API tools faq
paste
Advertisement
lolomin

20130404_mysql_crash_WSREPv23.7.3_GALERAv23.2.4

lolomin
Apr 4th, 2013
76
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.13 KB | None | 0 0
raw download clone embed print report
  1. 130404 15:26:34 mysqld_safe Starting mysqld daemon with databases from /opt/mysql-galera/data
  2. 130404 15:26:34 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.ber13CTjZ8
  3. 130404 15:26:38 mysqld_safe WSREP: Recovered position ff7156e6-9d29-11e2-0800-9b344a6d3838:6
  4. 130404 15:26:38 [Note] WSREP: wsrep_start_position var submitted: 'ff7156e6-9d29-11e2-0800-9b344a6d3838:6'
  5. 130404 15:26:38 [Note] WSREP: Read nil XID from storage engines, skipping position init
  6. 130404 15:26:38 [Note] WSREP: wsrep_load(): loading provider library '/opt/mysql-galera/lib/libgalera_smm.so'
  7. 130404 15:26:38 [Note] WSREP: wsrep_load(): Galera 23.2.4(r147) by Codership Oy <info@codership.com> loaded succesfully.
  8. 130404 15:26:38 [ERROR] WSREP: Failed to read output of: '/sbin/ifconfig | grep -E '^[[:space:]]+inet addr:' | grep -m1 -v 'inet addr:127' | sed 's/:/ /' | awk '{ print $3 }''
  9. 130404 15:26:38 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
  10. 130404 15:26:38 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
  11. 130404 15:26:38 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
  12. 130404 15:26:38 [Note] WSREP: Reusing existing '/opt/mysql-galera/data//galera.cache'.
  13. 130404 15:26:38 [Note] WSREP: Passing config to GCS: base_port = 4567; cert.log_conflicts = no; gcache.dir = /opt/mysql-galera/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /opt/mysql-galera/data//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
  14. 130404 15:26:38 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
  15. 130404 15:26:38 [Note] WSREP: wsrep_sst_grab()
  16. 130404 15:26:38 [Note] WSREP: Start replication
  17. 130404 15:26:38 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
  18. 130404 15:26:38 [Note] WSREP: protonet asio version 0
  19. 130404 15:26:38 [Note] WSREP: backend: asio
  20. 130404 15:26:38 [Note] WSREP: GMCast version 0
  21. 130404 15:26:38 [Note] WSREP: (4778990b-9d2b-11e2-0800-43ae960c05b0, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  22. 130404 15:26:38 [Note] WSREP: (4778990b-9d2b-11e2-0800-43ae960c05b0, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  23. 130404 15:26:38 [Note] WSREP: EVS version 0
  24. 130404 15:26:38 [Note] WSREP: PC version 0
  25. 130404 15:26:38 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer ''
  26. 130404 15:26:38 [Note] WSREP: Node 4778990b-9d2b-11e2-0800-43ae960c05b0 state prim
  27. 130404 15:26:38 [Note] WSREP: view(view_id(PRIM,4778990b-9d2b-11e2-0800-43ae960c05b0,1) memb {
  28. 4778990b-9d2b-11e2-0800-43ae960c05b0,
  29. } joined {
  30. } left {
  31. } partitioned {
  32. })
  33. 130404 15:26:38 [Note] WSREP: gcomm: connected
  34. 130404 15:26:38 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
  35. 130404 15:26:38 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  36. 130404 15:26:38 [Note] WSREP: Opened channel 'my_wsrep_cluster'
  37. 130404 15:26:38 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
  38. 130404 15:26:38 [Note] WSREP: Waiting for SST to complete.
  39. 130404 15:26:38 [Note] WSREP: Starting new group from scratch: 4778e5d2-9d2b-11e2-0800-59ff2fa05f48
  40. 130404 15:26:38 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 4778fd2d-9d2b-11e2-0800-7536affd74da
  41. 130404 15:26:38 [Note] WSREP: STATE EXCHANGE: sent state msg: 4778fd2d-9d2b-11e2-0800-7536affd74da
  42. 130404 15:26:38 [Note] WSREP: STATE EXCHANGE: got state msg: 4778fd2d-9d2b-11e2-0800-7536affd74da from 0 (cygnus.lolomin.net)
  43. 130404 15:26:38 [Note] WSREP: Quorum results:
  44. version = 2,
  45. component = PRIMARY,
  46. conf_id = 0,
  47. members = 1/1 (joined/total),
  48. act_id = 0,
  49. last_appl. = -1,
  50. protocols = 0/4/2 (gcs/repl/appl),
  51. group UUID = 4778e5d2-9d2b-11e2-0800-59ff2fa05f48
  52. 130404 15:26:38 [Note] WSREP: Flow-control interval: [16, 16]
  53. 130404 15:26:38 [Note] WSREP: Restored state OPEN -> JOINED (0)
  54. 130404 15:26:38 [Note] WSREP: Member 0 (cygnus.lolomin.net) synced with group.
  55. 130404 15:26:38 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
  56. 130404 15:26:38 [Note] WSREP: New cluster view: global state: 4778e5d2-9d2b-11e2-0800-59ff2fa05f48:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 2
  57. 130404 15:26:38 [Note] WSREP: SST complete, seqno: 0
  58. 130404 15:26:38 [ERROR] Can't open shared library '/opt/mysql-galera/lib/semisync_master.so' (errno: 0 /opt/mysql-galera/lib/semisync_master.so: cannot open shared object file: No such file or directory)
  59. 130404 15:26:38 [Warning] Couldn't load plugin named 'rpl_semi_sync_master' with soname 'semisync_master.so'.
  60. 130404 15:26:38 [ERROR] Can't open shared library '/opt/mysql-galera/lib/semisync_slave.so' (errno: 0 /opt/mysql-galera/lib/semisync_slave.so: cannot open shared object file: No such file or directory)
  61. 130404 15:26:38 [Warning] Couldn't load plugin named 'rpl_semi_sync_slave' with soname 'semisync_slave.so'.
  62. 130404 15:26:38 InnoDB: The InnoDB memory heap is disabled
  63. 130404 15:26:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  64. 130404 15:26:38 InnoDB: Compressed tables use zlib 1.2.3
  65. 130404 15:26:38 InnoDB: Using Linux native AIO
  66. 130404 15:26:38 InnoDB: Initializing buffer pool, size = 512.0M
  67. 130404 15:26:38 InnoDB: Completed initialization of buffer pool
  68. 130404 15:26:38 InnoDB: highest supported file format is Barracuda.
  69. 130404 15:26:38 InnoDB: Waiting for the background threads to start
  70. 130404 15:26:39 InnoDB: 1.1.8 started; log sequence number 179276810077
  71. 130404 15:26:39 [Note] Server hostname (bind-address): '192.168.0.1'; port: 3306
  72. 130404 15:26:39 [Note] - '192.168.0.1' resolves to '192.168.0.1';
  73. 130404 15:26:39 [Note] Server socket created on IP: '192.168.0.1'.
  74. 130404 15:26:39 [Note] Event Scheduler: Loaded 0 events
  75. 130404 15:26:39 [Note] /opt/mysql-galera/bin/mysqld: ready for connections.
  76. Version: '5.5.29-log' socket: '/opt/mysql-galera/data/mysql.sock' port: 3306 Source distribution, wsrep_23.7.3.r3853
  77. 130404 15:26:40 [Note] WSREP: Assign initial position for certification: 0, protocol version: 2
  78. 130404 15:26:40 [Note] WSREP: Synchronized with group, ready for connections
  79. 13:26:51 UTC - mysqld got signal 11 ;
  80. This could be because you hit a bug. It is also possible that this binary
  81. or one of the libraries it was linked against is corrupt, improperly built,
  82. or misconfigured. This error can also be caused by malfunctioning hardware.
  83. We will try our best to scrape up some info that will hopefully help
  84. diagnose the problem, but since we have already crashed,
  85. something is definitely wrong and this may fail.
  86.  
  87. key_buffer_size=104857600
  88. read_buffer_size=1048576
  89. max_used_connections=8
  90. max_threads=100
  91. thread_count=8
  92. connection_count=7
  93. It is possible that mysqld could use up to
  94. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 615578 K bytes of memory
  95. Hope that's ok; if not, decrease some variables in the equation.
  96.  
  97. Thread pointer: 0x2385320
  98. Attempting backtrace. You can use the following information to find out
  99. where mysqld died. If you see no messages after this, something went
  100. terribly wrong...
  101. stack_bottom = 7f87fc62fe58 thread_stack 0x40000
  102. /opt/mysql-galera/bin/mysqld(my_print_stacktrace+0x2e)[0x770c5e]
  103. /opt/mysql-galera/bin/mysqld(handle_fatal_signal+0x41a)[0x66513a]
  104. /lib64/libpthread.so.0[0x344540f000]
  105. /opt/mysql-galera/bin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy+0x42f)[0x53faff]
  106. /opt/mysql-galera/bin/mysqld(_Z20open_and_lock_tablesP3THDP10TABLE_LISTbjP19Prelocking_strategy+0x47)[0x540517]
  107. /opt/mysql-galera/bin/mysqld[0x55f075]
  108. /opt/mysql-galera/bin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x2d8)[0x560208]
  109. /opt/mysql-galera/bin/mysqld(_Z21mysql_execute_commandP3THD+0x1268)[0x570c28]
  110. /opt/mysql-galera/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x189)[0x5748e9]
  111. /opt/mysql-galera/bin/mysqld[0x575710]
  112. /opt/mysql-galera/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1573)[0x5770d3]
  113. /opt/mysql-galera/bin/mysqld(_Z10do_commandP3THD+0x11f)[0x57783f]
  114. /opt/mysql-galera/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x26e)[0x6039ae]
  115. /opt/mysql-galera/bin/mysqld(handle_one_connection+0x4a)[0x603a2a]
  116. /lib64/libpthread.so.0[0x3445407d15]
  117. /lib64/libc.so.6(clone+0x6d)[0x34448f246d]
  118.  
  119. Trying to get some variables.
  120. Some pointers may be invalid and cause the dump to abort.
  121. Query (7f87a0004ba0): is an invalid pointer
  122. Connection ID (thread ID): 48
  123. Status: NOT_KILLED
  124.  
  125. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  126. information that should help you find out what is causing the crash.
  127. Writing a core file
  128. 130404 15:26:51 mysqld_safe Number of processes running now: 0
  129. 130404 15:26:51 mysqld_safe WSREP: not restarting wsrep node automatically
  130. 130404 15:26:51 mysqld_safe mysqld from pid file /opt/mysql-galera/data/mysqld.pid ended
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!