Topic on Project:Support desk

PHP 7.0 (had 7.2 downgraded to 7.1 and 7.0 without any change)

Apache2

Database: mysql  Ver 15.1 Distrib 10.4.1-MariaDB, for Linux (x86_64) using readline 5.1

I had my wiki running for around 2 month without any problems. After patching the server (yum update -y) I cannot update pages anymore.

Full blank installation fails, too:

Datenbank wird eingerichtet… erledigt

Datentabellen werden erstellt… erledigt

Datenbankbenutzer wird erstellt… erledigt

Interwikitabellen werden eingerichtet… erledigt

Statistiken werden initialisiert… erledigt

Geheimschlüssel werden erstellt… erledigt

Unnötige Aktualisierungen nicht ausführen… erledigt

Administratorkonto wird erstellt… erledigt

Erstellung der Hauptseite mit Standardinhalten… gescheitert

Informationen

Die Hauptseite konnte nicht erstellt werden: Failed to update page row to use new revision.

Example of working wiki with broken pages: https://wiki.lethentir.de/Sandkasten

Example of wiki failing during setup: https://www.lethentir.de/wiki/mediawiki-1.31.1/mw-config/index.php

Any idea?

The message is too generic. Maybe a database error occurred (database may be read-only or has some corrupted table). Try saving a page and if it fails, enable exception details as detailed in Manual:How to debug

IP: 109.192.195.203
Start request POST /index.php?title=Sandkasten&action=submit
HTTP HEADERS:
HOST: wiki.lethentir.de
CONNECTION: keep-alive
CONTENT-LENGTH: 1975
CACHE-CONTROL: max-age=0
ORIGIN: https://wiki.lethentir.de
UPGRADE-INSECURE-REQUESTS: 1
CONTENT-TYPE: multipart/form-data; boundary=----WebKitFormBoundarygoXp18MEazJ5ooog
USER-AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
REFERER: https://wiki.lethentir.de/index.php?title=Sandkasten&action=edit
ACCEPT-ENCODING: gzip, deflate, br
ACCEPT-LANGUAGE: en-GB,en;q=0.9,en-US;q=0.8,de;q=0.7
COOKIE: wiki_wiki_UserName=Nagajdin; wiki_wiki__session=eskg2cr1aeqp3bjbchh337vknoa0oc6h; wiki_wiki_UserID=1
[StashEdit] Cached parser output for key 'wiki-wiki_:prepared-edit:d9dcfd4230c2c9560ec5594343bb5f2c:406e884f0fa990682eaa7cb894f3c8f38c7fe6a1:7a347af025660092f3f54c01a7842865' ('Sandkasten').
[DBQuery] wiki SELECT /* {closure}  */ RELEASE_LOCK('49ba59ab9b02dbd9112898544c03695a7c46b742') as lockstatus
[caches] cluster: SqlBagOStuff, WAN: mediawiki-main-default, stash: db-replicated, message: SqlBagOStuff, session: SqlBagOStuff
[DBQuery] wiki REPLACE /* SqlBagOStuff::setMulti  */ INTO `wiki_objectcache` (keyname,value,exptime) VALUES ('wiki-wiki_:stashedit:text:9addbf544119efa4a64223b649750a510f0d463f','+▒2▒R▒\0 %k\0','20190107113158')
[caches] LocalisationCache: using store LCStoreCDB
[Mime] MimeAnalyzer::loadFiles: loading mime types from /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/libs/mime/mime.types

[Mime] MimeAnalyzer::loadFiles: loading mime info from /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/libs/mime/mime.info

MediaWiki::preOutputCommit: primary transaction round committed
MediaWiki::preOutputCommit: pre-send deferred updates completed
MediaWiki::preOutputCommit: LBFactory shutdown completed
[cookie] setcookie: "UseDC", "master", "1546860428", "/", "", "1", "1"
[cookie] setcookie: "UseCDNCache", "false", "1546860428", "/", "", "1", "1"
[DBQuery] wiki COMMIT /* MWCallableUpdate::doUpdate  */
[DBQuery] wiki BEGIN /* Wikimedia\Rdbms\Database::query (Pingback::checkIfSent)  */
[DBQuery] wiki SELECT /* Pingback::checkIfSent  */  ul_value  FROM `wiki_updatelog`    WHERE ul_key = 'Pingback-1.31.1'  LIMIT 1
[DBQuery] wiki COMMIT /* MWCallableUpdate::doUpdate  */
Request ended normally
[session] Saving all sessions on shutdown
[DBConnection] Wikimedia\Rdbms\{closure}: closing connection to database 'localhost'.
[DBConnection] Wikimedia\Rdbms\{closure}: closing connection to database 'localhost'.
[DBConnection] Wikimedia\Rdbms\LoadBalancer::openConnection: calling initLB() before first connection.
[DBReplication] Cannot use ChronologyProtector with EmptyBagOStuff.
[DBReplication] Wikimedia\Rdbms\LBFactory::getChronologyProtector: using request info {
    "IPAddress": "109.192.195.203",
    "UserAgent": "Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/71.0.3578.98 Safari\/537.36",
    "ChronologyProtection": false,
    "ChronologyPositionIndex": 0
}
[DBConnection] Wikimedia\Rdbms\LoadBalancer::openConnection: connected to database 0 at 'localhost'.
[DBQuery] wiki SHOW /* Wikimedia\Rdbms\DatabaseMysqlBase::serverIsReadOnly  */ GLOBAL VARIABLES LIKE 'read_only'
[SQLBagOStuff] Connection 2460 will be used for SqlBagOStuff
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:global:user:id:wiki-wiki_:1'
[SQLBagOStuff] Connection 2460 will be used for SqlBagOStuff
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'wiki-wiki_:MWSession:eskg2cr1aeqp3bjbchh337vknoa0oc6h'
[DBConnection] Wikimedia\Rdbms\LoadBalancer::openConnection: connected to database 0 at 'localhost'.
[DBQuery] wiki BEGIN /* Wikimedia\Rdbms\Database::query (WikiPage::pageData)  */
[DBQuery] wiki SELECT /* WikiPage::pageData  */  page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model  FROM `wiki_page`    WHERE page_namespace = '0' AND page_title = 'Sandkasten'  LIMIT 1
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:page-restrictions:5:539'
Title::getRestrictionTypes: applicable restrictions to Sandkasten are {edit,move}
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:page-content-model:539'
[ContentHandler] Created handler for wikitext: WikitextContentHandler
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:page-content-model:539'
EditPage::edit: enter
EditPage::importFormData: Passed token check.
User: loading options for user 1 from override cache.
[DBQuery] wiki SELECT /* Title::getCascadeProtectionSources  */  pr_page,page_namespace,page_title,pr_expiry,pr_type,pr_level  FROM `wiki_templatelinks`,`wiki_page_restrictions`,`wiki_page`    WHERE tl_namespace = '0' AND tl_title = 'Sandkasten' AND (tl_from=pr_page) AND pr_cascade = '1' AND (page_id=pr_page)
User::getBlockedStatus: checking...
[DBQuery] wiki SELECT /* Block::newLoad  */  ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_reason AS `ipb_reason_text`,NULL AS `ipb_reason_data`,NULL AS `ipb_reason_cid`,ipb_by,ipb_by_text,NULL AS `ipb_by_actor`  FROM `wiki_ipblocks`    WHERE ipb_address = 'Nagajdin'
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:global:revision-row-1.29:wiki-wiki_:5:539'
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:revisiontext:textid:tt%3A512'
[DBQuery] wiki SELECT /* MediaWiki\Storage\SqlBlobStore::fetchBlob  */  old_text,old_flags  FROM `wiki_text`    WHERE old_id = '512'  LIMIT 1
Article::fetchContentObject failed to retrieve content of revision 539
[DBQuery] wiki SELECT /* WikiPage::pageData  */  page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model  FROM `wiki_page`    WHERE page_namespace = '0' AND page_title = 'Sandkasten'  LIMIT 1
[DBQuery] wiki SELECT /* WikiPage::pageData  */  page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model  FROM `wiki_page`    WHERE page_namespace = '0' AND page_title = 'Sandkasten'  LIMIT 1
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:global:revision-row-1.29:wiki-wiki_:5:539'
timestamp: 20190106124650, edittime: 20190106124650
EditPage::internalAttemptSave: getting section 

[DBQuery] wiki SELECT /* WikiPage::pageData  */  page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model  FROM `wiki_page`    WHERE page_namespace = '0' AND page_title = 'Sandkasten'  LIMIT 1
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:revisiontext:textid:tt%3A512'
[DBQuery] wiki SELECT /* MediaWiki\Storage\SqlBlobStore::fetchBlob  */  old_text,old_flags  FROM `wiki_text`    WHERE old_id = '512'  LIMIT 1
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'wiki-wiki_:prepared-edit:d9dcfd4230c2c9560ec5594343bb5f2c:406e884f0fa990682eaa7cb894f3c8f38c7fe6a1:7a347af025660092f3f54c01a7842865'
[StashEdit] Timestamp-based cache hit for key 'wiki-wiki_:prepared-edit:d9dcfd4230c2c9560ec5594343bb5f2c:406e884f0fa990682eaa7cb894f3c8f38c7fe6a1:7a347af025660092f3f54c01a7842865' (age: 0 sec).
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:page-content-model:539'
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:revisiontext:textid:tt%3A512'
[DBQuery] wiki SELECT /* MediaWiki\Storage\SqlBlobStore::fetchBlob  */  old_text,old_flags  FROM `wiki_text`    WHERE old_id = '512'  LIMIT 1
[DBQuery] wiki SELECT /* SqlBagOStuff::getMulti  */  keyname,value,exptime  FROM `wiki_objectcache`    WHERE keyname = 'WANCache:v:wiki-wiki_:revisiontext:textid:tt%3A512'
[DBQuery] wiki SELECT /* MediaWiki\Storage\SqlBlobStore::fetchBlob  */  old_text,old_flags  FROM `wiki_text`    WHERE old_id = '512'  LIMIT 1
[DBQuery] wiki ROLLBACK /* MWExceptionHandler::rollbackMasterChangesAndLog  */
[exception] [XDM3gmJzZRr83-M4wG3LSwAAAAc] /index.php?title=Sandkasten&action=submit   MWException from line 1722 of /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/page/WikiPage.php: Could not find text for current revision 539.
#0 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/page/WikiPage.php(1674): WikiPage->doModify(WikitextContent, integer, User, string, array)
#1 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/EditPage.php(2214): WikiPage->doEditContent(WikitextContent, string, integer, boolean, User, string, array, integer)
#2 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/EditPage.php(1506): EditPage->internalAttemptSave(array, boolean)
#3 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/EditPage.php(652): EditPage->attemptSave(array)
#4 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/actions/EditAction.php(60): EditPage->edit()
#5 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/actions/SubmitAction.php(38): EditAction->show()
#6 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/MediaWiki.php(500): SubmitAction->show()
#7 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/MediaWiki.php(294): MediaWiki->performAction(Article, Title)
#8 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/MediaWiki.php(861): MediaWiki->performRequest()
#9 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/includes/MediaWiki.php(524): MediaWiki->main()
#10 /var/www/html/wiki.lethentir.de/html/mediawiki-1.31.1/index.php(42): MediaWiki->run()
#11 {main}
[DBQuery] wiki BEGIN /* Wikimedia\Rdbms\Database::query (Pingback::checkIfSent)  */
[DBQuery] wiki SELECT /* Pingback::checkIfSent  */  ul_value  FROM `wiki_updatelog`    WHERE ul_key = 'Pingback-1.31.1'  LIMIT 1
[DBQuery] wiki COMMIT /* MWCallableUpdate::doUpdate  */
[DBQuery] wiki SELECT /* JobQueueDB::doGetSiblingQueuesWithJobs  */  DISTINCT job_cmd  FROM `wiki_job`    WHERE job_cmd IN ('refreshLinks','deleteLinks','htmlCacheUpdate','sendMail','enotifNotify','fixDoubleRedirect','AssembleUploadChunks','PublishStashedFile','ThumbnailRender','recentChangesUpdate','refreshLinksPrioritized','refreshLinksDynamic','activityUpdateJob','categoryMembershipChange','clearUserWatchlist','cdnPurge','userGroupExpiry','clearWatchlistNotifications','enqueue','null')
Request ended normally
[session] Saving all sessions on shutdown
[DBConnection] Wikimedia\Rdbms\{closure}: closing connection to database 'localhost'.
[DBConnection] Wikimedia\Rdbms\{closure}: closing connection to database 'localhost'.

Setting these parameters had no effect to the output on the page:

$wgExceptionDetails = true;

$wgShowDBErrorBacktrace = true;

$wgDebugLogFile = "/var/www/html/wiki.lethentir.de/logs/debug-{$wgDBname}.log";

$wgDebugDumpSql = true;

Root Cause is in the database: Seems some kind of corruption happened.

Did a fresh reinstall of mariadb from scratch without any old database and setup ran fine.

Was able the import data into the database -> everything is running (except: I have to delete the pages with missing revisions)