API tools faq
paste
Advertisement
lolomin

20130510_PXDBC_5530_node_upgrade_with_errors

lolomin
May 10th, 2013
160
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.95 KB | None | 0 0
raw download clone embed print report
  1. 130510 10:03:33 [Note] /usr/sbin/mysqld: Normal shutdown
  2.  
  3. 130510 10:03:33 [Note] WSREP: Stop replication
  4. 130510 10:03:33 [Note] WSREP: Closing send monitor...
  5. 130510 10:03:33 [Note] WSREP: Closed send monitor.
  6. 130510 10:03:33 [Note] WSREP: gcomm: terminating thread
  7. 130510 10:03:33 [Note] WSREP: gcomm: joining thread
  8. 130510 10:03:33 [Note] WSREP: gcomm: closing backend
  9. 130510 10:03:33 [Note] WSREP: view(view_id(NON_PRIM,35291e97-a04d-11e2-0800-fd0e69104b91,35) memb {
  10. 7ee1c0ea-a04d-11e2-0800-c7de472048d9,
  11. } joined {
  12. } left {
  13. } partitioned {
  14. 35291e97-a04d-11e2-0800-fd0e69104b91,
  15. dfaddead-9b90-11e2-0800-10aa9b4aacfd,
  16. })
  17. 130510 10:03:33 [Note] WSREP: view((empty))
  18. 130510 10:03:33 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
  19. 130510 10:03:33 [Note] WSREP: gcomm: closed
  20. 130510 10:03:33 [Note] WSREP: Flow-control interval: [16, 16]
  21. 130510 10:03:33 [Note] WSREP: Received NON-PRIMARY.
  22. 130510 10:03:33 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 141544)
  23. 130510 10:03:33 [Note] WSREP: Received self-leave message.
  24. 130510 10:03:33 [Note] WSREP: Flow-control interval: [0, 0]
  25. 130510 10:03:33 [Note] WSREP: Received SELF-LEAVE. Closing connection.
  26. 130510 10:03:33 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 141544)
  27. 130510 10:03:33 [Note] WSREP: RECV thread exiting 0: Success
  28. 130510 10:03:33 [Note] WSREP: New cluster view: global state: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 2
  29. 130510 10:03:33 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  30. 130510 10:03:33 [Note] WSREP: recv_thread() joined.
  31. 130510 10:03:33 [Note] WSREP: Closing slave action queue.
  32. 130510 10:03:33 [Note] WSREP: New cluster view: global state: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 2
  33. 130510 10:03:33 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  34. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:0)
  35. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:5)
  36. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:5)
  37. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:5)
  38. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:5)
  39. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:5)
  40. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:5)
  41. 130510 10:03:33 [Note] WSREP: applier thread exiting (code:5)
  42. 130510 10:03:35 [Note] WSREP: killing local connection: 179
  43. 130510 10:03:35 [Note] WSREP: rollbacker thread exiting
  44. 130510 10:03:35 [Note] Event Scheduler: Purging the queue. 0 events
  45. 130510 10:03:35 [Note] WSREP: dtor state: CLOSED
  46. 130510 10:03:35 [Note] WSREP: apply mon: entered 0
  47. 130510 10:03:35 [Note] WSREP: apply mon: entered 0
  48. 130510 10:03:35 [Note] WSREP: mon: entered 135237 oooe fraction 0 oool fraction 7.39443e-06
  49. 130510 10:03:35 [Note] WSREP: cert index usage at exit 32
  50. 130510 10:03:35 [Note] WSREP: cert trx map usage at exit 13
  51. 130510 10:03:35 [Note] WSREP: deps set usage at exit 0
  52. 130510 10:03:35 [Note] WSREP: avg deps dist 11.4615
  53. 130510 10:03:35 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
  54. 130510 10:03:35 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 141544)
  55. 130510 10:03:35 [Note] WSREP: Flushing memory map to disk...
  56. 130510 10:03:35 InnoDB: Starting shutdown...
  57. 130510 10:03:38 InnoDB: Shutdown completed; log sequence number 13774323133
  58. 130510 10:03:38 [Note] /usr/sbin/mysqld: Shutdown complete
  59.  
  60. 130510 10:03:38 mysqld_safe mysqld from pid file /var/lib/mysql/sopdet.pid ended
  61. 130510 10:04:18 [Note] WSREP: Read nil XID from storage engines, skipping position init
  62. 130510 10:04:18 [Note] WSREP: wsrep_load(): loading provider library 'none'
  63. 130510 10:04:19 [Note] WSREP: Service disconnected.
  64. 130510 10:04:20 [Note] WSREP: Some threads may fail to exit.
  65. 130510 10:04:20 [Note] WSREP: Read nil XID from storage engines, skipping position init
  66. 130510 10:04:20 [Note] WSREP: wsrep_load(): loading provider library 'none'
  67. 130510 10:04:55 [Note] WSREP: Service disconnected.
  68. 130510 10:04:56 [Note] WSREP: Some threads may fail to exit.
  69. 130510 10:04:56 [Note] WSREP: Read nil XID from storage engines, skipping position init
  70. 130510 10:04:56 [Note] WSREP: wsrep_load(): loading provider library 'none'
  71. 130510 10:04:56 [Note] Plugin 'FEDERATED' is disabled.
  72. 130510 10:04:56 InnoDB: The InnoDB memory heap is disabled
  73. 130510 10:04:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  74. 130510 10:04:56 InnoDB: Compressed tables use zlib 1.2.3
  75. 130510 10:04:56 InnoDB: Using Linux native AIO
  76. 130510 10:04:56 InnoDB: Initializing buffer pool, size = 26.0G
  77. 130510 10:04:57 InnoDB: Completed initialization of buffer pool
  78. 130510 10:04:57 InnoDB: highest supported file format is Barracuda.
  79. 130510 10:04:58 InnoDB: Waiting for the background threads to start
  80. 130510 10:04:59 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 13774323133
  81. 130510 10:04:59 [Note] WSREP: Service disconnected.
  82. 130510 10:05:00 [Note] WSREP: Some threads may fail to exit.
  83. 130510 10:05:00 InnoDB: Starting shutdown...
  84. 130510 10:05:04 InnoDB: Shutdown completed; log sequence number 13774323133
  85. 130510 10:05:04 [Note] WSREP: Read nil XID from storage engines, skipping position init
  86. 130510 10:05:04 [Note] WSREP: wsrep_load(): loading provider library 'none'
  87. 130510 10:05:04 [Note] Plugin 'FEDERATED' is disabled.
  88. 130510 10:05:04 InnoDB: The InnoDB memory heap is disabled
  89. 130510 10:05:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  90. 130510 10:05:04 InnoDB: Compressed tables use zlib 1.2.3
  91. 130510 10:05:04 InnoDB: Using Linux native AIO
  92. 130510 10:05:04 InnoDB: Initializing buffer pool, size = 26.0G
  93. 130510 10:05:05 InnoDB: Completed initialization of buffer pool
  94. 130510 10:05:06 InnoDB: highest supported file format is Barracuda.
  95. 130510 10:05:07 InnoDB: Waiting for the background threads to start
  96. 130510 10:05:08 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 13774323133
  97. ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
  98. 130510 10:05:08 [ERROR] Aborting
  99.  
  100. 130510 10:05:08 [Note] WSREP: Service disconnected.
  101. 130510 10:05:09 [Note] WSREP: Some threads may fail to exit.
  102. 130510 10:05:09 InnoDB: Starting shutdown...
  103. 130510 10:05:12 InnoDB: Shutdown completed; log sequence number 13774323133
  104. 130510 10:05:12 [Note] /usr/sbin/mysqld: Shutdown complete
  105.  
  106. 130510 10:05:13 [Note] WSREP: Read nil XID from storage engines, skipping position init
  107. 130510 10:05:13 [Note] WSREP: wsrep_load(): loading provider library 'none'
  108. 130510 10:05:13 [Note] Plugin 'FEDERATED' is disabled.
  109. 130510 10:05:13 InnoDB: The InnoDB memory heap is disabled
  110. 130510 10:05:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  111. 130510 10:05:13 InnoDB: Compressed tables use zlib 1.2.3
  112. 130510 10:05:13 InnoDB: Using Linux native AIO
  113. 130510 10:05:13 InnoDB: Initializing buffer pool, size = 26.0G
  114. 130510 10:05:14 InnoDB: Completed initialization of buffer pool
  115. 130510 10:05:14 InnoDB: highest supported file format is Barracuda.
  116. 130510 10:05:15 InnoDB: Waiting for the background threads to start
  117. 130510 10:05:16 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 13774323133
  118. 130510 10:05:16 [Note] WSREP: Service disconnected.
  119. 130510 10:05:17 [Note] WSREP: Some threads may fail to exit.
  120. 130510 10:05:17 InnoDB: Starting shutdown...
  121. 130510 10:05:21 InnoDB: Shutdown completed; log sequence number 13774323133
  122. 130510 10:05:21 [Note] WSREP: Read nil XID from storage engines, skipping position init
  123. 130510 10:05:21 [Note] WSREP: wsrep_load(): loading provider library 'none'
  124. 130510 10:05:21 [Note] Plugin 'FEDERATED' is disabled.
  125. 130510 10:05:21 InnoDB: The InnoDB memory heap is disabled
  126. 130510 10:05:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  127. 130510 10:05:21 InnoDB: Compressed tables use zlib 1.2.3
  128. 130510 10:05:21 InnoDB: Using Linux native AIO
  129. 130510 10:05:21 InnoDB: Initializing buffer pool, size = 26.0G
  130. 130510 10:05:22 InnoDB: Completed initialization of buffer pool
  131. 130510 10:05:22 InnoDB: highest supported file format is Barracuda.
  132. 130510 10:05:23 InnoDB: Waiting for the background threads to start
  133. 130510 10:05:24 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 13774323133
  134. ERROR: 1050 Table 'plugin' already exists
  135. 130510 10:05:24 [ERROR] Aborting
  136.  
  137. 130510 10:05:24 [Note] WSREP: Service disconnected.
  138. 130510 10:05:25 [Note] WSREP: Some threads may fail to exit.
  139. 130510 10:05:25 InnoDB: Starting shutdown...
  140. 130510 10:05:29 InnoDB: Shutdown completed; log sequence number 13774323133
  141. 130510 10:05:29 [Note] /usr/sbin/mysqld: Shutdown complete
  142.  
  143. 130510 10:05:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  144. 130510 10:05:29 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.gXgmFjQOri
  145. 130510 10:05:37 mysqld_safe WSREP: Recovered position 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544
  146. 130510 10:05:37 [Note] WSREP: wsrep_start_position var submitted: '7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544'
  147. 130510 10:05:37 [Note] WSREP: Read nil XID from storage engines, skipping position init
  148. 130510 10:05:37 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/mysql/plugin/libgalera_smm.so'
  149. 130510 10:05:37 [Note] WSREP: wsrep_load(): Galera 2.5(r150) by Codership Oy <info@codership.com> loaded succesfully.
  150. 130510 10:05:37 [Note] WSREP: Found saved state: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544
  151. 130510 10:05:37 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'.
  152. 130510 10:05:37 [Note] WSREP: Passing config to GCS: base_host = 192.168.0.51; 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 = 2048M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
  153. 130510 10:05:37 [Note] WSREP: Assign initial position for certification: 141544, protocol version: -1
  154. 130510 10:05:37 [Note] WSREP: wsrep_sst_grab()
  155. 130510 10:05:37 [Note] WSREP: Start replication
  156. 130510 10:05:37 [Note] WSREP: Setting initial position to 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544
  157. 130510 10:05:37 [Note] WSREP: protonet asio version 0
  158. 130510 10:05:37 [Note] WSREP: backend: asio
  159. 130510 10:05:37 [Note] WSREP: GMCast version 0
  160. 130510 10:05:37 [Note] WSREP: (66500644-b948-11e2-0800-0c3fab9eefda, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
  161. 130510 10:05:37 [Note] WSREP: (66500644-b948-11e2-0800-0c3fab9eefda, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
  162. 130510 10:05:37 [Note] WSREP: EVS version 0
  163. 130510 10:05:37 [Note] WSREP: PC version 0
  164. 130510 10:05:37 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '192.168.0.49:4567,192.168.0.50:4567,192.168.0.51:4567'
  165. 130510 10:05:37 [Warning] WSREP: (66500644-b948-11e2-0800-0c3fab9eefda, 'tcp://0.0.0.0:4567') address 'tcp://192.168.0.51:4567' points to own listening address, blacklisting
  166. 130510 10:05:37 [Note] WSREP: (66500644-b948-11e2-0800-0c3fab9eefda, 'tcp://0.0.0.0:4567') address 'tcp://192.168.0.51:4567' pointing to uuid 66500644-b948-11e2-0800-0c3fab9eefda is blacklisted, skipping
  167. 130510 10:05:37 [Note] WSREP: (66500644-b948-11e2-0800-0c3fab9eefda, 'tcp://0.0.0.0:4567') address 'tcp://192.168.0.51:4567' pointing to uuid 66500644-b948-11e2-0800-0c3fab9eefda is blacklisted, skipping
  168. 130510 10:05:37 [Note] WSREP: (66500644-b948-11e2-0800-0c3fab9eefda, 'tcp://0.0.0.0:4567') address 'tcp://192.168.0.51:4567' pointing to uuid 66500644-b948-11e2-0800-0c3fab9eefda is blacklisted, skipping
  169. 130510 10:05:38 [Note] WSREP: declaring 35291e97-a04d-11e2-0800-fd0e69104b91 stable
  170. 130510 10:05:38 [Note] WSREP: declaring dfaddead-9b90-11e2-0800-10aa9b4aacfd stable
  171. 130510 10:05:38 [Note] WSREP: Node 35291e97-a04d-11e2-0800-fd0e69104b91 state prim
  172. 130510 10:05:38 [Note] WSREP: view(view_id(PRIM,35291e97-a04d-11e2-0800-fd0e69104b91,37) memb {
  173. 35291e97-a04d-11e2-0800-fd0e69104b91,
  174. 66500644-b948-11e2-0800-0c3fab9eefda,
  175. dfaddead-9b90-11e2-0800-10aa9b4aacfd,
  176. } joined {
  177. } left {
  178. } partitioned {
  179. })
  180. 130510 10:05:38 [Note] WSREP: gcomm: connected
  181. 130510 10:05:38 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
  182. 130510 10:05:38 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
  183. 130510 10:05:38 [Note] WSREP: Opened channel 'my_wsrep_cluster'
  184. 130510 10:05:38 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
  185. 130510 10:05:38 [Note] WSREP: Waiting for SST to complete.
  186. 130510 10:05:38 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
  187. 130510 10:05:38 [Note] WSREP: STATE EXCHANGE: sent state msg: 666360fa-b948-11e2-0800-6e5193bec2e3
  188. 130510 10:05:38 [Note] WSREP: STATE EXCHANGE: got state msg: 666360fa-b948-11e2-0800-6e5193bec2e3 from 0 (sothis)
  189. 130510 10:05:38 [Note] WSREP: STATE EXCHANGE: got state msg: 666360fa-b948-11e2-0800-6e5193bec2e3 from 2 (sarapis)
  190. 130510 10:05:38 [Note] WSREP: STATE EXCHANGE: got state msg: 666360fa-b948-11e2-0800-6e5193bec2e3 from 1 (sopdet)
  191. 130510 10:05:38 [Note] WSREP: Quorum results:
  192. version = 2,
  193. component = PRIMARY,
  194. conf_id = 35,
  195. members = 2/3 (joined/total),
  196. act_id = 141579,
  197. last_appl. = -1,
  198. protocols = 0/4/2 (gcs/repl/appl),
  199. group UUID = 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2
  200. 130510 10:05:38 [Note] WSREP: Flow-control interval: [28, 28]
  201. 130510 10:05:38 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 141579)
  202. 130510 10:05:38 [Note] WSREP: State transfer required:
  203. Group state: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141579
  204. Local state: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544
  205. 130510 10:05:38 [Note] WSREP: New cluster view: global state: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141579, view# 36: Primary, number of nodes: 3, my index: 1, protocol version 2
  206. 130510 10:05:38 [Warning] WSREP: Gap in state sequence. Need state transfer.
  207. 130510 10:05:40 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'joiner' --address '192.168.0.51' --auth 'cluster:MYPASSWORD' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '18430''
  208. 130510 10:05:40 [Note] WSREP: Prepared SST request: xtrabackup|192.168.0.51:4444/xtrabackup_sst
  209. 130510 10:05:40 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  210. 130510 10:05:40 [Note] WSREP: Assign initial position for certification: 141579, protocol version: 2
  211. 130510 10:05:40 [Note] WSREP: Prepared IST receiver, listening at: tcp://192.168.0.51:4568
  212. 130510 10:05:40 [Note] WSREP: Node 1 (sopdet) requested state transfer from '*any*'. Selected 0 (sothis)(SYNCED) as donor.
  213. 130510 10:05:40 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 141579)
  214. 130510 10:05:40 [Note] WSREP: Requesting state transfer: success, donor: 0
  215. 130510 10:05:40 [Note] WSREP: SST complete, seqno: 141544
  216. 130510 10:05:40 [Note] Plugin 'FEDERATED' is disabled.
  217. 130510 10:05:40 InnoDB: The InnoDB memory heap is disabled
  218. 130510 10:05:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  219. 130510 10:05:40 InnoDB: Compressed tables use zlib 1.2.3
  220. 130510 10:05:40 InnoDB: Using Linux native AIO
  221. 130510 10:05:40 InnoDB: Initializing buffer pool, size = 26.0G
  222. 130510 10:05:41 InnoDB: Completed initialization of buffer pool
  223. 130510 10:05:41 InnoDB: highest supported file format is Barracuda.
  224. 130510 10:05:42 InnoDB: Waiting for the background threads to start
  225. 130510 10:05:43 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 13774323133
  226. 130510 10:05:44 [Note] Event Scheduler: Loaded 0 events
  227. 130510 10:05:44 [Note] WSREP: Signalling provider to continue.
  228. 130510 10:05:44 [Note] WSREP: SST received: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141544
  229. 130510 10:05:44 [Note] WSREP: Receiving IST: 35 writesets, seqnos 141544-141579
  230. 130510 10:05:44 [Note] /usr/sbin/mysqld: ready for connections.
  231. Version: '5.5.30-30.2-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 30.2, wsrep_23.7.4.r3843
  232. 130510 10:05:44 [Note] WSREP: 0 (sothis): State transfer to 1 (sopdet) complete.
  233. 130510 10:05:44 [Note] WSREP: IST received: 7ecb25b8-7a83-11e2-0800-fdaa5e1ee9c2:141579
  234. 130510 10:05:44 [Note] WSREP: Member 0 (sothis) synced with group.
  235. 130510 10:05:44 [Note] WSREP: 1 (sopdet): State transfer from 0 (sothis) complete.
  236. 130510 10:05:44 [Note] WSREP: Shifting JOINER -> JOINED (TO: 141579)
  237. 130510 10:05:44 [Note] WSREP: Member 1 (sopdet) synced with group.
  238. 130510 10:05:44 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 141579)
  239. 130510 10:05:44 [Note] WSREP: Synchronized with group, ready for connections
  240. 130510 10:05:44 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
  241.  
  242. Status information:
  243.  
  244. Current dir: /var/lib/mysql/
  245. Running threads: 10 Stack size: 196608
  246. Current locks:
  247. lock: 0x3452f10: read
  248. read : 0x3453e08 (16:5);
  249.  
  250. lock: 0x34bee18:
  251.  
  252. lock: 0x34b5ee8:
  253.  
  254. lock: 0x34594e0:
  255.  
  256. lock: 0x3493a10:
  257.  
  258. lock: 0x3491570:
  259.  
  260. lock: 0x348edb0:
  261.  
  262. lock: 0x348c960:
  263.  
  264. lock: 0x348a570:
  265.  
  266. lock: 0x347b520:
  267.  
  268. lock: 0x34726e0:
  269.  
  270. lock: 0x346e6b0:
  271.  
  272. lock: 0x346a1f0:
  273.  
  274. lock: 0x3466970:
  275.  
  276. lock: 0x3463480:
  277.  
  278. lock: 0x3449c70:
  279.  
  280. lock: 0x3440410:
  281.  
  282. lock: 0x342e1c0:
  283.  
  284. lock: 0x342ed20:
  285.  
  286. lock: 0x342d2c0:
  287.  
  288. lock: 0x3412d70:
  289.  
  290. lock: 0x3411cf0:
  291.  
  292. lock: 0x33f4d10:
  293.  
  294. lock: 0x340ca80:
  295.  
  296. lock: 0x34005d0:
  297.  
  298. lock: 0x33f45b0:
  299.  
  300. lock: 0x33e55b0:
  301.  
  302. lock: 0x33e2a80:
  303.  
  304. lock: 0x33dcd60:
  305.  
  306. lock: 0x33d5cb0:
  307.  
  308. lock: 0x33ccfe0:
  309.  
  310. lock: 0x339e500:
  311.  
  312. lock: 0x339e3e0:
  313.  
  314. lock: 0x339b090:
  315.  
  316. lock: 0x335b0a0:
  317.  
  318. lock: 0x3399cc0:
  319.  
  320. lock: 0x3393780:
  321.  
  322. lock: 0x33875f0:
  323.  
  324. lock: 0x3385aa0:
  325.  
  326. lock: 0x3374160:
  327.  
  328. lock: 0x336d300:
  329.  
  330. lock: 0x33721a0:
  331.  
  332. lock: 0x335ae90:
  333.  
  334. lock: 0x3365a50:
  335.  
  336. lock: 0x335a880:
  337.  
  338. lock: 0x3347560:
  339.  
  340. lock: 0x3347440:
  341.  
  342. lock: 0x33457a0:
  343.  
  344. lock: 0x3332cb0:
  345.  
  346. lock: 0x33393c0:
  347.  
  348. lock: 0x3332b90:
  349.  
  350. lock: 0x33253f0:
  351.  
  352. lock: 0x3322e90:
  353.  
  354. lock: 0x330e800:
  355.  
  356. lock: 0x330e6d0:
  357.  
  358. lock: 0x330ddd0:
  359.  
  360. lock: 0x3304820:
  361.  
  362. lock: 0x32f3530:
  363.  
  364. lock: 0x32f2cb0:
  365.  
  366. lock: 0x32ebaf0:
  367.  
  368. lock: 0x32dc230:
  369.  
  370. lock: 0x32dbc10:
  371.  
  372. lock: 0x32d3ec0:
  373.  
  374. lock: 0x32bbc40:
  375.  
  376. lock: 0x32c4c50:
  377.  
  378. lock: 0x32bb630:
  379.  
  380. lock: 0x32afec0:
  381.  
  382. lock: 0x32a3a40:
  383.  
  384. lock: 0x3291ec0:
  385.  
  386. lock: 0x32918a0:
  387.  
  388. lock: 0x3289070:
  389.  
  390. lock: 0x3278c10:
  391.  
  392. lock: 0x3276e20:
  393.  
  394. lock: 0x323eb20:
  395.  
  396. lock: 0x3250c70:
  397.  
  398. lock: 0x3256300:
  399.  
  400. lock: 0x323e9f0:
  401.  
  402. lock: 0x32276b0:
  403.  
  404. lock: 0x3225220:
  405.  
  406. lock: 0x3219be0:
  407.  
  408. lock: 0x320de20:
  409.  
  410. lock: 0x31f69c0:
  411.  
  412. lock: 0x31f3150:
  413.  
  414. lock: 0x32027d0:
  415.  
  416. lock: 0x31ec500:
  417.  
  418. lock: 0x31dc660:
  419.  
  420. lock: 0x31d9530:
  421.  
  422. lock: 0x31bf380:
  423.  
  424. lock: 0x31c5a40:
  425.  
  426. lock: 0x31bc720:
  427.  
  428. lock: 0x31b5050:
  429.  
  430. lock: 0x319ef70:
  431.  
  432. lock: 0x31861e0:
  433.  
  434. lock: 0x319c7c0:
  435.  
  436. lock: 0x31860b0:
  437.  
  438. lock: 0x3151930:
  439.  
  440. lock: 0x31848c0:
  441.  
  442. lock: 0x3161960:
  443.  
  444. lock: 0x3137930:
  445.  
  446. lock: 0x3161830:
  447.  
  448.  
  449. Key caches:
  450. default
  451. Buffer_size: 268435456
  452. Block_size: 1024
  453. Division_limit: 100
  454. Age_limit: 300
  455. blocks used: 3
  456. not flushed: 0
  457. w_requests: 108
  458. writes: 16
  459. r_requests: 92
  460. reads: 0
  461.  
  462.  
  463. handler status:
  464. read_key: 32
  465. read_next: 0
  466. read_rnd 30
  467. read_first: 5
  468. write: 392
  469. delete 25
  470. update: 5
  471.  
  472. Table status:
  473. Opened tables: 263
  474. Open tables: 122
  475. Open files: 41
  476. Open streams: 0
  477.  
  478. Alarm status:
  479. Active alarms: 0
  480. Max used alarms: 0
  481. Next alarm time: 0
  482.  
  483. Thread database.table_name Locked/Waiting Lock_type
  484.  
  485. 16 mysql.user Locked - read Read lock without concurrent inserts
  486.  
  487.  
  488.  
  489.  
  490. Memory status:
  491. Non-mmapped space allocated from system: 5873664
  492. Number of free chunks: 23
  493. Number of fastbin blocks: 0
  494. Number of mmapped regions: 25
  495. Space in mmapped regions: 1412157440
  496. Maximum total allocated space: 0
  497. Space available in freed fastbin blocks: 0
  498. Total allocated space: 5515952
  499. Total free space: 357712
  500. Top-most, releasable space: 348640
  501. Estimated memory (with thread stack): 1419997184
  502.  
  503.  
  504.  
  505. Events status:
  506. LLA = Last Locked At LUA = Last Unlocked At
  507. WOC = Waiting On Condition DL = Data Locked
  508.  
  509. Event scheduler status:
  510. State : INITIALIZED
  511. Thread id : 0
  512. LLA : n/a:0
  513. LUA : n/a:0
  514. WOC : NO
  515. Workers : 0
  516. Executed : 0
  517. Data locked: NO
  518.  
  519. Event queue status:
  520. Element count : 0
  521. Data locked : NO
  522. Attempting lock : NO
  523. LLA : drop_schema_events:382
  524. LUA : drop_schema_events:384
  525. WOC : NO
  526. Next activation : never
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!