fb-service-can-not-be-stopped-when-trying-to-del-from-mon$statements-es-eds.zip
- replace firebird.conf with following:
BugcheckAbort = 1
FileSystemCacheThreshold = 65536K
Servermode = Super
DefaultDbCachePages = 5000
TempBlockSize = 2M
TempCacheLimit = 2147483647
LockHashSlots = 22111
LockMemSize = 5M
AuthClient = Srp, Srp256, Win_Sspi, Legacy_Auth
AuthServer = Srp, Srp256, Win_Sspi, Legacy_Auth
UserManager = Srp, Legacy_UserManager
WireCompression = false
WireCrypt = Enabled
- unpack files from attached .zip and open 'eds-hang.bat' in editor; change there variables:
set FB_HOME=C:\FB\40SS
set ISC_USER=SYSDBA
set ISC_PASSWORD=masterkey
- ensure that databases.conf contain alias 'employee' for built-in FB example database;
- stop any running FB instances and applications; launch selected firebird (3.x, 4.x or 5.x) as service
- run batch eds-hang.bat
After several iterations (number can vary, but usually it will be less than 30) console will hang with somewhat like this:
17.01.2022 10:14:48.74 Starting C:\FB\50SS\isql localhost:employee -i eds-hang.sql 1>>C:\FBTESTING\qa\misc\eds-hang.1.log 2>&1
17.01.2022 10:14:48.74 Take small delay, point-1...
17.01.2022 10:14:50.75 Trying to delete from mon$statements, command:
echo set count on; delete from mon$statements where mon$attachment_id is distinct from current_connection; | C:\FB\50SS\isql localhost:employee
Since that moment FB service can not be stopped via NET STOP or services.msc GUI; only termination like "taskkill /f /t /im firebird.exe" can solve this problem.
Note that this can be reproduced only when we try to delete record from MON$STATEMENTS. No such problem with MON$ATTACHMENTS.
Checked on: WI-V3.0.9.33548; WI-V4.0.1.2704; WI-T5.0.0.372
fb-service-can-not-be-stopped-when-trying-to-del-from-mon$statements-es-eds.zip
After several iterations (number can vary, but usually it will be less than 30) console will hang with somewhat like this:
Since that moment FB service can not be stopped via NET STOP or services.msc GUI; only termination like "taskkill /f /t /im firebird.exe" can solve this problem.
Note that this can be reproduced only when we try to delete record from MON$STATEMENTS. No such problem with MON$ATTACHMENTS.
Checked on: WI-V3.0.9.33548; WI-V4.0.1.2704; WI-T5.0.0.372