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
[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.
