Fwd: Apache log: database shutdown

Fwd: Apache log: database shutdown

am 20.04.2010 13:20:07 von Kamil Walas

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() []:
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() [ href='function.ibase-fetch-assoc'>function.ibase-fetch-assoc]:
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() []:
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() [ href='function.ibase-fetch-assoc'>function.ibase-fetch-assoc]:
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() []:
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: Fwd: Apache log: database shutdown

am 20.04.2010 13:25:32 von Peter Lind

On 20 April 2010 13:20, Kamil Walas 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() []=
:
> 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() [ > href=3D'function.ibase-fetch-assoc'>function.ibase-fetch-ass oc]:
> 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() []=
:
> 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() [ > href=3D'function.ibase-fetch-assoc'>function.ibase-fetch-ass oc]:
> 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() []=
:
> 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

--=20

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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fwd: Apache log: database shutdown

am 20.04.2010 13:37:47 von Kamil Walas

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 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() []:
>> 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() [ >> href='function.ibase-fetch-assoc'>function.ibase-fetch-assoc]:
>> 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() []:
>> 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() [ >> href='function.ibase-fetch-assoc'>function.ibase-fetch-assoc]:
>> 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() []:
>> 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: Fwd: Apache log: database shutdown

am 20.04.2010 13:55:50 von Peter Lind

On 20 April 2010 13:37, Kamil Walas 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 =3D 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 =3D 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 =3D 104
> Centrum    Mon Apr 19 14:30:21 2010
>    INET/inet_error: read errno =3D 104
> Centrum    Mon Apr 19 15:22:18 2010
>    INET/inet_error: send errno =3D 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

--=20

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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fwd: Apache log: database shutdown

am 20.04.2010 14:22:11 von Kamil Walas

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 datab=
ase?
These PHP scripts are running in over 30 different servers and problem
is only with this one.

Regards,
Kamil

2010/4/20, Peter Lind :
> On 20 April 2010 13:37, Kamil Walas wrote:
>> I checked. It's looks fine for me, but I paste piece of it relevant to
>> apache log:
>>
>> Centrum =A0 =A0Mon Apr 19 13:57:02 2010
>> =A0 =A0INET/inet_error: send errno =3D 104
>> Centrum =A0 =A0Mon Apr 19 13:57:02 2010
>> =A0 =A0SERVER/process_packet: broken port, server exiting
>> Centrum =A0 =A0Mon Apr 19 14:03:49 2010
>> =A0 =A0INET/inet_error: send errno =3D 104
>> Centrum =A0 =A0Mon Apr 19 14:03:49 2010
>> =A0 =A0SERVER/process_packet: broken port, server exiting
>> Centrum =A0 =A0Mon Apr 19 14:13:57 2010
>> =A0 =A0INET/inet_error: read errno =3D 104
>> Centrum =A0 =A0Mon Apr 19 14:30:21 2010
>> =A0 =A0INET/inet_error: read errno =3D 104
>> Centrum =A0 =A0Mon Apr 19 15:22:18 2010
>> =A0 =A0INET/inet_error: send errno =3D 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
>
> --
>
> 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
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Fwd: Apache log: database shutdown

am 20.04.2010 15:19:25 von maarten.foque

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.
>=20
> But still the main questions remains. Why apache drops connections to dat=
abase?
> These PHP scripts are running in over 30 different servers and problem
> is only with this one.
>=20
> Regards,
> Kamil
>=20
> 2010/4/20, Peter Lind :
> > On 20 April 2010 13:37, Kamil Walas 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 =3D 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 =3D 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 =3D 104
> >> Centrum Mon Apr 19 14:30:21 2010
> >> INET/inet_error: read errno =3D 104
> >> Centrum Mon Apr 19 15:22:18 2010
> >> INET/inet_error: send errno =3D 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
> >
> > --
> >
> > 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
> >
> >
>=20


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php