Issue Details (XML | Word | Printable)

Key: CORE-3857
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: anthony jang
Votes: 4
Watchers: 10
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Firebird hangs for a while blocking all DB operations periodically.

Created: 28/May/12 09:50 PM   Updated: 28/Nov/18 10:05 AM
Component/s: Engine
Affects Version/s: 2.5.1
Fix Version/s: None

File Attachments: 1. Zip Archive fb_inet_server_081012.zip (467 kB)
2. Zip Archive fb_inet_server_minidump.zip (242 kB)

Environment: Firebird 2.5.1 Super-Classic x64 on Windows 2008 R2 Server with 32 GB of RAM


 Description  « Hide
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.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
anthony jang made changes - 14/Jun/12 07:17 PM
Field Original Value New Value
Attachment fb_inet_server_minidump.zip [ 12167 ]
anthony jang made changes - 10/Aug/12 06:53 PM
Attachment fb_inet_server_081012.zip [ 12191 ]