Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Deadlock in MySQL #4706

Closed
avernet opened this issue Nov 13, 2020 · 1 comment
Closed

Deadlock in MySQL #4706

avernet opened this issue Nov 13, 2020 · 1 comment

Comments

@avernet
Copy link
Collaborator

avernet commented Nov 13, 2020

In a report from a customer, the deadlock involved the following 2 queries:

DELETE FROM orbeon_i_control_text WHERE data_id IN ( 
    SELECT data_id FROM orbeon_i_current 
    WHERE
        document_id = 'e3f730e6e7a48cc8de0d9b27c2d6477ecf7f7dc7' AND 
        draft = 'Y' )
DELETE FROM orbeon_i_control_text WHERE data_id IN (
    SELECT data_id FROM orbeon_i_current 
    WHERE
        document_id = '86c0ac0c08c061088c0221b47c5b58e8c2c1c75b' )
ORDER BY data_id

+1 from customer

@avernet avernet self-assigned this Nov 13, 2020
avernet added a commit that referenced this issue Nov 14, 2020
@avernet avernet added this to To review in Orbeon Forms 2020.1 via automation Nov 21, 2020
@avernet
Copy link
Collaborator Author

avernet commented Nov 21, 2020

Marking as fixed, will reopen if necessary.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
No open projects
Development

No branches or pull requests

1 participant