On Sun, Apr 25, 2010 at 01:21:52PM +0300, Andreas Gerdd wrote:
> Hello.
> I noticed some unreferenced files from MySQL in my daily output mail;
> However, i don't have anything in /tmp or /var/tmp to check/fix the
> problem with fsck.
>
> Does this mean i lost some data from the database(s)?
>
> How may i fix or remove the reported bad files?
With patience. Running fsck on a mounted filesystem is very likely to
show the "problems" you mentioned.
The files will be cleaned up after the last process having a
reference to it exits, when softdep (if used) feels so.
-Otto
>
> Here's the output:
>
> OpenBSD 4.6-stable (GENERIC.MP) #2: Mon Apr 19 08:20:01 PDT 2010
> [email protected]:/usr/src/sys/arch/i386/compile/GENERIC.MP
>
> 1:32AM up 14:57, 0 users, load averages: 0.99, 0.47, 0.24
>
> Backing up root=/dev/rwd0a to /dev/rwd0d:
> 33129+1 records in
> 33129+1 records out
> 271393792 bytes transferred in 13.506 secs (20093240 bytes/sec)
> ** /dev/rwd0d
> ** Last Mounted on /
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 2602 files, 64653 used, 65178 free (394 frags, 8098 blocks, 0.3%
> fragmentation)
>
> MARK FILE SYSTEM CLEAN? yes
>
>
> ***** FILE SYSTEM WAS MODIFIED *****
>
> Checking subsystem status:
>
> disks:
> Filesystem 1K-blocks Used Avail Capacity Mounted on
> /dev/wd0a 259662 129306 117374 52% /
> /dev/wd0i 519646 6 493658 0% /tmp
> /dev/wd0e 15486368 3657428 11054622 25% /usr
> /dev/wd0f 36116632 138044 34172758 0% /var
> /dev/wd0h 10323146 11208 9795782 0% /var/vmail
> /dev/wd0g 170281220 150524 161616636 0% /var/www
>
> Last dump(s) done (Dump '>' file systems):
>
> mail:
> -Queue ID- --Size-- ----Arrival Time---- -Sender/Recipient-------
> E083791EB7 880 Sat Apr 24 10:26:31 [email protected]
> (connect to 42.22.192.55 [42.22.192.55]:10024:
> Invalid argument)
> [email protected]
>
> -- 1 Kbytes in 1 Request.
>
> network:
> Name Mtu Network Address Ipkts Ierrs Opkts Oerrs
> Colls
> lo0 33200 <Link> 30718 0 30718 0 > 0
> lo0 33200 127/8 127.0.0.1 30718 0 30718 0 > 0
> lo0 33200 ::1/128 ::1 30718 0 30718 0 > 0
> lo0 33200 fe80::%lo0/64 fe80::1%lo0 30718 0 30718
> 0 0
> bge0 1500 <Link> 00:19:b9:f9:0d:95 60140 4 41720 0 > 0
> bge0 1500 69.197.4.202/26 69.197.4.202 60140 4
> 41720 0 0
> bge0 1500 fe80::%bge0/64 fe80::219:b9ff:fef9:d95%bge0 60140
> 4 41720
> 0 0
> bge0 1500 72.20.55.89/29 72.20.55.89 60140 4 41720
> 0 0
> bge0 1500 72.20.55.90/29 72.20.55.90 60140 4 41720
> 0 0
> bge0 1500 72.20.55.91/29 72.20.55.91 60140 4 41720
> 0 0
> bge0 1500 72.20.55.92/29 72.20.55.92 60140 4 41720
> 0 0
> bge0 1500 72.20.55.93/29 72.20.55.93 60140 4 41720
> 0 0
> bge0 1500 72.20.55.94/29 72.20.55.94 60140 4 41720
> 0 0
> bge1* 1500 <Link> 00:19:b9:f9:0d:96 0 0 0 0 > 0
> enc0* 1536 <Link> 0 0 0 0 > 0
> pflog0 33200 <Link> 0 0 0 0 > 0
>
> Checking filesystems:
> ** /dev/rwd0a (NO WRITE)
> ** Last Mounted on /
> ** Root file system
> 2602 files, 64653 used, 65178 free (394 frags, 8098 blocks, 0.3%
> fragmentation)
> ** /dev/rwd0i (NO WRITE)
> ** Last Mounted on /tmp
> UNREF FILE I=3 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Apr 24 10:36 2010
> CLEAR? no
>
> UNREF FILE I=4 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Apr 24 10:36 2010
> CLEAR? no
>
> UNREF FILE I=5 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Apr 24 10:36 2010
> CLEAR? no
>
> UNREF FILE I=6 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Apr 24 10:36 2010
> CLEAR? no
>
> UNREF FILE I=7 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Apr 24 10:36 2010
> CLEAR? no
>
> 8 files, 3 used, 259820 free (20 frags, 32475 blocks, 0.0% fragmentation)
> ** /dev/rwd0e (NO WRITE)
> ** Last Mounted on /usr
> 314304 files, 1828714 used, 5914470 free (62566 frags, 731488 blocks, 0.8%
> fragmentation)
> ** /dev/rwd0f (NO WRITE)
> ** Last Mounted on /var
> 1117 files, 69019 used, 17989297 free (505 frags, 2248599 blocks, 0.0%
> fragmentation)
> ** /dev/rwd0h (NO WRITE)
> ** Last Mounted on /var/vmail
> 133 files, 5604 used, 5155969 free (193 frags, 644472 blocks, 0.0%
> fragmentation)
> ** /dev/rwd0g (NO WRITE)
> ** Last Mounted on /var/www
> 5502 files, 75262 used, 85065348 free (244 frags, 10633138 blocks,
> 0.0% fragmentation)
>
> Thanks.
