[mythtv-users] problems with mythweb, database and dual tuners
Harondel J. Sibble
help at pdscc.com
Fri Sep 19 01:03:21 EDT 2003
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.
More information about the mythtv-users
mailing list