2017-09-11T03:37:22.747539Z 8418957 [Note] Slave I/O thread killed while reading event for channel '' 2017-09-11T03:37:22.747564Z 8418957 [Note] Slave I/O thread exiting for channel '', read up to log 'binlog.006936', position 45487700 2017-09-11T03:37:22.757221Z 8487317 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006936' at position 45487700 2017-09-11T03:37:22.757286Z 8487317 [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. 2017-09-11T03:37:22.758690Z 8487317 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006936' at position 45487700 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 16:06:36 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=23 max_threads=3000 thread_count=25 connection_count=23 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f3cfc92bb10 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 = 7f5b9007ae70 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x3d) [0x129c2dd] /usr/sbin/mysqld(handle_fatal_signal+0x4a1) [0xbe09f1] /lib64/libpthread.so.0(+0xf370) [0x7f5c6e384370] /lib64/libc.so.6(gsignal+0x37) [0x7f5c6cd771d7] /lib64/libc.so.6(abort+0x148) [0x7f5c6cd788c8] /lib64/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x165) [0x7f5c6d67b9d5] /lib64/libstdc++.so.6(+0x5e946) [0x7f5c6d679946] /lib64/libstdc++.so.6(+0x5e973) [0x7f5c6d679973] /lib64/libstdc++.so.6(+0x5eb93) [0x7f5c6d679b93] /lib64/libstdc++.so.6(operator new(unsigned long)+0x7d) [0x7f5c6d67a12d] /usr/sbin/mysqld(void std::vector >::_M_emplace_back_aux(row_data_lock const&)+0x46) [0x16821e6] /usr/sbin/mysqld(PFS_data_lock_container::add_lock_row(char const*, unsigned long, char const*, unsigned long, unsigned long long, unsigned long long, unsigned long long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, void const*, char const*, char const*, char const*, char const*)+0x29d) [0x1681ccd] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx(PSI_server_data_lock_container*, bool, trx_t const*, bool, int, unsigned long, unsigned int, unsigned int, unsigned long)+0x485) [0x13149a5] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx_list(PSI_server_data_lock_container*, bool, bool, ut_list_base trx_t::*>*)+0x15f) [0x1314d5f] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan(PSI_server_data_lock_container*, bool)+0x26f) [0x131502f] /usr/sbin/mysqld(table_data_locks::rnd_next()+0x63) [0x1654823] /usr/sbin/mysqld(ha_perfschema::rnd_next(unsigned char*)+0x62) [0x15f9842] /usr/sbin/mysqld(handler::ha_rnd_next(unsigned char*)+0x1dc) [0xcad43c] /usr/sbin/mysqld(rr_sequential(READ_RECORD*)+0x20) [0x91e770] /usr/sbin/mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x12f) [0x96970f] /usr/sbin/mysqld(JOIN::exec()+0x27e) [0x96863e] /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x104) [0x9d6e24] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x25a) [0x9d5c2a] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x491) [0x993931] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3a5) [0x999655] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x99b) [0x99a06b] /usr/sbin/mysqld(do_command(THD*)+0x1a8) [0x99baf8] /usr/sbin/mysqld() [0xbd75f0] /usr/sbin/mysqld() [0x15fd454] /lib64/libpthread.so.0(+0x7dc5) [0x7f5c6e37cdc5] /lib64/libc.so.6(clone+0x6d) [0x7f5c6ce3973d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f3cfc09bb20): SELECT * FROM performance_schema.data_locks Connection ID (thread ID): 8522792 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2017-09-11T16:06:53.918700Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-11T16:06:53.922224Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-09-11T16:06:53.922251Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2017-09-11T16:06:53.923889Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.1-dmr-log) starting as process 21170 ... 2017-09-11T16:06:54.013678Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-11T16:06:54.014173Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-11T16:06:54.021339Z 1 [Note] InnoDB: PUNCH HOLE support available 2017-09-11T16:06:54.021367Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-11T16:06:54.021371Z 1 [Note] InnoDB: Uses event mutexes 2017-09-11T16:06:54.021375Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-11T16:06:54.021378Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-09-11T16:06:54.023160Z 1 [Note] InnoDB: Number of pools: 1 2017-09-11T16:06:54.023779Z 1 [Note] InnoDB: Using CPU crc32 instructions 2017-09-11T16:06:54.027706Z 1 [Note] InnoDB: Initializing buffer pool, total size = 99.875G, instances = 47, chunk size = 128M 2017-09-11T16:06:54.027797Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE 2017-09-11T16:07:01.112149Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT 2017-09-11T16:07:01.112191Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-09-11T16:07:02.315978Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-11T16:07:03.216801Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 39339717042041 2017-09-11T16:07:03.353392Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339722284544 2017-09-11T16:07:03.494328Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339727527424 2017-09-11T16:07:03.632428Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339732770304 2017-09-11T16:07:03.769557Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339738013184 2017-09-11T16:07:03.908635Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339743256064 2017-09-11T16:07:04.056132Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339748498944 2017-09-11T16:07:04.195191Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339753741824 2017-09-11T16:07:04.335770Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339758984704 2017-09-11T16:07:04.478557Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339764227584 2017-09-11T16:07:04.615965Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339769470464 2017-09-11T16:07:04.756432Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339774713344 2017-09-11T16:07:04.902045Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339779956224 2017-09-11T16:07:05.049226Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339785199104 2017-09-11T16:07:05.185473Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339790441984 2017-09-11T16:07:05.322183Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339795684864 2017-09-11T16:07:05.459184Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339800927744 2017-09-11T16:07:05.599061Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339806170624 2017-09-11T16:07:05.737904Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339811413504 2017-09-11T16:07:05.876453Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339816656384 2017-09-11T16:07:06.013559Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339821899264 2017-09-11T16:07:06.149247Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339827142144 2017-09-11T16:07:06.285309Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339832385024 2017-09-11T16:07:06.421863Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339837627904 2017-09-11T16:07:06.561191Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339842870784 2017-09-11T16:07:06.705118Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339848113664 2017-09-11T16:07:06.842013Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339853356544 2017-09-11T16:07:06.981935Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339858599424 2017-09-11T16:07:07.117986Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339863842304 2017-09-11T16:07:07.253938Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339869085184 2017-09-11T16:07:07.390582Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339874328064 2017-09-11T16:07:07.530011Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339879570944 2017-09-11T16:07:07.666359Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339884813824 2017-09-11T16:07:07.802701Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339890056704 2017-09-11T16:07:07.939056Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339895299584 2017-09-11T16:07:08.078559Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339900542464 2017-09-11T16:07:08.213721Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339905785344 2017-09-11T16:07:08.348739Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339911028224 2017-09-11T16:07:08.487200Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339916271104 2017-09-11T16:07:08.623650Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339921513984 2017-09-11T16:07:08.759715Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339926756864 2017-09-11T16:07:08.896673Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339931999744 2017-09-11T16:07:09.035428Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339937242624 2017-09-11T16:07:09.170335Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339942485504 2017-09-11T16:07:09.307018Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339947728384 2017-09-11T16:07:09.442150Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339952971264 2017-09-11T16:07:09.583398Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339958214144 2017-09-11T16:07:09.719451Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339963457024 2017-09-11T16:07:09.855344Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339968699904 2017-09-11T16:07:09.998047Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339973942784 2017-09-11T16:07:10.134865Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339979185664 2017-09-11T16:07:10.271241Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339984428544 2017-09-11T16:07:10.407584Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339989671424 2017-09-11T16:07:10.548655Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339994914304 2017-09-11T16:07:10.683210Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340000157184 2017-09-11T16:07:10.819580Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340005400064 2017-09-11T16:07:10.959270Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340010642944 2017-09-11T16:07:11.095335Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340015885824 2017-09-11T16:07:11.231422Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340021128704 2017-09-11T16:07:11.372747Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340026371584 2017-09-11T16:07:11.518592Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340031614464 2017-09-11T16:07:11.655679Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340036857344 2017-09-11T16:07:11.795029Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340042100224 2017-09-11T16:07:11.930879Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340047343104 2017-09-11T16:07:12.068873Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340052585984 2017-09-11T16:07:12.204903Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340057828864 2017-09-11T16:07:12.324333Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340062175590 2017-09-11T16:07:13.219399Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339717893632 2017-09-11T16:07:13.371148Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339723136512 2017-09-11T16:07:13.533402Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339728379392 2017-09-11T16:07:13.686379Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339733622272 2017-09-11T16:07:13.838150Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339738865152 2017-09-11T16:07:13.991104Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339744108032 2017-09-11T16:07:14.150010Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339749350912 2017-09-11T16:07:14.304764Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339754593792 2017-09-11T16:07:14.461989Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339759836672 2017-09-11T16:07:14.621918Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339765079552 2017-09-11T16:07:14.774220Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339770322432 2017-09-11T16:07:14.927864Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339775565312 2017-09-11T16:07:15.081414Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339780808192 2017-09-11T16:07:15.234697Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339786051072 2017-09-11T16:07:15.388186Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339791293952 2017-09-11T16:07:15.542699Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339796536832 2017-09-11T16:07:15.697409Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339801779712 2017-09-11T16:07:15.851942Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339807022592 2017-09-11T16:07:16.008737Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339812265472 2017-09-11T16:07:16.166170Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339817508352 2017-09-11T16:07:16.330987Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339822751232 2017-09-11T16:07:16.483570Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339827994112 2017-09-11T16:07:16.637491Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339833236992 2017-09-11T16:07:16.794623Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339838479872 2017-09-11T16:07:16.948722Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339843722752 2017-09-11T16:07:17.103131Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339848965632 2017-09-11T16:07:17.257983Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339854208512 2017-09-11T16:07:17.412177Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339859451392 2017-09-11T16:07:17.563786Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339864694272 2017-09-11T16:07:17.716660Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339869937152 2017-09-11T16:07:17.871477Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339875180032 2017-09-11T16:07:18.024377Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339880422912 2017-09-11T16:07:18.178484Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339885665792 2017-09-11T16:07:18.334235Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339890908672 2017-09-11T16:07:18.487654Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339896151552 2017-09-11T16:07:18.640069Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339901394432 2017-09-11T16:07:18.792701Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339906637312 2017-09-11T16:07:18.947963Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339911880192 2017-09-11T16:07:19.104116Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339917123072 2017-09-11T16:07:19.258660Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339922365952 2017-09-11T16:07:19.415044Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339927608832 2017-09-11T16:07:19.571700Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339932851712 2017-09-11T16:07:19.723555Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339938094592 2017-09-11T16:07:19.875578Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339943337472 2017-09-11T16:07:20.031648Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339948580352 2017-09-11T16:07:20.185990Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339953823232 2017-09-11T16:07:20.339219Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339959066112 2017-09-11T16:07:20.492904Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339964308992 2017-09-11T16:07:20.650458Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339969551872 2017-09-11T16:07:20.815192Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339974794752 2017-09-11T16:07:20.968979Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339980037632 2017-09-11T16:07:21.121719Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339985280512 2017-09-11T16:07:21.275545Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339990523392 2017-09-11T16:07:21.427327Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39339995766272 2017-09-11T16:07:21.577721Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340001009152 2017-09-11T16:07:21.733127Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340006252032 2017-09-11T16:07:21.887500Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340011494912 2017-09-11T16:07:22.041284Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340016737792 2017-09-11T16:07:22.195316Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340021980672 2017-09-11T16:07:22.373307Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340027223552 2017-09-11T16:07:22.528221Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340032466432 2017-09-11T16:07:22.681707Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340037709312 2017-09-11T16:07:22.837724Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340042952192 2017-09-11T16:07:22.989708Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340048195072 2017-09-11T16:07:23.141716Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340053437952 2017-09-11T16:07:23.294287Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340058680832 2017-09-11T16:07:23.420347Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39340062175590 2017-09-11T16:07:23.420885Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-09-11T16:07:23.420892Z 1 [Note] InnoDB: Starting crash recovery. 2017-09-11T16:07:23.666639Z 1 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 2017-09-11T16:07:32.867767Z 1 [Note] InnoDB: Apply batch completed 2017-09-11T16:07:32.868076Z 1 [Note] InnoDB: Last MySQL binlog file position 0 818871476, file name ../log/binlog.000465 2017-09-11T16:07:33.984690Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 126 row operations to undo 2017-09-11T16:07:33.984736Z 1 [Note] InnoDB: Trx id counter is 60513327104 2017-09-11T16:07:33.984904Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-11T16:07:33.984933Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-11T16:07:33.984999Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-11T16:07:33.991807Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-11T16:07:33.992627Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-09-11T16:07:34.017290Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 39340062175590 2017-09-11T16:07:34.017364Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31702ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2017-09-11T16:07:34.211993Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-09-11T16:07:34.212032Z 0 [Note] InnoDB: Rolling back trx with id 60513326322, 126 rows to undo 2017-09-11T16:07:34.212163Z 1 [Note] InnoDB: Waiting for purge to start 2017-09-11T16:07:34.227752Z 0 [Note] InnoDB: Rollback of trx with id 60513326322 completed 2017-09-11T16:07:34.227783Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-09-11T16:07:34.262358Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/res/data/ib_buffer_pool 2017-09-11T16:07:34.357330Z 1 [Warning] Skip re-populating collations and character sets tables in read-only mode. 2017-09-11T16:07:34.357374Z 1 [Note] Found data dictionary with version 1 2017-09-11T16:07:34.367161Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-09-11T16:07:34.367641Z 0 [Note] Server hostname (bind-address): '::'; port: 3306 2017-09-11T16:07:34.367669Z 0 [Note] - '::' resolves to '::'; 2017-09-11T16:07:34.367711Z 0 [Note] Server socket created on IP: '::'. 2017-09-11T16:07:34.419576Z 0 [Warning] Recovery from master pos 92390006 and file binlog.006984 for channel ''. Previous relay log pos and relay log file had been set to 92390213, ../log/relaylog.001807 respectively. 2017-09-11T16:07:34.420666Z 2 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006984' at position 92390006 2017-09-11T16:07:34.420766Z 2 [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. 2017-09-11T16:07:34.421658Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.006984' at position 92390006, relay log '../log/relaylog.001811' position: 4 2017-09-11T16:07:34.422955Z 2 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006984' at position 92390006 2017-09-11T16:07:34.472480Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.1-dmr-log' socket: 'mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-09-11T16:14:50.917935Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15865ms. The settings might not be optimal. (flushed=1509 and evicted=0, during the time.) 2017-09-11T16:19:36.759471Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170911 18:19:36 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 16:34:45 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=62 max_threads=3000 thread_count=64 connection_count=62 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f4488015170 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 = 7f5dac13de70 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x3d) [0x129c2dd] /usr/sbin/mysqld(handle_fatal_signal+0x4a1) [0xbe09f1] /lib64/libpthread.so.0(+0xf370) [0x7f6103a57370] /lib64/libc.so.6(gsignal+0x37) [0x7f610244a1d7] /lib64/libc.so.6(abort+0x148) [0x7f610244b8c8] /lib64/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x165) [0x7f6102d4e9d5] /lib64/libstdc++.so.6(+0x5e946) [0x7f6102d4c946] /lib64/libstdc++.so.6(+0x5e973) [0x7f6102d4c973] /lib64/libstdc++.so.6(+0x5eb93) [0x7f6102d4cb93] /lib64/libstdc++.so.6(operator new(unsigned long)+0x7d) [0x7f6102d4d12d] /usr/sbin/mysqld(void std::vector >::_M_emplace_back_aux(row_data_lock const&)+0x46) [0x16821e6] /usr/sbin/mysqld(PFS_data_lock_container::add_lock_row(char const*, unsigned long, char const*, unsigned long, unsigned long long, unsigned long long, unsigned long long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, void const*, char const*, char const*, char const*, char const*)+0x29d) [0x1681ccd] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx(PSI_server_data_lock_container*, bool, trx_t const*, bool, int, unsigned long, unsigned int, unsigned int, unsigned long)+0x485) [0x13149a5] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx_list(PSI_server_data_lock_container*, bool, bool, ut_list_base trx_t::*>*)+0x15f) [0x1314d5f] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan(PSI_server_data_lock_container*, bool)+0x26f) [0x131502f] /usr/sbin/mysqld(table_data_locks::rnd_next()+0x63) [0x1654823] /usr/sbin/mysqld(ha_perfschema::rnd_next(unsigned char*)+0x62) [0x15f9842] /usr/sbin/mysqld(handler::ha_rnd_next(unsigned char*)+0x1dc) [0xcad43c] /usr/sbin/mysqld(rr_sequential(READ_RECORD*)+0x20) [0x91e770] /usr/sbin/mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x12f) [0x96970f] /usr/sbin/mysqld(JOIN::exec()+0x27e) [0x96863e] /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x104) [0x9d6e24] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x25a) [0x9d5c2a] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x491) [0x993931] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3a5) [0x999655] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x99b) [0x99a06b] /usr/sbin/mysqld(do_command(THD*)+0x1a8) [0x99baf8] /usr/sbin/mysqld() [0xbd75f0] /usr/sbin/mysqld() [0x15fd454] /lib64/libpthread.so.0(+0x7dc5) [0x7f6103a4fdc5] /lib64/libc.so.6(clone+0x6d) [0x7f610250c76d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f448800d8a0): SELECT * FROM performance_schema.data_locks Connection ID (thread ID): 922 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2017-09-11T16:34:55.975573Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-11T16:34:55.975681Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-09-11T16:34:55.975684Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2017-09-11T16:34:55.977249Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.1-dmr-log) starting as process 47878 ... 2017-09-11T16:34:56.050900Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-11T16:34:56.051094Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-11T16:34:56.052073Z 1 [Note] InnoDB: PUNCH HOLE support available 2017-09-11T16:34:56.052121Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-11T16:34:56.052129Z 1 [Note] InnoDB: Uses event mutexes 2017-09-11T16:34:56.052137Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-11T16:34:56.052156Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-09-11T16:34:56.053773Z 1 [Note] InnoDB: Number of pools: 1 2017-09-11T16:34:56.053891Z 1 [Note] InnoDB: Using CPU crc32 instructions 2017-09-11T16:34:56.057512Z 1 [Note] InnoDB: Initializing buffer pool, total size = 99.875G, instances = 47, chunk size = 128M 2017-09-11T16:34:56.057531Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE 2017-09-11T16:35:03.130235Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT 2017-09-11T16:35:03.130276Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-09-11T16:35:04.325476Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-11T16:35:05.179039Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 39357440968668 2017-09-11T16:35:05.317733Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357446211072 2017-09-11T16:35:05.466284Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357451453952 2017-09-11T16:35:05.614653Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357456696832 2017-09-11T16:35:05.709924Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357460111267 2017-09-11T16:35:06.648084Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357442737664 2017-09-11T16:35:06.798427Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357447980544 2017-09-11T16:35:06.948804Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357453223424 2017-09-11T16:35:07.102404Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357458466304 2017-09-11T16:35:07.151711Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39357460111267 2017-09-11T16:35:07.151753Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-09-11T16:35:07.151757Z 1 [Note] InnoDB: Starting crash recovery. 2017-09-11T16:35:07.400977Z 1 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 2017-09-11T16:35:15.210009Z 1 [Note] InnoDB: Apply batch completed 2017-09-11T16:35:15.210561Z 1 [Note] InnoDB: Last MySQL binlog file position 0 818871476, file name ../log/binlog.000465 2017-09-11T16:35:15.590486Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 126 row operations to undo 2017-09-11T16:35:15.590537Z 1 [Note] InnoDB: Trx id counter is 60513328640 2017-09-11T16:35:15.590740Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-11T16:35:15.590760Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-11T16:35:15.590834Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-11T16:35:15.598212Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-11T16:35:15.599232Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-09-11T16:35:15.613802Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11288ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2017-09-11T16:35:15.614390Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 39357460111267 2017-09-11T16:35:15.746588Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-09-11T16:35:15.746665Z 0 [Note] InnoDB: Rolling back trx with id 60513327121, 126 rows to undo 2017-09-11T16:35:15.746739Z 1 [Note] InnoDB: Waiting for purge to start 2017-09-11T16:35:15.766272Z 0 [Note] InnoDB: Rollback of trx with id 60513327121 completed 2017-09-11T16:35:15.766289Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-09-11T16:35:15.797037Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/res/data/ib_buffer_pool 2017-09-11T16:35:15.883085Z 1 [Warning] Skip re-populating collations and character sets tables in read-only mode. 2017-09-11T16:35:15.883141Z 1 [Note] Found data dictionary with version 1 2017-09-11T16:35:15.889719Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-09-11T16:35:15.890452Z 0 [Note] Server hostname (bind-address): '::'; port: 3306 2017-09-11T16:35:15.890487Z 0 [Note] - '::' resolves to '::'; 2017-09-11T16:35:15.890551Z 0 [Note] Server socket created on IP: '::'. 2017-09-11T16:35:15.946347Z 0 [Warning] Recovery from master pos 92390006 and file binlog.006984 for channel ''. Previous relay log pos and relay log file had been set to 4, ../log/relaylog.001811 respectively. 2017-09-11T16:35:15.946954Z 2 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006984' at position 92390006 2017-09-11T16:35:15.947019Z 2 [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. 2017-09-11T16:35:15.947702Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.006984' at position 92390006, relay log '../log/relaylog.001821' position: 4 2017-09-11T16:35:15.948327Z 2 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006984' at position 92390006 2017-09-11T16:35:15.992177Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.1-dmr-log' socket: 'mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-09-11T16:47:29.268359Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170911 18:47:29 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 17:02:46 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=63 max_threads=3000 thread_count=65 connection_count=63 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f4570015260 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 = 7f5ef413de70 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x3d) [0x129c2dd] /usr/sbin/mysqld(handle_fatal_signal+0x4a1) [0xbe09f1] /lib64/libpthread.so.0(+0xf370) [0x7f61aaa27370] /lib64/libc.so.6(gsignal+0x37) [0x7f61a941a1d7] /lib64/libc.so.6(abort+0x148) [0x7f61a941b8c8] /lib64/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x165) [0x7f61a9d1e9d5] /lib64/libstdc++.so.6(+0x5e946) [0x7f61a9d1c946] /lib64/libstdc++.so.6(+0x5e973) [0x7f61a9d1c973] /lib64/libstdc++.so.6(+0x5eb93) [0x7f61a9d1cb93] /lib64/libstdc++.so.6(operator new(unsigned long)+0x7d) [0x7f61a9d1d12d] /usr/sbin/mysqld(void std::vector >::_M_emplace_back_aux(row_data_lock const&)+0x46) [0x16821e6] /usr/sbin/mysqld(PFS_data_lock_container::add_lock_row(char const*, unsigned long, char const*, unsigned long, unsigned long long, unsigned long long, unsigned long long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, void const*, char const*, char const*, char const*, char const*)+0x29d) [0x1681ccd] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx(PSI_server_data_lock_container*, bool, trx_t const*, bool, int, unsigned long, unsigned int, unsigned int, unsigned long)+0x485) [0x13149a5] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx_list(PSI_server_data_lock_container*, bool, bool, ut_list_base trx_t::*>*)+0x15f) [0x1314d5f] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan(PSI_server_data_lock_container*, bool)+0x26f) [0x131502f] /usr/sbin/mysqld(table_data_locks::rnd_next()+0x63) [0x1654823] /usr/sbin/mysqld(ha_perfschema::rnd_next(unsigned char*)+0x62) [0x15f9842] /usr/sbin/mysqld(handler::ha_rnd_next(unsigned char*)+0x1dc) [0xcad43c] /usr/sbin/mysqld(rr_sequential(READ_RECORD*)+0x20) [0x91e770] /usr/sbin/mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x12f) [0x96970f] /usr/sbin/mysqld(JOIN::exec()+0x27e) [0x96863e] /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x104) [0x9d6e24] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x25a) [0x9d5c2a] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x491) [0x993931] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3a5) [0x999655] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x99b) [0x99a06b] /usr/sbin/mysqld(do_command(THD*)+0x1a8) [0x99baf8] /usr/sbin/mysqld() [0xbd75f0] /usr/sbin/mysqld() [0x15fd454] /lib64/libpthread.so.0(+0x7dc5) [0x7f61aaa1fdc5] /lib64/libc.so.6(clone+0x6d) [0x7f61a94dc76d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f4570004530): SELECT * FROM performance_schema.data_locks Connection ID (thread ID): 949 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2017-09-11T17:02:56.238546Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-11T17:02:56.238696Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-09-11T17:02:56.238700Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2017-09-11T17:02:56.240370Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.1-dmr-log) starting as process 8689 ... 2017-09-11T17:02:56.314133Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-11T17:02:56.314335Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-11T17:02:56.315324Z 1 [Note] InnoDB: PUNCH HOLE support available 2017-09-11T17:02:56.315370Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-11T17:02:56.315379Z 1 [Note] InnoDB: Uses event mutexes 2017-09-11T17:02:56.315387Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-11T17:02:56.315395Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-09-11T17:02:56.317043Z 1 [Note] InnoDB: Number of pools: 1 2017-09-11T17:02:56.317169Z 1 [Note] InnoDB: Using CPU crc32 instructions 2017-09-11T17:02:56.321073Z 1 [Note] InnoDB: Initializing buffer pool, total size = 99.875G, instances = 47, chunk size = 128M 2017-09-11T17:02:56.321093Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE 2017-09-11T17:03:03.407358Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT 2017-09-11T17:03:03.407400Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-09-11T17:03:04.595233Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-11T17:03:05.469183Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 39374633451606 2017-09-11T17:03:05.469231Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39374633451615 2017-09-11T17:03:06.340422Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39374633451615 2017-09-11T17:03:06.340460Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-09-11T17:03:06.340465Z 1 [Note] InnoDB: Starting crash recovery. 2017-09-11T17:03:07.902583Z 1 [Note] InnoDB: Last MySQL binlog file position 0 818871476, file name ../log/binlog.000465 2017-09-11T17:03:08.276483Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 126 row operations to undo 2017-09-11T17:03:08.276519Z 1 [Note] InnoDB: Trx id counter is 60513330688 2017-09-11T17:03:08.276639Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-11T17:03:08.276650Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-11T17:03:08.276697Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-11T17:03:08.283453Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-11T17:03:08.284503Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-09-11T17:03:08.307204Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 39374633451615 2017-09-11T17:03:08.433651Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-09-11T17:03:08.433693Z 0 [Note] InnoDB: Rolling back trx with id 60513328661, 126 rows to undo 2017-09-11T17:03:08.433750Z 1 [Note] InnoDB: Waiting for purge to start 2017-09-11T17:03:08.449312Z 0 [Note] InnoDB: Rollback of trx with id 60513328661 completed 2017-09-11T17:03:08.449329Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-09-11T17:03:08.484048Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/res/data/ib_buffer_pool 2017-09-11T17:03:08.557371Z 1 [Warning] Skip re-populating collations and character sets tables in read-only mode. 2017-09-11T17:03:08.557414Z 1 [Note] Found data dictionary with version 1 2017-09-11T17:03:08.563407Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-09-11T17:03:08.563818Z 0 [Note] Server hostname (bind-address): '::'; port: 3306 2017-09-11T17:03:08.563845Z 0 [Note] - '::' resolves to '::'; 2017-09-11T17:03:08.563906Z 0 [Note] Server socket created on IP: '::'. 2017-09-11T17:03:08.614322Z 0 [Warning] Recovery from master pos 92390006 and file binlog.006984 for channel ''. Previous relay log pos and relay log file had been set to 4, ../log/relaylog.001821 respectively. 2017-09-11T17:03:08.614861Z 2 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006984' at position 92390006 2017-09-11T17:03:08.614973Z 2 [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. 2017-09-11T17:03:08.615723Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.006984' at position 92390006, relay log '../log/relaylog.001837' position: 4 2017-09-11T17:03:08.616367Z 2 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006984' at position 92390006 2017-09-11T17:03:08.670804Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.1-dmr-log' socket: 'mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-09-11T17:15:29.397752Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170911 19:15:29 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 17:30:45 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=58 max_threads=3000 thread_count=59 connection_count=57 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f06e000f5c0 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 = 7f200c0bbe70 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x3d) [0x129c2dd] /usr/sbin/mysqld(handle_fatal_signal+0x4a1) [0xbe09f1] /lib64/libpthread.so.0(+0xf370) [0x7f2361fdb370] /lib64/libc.so.6(gsignal+0x37) [0x7f23609ce1d7] /lib64/libc.so.6(abort+0x148) [0x7f23609cf8c8] /lib64/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x165) [0x7f23612d29d5] /lib64/libstdc++.so.6(+0x5e946) [0x7f23612d0946] /lib64/libstdc++.so.6(+0x5e973) [0x7f23612d0973] /lib64/libstdc++.so.6(+0x5eb93) [0x7f23612d0b93] /lib64/libstdc++.so.6(operator new(unsigned long)+0x7d) [0x7f23612d112d] /usr/sbin/mysqld(void std::vector >::_M_emplace_back_aux(row_data_lock const&)+0x46) [0x16821e6] /usr/sbin/mysqld(PFS_data_lock_container::add_lock_row(char const*, unsigned long, char const*, unsigned long, unsigned long long, unsigned long long, unsigned long long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, void const*, char const*, char const*, char const*, char const*)+0x29d) [0x1681ccd] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx(PSI_server_data_lock_container*, bool, trx_t const*, bool, int, unsigned long, unsigned int, unsigned int, unsigned long)+0x485) [0x13149a5] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx_list(PSI_server_data_lock_container*, bool, bool, ut_list_base trx_t::*>*)+0x15f) [0x1314d5f] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan(PSI_server_data_lock_container*, bool)+0x26f) [0x131502f] /usr/sbin/mysqld(table_data_locks::rnd_next()+0x63) [0x1654823] /usr/sbin/mysqld(ha_perfschema::rnd_next(unsigned char*)+0x62) [0x15f9842] /usr/sbin/mysqld(handler::ha_rnd_next(unsigned char*)+0x1dc) [0xcad43c] /usr/sbin/mysqld(rr_sequential(READ_RECORD*)+0x20) [0x91e770] /usr/sbin/mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x12f) [0x96970f] /usr/sbin/mysqld(JOIN::exec()+0x27e) [0x96863e] /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x104) [0x9d6e24] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x25a) [0x9d5c2a] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x491) [0x993931] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3a5) [0x999655] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x99b) [0x99a06b] /usr/sbin/mysqld(do_command(THD*)+0x1a8) [0x99baf8] /usr/sbin/mysqld() [0xbd75f0] /usr/sbin/mysqld() [0x15fd454] /lib64/libpthread.so.0(+0x7dc5) [0x7f2361fd3dc5] /lib64/libc.so.6(clone+0x6d) [0x7f2360a9076d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f06e00155f0): SELECT * FROM performance_schema.data_locks Connection ID (thread ID): 974 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2017-09-11T17:30:55.880021Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-11T17:30:55.880130Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-09-11T17:30:55.880134Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2017-09-11T17:30:55.881586Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.1-dmr-log) starting as process 34558 ... 2017-09-11T17:30:55.949441Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-11T17:30:55.949643Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-11T17:30:55.950625Z 1 [Note] InnoDB: PUNCH HOLE support available 2017-09-11T17:30:55.950647Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-11T17:30:55.950651Z 1 [Note] InnoDB: Uses event mutexes 2017-09-11T17:30:55.950654Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-11T17:30:55.950658Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-09-11T17:30:55.952041Z 1 [Note] InnoDB: Number of pools: 1 2017-09-11T17:30:55.952137Z 1 [Note] InnoDB: Using CPU crc32 instructions 2017-09-11T17:30:55.955233Z 1 [Note] InnoDB: Initializing buffer pool, total size = 99.875G, instances = 47, chunk size = 128M 2017-09-11T17:30:55.955252Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE 2017-09-11T17:31:03.137398Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT 2017-09-11T17:31:03.137433Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-09-11T17:31:04.350416Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-11T17:31:05.280745Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 39392289575892 2017-09-11T17:31:05.280788Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39392289575901 2017-09-11T17:31:06.193691Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39392289575901 2017-09-11T17:31:06.193733Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-09-11T17:31:06.193739Z 1 [Note] InnoDB: Starting crash recovery. 2017-09-11T17:31:07.812648Z 1 [Note] InnoDB: Last MySQL binlog file position 0 818871476, file name ../log/binlog.000465 2017-09-11T17:31:08.194836Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 126 row operations to undo 2017-09-11T17:31:08.194883Z 1 [Note] InnoDB: Trx id counter is 60513333248 2017-09-11T17:31:08.195054Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-11T17:31:08.195066Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-11T17:31:08.195111Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-11T17:31:08.202132Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-11T17:31:08.203022Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-09-11T17:31:08.223211Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 39392289575901 2017-09-11T17:31:08.354030Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-09-11T17:31:08.354073Z 0 [Note] InnoDB: Rolling back trx with id 60513330711, 126 rows to undo 2017-09-11T17:31:08.354146Z 1 [Note] InnoDB: Waiting for purge to start 2017-09-11T17:31:08.371918Z 0 [Note] InnoDB: Rollback of trx with id 60513330711 completed 2017-09-11T17:31:08.371934Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-09-11T17:31:08.404476Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/res/data/ib_buffer_pool 2017-09-11T17:31:08.483312Z 1 [Warning] Skip re-populating collations and character sets tables in read-only mode. 2017-09-11T17:31:08.483358Z 1 [Note] Found data dictionary with version 1 2017-09-11T17:31:08.489492Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-09-11T17:31:08.490084Z 0 [Note] Server hostname (bind-address): '::'; port: 3306 2017-09-11T17:31:08.490121Z 0 [Note] - '::' resolves to '::'; 2017-09-11T17:31:08.490190Z 0 [Note] Server socket created on IP: '::'. 2017-09-11T17:31:08.538395Z 0 [Warning] Recovery from master pos 92390006 and file binlog.006984 for channel ''. Previous relay log pos and relay log file had been set to 4, ../log/relaylog.001837 respectively. 2017-09-11T17:31:08.538913Z 2 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006984' at position 92390006 2017-09-11T17:31:08.538947Z 2 [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. 2017-09-11T17:31:08.539568Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.006984' at position 92390006, relay log '../log/relaylog.001859' position: 4 2017-09-11T17:31:08.540224Z 2 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006984' at position 92390006 2017-09-11T17:31:08.585486Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.1-dmr-log' socket: 'mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-09-11T17:43:34.700374Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170911 19:43:34 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 17:59:43 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=58 max_threads=3000 thread_count=59 connection_count=57 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f65f400c920 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 = 7f7e6817ee70 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x3d) [0x129c2dd] /usr/sbin/mysqld(handle_fatal_signal+0x4a1) [0xbe09f1] /lib64/libpthread.so.0(+0xf370) [0x7f825f615370] /lib64/libc.so.6(gsignal+0x37) [0x7f825e0081d7] /lib64/libc.so.6(abort+0x148) [0x7f825e0098c8] /lib64/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x165) [0x7f825e90c9d5] /lib64/libstdc++.so.6(+0x5e946) [0x7f825e90a946] /lib64/libstdc++.so.6(+0x5e973) [0x7f825e90a973] /lib64/libstdc++.so.6(+0x5eb93) [0x7f825e90ab93] /lib64/libstdc++.so.6(operator new(unsigned long)+0x7d) [0x7f825e90b12d] /usr/sbin/mysqld(void std::vector >::_M_emplace_back_aux(row_data_lock const&)+0x46) [0x16821e6] /usr/sbin/mysqld(PFS_data_lock_container::add_lock_row(char const*, unsigned long, char const*, unsigned long, unsigned long long, unsigned long long, unsigned long long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, void const*, char const*, char const*, char const*, char const*)+0x29d) [0x1681ccd] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx(PSI_server_data_lock_container*, bool, trx_t const*, bool, int, unsigned long, unsigned int, unsigned int, unsigned long)+0x485) [0x13149a5] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx_list(PSI_server_data_lock_container*, bool, bool, ut_list_base trx_t::*>*)+0x15f) [0x1314d5f] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan(PSI_server_data_lock_container*, bool)+0x26f) [0x131502f] /usr/sbin/mysqld(table_data_locks::rnd_next()+0x63) [0x1654823] /usr/sbin/mysqld(ha_perfschema::rnd_next(unsigned char*)+0x62) [0x15f9842] /usr/sbin/mysqld(handler::ha_rnd_next(unsigned char*)+0x1dc) [0xcad43c] /usr/sbin/mysqld(rr_sequential(READ_RECORD*)+0x20) [0x91e770] /usr/sbin/mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x12f) [0x96970f] /usr/sbin/mysqld(JOIN::exec()+0x27e) [0x96863e] /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x104) [0x9d6e24] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x25a) [0x9d5c2a] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x491) [0x993931] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3a5) [0x999655] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x99b) [0x99a06b] /usr/sbin/mysqld(do_command(THD*)+0x1a8) [0x99baf8] /usr/sbin/mysqld() [0xbd75f0] /usr/sbin/mysqld() [0x15fd454] /lib64/libpthread.so.0(+0x7dc5) [0x7f825f60ddc5] /lib64/libc.so.6(clone+0x6d) [0x7f825e0ca76d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f65f409e990): SELECT * FROM performance_schema.data_locks Connection ID (thread ID): 1003 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2017-09-11T17:59:53.985974Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-11T17:59:53.986082Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-09-11T17:59:53.986102Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2017-09-11T17:59:53.987983Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.1-dmr-log) starting as process 62141 ... 2017-09-11T17:59:54.061326Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-11T17:59:54.061523Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-11T17:59:54.062538Z 1 [Note] InnoDB: PUNCH HOLE support available 2017-09-11T17:59:54.062598Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-11T17:59:54.062603Z 1 [Note] InnoDB: Uses event mutexes 2017-09-11T17:59:54.062606Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-11T17:59:54.062619Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-09-11T17:59:54.064282Z 1 [Note] InnoDB: Number of pools: 1 2017-09-11T17:59:54.064409Z 1 [Note] InnoDB: Using CPU crc32 instructions 2017-09-11T17:59:54.068111Z 1 [Note] InnoDB: Initializing buffer pool, total size = 99.875G, instances = 47, chunk size = 128M 2017-09-11T17:59:54.068130Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE 2017-09-11T18:00:01.236679Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT 2017-09-11T18:00:01.236725Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-09-11T18:00:02.462842Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-11T18:00:03.423680Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 39410667670542 2017-09-11T18:00:03.423730Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39410667670551 2017-09-11T18:00:04.355735Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39410667670551 2017-09-11T18:00:04.355774Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-09-11T18:00:04.355780Z 1 [Note] InnoDB: Starting crash recovery. 2017-09-11T18:00:05.972067Z 1 [Note] InnoDB: Last MySQL binlog file position 0 818871476, file name ../log/binlog.000465 2017-09-11T18:00:06.338934Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 126 row operations to undo 2017-09-11T18:00:06.338997Z 1 [Note] InnoDB: Trx id counter is 60513336320 2017-09-11T18:00:06.339143Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-11T18:00:06.339173Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-11T18:00:06.339222Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-11T18:00:06.346654Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-11T18:00:06.347617Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-09-11T18:00:06.368574Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 39410667670551 2017-09-11T18:00:06.496000Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-09-11T18:00:06.496097Z 0 [Note] InnoDB: Rolling back trx with id 60513333275, 126 rows to undo 2017-09-11T18:00:06.496186Z 1 [Note] InnoDB: Waiting for purge to start 2017-09-11T18:00:06.513888Z 0 [Note] InnoDB: Rollback of trx with id 60513333275 completed 2017-09-11T18:00:06.513928Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-09-11T18:00:06.546476Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/res/data/ib_buffer_pool 2017-09-11T18:00:06.627835Z 1 [Warning] Skip re-populating collations and character sets tables in read-only mode. 2017-09-11T18:00:06.627877Z 1 [Note] Found data dictionary with version 1 2017-09-11T18:00:06.632711Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-09-11T18:00:06.633277Z 0 [Note] Server hostname (bind-address): '::'; port: 3306 2017-09-11T18:00:06.633313Z 0 [Note] - '::' resolves to '::'; 2017-09-11T18:00:06.633367Z 0 [Note] Server socket created on IP: '::'. 2017-09-11T18:00:06.679559Z 0 [Warning] Recovery from master pos 92390006 and file binlog.006984 for channel ''. Previous relay log pos and relay log file had been set to 4, ../log/relaylog.001859 respectively. 2017-09-11T18:00:06.683486Z 2 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006984' at position 92390006 2017-09-11T18:00:06.683515Z 2 [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. 2017-09-11T18:00:06.684045Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.006984' at position 92390006, relay log '../log/relaylog.001887' position: 4 2017-09-11T18:00:06.685176Z 2 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006984' at position 92390006 2017-09-11T18:00:06.731047Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.1-dmr-log' socket: 'mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-09-11T18:12:32.935324Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170911 20:12:32 2017-09-11T18:20:38.831250Z 2 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013) 2017-09-11T18:20:38.831293Z 2 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binlog.006995' at position 16995907 for channel '' 2017-09-11T18:20:38.831314Z 2 [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. terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 18:27:51 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=59 max_threads=3000 thread_count=61 connection_count=59 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7efb90010f90 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 = 7f15980fce70 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x3d) [0x129c2dd] /usr/sbin/mysqld(handle_fatal_signal+0x4a1) [0xbe09f1] /lib64/libpthread.so.0(+0xf370) [0x7f17addff370] /lib64/libc.so.6(gsignal+0x37) [0x7f17ac7f21d7] /lib64/libc.so.6(abort+0x148) [0x7f17ac7f38c8] /lib64/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x165) [0x7f17ad0f69d5] /lib64/libstdc++.so.6(+0x5e946) [0x7f17ad0f4946] /lib64/libstdc++.so.6(+0x5e973) [0x7f17ad0f4973] /lib64/libstdc++.so.6(+0x5eb93) [0x7f17ad0f4b93] /lib64/libstdc++.so.6(operator new(unsigned long)+0x7d) [0x7f17ad0f512d] /usr/sbin/mysqld(void std::vector >::_M_emplace_back_aux(row_data_lock const&)+0x46) [0x16821e6] /usr/sbin/mysqld(PFS_data_lock_container::add_lock_row(char const*, unsigned long, char const*, unsigned long, unsigned long long, unsigned long long, unsigned long long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, void const*, char const*, char const*, char const*, char const*)+0x29d) [0x1681ccd] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx(PSI_server_data_lock_container*, bool, trx_t const*, bool, int, unsigned long, unsigned int, unsigned int, unsigned long)+0x485) [0x13149a5] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx_list(PSI_server_data_lock_container*, bool, bool, ut_list_base trx_t::*>*)+0x15f) [0x1314d5f] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan(PSI_server_data_lock_container*, bool)+0x26f) [0x131502f] /usr/sbin/mysqld(table_data_locks::rnd_next()+0x63) [0x1654823] /usr/sbin/mysqld(ha_perfschema::rnd_next(unsigned char*)+0x62) [0x15f9842] /usr/sbin/mysqld(handler::ha_rnd_next(unsigned char*)+0x1dc) [0xcad43c] /usr/sbin/mysqld(rr_sequential(READ_RECORD*)+0x20) [0x91e770] /usr/sbin/mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x12f) [0x96970f] /usr/sbin/mysqld(JOIN::exec()+0x27e) [0x96863e] /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x104) [0x9d6e24] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x25a) [0x9d5c2a] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x491) [0x993931] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3a5) [0x999655] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x99b) [0x99a06b] /usr/sbin/mysqld(do_command(THD*)+0x1a8) [0x99baf8] /usr/sbin/mysqld() [0xbd75f0] /usr/sbin/mysqld() [0x15fd454] /lib64/libpthread.so.0(+0x7dc5) [0x7f17addf7dc5] /lib64/libc.so.6(clone+0x6d) [0x7f17ac8b476d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7efb9000a890): SELECT * FROM performance_schema.data_locks Connection ID (thread ID): 993 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2017-09-11T18:28:01.178629Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-11T18:28:01.178739Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-09-11T18:28:01.178742Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2017-09-11T18:28:01.180355Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.1-dmr-log) starting as process 23140 ... 2017-09-11T18:28:01.255716Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-11T18:28:01.255917Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-11T18:28:01.257003Z 1 [Note] InnoDB: PUNCH HOLE support available 2017-09-11T18:28:01.257049Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-11T18:28:01.257054Z 1 [Note] InnoDB: Uses event mutexes 2017-09-11T18:28:01.257057Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-11T18:28:01.257060Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-09-11T18:28:01.258637Z 1 [Note] InnoDB: Number of pools: 1 2017-09-11T18:28:01.258756Z 1 [Note] InnoDB: Using CPU crc32 instructions 2017-09-11T18:28:01.262350Z 1 [Note] InnoDB: Initializing buffer pool, total size = 99.875G, instances = 47, chunk size = 128M 2017-09-11T18:28:01.262370Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE 2017-09-11T18:28:08.409607Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT 2017-09-11T18:28:08.409651Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-09-11T18:28:09.611171Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-11T18:28:10.533404Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 39427938840514 2017-09-11T18:28:10.533453Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39427938840523 2017-09-11T18:28:11.429008Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39427938840523 2017-09-11T18:28:11.429057Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-09-11T18:28:11.429061Z 1 [Note] InnoDB: Starting crash recovery. 2017-09-11T18:28:13.021215Z 1 [Note] InnoDB: Last MySQL binlog file position 0 818871476, file name ../log/binlog.000465 2017-09-11T18:28:13.399380Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 126 row operations to undo 2017-09-11T18:28:13.399415Z 1 [Note] InnoDB: Trx id counter is 60513339904 2017-09-11T18:28:13.399546Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-11T18:28:13.399558Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-11T18:28:13.399602Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-11T18:28:13.406482Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-11T18:28:13.407278Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-09-11T18:28:13.425106Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 39427938840523 2017-09-11T18:28:13.555344Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-09-11T18:28:13.555406Z 1 [Note] InnoDB: Waiting for purge to start 2017-09-11T18:28:13.555412Z 0 [Note] InnoDB: Rolling back trx with id 60513336349, 126 rows to undo 2017-09-11T18:28:13.572212Z 0 [Note] InnoDB: Rollback of trx with id 60513336349 completed 2017-09-11T18:28:13.572230Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-09-11T18:28:13.605635Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/res/data/ib_buffer_pool 2017-09-11T18:28:13.678172Z 1 [Warning] Skip re-populating collations and character sets tables in read-only mode. 2017-09-11T18:28:13.678252Z 1 [Note] Found data dictionary with version 1 2017-09-11T18:28:13.683847Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-09-11T18:28:13.684539Z 0 [Note] Server hostname (bind-address): '::'; port: 3306 2017-09-11T18:28:13.684570Z 0 [Note] - '::' resolves to '::'; 2017-09-11T18:28:13.684621Z 0 [Note] Server socket created on IP: '::'. 2017-09-11T18:28:13.738323Z 0 [Warning] Recovery from master pos 92390006 and file binlog.006984 for channel ''. Previous relay log pos and relay log file had been set to 4, ../log/relaylog.001887 respectively. 2017-09-11T18:28:13.738925Z 2 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006984' at position 92390006 2017-09-11T18:28:13.738986Z 2 [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. 2017-09-11T18:28:13.739700Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.006984' at position 92390006, relay log '../log/relaylog.001922' position: 4 2017-09-11T18:28:13.740321Z 2 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006984' at position 92390006 2017-09-11T18:28:13.780925Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.1-dmr-log' socket: 'mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-09-11T18:29:16.858944Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4429ms. The settings might not be optimal. (flushed=1140 and evicted=0, during the time.) 2017-09-11T18:33:33.310249Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14430ms. The settings might not be optimal. (flushed=1512 and evicted=0, during the time.) 2017-09-11T18:40:34.819232Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170911 20:40:34 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 18:55:43 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=58 max_threads=3000 thread_count=59 connection_count=57 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f482c014fc0 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 = 7f5edc0bbe70 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x3d) [0x129c2dd] /usr/sbin/mysqld(handle_fatal_signal+0x4a1) [0xbe09f1] /lib64/libpthread.so.0(+0xf370) [0x7f6552959370] /lib64/libc.so.6(gsignal+0x37) [0x7f655134c1d7] /lib64/libc.so.6(abort+0x148) [0x7f655134d8c8] /lib64/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x165) [0x7f6551c509d5] /lib64/libstdc++.so.6(+0x5e946) [0x7f6551c4e946] /lib64/libstdc++.so.6(+0x5e973) [0x7f6551c4e973] /lib64/libstdc++.so.6(+0x5eb93) [0x7f6551c4eb93] /lib64/libstdc++.so.6(operator new(unsigned long)+0x7d) [0x7f6551c4f12d] /usr/sbin/mysqld(void std::vector >::_M_emplace_back_aux(row_data_lock const&)+0x46) [0x16821e6] /usr/sbin/mysqld(PFS_data_lock_container::add_lock_row(char const*, unsigned long, char const*, unsigned long, unsigned long long, unsigned long long, unsigned long long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, char const*, unsigned long, void const*, char const*, char const*, char const*, char const*)+0x29d) [0x1681ccd] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx(PSI_server_data_lock_container*, bool, trx_t const*, bool, int, unsigned long, unsigned int, unsigned int, unsigned long)+0x485) [0x13149a5] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan_trx_list(PSI_server_data_lock_container*, bool, bool, ut_list_base trx_t::*>*)+0x15f) [0x1314d5f] /usr/sbin/mysqld(Innodb_data_lock_iterator::scan(PSI_server_data_lock_container*, bool)+0x26f) [0x131502f] /usr/sbin/mysqld(table_data_locks::rnd_next()+0x63) [0x1654823] /usr/sbin/mysqld(ha_perfschema::rnd_next(unsigned char*)+0x62) [0x15f9842] /usr/sbin/mysqld(handler::ha_rnd_next(unsigned char*)+0x1dc) [0xcad43c] /usr/sbin/mysqld(rr_sequential(READ_RECORD*)+0x20) [0x91e770] /usr/sbin/mysqld(sub_select(JOIN*, QEP_TAB*, bool)+0x12f) [0x96970f] /usr/sbin/mysqld(JOIN::exec()+0x27e) [0x96863e] /usr/sbin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x104) [0x9d6e24] /usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x25a) [0x9d5c2a] /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x491) [0x993931] /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3a5) [0x999655] /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x99b) [0x99a06b] /usr/sbin/mysqld(do_command(THD*)+0x1a8) [0x99baf8] /usr/sbin/mysqld() [0xbd75f0] /usr/sbin/mysqld() [0x15fd454] /lib64/libpthread.so.0(+0x7dc5) [0x7f6552951dc5] /lib64/libc.so.6(clone+0x6d) [0x7f655140e76d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f482c003930): SELECT * FROM performance_schema.data_locks Connection ID (thread ID): 952 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2017-09-11T18:55:53.483043Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-11T18:55:53.483161Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2017-09-11T18:55:53.483164Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2017-09-11T18:55:53.484609Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.1-dmr-log) starting as process 49921 ... 2017-09-11T18:55:53.552976Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-11T18:55:53.553163Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-11T18:55:53.554052Z 1 [Note] InnoDB: PUNCH HOLE support available 2017-09-11T18:55:53.554074Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-11T18:55:53.554078Z 1 [Note] InnoDB: Uses event mutexes 2017-09-11T18:55:53.554082Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-11T18:55:53.554094Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-09-11T18:55:53.555379Z 1 [Note] InnoDB: Number of pools: 1 2017-09-11T18:55:53.555473Z 1 [Note] InnoDB: Using CPU crc32 instructions 2017-09-11T18:55:53.558572Z 1 [Note] InnoDB: Initializing buffer pool, total size = 99.875G, instances = 47, chunk size = 128M 2017-09-11T18:55:53.558590Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_INTERLEAVE 2017-09-11T18:56:00.697065Z 1 [Note] InnoDB: Setting NUMA memory policy to MPOL_DEFAULT 2017-09-11T18:56:00.697099Z 1 [Note] InnoDB: Completed initialization of buffer pool 2017-09-11T18:56:01.922085Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-11T18:56:02.872087Z 1 [Note] InnoDB: Log scan progressed past the checkpoint lsn 39445588427658 2017-09-11T18:56:02.872132Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39445588427667 2017-09-11T18:56:03.791790Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 39445588427667 2017-09-11T18:56:03.791821Z 1 [Note] InnoDB: Database was not shutdown normally! 2017-09-11T18:56:03.791827Z 1 [Note] InnoDB: Starting crash recovery. 2017-09-11T18:56:05.410872Z 1 [Note] InnoDB: Last MySQL binlog file position 0 818871476, file name ../log/binlog.000465 2017-09-11T18:56:05.794565Z 1 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 126 row operations to undo 2017-09-11T18:56:05.794610Z 1 [Note] InnoDB: Trx id counter is 60513344000 2017-09-11T18:56:05.794809Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-11T18:56:05.794820Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-11T18:56:05.794866Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-11T18:56:05.802258Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-11T18:56:05.803178Z 1 [Note] InnoDB: 32 rollback segment(s) are active in the temporary tablespace. 2017-09-11T18:56:05.823331Z 1 [Note] InnoDB: 8.0.1 started; log sequence number 39445588427667 2017-09-11T18:56:05.956643Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions 2017-09-11T18:56:05.956715Z 1 [Note] InnoDB: Waiting for purge to start 2017-09-11T18:56:05.956716Z 0 [Note] InnoDB: Rolling back trx with id 60513339923, 126 rows to undo 2017-09-11T18:56:05.974606Z 0 [Note] InnoDB: Rollback of trx with id 60513339923 completed 2017-09-11T18:56:05.974622Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2017-09-11T18:56:06.007133Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql/res/data/ib_buffer_pool 2017-09-11T18:56:06.079080Z 1 [Warning] Skip re-populating collations and character sets tables in read-only mode. 2017-09-11T18:56:06.079121Z 1 [Note] Found data dictionary with version 1 2017-09-11T18:56:06.084604Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-09-11T18:56:06.085174Z 0 [Note] Server hostname (bind-address): '::'; port: 3306 2017-09-11T18:56:06.085224Z 0 [Note] - '::' resolves to '::'; 2017-09-11T18:56:06.085288Z 0 [Note] Server socket created on IP: '::'. 2017-09-11T18:56:06.132130Z 0 [Warning] Recovery from master pos 92390006 and file binlog.006984 for channel ''. Previous relay log pos and relay log file had been set to 4, ../log/relaylog.001922 respectively. 2017-09-11T18:56:06.132798Z 2 [Note] Slave I/O thread: Start asynchronous replication to master 'rep_user@master.example.com:3306' in log 'binlog.006984' at position 92390006 2017-09-11T18:56:06.132854Z 2 [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. 2017-09-11T18:56:06.133487Z 3 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'binlog.006984' at position 92390006, relay log '../log/relaylog.001962' position: 4 2017-09-11T18:56:06.134363Z 2 [Note] Slave I/O thread for channel '': connected to master 'rep_user@master.example.com:3306',replication started in log 'binlog.006984' at position 92390006 2017-09-11T18:56:06.177459Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.1-dmr-log' socket: 'mysql.sock' port: 3306 MySQL Community Server (GPL) 2017-09-11T19:08:33.080210Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170911 21:08:33 terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 19:22:53 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=805306368 read_buffer_size=4194304 max_used_connections=61 max_threads=3000 thread_count=62 connection_count=60 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 16185924 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fccc0014ff0 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 = 7fe56007ae70 thread_stack 0