View Single Post
  #1  
Old 02-28-2005, 10:02 PM
Da-Idiot Da-Idiot is offline
Member
 
Join Date: Jan 2005
Posts: 23
Default 503 error, phpMyAdmin running sql query

I am having problems with running large sql queries with PhpMyAdmin under lsws

The sql query that is being run is around 3MB

I thought at first it may be the upload_max_filesize = 2M So i changed it to 4M No go.

I then checked the logs and found

lsws/log/error.log

FATAL: emalloc(): Unable to allocate 2040073 bytes
FATAL: emalloc(): Unable to allocate 2040073 bytes
FATAL: emalloc(): Unable to allocate 2040073 bytes
FATAL: emalloc(): Unable to allocate 2040073 bytes
FATAL: emalloc(): Unable to allocate 2040073 bytes
FATAL: emalloc(): Unable to allocate 2040073 bytes

Then went to admin and changed

Debug Level = High
Log Level = Debug

Here are the lines from error.log that are being produced from the above settings.

2005-02-28 16:36:54.225 [DEBUG] Failed to execute 'mpstat' command: No such file or directory
2005-02-28 16:36:59.229 [DEBUG] Failed to execute 'mpstat' command: No such file or directory
2005-02-28 16:37:04.233 [DEBUG] Failed to execute 'mpstat' command: No such file or directory
2005-02-28 16:37:09.238 [DEBUG] Failed to execute 'mpstat' command: No such file or directory
2005-02-28 16:37:14.242 [DEBUG] Failed to execute 'mpstat' command: No such file or directory
2005-02-28 16:37:19.246 [DEBUG] Failed to execute 'mpstat' command: No such file or directory
2005-02-28 16:37:24.250 [DEBUG] Failed to execute 'mpstat' command: No such file or directory

I thought mpstat had to do with getting system info such as processor id and the such.

I know the above errors are being created when trying to run my sql queries because the same
thing keeps on growing in the log at the same time i am making the 503 come up


Please help me with this. I am slowly getting the site up again.

I am running now on suse 9.2 professional minimal install Kernel 2.6.x

thanx
Reply With Quote