Advertisement
Guest User

Untitled

a guest
Nov 9th, 2018
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.35 KB | None | 0 0
  1. InnoDB: End of page dump
  2. 181109 7:22:20 InnoDB: Page checksum 1575996416 (32bit_calc: 2253597184), prior-to-4.0.14-form checksum 1371122432
  3. InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
  4. InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
  5. InnoDB: Page number (if stored to page already) 0,
  6. InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
  7. InnoDB: Page may be a freshly allocated page
  8. 181109 7:22:20 [ERROR] mysqld got signal 11 ;
  9. This could be because you hit a bug. It is also possible that this binary
  10. or one of the libraries it was linked against is corrupt, improperly built,
  11. or misconfigured. This error can also be caused by malfunctioning hardware.
  12.  
  13. To report this bug, see http://kb.askmonty.org/en/reporting-bugs
  14.  
  15. We will try our best to scrape up some info that will hopefully help
  16. diagnose the problem, but since we have already crashed,
  17. something is definitely wrong and this may fail.
  18.  
  19. Server version: 5.5.60-MariaDB
  20. key_buffer_size=134217728
  21. read_buffer_size=131072
  22. max_used_connections=24
  23. max_threads=153
  24. thread_count=17
  25. It is possible that mysqld could use up to
  26. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 466718 K bytes of memory
  27. Hope that's ok; if not, decrease some variables in the equation.
  28.  
  29. Thread pointer: 0x56372cc30e00
  30. Attempting backtrace. You can use the following information to find out
  31. where mysqld died. If you see no messages after this, something went
  32. terribly wrong...
  33. stack_bottom = 0x7fe887761d80 thread_stack 0x48000
  34. /usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x5637293bacbd]
  35. /usr/libexec/mysqld(handle_fatal_signal+0x515)[0x563728fcf4a5]
  36. sigaction.c:0(__restore_rt)[0x7fe8ddbe35d0]
  37. /usr/libexec/mysqld(+0x73afc1)[0x563729265fc1]
  38. /usr/libexec/mysqld(+0x68ae15)[0x5637291b5e15]
  39. /usr/libexec/mysqld(+0x63badb)[0x563729166adb]
  40. /usr/libexec/mysqld(+0x610bb4)[0x56372913bbb4]
  41. /usr/libexec/mysqld(_ZN7handler18index_read_idx_mapEPhjPKhm16ha_rkey_function+0x85)[0x563728fcfaa5]
  42. /usr/libexec/mysqld(+0x3b15fe)[0x563728edc5fe]
  43. /usr/libexec/mysqld(+0x3b17b8)[0x563728edc7b8]
  44. /usr/libexec/mysqld(+0x3b7789)[0x563728ee2789]
  45. /usr/libexec/mysqld(_ZN4JOIN8optimizeEv+0x675)[0x563728ee66d5]
  46. /usr/libexec/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xc8)[0x563728ee8bc8]
  47. /usr/libexec/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x2db)[0x563728ee96eb]
  48. /usr/libexec/mysqld(+0x36c4b9)[0x563728e974b9]
  49. /usr/libexec/mysqld(_Z21mysql_execute_commandP3THD+0x2e8e)[0x563728ea049e]
  50. /usr/libexec/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x125)[0x563728ea4445]
  51. /usr/libexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1750)[0x563728ea64a0]
  52. /usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0x1c2)[0x563728f58a22]
  53. /usr/libexec/mysqld(handle_one_connection+0x4a)[0x563728f58aca]
  54. pthread_create.c:0(start_thread)[0x7fe8ddbdbdd5]
  55. /lib64/libc.so.6(clone+0x6d)[0x7fe8dc3d5ead]
  56.  
  57. Trying to get some variables.
  58. Some pointers may be invalid and cause the dump to abort.
  59. Query (0x7fe850018e98): select CUSTOMERID FROM DS3.CUSTOMERS where USERNAME='user237896' and PASSWORD='password'
  60. Connection ID (thread ID): 98
  61. Status: NOT_KILLED
  62.  
  63. 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
  64.  
  65. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  66. information that should help you find out what is causing the crash.
  67. 181109 07:22:21 mysqld_safe Number of processes running now: 0
  68. 181109 07:22:21 mysqld_safe mysqld restarted
  69. 181109 7:22:21 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 26122 ...
  70. 181109 7:22:21 InnoDB: The InnoDB memory heap is disabled
  71. 181109 7:22:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  72. 181109 7:22:21 InnoDB: Compressed tables use zlib 1.2.7
  73. 181109 7:22:21 InnoDB: Using Linux native AIO
  74. 181109 7:22:21 InnoDB: Initializing buffer pool, size = 128.0M
  75. 181109 7:22:21 InnoDB: Completed initialization of buffer pool
  76. 181109 7:22:21 InnoDB: highest supported file format is Barracuda.
  77. 181109 7:22:21 InnoDB: Starting crash recovery from checkpoint LSN=118234821021
  78. InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
  79. 181109 7:22:21 InnoDB: Starting final batch to recover 587 pages from redo log
  80. 181109 7:22:21 InnoDB: Waiting for the background threads to start
  81. 181109 7:22:22 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 118235094167
  82. 181109 7:22:22 [Note] Plugin 'FEEDBACK' is disabled.
  83. 181109 7:22:22 [Note] Server socket created on IP: '0.0.0.0'.
  84. 181109 7:22:22 [Note] Event Scheduler: Loaded 0 events
  85. 181109 7:22:22 [Note] /usr/libexec/mysqld: ready for connections.
  86. 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