do you have video files on that hard drive? You only show an image file in your select statement.
The problem relates to all media types, i.e. video, image, audio. I also have video files:
mysql> select Path, Filename from File where Path like '%/home/public/data/other/Windows Share-F [75]/untarHP_machineDriveF/Avner/freeMind/MyMedia/MyVideos/TapesFromTheParents%' orderby PK_File desc limit 1;
+------------------------------------------------------------------------------------------------------------------------+----------+
| Path | Filename |
+------------------------------------------------------------------------------------------------------------------------+----------+
| /home/public/data/other/Windows Share-F [75]/untarHP_machineDriveF/Avner/freeMind/MyMedia/MyVideos/TapesFromTheParents | Tape9 |
+------------------------------------------------------------------------------------------------------------------------+----------+
1 row in set (0.05 sec)
After rebooting, Orbiter showed the video files but after a while they disappeared again.
I found that the network drive was dismounted and fails to mount again:
dcerouter_1015401:~# less /var/log/pluto/StorageDevices.log
...
1 Sat Jul 2 00:46:02 PDT 2011 20798 CALLED TO MOUNT DEVICE 75
1 Sat Jul 2 00:46:02 PDT 2011 29768 CALLED TO MOUNT DEVICE 75
1 Sat Jul 2 00:46:03 PDT 2011 15540 CALLED TO MOUNT DEVICE 75
...
dcerouter_1015401:~# less /var/log/pluto/umount-wrapper.log
...
21407 CALLED TO 'mount -t cifs -s -o username=family,password=*****,dir_mode=0777,file_mode=0777,iocharset=utf8 //192.168.80.129/F /mnt/device/75'
21407 EXIT WITH STATUS 0
21497 CALLED TO 'mount -t cifs -s -o username=family,password=*****,dir_mode=0777,file_mode=0777,iocharset=utf8 //192.168.80.129/F /mnt/device/75'
21497 EXIT WITH STATUS 0
...
tty2 shows the following error repeatedly:
...
cifs_read_super: get root inode failed
cifs_read_super: get root inode failed
...
Trying to run the mount command manually from the command line fails:
dcerouter_1015401:~# mount -t cifs -s -o username=family,password=*****,dir_mode=0777,file_mode=0777,iocharset=utf8 //192.168.80.129/F /mnt/device/75
mount error: cifs filesystem not supported by the system
Refer to the mount.cifs(8) manual page (e.g.man mount.cifs)
However, mounting the drive using fstab succeeds. Adding the following line in /etc/fstab
mount -t cifs -s -o username=family,password=*****,dir_mode=0777,file_mode=0777,iocharset=utf8 //192.168.80.129/F /mnt/device/75
and mounting the drive using
mount -a
from the command line mounts the network drive successfully.
I tried to work around the problem by mounting through fstab. The drive mounts succesfully first, but after a while dismounts, and then fails to mount again.
Solving the problem of the network drive mount failure is the next step to solve the original problem.
Any ideas?