when this plugin work, it locked my database mysql.

Issue #80 wontfix
Former user created an issue

jira version:7.1.2 plugin ver:1.2.11 the phenomenon is jira can't creat an update iusse, error is “Lock wait timeout exceeded,try restarting trantransaction” then,I “show OPEN TABLES where In_use > 0; ” in mysql +-------------+----------------------+--------+-------------+ | Database | Table | In_use | Name_locked | +-------------+----------------------+--------+-------------+ | jira712_pro | AO_9F079B_QUEUE_ITEM | 1 | 0 | | jira712_pro | tmp_cx_jbxxb | 1 | 0 | | jira712_pro | issuestatus | 1 | 0 | +-------------+----------------------+--------+-------------+ +-------------+------------------+--------+-------------+ | Database | Table | In_use | Name_locked | +-------------+------------------+--------+-------------+ | jira712_pro | AO_9F079B_COMMIT | 1 | 0 | | jira712_pro | customfieldvalue | 1 | 0 | | jira712_pro | tmp_cx_jbxxb | 1 | 0 | +-------------+------------------+--------+-------------+ just this plugin is working, and the cpu usage of mysql is high(116%),normal just 5%。 so I doubt this plugin locked mysql。 I back to old version。

Comments (2)

  1. Dmitrii Apanasevich repo owner

    Hi,

    Which version had you used before you updated the add-on to v. 1.2.11? This version contains the only bugfix and no new features.

    How have you configured repositories?

    Maybe, there is some information in Jira log connected with the keyword “jigit“, could you take a look into it?

  2. Log in to comment