Hi all
We are getting DB error: connect failed error uncontrollably populating into our email system. Currently we can’t start the postgrad database at all.
DB Error: connect failed
------------------------------------------------------------------
User Details
IP Address: XX.X.X.X
User-Agent: Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)
------------------------------------------------------------------
Root Urls
------------------------------------------------------------------
Current URL
http://help.yahoo.com/help/us/ysearch/slurp)
------------------------------------------------------------------
Back Trace
0 => array (
“function” => “sq_error_handler”,
“args” => array (
0 => 256,
1 => “DB Error: connect failed”,
2 => “[SYSTEM_ROOT]/core/include/mysource.inc”,
3 => 2133,
4 => array (
[Max Depth Reached]
)
)
),
1 => array (
“file” => “[SYSTEM_ROOT]/core/include/mysource.inc”,
“line” => 2133,
“function” => “trigger_error”,
“args” => array (
0 => “DB Error: connect failed”,
1 => 256
)
),
2 => array (
“file” => “[SYSTEM_ROOT]/core/include/mysource.inc”,
“line” => 206,
“function” => “changedatabaseconnection”,
“class” => “mysource”,
“type” => “->”,
“args” => array (
0 => “db”
)
),
3 => array (
“file” => “[SYSTEM_ROOT]/core/include/init.inc”,
“line” => 228,
“function” => “init”,
“class” => “mysource”,
“type” => “->”,
“args” => array (
[Empty]
)
),
4 => array (
“file” => “[SYSTEM_ROOT]/core/web/index.php”,
“line” => 28,
“args” => array (
0 => “[SYSTEM_ROOT]/core/include/init.inc”
),
“function” => “require_once”
)
Any help in resolving this error, this the first time we getting it
Cheers :unsure:
[quote]Hi all
We are getting DB error: connect failed error uncontrollably populating into our email system. Currently we can't start the postgrad database at all.
DB Error: connect failed
[…][/quote]
Hi
What do you have in logs??
If pgsql log to separate file check it.
This error can be if you have low or too high
max_connections in postgresql.conf
General if DB don't start it could be some error in
postgresql.conf or in semaphores in system configuration.
Regards
Arek
[quote]DB Error: connect failed
------------------------------------------------------------------
User Details
IP Address: XX.X.X.X
User-Agent: Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)[/quote]
It looks like your site may be getting hit by search bots. I’d suggest having a look at your logs and see if this is the case. You can also analyse what pages they were hitting (for example, searches or intensive asset listings) and what time it occurs (for example, 2am when page caches have expired).
It’s a difficult issue to tackle and can require a different approach in every case, because generally the traffic is legitimate. It could be a case of using a robots.txt file to stop search bots crawling search pages, or implementing more rigourous caching strategies.
If it’s causing your site to go down regularly and for long periods of time, you could look at actually reducing the number of connections that your servers handle at once (so they can start rejecting connections earlier and prevent the system from crashing for a lengthy period of time).
Dan.
[quote]It looks like your site may be getting hit by search bots. I'd suggest having a look at your logs and see if this is the case. You can also analyse what pages they were hitting (for example, searches or intensive asset listings) and what time it occurs (for example, 2am when page caches have expired).
It's a difficult issue to tackle and can require a different approach in every case, because generally the traffic is legitimate. It could be a case of using a robots.txt file to stop search bots crawling search pages, or implementing more rigourous caching strategies.
If it's causing your site to go down regularly and for long periods of time, you could look at actually reducing the number of connections that your servers handle at once (so they can start rejecting connections earlier and prevent the system from crashing for a lengthy period of time).
Dan.[/quote]
Thanks everyone it now being resolved through squiz helpdesk. Owen help us to fix up the issue, cheers Owen. :rolleyes: