Last modified: 2014-02-03 20:10:29 UTC
Created attachment 11992 [details] 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.
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.
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.
Update per https://www.mediawiki.org/w/index.php?title=MediaWiki_1.22/Known_issues&oldid=847749 which seems to be the master list.
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 ***
