Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
innodb Goto page 1, 2  Next
View previous topic :: View next topic  
Author Message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 7:54 pm    Post subject: innodb Reply with quote

It doesn't look like this is active. How would I activate it? Have an app that needs it active.

Is this a bad thing? Smile
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Jun 29, 2010 8:30 pm    Post subject: Reply with quote

It supposed to be active, but the tables upgrade caused some errors.

Remove /var/lib/mysql/ib* /var/lib/mysql/mysql-bin* don't worry as they will recreate, and do a 'mysql_upgrade' and restart mysql server.
Look in /var/lib/mysql/*.err to see if INNODB plugin started succesfully.
You should see something like
"InnoDB: Started; log sequence number 0 44044"


gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 8:49 pm    Post subject: Reply with quote

Your the Man! thanks for the help Very Happy
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 8:54 pm    Post subject: Reply with quote

oops!

root@searchers:/home/wolf# mysql_upgrade -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysql/mysql.sock'
mysqlcheck: Got error: 1049: Unknown database 'sqlgreydb' when selecting the database
FATAL ERROR: Upgrade failed


help Shocked
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Jun 29, 2010 9:11 pm    Post subject: Reply with quote

Have you try to restart mysql server and do mysql_upgrade?
Does sqlgrey db exists?

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 9:18 pm    Post subject: Reply with quote

I restarted mysql but can not upgrade. I cannot login, doesn't recognize my passwd. So, don't know if sqlgrey is still there.

Next?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Jun 29, 2010 9:24 pm    Post subject: Reply with quote

At first look if sqlgreydb exist in /var/lib/mysql.
Look if mysql is running, "ps aux | grep mysql".
What /var/lib/mysql/*.err says?
Do you get access denied?

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 9:27 pm    Post subject: Reply with quote

sqlgrey does not show in that directory.

ps aux | grep mysql
root 20328 0.0 0.0 1952 508 pts/1 S+ 12:26 0:00 grep mysql


tail /var/lib/mysql/*.err
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
100629 12:16:11 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100629 12:16:12 InnoDB: Started; log sequence number 0 44233
100629 12:16:12 [Note] Recovering after a crash using mysql-bin
100629 12:16:12 [Note] Starting crash recovery...
100629 12:16:12 [Note] Crash recovery finished.
100629 12:16:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100629 12:16:12 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended


Yes, access denied.
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Jun 29, 2010 9:32 pm    Post subject: Reply with quote

mysql doesn't run, don't worry.
If you have uninstall sqlgrey just untar sqlgrey package and cp -a sqlgreydb from package to /var/lib/mysql, do a "chown -R mysql.mysql /vasr/lib/mysql" just in case.
Remove /var/lib/mysql/ib* /var/lib/mysql/mysql-bin* one again and start the server.
And try to upgrade again.
The good thing is that InnoDB started though.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 9:36 pm    Post subject: Reply with quote

I'll try now. Getting nervous.
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 9:52 pm    Post subject: Reply with quote

mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysql/mysql.sock'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Jun 29, 2010 9:57 pm    Post subject: Reply with quote

mysql is not running.
does /var/lib/mysql/*.err outputs same error?
can I login to take look?

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 9:59 pm    Post subject: Reply with quote

yes it does. go to email.
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Tue Jun 29, 2010 10:29 pm    Post subject: Reply with quote

okay - so you fixed it Very Happy

I know you are going to bed soon, but when you get a chance to read and respond to this, was it because msyql.sock could not be found?

The relative path? Have been reading Confused
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Jun 29, 2010 10:39 pm    Post subject: Reply with quote

During the mysql_upgrade all of your databases moved to mysql@002eold and stay there because of the failure.
Technically you didn't have any database to start. your /var/lib/mysql were empty.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
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 vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional