Unreferenced files are totally normal when a sudden power down occurs.
Especially on /tmp. So stop worrying, and trust fsck to do the right thing.
-Otto
On Sun, Nov 01, 2009 at 10:56:50PM -0800, Mark Yieh wrote:
> Hi everyone,
> I'm not sure if this is any cause for concern, but I
> recently had to run an fsck due to a power failure
> on my base 4.6 i386 box, and I noticed some
> unreferenced files from MySQL.
> I installed MySQL from packages and followed the
> instructions for a secure install.
> I'm pretty new to OpenBSD and system administration
> in general, so I'm not sure if this is a big issue.
> If it's not then is there a way for me to clear these files
> so the next time I run fsck I won't see these errors?
>
> Here is the output from the fsck program:
>
> ** /dev/rsd0a (NO WRITE)
> ** Last Mounted on /
> ** Root file system
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 1906 files, 19932 used, 496332 free (28 frags, 62038 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0d (NO WRITE)
> ** Last Mounted on /home
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 22 files, 20 used, 51602271 free (31 frags, 6450280 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0e (NO WRITE)
> ** Last Mounted on /tmp
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> UNREF FILE I=8 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Nov 1 20:55 2009
> CLEAR? no
>
> UNREF FILE I=9 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Nov 1 20:55 2009
> CLEAR? no
>
> UNREF FILE I=10 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Nov 1 20:55 2009
> CLEAR? no
>
> UNREF FILE I=11 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Nov 1 20:55 2009
> CLEAR? no
>
> UNREF FILE I=12 OWNER=_mysql MODE=100600
> SIZE=0 MTIME=Nov 1 20:55 2009
> CLEAR? no
>
> ** Phase 5 - Check Cyl groups
> 6 files, 1 used, 1034207 free (15 frags, 129274 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0f (NO WRITE)
> ** Last Mounted on /usr
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 13038 files, 213917 used, 15268444 free (292 frags, 1908519 blocks,
> 0.0% fragmentation)
> ** /dev/rsd0g (NO WRITE)
> ** Last Mounted on /usr/X11R6
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 1 files, 1 used, 2066048 free (16 frags, 258254 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0h (NO WRITE)
> ** Last Mounted on /usr/local
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 5351 files, 58625 used, 15423736 free (72 frags, 1927958 blocks,
> 0.0% fragmentation)
> ** /dev/rsd0i (NO WRITE)
> ** Last Mounted on /usr/obj
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 1 files, 1 used, 2066048 free (16 frags, 258254 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0j (NO WRITE)
> ** Last Mounted on /usr/src
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 1 files, 1 used, 2066048 free (16 frags, 258254 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0k (NO WRITE)
> ** Last Mounted on /var
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 326 files, 12542 used, 15469819 free (211 frags, 1933701 blocks,
> 0.0% fragmentation)
> ** /dev/rsd0l (NO WRITE)
> ** Last Mounted on /var/log
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 23 files, 3052 used, 2062997 free (29 frags, 257871 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0m (NO WRITE)
> ** Last Mounted on /var/mail
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 2 files, 465 used, 5161108 free (20 frags, 645136 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0n (NO WRITE)
> ** Last Mounted on /var/spool
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 12 files, 12 used, 5161561 free (73 frags, 645186 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0o (NO WRITE)
> ** Last Mounted on /var/tmp
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 2 files, 2 used, 1034206 free (22 frags, 129273 blocks, 0.0%
> fragmentation)
> ** /dev/rsd0p (NO WRITE)
> ** Last Mounted on /var/www
> ** Phase 1 - Check Blocks and Sizes
> ** Phase 2 - Check Pathnames
> ** Phase 3 - Check Connectivity
> ** Phase 4 - Check Reference Counts
> ** Phase 5 - Check Cyl groups
> 278 files, 881 used, 51601410 free (66 frags, 6450168 blocks, 0.0%
> fragmentation)
>
> Here's how I start my MySQL daemon.
>
> if [ -x /usr/local/bin/mysqld_safe ] ; then
> su -c mysql root -c '/usr/local/bin/mysqld_safe > /dev/null
> 2>&1 &'
> echo -n ' mysql'
> fi
>
> I have that in /etc/rc.local.
> That was how the MySQL package suggested to start the daemon.
>
> Thanks for your help and thanks to the OpenBSD team for their time
> and effort.
