You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
After some highload test was interrupted (250 connects were killed via pskill.exe) I could not wait till FB will complete all ROLLBACKs.
total count of threads decreased too slowly and after 10 minutes it was ~100 (i.e. the decreasing rate was only 15 threads per minute):
bash-3.2$ ps -FLC fb_smp_server|wc -l
104
So I decided to restart FB:
[root@fbozzy logs]# /etc/init.d/firebird stop
Stopping Firebird server [default]: [ OK ]
But it seems that processes of fbguart and fb_smp_server are alive:
[root@fbozzy logs]# ls -l /var/run/firebird/
total 0
How to make them be stopped ? Only via kill ?
-------------------
ISQL Version: WI-V2.5.1.26351 Firebird 2.5
Server version:
Firebird/linux AMD64 (access method), version "LI-V2.5.2.26448 Firebird 2.5"
Firebird/linux AMD64 (remote server), version "LI-V2.5.2.26448 Firebird 2.5/tcp (fbozzy)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.1.26351 Firebird 2.5/tcp (tlprg)/P12"
on disk structure version 11.2
The text was updated successfully, but these errors were encountered:
summary: can`t stop fbguard and fb_smp_server during it performs rollback => Cannot shutdown the database or the whole server while it performs a longish savepoint cleanup during the rollback
Submitted by: @pavel-zotov
Votes: 1
After some highload test was interrupted (250 connects were killed via pskill.exe) I could not wait till FB will complete all ROLLBACKs.
total count of threads decreased too slowly and after 10 minutes it was ~100 (i.e. the decreasing rate was only 15 threads per minute):
bash-3.2$ ps -FLC fb_smp_server|wc -l
104
So I decided to restart FB:
[root@fbozzy logs]# /etc/init.d/firebird stop
Stopping Firebird server [default]: [ OK ]
But it seems that processes of fbguart and fb_smp_server are alive:
[root@fbozzy logs]# ps -e|grep fb
16709 ? 00:00:00 fbguard
29969 ? 00:00:00 fb_smp_server
[root@fbozzy logs]# ls -l /var/run/firebird/
total 0
How to make them be stopped ? Only via kill ?
-------------------
ISQL Version: WI-V2.5.1.26351 Firebird 2.5
Server version:
Firebird/linux AMD64 (access method), version "LI-V2.5.2.26448 Firebird 2.5"
Firebird/linux AMD64 (remote server), version "LI-V2.5.2.26448 Firebird 2.5/tcp (fbozzy)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.1.26351 Firebird 2.5/tcp (tlprg)/P12"
on disk structure version 11.2
The text was updated successfully, but these errors were encountered: