Blocking new connections as a consequence of the too long sweep security2.fdb
------------------------------------------------------------------------------
Key: CORE-5067
URL: http://tracker.firebirdsql.org/browse/CORE-5067
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.5, 2.5.3
Environment: Windows x64, Firebird Classic Server x64
Reporter: Oleg Matveyev
Symptoms: every time one process fb_inte_server.exe load 100% CPU one kernel
after some easy queries.
Current process ID is not present in SELECT FROM MON$ATTACHMENTS.
After one hour of continuous working, no more connections allowed,
and number fb_inet_server process increased from 40..50 to more than 250.
firebird.log:
______________________________
WOODY Sun Jan 03 13:26:01 2016
Sweep is started by SWEEPER
Database "C:\IB\SECURITY2.FDB"
OIT 19821012, OAT 20, OST 20, Next 70004809
WOODY Sun Jan 03 13:34:03 2016
Shutting down the server with 1 active connection(s) to 1 database(s),
0 active service(s)
WOODY Sun Jan 03 13:34:06 2016
Sweep is started by SWEEPER
Database "C:\IB\SECURITY2.FDB"
OIT 19821012, OAT 20, OST 20, Next 70005503
WOODY Sun Jan 03 13:36:23 2016
Shutting down the server with 1 active connection(s) to 1 database(s),
0 active service(s)
WOODY Sun Jan 03 13:36:24 2016
Sweep is started by SWEEPER
Database "C:\IB\SECURITY2.FDB"
OIT 19821012, OAT 20, OST 20, Next 70005604
WOODY Sun Jan 03 13:46:27 2016
Sweep is started by SWEEPER
Database "C:\IB\SECURITY2.FDB"
OIT 19821012, OAT 20, OST 20, Next 70005805
WOODY Sun Jan 03 13:51:03 2016
Sweep is started by SWEEPER
Database "C:\IB\SECURITY2.FDB"
OIT 19821012, OAT 20, OST 20, Next 70006002
______________________________
gstat -h
Database "c:\ib\security2.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 140017716
Page size 4096
ODS version 11.2
Oldest transaction 19821012
Oldest active 20
Oldest snapshot 20
Next transaction 70008371
Bumped transaction 1
Sequence number 0
Next attachment ID 70008352
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Mar 19, 2013 10:56:23
Attributes force write
Variable header data:
*END*
______________________________
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
