LinHES Forums
http://forums.linhes.org/

System froze had to power cycle now problems with MySQL
http://forums.linhes.org/viewtopic.php?f=17&t=18262		 Page 1 of 2
Author:  sparky.watson [ Sun May 04, 2008 2:58 pm ]
Post subject:  System froze had to power cycle now problems with MySQL
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
Author:  cecil [ Sun May 04, 2008 3:37 pm ]
Post subject: 
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!
Author:  tjc [ Sun May 04, 2008 3:41 pm ]
Post subject: 
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
Author:  sparky.watson [ Sun May 04, 2008 6:36 pm ]
Post subject: 
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
Author:  cecil [ Sun May 04, 2008 10:31 pm ]
Post subject: 
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.
Author:  sparky.watson [ Wed May 07, 2008 9:34 pm ]
Post subject: 
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...
Author:  cecil [ Wed May 07, 2008 10:44 pm ]
Post subject: 
I'm unfamiliar error. I'd suggest a google search.
Author:  sparky.watson [ Sat May 17, 2008 3:18 pm ]
Post subject: 
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...
Author:  tjc [ Sat May 17, 2008 3:24 pm ]
Post subject: 
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/*
Author:  sparky.watson [ Sat May 17, 2008 7:32 pm ]
Post subject: 
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.
Author:  sparky.watson [ Sun May 18, 2008 3:48 pm ]
Post subject: 
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?
Author:  bigbro [ Sun May 18, 2008 4:26 pm ]
Post subject: 
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.
Author:  tjc [ Sun May 18, 2008 4:31 pm ]
Post subject: 
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
Author:  sparky.watson [ Sun May 18, 2008 7:37 pm ]
Post subject: 
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?
Author:  tjc [ Sun May 18, 2008 7:49 pm ]
Post subject: 
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?
Page 1 of 2 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/