Page MenuHomeMiraheze

Error deleting files on testwiki
Closed, ResolvedPublic

Description

When attempting to delete the file Test png.PNG on testwiki, the following error occurs Error deleting file: An unknown error occurred in storage backend "local-backend".. This was first brought to my attention by the original uploader of the file, who encountered it while attempting to delete the file as a completed test, and subsequently requested help on the local community portal.

Event Timeline

Reception123 triaged this task as Normal priority.Mar 10 2022, 06:53
Reception123 closed this task as a duplicate of T8856: Error when deleting files.

Not the same error.

[e087887c4bf599068f1a380a] [no req]   Wikimedia\Rdbms\DBTransactionError: Explicit transaction still active. A caller may have caught an error. Open transactions: LocalFile::lockingTransaction
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}
Agent_Isai moved this task from Backlog to Bugs on the MediaWiki board.
Reception123 added a project: Upstream.
This comment was removed by Reception123.

An upstream task will likely have to opened but a second opinion would be good.

I have encountered the identical error here on another wiki natively hosted on Miraheze. The file can be (and was) moved, but a local administrator and myself as a Steward were unable to delete it.

Unknown Object (User) added a comment.Apr 8 2022, 06:32

If this is the same issue as I've fixed before then this SQL query should fix it:

DELETE FROM oldimage WHERE oi_archive_name='';

Doesn't seem to work for this error.

Unknown Object (User) added a comment.Apr 8 2022, 15:38

Doesn't seem to work for this error.

OK I wasn't sure but I have fixed it using that sql before so thought I'd just suggest it.

When I try again,this occered.

删除文件发生错误:Test png.PNG

删除文件发生错误:无法创建目录“mwstore://local-backend/local-deleted/g/q/5”。

(in Chinese)

Unknown Object (User) added a comment.EditedApr 13 2022, 07:06

Is directory permissions correct?

Unknown Object (User) closed this task as Resolved.Apr 14 2022, 23:27
Unknown Object (User) claimed this task.

Fixed.