FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Importing backups stopped working (Import dies without error)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Importing backups stopped working [message #186716] Fri, 09 January 2015 22:59 Go to next message
GaryM is currently offline  GaryM   United States
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!


[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 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3771
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 Go to previous messageGo to next message
GaryM is currently offline  GaryM   United States
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.



[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 Go to previous messageGo to next message
NeXuS is currently offline  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.
Re: Importing backups stopped working [message #186759 is a reply to message #186719] Thu, 19 February 2015 21:55 Go to previous messageGo to next message
GaryM is currently offline  GaryM   United States
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.


[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 Go to previous messageGo to next message
GaryM is currently offline  GaryM   United States
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.



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

Report message to a moderator

Re: Importing backups stopped working [message #186806 is a reply to message #186760] Sat, 07 March 2015 09:23 Go to previous message
anshuminesh19 is currently offline  anshuminesh19   India
Messages: 2
Registered: March 2015
Karma: 0
Junior Member
Thanks to all. I was also facing same issue for my website. Now that issue has been resolved. Thank you
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Password protected forum & quick reply
Next Topic: Can't backup
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 28 08:18:41 GMT 2024

Total time taken to generate the page: 1.76982 seconds