[PHP-DB] Fwd: Apache log: database shutdown
Since yesterday I have following situation. 1) Everything works fine for about one hour. 2) Site didn't show up and apache log is following: [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_query() [a href='function.ibase-query'function.ibase-query/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/funkcjewspolne.php on line 215 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc(): supplied argument is not a valid Firebird/InterBase result resource in /var/www/localhost/htdocs/icentrum/php/funkcjewspolne.php on line 216 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc() [a href='function.ibase-fetch-assoc'function.ibase-fetch-assoc/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 124 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_query() [a href='function.ibase-query'function.ibase-query/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 195 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc(): supplied argument is not a valid Firebird/InterBase result resource in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 196 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc() [a href='function.ibase-fetch-assoc'function.ibase-fetch-assoc/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 205 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_query() [a href='function.ibase-query'function.ibase-query/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 322 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc(): supplied argument is not a valid Firebird/InterBase result resource in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 323 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: Unknown: database Centrum:Centrum shutdown in Unknown on line 0 3) Restart apache. 4) Go back to point 1) I have no idea what is going on. Any help will be appropriated. Kamil Walas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Fwd: Apache log: database shutdown
I checked. It's looks fine for me, but I paste piece of it relevant to apache log: CentrumMon Apr 19 13:57:02 2010 INET/inet_error: send errno = 104 CentrumMon Apr 19 13:57:02 2010 SERVER/process_packet: broken port, server exiting CentrumMon Apr 19 14:03:49 2010 INET/inet_error: send errno = 104 CentrumMon Apr 19 14:03:49 2010 SERVER/process_packet: broken port, server exiting CentrumMon Apr 19 14:13:57 2010 INET/inet_error: read errno = 104 CentrumMon Apr 19 14:30:21 2010 INET/inet_error: read errno = 104 CentrumMon Apr 19 15:22:18 2010 INET/inet_error: send errno = 104 Regards Kamil W dniu 2010-04-20 13:25, Peter Lind pisze: On 20 April 2010 13:20, Kamil Walaskamilwala...@gmail.com wrote: Since yesterday I have following situation. 1) Everything works fine for about one hour. 2) Site didn't show up and apache log is following: [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_query() [a href='function.ibase-query'function.ibase-query/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/funkcjewspolne.php on line 215 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc(): supplied argument is not a valid Firebird/InterBase result resource in /var/www/localhost/htdocs/icentrum/php/funkcjewspolne.php on line 216 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc() [a href='function.ibase-fetch-assoc'function.ibase-fetch-assoc/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 124 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_query() [a href='function.ibase-query'function.ibase-query/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 195 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc(): supplied argument is not a valid Firebird/InterBase result resource in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 196 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc() [a href='function.ibase-fetch-assoc'function.ibase-fetch-assoc/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 205 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_query() [a href='function.ibase-query'function.ibase-query/a]: database Centrum:Centrum shutdown in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 322 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: ibase_fetch_assoc(): supplied argument is not a valid Firebird/InterBase result resource in /var/www/localhost/htdocs/icentrum/php/zlecenie.php on line 323 [Mon Apr 19 14:07:35 2010] [error] [client 10.0.30.10] PHP Warning: Unknown: database Centrum:Centrum shutdown in Unknown on line 0 3) Restart apache. 4) Go back to point 1) I have no idea what is going on. Any help will be appropriated. Have you checked the database logs? Just a thought. Regards Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Fwd: Apache log: database shutdown
On 20 April 2010 13:37, Kamil Walas kamilwala...@gmail.com wrote: I checked. It's looks fine for me, but I paste piece of it relevant to apache log: Centrum Mon Apr 19 13:57:02 2010 INET/inet_error: send errno = 104 Centrum Mon Apr 19 13:57:02 2010 SERVER/process_packet: broken port, server exiting Centrum Mon Apr 19 14:03:49 2010 INET/inet_error: send errno = 104 Centrum Mon Apr 19 14:03:49 2010 SERVER/process_packet: broken port, server exiting Centrum Mon Apr 19 14:13:57 2010 INET/inet_error: read errno = 104 Centrum Mon Apr 19 14:30:21 2010 INET/inet_error: read errno = 104 Centrum Mon Apr 19 15:22:18 2010 INET/inet_error: send errno = 104 That hardly looks fine. Googling a bit, I found the following: http://www.firebirdfaq.org/faq140/ http://www.firebirdfaq.org/faq120/ I'd guess it's a bad connection between Apache and your DB - or Apache dropping the connection for some other reason. Regards Peter -- hype WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 /hype -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Fwd: Apache log: database shutdown
You are right! When I reading description about this errors I have in mind situations when user shutdown his browser and this is why I thought these errors are fine. But this communication is between apache and Firebird. More suprising is that Firebird and Apache works on the same machine. But still the main questions remains. Why apache drops connections to database? These PHP scripts are running in over 30 different servers and problem is only with this one. Regards, Kamil 2010/4/20, Peter Lind peter.e.l...@gmail.com: On 20 April 2010 13:37, Kamil Walas kamilwala...@gmail.com wrote: I checked. It's looks fine for me, but I paste piece of it relevant to apache log: Centrum Mon Apr 19 13:57:02 2010 INET/inet_error: send errno = 104 Centrum Mon Apr 19 13:57:02 2010 SERVER/process_packet: broken port, server exiting Centrum Mon Apr 19 14:03:49 2010 INET/inet_error: send errno = 104 Centrum Mon Apr 19 14:03:49 2010 SERVER/process_packet: broken port, server exiting Centrum Mon Apr 19 14:13:57 2010 INET/inet_error: read errno = 104 Centrum Mon Apr 19 14:30:21 2010 INET/inet_error: read errno = 104 Centrum Mon Apr 19 15:22:18 2010 INET/inet_error: send errno = 104 That hardly looks fine. Googling a bit, I found the following: http://www.firebirdfaq.org/faq140/ http://www.firebirdfaq.org/faq120/ I'd guess it's a bad connection between Apache and your DB - or Apache dropping the connection for some other reason. Regards Peter -- hype WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 /hype -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Fwd: Apache log: database shutdown
Hi, You may want to check SELinux. Also, if those 30 other servers are supposed to have the same config, a diff between those will make it easier for the eye to catch things that are different. regards, Maarten On Tue, 2010-04-20 at 14:22 +0200, Kamil Walas wrote: You are right! When I reading description about this errors I have in mind situations when user shutdown his browser and this is why I thought these errors are fine. But this communication is between apache and Firebird. More suprising is that Firebird and Apache works on the same machine. But still the main questions remains. Why apache drops connections to database? These PHP scripts are running in over 30 different servers and problem is only with this one. Regards, Kamil 2010/4/20, Peter Lind peter.e.l...@gmail.com: On 20 April 2010 13:37, Kamil Walas kamilwala...@gmail.com wrote: I checked. It's looks fine for me, but I paste piece of it relevant to apache log: CentrumMon Apr 19 13:57:02 2010 INET/inet_error: send errno = 104 CentrumMon Apr 19 13:57:02 2010 SERVER/process_packet: broken port, server exiting CentrumMon Apr 19 14:03:49 2010 INET/inet_error: send errno = 104 CentrumMon Apr 19 14:03:49 2010 SERVER/process_packet: broken port, server exiting CentrumMon Apr 19 14:13:57 2010 INET/inet_error: read errno = 104 CentrumMon Apr 19 14:30:21 2010 INET/inet_error: read errno = 104 CentrumMon Apr 19 15:22:18 2010 INET/inet_error: send errno = 104 That hardly looks fine. Googling a bit, I found the following: http://www.firebirdfaq.org/faq140/ http://www.firebirdfaq.org/faq120/ I'd guess it's a bad connection between Apache and your DB - or Apache dropping the connection for some other reason. Regards Peter -- hype WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 /hype -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php