UTC - mysqld got signal 6

[青胜]

2016-08-22 18:05:59 7f0f8e548700 InnoDB: Assertion failure in thread 139704789141248 in file sync0sync.cc line 377
InnoDB: Failing assertion: mutex_get_lock_word(mutex) == 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
10:05:59 UTC - mysqld got signal 6 ;
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=131072
max_used_connections=854
max_threads=50002
thread_count=277
connection_count=277
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20003428 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x8a16aa00
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 = 7f0f8e547d40 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x8cc59c]
/usr/sbin/mysqld(handle_fatal_signal+0x461)[0x654f11]
/lib64/libpthread.so.0[0x3d2200f7e0]
/lib64/libc.so.6(gsignal+0x35)[0x3d21c32625]
/lib64/libc.so.6(abort+0x175)[0x3d21c33e05]
/usr/sbin/mysqld[0x568957]
/usr/sbin/mysqld[0x9b59ce]
/usr/sbin/mysqld[0x9caace]
/usr/sbin/mysqld[0x9ce1b2]
/usr/sbin/mysqld[0x9ce47b]
/usr/sbin/mysqld[0x8dcab9]
/usr/sbin/mysqld[0x596371]
/usr/sbin/mysqld(_Z24plugin_foreach_with_maskP3THDPFcS0_P13st_plugin_intPvEijS3_+0x1e5)[0x6e3c85]
/usr/sbin/mysqld(_ZN3THD17release_resourcesEv+0x172)[0x6a6c02]
/usr/sbin/mysqld(_Z29one_thread_per_connection_endP3THDb+0x1c)[0x58b39c]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xe6)[0x6aa6f6]
/usr/sbin/mysqld(handle_one_connection+0x40)[0x6aa860]
/usr/sbin/mysqld(pfs_spawn_thread+0x143)[0xadc113]
/lib64/libpthread.so.0[0x3d22007aa1]
/lib64/libc.so.6(clone+0x6d)[0x3d21ce893d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 5383912
Status: KILL_CONNECTION

You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
160822 18:06:00 mysqld_safe Number of processes running now: 0
160822 18:06:00 mysqld_safe mysqld restarted
2016-08-22 18:06:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-22 18:06:03 144416 [Note] Plugin 'FEDERATED' is disabled.
2016-08-22 18:06:03 144416 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-22 18:06:03 144416 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-22 18:06:03 144416 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-22 18:06:03 144416 [Note] InnoDB: Memory barrier is not used
2016-08-22 18:06:03 144416 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-22 18:06:03 144416 [Note] InnoDB: Using Linux native AIO
2016-08-22 18:06:03 144416 [Note] InnoDB: Using CPU crc32 instructions
2016-08-22 18:06:03 144416 [Note] InnoDB: Initializing buffer pool, size = 80.0G
2016-08-22 18:06:06 144416 [Note] InnoDB: Completed initialization of buffer pool
2016-08-22 18:06:07 144416 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-22 18:06:07 144416 [Note] InnoDB: Log scan progressed past the checkpoint lsn 202220831352
2016-08-22 18:06:07 144416 [Note] InnoDB: Database was not shutdown normally!
2016-08-22 18:06:07 144416 [Note] InnoDB: Starting crash recovery.
2016-08-22 18:06:07 144416 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-08-22 18:06:08 144416 [Note] InnoDB: Restoring possible half-written data pages
2016-08-22 18:06:08 144416 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 202220865928
InnoDB: 39 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 73 row operations to undo
InnoDB: Trx id counter is 413420032
2016-08-22 18:06:09 144416 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 967850935, file name mysql8-bin.000173
2016-08-22 18:06:10 144416 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419561, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Waiting for purge to start
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419561 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419556, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419556 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419552, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419552 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419520, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419520 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419514, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419514 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419385, 3 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419385 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419350, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419350 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419346, 1 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419346 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419344, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419344 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419343, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419343 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419165, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419165 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419150, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419150 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413419149, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413419149 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418849, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418849 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418817, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418817 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418811, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418811 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418777, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418777 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418753, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418753 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418242, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418242 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418228, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418228 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418199, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418199 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418198, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418198 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418190, 1 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418190 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418187, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418187 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418179, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418179 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418126, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418126 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413418096, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413418096 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417845, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417845 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417843, 1 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417843 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417825, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417825 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417824, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417824 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417823, 1 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417823 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417785, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417785 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417713, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417713 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413417709, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413417709 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413416936, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413416936 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413416822, 2 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413416822 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413415316, 1 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413415316 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rolling back trx with id 413415282, 1 rows to undo
2016-08-22 18:06:10 144416 [Note] InnoDB: Rollback of trx with id 413415282 completed
2016-08-22 18:06:10 7f2d4379a700 InnoDB: Rollback of non-prepared transactions completed
2016-08-22 18:06:10 144416 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 202220865928
2016-08-22 18:06:10 7f2d91096700 InnoDB: Loading buffer pool(s) from /opt/mysql/data/ib_buffer_pool
2016-08-22 18:06:10 144416 [Note] Recovering after a crash using mysql8-bin
2016-08-22 18:06:10 7f2d91096700 InnoDB: Buffer pool(s) load completed at 160822 18:06:10
2016-08-22 18:06:14 144416 [Note] Starting crash recovery...
2016-08-22 18:06:14 144416 [Note] Crash recovery finished.
2016-08-22 18:06:14 144416 [Note] RSA private key file not found: /opt/mysql/data//private_key.pem. Some authentication plugins will not work.
2016-08-22 18:06:14 144416 [Note] RSA public key file not found: /opt/mysql/data//public_key.pem. Some authentication plugins will not work.
2016-08-22 18:06:14 144416 [Note] Server hostname (bind-address): '*'; port: 3331
2016-08-22 18:06:14 144416 [Note] IPv6 is available.
2016-08-22 18:06:14 144416 [Note] - '::' resolves to '::';
2016-08-22 18:06:14 144416 [Note] Server socket created on IP: '::'.
2016-08-22 18:06:14 144416 [Warning] 'user' entry 'root@mysql8' ignored in --skip-name-resolve mode.
2016-08-22 18:06:14 144416 [Warning] 'user' entry '@mysql8' ignored in --skip-name-resolve mode.
2016-08-22 18:06:14 144416 [Warning] 'proxies_priv' entry '@ root@mysql8' ignored in --skip-name-resolve mode.
2016-08-22 18:06:14 144416 [Note] Event Scheduler: Loaded 0 events
2016-08-22 18:06:14 144416 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.23-72.1-log' socket: '/opt/mysql/mysql.sock' port: 3331 Percona Server (GPL), Release 72.1, Revision 0503478
2016-08-22 19:05:58 7f2d88c81700 InnoDB: Assertion failure in thread 139833545070336 in file sync0sync.cc line 377
InnoDB: Failing assertion: mutex_get_lock_word(mutex) == 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
11:05:58 UTC - mysqld got signal 6 ;
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=131072
max_used_connections=488
max_threads=50002
thread_count=410
connection_count=410
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20003428 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x8a48e890
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 = 7f2d88c80d40 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x8cc59c]
/usr/sbin/mysqld(handle_fatal_signal+0x461)[0x654f11]
/lib64/libpthread.so.0[0x3d2200f7e0]
/lib64/libc.so.6(gsignal+0x35)[0x3d21c32625]
/lib64/libc.so.6(abort+0x175)[0x3d21c33e05]
/usr/sbin/mysqld[0x568957]
/usr/sbin/mysqld[0x9b59ce]
/usr/sbin/mysqld[0x9caace]
/usr/sbin/mysqld[0x9ce1b2]
/usr/sbin/mysqld[0x9ce47b]
/usr/sbin/mysqld[0x8dcab9]
/usr/sbin/mysqld[0x596371]
/usr/sbin/mysqld(_Z24plugin_foreach_with_maskP3THDPFcS0_P13st_plugin_intPvEijS3_+0x1e5)[0x6e3c85]
/usr/sbin/mysqld(_ZN3THD17release_resourcesEv+0x172)[0x6a6c02]
/usr/sbin/mysqld(_Z29one_thread_per_connection_endP3THDb+0x1c)[0x58b39c]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xe6)[0x6aa6f6]
/usr/sbin/mysqld(handle_one_connection+0x40)[0x6aa860]
/usr/sbin/mysqld(pfs_spawn_thread+0x143)[0xadc113]
/lib64/libpthread.so.0[0x3d22007aa1]
/lib64/libc.so.6(clone+0x6d)[0x3d21ce893d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 9730
Status: KILL_CONNECTION

You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
160822 19:05:59 mysqld_safe Number of processes running now: 0
160822 19:05:59 mysqld_safe mysqld restarted
2016-08-22 19:06:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-22 19:06:02 188969 [Note] Plugin 'FEDERATED' is disabled.
2016-08-22 19:06:02 188969 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-22 19:06:02 188969 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-22 19:06:02 188969 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-22 19:06:02 188969 [Note] InnoDB: Memory barrier is not used
2016-08-22 19:06:02 188969 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-22 19:06:02 188969 [Note] InnoDB: Using Linux native AIO
2016-08-22 19:06:02 188969 [Note] InnoDB: Using CPU crc32 instructions
2016-08-22 19:06:02 188969 [Note] InnoDB: Initializing buffer pool, size = 80.0G
2016-08-22 19:06:05 188969 [Note] InnoDB: Completed initialization of buffer pool
2016-08-22 19:06:06 188969 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-22 19:06:06 188969 [Note] InnoDB: Log scan progressed past the checkpoint lsn 202275531563
2016-08-22 19:06:06 188969 [Note] InnoDB: Database was not shutdown normally!
2016-08-22 19:06:06 188969 [Note] InnoDB: Starting crash recovery.
2016-08-22 19:06:06 188969 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-08-22 19:06:06 188969 [Note] InnoDB: Restoring possible half-written data pages
2016-08-22 19:06:06 188969 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 202275708449
InnoDB: 53 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 85 row operations to undo
InnoDB: Trx id counter is 413689344
2016-08-22 19:06:07 188969 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 71663127, file name mysql8-bin.000174
2016-08-22 19:06:09 188969 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688811, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Waiting for purge to start
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688811 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688769, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688769 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688745, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688745 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688675, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688675 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688593, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688593 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688592, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688592 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688585, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688585 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688545, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688545 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688441, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688441 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688395, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688395 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688349, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688349 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688343, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688343 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688328, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688328 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413688321, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413688321 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687919, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687919 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687884, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687884 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687862, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687862 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687563, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687563 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687561, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687561 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687538, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687538 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687536, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687536 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687524, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687524 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687519, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687519 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687517, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687517 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687515, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687515 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687514, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687514 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687513, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687513 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687512, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687512 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413687509, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413687509 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686754, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686754 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686749, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686749 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686732, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686732 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686724, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686724 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686723, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686723 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686719, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686719 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686714, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686714 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413686705, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413686705 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685484, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685484 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685482, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685482 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685471, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685471 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685460, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685460 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685448, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685448 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685425, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685425 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685421, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685421 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685134, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685134 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685124, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685124 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685107, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685107 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685089, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685089 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413685067, 2 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413685067 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413684915, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413684915 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413684594, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413684594 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413684546, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413684546 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rolling back trx with id 413684486, 1 rows to undo
2016-08-22 19:06:09 188969 [Note] InnoDB: Rollback of trx with id 413684486 completed
2016-08-22 19:06:09 7f3862c62700 InnoDB: Rollback of non-prepared transactions completed
2016-08-22 19:06:09 188969 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 202275708449
2016-08-22 19:06:09 7f38b055e700 InnoDB: Loading buffer pool(s) from /opt/mysql/data/ib_buffer_pool
2016-08-22 19:06:09 188969 [Note] Recovering after a crash using mysql8-bin
2016-08-22 19:06:09 7f38b055e700 InnoDB: Buffer pool(s) load completed at 160822 19:06:09
2016-08-22 19:06:09 188969 [Note] Starting crash recovery...
2016-08-22 19:06:09 188969 [Note] Crash recovery finished.
2016-08-22 19:06:09 188969 [Note] RSA private key file not found: /opt/mysql/data//private_key.pem. Some authentication plugins will not work.
2016-08-22 19:06:09 188969 [Note] RSA public key file not found: /opt/mysql/data//public_key.pem. Some authentication plugins will not work.
2016-08-22 19:06:09 188969 [Note] Server hostname (bind-address): '*'; port: 3331
2016-08-22 19:06:09 188969 [Note] IPv6 is available.
2016-08-22 19:06:09 188969 [Note] - '::' resolves to '::';
2016-08-22 19:06:09 188969 [Note] Server socket created on IP: '::'.
2016-08-22 19:06:09 188969 [Warning] 'user' entry 'root@mysql8' ignored in --skip-name-resolve mode.
2016-08-22 19:06:09 188969 [Warning] 'user' entry '@mysql8' ignored in --skip-name-resolve mode.
2016-08-22 19:06:09 188969 [Warning] 'proxies_priv' entry '@ root@mysql8' ignored in --skip-name-resolve mode.
2016-08-22 19:06:09 188969 [Note] Event Scheduler: Loaded 0 events
2016-08-22 19:06:09 188969 [Note] /usr/sbin/mysqld: ready for connections.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3521