Subject Re: Firebird Hanging - Need suggestions ???
Author John B. Moore
Followup...

I did a re-install of the OS and upgraded it to CentOS 4.2. Then
installed: FirebirdSS-1.5.2.4731-nptl.i686.rpm.

Saddly it still hung after serveral hours..

In frustration I began looking for hardware issues and noticed that of
a group of status lights on the machine (rack mount 2U) that are
normally green, one had gone out.. (not red, just not green).. This
was the system light.

Did a netstat and also noticed that a number of the connections on the
list were set at the "CLOSEWAIT" (see sample below) I have watched
another database machine and it had only ESTABLISHED entries..

I would assume that is significant.. ?? (anyone have thoughts on this..??)

Anyway I have all the databases off that machine and am pursuing a
possible hardware problem.

John..





========netstat===============
tcp 21 0 mps-185.microps.com:gds_db mps-187.microps.com:34315
CLOSE_WAIT
tcp 21 0 mps-185.microps.com:gds_db mps-187.microps.com:34317
CLOSE_WAIT
tcp 21 0 mps-185.microps.com:gds_db mps-187.microps.com:34316
CLOSE_WAIT
tcp 1 0 mps-185.microps.com:gds_db mps-187.microps.com:34319
CLOSE_WAIT
tcp 1 0 mps-185.microps.com:gds_db mps-187.microps.com:34318
CLOSE_WAIT
tcp 1 0 mps-185.microps.com:gds_db mps-187.microps.com:34309
CLOSE_WAIT
tcp 21 0 mps-185.microps.com:gds_db mps-187.microps.com:34311
CLOSE_WAIT