https://bugzilla.wikimedia.org/show_bug.cgi?id=27282

           Summary: Running importDump for Pg reveals savepoints outside
                    of transactions
           Product: MediaWiki
           Version: 1.18-svn
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: Normal
         Component: Database
        AssignedTo: wikibugs-l@lists.wikimedia.org
        ReportedBy: m...@everybody.org


I found the following in my logs while running importDump:

2011-02-09 13:07:13 EST LOG:  statement: COMMIT
2011-02-09 13:07:13 EST LOG:  statement: SELECT /*
LinksUpdate::getExistingLinks 127.0.0.1 */  pl_namespace,pl_title  FROM
pagelinks  WHERE pl_from = '438'   FOR UPDATE
2011-02-09 13:07:13 EST LOG:  statement: SAVEPOINT mw
2011-02-09 13:07:13 EST ERROR:  SAVEPOINT can only be used in transaction
blocks
2011-02-09 13:07:13 EST STATEMENT:  SAVEPOINT mw
2011-02-09 13:07:13 EST LOG:  statement: INSERT /* LinksUpdate::incrTableUpdate
127.0.0.1 */ INTO pagelinks (pl_from,pl_namespace,pl_title) VALUES
('438','0','Analysis_of_variance')
2011-02-09 13:07:13 EST LOG:  statement: RELEASE mw
2011-02-09 13:07:13 EST ERROR:  RELEASE SAVEPOINT can only be used in
transaction blocks
2011-02-09 13:07:13 EST STATEMENT:  RELEASE mw

(Set up verbose logging using the following at the end of postgresql.conf:

log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_statement = 'all'
)

-- 
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to