Author |
Message |
sparky.watson
|
Posted: Sun May 04, 2008 2:58 pm |
|
Joined: Mon Oct 23, 2006 1:11 pm
Posts: 74
Location:
San Antonio, Texas
|
When system boots up now, I see:
Mount failed for selinuxfs. No such file or directory
(Only when I have problems do I really pay close attention but I've seen this before, is it "normal"?)
after a while:
Starting MySQL database server: mysqld....failed!
Then when I get to the GUI, I'm prompted to "Select your preferred language", select English, then "Database Configuration 1/2 Myth could not connect to the database..."
Looking for any help to get this thing going again.
Thanks
_________________ AMD 3000+ MSI K8MM-V 512MB PC3200, 2TB SATA HD, GeForce 256MB 6200, DVD-RW, Hauppauage WinTV-PVR 150 (flakey with terrible video?) & 250 -- R7.4 (rdt) --
|
|
Top |
|
|
cecil
|
Posted: Sun May 04, 2008 3:37 pm |
|
|
Site Admin |
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location:
Whittier, Ca
|
The selinuxfs error can be ignored. You need to check MySQL for errors. I posted on how to do this a while ago in Hints and Tips. Once you done that, ensure the backend is started and take a look at the backend log. Then start the frontend.
It is always a good idea to check MySQL after a power failure. Good luck!
|
|
Top |
|
|
tjc
|
Posted: Sun May 04, 2008 3:41 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
|
Top |
|
|
sparky.watson
|
Posted: Sun May 04, 2008 6:36 pm |
|
Joined: Mon Oct 23, 2006 1:11 pm
Posts: 74
Location:
San Antonio, Texas
|
I had previously found the "check MySQL for errors"
cd /var/lib/mysql/mythconverg
/etc/init.d/mythtv-backend stop
/etc/init.d/mysql stop
myisamchk *.MYI >> mythconverg_check.log
and not seeing any errors figured I was heading in the wrong direction.
Based on the link to RepairingMythConvergDB, I went ahead and copied the optimize_db.sh script and ran it. I did comment out the following:
/etc/init.d/mysql restart
/etc/init.d/mythtv-backend stop
/etc/init.d/mythtv-backend start
When I did the mysql restart manully, I got the same thing:
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
Here is end of daemon.log/syslog/debug.log:
Code: ... May 4 15:54:06 mythtv ntpd[3198]: synchronized to 128.10.19.24, stratum 1 May 4 19:18:32 mythtv mysqld_safe[5517]: started May 4 19:18:32 mythtv mysqld[5520]: 080504 19:18:32 InnoDB: Started; log sequence number 0 43665 May 4 19:18:32 mythtv mysqld[5520]: 080504 19:18:32 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm' May 4 19:18:32 mythtv mysqld[5520]: 080504 19:18:32 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm' May 4 19:18:32 mythtv mysqld[5520]: 080504 19:18:32 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/host.frm' May 4 19:18:32 mythtv mysqld_safe[5531]: ended May 4 19:18:46 mythtv /etc/init.d/mysql[5666]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in May 4 19:18:46 mythtv /etc/init.d/mysql[5666]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed May 4 19:18:46 mythtv /etc/init.d/mysql[5666]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' May 4 19:18:46 mythtv /etc/init.d/mysql[5666]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! May 4 19:18:46 mythtv /etc/init.d/mysql[5666]:
so it looks like I've arrived at a problem with ./mysql/host.frm just like in http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043
_________________ AMD 3000+ MSI K8MM-V 512MB PC3200, 2TB SATA HD, GeForce 256MB 6200, DVD-RW, Hauppauage WinTV-PVR 150 (flakey with terrible video?) & 250 -- R7.4 (rdt) --
|
|
Top |
|
|
cecil
|
Posted: Sun May 04, 2008 10:31 pm |
|
|
Site Admin |
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location:
Whittier, Ca
|
http://bugs.mysql.com/bug.php?id=1279 or a google search may prove fruitful. If all else fails, copy the contents of /var/lib/mysql/mythconverg to /myth/backup/ (you may want to create a temp dir), then do an auto upgrade. Once complete, copy the contents back, restart mysql and the backend.
|
|
Top |
|
|
sparky.watson
|
Posted: Wed May 07, 2008 9:34 pm |
|
Joined: Mon Oct 23, 2006 1:11 pm
Posts: 74
Location:
San Antonio, Texas
|
Well...way too busy to spend more than a few minutes since the last post.
Cecil, thanks...I couldn't find anything directly useful to me from either that link or searching google. So I went with the backup copy of /var/lib/mysql/mythconverg and auto upgrade. It went through setting up passwords and IP info and eventually rebooted again, however....
After multiple attempts to get it to boot back up, sometimes I get a total grey screen (with a squiggle pattern), sometimes that gray with the workspace bar at the bottom, a couple of times about the top third of the Knoppmyth background, but never a complete background and certainly not the frontend.
I see the following in /var/log/Xorg.0.log:
Code: (EE) NVIDIA(0): Error recovery failed. (EE) NVIDIA(0): *** Aborting *** (EE) NVIDIA(0): Error recovery failed. (EE) NVIDIA(0): *** Aborting *** (EE) NVIDIA(0): Error recovery failed. (EE) NVIDIA(0): *** Aborting ***
I was able to copy the files back to /var/lib/mysql/mythconverg.
Out of time again...
_________________ AMD 3000+ MSI K8MM-V 512MB PC3200, 2TB SATA HD, GeForce 256MB 6200, DVD-RW, Hauppauage WinTV-PVR 150 (flakey with terrible video?) & 250 -- R7.4 (rdt) --
|
|
Top |
|
|
cecil
|
Posted: Wed May 07, 2008 10:44 pm |
|
|
Site Admin |
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location:
Whittier, Ca
|
I'm unfamiliar error. I'd suggest a google search.
|
|
Top |
|
|
sparky.watson
|
Posted: Sat May 17, 2008 3:18 pm |
|
Joined: Mon Oct 23, 2006 1:11 pm
Posts: 74
Location:
San Antonio, Texas
|
I hate being so busy I'm just now getting a few minutes to check this out.
Ok, how about this, in /var/log/syslog, I've got a bunch of errors like:
Quote: ... May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videogenre.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videogenre.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videometadata.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videometadata.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videometadatacountry.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videometadatacountry.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videometadatagenre.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videometadatagenre.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videosource.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videosource.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videotypes.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/videotypes.frm' (errno: 13) May 17 15:36:31 mythtv mysqld[2862]: 080517 15:36:31 [ERROR] /usr/sbin/mysqld: Can't find file: './mythconverg/websites.frm' (errno: 13) ...
Those files do exist: Quote: root@mythtv:/var/lib/mysql/mythconverg# ls -l websites.frm -rw-rw---- 1 mythtv mythtv 8650 May 4 06:48 websites.frm
Are those permissions and owerships right? I'm not sure why it is reporting it can't find those file...
_________________ AMD 3000+ MSI K8MM-V 512MB PC3200, 2TB SATA HD, GeForce 256MB 6200, DVD-RW, Hauppauage WinTV-PVR 150 (flakey with terrible video?) & 250 -- R7.4 (rdt) --
|
|
Top |
|
|
tjc
|
Posted: Sat May 17, 2008 3:24 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
Nope, those should be owned by the mysql user.
Code: root@black2:~# ls -al /var/lib/mysql/mythconverg total 188476 drwx------ 2 mysql mysql 8192 May 17 14:28 . drwxr-xr-x 4 mysql mysql 4096 May 17 14:49 .. -rw-rw---- 1 mysql mysql 376 May 17 14:27 archiveitems.MYD -rw-rw---- 1 mysql mysql 3072 May 17 14:27 archiveitems.MYI -rw-rw---- 1 mysql mysql 8955 May 11 06:47 archiveitems.frm -rw-rw---- 1 mysql mysql 1384 May 17 14:27 callsignnetworkmap.MYD -rw-rw---- 1 mysql mysql 3072 May 17 14:27 callsignnetworkmap.MYI -rw-rw---- 1 mysql mysql 8630 May 11 06:47 callsignnetworkmap.frm -rw-rw---- 1 mysql mysql 152 May 17 14:27 capturecard.MYD -rw-rw---- 1 mysql mysql 2048 May 17 14:27 capturecard.MYI -rw-rw---- 1 mysql mysql 9982 May 11 06:47 capturecard.frm -rw-rw---- 1 mysql mysql 96 May 17 14:27 cardinput.MYD -rw-rw---- 1 mysql mysql 2048 May 17 14:27 cardinput.MYI -rw-rw---- 1 mysql mysql 9434 May 11 06:47 cardinput.frm : :
To fix it, do the following as root: Code: chown -R mysql:mysql /var/lib/mysql/mythconverg chmod ug=rw /var/lib/mysql/mythconverg/*
|
|
Top |
|
|
sparky.watson
|
Posted: Sat May 17, 2008 7:32 pm |
|
Joined: Mon Oct 23, 2006 1:11 pm
Posts: 74
Location:
San Antonio, Texas
|
All right, cool. MySQL, backend and frontend are all running however this is from a PuTTY session since my Myth screen is still the gray pattern and Xorg is running crazy.
In /var/log/messages, I've got
Quote: May 17 20:28:26 mythtv kernel: ivtv0: Cause: the application is not reading fast enough. May 17 20:28:26 mythtv kernel: ivtv1: All encoder VBI stream buffers are full. Dropping data.
over and over. I've found where it is suggested to increase buffers for ivtv by adding a line to /etc/mythtv/modules/ivtv but I don't believe I ever had to do this before.
...and doesn't seem to have helped. I added "options ivtv enc_yuv_buffers=8 enc_mpg_buffers=32 enc_vbi_buffers=8 enc_pcm_buffers=8" and rebooted. Still a gray screen and still the same error over and over.
_________________ AMD 3000+ MSI K8MM-V 512MB PC3200, 2TB SATA HD, GeForce 256MB 6200, DVD-RW, Hauppauage WinTV-PVR 150 (flakey with terrible video?) & 250 -- R7.4 (rdt) --
|
|
Top |
|
|
sparky.watson
|
Posted: Sun May 18, 2008 3:48 pm |
|
Joined: Mon Oct 23, 2006 1:11 pm
Posts: 74
Location:
San Antonio, Texas
|
This is about to drive me nuts...
Quote: Increase buffer size for IVTV
The following steps eliminated the "application not reading fast enough" errors for me. This procedure increases IVTV's buffer sizes from the default of 4/8/4/4 to 8/32/8/8. Some have reported that the problem goes away with a smaller increase to 4/16/4/4 - you can experiment to see what works best for you. You need enough RAM for this to be OK - I have 1 GB ... 4. R5F27: Add the following line after the existing line in "/etc/mythtv/modules/ivtv" that reads "options msp3400 once=1": * options ivtv enc_yuv_buffers=8 enc_mpg_buffers=32 enc_vbi_buffers=8 enc_pcm_buffers=8 5. All versions: Reboot and verify that you are now allocating 32MB to your mpg buffers. You can do this by looking for the following line in /var/log/kern.log: * ivtv0: Allocate DMA encoder MPEG stream: 1024 x 32768 buffers (32768KB total)
I've done this but I do not find any message in /var/log/kern.log similar to step 5 stated to verify however I don't see any "application not reading fast enough" messages so maybe that is fixed.
Because Xorg is consuming 95+% of the CPU and I can't kill it, the system constantly pauses as I'm trying to troubleshoot.
I am able to see recorded shows via a Wintel application. I'm still getting just a gray screen on my fe/be system.
I'm sure there are now other problems with my system but I just can't seem to find what it is (or they are).
What now?
_________________ AMD 3000+ MSI K8MM-V 512MB PC3200, 2TB SATA HD, GeForce 256MB 6200, DVD-RW, Hauppauage WinTV-PVR 150 (flakey with terrible video?) & 250 -- R7.4 (rdt) --
|
|
Top |
|
|
bigbro
|
Posted: Sun May 18, 2008 4:26 pm |
|
Joined: Sat Dec 24, 2005 11:33 am
Posts: 400
Location:
Kitsap Peninsula, Wa., United States
|
Just a shot in the dark but I was seeing some really wierd indications a while back like 95-100% CPU usage associated with Xorg.
I replaced my video output card and it resolved the issue.
Let me see if I can find the post.
|
|
Top |
|
|
tjc
|
Posted: Sun May 18, 2008 4:31 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
That high CPU usage by the X server sounds like a problem we've seen with the nvidia drivers.
To fix it I made the changes recommended here http://www.mythtv.org/wiki/index.php/XvMC even though I'm not using XvMC. The key bits seemed to be the following in xorg.conf:
Code: Option "XvmcUsesTextures" "false" Option "UseEvents" "true" and these settings in .nvidia-settings-rc: Code: 0/XVideoTextureSyncToVBlank=0 0/XVideoBlitterSyncToVBlank=0
|
|
Top |
|
|
sparky.watson
|
Posted: Sun May 18, 2008 7:37 pm |
|
Joined: Mon Oct 23, 2006 1:11 pm
Posts: 74
Location:
San Antonio, Texas
|
I made just the 2 line addition to xorg.conf and that alone didn't seem to make any difference.
I don't have a .nvidia-settings-rc file anywhere, would I create it in /home/mythtv/.nvidia-settings-rc? What about ownership and permissions?
_________________ AMD 3000+ MSI K8MM-V 512MB PC3200, 2TB SATA HD, GeForce 256MB 6200, DVD-RW, Hauppauage WinTV-PVR 150 (flakey with terrible video?) & 250 -- R7.4 (rdt) --
|
|
Top |
|
|
tjc
|
Posted: Sun May 18, 2008 7:49 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
The mythtv user should own pretty much everything in it's home directory.
Code: root@black2:~# ls -al /home/mythtv/.nvidia-settings-rc -rw-r--r-- 1 mythtv mythtv 1121 May 10 00:15 /home/mythtv/.nvidia-settings-rc
On the other hand, if you don't have it and aren't running nvidia-settings from your /home/mythtv/.fluxbox/apps it shouldn't be an issue. Crud, my brain is scattered to the winds tonight... Did you put them in the proper section? Code: Section "Device" Identifier "Card0" Driver "nvidia" VendorName "All" BoardName "All" #BusID "PCI:1:0:0" Option "XvmcUsesTextures" "false" Option "UseEvents" "true" #Option "NVAGP" "2" EndSection
Did you restart the X server after making the changes?
|
|
Top |
|
|