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?
Short answer: Ignore them. They are remnants of TEMPORARY tables which are supposed to vanish when connection is dropped. > > 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. MySQL (at least the one I've got running -current) keeps Files for ISAM tables in /var/mysql and files for TEMPORARY (ISAM) tables in /var like so: # ls -l /tmp/#sql* -rw-rw---- 1 _mysql wheel 0 Apr 25 06:02 /tmp/#sql7dd3_7_2.MYD -rw-rw---- 1 _mysql wheel 1024 Apr 25 06:02 /tmp/#sql7dd3_7_2.MYI -rw-rw---- 1 _mysql wheel 8586 Apr 25 06:02 /tmp/#sql7dd3_7_2.frm Whenever a connection is dropped, the TEMPORARY tables are supposed to vanish. If there is ANY problem with coordination, I would much rather have a bit of junk, especially zero-length junk.