View previous topic :: View next topic |
Author |
Message |
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 7:54 pm Post subject: innodb |
|
|
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](images/smiles/icon_smile.gif) |
|
Back to top |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 29, 2010 8:30 pm Post subject: |
|
|
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 |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 8:49 pm Post subject: |
|
|
Your the Man! thanks for the help ![Very Happy](images/smiles/icon_biggrin.gif) |
|
Back to top |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 8:54 pm Post subject: |
|
|
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](images/smiles/icon_eek.gif) |
|
Back to top |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 29, 2010 9:11 pm Post subject: |
|
|
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 |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 9:18 pm Post subject: |
|
|
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 |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 29, 2010 9:24 pm Post subject: |
|
|
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 |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 9:27 pm Post subject: |
|
|
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 |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 29, 2010 9:32 pm Post subject: |
|
|
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 |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 9:36 pm Post subject: |
|
|
I'll try now. Getting nervous. |
|
Back to top |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 9:52 pm Post subject: |
|
|
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 |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 29, 2010 9:57 pm Post subject: |
|
|
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 |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 9:59 pm Post subject: |
|
|
yes it does. go to email. |
|
Back to top |
|
baboo Senior Member
Joined: 04 Sep 2007 Posts: 676
|
Posted: Tue Jun 29, 2010 10:29 pm Post subject: |
|
|
okay - so you fixed it
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](images/smiles/icon_confused.gif) |
|
Back to top |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 29, 2010 10:39 pm Post subject: |
|
|
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 |
|
|