Падает Http server (апач)

[poncho]

с недавних пор в логах апача вот такие строки появились

[Mon Nov 06 01:35:23 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:24 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:24 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:24 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:24 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:25 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:25 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:25 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:26 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:26 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:26 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:42 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:42 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:42 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:48 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:48 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:48 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:53 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:53 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:53 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:56 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:56 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:56 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:56 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:56 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:56 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:57 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:57 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:57 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:35:57 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:35:57 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:35:57 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:36:00 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:36:00 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:36:00 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:36:02 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\engine\\engine.php on line 34
[Mon Nov 06 01:36:05 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 67
[Mon Nov 06 01:36:05 2006] [error] PHP Warning:  mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 70
[Mon Nov 06 01:36:05 2006] [error] PHP Warning:  mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\\web\\forum\\sources\\Drivers\\mySQL.php on line 103
[Mon Nov 06 01:36:14 2006] [error] PHP Warning:  mysql_connect(): \xf3\xcc\xc9\xdb\xcb\xcf\xcd \xcd\xce\xcf\xc7\xcf \xd3\xcf\xc5\xc4\xc9\xce\xc5\xce\xc9\xca in d:\\web\\engine\\engine.php on line 34

 

как видите строки повторяются, после чего web сервер виснит, при заходе на сайт даже не на сам форум, пользователь видит пустую страницу.

 

вот что пишет ему:

ERROR: Cannot find database pgf_forum P,BODY{ font-family:arial,sans-serif; font-size:11px; } 

There appears to be an error with the ********* Форум database.
You can try to refresh the page by clicking here

 

сначала думал из-за возросшей посещаемости и использовании мускула не только сайтом но и игровым сервером+статистика+баны... все на мускуле у мя, начинает превышать предел обращений... долго вкуривал что ето такое и как испарвить в итоге создал еще одного пользователя мускула и распределил между двумя пользователями использование базы, как оказалось не помогло, да и не в мускуле дело скорей всего...

 

короче СПАСИТЕ!!! каждые 30 минут валится...

 

 

PS ipb 1.3 final apache 1.33 PHP 4.3.10 мускул 4...

[Destruction]

Cannot find database pgf_forum

 

А в чём, коли не в мускуле ?

[poncho]

в том то и дело что проблема решается рестартом апача

 

какие рецепты избавления от этого ?

 

 

хм.. мб батник сделать и закинуть его в шедулер пусть каждые 30 минут рестартит апач.

 

какой должен быть текст батника ?

[Destruction]

apache.exe -k restart

 

И повесить на что-нибудь типа крона.

 

Лично мне, в последнее время нравится делать демонов на PHP и в трей кидать (тулзой AllToTray), вообще это не совсем правильно - зато язык привычный.

Изменено 6 Ноября 2006 пользователем Destruction

[poncho]

а решить проблему как можно, rr это тока временное, но не решение проблемы.