[openxs@chief p5.6]$ bin/mysql -uroot test
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 95
[openxs@chief p5.6]$ 140523 12:38:27 mysqld_safe Number of processes running now: 0
140523 12:38:27 mysqld_safe mysqld restarted
[openxs@chief p5.6]$ tail -80 data/chief.err Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=1
max_threads=153
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 69168 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x28b1d50
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 = 7fa5e006be10 thread_stack 0x40000
/home/openxs/dbs/p5.6/bin/mysqld(my_print_stacktrace+0x35)[0x902035]
/home/openxs/dbs/p5.6/bin/mysqld(handle_fatal_signal+0x4c4)[0x66cd24]
/lib64/libpthread.so.0[0x3ffac0eeb0]
/home/openxs/dbs/p5.6/bin/mysqld[0x68f629]
/home/openxs/dbs/p5.6/bin/mysqld[0x68fc98]
/home/openxs/dbs/p5.6/bin/mysqld[0x69007e]
/home/openxs/dbs/p5.6/bin/mysqld[0x67d779]
/home/openxs/dbs/p5.6/bin/mysqld[0x67d944]
/home/openxs/dbs/p5.6/bin/mysqld(_Z16acl_authenticateP3THDj+0x1c0)[0x690430]
/home/openxs/dbs/p5.6/bin/mysqld[0x6bcb2a]
/home/openxs/dbs/p5.6/bin/mysqld(_Z16login_connectionP3THD+0x4d)[0x6be4bd]
/home/openxs/dbs/p5.6/bin/mysqld(_Z22thd_prepare_connectionP3THD+0x24)[0x6bec14]
/home/openxs/dbs/p5.6/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x135)[0x6bef15]
/home/openxs/dbs/p5.6/bin/mysqld(handle_one_connection+0x47)[0x6bf017]
/home/openxs/dbs/p5.6/bin/mysqld(pfs_spawn_thread+0x12a)[0x98fa0a]
/lib64/libpthread.so.0[0x3ffac06ccb]
/lib64/libc.so.6(clone+0x6d)[0x3ffa8e0c2d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 1
Status: NOT_KILLED
...
Confirmed with my own build from recent bzr sources suing commands like these:
1000 rm CMakeCache.txt INSTALL_ PREFIX= /home/openxs/ dbs/p5. 6 -DCMAKE_ BUILD_TYPE= RelWithDebInfo -DBUILD_ CONFIG= mysql_release -DFEATURE_ SET=community -DWITH_ EMBEDDED_ SERVER= OFF
1001 cmake . -DCMAKE_
1002 make
1003 make install && make clean
...
1015 cd dbs/p5.6
1016 ls
1017 ls data/
1018 rm -rf data/*
...
1026 scripts/ mysql_install_ db --no-defaults --server-id=256 --explicit_ defaults_ for_timestamp= 1 --log-bin --gtid-mode=ON --log-slave- updates= 1 --enforce- gtid-consistenc y=1 --autocommit=0 defaults_ for_timestamp= 1 --log-bin --gtid-mode=ON --log-slave- updates= 1 --enforce- gtid-consistenc y=1 --autocommit=0 &
1027 ls -lh data/
1028 bin/mysqld_safe --no-defaults --server-id=256 --explicit_
1029 tail data/chief.err
1030 bin/mysql -uroot test
1031 tail -80 data/chief.err
This is what we see in the error log:
[openxs@chief p5.6]$ bin/mysql -uroot test
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 95
[openxs@chief p5.6]$ 140523 12:38:27 mysqld_safe Number of processes running now: 0
140523 12:38:27 mysqld_safe mysqld restarted
[openxs@chief p5.6]$ tail -80 data/chief.err Please help us make Percona Server better by reporting any bugs.percona. com/
bugs at http://
key_buffer_ size=8388608 size=131072 connections= 1 size)*max_ threads = 69168 K bytes of memory
read_buffer_
max_used_
max_threads=153
thread_count=1
connection_count=1
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: 0x28b1d50 dbs/p5. 6/bin/mysqld( my_print_ stacktrace+ 0x35)[0x902035] dbs/p5. 6/bin/mysqld( handle_ fatal_signal+ 0x4c4)[ 0x66cd24] libpthread. so.0[0x3ffac0ee b0] dbs/p5. 6/bin/mysqld[ 0x68f629] dbs/p5. 6/bin/mysqld[ 0x68fc98] dbs/p5. 6/bin/mysqld[ 0x69007e] dbs/p5. 6/bin/mysqld[ 0x67d779] dbs/p5. 6/bin/mysqld[ 0x67d944] dbs/p5. 6/bin/mysqld( _Z16acl_ authenticateP3T HDj+0x1c0) [0x690430] dbs/p5. 6/bin/mysqld[ 0x6bcb2a] dbs/p5. 6/bin/mysqld( _Z16login_ connectionP3THD +0x4d)[ 0x6be4bd] dbs/p5. 6/bin/mysqld( _Z22thd_ prepare_ connectionP3THD +0x24)[ 0x6bec14] dbs/p5. 6/bin/mysqld( _Z24do_ handle_ one_connectionP 3THD+0x135) [0x6bef15] dbs/p5. 6/bin/mysqld( handle_ one_connection+ 0x47)[0x6bf017] dbs/p5. 6/bin/mysqld( pfs_spawn_ thread+ 0x12a)[ 0x98fa0a] libpthread. so.0[0x3ffac06c cb] libc.so. 6(clone+ 0x6d)[0x3ffa8e0 c2d]
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 = 7fa5e006be10 thread_stack 0x40000
/home/openxs/
/home/openxs/
/lib64/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/home/openxs/
/lib64/
/lib64/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 1
Status: NOT_KILLED
...