Comment 4 for bug 1483956

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

So yes, with enable super_read_only with read_only simultaneously, mysqld getting crashed.

root@desktop:~# cat /etc/mysql/my.cnf | grep read_only
super_read_only=1
read_only=1
root@desktop:~#

root@desktop:~# /etc/init.d/mysql restart
 * Stopping MySQL (Percona Server) mysqld [ OK ]
 * Starting MySQL (Percona Server) database server mysqld [fail]
root@desktop:~#

root@desktop:~# tail -100 /var/log/mysql/error.log
...
2015-09-08 10:39:52 1598 [Note] /usr/sbin/mysqld: Shutdown complete

150908 10:39:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150908 10:39:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
2015-09-08 10:39:52 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
...
2015-09-08 10:39:52 5875 [Note] Server hostname (bind-address): '*'; port: 3306
2015-09-08 10:39:52 5875 [Note] IPv6 is available.
2015-09-08 10:39:52 5875 [Note] - '::' resolves to '::';
2015-09-08 10:39:52 5875 [Note] Server socket created on IP: '::'.
2015-09-08 10:39:52 5875 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2015-09-08 10:39:52 5875 [ERROR] Event Scheduler: Failed to open table mysql.event
2015-09-08 10:39:52 5875 [ERROR] Event Scheduler: Error while loading from disk.
2015-09-08 10:39:52 5875 [Note] Event Scheduler: Purging the queue. 0 events
2015-09-08 10:39:52 5875 [ERROR] Aborting

2015-09-08 10:39:52 5875 [Note] Binlog end
2015-09-08 10:39:52 5875 [Note] Shutting down plugin 'auth_pam_compat'
...
2015-09-08 10:39:55 5875 [Note] Shutting down plugin 'binlog'
2015-09-08 10:39:55 5875 [Note] /usr/sbin/mysqld: Shutdown complete

Error in my_thread_global_end(): 1 threads didn't exit
150908 10:40:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
root@desktop:~#