Results 1 to 7 of 7

Thread: [SOLVED] Upgrade 5.0.19 > 6.0.6 hangs on "starting mysql..."

Threaded View

  1. #1
    Join Date
    Jun 2009
    Location
    Hamburg, Germany
    Posts
    22
    Rep Power
    6

    Default [SOLVED] Upgrade 5.0.19 > 6.0.6 hangs on "starting mysql..."

    Hello.

    So I started the upgrade grom 5.0.19 to 6.0.6 Network Edition on CentOS 5 x64. Everything ran smoothly so far, but now it hangs at "starting mysql...".

    I had a look into /opt/zimbra/log/mysql-error.log:
    Code:
    100424 16:57:48 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown
    
    100424 16:57:49  InnoDB: Starting shutdown...
    100424 16:57:55  InnoDB: Shutdown completed; log sequence number 4 1415862554
    100424 16:57:55 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete
    
    100424 16:57:55  mysqld ended
    
    100424 17:20:46  mysqld started
    100424 17:20:51  InnoDB: Started; log sequence number 4 1415862554
    100424 17:20:51 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
    100424 17:44:40 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown
    
    100424 17:44:40  InnoDB: Starting shutdown...
    100424 17:44:42  InnoDB: Shutdown completed; log sequence number 4 1416207138
    100424 17:44:42 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete
    
    100424 17:44:42  mysqld ended
    
    100424 17:46:46  mysqld started
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    100424 17:46:46  InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    100424 17:46:46  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 100 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Progress in MB: 100
    100424 17:46:49  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 100 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Progress in MB: 100
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    100424 17:46:52  InnoDB: Started; log sequence number 0 0
    100424 17:46:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    100424 17:46:52  mysqld ended
    
    100424 17:46:56  mysqld started
    InnoDB: Log scan progressed past the checkpoint lsn 0 36808
    100424 17:46:57  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 0 43655
    100424 17:46:57  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 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
    100424 17:46:58  InnoDB: Started; log sequence number 0 43655
    100424 17:46:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    100424 17:46:58  mysqld ended
    
    100424 17:47:07  mysqld started
    InnoDB: Log scan progressed past the checkpoint lsn 0 36808
    100424 17:47:12  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 0 43655
    100424 17:47:14  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 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
    100424 17:47:14  InnoDB: Started; log sequence number 0 43655
    100424 17:47:14 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    100424 17:47:14  mysqld ended
    
    100424 17:47:18  mysqld started
    InnoDB: Log scan progressed past the checkpoint lsn 0 36808
    100424 17:47:18  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 0 43655
    100424 17:47:18  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 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
    100424 17:47:19  InnoDB: Started; log sequence number 0 43655
    100424 17:47:19 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    100424 17:47:19  mysqld ended
    Here I cut it because the last parts keep repeating.

    This makes me kind of nervous... any suggestions?

    Edit: Now the install script added a "done" after "starting mysql" and then said "UPGRADE FAILED - exiting". :S
    Last edited by Jay2k1; 04-24-2010 at 10:20 AM.

Similar Threads

  1. [SOLVED] Upgrade to 6.0.4 hangs: Starting mysql...
    By faizel in forum Administrators
    Replies: 4
    Last Post: 07-31-2010, 03:08 PM
  2. Replies: 0
    Last Post: 04-16-2010, 12:05 PM
  3. [SOLVED] mysql not starting after restoring from backup
    By jschnip in forum Administrators
    Replies: 4
    Last Post: 02-02-2009, 08:07 AM
  4. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  5. Upgrade hangs @ starting mysql
    By billzeta in forum Installation
    Replies: 10
    Last Post: 05-27-2008, 12:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •