Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- InnoDB: End of page dump
- 181109 7:22:20 InnoDB: Page checksum 1575996416 (32bit_calc: 2253597184), prior-to-4.0.14-form checksum 1371122432
- InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
- InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
- InnoDB: Page number (if stored to page already) 0,
- InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
- InnoDB: Page may be a freshly allocated page
- 181109 7:22:20 [ERROR] 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.
- To report this bug, see http://kb.askmonty.org/en/reporting-bugs
- 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.
- Server version: 5.5.60-MariaDB
- key_buffer_size=134217728
- read_buffer_size=131072
- max_used_connections=24
- max_threads=153
- thread_count=17
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466718 K bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- Thread pointer: 0x56372cc30e00
- 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 = 0x7fe887761d80 thread_stack 0x48000
- /usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x5637293bacbd]
- /usr/libexec/mysqld(handle_fatal_signal+0x515)[0x563728fcf4a5]
- sigaction.c:0(__restore_rt)[0x7fe8ddbe35d0]
- /usr/libexec/mysqld(+0x73afc1)[0x563729265fc1]
- /usr/libexec/mysqld(+0x68ae15)[0x5637291b5e15]
- /usr/libexec/mysqld(+0x63badb)[0x563729166adb]
- /usr/libexec/mysqld(+0x610bb4)[0x56372913bbb4]
- /usr/libexec/mysqld(_ZN7handler18index_read_idx_mapEPhjPKhm16ha_rkey_function+0x85)[0x563728fcfaa5]
- /usr/libexec/mysqld(+0x3b15fe)[0x563728edc5fe]
- /usr/libexec/mysqld(+0x3b17b8)[0x563728edc7b8]
- /usr/libexec/mysqld(+0x3b7789)[0x563728ee2789]
- /usr/libexec/mysqld(_ZN4JOIN8optimizeEv+0x675)[0x563728ee66d5]
- /usr/libexec/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xc8)[0x563728ee8bc8]
- /usr/libexec/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x2db)[0x563728ee96eb]
- /usr/libexec/mysqld(+0x36c4b9)[0x563728e974b9]
- /usr/libexec/mysqld(_Z21mysql_execute_commandP3THD+0x2e8e)[0x563728ea049e]
- /usr/libexec/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x125)[0x563728ea4445]
- /usr/libexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1750)[0x563728ea64a0]
- /usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0x1c2)[0x563728f58a22]
- /usr/libexec/mysqld(handle_one_connection+0x4a)[0x563728f58aca]
- pthread_create.c:0(start_thread)[0x7fe8ddbdbdd5]
- /lib64/libc.so.6(clone+0x6d)[0x7fe8dc3d5ead]
- Trying to get some variables.
- Some pointers may be invalid and cause the dump to abort.
- Query (0x7fe850018e98): select CUSTOMERID FROM DS3.CUSTOMERS where USERNAME='user237896' and PASSWORD='password'
- Connection ID (thread ID): 98
- Status: NOT_KILLED
- Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off
- 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.
- 181109 07:22:21 mysqld_safe Number of processes running now: 0
- 181109 07:22:21 mysqld_safe mysqld restarted
- 181109 7:22:21 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 26122 ...
- 181109 7:22:21 InnoDB: The InnoDB memory heap is disabled
- 181109 7:22:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 181109 7:22:21 InnoDB: Compressed tables use zlib 1.2.7
- 181109 7:22:21 InnoDB: Using Linux native AIO
- 181109 7:22:21 InnoDB: Initializing buffer pool, size = 128.0M
- 181109 7:22:21 InnoDB: Completed initialization of buffer pool
- 181109 7:22:21 InnoDB: highest supported file format is Barracuda.
- 181109 7:22:21 InnoDB: Starting crash recovery from checkpoint LSN=118234821021
- InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
- 181109 7:22:21 InnoDB: Starting final batch to recover 587 pages from redo log
- 181109 7:22:21 InnoDB: Waiting for the background threads to start
- 181109 7:22:22 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 118235094167
- 181109 7:22:22 [Note] Plugin 'FEEDBACK' is disabled.
- 181109 7:22:22 [Note] Server socket created on IP: '0.0.0.0'.
- 181109 7:22:22 [Note] Event Scheduler: Loaded 0 events
- 181109 7:22:22 [Note] /usr/libexec/mysqld: ready for connections.
- Version: '5.5.60-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement