Announcement

Announcement Module
Collapse
No announcement yet.

pmp-check-mysql-deadlocks table doesn't exist

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pmp-check-mysql-deadlocks table doesn't exist

    I'm testing nagios plugins, when I run pmp-check-mysql-deadlocks -H mytest-db -l nagios -p passwod
    ERROR 1146 (42S02) at line 1: Table 'percona.deadlocks' doesn't exist
    UNK could not count deadlocks

    How does the table get created? which database should the table be created?

    thanks
    Wolf

  • #2
    The pmp-check-mysql-deadlocks plugin pulls data from a table that pt-deadlock-logger creates and logs to (http://www.percona.com/doc/percona-m...ml#description).

    So you would first need to get pt-deadlock-logger up and running, at which point the table will be created (http://www.percona.com/doc/percona-t...k-logger--dest) and then you should be able to get pmp-check-mysql-deadlocks working at that point.

    Comment

    Working...
    X