The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql keeps restarting after updating to 4.1.18-standard

Discussion in 'General Discussion' started by doubleg, May 24, 2006.

  1. doubleg

    doubleg Member
    PartnerNOC

    Joined:
    Feb 10, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    here is the log I see in the /var/lib/mysql/host.<servername>.err

    Number of processes running now: 0
    060524 11:04:12 mysqld restarted
    060524 11:04:13 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...
    060524 11:04:13 InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 3496205660.
    InnoDB: Doing recovery: scanned up to log sequence number 0 3496205660
    060524 11:04:13 InnoDB: Flushing modified pages from the buffer pool...
    060524 11:04:13 InnoDB: Started; log sequence number 0 3496205660
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.18-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)


    consistant restarts and this over and over again.

    anyone seeing this?
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    MySQL is unstable and your upgrade didn't go smoothly. Re-install MySQL one more time and if that doesn't help submit a ticket with your data center. Do you have backup copies of your DBs?
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider

    Try

    /scripts/mysqlup --force

    chown -R mysql:mysql /var/lib/mysql

    then

    /scripts/restartsrv_mysql
     
  4. doubleg

    doubleg Member
    PartnerNOC

    Joined:
    Feb 10, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    I had already given that a try. I tried it again and still having the issue.

    here is something I missed that I'm seeing when its restarting.

    libgcc_s.so.1 must be installed for pthread_cancel to work

    The log file is now 63 Megs large ;)

    here is an error I'm getting when I try the update also.

    Waiting for MySQL to restart ...
    root 32722 0.2 0.0 2132 976 pts/0 S 10:48 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/host.servername.com.pid
    mysql 488 0.0 0.6 105592 13996 pts/0 S 10:48 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/host.servername.com.pid --skip-locking
    This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.

    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

    You can safely ignore all 'Duplicate column' and 'Unknown column' errors
    because these just mean that your tables are already up to date.
    This script is safe to run even if your tables are already up to date!

    ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
    ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
    ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
    ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
    ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
    ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
    ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
    ERROR 1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
    ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
    ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
    ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
    ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
    done
     
Loading...

Share This Page