https://bugzilla.wikimedia.org/show_bug.cgi?id=35358
Web browser: ---
Bug #: 35358
Summary: DB backtrace while importing
Product: MediaWiki
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Mobile Platform: ---
While trying to import a dump (simplewiki-20120313-pages-meta-history.xml.bz2)
into a Pg-based wiki with several extensions, I got the following a backtrace:
PHP Warning: pg_query(): Query failed: ERROR: insert or update on table
"revision" violates foreign key constraint "revision_rev_page_fkey"
DETAIL: Key (rev_page)=(943) is not present in table "page". in
.../includes/db/DatabasePostgres.php on line 323
PHP Stack trace:
PHP 1. {main}() .../maintenance/importDump.php:0
PHP 2. require_once() .../maintenance/importDump.php:287
PHP 3. BackupReader->execute() .../maintenance/doMaintenance.php:105
PHP 4. BackupReader->importFromFile() .../maintenance/importDump.php:91
PHP 5. BackupReader->importFromHandle() .../maintenance/importDump.php:241
PHP 6. WikiImporter->doImport() .../maintenance/importDump.php:282
PHP 7. WikiImporter->handlePage() .../includes/Import.php:425
PHP 8. WikiImporter->handleRevision() .../includes/Import.php:559
PHP 9. WikiImporter->processRevision() .../includes/Import.php:607
PHP 10. WikiImporter->revisionCallback() .../includes/Import.php:649
PHP 11. call_user_func_array() .../includes/Import.php:310
PHP 12. BackupReader->handleRevision() .../includes/Import.php:310
PHP 13. call_user_func() .../maintenance/importDump.php:161
PHP 14. WikiImporter->importRevision() .../maintenance/importDump.php:161
PHP 15. DatabaseBase->deadlockLoop() .../includes/Import.php:223
PHP 16. DatabaseBase->commit() .../includes/db/Database.php:2797
PHP 17. DatabaseBase->query() .../includes/db/Database.php:2887
PHP 18. DatabasePostgres->doQuery() .../includes/db/Database.php:877
PHP 19. pg_query() .../includes/db/DatabasePostgres.php:323
A database query syntax error has occurred.
The last attempted database query was:
"COMMIT"
from within function "DatabaseBase::deadlockLoop".
Database returned error "1: ERROR: insert or update on table "revision"
violates foreign key constraint "revision_rev_page_fkey"
DETAIL: Key (rev_page)=(943) is not present in table "page"."
Backtrace:
#0 .../includes/db/DatabasePostgres.php(332):
DatabaseBase->reportQueryError('ERROR: insert ...', 1, 'COMMIT',
'DatabaseBase::d...', false)
#1 .../includes/db/Database.php(904):
DatabasePostgres->reportQueryError('ERROR: insert ...', 1, 'COMMIT',
'DatabaseBase::d...', false)
#2 .../includes/db/Database.php(2887): DatabaseBase->query('COMMIT',
'DatabaseBase::d...')
#3 .../includes/db/Database.php(2797):
DatabaseBase->commit('DatabaseBase::d...')
#4 .../includes/Import.php(223): DatabaseBase->deadlockLoop(Array)
#5 [internal function]: WikiImporter->importRevision(Object(WikiRevision))
#6 .../maintenance/importDump.php(161): call_user_func(Array,
Object(WikiRevision))
#7 [internal function]: BackupReader->handleRevision(Object(WikiRevision),
Object(WikiImporter))
#8 .../includes/Import.php(310): call_user_func_array(Array, Array)
#9 .../includes/Import.php(649):
WikiImporter->revisionCallback(Object(WikiRevision))
#10 .../includes/Import.php(607): WikiImporter->processRevision(Array, Array)
#11 .../includes/Import.php(559): WikiImporter->handleRevision(Array)
#12 .../includes/Import.php(425): WikiImporter->handlePage()
#13 .../maintenance/importDump.php(282): WikiImporter->doImport()
#14 .../maintenance/importDump.php(241):
BackupReader->importFromHandle(Resource id #76)
#15 .../maintenance/importDump.php(91): BackupReader->importFromFile('...')
#16 .../maintenance/doMaintenance.php(105): BackupReader->execute()
#17 .../maintenance/importDump.php(287): require_once('...')
#18 {main}
--
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
