I have tracked this more by using Mythweb to try to access the list of
videos. Mythweb errors with the following text:
*Fatal Error* at /var/www/localhost/htdocs/mythweb/video.php, line 50:
SQL Error: Error writing file '/tmp/MYbKY3mI' (Errcode: 28)
...examining the video.php file, here is where the failure is occurring:
$query = "SELECT * FROM videometadata " . $where . " ORDER BY title";
$result = mysql_query($query)
or trigger_error('SQL Error: '.mysql_error(), FATAL);
...errcode 28 is "System error: 28 = No space left on device"
...so, it appears that there is some sort of space issue with /tmp.
However, there is plenty of space on my disk:
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda3 9775248 5382556 4392692 56% /
/dev/hda4 106893240 55632988 51260252 53% /mnt/video
none 241212 0 241212 0% /dev/shm
please help. Any hint would be appreciated.
-dvh
Dean Vanden Heuvel wrote:
>I have been using Mythtv for over a year now, and I have never done much
>with Mythvideo. In fact, I had mapped the video directory to be the
>same as that used for recordings. When I would enter mythvideo, the
>display would show many videos, with long indecipherable names...the
>names that Myth gives to its recordings.
>
>Today, I remapped the directory to a new dir, and dropped an "avi" file
>into it. When I tried to enter mythvideo to see the listing, it took
>many minutes before the screen appeared...then there were no listings.
>My CPU is very busy during the wait, and using another networked
>computer, I ran "top" and learned that it is Mysql that seems to be
>thrashing for some time.
>
>I have searched the list here for some advice, but I haven't found
>anything quite the same. Any ideas as to what might be causing the problem?
>
>-dvh
>_______________________________________________
>mythtv-users mailing list
>[email protected]
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
