FB2.5.7 and Firebird-2.5.8.27070-0_x64 - periodically frozen under load
-----------------------------------------------------------------------
Key: CORE-5604
URL: http://tracker.firebirdsql.org/browse/CORE-5604
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.7
Environment: Windows 2008 R2 server, 4 CPU, 8GB RAM, Super Clasic
Reporter: Slavomir Skopalik
Priority: Blocker
Approximately every one or two days first firebird will consume one CPU, but no
SQL command in monitoring tables.
After some time, about 6 hours, firebird stops executing statements and
receiving new connection.
Some notes about environment:
* About 50 connections
* About 5 transactions per second
* There are high number of rollbacked transactions (making update and rollback)
>From log (firebird was hard killed and start at Tue Sep 05 07:14:23 2017):
CEECZPROP05 Tue Sep 05 07:03:05 2017
INET/inet_error: read errno = 10054
CEECZPROP05 Tue Sep 05 07:14:24 2017
Sweep is started by SWEEPER
Database "D:\FBDATA\KINGSPAN_CZ.FDB"
OIT 93640260, OAT 93935017, OST 93935017, Next 93935034
CEECZPROP05 Tue Sep 05 07:18:30 2017
Sweep is finished
Database "D:\FBDATA\KINGSPAN_CZ.FDB"
OIT 93935016, OAT 93935359, OST 93935359, Next 93936545
CEECZPROP05 Tue Sep 05 07:30:28 2017
INET/inet_error: read errno = 10054
Process dump file is here: http://www.elektlabs.cz/20170905-FB2.5.8.7z
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
