percona 又挂了

归隐乡村

InnoDB: End of page dump
2016-05-12 10:07:18 7fb67f618700 InnoDB: uncompressed page, stored checksum in field1 0, calculated checksums for field1: crc32 536728786, innodb 1575996416, none 3735928559, stored checksum in field2 0, calculated checksums for field2: crc32 536728786, innodb 1371122432, none 3735928559, page LSN 0 0, low 4 bytes of LSN at page end 0, page number (if stored to page already) 0, space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be a freshly allocated page
02:07:18 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Please help us make Percona Server better by reporting any
bugs at http://bugs.percona.com/

key_buffer_size=524288000
read_buffer_size=4194304
max_used_connections=306
max_threads=2002
thread_count=306
connection_count=306
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 12841787 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1433bbc0
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 = 7fb67f617d40 thread_stack 0x40000
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(my_print_stacktrace+0x2c)[0x8ed71c]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x461)[0x679c81]
/lib64/libpthread.so.0(+0xf710)[0x7fba2ce6f710]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x99c5be]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0xa47872]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x9eeaad]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x93fa31]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function+0x72)[0x5bf8e2]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x6db0b4]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0xdd)[0x6d87ed]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x6d84ef]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x14b)[0x6d885b]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN4JOIN4execEv+0x2b[0x6d7a88]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z25mysql_derived_materializeP3THDP3LEXP10TABLE_LIST+0x79)[0x6d49c9]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z24join_materialize_derivedP13st_join_table+0x52)[0x6d9252]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN13st_join_table12prepare_scanEv+0x42)[0x6d7fa2]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x3[0x6d8748]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x6d84ef]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x14b)[0x6d885b]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x6d84ef]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x14b)[0x6d885b]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN4JOIN4execEv+0x2b[0x6d7a88]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x275)[0x720755]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x165)[0x720fb5]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld[0x5816c2]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z21mysql_execute_commandP3THD+0x1e49)[0x6fad99]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x5c[0x6fffe8]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xff9)[0x701759]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x162)[0x6cf362]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(handle_one_connection+0x40)[0x6cf450]
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(pfs_spawn_thread+0x143)[0x924763]
/lib64/libpthread.so.0(+0x79d1)[0x7fba2ce679d1]
/lib64/libc.so.6(clone+0x6d)[0x7fba2b5868fd]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fb6e04495d0): select a1.apply_id,a1.apply_time             ,  a1.province_code             ,  a1.AGENT_NAME                ,a1.AGENT_CODE                ,a1.CHNL_NAME             ,a1.CHNL_CODE             ,a3.staff_name                ,a3.staff_no                ,  a1.busi_oper_code             , a1.service_num                ,  CASE a1.acct_type            WHEN 1 THEN '            '            WHEN 0 THEN '         '            ELSE ''         END              ,  CASE a1.from_type            WHEN 1 THEN '      '            WHEN 2 THEN '         '            WHEN 3 THEN '      '            WHEN 4 THEN '      '            WHEN 5 THEN '         '            WHEN 6 THEN '         app'            ELSE ''         END                from (  select aa.apply_id,aa.apply_time,  aa.province_code,  aa.AGENT_NAME,aa.AGENT_CODE,aa.CHNL_NAME,aa.CHNL_CODE,aa.oper_id,  aa.busi_oper_code, bb.service_num,cc.acct_type,aa.from_type from (  select a.apply_id,a.apply_time,  (CASE c.PROVINCE_CODE when '11' then '      ' when '51' then '      ' w
Connection ID (thread ID): 850
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.
160512 10:07:18 mysqld_safe Number of processes running now: 0
160512 10:07:18 mysqld_safe mysqld restarted
2016-05-12 10:07:19 19584 [Note] Plugin 'FEDERATED' is disabled.
2016-05-12 10:07:19 19584 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-12 10:07:19 19584 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-12 10:07:19 19584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-05-12 10:07:19 19584 [Note] InnoDB: Memory barrier is not used
2016-05-12 10:07:19 19584 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-12 10:07:19 19584 [Note] InnoDB: Using Linux native AIO
2016-05-12 10:07:19 19584 [Note] InnoDB: Using CPU crc32 instructions
2016-05-12 10:07:19 19584 [Note] InnoDB: Initializing buffer pool, size = 10.0G
2016-05-12 10:07:19 19584 [Note] InnoDB: Completed initialization of buffer pool
2016-05-12 10:07:19 19584 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-12 10:07:19 19584 [Note] InnoDB: Log scan progressed past the checkpoint lsn 73547372628
2016-05-12 10:07:19 19584 [Note] InnoDB: Database was not shutdown normally!
2016-05-12 10:07:19 19584 [Note] InnoDB: Starting crash recovery.
2016-05-12 10:07:19 19584 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-05-12 10:07:25 19584 [Note] InnoDB: Restoring possible half-written data pages
2016-05-12 10:07:25 19584 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 73547372638
InnoDB: Last MySQL binlog file position 0 162242, file name mysql-bin.005028
2016-05-12 10:07:25 19584 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-12 10:07:25 19584 [Note] InnoDB: Waiting for purge to start
2016-05-12 10:07:25 19584 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.21-rel70.1 started; log sequence number 73547372638
2016-05-12 10:07:25 19584 [Note] Recovering after a crash using mysql-bin
2016-05-12 10:07:25 19584 [Note] Starting crash recovery...
2016-05-12 10:07:25 19584 [Note] Crash recovery finished.

2016-05-12 10:07:25 19584 [Note] Server hostname (bind-address): '*'; port: 3916
2016-05-12 10:07:25 19584 [Note] IPv6 is available.
2016-05-12 10:07:25 19584 [Note]   - '::' resolves to '::';
2016-05-12 10:07:25 19584 [Note] Server socket created on IP: '::'.
2016-05-12 10:07:25 19584 [Note] Event Scheduler: Loaded 0 events
2016-05-12 10:07:25 19584 [Note] /opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld: ready for connections.