[mythtv-users] mythfilldatabase problems

[Dan Wilson]

On 08/31/2011 02:29 PM, Michael T. Dean wrote:
> On 08/31/2011 02:44 PM, Dan Wilson wrote:
>> It almost seems as if mythfilldatabase gets stuck. When it times-out, it
>> is always between 200k-300k into the transfer, everything seems to be
>> working to that point, and then the disk i/o just stops.
> Problems with your /tmp directory/filesystem that cause it to fill up
> when mythfilldatabase is writing to it?

That partition has 40+ GB of free space.

>>    I don't see any
>> indication that anything is downloading or that any processing is
>> occurring. I ran "top", and before the failure point, mysqld and
>> mythfilldatabase are always at the top of the process list. Once it gets
>> stuck, they vanish.
> Or misconfigured MySQL that can't use the /tmp file system either due to
> invalid permissions (must be 1777) or, as above, space issues, so it
> fails if the amount of data inserted into the temp tables by
> mythfilldatabase is large enough that mysqld tries to create an on-disk
> temporary table?
drwxrwxrwt.  30 root root  4096 Aug 31 15:33 tmp

This looks right to me. I also see several small files in there, some of 
them mythtv-related and created today:

drwx------. 2 dwilson dwilson 4096 Aug 31 09:00 mythtv_ddp_7zWENi
drwx------. 2 dwilson dwilson 4096 Aug 30 18:45 mythtv_ddp_APtUjR
drwx------. 2 dwilson dwilson 4096 Aug 30 21:05 mythtv_ddp_i2fLjv
drwx------. 2 dwilson dwilson 4096 Aug 31 11:16 mythtv_ddp_leMPkv
drwx------. 2 dwilson dwilson 4096 Aug 30 17:24 mythtv_ddp_liNceN
drwx------. 2 dwilson dwilson 4096 Jul 23 20:23 mythtv_ddp_lKWGiJ
drwx------. 2 dwilson dwilson 4096 Aug 29 22:42 mythtv_ddp_lL2UZA
drwx------. 2 dwilson dwilson 4096 Aug 27 20:28 mythtv_ddp_MbN0V3
drwx------. 2 dwilson dwilson 4096 Aug 31 10:25 mythtv_ddp_MWmFen
drwx------. 2 dwilson dwilson 4096 Aug 31 13:14 mythtv_ddp_pw79LS
drwx------. 2 dwilson dwilson 4096 Aug 30 22:13 mythtv_ddp_QWZ3QB
drwx------. 2 dwilson dwilson 4096 Aug 31 12:58 mythtv_ddp_tG0Iwc
drwx------. 2 dwilson dwilson 4096 Aug 31 09:59 mythtv_ddp_YRoX2l


I ran a test run with "-v database,xmltv". At the point of failure, the 
last diagnostic shows a SQL insert command just like thousands of 
inserts before it. In short, I haven't found a smoking gun as of yet....

Unless someone has any other thoughts, I guess the next step is to go 
get the 0.24.1 source files, compile my own mythfilldatabase with gdb 
debugging enabled, and see what I can find when it fails....

Dan.