Hi,
I'm running FB classic 2.5 on ubuntu server 12.04, and i have a disk space
utilization issue :
my wcdata.fdb is 25 G large.
ls -lhs /db
total 39G
16K drwx------ 2 wincable dba 16K Oct 31 09:11 lost+found
4.0K drwxr-xr-x 2 root root 4.0K Nov 18 10:11 scripts
4.0K drwxr-xr-x 2 root root 4.0K Nov 11 20:19 tmp
4.0K drwxr-xr-x 3 root root 4.0K Nov 20 11:02 tmptmp
15G -rw-r--r-- 1 root root 15G Nov 20 03:01 wcdata.fbk
25G -rw-rw---- 1 firebird firebird 25G Nov 20 15:50 wcdata.fdb
48K -rw-r--r-- 1 firebird firebird 48K Nov 20 03:01 wcdata_security.fbk
if i do a du -hs i see this :
Size Used Avail Use% Mounted on
197G 64G 125G 34% /db/
also if i do a lsof -n -P | grep "wcdata.fdb"
fb_inet_s 15597 firebird 6u REG 252,1 25918701568
18 /db/wcdata.fdb (deleted)
fb_inet_s 16762 firebird 6u REG 252,1 25918701568
18 /db/wcdata.fdb (deleted)
fb_inet_s 16795 firebird 6u REG 252,1 25918701568
18 /db/wcdata.fdb (deleted)
fb_inet_s 16864 firebird 6u REG 252,1 25918701568
18 /db/wcdata.fdb (deleted)
fb_inet_s 17133 firebird 6u REG 252,1 25918701568
18 /db/wcdata.fdb (deleted)
fb_inet_s 18205 firebird 6u REG 252,1 25918701568
18 /db/wcdata.fdb (deleted)
fb_inet_s 19240 firebird 6u REG 252,1 25918701568
18 /db/wcdata.fdb (deleted)
fb_inet_s 20467 firebird 6u REG 252,1 25927090176
12 /db/wcdata.fdb
fb_inet_s 21454 firebird 6u REG 252,1 25927090176
12 /db/wcdata.fdb
fb_inet_s 21483 firebird 6u REG 252,1 25927090176
12 /db/wcdata.fdb
fb_inet_s 21498 firebird 6u REG 252,1 25927090176
12 /db/wcdata.fdb
fb_inet_s 22663 firebird 6u REG 252,1 25927090176
12 /db/wcdata.fdb
fb_inet_s 23783 firebird 6u REG 252,1 25927090176
12 /db/wcdata.fdb
I think the file marked as (deleted) is still using space on the drive...
if i do a kill pid, it release the space, but i want to understand the issue
and fix it in a proper way.
Thank you,
J
[Non-text portions of this message have been removed]
