Red Hat Bugzilla – Bug 965415
Bugzilla tries to write to shadow db
Last modified: 2014-10-12 18:50:49 EDT
Description of problem:
DBD::mysql::db do failed: The MySQL server is running with the --read-only option so it cannot execute this statement [for Statement "INSERT INTO tokens (userid, issuedate, token, tokentype, eventdata)
VALUES (?, NOW(), ?, ?, ?)"] at Bugzilla/Token.pm line 418
Bugzilla::Token::_create_token(164808, 'cc_unsubscribe', 962949) called at Bugzilla/Token.pm line 396
Bugzilla::Token::issue_cc_remove_token('Bugzilla::User=HASH(0x7d77f50)', 'Bugzilla::Bug=HASH(0x7d63290)') called at Bugzilla/BugMail.pm line 425
Bugzilla::BugMail::sendMail('HASH(0x7881260)') called at Bugzilla/BugMail.pm line 274
Bugzilla::BugMail::Send(962949, 'HASH(0x7e52dd0)', 'HASH(0x7e6efb0)') called at Bugzilla/Bug.pm line 1472
Bugzilla::Bug::_send_bugmail('HASH(0x7e6efb0)', 'HASH(0x6be9b30)') called at Bugzilla/Bug.pm line 1437
Bugzilla::Bug::send_changes('Bugzilla::Bug=HASH(0x6e4a190)', 'HASH(0x6c108f0)', 'HASH(0x6be9b30)') called at /var/www/html/bugzilla/process_bug.cgi line 512
Version-Release number of selected component (if applicable):
Current production version
No idea. This happened to me when moving bz962792 to CLOSED:ERRATA state. Because the bug has ~120 (non-RH) people on the CC list, I don't want to move back to NEW and test again.
Strangely enough, the bug changed it's state to CLOSED:ERRATA despite the error message.
Error message is reported.
No error message is shown.
This error has been reported many times, so I need to get to the bottom of it. Unfortunately, I'm not exactly sure of where the problem is.
As a background, Red Hat have an extension that adds a remove me from the CC: list that uses a token to authenticate. The error occurs when generating this token. It appears that it is trying to put the token on the slave database, and not the master.
This only started occurring in Red Hat Bugzilla 4.4, so something has changed since 4.2.5-8 and this release.
Verified on qe test env version 4.4.rc2-3.1(20130522) --> pass
1. login as redhat account.
2. visit show bug page of bug 560484 which has 688 users in cc list.
3. change the status of this bug to 'Assigned' and click 'save changes'.
then expected results:
large quantity email notifications message displaying on the top, and the status has been set to 'Assigned' without errors.
4. edit the cc list to remove one account, and meantime change the status of this bug to 'CLOSED:ERRATA' and click 'save changes'.
then expected results:
large quantity email notifications message displaying on the top, and the status has been set to 'CLOSED:ERRATA' without errors.
same with expected results.