Hi,
while importing the cur dump today I received this error message:
Error: MySQL server has gone away
This error occurs regardless of whether I pipe the dump through mysql (the "usual" way), or use a Perl script to import it through DBI (what I usually use because it gives me a progress meter).
My investigation pin-pointed this to one particular line in the cur dump which contains an INSERT statement which is for the page [[Wikipedia:Upload log]]. The one row of data for this page is 1051409 bytes.
So I'm wondering:
1) Why does that cause the above error message? Am I doing something wrong? 2) Do we have to have such a huge page? Can we circumvent this by splitting the page up?
Thanks, Timwi
Timwi-
Timwi wrote:
My investigation pin-pointed this to one particular line in the cur dump which contains an INSERT statement which is for the page [[Wikipedia:Upload log]].
I'm sorry - actually it is [[Wikipedia:Upload log archive/March 2004 (2)]].
For what it's worth, I imported the latest en:-dump a couple of days ago, and I had the same problem with the same page. I didn't have time to investigate, so I just removed the offending line from the .sql-file.
Out of curiosity, is this a standard Perl script you are using for importing with a progress meter? Can I download it somewhere?
Regards,
Erik
Erik Moeller wrote:
For what it's worth, I imported the latest en:-dump a couple of days ago, and I had the same problem with the same page. I didn't have time to investigate, so I just removed the offending line from the .sql-file.
Brion's suggestion helped and it worked.
You need to add something like this to /etc/my.cnf: [mysqld] set-variable = max_allowed_packet=16M
(or, if you are using MySQL 4 or above) [mysqld] max_allowed_packet=16M
and then restart.
Out of curiosity, is this a standard Perl script you are using for importing with a progress meter? Can I download it somewhere?
No, it's something I wrote. I added it to
http://meta.wikipedia.org/wiki/Useless_Perl_Scripts
so you can download it there.
Greetings, Timwi
wikitech-l@lists.wikimedia.org