Pim Rupert
2012-09-24 12:36:44 UTC
Pim Rupert [http://community.zenoss.org/people/prupert] created the discussion
"[ZC4.2] endless table metadata lock on zodb.object_state"
To view the discussion, visit: http://community.zenoss.org/message/68715#68715
--------------------------------------------------------------
Hi,
We are encountering a table metadata lock on zodb.object_state after running a MySQL OPTIMIZE query. The strange thing is dat this table metadata lock never gets freed up. We are encountering this on a clean installation of Zenoss Core 4.2 SP1 without any modifications using the MySQL package provided by the Zenoss installer script.
A work-around is to stop Zenoss temporarily, run the MySQL optimize query and start Zenoss again.
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68715#68715]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"[ZC4.2] endless table metadata lock on zodb.object_state"
To view the discussion, visit: http://community.zenoss.org/message/68715#68715
--------------------------------------------------------------
Hi,
We are encountering a table metadata lock on zodb.object_state after running a MySQL OPTIMIZE query. The strange thing is dat this table metadata lock never gets freed up. We are encountering this on a clean installation of Zenoss Core 4.2 SP1 without any modifications using the MySQL package provided by the Zenoss installer script.
+------+--------+-----------------+------------+---------+------+---------------------------------+--------------------------------------------------------+
| Id  | User  | Host           | db        | Command | Time | State                          | Info                                                  |
+------+--------+-----------------+------------+---------+------+---------------------------------+--------------------------------------------------------+
| 13  | zenoss | localhost      | zodb      | Query  | 1651 | Waiting for table metadata lock | SELECT tid FROM object_state ORDER BY tid DESC LIMIT 1 |
| 14  | zenoss | localhost      | zodb      | Sleep  | 1652 |                                |                                                       |
| 23  | zenoss | localhost      | zodb      | Query  | 1569 | Waiting for table metadata lock | SELECT tid FROM object_state ORDER BY tid DESC LIMIT 1 |
| 26  | zenoss | localhost      | zodb      | Query  | 1648 | Waiting for table metadata lock | SELECT tid FROM object_state ORDER BY tid DESC LIMIT 1 |
| 163 | zenoss | localhost:56510 | zenoss_zep | Sleep  | 3069 |                                |                                                       |
| 166 | zenoss | localhost:56513 | zenoss_zep | Sleep  | 9   |                                |                                                       |
| 176 | zenoss | localhost      | zodb      | Sleep  | 5242 |                                |                                                       |
| 185 | zenoss | localhost      | zodb      | Sleep  | 1659 |                                |                                                       |
| 186 | zenoss | localhost:56917 | zenoss_zep | Sleep  | 0   |                                |                                                       |
| 189 | zenoss | localhost      | zodb      | Sleep  | 1677 |                                |                                                       |
| 200 | root  | localhost      | zodb      | Query  | 1651 | Waiting for table metadata lock | OPTIMIZE TABLE `object_state`                         |
| 1821 | root  | localhost      |           | Query  | 0   |                                | show processlist                                      |
+------+--------+-----------------+------------+---------+------+---------------------------------+--------------------------------------------------------+
The locks stays there, endlessly. So we have had to restart MySQL to free up the lock.| Id  | User  | Host           | db        | Command | Time | State                          | Info                                                  |
+------+--------+-----------------+------------+---------+------+---------------------------------+--------------------------------------------------------+
| 13  | zenoss | localhost      | zodb      | Query  | 1651 | Waiting for table metadata lock | SELECT tid FROM object_state ORDER BY tid DESC LIMIT 1 |
| 14  | zenoss | localhost      | zodb      | Sleep  | 1652 |                                |                                                       |
| 23  | zenoss | localhost      | zodb      | Query  | 1569 | Waiting for table metadata lock | SELECT tid FROM object_state ORDER BY tid DESC LIMIT 1 |
| 26  | zenoss | localhost      | zodb      | Query  | 1648 | Waiting for table metadata lock | SELECT tid FROM object_state ORDER BY tid DESC LIMIT 1 |
| 163 | zenoss | localhost:56510 | zenoss_zep | Sleep  | 3069 |                                |                                                       |
| 166 | zenoss | localhost:56513 | zenoss_zep | Sleep  | 9   |                                |                                                       |
| 176 | zenoss | localhost      | zodb      | Sleep  | 5242 |                                |                                                       |
| 185 | zenoss | localhost      | zodb      | Sleep  | 1659 |                                |                                                       |
| 186 | zenoss | localhost:56917 | zenoss_zep | Sleep  | 0   |                                |                                                       |
| 189 | zenoss | localhost      | zodb      | Sleep  | 1677 |                                |                                                       |
| 200 | root  | localhost      | zodb      | Query  | 1651 | Waiting for table metadata lock | OPTIMIZE TABLE `object_state`                         |
| 1821 | root  | localhost      |           | Query  | 0   |                                | show processlist                                      |
+------+--------+-----------------+------------+---------+------+---------------------------------+--------------------------------------------------------+
A work-around is to stop Zenoss temporarily, run the MySQL optimize query and start Zenoss again.
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68715#68715]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]