[1.6] Importing from Serendipity hangs

Discussion corner for Developers of Serendipity.
Post Reply
User avatar
seraphyn
Regular
Posts: 211
Joined: Fri Dec 01, 2006 8:42 am
Contact:

[1.6] Importing from Serendipity hangs

Post by seraphyn » Mon Jun 06, 2011 6:46 pm

Used the CVS and I've one showstopper in the import-function import from serendipity admin interface.
fromhttp://board.s9y.org/viewtopic.php?f=6& ... p=10425207
Put the DB-data after installation from the other s9y-Installation in and pressed import.
This runs over an hour with 100% on the dbms.
Have had a restart of the dbms to stop the use of 100% cpu.
Refreshed the import-gui and stand next to the login-page again.
Looks like an timeout for me.
But all entries are well imported.
Comments are not all well, template shows 3 comments, but only 2 are shown.

1.6 clean install in another subdomain.
Apache2 Version: 2.2.16-6+squeeze1
PHP5 Version: 5.3.3-7+squeeze1
DBMS: mysql Version: 5.1.49-3
btw Version 1.5.5 import to 1.6
garvinhicking wrote:Hi!

How large is your install, i.e. the sql dump? Can you open a new thread for this so we can work it out.

Regards,
Garvin
Files: 95MB (96780)
SQL:
42 tables
Entries at all 1,111,144
size of over all 169,3 MiB
Machine is a 2.4GHZ p4 with 1GB RAM.
Footprint debian without running services 17MB RAM.
With all services 278MB RAM used. (nfs, ushare, cups, apache2, mysql, tinytinyrss with cron update every 4 hours, backup only in the early morning)
MySQL got 128MB RAM in key_buffer. <--- the only change
Is php.ini needed too?

Looks like a timeout for my session or something else.
It is possible for me to delete the db in the dbms reinstall it the same way...

Greetings Chris

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: [1.6] Importing from Serendipity hangs

Post by garvinhicking » Tue Jun 07, 2011 10:46 am

Hi!

Hm, 163MB of data to copy inside a single PHP script might take some time. Are you running PHP as CGI or mod_php? You might need to change php.ini to allow max_execution_time for i.e. 10 Minutes, and then retry the import.

I'm also quite sure this is a server timeout issue; on the s9y side it's hard to do something about it...

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

User avatar
seraphyn
Regular
Posts: 211
Joined: Fri Dec 01, 2006 8:42 am
Contact:

Re: [1.6] Importing from Serendipity hangs

Post by seraphyn » Tue Jun 07, 2011 10:53 am

Running as mod.
I think I need to change the max_input_time too?
Was just a minute.
So I'll raise up the max_input_time and the max_execution_time to ae 30 minutes and restest again.
I'll send feedback later this day.

Chris

EDIT:
Possibility to run this with php-cli to have a verbose output. that I could control in this case?

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: [1.6] Importing from Serendipity hangs

Post by garvinhicking » Tue Jun 07, 2011 1:54 pm

Hi!

You can't easily run it in php-cli due to authentication requiring a cookie etc.

You could edit the importer file and use echo/logging/fwrite for every performed SQL query and some breakpoints...

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

User avatar
seraphyn
Regular
Posts: 211
Joined: Fri Dec 01, 2006 8:42 am
Contact:

Re: [1.6] Importing from Serendipity hangs

Post by seraphyn » Tue Jun 07, 2011 1:56 pm

Try my best.
DBMS aren't normally my world, but still ready to learn ;)
Chris

Post Reply