| Subject | RE: Re: [firebird-support] wcdata.fdb file opened many times, hogging space ! |
|---|---|
| Author | |
| Post date | 2013-11-22T17:39:52Z |
No i'm not deleting any file.
-we use the gfix script to stop the db every night, and make a backup. this is not releasing the hogged space (fb_inet process still running) ! we use "gfix -user sysdba -password XXXX -shut full -force 0 wcdata.fdb", then the DB is dow, we we try to connect to it.
-Then we decided to go with a service firebird2-5.... stop, this this is not releasing the hogged space (fb_inet process still running) !
-the only option is to do a "pkill fb_inet", thus processes a killed, space is released.
@MArk : by service api , do you mean using gfix to shut down the DB ?
I am amazed i'm the only one having this issue, i did an standard install, no fancy config !
Thanks for your help
---In firebird-support@yahoogroups.com, <mark@...> wrote:On 21-11-2013 17:59, jbossert@... wrote:
>Use the monitoring tables to kill connections.
>
> Hi Mark,
>
>
> Right now i'm looking in a way to reclaim the space right away without
> killing the process.
But how did you remove the file, did you delete it? Instead of deleting
it through the file system, you might want to try dropping it using the
service API. That will check if the database is still in use or not.
> Is it helping if i change the FB flavor to "superclassic", assuming thisI don't know.
> fires only 1 instance of the db, so the file will be opened only 1 time ?!
Mark
--
Mark Rotteveel