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? Here's the output: OpenBSD 4.6-stable (GENERIC.MP) #2: Mon Apr 19 08:20:01 PDT 2010 r...@test.domain.com:/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 i...@mydomain.com (connect to 42.22.192.55 [42.22.192.55]:10024: Invalid argument) testm...@yahoo.com -- 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.