Last modified: 2012-07-06 05:18:11 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 T40202, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 38202 - Database error: "SqlBagOStuff::set". Database returned error "1114: The table 'pc233' is full (10.0.6.50)".
Database error: "SqlBagOStuff::set". Database returned error "1114: The table...
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Highest critical with 3 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
:
: 38203 38204 (view as bug list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-07-05 13:16 UTC by Krinkle
Modified: 2012-07-06 05:18 UTC (History)
12 users (show)

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


Attachments

Description Krinkle 2012-07-05 13:16:36 UTC
Just saving an edit:
 http://meta.wikimedia.org/w/index.php?title=Talk:Wikidata&action=submit


A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "SqlBagOStuff::set". Database returned error "1114: The table 'pc233' is full (10.0.6.50)".
Comment 1 Krinkle 2012-07-05 13:17:20 UTC
Not just when saving, here, reading a revision:

http://meta.wikimedia.org/w/index.php?title=Talk%3AWikidata&diff=3879256&oldid=3879182

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "SqlBagOStuff::set". Database returned error "1114: The table 'pc233' is full (10.0.6.50)".
Comment 2 Krinkle 2012-07-05 13:20:12 UTC
Not just pc233:

> The table 'pc193' is full (10.0.6.50)".
Comment 3 matanya 2012-07-05 13:21:40 UTC
I got it on other table : 
from within function "SqlBagOStuff::set". Database returned error "1114: The table 'pc193' is full (10.0.6.50)".

https://he.wikipedia.org/w/index.php?title=%D7%A9%D7%99%D7%97%D7%AA_%D7%9E%D7%A9%D7%AA%D7%9E%D7%A9:%D7%A2%D7%A8%D7%9F&action=submit
Comment 4 Chad H. 2012-07-05 13:22:55 UTC
*** Bug 38203 has been marked as a duplicate of this bug. ***
Comment 5 matanya 2012-07-05 13:26:47 UTC
upload as well, table pc006
upload failed from within function "SqlBagOStuff::set". Database returned error "1114: The table 'pc006' is full (10.0.6.50)".
Comment 6 Krinkle 2012-07-05 13:27:46 UTC
Seen on at least:
* metawiki
* commonswiki
* hewiki
* ptwiki
* itwiki

(all s7 cluster wikis)

So far all mention only 10.0.6.50 (db40, s7 cluster), though the pc### table varies.
Comment 7 reza1615 2012-07-05 13:29:21 UTC
also fawiki Bug 38203
Comment 8 Trijnstel 2012-07-05 13:34:59 UTC
also nlwiki
Comment 9 Trijnstel 2012-07-05 13:36:16 UTC
and also enwikisource
Comment 10 Chad H. 2012-07-05 13:37:17 UTC
It's affecting all wikis because db40 runs the parser cache. Please do not pile further "this wiki too" comments.
Comment 11 shi zhao 2012-07-05 13:38:05 UTC
also zhwiki.
Comment 12 Chad H. 2012-07-05 13:40:21 UTC
*** Bug 38204 has been marked as a duplicate of this bug. ***
Comment 14 Krinkle 2012-07-05 13:58:17 UTC
db40 just went down entirely. Now all reading is off for most/all wikis as well (including en.wikipedia.org).

Skin-less blank db error etc.:

> Sorry! This site is experiencing technical difficulties.
> Try waiting a few minutes and reloading.
> (Cannot contact the database server: Unknown error (10.0.6.50))
Comment 15 vigorous action 2012-07-05 14:02:05 UTC
also jawiki, jaws,jawb.
Comment 16 Chad H. 2012-07-05 14:05:49 UTC
(In reply to comment #15)
> also jawiki, jaws,jawb.

Also ~800 other wikis. Please see comment 10.
Comment 17 Christa 2012-07-05 14:10:25 UTC
funny error message in dewiki on read access:

"Error 500 Internal Server Error Internal Server Error
Guru Meditation: XID: 3696570436 Varnish cache server"
Comment 18 Max Semenik 2012-07-05 14:11:08 UTC
Christa, unrelated issue.
Comment 19 Krinkle 2012-07-05 14:15:56 UTC
(In reply to comment #18)
> Christa, unrelated issue.

Probably not unrelated, actually. db40 went down since ~ comment 14. And all requests that don't hit squid cache server skin-less db error pages (which head with HTTP 500 Internal Server Error).

bits varnish hitting the backend might get that too from the mediawiki/apaches.
Comment 20 Krinkle 2012-07-05 14:17:33 UTC
(Cite wikisal July 5)
> 14:07 logmsgbot: midom synchronized wmf-config/InitialiseSettings.php 'disabling parser cache for now'

Browsing is back up for everybody. Logged-in users bypassing parser cache. Logged-out users just hitting squids as usual.
Comment 21 Saibo 2012-07-05 20:13:25 UTC
It seems some links of files to categories (files are not shown on category pages even while being logged in) are broken:  https://commons.wikimedia.org/wiki/Commons:Village_pump#Database_error ([https://commons.wikimedia.org/w/index.php?title=Commons:Village_pump&oldid=73829498#Database_error perm.])  A null edit to the file pages helps. Maybe that (or a subset of the triggered actions) can be done to all affected files automatically.
Comment 22 Rob Lanphier 2012-07-06 05:18:11 UTC
Hi everyone, Domas got things back up and running earlier today.  We're still have some work to do to make sure we don't have a similar outage again which we're sorting out now, but the bug as reported was fixed this morning.

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


Navigation
Links