Reduce time of detection that client connection was killed while doing heavy
operations (e.g sort large data set etc)
---------------------------------------------------------------------------------------------------------------------
Key: CORE-4757
URL: http://tracker.firebirdsql.org/browse/CORE-4757
Project: Firebird Core
Issue Type: Improvement
Reporter: Pavel Zotov
Priority: Minor
Test for CORE-2966 ("Wrong results or unexpected errors while sorting a large
data set") begins with filling table t (col varchar(32000)) with 200'000 rows
and then sorting them (select ... from ... GROUP BY ...).
This operation lasted on common PC-workstation more than two hours and it was
decided to cancel client connection (pskill cmd.exe its child processes:
isql.exe & fbt_run.exe).
Sort created temp file (fb_sort_*) with size more than 2.4 Gb and this file
remained as open by firebird process about FIVE (!) minutes with almost zero
cpu & io activity.
After that time FB made CPU workload about 80% till ~15 seconds and than
removed this file and finally stopped its activity (see attached screen from
PE).
I can`t understand: what prevents FB to immediately encounter client's death
and cancel any activity just at this moment ?
Version: WI-T3.0.0.31794
Architecture: SuperServer
Config:
===
DefaultDbCachePages = 2048
FileSystemCacheThreshold = 65536K
LockHashSlots = 22111
AuthClient = Legacy_Auth,Srp,Win_Sspi
AuthServer = Legacy_Auth,Srp
UserManager = Legacy_UserManager
WireCrypt = Disabled
SharedCache = false
SharedDatabase = true
===
(yes, TempCacheLimit is not specified, i.e. has default value).
Values from
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters:
KeepAliveTime = 5000
KeepAliveInterval = 1000
TcpMaxDataRetransmissions = 3
--
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
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
