Page MenuHomePhabricator

PostgreSQL syntax error: LOCK IN SHARE MODE when running Category
Closed, ResolvedPublic

Description

Author: darkcircle.0426

Description:
This patch is for getting rid of "LOCK IN SHARE MODE" related warning message.

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "LOCK" LINE 1: ... in ${MEDIAWIKI_HOME}/includes/db/DatabasePostgres.php on line 254 when category page is called.

as below commit message
https://gerrit.wikimedia.org/r/#/c/53554/
"LOCK IN SHARE MODE" is a MySQL extension not supported by another SQL Engine.

so I suggest very simple patch for eliminating this issue.


Version: 1.22.0
Severity: normal
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=47055

Attached:

Details

Reference
bz46594

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 22 2014, 1:21 AM
bzimport set Reference to bz46594.
bzimport added a subscriber: Unknown Object (MLST).
bzimport created this task.Mar 27 2013, 9:45 AM

Hi Seong-ho! Thanks for your patch!

You are welcome to use Developer access

https://www.mediawiki.org/wiki/Developer_access

to submit this as a Git branch directly into Gerrit:

https://www.mediawiki.org/wiki/Git/Tutorial

Putting your branch in Git makes it easier to review it quickly.
Thanks again! We appreciate your contribution.

saper added a comment.Jul 17 2013, 3:12 PM

I think PostgreSQL has "FOR SHARE" SELECT option. By then, issues listed in bug 47055 apply.

Hi Seong-ho Cho,

I tried to apply your patch, but unfortunately it did not apply cleanly. To submit a patch, you can now also use the on-line patch uploader at https://tools.wmflabs.org/gerrit-patch-uploader/ . Of course, you can also submit it directly using git.

Was already fixed with bug 39635, thats why the provided patch cannot apply to current master.

  • This bug has been marked as a duplicate of bug 39635 ***
Jdforrester-WMF added a subscriber: Jdforrester-WMF.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.