Fwd: Apache log: database shutdown
in [Databases]
|
From: Kamil Walas on 20 Apr 2010 07:20 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
From: Peter Lind on 20 Apr 2010 07:25 On 20 April 2010 13:20, Kamil Walas <kamilwalas85(a)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 -- <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>
From: Kamil Walas on 20 Apr 2010 07:37 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 Regards Kamil W dniu 2010-04-20 13:25, Peter Lind pisze: > On 20 April 2010 13:20, Kamil Walas<kamilwalas85(a)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 > >
From: Peter Lind on 20 Apr 2010 07:55 On 20 April 2010 13:37, Kamil Walas <kamilwalas85(a)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>
From: Kamil Walas on 20 Apr 2010 08:22
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.lind(a)gmail.com>: > On 20 April 2010 13:37, Kamil Walas <kamilwalas85(a)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> > |