View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 22 posts ] 
Go to page 1, 2  Next

Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun May 04, 2008 2:58 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 04, 2008 3:37 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 04, 2008 3:41 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Start with the disaster recovery page on the wiki here: http://www.knoppmythwiki.org/index.php?page=DisasterRecovery

Especially: http://www.knoppmythwiki.org/index.php?page=RepairingMythConvergDB


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 04, 2008 6:36 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 04, 2008 10:31 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Wed May 07, 2008 9:34 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Wed May 07, 2008 10:44 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sat May 17, 2008 3:18 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sat May 17, 2008 3:24 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sat May 17, 2008 7:32 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 18, 2008 3:48 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 18, 2008 4:26 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 18, 2008 4:31 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 18, 2008 7:37 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Sun May 18, 2008 7:49 pm 
Offline
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
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 22 posts ] 
Go to page 1, 2  Next



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 24 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu