Mysql time out error

Trouble during PacsOne Server installations
Post Reply
bobreaman
Posts:6
Joined:Thu Mar 31, 2005 5:53 pm
Mysql time out error

Post by bobreaman » Tue Apr 05, 2005 6:08 pm

I am getting mysql time out error:
Fatal error: Maximum execution time of 30 seconds exceeded in /opt/pacs/php/display.php on line 551

also some of the thumnail pictures shows up correctly most of them are not.

any idea to improve the performance of searches..?

Thanks,
Bob

pacsone
Site Admin
Posts:3149
Joined:Tue Sep 30, 2003 2:47 am

Post by pacsone » Tue Apr 05, 2005 6:56 pm

This is actually a PHP timeout instead of MySQL.

You can set the max_execution_time variable to 0 in your PHP.INI file so that PHP will never time out, and see if you get the same error, i.e.:

max_execution_time = 0

Also, the Premium Edition has page control so that it only displays 10 images per page instead of all images within the series, so it'd be surprising to see PHP timeout after 30 seconds trying to display 10 image thumbnails.

BTW, are you using the Premium Edition or the Basic Edition?

bob reaman

Post by bob reaman » Tue Apr 05, 2005 10:34 pm

i am using premium eval version.
fedora core 3, apache 2.0.52, php 4.3.9, mysql 4.0.21

the pages loading very slowley and few images i can view with the dicom viewer.

Thanks,
Bob

pacsone
Site Admin
Posts:3149
Joined:Tue Sep 30, 2003 2:47 am

Post by pacsone » Wed Apr 06, 2005 12:55 am

This seems like a bug as it should not take this long to create thumbnails for 10 images.

Can you do the following to trouble-shoot this problem further:

1. Pick one image where you could not see the thumbnail from the browser, there should be a Download link right below where the thumbnail image should be. Click on the Download link and save the downloaded zip file to the local computer.

2. The zip file should contain one raw image file named with the image UID. You can try any 3rd-party image viewer (eFilm, RadWorks, ezDicom etc.) to see if you can view the raw image file.

3. If you can view the image fine from the 3rd-party viewers, then the problem is with the ImageMagick PHP extension used by PacsOne. You can then send the zip file to mailto:pacsone@pacsone.net for us to reproduce the problem. You can anonymize the patient information if you're concerned about privacy.

4. Another good test is to click on the Dicom Tags link to dump all the raw Dicom tags to the browser window. This is another way to test if the raw image file itself is ok or not.

Post Reply