[mythtv-users] problems with mythweb, database and dual tuners

[Harondel J. Sibble]

Okay, kinda ripping my hair out.  Last week finally got dual tuners working 
nicely together, an ATI TV Wonder and a Hauppauge PVR-250.  

Life was good...

and then it wasn't :-(

Running 0.11 on MDK8.2 with a "clean" (kernel.org) 2.4.20 kernel.

Basically the long and short is that scheduling 2 shows at the same time 
results in error of the following sort


Changing from None to RecordingOnly
DB Error (WriteRecordedToDB):
Query was:
INSERT INTO recorded 
(chanid,starttime,endtime,title,subtitle,description,hostname,category,autoexpire) 
VALUES(1040,"20030918220000","20030919003500","American History X","","A 
reformed skinhead tries to change his 
brother.","marcus.sibble.com","Drama",0);
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1040-20030918220000' for key 1

Changing from None to RecordingOnly

Normally I setup all my recordings from mythweb.

Looking through the archives the closest thing I can see to reason was that 
maybe mysql was running under a different user that couldn't access the 
files. I haven't made any changes to mysql in several months so that seems 
like a non starter.

Here is what I see in the database after this problem, note this is copied 
from within the mysql module in webmin



7 1 1046 22:00:00 2003-09-18 00:00:00 2003-09-19 Amazon Women on the Moon 
Assorted sketches spoof low-budget movies of the '50s and late-night TV 
commercials. 0  0 0 0 0 0

8 1 1040 22:00:00 2003-09-18 00:35:00 2003-09-19 American History X
A reformed skinhead tries to change his brother.  0 0 0 0 0 0


and here is what I see in mythweb

2 Recorded Programs
Title Station Air Date Length Description Size Action

American History X SHCASEP 09-18-2003 10:00 pm 2.6 hrs A reformed skinhead 
tries to change his brother. 5.4 MB

0 1046 12-31-1969 03:59 pm 0 mins Amazon Women on the Moon 180 GB

-1 12-31-1969 03:59 pm 0 mins 0 0 EB

Total recording time: 2.6 hrs
Storage: 7.6 GB used out of 110.9 GB total


Thinking maybe I had some database corruption, I dumped the mythconverg 
database and readded it 

$ cd database 
$ mysql -u root < mc.sql

I then reran setup and configured everything again.

Looking in the video directory, I can see that the file size for one of the 
shows is increasing while the other is stopped when they should both be 
increasing.

Disk space is not an issue as I have a 120gb drive that only has under 20gb 
in use.

Now if I go into the watch recorded shows screen, usually the first show I 
wanted to record has stopped recording and maybe 15 minutes was recorded, if 
I play it back, or just try to delete it, it hangs the frontend, the second 
show is happily recording (on the ATI card I think).

Any ideas.