percona 又挂了
InnoDB: End of page dump2016-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 Kbytes 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)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x461)
/lib64/libpthread.so.0(+0xf710)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function+0x72)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0xdd)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x14b)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN4JOIN4execEv+0x2b8)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z25mysql_derived_materializeP3THDP3LEXP10TABLE_LIST+0x79)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z24join_materialize_derivedP13st_join_table+0x52)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN13st_join_table12prepare_scanEv+0x42)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x38)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x14b)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x14b)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_ZN4JOIN4execEv+0x2b8)
/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)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x165)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z21mysql_execute_commandP3THD+0x1e49)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x5c8)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xff9)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x162)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(handle_one_connection+0x40)
/opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld(pfs_spawn_thread+0x143)
/lib64/libpthread.so.0(+0x79d1)
/lib64/libc.so.6(clone+0x6d)
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 Plugin 'FEDERATED' is disabled.
2016-05-12 10:07:19 19584 InnoDB: Using atomics to ref count buffer pool pages
2016-05-12 10:07:19 19584 InnoDB: The InnoDB memory heap is disabled
2016-05-12 10:07:19 19584 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-05-12 10:07:19 19584 InnoDB: Memory barrier is not used
2016-05-12 10:07:19 19584 InnoDB: Compressed tables use zlib 1.2.3
2016-05-12 10:07:19 19584 InnoDB: Using Linux native AIO
2016-05-12 10:07:19 19584 InnoDB: Using CPU crc32 instructions
2016-05-12 10:07:19 19584 InnoDB: Initializing buffer pool, size = 10.0G
2016-05-12 10:07:19 19584 InnoDB: Completed initialization of buffer pool
2016-05-12 10:07:19 19584 InnoDB: Highest supported file format is Barracuda.
2016-05-12 10:07:19 19584 InnoDB: Log scan progressed past the checkpoint lsn 73547372628
2016-05-12 10:07:19 19584 InnoDB: Database was not shutdown normally!
2016-05-12 10:07:19 19584 InnoDB: Starting crash recovery.
2016-05-12 10:07:19 19584 InnoDB: Reading tablespace information from the .ibd files...
2016-05-12 10:07:25 19584 InnoDB: Restoring possible half-written data pages
2016-05-12 10:07:25 19584 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 InnoDB: 128 rollback segment(s) are active.
2016-05-12 10:07:25 19584 InnoDB: Waiting for purge to start
2016-05-12 10:07:25 19584 InnoDB:Percona XtraDB (http://www.percona.com) 5.6.21-rel70.1 started; log sequence number 73547372638
2016-05-12 10:07:25 19584 Recovering after a crash using mysql-bin
2016-05-12 10:07:25 19584 Starting crash recovery...
2016-05-12 10:07:25 19584 Crash recovery finished.
2016-05-12 10:07:25 19584 Server hostname (bind-address): '*'; port: 3916
2016-05-12 10:07:25 19584 IPv6 is available.
2016-05-12 10:07:25 19584 - '::' resolves to '::';
2016-05-12 10:07:25 19584 Server socket created on IP: '::'.
2016-05-12 10:07:25 19584 Event Scheduler: Loaded 0 events
2016-05-12 10:07:25 19584 /opt/freeware/Percona-Server-5.6.21-rel70.1-698.Linux.x86_64/bin/mysqld: ready for connections.
页:
[1]