Skip to content

Instantly share code, notes, and snippets.

@ronin13

ronin13/view Secret

Created August 2, 2013 17:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ronin13/f74c5772887f437d0bad to your computer and use it in GitHub Desktop.
Save ronin13/f74c5772887f437d0bad to your computer and use it in GitHub Desktop.
CURRENT_TEST: main.1st
130802 19:45:32 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:18007' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
130802 19:45:32 [Note] WSREP: Read nil XID from storage engines, skipping position init
130802 19:45:32 [Note] WSREP: wsrep_load(): loading provider library '/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/lib/libgalera_smm.so'
130802 19:45:32 [Note] WSREP: wsrep_load(): Galera 2.6(r152) by Codership Oy <info@codership.com> loaded succesfully.
130802 19:45:32 [Warning] WSREP: Could not open saved state file for reading: /mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/14/mysqldir/node2/mysqld.1/data//grastate.dat
130802 19:45:32 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
130802 19:45:32 [Note] WSREP: Preallocating 134219048/134219048 bytes in '/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/14/mysqldir/node2/mysqld.1/data//galera.cache'...
130802 19:45:32 [Note] WSREP: Passing config to GCS: base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; gcache.dir = /mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/14/mysqldir/node2/mysqld.1/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/14/mysqldir/node2/mysqld.1/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; gmcast.listen_addr = tcp://127.0.0.1:18008; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
130802 19:45:32 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
130802 19:45:32 [Note] WSREP: wsrep_sst_grab()
130802 19:45:32 [Note] WSREP: Start replication
130802 19:45:32 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
130802 19:45:32 [Note] WSREP: protonet asio version 0
130802 19:45:32 [Note] WSREP: backend: asio
130802 19:45:32 [Note] WSREP: GMCast version 0
130802 19:45:32 [Note] WSREP: (f286bfe0-fb92-11e2-85b8-9f005c430a65, 'tcp://127.0.0.1:18008') listening at tcp://127.0.0.1:18008
130802 19:45:32 [Note] WSREP: (f286bfe0-fb92-11e2-85b8-9f005c430a65, 'tcp://127.0.0.1:18008') multicast: , ttl: 1
130802 19:45:32 [Note] WSREP: EVS version 0
130802 19:45:32 [Note] WSREP: PC version 0
130802 19:45:32 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:15008'
130802 19:45:33 [Note] WSREP: declaring e55b79c3-fb92-11e2-b1f1-82d225192cc0 stable
130802 19:45:33 [Note] WSREP: Node e55b79c3-fb92-11e2-b1f1-82d225192cc0 state prim
130802 19:45:33 [Note] WSREP: view(view_id(PRIM,e55b79c3-fb92-11e2-b1f1-82d225192cc0,2) memb {
e55b79c3-fb92-11e2-b1f1-82d225192cc0,
f286bfe0-fb92-11e2-85b8-9f005c430a65,
} joined {
} left {
} partitioned {
})
130802 19:45:33 [Note] WSREP: gcomm: connected
130802 19:45:33 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
130802 19:45:33 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
130802 19:45:33 [Note] WSREP: Opened channel 'my_wsrep_cluster'
130802 19:45:33 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
130802 19:45:33 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
130802 19:45:33 [Note] WSREP: Waiting for SST to complete.
130802 19:45:33 [Note] WSREP: STATE EXCHANGE: sent state msg: f2d46526-fb92-11e2-980b-1bc1f66b971d
130802 19:45:33 [Note] WSREP: STATE EXCHANGE: got state msg: f2d46526-fb92-11e2-980b-1bc1f66b971d from 0 (jhc-new-centos6-64)
130802 19:45:33 [Note] WSREP: STATE EXCHANGE: got state msg: f2d46526-fb92-11e2-980b-1bc1f66b971d from 1 (jhc-new-centos6-64)
130802 19:45:33 [Note] WSREP: Quorum results:
version = 2,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 41,
last_appl. = -1,
protocols = 0/4/2 (gcs/repl/appl),
group UUID = e55c5e08-fb92-11e2-bdb3-636bb487f677
130802 19:45:33 [Note] WSREP: Flow-control interval: [23, 23]
130802 19:45:33 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 41)
130802 19:45:33 [Note] WSREP: State transfer required:
Group state: e55c5e08-fb92-11e2-bdb3-636bb487f677:41
Local state: 00000000-0000-0000-0000-000000000000:-1
130802 19:45:33 [Note] WSREP: New cluster view: global state: e55c5e08-fb92-11e2-bdb3-636bb487f677:41, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 2
130802 19:45:33 [Warning] WSREP: Gap in state sequence. Need state transfer.
130802 19:45:35 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:18007' --auth 'root:' --datadir '/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/14/mysqldir/node2/mysqld.1/data/' --defaults-file '/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/14/mysqldir/node2/my.cnf' --parent '12661''
130802 19:45:35 [Note] WSREP: Prepared SST request: rsync|127.0.0.1:18007/rsync_sst
130802 19:45:35 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130802 19:45:35 [Note] WSREP: Assign initial position for certification: 41, protocol version: 2
130802 19:45:35 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (e55c5e08-fb92-11e2-bdb3-636bb487f677): 1 (Operation not permitted)
at galera/src/replicator_str.cpp:prepare_for_IST():436. IST will be unavailable.
130802 19:45:35 [Note] WSREP: Node 1 (jhc-new-centos6-64) requested state transfer from '*any*'. Selected 0 (jhc-new-centos6-64)(SYNCED) as donor.
130802 19:45:35 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 41)
130802 19:45:35 [Note] WSREP: Requesting state transfer: success, donor: 0
130802 19:45:37 [Note] WSREP: 0 (jhc-new-centos6-64): State transfer to 1 (jhc-new-centos6-64) complete.
130802 19:45:37 [Note] WSREP: Member 0 (jhc-new-centos6-64) synced with group.
WSREP_SST: [INFO] Joiner cleanup. (20130802 19:45:38.068)
WSREP_SST: [INFO] Joiner cleanup done. (20130802 19:45:38.597)
130802 19:45:38 [Note] WSREP: SST complete, seqno: 41
130802 19:45:38 [Note] Plugin 'FEDERATED' is disabled.
130802 19:45:38 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
130802 19:45:38 InnoDB: The InnoDB memory heap is disabled
130802 19:45:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130802 19:45:38 InnoDB: Compressed tables use zlib 1.2.3
130802 19:45:38 InnoDB: Using Linux native AIO
130802 19:45:38 InnoDB: Initializing buffer pool, size = 32.0M
130802 19:45:38 InnoDB: Completed initialization of buffer pool
130802 19:45:38 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130802 19:45:38 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130802 19:45:38 InnoDB: Waiting for the background threads to start
130802 19:45:39 Percona XtraDB (http://www.percona.com) 5.5.32-rel31.0 started; log sequence number 28421083
130802 19:45:39 [Warning] 'user' entry 'root@jhc-new-centos6-64' ignored in --skip-name-resolve mode.
130802 19:45:39 [Warning] 'proxies_priv' entry '@ root@jhc-new-centos6-64' ignored in --skip-name-resolve mode.
130802 19:45:39 [Note] Event Scheduler: Loaded 0 events
130802 19:45:39 [Note] WSREP: Signalling provider to continue.
130802 19:45:39 [Note] WSREP: SST received: e55c5e08-fb92-11e2-bdb3-636bb487f677:41
130802 19:45:39 [Note] /mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.5.32-23.7.5-debug-log' socket: '/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/14/mysqldir/node2/socket.sock' port: 18001 Percona XtraDB Cluster (GPL) 5.5.32-23.7.5, Revision 500, wsrep_23.7.5.r3880
130802 19:45:39 [Note] WSREP: 1 (jhc-new-centos6-64): State transfer from 0 (jhc-new-centos6-64) complete.
130802 19:45:39 [Note] WSREP: Shifting JOINER -> JOINED (TO: 41)
130802 19:45:39 [Note] WSREP: Member 1 (jhc-new-centos6-64) synced with group.
130802 19:45:39 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 41)
130802 19:45:39 [Note] WSREP: Synchronized with group, ready for connections
130802 19:45:39 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
InnoDB: DEBUG: update_statistics for test/sbtest1.
130802 19:50:16 InnoDB: Assertion failure in thread 139767104726784 in file row0sel.c line 2724
InnoDB: Failing assertion: !rec_get_deleted_flag(rec, rec_offs_comp(offsets))
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
16:50:16 UTC - mysqld got signal 6 ;
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=1048576
read_buffer_size=131072
max_used_connections=18
max_threads=153
thread_count=18
connection_count=18
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61708 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x208d7b0
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 = 7f1e10a0dd68 thread_stack 0x40000
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(my_print_stacktrace+0x35)[0x80dd35]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x314)[0x6d2f38]
/lib64/libpthread.so.0[0x357ae0f500]
/lib64/libc.so.6(gsignal+0x35)[0x357a6328a5]
/lib64/libc.so.6(abort+0x175)[0x357a634085]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x8a5481]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x8a91b5]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x8694f9]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_ZN7handler14index_read_mapEPhPKhm16ha_rkey_function+0x4b)[0x6dd10b]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_ZN7handler18index_read_idx_mapEPhjPKhm16ha_rkey_function+0x5c)[0x6d38a8]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x5d8538]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x5e2080]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x5e5437]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_ZN4JOIN8optimizeEv+0x91f)[0x5e965b]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x64b)[0x5f3525]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x251)[0x5f3b15]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x5a680e]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_Z21mysql_execute_commandP3THD+0x766)[0x5acc72]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x225)[0x5b2a74]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld[0x5b2e2a]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xa2f)[0x5b459d]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_Z10do_commandP3THD+0x6e0)[0x5b674c]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x137)[0x65d5c6]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(handle_one_connection+0x52)[0x65d7c6]
/mnt/workspace/PXC-5.5-msysbench/BTYPE/debug/Host/centos6-64/Percona-XtraDB-Cluster-5.5.32-23.7.5.500.Linux.x86_64/bin/mysqld(pfs_spawn_thread+0x63)[0xa0e87e]
/lib64/libpthread.so.0[0x357ae07851]
/lib64/libc.so.6(clone+0x6d)[0x357a6e890d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f1dbc004bf0): SELECT c FROM sbtest1 WHERE id=50201
Connection ID (thread ID): 11
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.
Writing a core file
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment