| Subject | fbserver and 100% of one core of cpu usage REFdn4055716621 |
|---|---|
| Author | dennis |
| Post date | 2010-03-15T12:01:29Z |
Here is the firebird.log, please read my notes prefixed with “---“
--- the application is running as well, but something happen on firebird server, see the log what reports
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
XNET error: get_free_slot() failed
--- hmmm I don’t know… by th way
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
Database:
unknown ISC error 0
--- what is really means this error message?
SERVERVENIZ (Server) Mon Mar 15 13:13:21 2010
XNET error: connection lost: another side is dead
--- At this point, till now, the application has reported error messages like “connection lost”.
--- Next the user closed the application, and then the Firebird (as shown below) was terminated and automatically reloaded.
SERVERVENIZ (Client) Mon Mar 15 13:13:21 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Mon Mar 15 13:13:23 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
--- Description of the problem:
--- At this point, the application hasn’t been loaded again, so the database should be not used from any client application. But something is going wrong and unknown. When then fbserver.exe launched, the one core of the cpu is working 100%, suddenly 862mb of ram occupied from fbserver, the memory usage in general was peaked from 350mb to 2,1gb, the database file is locked (i.e.: we cannot rename it) and all these started when the fbserver.exe launched after abnormal termination.
--- If we launch the application at this point, it is working well with this database file, but is it extremely slow! Of course there is something wrong here, maybe the file is corrupted the firebird do something like sweep. I said maybe, I don’t know.
Here is the gstat report from this database (requested as the core of the cpu is used 100%)
Database header page information:
Flags 0
Checksum 12345
Generation 8650005
Page size 16384
ODS version 11.0
Oldest transaction 8362584
Oldest active 8649781
Oldest snapshot 8649775
Next transaction 8649998
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 21, 2010 10:40:33
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
The rest of the email is the last part of the firebird.log
…
SERVERVENIZ (Server) Thu Feb 11 14:23:41 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Thu Feb 11 14:25:02 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Server) Tue Mar 09 09:45:50 2010
XNET error: get_free_slot() failed
SERVERVENIZ (Server) Tue Mar 09 09:45:50 2010
Database:
unknown ISC error 0
SERVERVENIZ (Server) Tue Mar 09 09:56:01 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Tue Mar 09 09:56:01 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Tue Mar 09 09:56:02 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Client) Tue Mar 09 09:56:12 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Tue Mar 09 09:56:12 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Tue Mar 09 10:00:15 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Tue Mar 09 10:00:15 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Tue Mar 09 10:22:15 2010
Database: C:\PROGRAM FILES\COMPANYS LTD\APP1\DATABASE\VENIZ_DB.FDB
cannot start sweep thread (0)
SERVERVENIZ (Server) Tue Mar 09 10:27:13 2010
Database: C:\PROGRAM FILES\COMPANYS LTD\APP1\DATABASE\VENIZ_DB.FDB
cannot start sweep thread (0)
SERVERVENIZ (Server) Wed Mar 10 10:07:35 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:17:01 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:24:39 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:28:28 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:30:03 2010
INET/inet_error: accept errno = 10093
SERVERVENIZ (Server) Wed Mar 10 10:30:03 2010
INET/select_wait: select failed, errno = 10093
SERVERVENIZ (Server) Wed Mar 10 10:30:03 2010
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
SERVERVENIZ (Client) Wed Mar 10 10:30:06 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Client) Wed Mar 10 10:30:12 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Wed Mar 10 10:30:12 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Sat Mar 13 19:27:39 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Sat Mar 13 19:27:39 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Client) Sat Mar 13 19:27:41 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Sat Mar 13 19:27:41 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 19:27:51 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 19:27:55 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:21 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:26 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:26 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:26 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:28 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:28 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
XNET error: get_free_slot() failed
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
Database:
unknown ISC error 0
SERVERVENIZ (Server) Mon Mar 15 13:13:21 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Mon Mar 15 13:13:21 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Mon Mar 15 13:13:23 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
dennis
...we are what we are doing... P Think! before you print.
[Non-text portions of this message have been removed]
--- the application is running as well, but something happen on firebird server, see the log what reports
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
XNET error: get_free_slot() failed
--- hmmm I don’t know… by th way
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
Database:
unknown ISC error 0
--- what is really means this error message?
SERVERVENIZ (Server) Mon Mar 15 13:13:21 2010
XNET error: connection lost: another side is dead
--- At this point, till now, the application has reported error messages like “connection lost”.
--- Next the user closed the application, and then the Firebird (as shown below) was terminated and automatically reloaded.
SERVERVENIZ (Client) Mon Mar 15 13:13:21 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Mon Mar 15 13:13:23 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
--- Description of the problem:
--- At this point, the application hasn’t been loaded again, so the database should be not used from any client application. But something is going wrong and unknown. When then fbserver.exe launched, the one core of the cpu is working 100%, suddenly 862mb of ram occupied from fbserver, the memory usage in general was peaked from 350mb to 2,1gb, the database file is locked (i.e.: we cannot rename it) and all these started when the fbserver.exe launched after abnormal termination.
--- If we launch the application at this point, it is working well with this database file, but is it extremely slow! Of course there is something wrong here, maybe the file is corrupted the firebird do something like sweep. I said maybe, I don’t know.
Here is the gstat report from this database (requested as the core of the cpu is used 100%)
Database header page information:
Flags 0
Checksum 12345
Generation 8650005
Page size 16384
ODS version 11.0
Oldest transaction 8362584
Oldest active 8649781
Oldest snapshot 8649775
Next transaction 8649998
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 21, 2010 10:40:33
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
The rest of the email is the last part of the firebird.log
…
SERVERVENIZ (Server) Thu Feb 11 14:23:41 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Thu Feb 11 14:25:02 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Server) Tue Mar 09 09:45:50 2010
XNET error: get_free_slot() failed
SERVERVENIZ (Server) Tue Mar 09 09:45:50 2010
Database:
unknown ISC error 0
SERVERVENIZ (Server) Tue Mar 09 09:56:01 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Tue Mar 09 09:56:01 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Tue Mar 09 09:56:02 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Client) Tue Mar 09 09:56:12 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Tue Mar 09 09:56:12 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Tue Mar 09 10:00:15 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Tue Mar 09 10:00:15 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Tue Mar 09 10:22:15 2010
Database: C:\PROGRAM FILES\COMPANYS LTD\APP1\DATABASE\VENIZ_DB.FDB
cannot start sweep thread (0)
SERVERVENIZ (Server) Tue Mar 09 10:27:13 2010
Database: C:\PROGRAM FILES\COMPANYS LTD\APP1\DATABASE\VENIZ_DB.FDB
cannot start sweep thread (0)
SERVERVENIZ (Server) Wed Mar 10 10:07:35 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:17:01 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:24:39 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:28:28 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Wed Mar 10 10:30:03 2010
INET/inet_error: accept errno = 10093
SERVERVENIZ (Server) Wed Mar 10 10:30:03 2010
INET/select_wait: select failed, errno = 10093
SERVERVENIZ (Server) Wed Mar 10 10:30:03 2010
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
SERVERVENIZ (Client) Wed Mar 10 10:30:06 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Client) Wed Mar 10 10:30:12 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Wed Mar 10 10:30:12 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Sat Mar 13 19:27:39 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Sat Mar 13 19:27:39 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
SERVERVENIZ (Client) Sat Mar 13 19:27:41 2010
XNET error: Server shutdown detected
SERVERVENIZ (Client) Sat Mar 13 19:27:41 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 19:27:51 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 19:27:55 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:21 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:26 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:26 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:26 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:28 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Sat Mar 13 20:30:28 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
XNET error: get_free_slot() failed
SERVERVENIZ (Server) Mon Mar 15 11:21:39 2010
Database:
unknown ISC error 0
SERVERVENIZ (Server) Mon Mar 15 13:13:21 2010
XNET error: connection lost: another side is dead
SERVERVENIZ (Client) Mon Mar 15 13:13:21 2010
C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe: terminated abnormally (4294967295)
SERVERVENIZ (Client) Mon Mar 15 13:13:23 2010
Guardian starting: C:\Program Files\Firebird\Firebird_2_0\bin\fbserver.exe
dennis
...we are what we are doing... P Think! before you print.
[Non-text portions of this message have been removed]