Disk full in wiki?

[andreas85]

When trying ti add some content to the wiki, i got the following error

Es ist ein Datenbankabfragefehler aufgetreten. Dies könnte auf einen Fehler in der Software hindeuten.

[a10459251db1a5d504d87241] /index.php?title=Btrfs&action=submit Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Error 1021: Disk full (/tmp/#sql-temptable-1-0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (manjaro-wiki_database_1)
Function: MediaWiki\Storage\EditResultBuilder::findIdenticalRevision
Query: SELECT * FROM (SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,temp_rev_user.revactor_actor AS `rev_actor` FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `revision_actor_temp` `temp_rev_user` ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) WHERE rev_page = 21425 ORDER BY rev_timestamp DESC,rev_id DESC LIMIT 1,15 ) `recent_revs` WHERE rev_sha1 = 's9g95nd5bbrbe5cq90nwfpq7a63k06l' LIMIT 1
Backtrace:

from /var/www/html/includes/libs/rdbms/database/Database.php(1719)
#0 /var/www/html/includes/libs/rdbms/database/Database.php(1703): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /var/www/html/includes/libs/rdbms/database/Database.php(1678): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /var/www/html/includes/libs/rdbms/database/Database.php(1244): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#3 /var/www/html/includes/libs/rdbms/database/Database.php(1929): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /var/www/html/includes/libs/rdbms/database/Database.php(2029): Wikimedia\Rdbms\Database->select(array, string, array, string, array, array)
#5 /var/www/html/includes/Storage/EditResultBuilder.php(272): Wikimedia\Rdbms\Database->selectRow(array, string, array, string)
#6 /var/www/html/includes/Storage/EditResultBuilder.php(215): MediaWiki\Storage\EditResultBuilder->findIdenticalRevision(integer)
#7 /var/www/html/includes/Storage/EditResultBuilder.php(124): MediaWiki\Storage\EditResultBuilder->detectManualRevert()
#8 /var/www/html/includes/Storage/PageUpdater.php(1085): MediaWiki\Storage\EditResultBuilder->buildEditResult()
#9 /var/www/html/includes/Storage/PageUpdater.php(1204): MediaWiki\Storage\PageUpdater->buildEditResult(MediaWiki\Revision\MutableRevisionRecord, boolean)
#10 /var/www/html/includes/Storage/PageUpdater.php(815): MediaWiki\Storage\PageUpdater->doModify(CommentStoreComment, User, integer)
#11 /var/www/html/includes/page/WikiPage.php(2225): MediaWiki\Storage\PageUpdater->saveRevision(CommentStoreComment, integer)
#12 /var/www/html/includes/page/WikiPage.php(2080): WikiPage->doUserEditContent(WikitextContent, User, CommentStoreComment, integer, boolean, array, integer)
#13 /var/www/html/includes/EditPage.php(2361): WikiPage->doEditContent(WikitextContent, string, integer, boolean, User, string, array, integer)
#14 /var/www/html/includes/EditPage.php(1694): EditPage->internalAttemptSave(array, boolean)
#15 /var/www/html/includes/EditPage.php(669): EditPage->attemptSave(array)
#16 /var/www/html/includes/actions/EditAction.php(71): EditPage->edit()
#17 /var/www/html/includes/actions/SubmitAction.php(38): EditAction->show()
#18 /var/www/html/includes/MediaWiki.php(531): SubmitAction->show()
#19 /var/www/html/includes/MediaWiki.php(315): MediaWiki->performAction(Article, Title)
#20 /var/www/html/includes/MediaWiki.php(913): MediaWiki->performRequest()
#21 /var/www/html/includes/MediaWiki.php(546): MediaWiki->main()
#22 /var/www/html/index.php(53): MediaWiki->run()
#23 /var/www/html/index.php(46): wfIndexMain()
#24 {main}

Manjaro
Bearbeiten Sie diesen Text auf MediaWiki:Citizen-footer-desc/de

Datenschutz
Über Manjaro
Haftungsausschluss
Mobile Ansicht
Bearbeiten Sie diesen Text auf MediaWiki:Citizen-footer-tagline/de
GNU Free Documentation License 1.3 or later
Powered by MediaWiki

@codesardine

Error 1021: Disk full (/tmp/#sql-temptable-1-0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (manjaro-wiki_database_1)

Is this system using btrfs ???

[papajoke]

@andreas85

system using btrfs ???

/tmp/ is the ram ! 50% of your ram (used here to decompress an archive ?)

[andreas85]

@papajoke

/tmp/ is the ram ! 50% of your ram

df /tmp
Dateisystem    Größe Benutzt Verf. Verw% Eingehängt auf
tmpfs            33G    6,5G   27G   20% /tmp

@papajoke

(used here to decompress an archive ?)

No, i only tried to change one paragraph in the wiki (less then 40 lines)

This is the full text i tried to insert:

Here the full scope of btrfs' difference becomes visible. When btrfs takes snapshots, many files are contained unchanged in several snapshots, but only take up space in the file system once. At the same time, there can be the same(!) file with different content and size in the different snapshots.

It is therefore not enough to simply add up the size of all files in a path to determine the space consumption in the file system.

For each file, it must be determined how large it is and whether all or part of it is shared with other subvolumes. Since btrfs has to read a lot of metadata for this, it can take a long time to display the results:

Total:
The sum of all files, as "du" would display them in a conventional file system
Exclusive:
The sum of the files that "only" occur in one of the subvolumes and are not shared with other subvolumes
Set shared:
The sum of files shared with other subvolumes

Exclusive+shared
This is the actual space used in the file system
Total
This is how much space a conventional file system would use to store these files (and all the necessary copies).

I will try again after cleaning my /tmp out

cat /etc/fstab|grep tmpfs
tmpfs 						/tmp			tmpfs	defaults,size=70%,mode=1777					0 0

/tmp was “only” at 20% full

[papajoke]

ok, wiki is break
in all pages :

Error creating thumbnail: Unable to save thumbnail to destination

codesardine is not admin but you have @Yochanan

[andreas85]

@papajoke

ok, wiki is break
in all pages :

So i will stop trying to edit something

If /tmp is on btrfs, you can find good info on how to repair it in the wiki

[Yochanan]

@papajoke

codesardine is not admin but you have

Wiki Admin ≠ server admin

[papajoke]

not with btrfs, this wiki is an official docker mediawiki image

[Aragorn]

@papajoke

/tmp/ is the ram !

Strictly speaking, no, tmpfs is a virtual memory filesystem, not a RAM disk. This means that its contents can be paged out to the swap device if needed.

Of course, the virtual filesystem layer in the kernel doesn’t make any distinction between storage in RAM versus storage on disk, but what the error either way means is that there is indeed a lack of free storage space, and considering that tmpfs can be paged out to the swap device, things would indeed ultimately point at there not being enough swap.

[oguzkagan]

Can you try again? It was related mediawiki logs.

[andreas85]

I did

Btrfs

There was no error while editing this.

[papajoke]

@oguzkagan

try again

only read wiki, always same error “Error creating thumbnail:” in all pages (with thumbnail ?)
example

EDIT: now it’s OK

[andreas85]

@papajoke

only read wiki, always same error “Error creating thumbnail:” in all pages (with thumbnail ?)
example

I can’t reproduce this. You may need to take a screenshot or copy the compßlete error-text

[oguzkagan]

Yeah something broke. Now, it should be fixed. I think, it would be good to create a cron job for clear logs ::

[cscs]

Why does the idea of adding cron/cronie keep coming up when we have systemd?
I have yet to see a good reason for having another timer/management system.
I know cronie came with the default profile … but IIRC that is only because of some dependency requirement, while systemd timers are already in use.

[soundofthunder]

@cscs

systemd timers are already in use

This might be a good topic for the wiki, if it’s not already sufficiently covered.

[cscs]

https://wiki.archlinux.org/title/Systemd/Timers

[soundofthunder]

Yup, that seems to cover it.