Topic on Project:Support desk

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (localhost)

5
Strela9K (talkcontribs)

MediaWiki V1.30.0

PHP version 5.6.33-0+deb8u1 (apache2handler)

MySQL version 5.5.59-0+deb8u1-log

URL: https://wiki.iceh.eu/index.php/Main_Page

Hey, I have a wiki for own purposes running on a raspberry pi. It used to work without a problem, but now I'm having trouble opening my

Ansible - Configuration page https://wiki.iceh.eu/index.php/Configuration All other pages work. I tried to run php update.php just in case.

It seems like my MySQL crashes (restarts) when I try to access Configuration. I get the following error:

MediaWiki internal error.

Original exception: [e8c603824f627c5fc7fbdf09] /index.php/Configuration Wikimedia\Rdbms\DBQueryError from line 1149 of /usr/share/mediawiki-1.30.0/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT old_text,old_flags FROM `text` WHERE old_id = '41' LIMIT 1

Function: Revision::fetchText

Error: 2002 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (localhost)

Backtrace:

#0 /usr/share/mediawiki-1.30.0/includes/libs/rdbms/database/Database.php(979): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#1 /usr/share/mediawiki-1.30.0/includes/libs/rdbms/database/Database.php(1343): Wikimedia\Rdbms\Database->query(string, string)

#2 /usr/share/mediawiki-1.30.0/includes/libs/rdbms/database/Database.php(1411): Wikimedia\Rdbms\Database->select(string, array, array, string, array, array)

#3 /usr/share/mediawiki-1.30.0/includes/Revision.php(1672): Wikimedia\Rdbms\Database->selectRow(string, array, array, string, array)

#4 /usr/share/mediawiki-1.30.0/includes/Revision.php(1637): Revision->fetchText()

#5 [internal function]: Revision->{closure}(boolean, integer, array, NULL)

#6 /usr/share/mediawiki-1.30.0/includes/libs/objectcache/WANObjectCache.php(1012): call_user_func_array(Closure, array)

#7 /usr/share/mediawiki-1.30.0/includes/libs/objectcache/WANObjectCache.php(914): WANObjectCache->doGetWithSetCallback(string, integer, Closure, array)

#8 /usr/share/mediawiki-1.30.0/includes/Revision.php(1640): WANObjectCache->getWithSetCallback(string, integer, Closure, array)

#9 /usr/share/mediawiki-1.30.0/includes/Revision.php(1084): Revision->loadText()

#10 /usr/share/mediawiki-1.30.0/includes/Revision.php(1101): Revision->getSerializedData()

#11 /usr/share/mediawiki-1.30.0/includes/Revision.php(1071): Revision->getContentInternal()

#12 /usr/share/mediawiki-1.30.0/includes/page/Article.php(362): Revision->getContent(integer, User)

#13 /usr/share/mediawiki-1.30.0/includes/page/Article.php(552): Article->fetchContentObject()

#14 /usr/share/mediawiki-1.30.0/includes/actions/ViewAction.php(68): Article->view()

#15 /usr/share/mediawiki-1.30.0/includes/MediaWiki.php(499): ViewAction->show()

#16 /usr/share/mediawiki-1.30.0/includes/MediaWiki.php(293): MediaWiki->performAction(Article, Title)

#17 /usr/share/mediawiki-1.30.0/includes/MediaWiki.php(851): MediaWiki->performRequest()

#18 /usr/share/mediawiki-1.30.0/includes/MediaWiki.php(523): MediaWiki->main()

#19 /usr/share/mediawiki-1.30.0/index.php(43): MediaWiki->run()

#20 {main}

Exception caught inside exception handler: [e8c603824f627c5fc7fbdf09] /index.php/Configuration Wikimedia\Rdbms\DBConnectionError from line 800 of /usr/share/mediawiki-1.30.0/includes/libs/rdbms/database/Database.php: Cannot access the database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (localhost)

Backtrace:

#0 /usr/share/mediawiki-1.30.0/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1028): Wikimedia\Rdbms\Database->reportConnectionError(string)

#1 /usr/share/mediawiki-1.30.0/includes/libs/rdbms/loadbalancer/LoadBalancer.php(670): Wikimedia\Rdbms\LoadBalancer->reportConnectionError()

#2 /usr/share/mediawiki-1.30.0/includes/GlobalFunctions.php(2858): Wikimedia\Rdbms\LoadBalancer->getConnection(integer, array, boolean)

#3 /usr/share/mediawiki-1.30.0/includes/cache/localisation/LCStoreDB.php(45): wfGetDB(integer)

#4 /usr/share/mediawiki-1.30.0/includes/cache/localisation/LocalisationCache.php(392): LCStoreDB->get(string, string)

#5 /usr/share/mediawiki-1.30.0/includes/cache/localisation/LocalisationCache.php(291): LocalisationCache->loadSubitem(string, string, string)

#6 /usr/share/mediawiki-1.30.0/languages/Language.php(2587): LocalisationCache->getSubitem(string, string, string)

#7 /usr/share/mediawiki-1.30.0/includes/cache/MessageCache.php(933): Language->getMessage(string)

#8 /usr/share/mediawiki-1.30.0/includes/cache/MessageCache.php(888): MessageCache->getMessageForLang(LanguageEn, string, boolean, array)

#9 /usr/share/mediawiki-1.30.0/includes/cache/MessageCache.php(829): MessageCache->getMessageFromFallbackChain(LanguageEn, string, boolean)

#10 /usr/share/mediawiki-1.30.0/includes/Message.php(1275): MessageCache->get(string, boolean, LanguageEn)

#11 /usr/share/mediawiki-1.30.0/includes/Message.php(842): Message->fetchMessage()

#12 /usr/share/mediawiki-1.30.0/includes/Message.php(971): Message->toString(string)

#13 /usr/share/mediawiki-1.30.0/includes/exception/MWExceptionRenderer.php(131): Message->escaped()

#14 /usr/share/mediawiki-1.30.0/includes/exception/MWExceptionRenderer.php(54): MWExceptionRenderer::reportHTML(Wikimedia\Rdbms\DBQueryError)

#15 /usr/share/mediawiki-1.30.0/includes/exception/MWExceptionHandler.php(75): MWExceptionRenderer::output(Wikimedia\Rdbms\DBQueryError, integer)

#16 /usr/share/mediawiki-1.30.0/includes/exception/MWExceptionHandler.php(130): MWExceptionHandler::report(Wikimedia\Rdbms\DBQueryError)

#17 /usr/share/mediawiki-1.30.0/includes/MediaWiki.php(550): MWExceptionHandler::handleException(Wikimedia\Rdbms\DBQueryError)

#18 /usr/share/mediawiki-1.30.0/index.php(43): MediaWiki->run()

#19 {main}

Ciencia Al Poder (talkcontribs)

Look at the mysql error logs in case it contains hints about what can be happening and to confirm if mysql is crashing on that page.

Strela9K (talkcontribs)

Thank you for the reply. I've checked mysql.log already. It seems like something is wrong with the table "text". Every time a query tries to read anything from it. Mysql service restarts.

I've also tried doing mysqlcheck... which again crashes the process when it tries to read from that table. Not sure what I should do... or if I can actually do anything about it.

Ciencia Al Poder (talkcontribs)
Strela9K (talkcontribs)

Thank you for you time and finding! Much appreciated.