Firebird hangs for a while blocking all DB operations periodically.
-------------------------------------------------------------------
Key: CORE-3857
URL: http://tracker.firebirdsql.org/browse/CORE-3857
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1
Environment: Firebird 2.5.1 Super-Classic x64 on Windows 2008 R2
Server with 32 GB of RAM
Reporter: anthony jang
Priority: Critical
We have a Firebird server installation that periodically blocks all operations
for a few minutes and then comes back alive on its own. This has happened about
once a month for the last few months. During this blocking period, Firebird CPU
usage is unusually low as this is a busy server. This server normally has
200-300 client attachments. The blocking time has varied from 2 minutes to over
10 minutes. During this time, no Firebird operations can be performed i.e. New
connections are blocked along with existing connections. Upon recovery,
Firebird continues processing without any other issues.
We have noticed that this has generally occurred, but not always, during a DB
sweep. Our sweep interval is set to 0 and we are performing the sweep once a
day as a scheduled task.
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
