HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=15)
-   -   MySQL connection errors (http://www.howtoforge.com/forums/showthread.php?t=6245)

drake 16th August 2006 13:55

MySQL connection errors
 
Hi
I'm running ISPConfig on SuSE 10, and although installation went well and the system seems to be working, I get regular mysql connection errors when using ispconfig itself and with the sites that I am hosting.

The errors are generally like:
"Error (ERROR_STORAGE_FAILURE) :
in modules/core/classes/GalleryStorage.class at line 229 (MySqlStorage::error)
in modules/core/classes/GalleryStorage.class at line 449 (MySqlStorage::_getConnection)
in modules/core/classes/Gallery.class at line 223 (MySqlStorage::search)
in modules/core/classes/GallerySession.class at line 911 (Gallery::search)
in modules/core/classes/GallerySession.class at line 261 (GallerySession::_loadSessionData)
in modules/core/classes/Gallery.class at line 315 (GallerySession::init)
in init.inc at line 125 (Gallery::initSession)
in main.php at line 73"

and I get similar types of errors while using the ispconfig control panel.

Generally the errors go after refreshing the page a few times, but it makes me think that there's something wrong with the setup.

My googling etc has turned up no clues as to how I can troubleshoot this.

Any ideas would be appreciated.

Cheers

drake

Ben 16th August 2006 14:57

What kind of gallery is that or another question what happens if you run
mysql on the console and use the same username and password for that as you use on that gallery?

Actually I don't know what that gallery directly has in common with ISPConfig.

drake 16th August 2006 15:06

MySQL storage errors
 
The gallery is Gallery2

The errors are not specific to the gallery (that was the first example I has to hand) - they occur with the ISPConfig admin pages, and my wordpress blogs. All the errors are similar.

Running in the console is fine - no probs. It doesn't seem to be an access problem as such, because refreshing the page a few times allows the content to be displayed properly.

Ben 16th August 2006 15:31

Hm that sounds strange... but what is the errormessage from mysqld then?

drake 16th August 2006 15:57

MySQL connection errors
 
There doesn't appear to be any error in /var/lib/mysql/mysqld.log or mysqld.log.1

falko 17th August 2006 16:44

This link: http://gallery.menalto.com/node/23630 means that one of your partitions could be full. What's the output of
Code:

df -h
?

drake 17th August 2006 18:45

MySQL connection errors
 
Hi
Thanks for the reply - unfortunately (in one sense :-) ) I have plenty of disk space:

Filesystem Size Used Avail Use% Mounted on
/dev/md1 5.1G 1.2G 3.9G 23% /
tmpfs 252M 0 252M 0% /dev/shm
/dev/sda1 31M 7.5M 22M 26% /boot
/dev/md3 9.5G 492M 9.0G 6% /home
/dev/md2 2.1G 665M 1.4G 33% /var

I'll post the error I get when using ispconfig as well.

drake 22nd August 2006 12:29

MySQL connection errors - maybe fixed
 
Hi
I've been fiddling with the MySQL settings in my.cnf and so far, the errors have stopped. Here are the settings that I'm using:
skip-locking
key_buffer = 64M
max_allowed_packet = 16M
table_cache = 1024
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 1M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
thread_cache_size = 64
wait_timeout = 900
connect_timeout = 10
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
max_connections = 600

Hopefully it'll stay fixed!

Thanks for the replies.

falko 23rd August 2006 15:04

What exactly did you change in your my.cnf?

drake 23rd August 2006 17:57

my.cnf changes
 
Hi Falko
I increased all of the buffer sizes, max_connections, thread_cache_size - in fact, pretty much every value in the list. max_connections had to be added as it wasn't there already. All the buffer sizes were quite low.

Unfortunately I wasn't clever enough to save the original for comparison....d'uh.

The original my.cnf was the default as per perferct-setup installation - I hadn't made any changes before getting the connection errors.


All times are GMT +2. The time now is 13:31.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.