Last modified: 2012-12-17 12:16:30 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T39464, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 37464 - update.php fails with DB connection error: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 (mysqlsvr)
update.php fails with DB connection error: Lost connection to MySQL server at...
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
1.19.0
All Linux
: Unprioritized normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-06-11 15:15 UTC by Craig Duncan
Modified: 2012-12-17 12:16 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Craig Duncan 2012-06-11 15:15:21 UTC
During an upgrade from 1.18.3 to 1.19.0 the update script failed with an mysql connect error.

At this point I couldn't connect to the mysql server using any means, for a minute or so, and then I was able to connect fine.

Ran the script again, and the same thing happened, so it seems the script is causing the mysql server to start rejecting connections temporarily.

Tail of output from update.php...

...have rd_interwiki field in redirect table.
...transcache tc_time already converted.
...eu_wiki_id already renamed to eu_local_id.
...*_mime_minor fields are already long enough.
...iwlinks table already exists.
...index iwl_prefix_title_from already set on iwlinks table.
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...iwl_prefix_from_title key doesn't exist.
Adding cl_collation field to table categorylinks...DB connection error: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 (mysqlsvr)
Comment 1 Sam Reed (reedy) 2012-06-11 18:02:42 UTC
(In reply to comment #0)
> During an upgrade from 1.18.3 to 1.19.0 the update script failed with an mysql
> connect error.
> 
> At this point I couldn't connect to the mysql server using any means, for a
> minute or so, and then I was able to connect fine.
> 
> Ran the script again, and the same thing happened, so it seems the script is
> causing the mysql server to start rejecting connections temporarily.

Is mysql still running? It sounds like it died
Comment 2 Craig Duncan 2012-06-11 18:08:00 UTC
I presume so, as I have nothing that automatically restarts it, and it is available to connect to moments later.
Comment 3 Andre Klapper 2012-12-15 16:57:59 UTC
Craig: Was this reproducible, also when upgrading to MW 1.19.3 or 1.20.2?
Comment 4 Craig Duncan 2012-12-17 12:16:30 UTC
It looks like this was a result of poorly configured mysql server. No problem with the upgrade script

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links