my.cnf userstat=1 causes crash on install
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
# We're on CentOS 6.2 x86_64
%> uname -a
Linux host.domain 2.6.32-
%> cat /etc/*release
CentOS release 6.2 (Final)
CentOS release 6.2 (Final)
CentOS release 6.2 (Final)
%> free -g
total used free shared buffers cached
Mem: 31 0 30 0 0 0
-/+ buffers/cache: 0 30
Swap: 1 0 1
# Populate our my.cnf
%> cat > /etc/my.cnf << EOF
[mysqld]
innodb_
innodb_
userstat = 1
EOF
# Here is what we install
%> mkdir rpms
%> cd rpms
%> wget http://
%> wget http://
%> wget http://
%> wget http://
%> wget http://
%> rpm -ivh *.rpm
warning: Percona-
Preparing... #######
1:Percona-
2:Percona-
3:percona-
4:Percona-
120623 15:41:54 [Note] Flashcache bypass: disabled
120623 15:41:54 [Note] Flashcache setup error is : ioctl failed
15:41:54 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
key_buffer_
read_buffer_
max_used_
max_threads=151
thread_count=1
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x1ab0bb0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f9584181c18 thread_stack 0x40000
/usr/sbin/
/usr/sbin/
/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f95780009c0): is an invalid pointer
Connection ID (thread ID): 1
Status: NOT_KILLED
The manual page at http://
information that should help you find out what is causing the crash.
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/sbin/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
5:Percona-
===== However, if we do the following, we can get this installed without issue:
%> yum remove Percona-
%> cat > /etc/my.cnf << EOF
[mysqld]
innodb_
innodb_
userstat = 0
EOF
%> rpm -ivh *.rpm
warning: Percona-
Preparing... #######
1:Percona-
2:Percona-
3:percona-
4:Percona-
120623 15:47:33 [Note] Flashcache bypass: disabled
120623 15:47:33 [Note] Flashcache setup error is : ioctl failed
120623 15:47:33 [Note] Flashcache bypass: disabled
120623 15:47:33 [Note] Flashcache setup error is : ioctl failed
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h host.domain password 'new-password'
Alternatively you can run:
/usr/bin/
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
Percona recommends that all production deployments be protected with a support
contract (http://
be eligible for hot fixes, and boost your team's productivity.
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://
5:Percona-