Subject | Re: [firebird-support] 2 copies of fb_lock_mgr |
---|---|
Author | Nick Upson |
Post date | 2008-08-08T13:27:24Z |
2008/8/8 Milan Babuskov milanb@...
rename database filename
connect from several C programs as user1, using localhost in filepath,
programs remain connected
connect from C program & isql as root, may have been using localhost in
filepath, do not remain connected
later I spot 2 copies of lock mgr running
would you expect this to do it?
[Non-text portions of this message have been removed]
>gbak as root using localhost in filepath
> When you access Classic via xinetd or inted, it always spawns a single
> fb_lock_mgr since system username is 'hardcoded' in (x)inetd config file.
>
> So, if I run:
>
> $ bin/isql localhost:/path/whetever.fdb -user fbuser -pass ****
>
> or as root:
>
> # bin/isql localhost:/path/whetever.fdb -user fbuser -pass ****
>
> I will end up with a single fb_lock_mgr.
>
> However, if you try to access the database file directly (i.e. no
> hostname in the path):
>
> $ bin/isql /path/whetever.fdb
>
> Another fb_lock_mgr might get spawned (depends on the account you are
> using). This second form of attaching to database can work without
> Firebird username and password if you have enough privileges on the
> database file itself as a user.
>
> The sequence of events I had was, I think,
rename database filename
connect from several C programs as user1, using localhost in filepath,
programs remain connected
connect from C program & isql as root, may have been using localhost in
filepath, do not remain connected
later I spot 2 copies of lock mgr running
would you expect this to do it?
[Non-text portions of this message have been removed]