2016-01-22T06:21:34.768906Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2016-01-22T06:21:34.819277Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2016-01-22T06:21:37.120157Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-01-22T06:21:37.144837Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2016-01-22T06:21:37.173985Z 0 [Note] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld (mysqld 5.7.10-1rc1-debug-valgrind) starting as process 20373 ... 2016-01-22T06:21:38.159058Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-01-22T06:21:38.167141Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2016-01-22T06:21:38.168291Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-01-22T06:21:38.169440Z 0 [Note] InnoDB: Uses event mutexes 2016-01-22T06:21:38.170589Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-01-22T06:21:38.171750Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2016-01-22T06:21:38.173020Z 0 [Note] InnoDB: Using Linux native AIO 2016-01-22T06:21:38.566866Z 0 [Note] InnoDB: Number of pools: 1 2016-01-22T06:21:38.641273Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-01-22T06:21:42.161424Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-01-22T06:21:55.003490Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-01-22T06:21:56.079802Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-01-22T06:21:56.600567Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-01-22T06:22:03.824304Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-01-22T06:22:03.850960Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-01-22T06:22:03.919605Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-01-22T06:22:05.607346Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-01-22T06:22:05.609225Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-01-22T06:22:05.872841Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9849ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2016-01-22T06:22:07.915336Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.10-1 started; log sequence number 2491156 2016-01-22T06:22:08.078813Z 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/1452850231/data/ib_buffer_pool 2016-01-22T06:22:08.882707Z 0 [Note] InnoDB: not started 2016-01-22T06:22:08.998682Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-01-22T06:22:12.436703Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2016-01-22T06:22:12.442658Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2016-01-22T06:22:13.530559Z 0 [Warning] CA certificate ca.pem is self signed. 2016-01-22T06:22:13.560802Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2016-01-22T06:22:13.636210Z 0 [Note] Server hostname (bind-address): '*'; port: 31962 2016-01-22T06:22:13.658579Z 0 [Note] IPv6 is available. 2016-01-22T06:22:13.716695Z 0 [Note] - '::' resolves to '::'; 2016-01-22T06:22:13.726896Z 0 [Note] Server socket created on IP: '::'. 2016-01-22T06:22:14.577528Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160122 1:22:14 2016-01-22T06:22:17.839947Z 0 [Note] Event Scheduler: Loaded 0 events 2016-01-22T06:22:17.923126Z 1 [Note] Event Scheduler: scheduler thread started with id 1 2016-01-22T06:22:18.089650Z 0 [Note] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld: ready for connections. Version: '5.7.10-1rc1-debug-valgrind' socket: '/dev/shm/1452850231/socket.sock' port: 31962 MySQL Community Server (GPL) mysqld: /sda/ps5.7/PS-5.7_val/mysys/my_malloc.c:80: my_realloc: Assertion `(old_mh->m_key == key) || (old_mh->m_key == 0)' failed. 06:23:07 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. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=152 thread_count=2 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68382 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x953c140 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 = 40fdce0 thread_stack 0x40000 /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(my_print_stacktrace+0x35)[0x183ce69] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(handle_fatal_signal+0x411)[0xe61008] /lib64/libpthread.so.0(+0xf100)[0x507d100] /lib64/libc.so.6(gsignal+0x37)[0x6d9a5f7] /lib64/libc.so.6(abort+0x148)[0x6d9bce8] /lib64/libc.so.6(+0x2e566)[0x6d93566] /lib64/libc.so.6(+0x2e612)[0x6d93612] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(my_realloc+0x76)[0x1835386] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z36alloc_and_copy_thd_dynamic_variablesP3THDb+0x84)[0x15478bb] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld[0x1547bc5] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN17sys_var_pluginvar14real_value_ptrEP3THD13enum_var_type+0x87)[0x1548805] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN17sys_var_pluginvar12do_value_ptrEP3THDS1_13enum_var_typeP19st_mysql_lex_string+0x32)[0x15488d0] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN17sys_var_pluginvar17session_value_ptrEP3THDS1_P19st_mysql_lex_string+0x38)[0x154b55a] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN7sys_var9value_ptrEP3THDS1_13enum_var_typeP19st_mysql_lex_string+0xbc)[0x14563e2] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z20get_one_variable_extP3THDS0_PK17st_mysql_show_var13enum_var_type20enum_mysql_show_typeP17system_status_varPPK15charset_info_stPcPm+0x6e)[0x157f7d8] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN15System_variable4initEP3THDPK17st_mysql_show_var13enum_var_type+0x1a0)[0x191c8a6] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN15System_variableC2EP3THDPK17st_mysql_show_var13enum_var_type+0x8a)[0x191c704] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN25PFS_system_variable_cache18do_materialize_allEP3THD+0x1c3)[0x191bafd] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN18PFS_variable_cacheI15System_variableE15materialize_allEP3THD+0x5a)[0x1957cce] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN23table_session_variables8rnd_initEb+0x2e)[0x19576e6] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN13ha_perfschema8rnd_initEb+0x128)[0x18e4ae6] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN7handler11ha_rnd_initEb+0xff)[0xef314f] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z16init_read_recordP11READ_RECORDP3THDP5TABLEP7QEP_TABibb+0x82d)[0x14455a3] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z21join_init_read_recordP7QEP_TAB+0x123)[0x14cf305] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z10sub_selectP4JOINP7QEP_TABb+0x230)[0x14cc562] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld[0x14cbef6] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_ZN4JOIN4execEv+0x629)[0x14c9e77] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z12handle_queryP3THDP3LEXP12Query_resultyy+0x362)[0x1568a52] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld[0x151bf0a] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z21mysql_execute_commandP3THDb+0xe46)[0x151510d] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x685)[0x151cec2] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xbf8)[0x1511ce1] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(_Z10do_commandP3THD+0x520)[0x1510bfb] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(handle_connection+0x2a0)[0x164ffab] /sda/ps5.7/PS-mysql-5.7.10-1rc1-linux-x86_64-valgrind/bin/mysqld(pfs_spawn_thread+0x170)[0x18e778c] /lib64/libpthread.so.0(+0x7dc5)[0x5075dc5] /lib64/libc.so.6(clone+0x6d)[0x6e5b21d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (4700d8b0): show session variables like 'log_error' Connection ID (thread ID): 4 Status: NOT_KILLED 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. Writing a core file