Percona Server moved to https://jira.percona.com/projects/PS

Bug #1435606
Comment #4

Comment 4 for bug 1435606

Revision history for this message

monty solomon (monty+launchpad) wrote on 2015-03-23: Re: Installation of audit_log plugin crashes mysql server

Another example

2015-03-23 22:37:17 5857 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
2015-03-23 22:37:17 5857 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'bin.001636' at position 387019559
2015-03-23 22:37:17 5857 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2015-03-23 22:37:17 5857 [ERROR] Slave I/O: error reconnecting to master 'SUSR_Repl@bullis:3306' - retry-time: 15 retries: 1, Error_code: 2003
2015-03-23 22:37:32 5857 [Note] Slave: connected to master 'SUSR_Repl@bullis:3306',replication resumed in log 'bin.001636' at position 387019559
2015-03-23T22:43:55 audit_log: Cannot open file /opt/m. Error: : Permission denied
2015-03-23 22:43:55 5857 [ERROR] Plugin 'audit_log' init function returned error.
2015-03-23 22:43:55 5857 [ERROR] Plugin 'audit_log' registration as a AUDIT failed.
2015-03-23 22:43:55 5857 [Note] Shutting down plugin 'audit_log'
22:43:55 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.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/

key_buffer_size=67108864
read_buffer_size=1048576
max_used_connections=310
max_threads=702
thread_count=212
connection_count=210
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 974430 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x2a0bdd60
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 = 7fa73908ad40 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x8c13ac]
/usr/sbin/mysqld(handle_fatal_signal+0x461)[0x651e41]
/lib64/libpthread.so.0(+0xf710)[0x7fad8f194710]
/usr/lib64/mysql/plugin/audit_log.so(+0x4a28)[0x7fa72f59aa28]
/usr/sbin/mysqld(_Z21finalize_audit_pluginP13st_plugin_int+0x1f)[0x6812bf]
/usr/sbin/mysqld[0x6e0097]
/usr/sbin/mysqld(_Z20mysql_install_pluginP3THDPK19st_mysql_lex_stringS3_+0x5ae)[0x6e12ce]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3d9d)[0x6d41ad]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x5c8)[0x6d7478]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xfb7)[0x6d8b97]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x162)[0x6a67a2]
/usr/sbin/mysqld(handle_one_connection+0x40)[0x6a6890]
/usr/sbin/mysqld(pfs_spawn_thread+0x143)[0xacd003]
/lib64/libpthread.so.0(+0x79d1)[0x7fad8f18c9d1]
/lib64/libc.so.6(clone+0x6d)[0x7fad8d8abb6d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fa6a7e1f120): is an invalid pointer
Connection ID (thread ID): 4333854
Status: NOT_KILLED

mysql Ver 14.14 Distrib 5.6.22-71.0, for Linux (x86_64) using EditLine wrapper
Server version: 5.6.22-71.0-log Percona Server (GPL), Release 71.0, Revision 726
Linux wanosha 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
CentOS release 6.5 (Final)

Another example

2015-03-23 22:37:17 5857 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
2015-03-23 22:37:17 5857 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'bin.001636' at position 387019559
2015-03-23 22:37:17 5857 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2015-03-23 22:37:17 5857 [ERROR] Slave I/O: error reconnecting to master 'SUSR_Repl@bullis:3306' - retry-time: 15  retries: 1, Error_code: 2003
2015-03-23 22:37:32 5857 [Note] Slave: connected to master 'SUSR_Repl@bullis:3306',replication resumed in log 'bin.001636' at position 387019559
2015-03-23T22:43:55 audit_log: Cannot open file /opt/m. Error: : Permission denied
2015-03-23 22:43:55 5857 [ERROR] Plugin 'audit_log' init function returned error.
2015-03-23 22:43:55 5857 [ERROR] Plugin 'audit_log' registration as a AUDIT failed.
2015-03-23 22:43:55 5857 [Note] Shutting down plugin 'audit_log'
22:43:55 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.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/

key_buffer_size=67108864
read_buffer_size=1048576
max_used_connections=310
max_threads=702
thread_count=212
connection_count=210
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 974430 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fa6a7e1f120): is an invalid pointer
Connection ID (thread ID): 4333854
Status: NOT_KILLED

0000000   2   0   1   5   -   0   3   -   2   3   T   2   2   :   4   3
          12338   13617   12333   11571   13106   12884   14898   13108
0000020   :   5   5       a   u   d   i   t   _   l   o   g   :       C
          13626    8245   30049   26980   24436   28524   14951   17184
0000040   a   n   n   o   t       o   p   e   n       f   i   l   e    
          28257   28526    8308   28783   28261   26144   27753    8293
0000060   /   o   p   t   /   m   y  \b 005   .       E   r   r   o   r
          28463   29808   27951    2169   11781   17696   29298   29295
0000100   :       :       P   e   r   m   i   s   s   i   o   n       d
           8250    8250   25936   28018   29545   26995   28271   25632
0000120   e   n   i   e   d  \n   2   0   1   5   -   0   3   -   2   3

mysql  Ver 14.14 Distrib 5.6.22-71.0, for Linux (x86_64) using  EditLine wrapper
Server version:		5.6.22-71.0-log Percona Server (GPL), Release 71.0, Revision 726
Linux wanosha 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
CentOS release 6.5 (Final)