Status information: Current dir: /var/lib/mysql/ Running threads: 82 Stack size: 294912 Current locks: lock: 0x2b1675aad140: read read : 0x2b166d6ea438 (26440106:2); lock: 0x2b16822aaa40: read read : 0x2b1677889438 (26440106:2); lock: 0x2b0c0d92b1c0: lock: 0x2b166a0ff200: lock: 0x2b167707cbc0: lock: 0x2b0cad89f680: lock: 0x2b0cab852340: lock: 0x1a1d3c0: lock: 0x1a1dcc0: lock: 0x1a1dbc0: lock: 0x1a1dac0: lock: 0x1a1d5c0: lock: 0x1a1d4c0: lock: 0x1a1d2c0: lock: 0x1a1d1c0: lock: 0x1a1d0c0: lock: 0x1a1ddc0: lock: 0x1a1d6c0: lock: 0x1a1d9c0: lock: 0x1a1d8c0: lock: 0x1a1d7c0: lock: 0x1a1cfc0: lock: 0x1a1cec0: lock: 0x1a1cdc0: Key caches: default Buffer_size: 32768 Block_size: 1024 Division_limit: 100 Age_threshold: 300 Partitions: 2 blocks used: 21 not flushed: 0 w_requests: 0 writes: 0 r_requests: 114 reads: 53 handler status: read_key: 22827813393 read_next: 177056538333 read_rnd 469904313 read_first: 402514 write: 264715364 delete 2326540 update: 50748061 Table status: Opened tables: 21759 Open tables: 14 Open files: 37 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 Thread database.table_name Locked/Waiting Lock_type 26440106products.api_checkouts Locked - read Low priority read lock 26440106wepay.payment_requests Locked - read Low priority read lock 131020 4:02:03 [Warning] 'proxies_priv' entry '@ root@WPDB01' ignored in --skip-name-resolve mode. Memory status: Non-mmapped space allocated from system: 0 Number of free chunks: 1 Number of fastbin blocks: 0 Number of mmapped regions: 0 Space in mmapped regions: 0 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 0 Total free space: 0 Top-most, releasable space: 0 Estimated memory (with thread stack): 24182784 Events status: LLA = Last Locked At LUA = Last Unlocked At WOC = Waiting On Condition DL = Data Locked Event scheduler status: State : INITIALIZED Thread id : 0 LLA : n/a:0 LUA : n/a:0 WOC : NO Workers : 0 Executed : 0 Data locked: NO Event queue status: Element count : 0 Data locked : NO Attempting lock : NO LLA : init_queue:139 LUA : init_queue:149 WOC : NO Next activation : never 131020 4:16:50 [Note] WSREP: declaring afad2e3e-2d74-11e3-918d-0fac699eec8d stable 131020 4:16:50 [Note] WSREP: (4673afc6-2d77-11e3-a67e-4325bb74bc70, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: ssl://10.240.170.41:4567 131020 4:16:50 [Note] WSREP: Node 4673afc6-2d77-11e3-a67e-4325bb74bc70 state prim 131020 4:16:50 [Note] WSREP: view(view_id(PRIM,4673afc6-2d77-11e3-a67e-4325bb74bc70,72) memb { 4673afc6-2d77-11e3-a67e-4325bb74bc70, afad2e3e-2d74-11e3-918d-0fac699eec8d, } joined { } left { } partitioned { 7827c5d2-3698-11e3-8066-72fa81778397, }) 131020 4:16:50 [Note] WSREP: forgetting 7827c5d2-3698-11e3-8066-72fa81778397 (ssl://10.240.170.41:4567) 131020 4:16:50 [Note] WSREP: (4673afc6-2d77-11e3-a67e-4325bb74bc70, 'ssl://0.0.0.0:4567') turning message relay requesting off 131020 4:16:50 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 131020 4:16:50 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 71b27924-393e-11e3-83d8-cf4abc36e336 131020 4:16:50 [Note] WSREP: STATE EXCHANGE: sent state msg: 71b27924-393e-11e3-83d8-cf4abc36e336 131020 4:16:50 [Note] WSREP: STATE EXCHANGE: got state msg: 71b27924-393e-11e3-83d8-cf4abc36e336 from 0 (wpdb01) 131020 4:16:50 [Note] WSREP: STATE EXCHANGE: got state msg: 71b27924-393e-11e3-83d8-cf4abc36e336 from 1 (wpdb03) 131020 4:16:50 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 69, members = 2/2 (joined/total), act_id = 712768647, last_appl. = 712767798, protocols = 0/4/2 (gcs/repl/appl), group UUID = a708f854-bc4e-11e2-0800-646d4bde0af7 131020 4:16:50 [Note] WSREP: Flow-control interval: [23, 23] 131020 4:16:56 [Note] WSREP: cleaning up 7827c5d2-3698-11e3-8066-72fa81778397 (ssl://10.240.170.41:4567) 131020 4:17:11 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.240.170.41:49227 local endpoint ssl://10.240.170.40:4567 cipher: AES128-SHA compression: 131020 4:17:11 [Note] WSREP: declaring 7e2f5e7e-393e-11e3-b54d-4e249af235bd stable 131020 4:17:11 [Note] WSREP: declaring afad2e3e-2d74-11e3-918d-0fac699eec8d stable 131020 4:17:11 [Note] WSREP: Node 4673afc6-2d77-11e3-a67e-4325bb74bc70 state prim 131020 4:17:11 [Note] WSREP: view(view_id(PRIM,4673afc6-2d77-11e3-a67e-4325bb74bc70,73) memb { 4673afc6-2d77-11e3-a67e-4325bb74bc70, 7e2f5e7e-393e-11e3-b54d-4e249af235bd, afad2e3e-2d74-11e3-918d-0fac699eec8d, } joined { } left { } partitioned { }) 131020 4:17:11 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 131020 4:17:11 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 7e3b10c0-393e-11e3-b34e-5f0f6b2427d6 131020 4:17:11 [Note] WSREP: STATE EXCHANGE: sent state msg: 7e3b10c0-393e-11e3-b34e-5f0f6b2427d6 131020 4:17:11 [Note] WSREP: STATE EXCHANGE: got state msg: 7e3b10c0-393e-11e3-b34e-5f0f6b2427d6 from 0 (wpdb01) 131020 4:17:11 [Note] WSREP: STATE EXCHANGE: got state msg: 7e3b10c0-393e-11e3-b34e-5f0f6b2427d6 from 2 (wpdb03) 131020 4:17:12 [Note] WSREP: STATE EXCHANGE: got state msg: 7e3b10c0-393e-11e3-b34e-5f0f6b2427d6 from 1 (wpdb02) 131020 4:17:12 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 70, members = 2/3 (joined/total), act_id = 712768650, last_appl. = 712767798, protocols = 0/4/2 (gcs/repl/appl), group UUID = a708f854-bc4e-11e2-0800-646d4bde0af7 131020 4:17:12 [Note] WSREP: Flow-control interval: [28, 28] 131020 4:18:09 [Note] /usr/sbin/mysqld: Normal shutdown 131020 4:18:09 [Note] WSREP: Stop replication 131020 4:18:09 [Note] WSREP: Closing send monitor... 131020 4:18:09 [Note] WSREP: cluster conflict due to certification failure for threads: 131020 4:18:09 [Note] WSREP: cluster conflict due to certification failure for threads: 131020 4:18:09 [Note] WSREP: Victim thread: THD: 26478760, mode: local, state: executing, conflict: cert failure, seqno: -1 ====== ACTUAL QUERIES REDACTED: there were about 50 errors "cert failure" 131020 4:18:09 [Note] WSREP: gcomm: closed 131020 4:18:09 [Note] WSREP: Flow-control interval: [16, 16] 131020 4:18:09 [Note] WSREP: Received NON-PRIMARY. 131020 4:18:09 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 712768654) 131020 4:18:09 [Note] WSREP: Received self-leave message. 131020 4:18:09 [Note] WSREP: Flow-control interval: [0, 0] 131020 4:18:09 [Note] WSREP: Received SELF-LEAVE. Closing connection. 131020 4:18:09 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 712768654) 131020 4:18:09 [Note] WSREP: RECV thread exiting 0: Success 131020 4:18:09 [Note] WSREP: recv_thread() joined. 131020 4:18:09 [Note] WSREP: Closing replication queue. 131020 4:18:09 [Note] WSREP: Closing slave action queue. 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) 131020 4:18:09 [Warning] WSREP: gcs_caused() returned -103 (Software caused connection abort) InnoDB: Warning: a long semaphore wait: --Thread 47376117594432 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333438163264 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333377943872 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378275346752 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47373329250624 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333375551808 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333439658304 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47373329848640 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376131049792 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376125667648 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378273253696 has waited at btr0cur.c line 568 for 241.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376111315264 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376119687488 has waited at btr0cur.c line 568 for 241.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376129554752 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376403409216 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376403708224 has waited at row0row.c line 716 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 InnoDB: Warning: a long semaphore wait: --Thread 47376120584512 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378281326912 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376401914176 has waited at row0row.c line 716 for 241.00 seconds the semaphore: X-lock on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 InnoDB: Warning: a long semaphore wait: --Thread 47375251257664 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376138225984 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376134637888 has waited at lock0lock.c line 3419 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376432470336 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376686827840 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333432772928 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378259798336 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376116099392 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376113408320 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47375253051712 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376121182528 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376130152768 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376139721024 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333377046848 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376131946816 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376947718464 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376402512192 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333442050368 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47375251556672 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333444741440 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376836626752 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376980728128 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333379139904 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376138824000 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333441153344 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47377651841344 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376134936896 has waited at btr0cur.c line 575 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333443246400 has waited at ha_innodb.cc line 3982 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333441452352 has waited at trx0trx.c line 941 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333432174912 has waited at lock0lock.c line 3419 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376686528832 has waited at trx0trx.c line 941 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376400419136 has waited at lock0lock.c line 3238 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333440256320 has waited at lock0lock.c line 3419 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376433068352 has waited at trx0trx.c line 941 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47378268469568 has waited at lock0lock.c line 3454 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376119986496 has waited at lock0lock.c line 3419 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333626116416 has waited at trx0trx.c line 941 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333624621376 has waited at trx0trx.c line 941 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333624322368 has waited at trx0trx.c line 941 for 241.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 131020 4:22:13 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 45 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 7680342 1_second, 7678641 sleeps, 767769 10_second, 14781 background, 14283 flush srv_master_thread log flush and writes: 1277219 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 30444790, signal count 57907948 --Thread 47376117594432 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333438163264 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333377943872 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47378275346752 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47373329250624 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333375551808 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333439658304 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47373329848640 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376131049792 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376125667648 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47378273253696 has waited at btr0cur.c line 568 for 244.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376111315264 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376119687488 has waited at btr0cur.c line 568 for 244.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376129554752 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376403409216 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376403708224 has waited at row0row.c line 716 for 244.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 --Thread 47376120584512 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47378281326912 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376401914176 has waited at row0row.c line 716 for 244.00 seconds the semaphore: X-lock on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 --Thread 47375251257664 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376138225984 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376134637888 has waited at lock0lock.c line 3419 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376432470336 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376686827840 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333432772928 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47378259798336 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376116099392 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376113408320 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47375253051712 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376121182528 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376130152768 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376139721024 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333377046848 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376131946816 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376947718464 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376402512192 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333442050368 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47375251556672 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333444741440 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376836626752 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376980728128 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333379139904 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376138824000 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333441153344 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47377651841344 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47376134936896 has waited at btr0cur.c line 575 for 244.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 --Thread 47333443246400 has waited at ha_innodb.cc line 3982 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47333441452352 has waited at trx0trx.c line 941 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47333432174912 has waited at lock0lock.c line 3419 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376686528832 has waited at trx0trx.c line 941 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376400419136 has waited at lock0lock.c line 3238 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47333440256320 has waited at lock0lock.c line 3419 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376433068352 has waited at trx0trx.c line 941 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47378268469568 has waited at lock0lock.c line 3454 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376119986496 has waited at lock0lock.c line 3419 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47333626116416 has waited at trx0trx.c line 941 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47333624621376 has waited at trx0trx.c line 941 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47333624322368 has waited at trx0trx.c line 941 for 244.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376098158912 has waited at trx0purge.c line 1154 for 243.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2b0c0c83a898 '&purge_sys->latch' a writer (thread id 47376098158912) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0vers.c line 361 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/trx/trx0purge.c line 1154 --Thread 47376087669056 has waited at row0mysql.c line 2352 for 243.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376045709632 has waited at srv0srv.c line 2905 for 243.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 --Thread 47376952203584 has waited at row0vers.c line 514 for 242.00 seconds the semaphore: S-lock on RW-latch at 0x2b0c0c83a898 '&purge_sys->latch' a writer (thread id 47376098158912) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0vers.c line 361 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/trx/trx0purge.c line 1154 Mutex spin waits 517253945, rounds 810917117, OS waits 9024036 RW-shared spins 159605416, rounds 982753285, OS waits 20627956 RW-excl spins 335313, rounds 56147027, OS waits 473318 Spin rounds per wait: 1.57 mutex, 6.16 RW-shared, 167.45 RW-excl -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 143982187 OS file reads, 326608650 OS file writes, 220227609 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 26006, seg size 26008, 23581730 merges merged operations: insert 44219175, delete mark 4116280, delete 518993 discarded operations: insert 26768, delete mark 159, delete 159 Hash table size 76499243, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 1630050838556 Log flushed up to 1630050838556 Last checkpoint at 1630050585473 Max checkpoint age 108005254 Checkpoint age target 104630090 Modified age 253083 Checkpoint age 253083 0 pending log writes, 0 pending chkp writes 199650957 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 39692795904; in additional pool allocated 0 Total memory allocated by read views 27264 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 47376117594432 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333438163264 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333377943872 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378275346752 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47373329250624 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333375551808 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333439658304 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47373329848640 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376131049792 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376125667648 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378273253696 has waited at btr0cur.c line 568 for 272.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376111315264 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376119687488 has waited at btr0cur.c line 568 for 272.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376129554752 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376403409216 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376403708224 has waited at row0row.c line 716 for 272.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 InnoDB: Warning: a long semaphore wait: --Thread 47376120584512 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378281326912 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376401914176 has waited at row0row.c line 716 for 272.00 seconds the semaphore: X-lock on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 InnoDB: Warning: a long semaphore wait: --Thread 47375251257664 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376138225984 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376134637888 has waited at lock0lock.c line 3419 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376432470336 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376686827840 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333432772928 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378259798336 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376116099392 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376113408320 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47375253051712 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376121182528 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376130152768 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376139721024 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333377046848 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376131946816 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376947718464 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376402512192 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333442050368 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47375251556672 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333444741440 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376836626752 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376980728128 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333379139904 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376138824000 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333441153344 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47377651841344 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376134936896 has waited at btr0cur.c line 575 for 272.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333443246400 has waited at ha_innodb.cc line 3982 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333441452352 has waited at trx0trx.c line 941 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333432174912 has waited at lock0lock.c line 3419 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376686528832 has waited at trx0trx.c line 941 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376400419136 has waited at lock0lock.c line 3238 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333440256320 has waited at lock0lock.c line 3419 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376433068352 has waited at trx0trx.c line 941 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47378268469568 has waited at lock0lock.c line 3454 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376119986496 has waited at lock0lock.c line 3419 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333626116416 has waited at trx0trx.c line 941 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333624621376 has waited at trx0trx.c line 941 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333624322368 has waited at trx0trx.c line 941 for 272.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376098158912 has waited at trx0purge.c line 1154 for 271.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2b0c0c83a898 '&purge_sys->latch' a writer (thread id 47376098158912) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0vers.c line 361 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/trx/trx0purge.c line 1154 InnoDB: Warning: a long semaphore wait: --Thread 47376087669056 has waited at row0mysql.c line 2352 for 271.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376045709632 has waited at srv0srv.c line 2905 for 271.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376952203584 has waited at row0vers.c line 514 for 270.00 seconds the semaphore: S-lock on RW-latch at 0x2b0c0c83a898 '&purge_sys->latch' a writer (thread id 47376098158912) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0vers.c line 361 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/trx/trx0purge.c line 1154 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 47376117594432 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333438163264 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333377943872 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378275346752 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47373329250624 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333375551808 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333439658304 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47373329848640 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376131049792 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376125667648 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378273253696 has waited at btr0cur.c line 568 for 303.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376111315264 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376119687488 has waited at btr0cur.c line 568 for 303.00 seconds the semaphore: X-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376129554752 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376403409216 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376403708224 has waited at row0row.c line 716 for 303.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 InnoDB: Warning: a long semaphore wait: --Thread 47376120584512 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378281326912 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376401914176 has waited at row0row.c line 716 for 303.00 seconds the semaphore: X-lock on RW-latch at 0x2b0ce92a99b0 '&block->lock' a writer (thread id 47376403708224) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0umod.c line 318 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/row/row0row.c line 716 InnoDB: Warning: a long semaphore wait: --Thread 47375251257664 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376138225984 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376134637888 has waited at lock0lock.c line 3419 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376432470336 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376686827840 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333432772928 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47378259798336 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376116099392 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376113408320 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47375253051712 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376121182528 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376130152768 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376139721024 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333377046848 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376131946816 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376947718464 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376402512192 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333442050368 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47375251556672 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333444741440 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376836626752 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376980728128 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333379139904 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376138824000 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333441153344 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47377651841344 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b162db5d578 '&new_index->lock' a writer (thread id 47376134637888) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47376134936896 has waited at btr0cur.c line 575 for 303.00 seconds the semaphore: S-lock on RW-latch at 0x2b166a0b6b78 '&new_index->lock' a writer (thread id 47376119986496) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr0cur.c line 575 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/btr/btr0cur.c line 568 InnoDB: Warning: a long semaphore wait: --Thread 47333443246400 has waited at ha_innodb.cc line 3982 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333441452352 has waited at trx0trx.c line 941 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333432174912 has waited at lock0lock.c line 3419 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376686528832 has waited at trx0trx.c line 941 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376400419136 has waited at lock0lock.c line 3238 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333440256320 has waited at lock0lock.c line 3419 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376433068352 has waited at trx0trx.c line 941 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47378268469568 has waited at lock0lock.c line 3454 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376119986496 has waited at lock0lock.c line 3419 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333626116416 has waited at trx0trx.c line 941 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333624621376 has waited at trx0trx.c line 941 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47333624322368 has waited at trx0trx.c line 941 for 303.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376098158912 has waited at trx0purge.c line 1154 for 302.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2b0c0c83a898 '&purge_sys->latch' a writer (thread id 47376098158912) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0vers.c line 361 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/trx/trx0purge.c line 1154 InnoDB: Warning: a long semaphore wait: --Thread 47376087669056 has waited at row0mysql.c line 2352 for 302.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376045709632 has waited at srv0srv.c line 2905 for 302.00 seconds the semaphore: Mutex at 0x2b0c0cbfc138 '&kernel_mutex', lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 47376952203584 has waited at row0vers.c line 514 for 301.00 seconds the semaphore: S-lock on RW-latch at 0x2b0c0c83a898 '&purge_sys->latch' a writer (thread id 47376098158912) has reserved it in mode wait exclusive number of readers 4, waiters flag 1, lock_word: fffffffffffffffc Last time read locked in file row0vers.c line 361 Last time write locked in file /home/sites/rpmbuild/mariadb-5.5.33a/storage/xtradb/trx/trx0purge.c line 1154 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream 131020 04:25:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131020 04:25:55 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.AyMopd8834 --pid-file=/var/lib/mysql/WPDB01-recover.pid 131020 04:26:12 mysqld_safe WSREP: Recovered position a708f854-bc4e-11e2-0800-646d4bde0af7:712768490 131020 4:26:13 [Note] WSREP: wsrep_start_position var submitted: 'a708f854-bc4e-11e2-0800-646d4bde0af7:712768490' 131020 4:26:13 [Note] WSREP: Read nil XID from storage engines, skipping position init 131020 4:26:13 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 131020 4:26:13 [Note] WSREP: wsrep_load(): Galera 2.7(rXXXX) by Codership Oy loaded succesfully. 131020 4:26:13 [Note] WSREP: Found saved state: a708f854-bc4e-11e2-0800-646d4bde0af7:-1 131020 4:26:13 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'. 131020 4:26:13 [Note] WSREP: Passing config to GCS: base_host = 10.240.170.40; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 2G; 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 = 1; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3; socket.ssl_ca = /etc/my.ssl/cacert.pem; socket.ssl_cert = /etc/my.ssl/rel-mysql-client.crt; socket.ssl_key = /etc/my.ssl/rel-mysql-client-nopwd.key 131020 4:26:13 [Note] WSREP: Assign initial position for certification: 712768490, protocol version: -1 131020 4:26:13 [Note] WSREP: wsrep_sst_grab() 131020 4:26:13 [Note] WSREP: Start replication 131020 4:26:13 [Note] WSREP: Setting initial position to a708f854-bc4e-11e2-0800-646d4bde0af7:712768490 131020 4:26:13 [Note] WSREP: protonet asio version 0 131020 4:26:13 [Note] WSREP: initializing ssl context 131020 4:26:13 [Note] WSREP: backend: asio 131020 4:26:13 [Note] WSREP: GMCast version 0 131020 4:26:13 [Note] WSREP: (c0d9e432-393f-11e3-ac25-e7b451402b21, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567 131020 4:26:13 [Note] WSREP: (c0d9e432-393f-11e3-ac25-e7b451402b21, 'ssl://0.0.0.0:4567') multicast: , ttl: 1 131020 4:26:13 [Note] WSREP: EVS version 0 131020 4:26:13 [Note] WSREP: PC version 0 131020 4:26:13 [Note] WSREP: gcomm: connecting to group 'wepay', peer '10.240.170.41:,10.240.170.43:' 131020 4:26:13 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.240.170.41:4567 local endpoint ssl://10.240.170.40:60222 cipher: AES128-SHA compression: 131020 4:26:13 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.240.170.43:4567 local endpoint ssl://10.240.170.40:40022 cipher: AES128-SHA compression: 131020 4:26:13 [Note] WSREP: declaring 7e2f5e7e-393e-11e3-b54d-4e249af235bd stable 131020 4:26:13 [Note] WSREP: declaring afad2e3e-2d74-11e3-918d-0fac699eec8d stable 131020 4:26:13 [Note] WSREP: Node 7e2f5e7e-393e-11e3-b54d-4e249af235bd state prim 131020 4:26:13 [Note] WSREP: view(view_id(PRIM,7e2f5e7e-393e-11e3-b54d-4e249af235bd,75) memb { 7e2f5e7e-393e-11e3-b54d-4e249af235bd, afad2e3e-2d74-11e3-918d-0fac699eec8d, c0d9e432-393f-11e3-ac25-e7b451402b21, } joined { } left { } partitioned { }) 131020 4:26:13 [Note] WSREP: gcomm: connected 131020 4:26:13 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 131020 4:26:13 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 131020 4:26:13 [Note] WSREP: Opened channel 'wepay' 131020 4:26:13 [Note] WSREP: Waiting for SST to complete. 131020 4:26:13 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 131020 4:26:13 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 131020 4:26:13 [Note] WSREP: STATE EXCHANGE: sent state msg: c0e24f78-393f-11e3-aa99-e744b03a570b 131020 4:26:13 [Note] WSREP: STATE EXCHANGE: got state msg: c0e24f78-393f-11e3-aa99-e744b03a570b from 0 (wpdb02) 131020 4:26:13 [Note] WSREP: STATE EXCHANGE: got state msg: c0e24f78-393f-11e3-aa99-e744b03a570b from 1 (wpdb03) 131020 4:26:13 [Note] WSREP: STATE EXCHANGE: got state msg: c0e24f78-393f-11e3-aa99-e744b03a570b from 2 (wpdb01) 131020 4:26:13 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 72, members = 2/3 (joined/total), act_id = 712794792, last_appl. = -1, protocols = 0/4/2 (gcs/repl/appl), group UUID = a708f854-bc4e-11e2-0800-646d4bde0af7 131020 4:26:13 [Note] WSREP: Flow-control interval: [28, 28] 131020 4:26:13 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 712794792) 131020 4:26:13 [Note] WSREP: State transfer required: Group state: a708f854-bc4e-11e2-0800-646d4bde0af7:712794792 Local state: a708f854-bc4e-11e2-0800-646d4bde0af7:712768490 131020 4:26:13 [Note] WSREP: New cluster view: global state: a708f854-bc4e-11e2-0800-646d4bde0af7:712794792, view# 73: Primary, number of nodes: 3, my index: 2, protocol version 2 131020 4:26:13 [Warning] WSREP: Gap in state sequence. Need state transfer. 131020 4:26:15 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'joiner' --address '10.240.170.40' --auth 'root:tV&qm.%@ww-t[w5M' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '8952'' WSREP_SST: [INFO] Streaming with tar (20131020 04:26:15.775) WSREP_SST: [INFO] Note: Advanced xtrabackup features - encryption,compression etc. not available with tar. (20131020 04:26:15.776) WSREP_SST: [INFO] However, xbstream requires manual cleanup of data directory before SST - lp:1193240. (20131020 04:26:15.778) 131020 4:26:16 [Note] WSREP: Prepared SST request: xtrabackup|10.240.170.40:4444/xtrabackup_sst 131020 4:26:16 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 131020 4:26:16 [Note] WSREP: Assign initial position for certification: 712794792, protocol version: 2 131020 4:26:16 [Note] WSREP: IST receiver using ssl 131020 4:26:16 [Note] WSREP: Prepared IST receiver, listening at: ssl://10.240.170.40:4568 131020 4:26:16 [Note] WSREP: Node 2 (wpdb01) requested state transfer from 'wpdb02'. Selected 0 (wpdb02)(SYNCED) as donor. 131020 4:26:16 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 712794864) 131020 4:26:16 [Note] WSREP: Requesting state transfer: success, donor: 0 131020 07:38:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131020 07:38:04 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.LBEDA14773 --pid-file=/var/lib/mysql/WPDB01-recover.pid 131020 07:38:13 mysqld_safe WSREP: Failed to recover position: '131020 7:38:04 InnoDB: The InnoDB memory heap is disabled 131020 7:38:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131020 7:38:04 InnoDB: Compressed tables use zlib 1.2.3 131020 7:38:04 InnoDB: Using Linux native AIO 131020 7:38:04 InnoDB: Initializing buffer pool, size = 36.0G 131020 7:38:07 InnoDB: Completed initialization of buffer pool 131020 7:38:07 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! 131020 7:38:08 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... InnoDB: 101 transaction(s) which must be rolled back or cleaned up InnoDB: in total 139 row operations to undo InnoDB: Trx id counter is 7C62E900 InnoDB: Last MySQL binlog file position 0 23578346, file name /var/lib/mysql/mysql-bin.001255 InnoDB: Cleaning up trx with id 7C630396 InnoDB: Cleaning up trx with id 7C63033A InnoDB: Cleaning up trx with id 7C630255 InnoDB: Cleaning up trx with id 7C6301AF InnoDB: Cleaning up trx with id 7C62FF87 InnoDB: Cleaning up trx with id 7C62FF5F InnoDB: Cleaning up trx with id 7C62FF0D InnoDB: Cleaning up trx with id 7C62FDF6 InnoDB: Cleaning up trx with id 7C62FDD6 InnoDB: Cleaning up trx with id 7C62FD9C InnoDB: Cleaning up trx with id 7C62FD64 InnoDB: Cleaning up trx with id 7C62FC6A InnoDB: Cleaning up trx with id 7C62FC60 InnoDB: Cleaning up trx with id 7C62FB98 InnoDB: Cleaning up trx with id 7C62FB36 InnoDB: Cleaning up trx with id 7C62FA4B InnoDB: Cleaning up trx with id 7C62F9E1 InnoDB: Cleaning up trx with id 7C62F94D InnoDB: Cleaning up trx with id 7C62F8E0 InnoDB: Cleaning up trx with id 7C62F7BC InnoDB: Cleaning up trx with id 7C62F793 InnoDB: Cleaning up trx with id 7C62F6A8 InnoDB: Cleaning up trx with id 7C62F690 InnoDB: Cleaning up trx with id 7C62F655 InnoDB: Cleaning up trx with id 7C62F609 InnoDB: Cleaning up trx with id 7C62F4FE InnoDB: Cleaning up trx with id 7C62F4DF InnoDB: Cleaning up trx with id 7C62F4B4 InnoDB: Cleaning up trx with id 7C62F47B InnoDB: Cleaning up trx with id 7C62F473 InnoDB: Cleaning up trx with id 7C62F3D2 InnoDB: Cleaning up trx with id 7C62F38E InnoDB: Cleaning up trx with id 7C62EECD InnoDB: Cleaning up trx with id 7C62EE8A InnoDB: Cleaning up trx with id 7C62EE6B InnoDB: Cleaning up trx with id 7C62ED79 InnoDB: Cleaning up trx with id 7C62ED14 InnoDB: Cleaning up trx with id 7C62EC14 InnoDB: Cleaning up trx with id 7C62EBB5 InnoDB: Cleaning up trx with id 7C62EB8E InnoDB: Cleaning up trx with id 7C62EA49 InnoDB: Cleaning up trx with id 7C62E598 InnoDB: Cleaning up trx with id 7C62E335 InnoDB: Cleaning up trx with id 7C62E186 InnoDB: Cleaning up trx with id 7C62E0C9 InnoDB: Cleaning up trx with id 7C62E0B8 InnoDB: Cleaning up trx with id 7C62E0B6 InnoDB: Cleaning up trx with id 7C62E0AB InnoDB: Cleaning up trx with id 7C62E081 InnoDB: Cleaning up trx with id 7C62DC95 InnoDB: Cleaning up trx with id 7C62DA51 InnoDB: Cleaning up trx with id 7C62D98E InnoDB: Cleaning up trx with id 7C62D986 InnoDB: Cleaning up trx with id 7C62D8F9 InnoDB: Cleaning up trx with id 7C62D8D0 InnoDB: Cleaning up trx with id 7C62D8C9 InnoDB: Cleaning up trx with id 7C62D6B8 InnoDB: Cleaning up trx with id 7C62D44F InnoDB: Cleaning up trx with id 7C62D3AB InnoDB: Cleaning up trx with id 7C62D393 InnoDB: Cleaning up trx with id 7C62D383 InnoDB: Cleaning up trx with id 7C62D2E4 InnoDB: Cleaning up trx with id 7C62D2E1 InnoDB: Cleaning up trx with id 7C62D22C InnoDB: Cleaning up trx with id 7C62D220 InnoDB: Cleaning up trx with id 7C62D0CE InnoDB: Cleaning up trx with id 7C62CED4 InnoDB: Cleaning up trx with id 7C62CEA7 InnoDB: Cleaning up trx with id 7C62CE89 InnoDB: Cleaning up trx with id 7C62CBDF InnoDB: Cleaning up trx with id 7C62CBDD InnoDB: Cleaning up trx with id 7C6160DE 131020 7:38:12 InnoDB: Assertion failure in thread 47736910333680 in file fsp0fsp.c line 3566 InnoDB: Failing assertion: xdes_get_bit(descr, XDES_FREE_BIT, header_page % FSP_EXTENT_SIZE, mtr) == FALSE 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. 131020 7:38:12 [ERROR] 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. 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.33a-MariaDB-log key_buffer_size=32768 read_buffer_size=32768 max_used_connections=0 max_threads=402 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9899778 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 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 = 0x0 thread_stack 0x48000 ??:0(my_print_stacktrace)[0xaad47e] ??:0(handle_fatal_signal)[0x6ec1db] ??:0(??)[0x337e00eca0] ??:0(??)[0x337d830265] ??:0(??)[0x337d831d10] ??:0(fseg_free_step)[0xa04d14] ??:0(trx_undo_seg_free)[0x995ff2] ??:0(trx_undo_insert_cleanup)[0x996b10] ??:0(trx_cleanup_at_db_startup)[0x98fa6b] ??:0(trx_rollback_or_clean_recovered)[0x988c4d] ??:0(recv_recovery_from_checkpoint_finish)[0xa31ad5] ??:0(innobase_start_or_create_for_mysql)[0x977c1f] ??:0(_ZL13innobase_initPv)[0x933622] ??:0(ha_initialize_handlerton(st_plugin_int*))[0x6ee798] ??:0(_ZL17plugin_initializeP13st_plugin_int)[0x5a285b] ??:0(plugin_init(int*, char**, int))[0x5a4f7d] ??:0(_ZL22init_server_componentsv)[0x50d49c] ??:0(mysqld_main(int, char**))[0x50f953] ??:0(??)[0x337d81d9c4] ??:0(_start)[0x504f49] 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.' 131020 07:56:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131020 07:56:57 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.mScAR20221 --pid-file=/var/lib/mysql/WPDB01-recover.pid 131020 07:57:05 mysqld_safe WSREP: Failed to recover position: '131020 7:56:58 InnoDB: The InnoDB memory heap is disabled 131020 7:56:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131020 7:56:58 InnoDB: Compressed tables use zlib 1.2.3 131020 7:56:58 InnoDB: Using Linux native AIO 131020 7:56:58 InnoDB: Initializing buffer pool, size = 36.0G 131020 7:57:01 InnoDB: Completed initialization of buffer pool 131020 7:57:01 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! 131020 7:57:01 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... InnoDB: 101 transaction(s) which must be rolled back or cleaned up InnoDB: in total 139 row operations to undo InnoDB: Trx id counter is 7C62E900 InnoDB: Last MySQL binlog file position 0 23578346, file name /var/lib/mysql/mysql-bin.001255 InnoDB: Cleaning up trx with id 7C630396 InnoDB: Cleaning up trx with id 7C63033A InnoDB: Cleaning up trx with id 7C630255 InnoDB: Cleaning up trx with id 7C6301AF InnoDB: Cleaning up trx with id 7C62FF87 InnoDB: Cleaning up trx with id 7C62FF5F InnoDB: Cleaning up trx with id 7C62FF0D InnoDB: Cleaning up trx with id 7C62FDF6 InnoDB: Cleaning up trx with id 7C62FDD6 InnoDB: Cleaning up trx with id 7C62FD9C InnoDB: Cleaning up trx with id 7C62FD64 InnoDB: Cleaning up trx with id 7C62FC6A InnoDB: Cleaning up trx with id 7C62FC60 InnoDB: Cleaning up trx with id 7C62FB98 InnoDB: Cleaning up trx with id 7C62FB36 InnoDB: Cleaning up trx with id 7C62FA4B InnoDB: Cleaning up trx with id 7C62F9E1 InnoDB: Cleaning up trx with id 7C62F94D InnoDB: Cleaning up trx with id 7C62F8E0 InnoDB: Cleaning up trx with id 7C62F7BC InnoDB: Cleaning up trx with id 7C62F793 InnoDB: Cleaning up trx with id 7C62F6A8 InnoDB: Cleaning up trx with id 7C62F690 InnoDB: Cleaning up trx with id 7C62F655 InnoDB: Cleaning up trx with id 7C62F609 InnoDB: Cleaning up trx with id 7C62F4FE InnoDB: Cleaning up trx with id 7C62F4DF InnoDB: Cleaning up trx with id 7C62F4B4 InnoDB: Cleaning up trx with id 7C62F47B InnoDB: Cleaning up trx with id 7C62F473 InnoDB: Cleaning up trx with id 7C62F3D2 InnoDB: Cleaning up trx with id 7C62F38E InnoDB: Cleaning up trx with id 7C62EECD InnoDB: Cleaning up trx with id 7C62EE8A InnoDB: Cleaning up trx with id 7C62EE6B InnoDB: Cleaning up trx with id 7C62ED79 InnoDB: Cleaning up trx with id 7C62ED14 InnoDB: Cleaning up trx with id 7C62EC14 InnoDB: Cleaning up trx with id 7C62EBB5 InnoDB: Cleaning up trx with id 7C62EB8E InnoDB: Cleaning up trx with id 7C62EA49 InnoDB: Cleaning up trx with id 7C62E598 InnoDB: Cleaning up trx with id 7C62E335 InnoDB: Cleaning up trx with id 7C62E186 InnoDB: Cleaning up trx with id 7C62E0C9 InnoDB: Cleaning up trx with id 7C62E0B8 InnoDB: Cleaning up trx with id 7C62E0B6 InnoDB: Cleaning up trx with id 7C62E0AB InnoDB: Cleaning up trx with id 7C62E081 InnoDB: Cleaning up trx with id 7C62DC95 InnoDB: Cleaning up trx with id 7C62DA51 InnoDB: Cleaning up trx with id 7C62D98E InnoDB: Cleaning up trx with id 7C62D986 InnoDB: Cleaning up trx with id 7C62D8F9 InnoDB: Cleaning up trx with id 7C62D8D0 InnoDB: Cleaning up trx with id 7C62D8C9 InnoDB: Cleaning up trx with id 7C62D6B8 InnoDB: Cleaning up trx with id 7C62D44F InnoDB: Cleaning up trx with id 7C62D3AB InnoDB: Cleaning up trx with id 7C62D393 InnoDB: Cleaning up trx with id 7C62D383 InnoDB: Cleaning up trx with id 7C62D2E4 InnoDB: Cleaning up trx with id 7C62D2E1 InnoDB: Cleaning up trx with id 7C62D22C InnoDB: Cleaning up trx with id 7C62D220 InnoDB: Cleaning up trx with id 7C62D0CE InnoDB: Cleaning up trx with id 7C62CED4 InnoDB: Cleaning up trx with id 7C62CEA7 InnoDB: Cleaning up trx with id 7C62CE89 InnoDB: Cleaning up trx with id 7C62CBDF InnoDB: Cleaning up trx with id 7C62CBDD InnoDB: Cleaning up trx with id 7C6160DE 131020 7:57:04 InnoDB: Assertion failure in thread 47248202143472 in file fsp0fsp.c line 3566 InnoDB: Failing assertion: xdes_get_bit(descr, XDES_FREE_BIT, header_page % FSP_EXTENT_SIZE, mtr) == FALSE 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. 131020 7:57:04 [ERROR] 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. 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.33a-MariaDB-log key_buffer_size=32768 read_buffer_size=32768 max_used_connections=0 max_threads=402 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9899778 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 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 = 0x0 thread_stack 0x48000 ??:0(my_print_stacktrace)[0xaad47e] ??:0(handle_fatal_signal)[0x6ec1db] ??:0(??)[0x337e00eca0] ??:0(??)[0x337d830265] ??:0(??)[0x337d831d10] ??:0(fseg_free_step)[0xa04d14] ??:0(trx_undo_seg_free)[0x995ff2] ??:0(trx_undo_insert_cleanup)[0x996b10] ??:0(trx_cleanup_at_db_startup)[0x98fa6b] ??:0(trx_rollback_or_clean_recovered)[0x988c4d] ??:0(recv_recovery_from_checkpoint_finish)[0xa31ad5] ??:0(innobase_start_or_create_for_mysql)[0x977c1f] ??:0(_ZL13innobase_initPv)[0x933622] ??:0(ha_initialize_handlerton(st_plugin_int*))[0x6ee798] ??:0(_ZL17plugin_initializeP13st_plugin_int)[0x5a285b] ??:0(plugin_init(int*, char**, int))[0x5a4f7d] ??:0(_ZL22init_server_componentsv)[0x50d49c] ??:0(mysqld_main(int, char**))[0x50f953] ??:0(??)[0x337d81d9c4] ??:0(_start)[0x504f49] 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.' 131020 07:59:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131020 07:59:22 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.ZTXdG21999 --pid-file=/var/lib/mysql/WPDB01-recover.pid 131020 07:59:30 mysqld_safe WSREP: Failed to recover position: '131020 7:59:23 InnoDB: The InnoDB memory heap is disabled 131020 7:59:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131020 7:59:23 InnoDB: Compressed tables use zlib 1.2.3 131020 7:59:23 InnoDB: Using Linux native AIO 131020 7:59:23 InnoDB: Initializing buffer pool, size = 36.0G 131020 7:59:26 InnoDB: Completed initialization of buffer pool 131020 7:59:26 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! 131020 7:59:26 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... InnoDB: 101 transaction(s) which must be rolled back or cleaned up InnoDB: in total 139 row operations to undo InnoDB: Trx id counter is 7C62E900 InnoDB: Last MySQL binlog file position 0 23578346, file name /var/lib/mysql/mysql-bin.001255 InnoDB: Cleaning up trx with id 7C630396 InnoDB: Cleaning up trx with id 7C63033A InnoDB: Cleaning up trx with id 7C630255 InnoDB: Cleaning up trx with id 7C6301AF InnoDB: Cleaning up trx with id 7C62FF87 InnoDB: Cleaning up trx with id 7C62FF5F InnoDB: Cleaning up trx with id 7C62FF0D InnoDB: Cleaning up trx with id 7C62FDF6 InnoDB: Cleaning up trx with id 7C62FDD6 InnoDB: Cleaning up trx with id 7C62FD9C InnoDB: Cleaning up trx with id 7C62FD64 InnoDB: Cleaning up trx with id 7C62FC6A InnoDB: Cleaning up trx with id 7C62FC60 InnoDB: Cleaning up trx with id 7C62FB98 InnoDB: Cleaning up trx with id 7C62FB36 InnoDB: Cleaning up trx with id 7C62FA4B InnoDB: Cleaning up trx with id 7C62F9E1 InnoDB: Cleaning up trx with id 7C62F94D InnoDB: Cleaning up trx with id 7C62F8E0 InnoDB: Cleaning up trx with id 7C62F7BC InnoDB: Cleaning up trx with id 7C62F793 InnoDB: Cleaning up trx with id 7C62F6A8 InnoDB: Cleaning up trx with id 7C62F690 InnoDB: Cleaning up trx with id 7C62F655 InnoDB: Cleaning up trx with id 7C62F609 InnoDB: Cleaning up trx with id 7C62F4FE InnoDB: Cleaning up trx with id 7C62F4DF InnoDB: Cleaning up trx with id 7C62F4B4 InnoDB: Cleaning up trx with id 7C62F47B InnoDB: Cleaning up trx with id 7C62F473 InnoDB: Cleaning up trx with id 7C62F3D2 InnoDB: Cleaning up trx with id 7C62F38E InnoDB: Cleaning up trx with id 7C62EECD InnoDB: Cleaning up trx with id 7C62EE8A InnoDB: Cleaning up trx with id 7C62EE6B InnoDB: Cleaning up trx with id 7C62ED79 InnoDB: Cleaning up trx with id 7C62ED14 InnoDB: Cleaning up trx with id 7C62EC14 InnoDB: Cleaning up trx with id 7C62EBB5 InnoDB: Cleaning up trx with id 7C62EB8E InnoDB: Cleaning up trx with id 7C62EA49 InnoDB: Cleaning up trx with id 7C62E598 InnoDB: Cleaning up trx with id 7C62E335 InnoDB: Cleaning up trx with id 7C62E186 InnoDB: Cleaning up trx with id 7C62E0C9 InnoDB: Cleaning up trx with id 7C62E0B8 InnoDB: Cleaning up trx with id 7C62E0B6 InnoDB: Cleaning up trx with id 7C62E0AB InnoDB: Cleaning up trx with id 7C62E081 InnoDB: Cleaning up trx with id 7C62DC95 InnoDB: Cleaning up trx with id 7C62DA51 InnoDB: Cleaning up trx with id 7C62D98E InnoDB: Cleaning up trx with id 7C62D986 InnoDB: Cleaning up trx with id 7C62D8F9 InnoDB: Cleaning up trx with id 7C62D8D0 InnoDB: Cleaning up trx with id 7C62D8C9 InnoDB: Cleaning up trx with id 7C62D6B8 InnoDB: Cleaning up trx with id 7C62D44F InnoDB: Cleaning up trx with id 7C62D3AB InnoDB: Cleaning up trx with id 7C62D393 InnoDB: Cleaning up trx with id 7C62D383 InnoDB: Cleaning up trx with id 7C62D2E4 InnoDB: Cleaning up trx with id 7C62D2E1 InnoDB: Cleaning up trx with id 7C62D22C InnoDB: Cleaning up trx with id 7C62D220 InnoDB: Cleaning up trx with id 7C62D0CE InnoDB: Cleaning up trx with id 7C62CED4 InnoDB: Cleaning up trx with id 7C62CEA7 InnoDB: Cleaning up trx with id 7C62CE89 InnoDB: Cleaning up trx with id 7C62CBDF InnoDB: Cleaning up trx with id 7C62CBDD InnoDB: Cleaning up trx with id 7C6160DE 131020 7:59:30 InnoDB: Assertion failure in thread 47209023489776 in file fsp0fsp.c line 3566 InnoDB: Failing assertion: xdes_get_bit(descr, XDES_FREE_BIT, header_page % FSP_EXTENT_SIZE, mtr) == FALSE 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. 131020 7:59:30 [ERROR] 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. 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.33a-MariaDB-log key_buffer_size=32768 read_buffer_size=32768 max_used_connections=0 max_threads=402 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9899778 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 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 = 0x0 thread_stack 0x48000 ??:0(my_print_stacktrace)[0xaad47e] ??:0(handle_fatal_signal)[0x6ec1db] ??:0(??)[0x337e00eca0] ??:0(??)[0x337d830265] ??:0(??)[0x337d831d10] ??:0(fseg_free_step)[0xa04d14] ??:0(trx_undo_seg_free)[0x995ff2] ??:0(trx_undo_insert_cleanup)[0x996b10] ??:0(trx_cleanup_at_db_startup)[0x98fa6b] ??:0(trx_rollback_or_clean_recovered)[0x988c4d] ??:0(recv_recovery_from_checkpoint_finish)[0xa31ad5] ??:0(innobase_start_or_create_for_mysql)[0x977c1f] ??:0(_ZL13innobase_initPv)[0x933622] ??:0(ha_initialize_handlerton(st_plugin_int*))[0x6ee798] ??:0(_ZL17plugin_initializeP13st_plugin_int)[0x5a285b] ??:0(plugin_init(int*, char**, int))[0x5a4f7d] ??:0(_ZL22init_server_componentsv)[0x50d49c] ??:0(mysqld_main(int, char**))[0x50f953] ??:0(??)[0x337d81d9c4] ??:0(_start)[0x504f49] 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.' 131020 08:07:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131020 08:07:01 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.kKxtL24606 --pid-file=/var/lib/mysql/WPDB01-recover.pid 131020 08:07:09 mysqld_safe WSREP: Failed to recover position: '131020 8:07:01 InnoDB: The InnoDB memory heap is disabled 131020 8:07:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131020 8:07:01 InnoDB: Compressed tables use zlib 1.2.3 131020 8:07:01 InnoDB: Using Linux native AIO 131020 8:07:01 InnoDB: Initializing buffer pool, size = 36.0G 131020 8:07:04 InnoDB: Completed initialization of buffer pool 131020 8:07:04 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! 131020 8:07:05 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... InnoDB: 101 transaction(s) which must be rolled back or cleaned up InnoDB: in total 139 row operations to undo InnoDB: Trx id counter is 7C62E900 InnoDB: Last MySQL binlog file position 0 23578346, file name /var/lib/mysql/mysql-bin.001255 InnoDB: Cleaning up trx with id 7C630396 InnoDB: Cleaning up trx with id 7C63033A InnoDB: Cleaning up trx with id 7C630255 InnoDB: Cleaning up trx with id 7C6301AF InnoDB: Cleaning up trx with id 7C62FF87 InnoDB: Cleaning up trx with id 7C62FF5F InnoDB: Cleaning up trx with id 7C62FF0D InnoDB: Cleaning up trx with id 7C62FDF6 InnoDB: Cleaning up trx with id 7C62FDD6 InnoDB: Cleaning up trx with id 7C62FD9C InnoDB: Cleaning up trx with id 7C62FD64 InnoDB: Cleaning up trx with id 7C62FC6A InnoDB: Cleaning up trx with id 7C62FC60 InnoDB: Cleaning up trx with id 7C62FB98 InnoDB: Cleaning up trx with id 7C62FB36 InnoDB: Cleaning up trx with id 7C62FA4B InnoDB: Cleaning up trx with id 7C62F9E1 InnoDB: Cleaning up trx with id 7C62F94D InnoDB: Cleaning up trx with id 7C62F8E0 InnoDB: Cleaning up trx with id 7C62F7BC InnoDB: Cleaning up trx with id 7C62F793 InnoDB: Cleaning up trx with id 7C62F6A8 InnoDB: Cleaning up trx with id 7C62F690 InnoDB: Cleaning up trx with id 7C62F655 InnoDB: Cleaning up trx with id 7C62F609 InnoDB: Cleaning up trx with id 7C62F4FE InnoDB: Cleaning up trx with id 7C62F4DF InnoDB: Cleaning up trx with id 7C62F4B4 InnoDB: Cleaning up trx with id 7C62F47B InnoDB: Cleaning up trx with id 7C62F473 InnoDB: Cleaning up trx with id 7C62F3D2 InnoDB: Cleaning up trx with id 7C62F38E InnoDB: Cleaning up trx with id 7C62EECD InnoDB: Cleaning up trx with id 7C62EE8A InnoDB: Cleaning up trx with id 7C62EE6B InnoDB: Cleaning up trx with id 7C62ED79 InnoDB: Cleaning up trx with id 7C62ED14 InnoDB: Cleaning up trx with id 7C62EC14 InnoDB: Cleaning up trx with id 7C62EBB5 InnoDB: Cleaning up trx with id 7C62EB8E InnoDB: Cleaning up trx with id 7C62EA49 InnoDB: Cleaning up trx with id 7C62E598 InnoDB: Cleaning up trx with id 7C62E335 InnoDB: Cleaning up trx with id 7C62E186 InnoDB: Cleaning up trx with id 7C62E0C9 InnoDB: Cleaning up trx with id 7C62E0B8 InnoDB: Cleaning up trx with id 7C62E0B6 InnoDB: Cleaning up trx with id 7C62E0AB InnoDB: Cleaning up trx with id 7C62E081 InnoDB: Cleaning up trx with id 7C62DC95 InnoDB: Cleaning up trx with id 7C62DA51 InnoDB: Cleaning up trx with id 7C62D98E InnoDB: Cleaning up trx with id 7C62D986 InnoDB: Cleaning up trx with id 7C62D8F9 InnoDB: Cleaning up trx with id 7C62D8D0 InnoDB: Cleaning up trx with id 7C62D8C9 InnoDB: Cleaning up trx with id 7C62D6B8 InnoDB: Cleaning up trx with id 7C62D44F InnoDB: Cleaning up trx with id 7C62D3AB InnoDB: Cleaning up trx with id 7C62D393 InnoDB: Cleaning up trx with id 7C62D383 InnoDB: Cleaning up trx with id 7C62D2E4 InnoDB: Cleaning up trx with id 7C62D2E1 InnoDB: Cleaning up trx with id 7C62D22C InnoDB: Cleaning up trx with id 7C62D220 InnoDB: Cleaning up trx with id 7C62D0CE InnoDB: Cleaning up trx with id 7C62CED4 InnoDB: Cleaning up trx with id 7C62CEA7 InnoDB: Cleaning up trx with id 7C62CE89 InnoDB: Cleaning up trx with id 7C62CBDF InnoDB: Cleaning up trx with id 7C62CBDD InnoDB: Cleaning up trx with id 7C6160DE 131020 8:07:08 InnoDB: Assertion failure in thread 47987284248304 in file fsp0fsp.c line 3566 InnoDB: Failing assertion: xdes_get_bit(descr, XDES_FREE_BIT, header_page % FSP_EXTENT_SIZE, mtr) == FALSE 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. 131020 8:07:08 [ERROR] 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. 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.33a-MariaDB-log key_buffer_size=32768 read_buffer_size=32768 max_used_connections=0 max_threads=402 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9899778 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 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 = 0x0 thread_stack 0x48000 ??:0(my_print_stacktrace)[0xaad47e] ??:0(handle_fatal_signal)[0x6ec1db] ??:0(??)[0x337e00eca0] ??:0(??)[0x337d830265] ??:0(??)[0x337d831d10] ??:0(fseg_free_step)[0xa04d14] ??:0(trx_undo_seg_free)[0x995ff2] ??:0(trx_undo_insert_cleanup)[0x996b10] ??:0(trx_cleanup_at_db_startup)[0x98fa6b] ??:0(trx_rollback_or_clean_recovered)[0x988c4d] ??:0(recv_recovery_from_checkpoint_finish)[0xa31ad5] ??:0(innobase_start_or_create_for_mysql)[0x977c1f] ??:0(_ZL13innobase_initPv)[0x933622] ??:0(ha_initialize_handlerton(st_plugin_int*))[0x6ee798] ??:0(_ZL17plugin_initializeP13st_plugin_int)[0x5a285b] ??:0(plugin_init(int*, char**, int))[0x5a4f7d] ??:0(_ZL22init_server_componentsv)[0x50d49c] ??:0(mysqld_main(int, char**))[0x50f953] ??:0(??)[0x337d81d9c4] ??:0(_start)[0x504f49] 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.'