| Summary: | SFDC<->BZ interaction isn't working on partner-bugzilla | ||
|---|---|---|---|
| Product: | [Community] Bugzilla | Reporter: | Daniel Fisher <dfisher> |
| Component: | Creating/Changing Bugs | Assignee: | Simon Green <sgreen> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | devel | CC: | bhowmick, ebaak, sgreen |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2011-05-27 00:07:45 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
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 |
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: