[mythtv-users] Mythtv 24.1 - MythFillDatabase filling the database
Trevor Burns
mythtv at teklord.com
Thu Mar 1 14:48:41 UTC 2012
Mike
The database is currently on an EXT4 file system. Looking at fstab (see
below), I am not seeing any indication of barriers for the mounts. One item
I forgot to include, the two 500G drives are "linked" as a LVM volume group.
/dev/mapper/vg_pvr2-lv_root / ext4 defaults
1 1
UUID=3a613e91-3559-4f4e-8344-0a5115b08c4b /boot ext4
defaults 1 2
/dev/mapper/vg_pvr2-lv_swap swap swap defaults
0 0
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
As I mentioned in my starting e-mail, I was running the Mythfilldatabase
process while writing the email. Here is the segment of the log during that
period (the log finally closed out at 21:15).
--------------- LOG SEGMENT --------------------------
2012-02-29 15:53:55.688 Using runtime prefix = /usr
2012-02-29 15:53:55.713 Read conf dir = /etc/mythtv
2012-02-29 15:53:55.713 Using configuration directory = /etc/mythtv
2012-02-29 15:53:55.713 Using localhost value of pvr2
2012-02-29 15:53:55.713 Configuration::Load - Error parsing:
/etc/mythtv/config.xml at line: 1 column: 1
2012-02-29 15:53:55.714 Configuration::Load - Error Msg: error occurred
while parsing element
2012-02-29 15:53:55.717 New DB connection, total: 1
2012-02-29 15:53:55.722 Connected to database 'mythconverg' at host:
localhost
2012-02-29 15:53:55.724 Closing DB connection named 'DBManager0'
2012-02-29 15:53:55.724 Connected to database 'mythconverg' at host:
localhost
2012-02-29 15:53:55.726 Current locale en_CA
2012-02-29 15:53:55.726 Reading locale defaults from
/usr/share/mythtv//locales/en_ca.xml
2012-02-29 15:53:55.732 Loading en_us translation for module mythfrontend
2012-02-29 15:53:55.733 Current MythTV Schema Version (DBSchemaVer): 1264
2012-02-29 15:53:55.734 New DB connection, total: 2
2012-02-29 15:53:55.734 Connected to database 'mythconverg' at host:
localhost
2012-02-29 15:53:55.735 Updating source #1 (MTS) with grabber
schedulesdirect1
2012-02-29 15:53:55.736 Found 123 channels for source 1 which use grabber
2012-02-29 15:53:55.736
2012-02-29 15:53:55.736 Checking day @ offset 0, date: Wed Feb 29 2012
2012-02-29 15:53:55.740 Data refresh needed because no data exists for day @
offset 0 from 8PM - midnight.
2012-02-29 15:53:55.740 Refreshing data for Wed Feb 29 2012
2012-02-29 15:53:55.740 New DB DataDirect connection
2012-02-29 15:53:55.740 Connected to database 'mythconverg' at host:
localhost
2012-02-29 15:53:55.832 Retrieving datadirect data.
2012-02-29 15:53:55.832 Grabbing data for Wed Feb 29 2012 offset 0
2012-02-29 15:53:55.832 From Wed Feb 29 06:00:00 2012 to Thu Mar 1 06:00:00
2012 (UTC)
2012-02-29 15:53:55.833 Grabbing listing data
--2012-02-29 15:53:55--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlisti
ngs/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: "STDOUT"
0K .......... .......... .......... .......... .......... 26.0K
50K .......... .......... ........2012-02-29 15:54:00.501 New DB
connection, total: 3
2012-02-29 15:54:00.501 Connected to database 'mythconverg' at host:
localhost
2012-02-29 15:54:00.503 DataDirect: Your subscription expires on Tuesday Jun
19 11:08 PM
2012-02-29 15:54:32.864 sourceid 1 has lineup type: CableDigital
.. .......... .......... 177
100K .......... .......... .......... .......... .......... 220
150K .......... .......... .......... ... 553 =9m46s
2012-02-29 16:18:42 (320 B/s) - Read error at byte 187800 (Connection timed
out).Retrying.
--2012-02-29 16:18:43-- (try: 2)
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlisti
ngs/xtvdService
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
The file is already fully retrieved; nothing to do.
gzip: stdin: unexpected end of file
2012-02-29 16:20:36.431 DataDirect, Error: DataDirect XML failed to properly
parse, downloaded listings were probably corrupt.
2012-02-29 16:20:36.431 Encountered error in grabbing data.
2012-02-29 16:20:36.431
2012-02-29 16:20:36.431 Checking day @ offset 1, date: Thu Mar 1 2012
2012-02-29 16:20:36.431 Data Refresh always needed for tomorrow
2012-02-29 16:20:36.431 Refreshing data for Thu Mar 1 2012
2012-02-29 16:20:36.497 Retrieving datadirect data.
2012-02-29 16:20:36.497 Grabbing data for Wed Feb 29 2012 offset 1
2012-02-29 16:20:36.497 From Thu Mar 1 06:00:00 2012 to Fri Mar 2 06:00:00
2012 (UTC)
2012-02-29 16:20:36.498 Grabbing listing data
--2012-02-29 16:20:36--
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlisti
ngs/xtvdService
Resolving webservices.schedulesdirect.tmsdatadirect.com... 144.142.232.53
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]
Saving to: "STDOUT"
0K .......... .......... .......... .......... .......... 14.1K
50K .......... .......... ........2012-02-29 16:20:41.402 DataDirect:
Your subscription expires on Tuesday Jun 19 11:08 PM
.. .......... .......... 353
100K .......... .......... .......... .......... .......... 289
150K .......... .......... .......... ...... 602 =6m27s
2012-02-29 16:42:04 (492 B/s) - Read error at byte 190590 (Connection timed
out).Retrying.
--2012-02-29 16:42:05-- (try: 2)
http://webservices.schedulesdirect.tmsdatadirect.com/schedulesdirect/tvlisti
ngs/xtvdService
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 401 Unauthorized
Connecting to
webservices.schedulesdirect.tmsdatadirect.com|144.142.232.53|:80...
connected.
HTTP request sent, awaiting response... 200 OK
The file is already fully retrieved; nothing to do.
gzip: stdin: unexpected end of file
--------------- LOG SEGMENT -----------------------
I looked at the /etc/mythtv/config.xml file -- it only has a comment "# to
be filled in by mythtv-setup". Which I have completed -- and looking at my
MythDora 12.23 both files have the same comment.
Trevor Burns
-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Michael T. Dean
Sent: Thursday, March 01, 2012 12:58 AM
To: Discussion about MythTV
Subject: Re: [mythtv-users] Mythtv 24.1 - MythFillDatabase filling the
database
On 02/29/2012 05:19 PM, teklord wrote:
> I have been using MythTV on another system successfully for 2 years.
> The machine is aging, it is running Fedora 12, and doesn't have a lot
> of horse power (commercial scanning, podcasting is done on a secondary
> backend that I want to re-purpose). A couple of weeks ago, I decided
> to build a new machine and eventually migrate from the old machine.
>
> After going through the Mythtv-Setup to define the General, Capture
> Cards, etc I dropped to commandline and ran 'mythfilldatabase'
> expecting it to populate the database with TV Listings from Schedules
Direct.
>
> I have been trying to get MythFillDatabase to populate the database on
> the new machine. I have even tried dumping the 24.1 database, export
> my current working MythDora installation, importing it, upgrading the
> database, re-configuring to match the current system, and run
> mythfilldatabase -- nothing is working.
>
> On my other machine, Mythfilldatabase took 9 minutes to download and
> populate this morning -- so I don't think it is a network connection
issue.
>
What file system is your MySQL database data on? Do you have barriers
enabled on the file system?
Mike
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-users
More information about the mythtv-users
mailing list