I apologize for my inaccurate assessment re 4.x to 5.x breaking mysql. var log dpkg.log grepped for mysql and server over period of first update and problem:
dpkg.log:2007-09-06 14:03:03 upgrade mysql-server 5.0.38-0ubuntu1 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:03:03 status half-configured mysql-server 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:03 status unpacked mysql-server 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:03 status half-installed mysql-server 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:05 status half-installed mysql-server 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:05 status unpacked mysql-server 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:03:05 status unpacked mysql-server 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:03:15 upgrade mysql-server-5.0 5.0.38-0ubuntu1 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:03:15 status half-configured mysql-server-5.0 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:15 status unpacked mysql-server-5.0 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:15 status half-installed mysql-server-5.0 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:31 status half-installed mysql-server-5.0 5.0.38-0ubuntu1 dpkg.log:2007-09-06 14:03:32 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:03:34 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status unpacked mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 14:48:35 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 15:46:30 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 15:53:49 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 16:18:15 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 16:22:47 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 16:23:41 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 19:43:09 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 19:44:53 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-06 20:07:25 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-07 09:21:53 status half-configured mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-07 09:21:57 status installed mysql-server-5.0 5.0.45-1ubuntu2 dpkg.log:2007-09-07 09:21:58 status unpacked mysql-server 5.0.45-1ubuntu2 dpkg.log:2007-09-07 09:21:58 status half-configured mysql-server 5.0.45-1ubuntu2 dpkg.log:2007-09-07 09:21:58 status installed mysql-server 5.0.45-1ubuntu2 daemon.log grepped for mysql from next day when still trying to install/fix (I had wiped older compressed logs which I do from time to time so don't have the 9/6 messages) [EMAIL PROTECTED]:/var/log# grep mysql daemon.log.0 Sep 7 09:21:55 localhost mysqld_safe[19322]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Sep 7 09:21:55 localhost mysqld_safe[19322]: To do so, start the server, then issue the following commands: Sep 7 09:21:55 localhost mysqld_safe[19322]: /usr/bin/mysqladmin -u root password 'new-password' Sep 7 09:21:55 localhost mysqld_safe[19322]: /usr/bin/mysqladmin -u root -h zonker password 'new-password' Sep 7 09:21:55 localhost mysqld_safe[19322]: See the manual for more instructions. Sep 7 09:21:55 localhost mysqld_safe[19322]: Please report any problems with the /usr/bin/mysqlbug script! Sep 7 09:21:55 localhost mysqld_safe[19322]: Sep 7 09:21:55 localhost mysqld_safe[19322]: The latest information about MySQL is available on the web at Sep 7 09:21:55 localhost mysqld_safe[19322]: http://www.mysql.com Sep 7 09:21:55 localhost mysqld_safe[19322]: Support MySQL by buying support/licenses at http://shop.mysql.com Sep 7 09:21:56 localhost mysqld_safe[19387]: ERROR: 1046 No database selected Sep 7 09:21:56 localhost mysqld_safe[19387]: 070907 9:21:56 [ERROR] Aborting Sep 7 09:21:56 localhost mysqld_safe[19387]: Sep 7 09:21:56 localhost mysqld_safe[19387]: 070907 9:21:56 [Note] /usr/sbin/mysqld: Shutdown complete Sep 7 09:21:56 localhost mysqld_safe[19387]: Sep 7 10:20:39 localhost mysqld_safe[5430]: started Sep 7 10:20:41 localhost mysqld[5433]: 070907 10:20:41 InnoDB: Database was not shut down normally! Sep 7 10:20:41 localhost mysqld[5433]: InnoDB: Starting crash recovery. Sep 7 10:20:41 localhost mysqld[5433]: InnoDB: Reading tablespace information from the .ibd files... Sep 7 10:20:43 localhost mysqld[5433]: InnoDB: Restoring possible half-written data pages from the doublewrite Sep 7 10:20:43 localhost mysqld[5433]: InnoDB: buffer... Sep 7 10:20:43 localhost mysqld[5433]: 070907 10:20:43 InnoDB: Starting log scan based on checkpoint at Sep 7 10:20:43 localhost mysqld[5433]: InnoDB: log sequence number 0 632204. Sep 7 10:20:43 localhost mysqld[5433]: InnoDB: Doing recovery: scanned up to log sequence number 0 632204 Sep 7 10:20:44 localhost mysqld[5433]: InnoDB: Last MySQL binlog file position 0 23521, file name /var/log/mysql/mysql-bin.000375 Sep 7 10:20:44 localhost mysqld[5433]: 070907 10:20:44 InnoDB: Started; log sequence number 0 632204 Sep 7 10:20:44 localhost mysqld[5433]: 070907 10:20:44 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Sep 7 10:20:44 localhost mysqld[5433]: 070907 10:20:44 [Note] Starting crash recovery... Sep 7 10:20:44 localhost mysqld[5433]: 070907 10:20:44 [Note] Crash recovery finished. Sep 7 10:20:44 localhost mysqld[5433]: 070907 10:20:44 [ERROR] Can't open the mysql.func table. Please run the mysql_install_db script to create it. Sep 7 10:20:44 localhost mysqld[5433]: 070907 10:20:44 [Note] /usr/sbin/mysqld: ready for connections. Sep 7 10:20:44 localhost mysqld[5433]: Version: '5.0.45-Debian_1ubuntu2-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution Sep 7 10:20:46 localhost /etc/mysql/debian-start[5524]: Upgrading MySQL tables if necessary. Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: Looking for 'mysql' in: /usr/bin/mysql Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: Running 'mysqlcheck'... Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.columns_priv Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'columns_priv' Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.db OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.func Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'func' Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.help_category OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.help_keyword OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.help_relation OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.help_topic OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.host OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.proc OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.procs_priv Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'procs_priv' Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.tables_priv Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'tables_priv' Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.time_zone OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.time_zone_leap_second OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.time_zone_name OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.time_zone_transition OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.time_zone_transition_type OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: mysql.user OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.assets OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.assigned_assets OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.assigned_sections OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.cached_pages OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.content_versions OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.contents OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.events OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.feedbacks OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.memberships OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.mephisto_plugins OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.schema_info OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.sections OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.sessions OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.sites OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.taggings OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.tags OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_mephisto.users OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.addresses OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.csi_codes OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.dependencies OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.digital_entries OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.digital_entry_types OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.email_addresses OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.labor_counts OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.labor_types OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.media_families OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.organization_types OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.organizations OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.people OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.person_qb_types OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.person_types OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.phone_numbers OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.staff OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.states OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.tasks OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.text_entries OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: randall_workphlo.text_entry_types OK Sep 7 10:20:48 localhost /etc/mysql/debian-start[5527]: Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: Repairing tables Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: mysql.columns_priv Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'columns_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: mysql.func Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'func' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: mysql.procs_priv Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'procs_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: mysql.tables_priv Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: error : Incorrect file format 'tables_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: Running 'mysql_fix_privilege_tables'... Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 105: Incorrect file format 'tables_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 108: Incorrect file format 'tables_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 117: Incorrect file format 'tables_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 131: Incorrect file format 'columns_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 135: Incorrect file format 'columns_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 145: Incorrect file format 'columns_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 153: Incorrect file format 'func' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 203: Incorrect file format 'func' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 273: Incorrect file format 'func' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 275: Incorrect file format 'func' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 378: Incorrect file format 'procs_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 382: Incorrect file format 'procs_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 386: Incorrect file format 'procs_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: ERROR 130 (HY000) at line 390: Incorrect file format 'procs_priv' Sep 7 10:20:54 localhost /etc/mysql/debian-start[5527]: FATAL ERROR: Upgrade failed Sep 7 10:20:54 localhost /etc/mysql/debian-start[5560]: Checking for insecure root accounts. Sep 7 10:20:54 localhost /etc/mysql/debian-start[5564]: WARNING: mysql.user contains 3 root accounts without password! Sep 7 10:20:54 localhost /etc/mysql/debian-start[5565]: Checking for crashed MySQL tables. Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: WARNING: mysqlcheck has found corrupt tables Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: mysql.columns_priv Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: error : Incorrect file format 'columns_priv' Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: mysql.func Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: error : Incorrect file format 'func' Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: mysql.procs_priv Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: error : Incorrect file format 'procs_priv' Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: mysql.tables_priv Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: error : Incorrect file format 'tables_priv' Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: Improperly closed tables are also reported if clients are accessing Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: the tables *now*. A list of current connections is below. Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: +----+------------------+-----------+----+---------+------+-------+------------------+ Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: | Id | User | Host | db | Command | Time | State | Info | Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: +----+------------------+-----------+----+---------+------+-------+------------------+ Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: | 9 | debian-sys-maint | localhost | | Query | 0 | | show processlist | Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: +----+------------------+-----------+----+---------+------+-------+------------------+ Sep 7 10:20:56 localhost /etc/mysql/debian-start[5692]: Uptime: 15 Threads: 1 Questions: 252 Slow queries: 0 Opens: 136 Flush tables: 1 Open tables: 50 Queries per second avg: 16.800 -- mysql upgrade feisty to gutsy breaks https://bugs.launchpad.net/bugs/138714 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
