Bug 1276192 - Reduce transaction isolation level for profile_search table
Summary: Reduce transaction isolation level for profile_search table
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Bugzilla
Classification: Community
Component: Database
Version: 4.4
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: 4.4
Assignee: Matt Tyson 🤬
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-10-29 03:08 UTC by Matt Tyson 🤬
Modified: 2018-12-09 06:29 UTC (History)
5 users (show)

Fixed In Version: 4.4.10044.10
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-11-16 00:42:23 UTC
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1280315 0 high CLOSED Frequent reports of "Red Hat Bugzilla's database reported a query serialization error" 2021-02-22 00:41:40 UTC

Internal Links: 1280315

Description Matt Tyson 🤬 2015-10-29 03:08:11 UTC
The profile_search table stores recently used searches by the user.

When the user starts opening searches in quick succession, this can cause postgres serialization errors to happen.

These serialization errors really aren't all that critical for this table and could be safely ignored.

In Bugzilla/Search/Recent.pm we should wind the serialization level back to READ COMMITTED where it deletes from the profile_search table.

Comment 3 Rony Gong 🔥 2015-11-12 08:58:57 UTC
Test this on build 4.4.10042-7
Before upgrading, QE could get the serialization error when open huge amount tabs of search at once:
Red Hat Bugzilla's database reported a query serialization error. Most likely this occurred because another user or process attempted to change the same data that you were attempting to change. 

Please press Back and retry the transaction.

After upgrading, QE couldn't find the serialization error happened anymore.

Comment 4 Matt Tyson 🤬 2015-11-16 00:42:23 UTC
This change is now live. If there are any issues, do not reopen this bug.
Instead, you should create a new bug and reference this bug.


Note You need to log in before you can comment on or make changes to this bug.