maria-discuss team mailing list archive

[Daniel Black <daniel.black@xxxxxxxxxxxxx>]

mydumper -V
mydumper 0.5.2, built against MySQL 5.5.34

Running this: mydumper -c

Server version: 5.5.29-MariaDB-mariadb1~precise-log mariadb.org binary distribution, wsrep_23.7.3.rXXXX

Causes this query to occur and block:
| 30 | openquery   | localhost | NULL | Query   |   770 | checking permissions | CREATE TABLE IF NOT EXISTS mysql.mydumperdummy (a INT) ENGINE=INNODB |    0.00


The mysql error log reports:

140118  9:32:51 [Note] WSREP: Provider paused at 727ac931-ae1d-11e2-0800-35fac11491b4:6506290


And the query is unkillable:
kill 30;
Show processlist stays at:

| 30 | openquery   | localhost | NULL | Killed  |   959 | checking permissions | CREATE TABLE IF NOT EXISTS mysql.mydumperdummy (a INT) ENGINE=INNODB |    0.00

This process never terminates.

The mydumper process terminates correctly:
** (mydumper:3859): CRITICAL **: Unable to list databases: MySQL server has gone away

The error log says (I think i got out of the mysql prompt here)
140118  9:48:43 [Warning] Aborted connection 32 to db: 'unconnected' user: 'openquery' host: 'localhost' (Unknown error)
140118  9:48:43 [Warning] Aborted connection 33 to db: 'unconnected' user: 'openquery' host: 'localhost' (Unknown error)
140118  9:48:43 [Warning] Aborted connection 34 to db: 'unconnected' user: 'openquery' host: 'localhost' (Unknown error)
140118  9:48:43 [Warning] Aborted connection 35 to db: 'unconnected' user: 'openquery' host: 'localhost' (Unknown error)

The global status is ok now however there is a hanging process:

| Variable_name              | Value                                           |
+----------------------------+-------------------------------------------------+
| wsrep_local_state_uuid     | 727ac931-ae1d-11e2-0800-35fac11491b4            |
| wsrep_protocol_version     | 4                                               |
| wsrep_last_committed       | 6506290                                         |
| wsrep_replicated           | 1                                               |
| wsrep_replicated_bytes     | 456                                             |
| wsrep_received             | 10107                                           |
| wsrep_received_bytes       | 4364320                                         |
| wsrep_local_commits        | 0                                               |
| wsrep_local_cert_failures  | 0                                               |
| wsrep_local_bf_aborts      | 0                                               |
| wsrep_local_replays        | 0                                               |
| wsrep_local_send_queue     | 0                                               |
| wsrep_local_send_queue_avg | 0.000000                                        |
| wsrep_local_recv_queue     | 29                                              |
| wsrep_local_recv_queue_avg | 1.183673                                        |
| wsrep_flow_control_paused  | 0.299376                                        |
| wsrep_flow_control_sent    | 1                                               |
| wsrep_flow_control_recv    | 1                                               |
| wsrep_cert_deps_distance   | 199.864721                                      |
| wsrep_apply_oooe           | 0.000000                                        |
| wsrep_apply_oool           | 0.000000                                        |
| wsrep_apply_window         | 1.000000                                        |
| wsrep_commit_oooe          | 0.000000                                        |
| wsrep_commit_oool          | 0.000000                                        |
| wsrep_commit_window        | 1.000000                                        |
| wsrep_local_state          | 4                                               |
| wsrep_local_state_comment  | Synced                                          |
| wsrep_cert_index_size      | 382                                             |
| wsrep_causal_reads         | 0                                               |
| wsrep_incoming_addresses   | 10.1.2.121:3306,10.1.2.129:3306,10.1.2.120:3306 |
| wsrep_cluster_conf_id      | 4                                               |
| wsrep_cluster_size         | 3                                               |
| wsrep_cluster_state_uuid   | 727ac931-ae1d-11e2-0800-35fac11491b4            |
| wsrep_cluster_status       | Primary                                         |
| wsrep_connected            | ON                                              |
| wsrep_local_index          | 1                                               |
| wsrep_provider_name        | Galera                                          |
| wsrep_provider_vendor      | Codership Oy <info@xxxxxxxxxxxxx>               |
| wsrep_provider_version     | 23.2.7-wheezy(r)                                |
| wsrep_ready                | ON                                              |


I plan on putting a patch back into mydump to remove this "feature" (It looks like a pre-4.1.8 servers workaround that isn't needed.
http://bazaar.launchpad.net/~perconardba/mydumper/0.6/revision/23 )

Any clues to why the blocking?


-- 
Daniel Black, Engineer @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.