Hide Forgot
Description of problem: partner-bugzilla has been refreshed, but it's not posing problems with SFDC interactions. How reproducible: Every time. Steps to Reproduce: 1. Create a Bug - e.g.: 707933 2. Create an SFDC Case - e.g. on SFDC Dev: 00457838 3. Attach in Bugzilla. [Doesn't complain, but doesn't show up as linked in SFDC Dev Case page for 00457838] using "Red Hat Customer Portal (DEV)" 4. Try removing External Tracker in Bugzilla. Actual results: Error: DBD::mysql::db selectcol_arrayref failed: Table 'bugs.bug_cf_extra_component' doesn't exist [for Statement "SELECT value FROM bug_cf_extra_component WHERE bug_id = ?"] at Bugzilla/Bug.pm line 3432 Bugzilla::Bug::all_components('Bugzilla::Bug=HASH(0x1fa6ca30)') called at Bugzilla/WebService/Bug.pm line 1382 Bugzilla::WebService::Bug::_bug_to_hash('Bugzilla::WebService::Bug', 'Bugzilla::Bug=HASH(0x1fa6ca30)', 'HASH(0x1fa48840)') called at Bugzilla/WebService/Bug.pm line 333 Bugzilla::WebService::Bug::get('Bugzilla::WebService::Bug', 'HASH(0x1fa48840)') called at /loader/0x1e74e720/Bugzilla/Extension/ExternalBugs/Type/SFDC_DEV.pm line 71 Bugzilla::Extension::ExternalBugs::Type::SFDC_DEV::send_changes('Bugzilla::Extension::ExternalBugs::Type::SFDC_DEV=HASH(0x1f94...', 'HASH(0x1fa522a0)') called at ./extensions/ExternalBugs/Extension.pm line 537 Bugzilla::Extension::ExternalBugs::bug_send_changes('Bugzilla::Extension::ExternalBugs=HASH(0x1e565630)', 'HASH(0x1f95ec90)') called at Bugzilla/Hook.pm line 33 Bugzilla::Hook::process('bug_send_changes', 'HASH(0x1f95ec90)') called at Bugzilla/BugMail.pm line 549 Bugzilla::BugMail::Send(707933, 'HASH(0x1f940c10)') called at /var/www/html/bugzilla/process_bug.cgi line 86 main::send_results(707933, 'HASH(0x1efff5e0)') called at /var/www/html/bugzilla/process_bug.cgi line 741 Expected results: No error. Additional info:
This started occurring after I refreshed the partners db. All I did was reload from this morning's backup, and ran the steps outlined in rt#111429. The table 'bug_cf_extra_component' doesn't exist on either live or partners db. I've run checksetup twice on partners just in case it may have not done all the necessary db changes. What i did not do is the 8 hour jiradb import since that is not part of tonights outage. Is there something in that procedure that adds the table in question?
This is what is live: [root@bzweb01 extensions]# grep bug_cf_extra_component * -rn ExtraValues/Extension.pm:159: OR bugs.bug_id IN (SELECT bug_id FROM bug_cf_extra_components ExtraValues/Extension.pm:257: $$ff = "bug_cf_extra_components.value"; ExtraValues/Extension.pm:264: "bugs.bug_id", "bug_cf_extra_components.bug_id", ExtraValues/Extension.pm:265: "bug_cf_extra_components", $$term) . ')'; This is what is on partners: [root@pbzweb01 extensions]# grep bug_cf_extra_component * -rn Browse/lib/Queries.pm:198: FROM bugs b JOIN bug_cf_extra_component c USING (bug_id) ExtraValues/Extension.pm:529: SELECT value FROM bug_cf_extra_component WHERE bug_id = ?", ExtraValues/Extension.pm:559: $$ff = "bug_cf_extra_component.value"; ExtraValues/Extension.pm:566: "bugs.bug_id", "bug_cf_extra_component.bug_id", ExtraValues/Extension.pm:567: "bug_cf_extra_component", $$term) . ')'; Where is this table coming from if it is not on either database. Live: mysql> describe bugs.bug_cf_extra_component; ERROR 1146 (42S02): Table 'bugs.bug_cf_extra_component' doesn't exist Partner: mysql> describe bugs.bug_cf_extra_component; ERROR 1146 (42S02): Table 'bugs.bug_cf_extra_component' doesn't exist
However on bugs36_devel it does exist. This leads me to believe that it was something to do w/ the jiradb migration process that i didn't apply. Before we can continue with tonights upgrade to bugzilla live, this needs to be resolved and verified. mysql> use bugs36_devel; Database changed mysql> describe bugs.bug_cf_extra_component; ERROR 1146 (42S02): Table 'bugs.bug_cf_extra_component' doesn't exist mysql> describe bugs36_devel.bug_cf_extra_component; +--------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+-------+ | bug_id | mediumint(9) | NO | PRI | NULL | | | value | varchar(64) | NO | PRI | NULL | | +--------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
Just a quick note that I have found the cause of this, and Meethune will be doing a new release on partner-bugzilla shortly. Thank you very much for finding this error. -- simon
Release is on partners, please verify everything is now working. Meethune
Marking as closed. Fix is now on live server and partner-bugzilla. -- simon