Page MenuHomeMiraheze

Fatal exceptions
Closed, ResolvedPublic

Description

Fatal exception of type "Wikimedia\Rdbms\DBTransactionError" when trying to import a valid XML file to this wiki.

Fatal exception of type "LogicException" when trying to delete this page.

Event Timeline

@Ora: Can you please give an exception id (the hash)?

I can reproduce the delete issue.

"Wikimedia\Rdbms\DBTransactionError":
e01acfbf03aff9644fa2f37e

"LogicException":
2892a22ba7022c0833768618

For deleting a page:

rhinos@mwtask1:~$ sudo -u www-data php /srv/mediawiki/w/maintenance/deleteBatch.php delsuper.txt --wiki=superwiki
דף הביתLogicException from line 432 of /srv/mediawiki/w/includes/page/DeletePage.php: No revisions for דף הבית?
#0 /srv/mediawiki/w/includes/page/DeletePage.php(385): MediaWiki\Page\DeletePage->deleteInternal('')
#1 /srv/mediawiki/w/includes/page/WikiPage.php(2698): MediaWiki\Page\DeletePage->deleteUnsafe('')
#2 /srv/mediawiki/w/maintenance/deleteBatch.php(124): WikiPage->doDeleteArticleReal('', Object(User), false, NULL, '', NULL, Array, 'delete', true)
#3 /srv/mediawiki/w/maintenance/doMaintenance.php(108): DeleteBatch->execute()
#4 /srv/mediawiki/w/maintenance/deleteBatch.php(141): require_once('/srv/mediawiki/...')
#5 {main}
[180dd79fbf942d9c795f7887] [no req]   Wikimedia\Rdbms\DBTransactionError: Explicit transaction still active. A caller may have caught an error. Open transactions: MediaWiki\Page\DeletePage::deleteInternal
Backtrace:
from /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1637)
#0 /srv/mediawiki/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1757): Wikimedia\Rdbms\Database->assertNoOpenTransactions()
#1 /srv/mediawiki/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(2344): Wikimedia\Rdbms\LoadBalancer->Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\DatabaseMysqli)
#2 /srv/mediawiki/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1781): Wikimedia\Rdbms\LoadBalancer->forEachOpenPrimaryConnection(Closure)
#3 /srv/mediawiki/w/includes/libs/rdbms/lbfactory/LBFactory.php(249): Wikimedia\Rdbms\LoadBalancer->approvePrimaryChanges(array, string, integer)
#4 /srv/mediawiki/w/includes/libs/rdbms/lbfactory/LBFactoryMulti.php(236): Wikimedia\Rdbms\LBFactory::Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\LoadBalancer, string, array)
#5 /srv/mediawiki/w/includes/libs/rdbms/lbfactory/LBFactory.php(251): Wikimedia\Rdbms\LBFactoryMulti->forEachLB(Closure, array)
#6 /srv/mediawiki/w/includes/libs/rdbms/lbfactory/LBFactory.php(315): Wikimedia\Rdbms\LBFactory->forEachLBCallMethod(string, array)
#7 /srv/mediawiki/w/maintenance/includes/Maintenance.php(1243): Wikimedia\Rdbms\LBFactory->commitPrimaryChanges(string)
#8 /srv/mediawiki/w/maintenance/doMaintenance.php(130): Maintenance->shutdown()
#9 /srv/mediawiki/w/maintenance/deleteBatch.php(141): require_once(string)
#10 {main}

I can't edit that page either, there's an alleged edit conflict.

I deleted the page server side

In T8492#171500, @Ora wrote:

I can't edit that page either, there's an alleged edit conflict.

The page somehow managed to exist with no revisions. I've dropped it from the backend tables.

Please get an exception id for the import issue.

@Ora: Please send the XML to sre@miraheze.org so I can run it in a debug mode

@Ora: Can you tell me where the dump is from so we can add a prefix

Same wiki, it's a backup.

It looks like the backup is corrupted.

RhinosF1 claimed this task.

Closing, broken page is removed and the backup is broken.

I'll cleanup in a second. Have you tried the import again? It's the import leaving it broken causing it.

I did and then I deleted that file.

In T8492#171527, @Ora wrote:

I did and then I deleted it.

Please do not keep sending invalid imports. The file you've given will not work.

I just created that page, exported it, deleted it and then tried to import it just to check.
"No revisions imported (all were either already present, or skipped due to errors)."
I assume you can reproduce this issue too.

...Same error with other pages. Brand new untouched XML files from this very wiki.

Please list the pages.

Please also give us the exact options you're using to export.

(And preferably don't try any more until we can fix this)

Okay.

All the mainspace pages:

Export:
*Include only the current revision, not the full history
*Save as file

Import:
*Prefix: superwiki
*Assign edits to local users where the named user exists locally
*No comment
*Import to default locations

(And preferably don't try any more until we can fix this)

Can I try again now?

I moved all of the mainspace pages with all of their history to a draft, and then successfully imported the last versions (there's no copyright problem). Everything seems fine. Thank you for your help.

This issue reminded me this old file. I don't even remember what it was and I don't need it anymore. Can you remove it?

In T8492#171569, @Ora wrote:

I moved all of the mainspace pages with all of their history to a draft, and then successfully imported the last versions (there's no copyright problem). Everything seems fine. Thank you for your help.

This issue reminded me this old file. I don't even remember what it was and I don't need it anymore. Can you remove it?

Is there any reason you can't?

The page was deleted, but the file itself remained:
An unknown error occurred in storage backend "local-backend".
It still appears under "Unused files".

I've checked every place I can think MediaWiki would hold data but so far it still persists.

Whatever you did worked. You somehow deleted the older version so I was able to delete the newer version... and then there were none. Thanks!

John triaged this task as Normal priority.Feb 27 2022, 10:28