https://bugzilla.wikimedia.org/show_bug.cgi?id=27283
Summary: Transactions can't be nested in Pg
Product: MediaWiki
Version: 1.18-svn
Platform: All
OS/Version: All
Status: NEW
Severity: enhancement
Priority: Normal
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Got a few "WARNING: there is already a transaction in progress" which shows
that a BEGIN was given without ending the previous transaction. Excerpt from
the logs:
2011-02-09 13:07:13 EST LOG: statement: BEGIN
2011-02-09 13:07:13 EST LOG: statement: SELECT /* User::idFromName */
user_id FROM mwuser WHERE user_name = 'Graham87' LIMIT 1
2011-02-09 13:07:13 EST LOG: statement: SELECT /* LinkCache::addLinkObj */
page_id,page_len,page_is_redirect,page_latest FROM page WHERE page_namespace
= '0' AND page_title = 'Analysis_of_var
iance/Degrees_of_freedom' LIMIT 1
2011-02-09 13:07:13 EST LOG: statement: SELECT /* */
nextval('page_page_id_seq')
2011-02-09 13:07:13 EST LOG: statement: SAVEPOINT mw
2011-02-09 13:07:13 EST LOG: statement: INSERT /* Article::insertOn */ INTO
page
(page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len)
VALUES
('438','0','Analysis_of_variance/Degrees_of_freedom','0','','0','1','0.708513577845','2011-02-09
18:07:13 GMT','0','0')
2011-02-09 13:07:13 EST LOG: statement: BEGIN
2011-02-09 13:07:13 EST WARNING: there is already a transaction in progress
2011-02-09 13:07:13 EST LOG: statement: DELETE /* SqlBagOStuff::set 127.0.0.1
*/ FROM objectcache WHERE (keyname='my_wiki:pcache:idhash:438-0!*!0!!*!*!*')
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
