|
|
Re: Import problem at fud30_msg [message #167357 is a reply to message #167342] |
Sat, 09 June 2012 20:23 |
|
ShineOn
Messages: 53 Registered: July 2011
Karma: 1
|
Member |
|
|
Frank, thanks, as usual, for your prompt reply.
Process list shows no mysql activity. The process is being killed by the kernel when I set memory_limit to -1 in admimport.
The line I have been messing with is the @ini_set line, from /* main */
@ini_set('memory_limit', '256M');
@set_time_limit(0);
With admimport memory_limit set to -1, this is what shows at the tail end of the import screen in adm panel:
Process table fud30_mime:
...43 rows loaded.
Process table fud30_mod:
...143 rows loaded.
Process table fud30_msg: The relevant section of the dmesg log: Out of memory: kill process 14258 (php-cgi) score 363611 or a child
Killed process 14258 (php-cgi) vsz:2908888kB, anon-rss:864564kB, file-rss:16kB
Again, this is with memory_limit set to -1 instead of 256M in admimport. With the stock admimport memory_limit of 256M, I get this in adm panel:Process table fud30_mime:
...43 rows loaded.
Process table fud30_mod:
...143 rows loaded.
Process table fud30_msg:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 523800 bytes) in /home/<user>/<domain>_files/FUDforum/include/theme/default/db.inc on line 168 and in the forum apache error log: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 523800 bytes) in /home/<usedr>/<domain>_files/FUDforum/include/theme/default/db.inc on line 168, referer: http://<url>/adm/admimport.php?rid=42&SQ=e222280852faf75391ed5282969bc414
Note: if I set the memory_limit in admimport to 512M, the error that's thrown is identical, except it has a higher memory value and says "... db.inc on line 53, ..." instead of line 168
System info: FUDforum version: 3.0.3
PHP version: 5.3.13
PHP built on: Linux <server name> 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64
Database type: mysql (mysqli)
Database version: 5.5.16
Web server: Apache/2
Web Server load: 0.03
Web server to PHP interface: cgi-fcgi
WebServer User/Group: <user> / <group> (503/505)
Relevant PHP settings:
Safe mode: OFF
Open basedir: /home/<user>/:/tmp/
Display errors: ON
File uploads: ON
Maximum file upload size: 32M
Magic quotes: ON
Output buffering: Yes
Disabled functions: exec, system, passthru, shell_exec, escapeshellarg, escapeshellcmd, proc_close, proc_open, dl, popen, show_source
PSpell support: No
Zlib support: Yes
Please note I am still tweaking settings on the new host server, so if there are any settings I should change immediately, please advise.
Also, the old host is no longer available, so all I have to work with is the backup file I am trying to restore, so please don't ask me to redo the dump - I can't.
|
|
|
|
|
Re: Import problem at fud30_msg [message #167379 is a reply to message #167359] |
Tue, 12 June 2012 01:05 |
|
ShineOn
Messages: 53 Registered: July 2011
Karma: 1
|
Member |
|
|
I trimmed down all processes as much as possible. My VPS has 1GB RAM and 2GB swap, and after clean reboot, starting out with 0 swap used, running the import results in swap filling up completely and OOM killing php. Something else must be wrong. Is there a way to bypass the msg table import and run that separately?
[Updated on: Tue, 12 June 2012 02:00] Report message to a moderator
|
|
|
|
|