FUDforum: Bug Reports » Importing backups stopped working

Home » FUDforum Development » Bug Reports » Importing backups stopped working (Import dies without error)

Show: Today's Messages :: Polls :: Message Navigator

Importing backups stopped working [message #186716]

Fri, 09 January 2015 22:59

GaryM

Messages: 118
Registered: May 2013
Location: Seattle

Karma: 3

Senior Member

Took 3 different datadumps from my production forum today and tried importing them to my local sever copy and the import just dies, no errors. Dies in different places bu generally in this area:

Process table fud30_level:
...4 rows loaded.
Process table fud30_mime:
...43 rows loaded.
Process table fud30_mod:
...6 rows loaded.
Process table fud30_msg:

From the apache error log:

[Fri Jan 09 16:44:59.256328 2015] [:error] [pid 3267] [client 127.0.0.1:45795] PHP Warning:  Error while sending QUERY packet. PID=3267 in /home/curvex/public_html/FUDforum/include/theme/default/db.inc on line 110, referer: http://127.0.0.1/~curvex/vgforum/adm/admimport.php?&SQ=d510e0c9a990849a48d0e9e2b354f38d
[Fri Jan 09 16:45:00.174981 2015] [core:notice] [pid 588] AH00052: child pid 3267 exit signal Segmentation fault (11)

Interesting to know that I went back to a last year datadump, 11/29, after the upgrade to 3.0.6 and this datadump imports without issue. Did this import 2 times and both successfull. Also successfully (by mistake) imported a 3.0.5 backup onto a 3.0.6 release. Actually works.

Note after the import dies the forum is inaccessable. You have to run a fresh installl of the forum.

I'm not sure what's gpoing on, any help would be greatful.
Thanks!

http://vintagegruen.org

[Updated on: Sat, 10 January 2015 00:59]

Report message to a moderator

Re: Importing backups stopped working [message #186717 is a reply to message #186716]

Sat, 10 January 2015 06:57

naudefj

Messages: 3772
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Have you checked for errors in your web server's error_log?

http://httpd.apache.org/docs/1.3/logs.html#errorlog

[Updated on: Sat, 10 January 2015 07:01]

Report message to a moderator

Re: Importing backups stopped working [message #186718 is a reply to message #186717]

Sat, 10 January 2015 15:55

GaryM

Messages: 118
Registered: May 2013
Location: Seattle

Karma: 3

Senior Member

Yes the above code snippet is from my server's http error_log. I suspect that I'm hitting a size limit, memory, ect...Successfull imports are 510mb compressed. The imports that die are 550mb.

http://vintagegruen.org

[Updated on: Sat, 10 January 2015 16:45]

Report message to a moderator

Re: Importing backups stopped working [message #186719 is a reply to message #186718]

Sun, 11 January 2015 18:28

NeXuS
Messages: 121
Registered: July 2010
Location: South Korea

Karma: 5

Senior Member
Contributing Core Developer

Might be time execution limit: I don't quite remember how it is handled, but the runtime might just kill the process unceremoniously.

Report message to a moderator

Re: Importing backups stopped working [message #186759 is a reply to message #186719]

Thu, 19 February 2015 21:55

GaryM

Messages: 118
Registered: May 2013
Location: Seattle

Karma: 3

Senior Member

Bypassed the webserver and tried importing the lastest backup via the command line using php -q adminimport.php command. Got the same error but with more output and corefile dump:

Process table fud30_mod:
 ...6 rows loaded.
Process table fud30_msg:
PHP Warning:  Error while sending QUERY packet. PID=5331 in /var/www/FUDforum/include/theme/default/db.inc on line 110

Warning: Error while sending QUERY packet. PID=5331 in /var/www/FUDforum/include/theme/default/db.inc on line 110
Segmentation fault (core dumped)

/var/log/messages
Feb 19 11:55:47 localhost kernel: [10225.401780] php[5331]: segfault at 7fff18f03ff8 ip 00007f723c68be1f sp 00007fff18f04000 error 6 in php[7f723c485000+389000]
Feb 19 11:55:50 localhost abrt-hook-ccpp[5334]: Saved core dump of pid 5331 (/usr/bin/php) to /var/tmp/abrt/ccpp-2015-02-19-11:55:48-5331 (44138496 bytes)
Feb 19 11:55:53 localhost abrt-server[5335]: Generating core_backtrace
Feb 19 11:55:53 localhost abrt-server[5335]: Generating backtrace

Stringed the corefile out to a text file. A seach for pid 5331 came up with multiple entries and not sure what to make of it..

HY000
$pos, $mid) = db_saq('SELECT /* USE MASTER */ replies+1,last_post_id FROM {SQL_TABLE_PREFIX}thread WHERE id='. $th);
: Error while sending QUERY packet. PID=5331 in  in n pipe
bject)
hh.*r
 if ($_GET['goto']) { /* Verify that the thread & msg id are valid. */
`o.*r
$th) {
k.*r
= (int) q_singleval('SELECT /* USE MASTER */ thread_id FROM {SQL_TABLE_PREFIX}msg WHERE id='. $_GET['goto']);

packet bigger than 'max_allowed_packet' bytes
30_msg VALUES ('1','A
/var/www/FUDforum/include/theme/default/db.inc
e to FUDf1
MySQL server has gone away
',NULL,N1
MySQL server has gone away
,'0','191
MySQL server has gone away
L,'Sorry1

Cannot attach compressed corefile, larger the the 1024KB size. Any help or suggestions are much appreciated.

http://vintagegruen.org

[Updated on: Thu, 19 February 2015 22:44]

Report message to a moderator

Re: Importing backups stopped working [message #186760 is a reply to message #186759]

Fri, 20 February 2015 04:03

GaryM

Messages: 118
Registered: May 2013
Location: Seattle

Karma: 3

Senior Member

Good news! The max_allowed_packet from the core dump quizzed me to do a goggle search and found this to be a mysql setting. Suggestion was to change/add the setting max_allowed_packet=256M to the my.cnf file. I had to add this line in.

Import worked! Should add this workaround to the documentation. I assume most hosting providers have this packet allocation set. Unsure of what the default is by not having this specified.

I'm just glad now that I can verify my backups.

http://vintagegruen.org

[Updated on: Fri, 20 February 2015 04:13]

Report message to a moderator