DB Connection Error?! Help With Debug Plz

At random times I seem to get DB connection errors .... Below is whats shown .... Can anyone help me understand what the issue could be please?

Thanks in advance :)

Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 82
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => 
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => ************
                    [user] => *****
                    [password] => *****
                    [link] => 
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => 
                    [oDbCacheObject] => 
                    [_error] => 
                )

            [type] => ->
            [args] => Array
                (
                    [0] => Database connect failed
                    [1] => 1
                )

        )

    [2] => Array
        (
            [file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolDb.php
            [line] => 58
            [function] => connect
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => 
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => ************
                    [user] => *****
                    [password] => *****
                    [link] => 
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => 
                    [oDbCacheObject] => 
                    [_error] => 
                )

            [type] => ->
            [args] => Array
                (
                )

        )

    [3] => Array
        (
            [file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/db.inc.php
            [line] => 25
            [function] => BxDolDb
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => 
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => ************
                    [user] => *****
                    [password] => *****
                    [link] => 
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => 
                    [oDbCacheObject] => 
                    [_error] => 
                )

            [type] => ->
            [args] => Array
                (
                )

        )

    [4] => Array
        (
            [file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolAlerts.php
            [line] => 20
            [args] => Array
                (
                    [0] => /var/www/vhosts/socialmunch.com/httpdocs/inc/db.inc.php
                )

            [function] => require_once
        )

    [5] => Array
        (
            [file] => /var/www/vhosts/socialmunch.com/httpdocs/inc/header.inc.php
            [line] => 177
            [args] => Array
                (
                    [0] => /var/www/vhosts/socialmunch.com/httpdocs/inc/classes/BxDolAlerts.php
                )

            [function] => require_once
        )

    [6] => Array
        (
            [file] => /var/www/vhosts/socialmunch.com/httpdocs/browse.php
            [line] => 21
            [args] => Array
                (
                    [0] => /var/www/vhosts/socialmunch.com/httpdocs/inc/header.inc.php
                )

            [function] => require_once
        )

)

Called script: /browse.php
Request parameters:

Array
(
)
DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 11 Nov 2012

anyone have a idea what might cause DB connection failed errors please ?

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 11 Nov 2012

This right here. 

[0] => Database connect failed


I can think of only two posibilities.

1) Database server down
2) Database overloaded or at maxinium number of allowed connections.

Give that you said that it's random, then reason 2 is most likley.


https://www.deanbassett.com
Quote · 11 Nov 2012

I'm going to throw something out here..

looks like it's from the browse.php page.

Looking at that page, you have some "extra" members blocks down the right side. Try removing them one by one maybe. Who made those.?

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 11 Nov 2012

what are your

max_connections
max_user_connections

settings in my.cnf??

 

you could use tuning_primer or MySQLTuner to check your mysql configuration ...

http://www.boonex.com/market/posts/paansystems - your resource for Dolphin Pro
Quote · 11 Nov 2012

 hey man :)      well this happens at random times for random pages .... also happened to me on member.php

Oh and EU30 (i think that's the right developer)

I'm going to throw something out here..

looks like it's from the browse.php page.

Looking at that page, you have some "extra" members blocks down the right side. Try removing them one by one maybe. Who made those.?

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 11 Nov 2012

 that file shows following stuff ...I would also be happy if you can advise on other changes I should make bearing in mind I have a very active network:-


skip-external-locking
key_buffer = 384M
max_allowed_packet = 1M
max_connections = 300
max_user_connections = 35
wait_timeout=40
connect_timeout=10
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 4

max_connections = 300
max_user_connections = 35

what are your

max_connections
max_user_connections

settings in my.cnf??

 

you could use tuning_primer or MySQLTuner to check your mysql configuration ...

 

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 11 Nov 2012

 can you advise how I check and change this if required ??

I will try and research this info also ... thanks

"2) Database overloaded or at maxinium number of allowed connections".

This right here. 

[0] => Database connect failed


I can think of only two posibilities.

1) Database server down
2) Database overloaded or at maxinium number of allowed connections.

Give that you said that it's random, then reason 2 is most likley.


 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 11 Nov 2012

Save this mysql-tuner script and run it on your machine (assuming you have shell access):

https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl

 

Then check out the results... specificly:

[OK] Highest usage of available connections: 73% (147/200)

The longer your MySQL daemon has been up and running the better...

 
Quote · 11 Nov 2012

run it but don't have a clue what I'm looking at ... :(

Am still looking !

Save this mysql-tuner script and run it on your machine (assuming you have shell access):

https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl

 

Then check out the results... specificly:

[OK] Highest usage of available connections: 73% (147/200)

The longer your MySQL daemon has been up and running the better...

 

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 11 Nov 2012

 I don't see anything like this there ...

Highest usage of available connections: 73% (147/200)

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 11 Nov 2012

*shrug* not sure what to say... Here's a snip from mine:

 

-------- Performance Metrics -------------------------------------------------

[--] Up for: 7d 2h 41m 23s (93M q [151.779 qps], 1M conn, TX: 37B, RX: 25B)

[--] Reads / Writes: 94% / 6%

[--] Total buffers: 212.0M global + 2.7M per thread (200 max threads)

[OK] Maximum possible memory usage: 749.5M (20% of installed RAM)

[OK] Slow queries: 0% (3K/93M)

[OK] Highest usage of available connections: 73% (147/200)


 Perhaps your user doen't have enough privileges for that query??
Quote · 12 Nov 2012

can anyone tell me if the following looks right OR should be adjusted in anyway for best performance of server please:

skip-external-locking
key_buffer = 384M
max_allowed_packet = 1M
max_connections = 300
max_user_connections = 35
wait_timeout=40
connect_timeout=10
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 4

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 12 Nov 2012

 I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/

can anyone tell me if the following looks right OR should be adjusted in anyway for best performance of server please:

skip-external-locking
key_buffer = 384M
max_allowed_packet = 1M
max_connections = 300
max_user_connections = 35
wait_timeout=40
connect_timeout=10
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 4

 

Rules → http://www.boonex.com/terms
Quote · 13 Nov 2012

 Same as the link I posted above :)

 I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/

Quote · 13 Nov 2012

DAMN ..... every now and then and for different things my members are getting DB connection failed errors ?!

This is a new issue for my network!  I have never had a issue with such prior to this thread ..........

Anyone advise further with this please !

 

 Same as the link I posted above :)

 I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 14 Nov 2012

 anyone ?!

DAMN ..... every now and then and for different things my members are getting DB connection failed errors ?!

This is a new issue for my network!  I have never had a issue with such prior to this thread ..........

Anyone advise further with this please !

 

 Same as the link I posted above :)

 I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/

 

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 14 Nov 2012

 this does not give me any recommendations ?!

I run it several times and still same result ...

 I suggest to use the following perl script to optimize your MySQL parameters - http://mysqltuner.com/

can anyone tell me if the following looks right OR should be adjusted in anyway for best performance of server please:

skip-external-locking
key_buffer = 384M
max_allowed_packet = 1M
max_connections = 300
max_user_connections = 35
wait_timeout=40
connect_timeout=10
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 4

 

 

DedicatedServer4You.com -- BIGGEST Range of Dedicated Servers at the Lowest Price!
Quote · 14 Nov 2012

Sorry crack_foo, I didn't noticed this.

@Detective08 - try to change

max_connections = 300

to

max_connections = 1000

Rules → http://www.boonex.com/terms
Quote · 15 Nov 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.