Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot shutdown the database or the whole server while it performs a longish savepoint cleanup during the rollback [CORE3809] #4152

Open
firebird-automations opened this issue Apr 7, 2012 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

It's very interesting point. Probably be we should change rollback method when shutdown is active.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Alexander Peshkov [ alexpeshkoff ] => Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 2.1.4 [ 10361 ]

Version: 2.5.0 [ 10221 ]

Version: 3.0 Initial [ 10301 ]

Version: 2.1.3 [ 10302 ]

Version: 2.1.2 [ 10270 ]

Version: 2.1.1 [ 10223 ]

Version: 2.1.0 [ 10041 ]

Component: Engine [ 10000 ]

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment