[mythtv-users] ...misuse of Mythvideo

[Dean Vanden Heuvel]

As I think about this, it could be that the reason it TAKES SO LONG is
that the SELECT query is attempting to create a HUGE file (maybe some
infinite looping is occurring??), which, even though I have a LOT of
disk space, eats ALL of it and wants more.  Can't get more, hence the
error, and the file is not created.  Now, WHY would a select from
"videometadata" seem to loop infinitely??

-dvh

Dean Vanden Heuvel wrote:

>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
>>mythtv-users at mythtv.org
>>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>> 
>>
>>    
>>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>  
>