[Oracle] Oracle crashes when typing "word1 word2" in QuickSearch with "ORA-29907: found duplicate labels in primary invocations"

RESOLVED FIXED in Bugzilla 4.2

Status

()

Bugzilla
Database
RESOLVED FIXED
5 years ago
5 years ago

People

(Reporter: f.v.scognamiglio, Assigned: Frédéric Buclin)

Tracking

4.2.1
Bugzilla 4.2
Bug Flags:
approval +
approval4.4 +
blocking4.4 +
approval4.2 +
blocking4.2.4 +

Details

Attachments

(2 attachments, 1 obsolete attachment)

(Reporter)

Description

5 years ago
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4

Steps to reproduce:

Entered "word1 word2" (without quotes) into quicksearch field


Actual results:

DBD::Oracle::db prepare failed: ORA-29907: found duplicate labels in primary invocations (DBD ERROR: error possibly near <*> indicator at char 2407 in 'SELECT bugs.bug_id  bug_id, bugs.bug_severity  bug_severity, bugs.priority  priority, bugs.bug_status  bug_status, bugs.resolution  resolution, map_product.name  product, map_component.name  component, map_assigned_to.login_name  assigned_to, bugs.short_desc  short_desc, bugs.delta_ts  changeddate
  FROM bugs
LEFT JOIN bug_group_map  security_map ON bugs.bug_id = security_map.bug_id AND NOT ( security_map.group_id IN (1,10,11,14,13,12,9,4,8,5,6,7,3,2,15,16,17) )
LEFT JOIN cc  security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 23
INNER JOIN products  map_product ON bugs.product_id = map_product.id
INNER JOIN components  map_component ON bugs.component_id = map_component.id
INNER JOIN profiles  map_assigned_to ON bugs.assigned_to = map_assigned_to.userid
INNER JOIN bug_status  map_bug_status ON bugs.bug_status = map_bug_status.value
INNER JOIN priority  map_priority ON bugs.priority = map_priority.value
LEFT JOIN bugs_fulltext  bugs_fulltext_6 ON bugs.bug_id = bugs_fulltext_6.bug_id
LEFT JOIN bugs_fulltext  bugs_fulltext_12 ON bugs.bug_id = bugs_fulltext_12.bug_id
  WHERE  rownum <=500 AND  bugs.creation_ts IS NOT NULL
   AND (security_map.group_id IS NULL
        OR (bugs.reporter_accessible = 1 AND bugs.reporter = 23)
        OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
        OR bugs.assigned_to = 23
)
   AND  bugs.bug_status IN ('UNCONFIRMED','CONFIRMED','PRESO_IN_CARICO')  AND ( ( ( bugs.product_id IN (SELECT products.id FROM products WHERE INSTR(LOWER(products.name), LOWER('ciao')) > 0) OR bugs.component_id IN (SELECT components.id FROM components WHERE INSTR(LOWER(components.name), LOWER('ciao')) > 0) OR INSTR(LOWER(COALESCE(bugs.alias, '__BZ_EMPTY_STR__')), LOWER('ciao')) > 0 OR INSTR(LOWER(bugs.short_desc), LOWER('ciao')) > 0 OR INSTR(LOWER(bugs.status_whiteboard), LOWER( ... value
LEFT JOIN bugs_fulltext  bugs_fulltext_6 ON bugs.bug_id = bugs_fulltext_6.bug_id
LEFT JOIN bugs_fulltext  bugs_fulltext_12 ON bugs.bug_id = bugs_fulltext_12.bug_id
  WHERE  rownum <=500 AND  bugs.creation_ts IS NOT NULL
   AND (security_map.group_id IS NULL
        OR (bugs.reporter_accessible = 1 AND bugs.reporter = 23)
        OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
        OR bugs.assigned_to = 23
)
   AND  bugs.bug_status IN ('UNCONFIRMED','CONFIRMED','PRESO_IN_CARICO')  AND ( ( ( bugs.product_id IN (SELECT products.id FROM products WHERE INSTR(LOWER(products.name), LOWER('ciao')) > 0) OR bugs.component_id IN (SELECT components.id FROM components WHERE INSTR(LOWER(components.name), LOWER('ciao')) > 0) OR INSTR(LOWER(COALESCE(bugs.alias, '__BZ_EMPTY_STR__')), LOWER('ciao')) > 0 OR INSTR(LOWER(bugs.short_desc), LOWER('ciao')) > 0 OR INSTR(LOWER(bugs.status_whiteboard), LOWER('ciao')) > 0 OR CONTAINS(bugs_fulltext_6.comments_noprivate,'"ciao"',1) > 0 OR CONTAINS(bugs_fulltext_6.short_desc,'"ciao"',2) > 0 ) ) AND ( ( bugs.product_id IN (SELECT products.id FROM products WHERE INSTR(LOWER(products.name), LOWER('ciao')) > 0) OR bugs.component_id IN (SELECT components.id FROM components WHERE INSTR(LOWER(components.name), LOWER('ciao')) > 0) OR INSTR(LOWER(COALESCE(bugs.alias, '__BZ_EMPTY_STR__')), LOWER('ciao')) > 0 OR INSTR(LOWER(bugs.short_desc), LOWER('ciao')) > 0 OR INSTR(LOWER(bugs.status_whiteboard), LOWER('ciao')) > 0 OR CONTAINS(bugs_fulltext_12.comments_noprivate,'"ciao"',1) > 0 OR CONTAINS(bugs_fulltext_12.short_desc,'"ciao"',2) > 0 ) ) )
GROUP BY bugs.bug_id, bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,map_product.name,map_component.name,map_assigned_to.login_name,bugs.short_desc,bugs.delta_ts,map_bug_status.sortkey,map_bug_status.value,map_priority.sortkey,map_priority.value
ORDER BY map_bug_status.sortkey, map_bug_status.value, map_priority.sortkey, map_priority.value, assigned_to, bug_id
/* LIMIT 500 */
"] at Bugzilla/DB/Oracle.pm line 491
	Bugzilla::DB::Oracle::prepare(undef, 'SELECT bugs.bug_id  bug_id, bugs.bug_severity  bug_severity, ...') called at /sw/instance/apache-2.2.22/htdocs/bugzilla/buglist.cgi line 828


Expected results:

I saw that there is a similar case for the version 4.0.2 resolved with an upgrade to later versions. But in this case, what can I do?
(Reporter)

Updated

5 years ago
OS: All → Linux
Hardware: All → x86
(Assignee)

Comment 1

5 years ago
Confirmed on 4.5.
Status: UNCONFIRMED → NEW
Ever confirmed: true
Flags: blocking4.4+
OS: Linux → All
Hardware: x86 → All
Summary: DBD::Oracle::db prepare failed: ORA-29907: → [Oracle] Oracle crashes when typing "word1 word2" in QuickSearch with "ORA-29907: found duplicate labels in primary invocations"
Target Milestone: --- → Bugzilla 4.2
(Assignee)

Comment 2

5 years ago
Created attachment 675145 [details] [diff] [review]
patch for trunk, v1

As Bugzilla 5.0 requires Perl 5.10.1, I can use the "state" feature.
Assignee: database → LpSolit
Status: NEW → ASSIGNED
Attachment #675145 - Flags: review?(dkl)
(Assignee)

Comment 3

5 years ago
Created attachment 675181 [details] [diff] [review]
patch for trunk, v1.1

I forgot to remove $label from the list of arguments in my previous patch.
Attachment #675145 - Attachment is obsolete: true
Attachment #675145 - Flags: review?(dkl)
Attachment #675181 - Flags: review?(dkl)
(Assignee)

Updated

5 years ago
Attachment #675181 - Attachment description: patch, v1.1 → patch for trunk, v1.1
(Assignee)

Comment 4

5 years ago
Created attachment 675212 [details] [diff] [review]
patch for 4.x, v1

Instead of "state", I use "our" for branches.
Attachment #675212 - Flags: review?(dkl)
(Assignee)

Updated

5 years ago
Flags: blocking4.2.4+
Comment on attachment 675181 [details] [diff] [review]
patch for trunk, v1.1

Review of attachment 675181 [details] [diff] [review]:
-----------------------------------------------------------------

Looks fine and corrects the issue for me. r=dkl
Attachment #675181 - Flags: review?(dkl) → review+

Updated

5 years ago
Flags: approval?
Flags: approval4.4?
Flags: approval4.2?
Comment on attachment 675212 [details] [diff] [review]
patch for 4.x, v1

Review of attachment 675212 [details] [diff] [review]:
-----------------------------------------------------------------

Also looks good and fixes the issue on 4.4. r=dkl
Attachment #675212 - Flags: review?(dkl) → review+
(Assignee)

Updated

5 years ago
Flags: approval?
Flags: approval4.4?
Flags: approval4.4+
Flags: approval4.2?
Flags: approval4.2+
Flags: approval+
(Assignee)

Comment 7

5 years ago
Committing to: bzr+ssh://lpsolit%40gmail.com@bzr.mozilla.org/bugzilla/trunk/
modified Bugzilla/Bug.pm
modified Bugzilla/Search.pm
modified Bugzilla/DB/Oracle.pm
Committed revision 8456.

Committing to: bzr+ssh://lpsolit%40gmail.com@bzr.mozilla.org/bugzilla/4.4/
modified Bugzilla/Bug.pm
modified Bugzilla/Search.pm
modified Bugzilla/DB/Oracle.pm
Committed revision 8442.

Committing to: bzr+ssh://lpsolit%40gmail.com@bzr.mozilla.org/bugzilla/4.2/
modified Bugzilla/Bug.pm
modified Bugzilla/Search.pm
modified Bugzilla/DB/Oracle.pm
Committed revision 8162.
Status: ASSIGNED → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
(Reporter)

Comment 8

5 years ago
ok. the problem has been resolved! thank's!
You need to log in before you can comment on or make changes to this bug.