| Bug #75292 | Error reinstall in Ubuntu 14.04 Server | ||
|---|---|---|---|
| Submitted: | 22 Dec 2014 16:54 | Modified: | 10 Feb 2015 15:43 |
| Reporter: | Octavio Jaume | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S1 (Critical) |
| Version: | Any | OS: | Linux (Ubuntu 14.04) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | reinstall, ubuntuººººººº | ||
[22 Dec 2014 16:54]
Octavio Jaume
[23 Dec 2014 10:56]
Octavio Jaume
I have the same problem with the version 5.7. The output log (/var/log/mysql/error.log): 141223 11:50:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-12-23T10:50:49.869500Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.5-m15) starting as process 23999 ... 2014-12-23T10:50:49.869601Z 0 [ERROR] Can't find error-message file '/usr/share/mysql/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive. 2014-12-23T10:50:49.872032Z 0 [Note] Plugin 'FEDERATED' is disabled. mysqld: Unknown error 1146 2014-12-23T10:50:49.872172Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2014-12-23T10:50:49.872353Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-12-23T10:50:49.872366Z 0 [Note] InnoDB: Uses event mutexes 2014-12-23T10:50:49.872374Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2014-12-23T10:50:49.872379Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2014-12-23T10:50:49.872384Z 0 [Note] InnoDB: Using Linux native AIO 2014-12-23T10:50:49.872635Z 0 [Note] InnoDB: Number of pools: 1 2014-12-23T10:50:49.872723Z 0 [Note] InnoDB: Using CPU crc32 instructions 2014-12-23T10:50:49.873650Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128.0M, instances = 1, chunk size = 128.0M 2014-12-23T10:50:49.887344Z 0 [Note] InnoDB: Completed initialization of buffer pool 2014-12-23T10:50:49.890899Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2014-12-23T10:50:49.967308Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2014-12-23T10:50:49.967402Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2014-12-23T10:50:50.119684Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2014-12-23T10:50:50.121147Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2014-12-23T10:50:50.121171Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2014-12-23T10:50:50.122009Z 0 [Note] InnoDB: Waiting for purge to start 2014-12-23T10:50:50.172290Z 0 [Note] InnoDB: 5.7.5 started; log sequence number 1801449 2014-12-23T10:50:50.172841Z 0 [ERROR] Unable to read errmsg.sys file 2014-12-23T10:50:50.172866Z 0 [ERROR] Aborting 2014-12-23T10:50:50.172884Z 0 [Note] Binlog end 2014-12-23T10:50:50.172957Z 0 [Note] Shutting down plugin 'partition' 2014-12-23T10:50:50.172972Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-12-23T10:50:50.173048Z 0 [Note] Shutting down plugin 'ARCHIVE' 2014-12-23T10:50:50.173058Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2014-12-23T10:50:50.173067Z 0 [Note] Shutting down plugin 'MEMORY' 2014-12-23T10:50:50.173078Z 0 [Note] Shutting down plugin 'MyISAM' 2014-12-23T10:50:50.173097Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-12-23T10:50:50.173106Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-12-23T10:50:50.173114Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-12-23T10:50:50.173122Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-12-23T10:50:50.173129Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-12-23T10:50:50.173137Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-12-23T10:50:50.173145Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-12-23T10:50:50.173152Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-12-23T10:50:50.173160Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-12-23T10:50:50.173167Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-12-23T10:50:50.173174Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-12-23T10:50:50.173182Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-12-23T10:50:50.173190Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-12-23T10:50:50.173197Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-12-23T10:50:50.173205Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-12-23T10:50:50.173213Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2014-12-23T10:50:50.173220Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2014-12-23T10:50:50.173228Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-12-23T10:50:50.173236Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-12-23T10:50:50.173243Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-12-23T10:50:50.173251Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-12-23T10:50:50.173258Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-12-23T10:50:50.173265Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-12-23T10:50:50.173273Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-12-23T10:50:50.173280Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-12-23T10:50:50.173288Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2014-12-23T10:50:50.173296Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-12-23T10:50:50.173303Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-12-23T10:50:50.173311Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2014-12-23T10:50:50.173319Z 0 [Note] Shutting down plugin 'InnoDB' 2014-12-23T10:50:50.173412Z 0 [Note] InnoDB: FTS optimize thread exiting. 2014-12-23T10:50:50.173484Z 0 [Note] InnoDB: Starting shutdown... 2014-12-23T10:50:52.072928Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1801468 2014-12-23T10:50:52.075694Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2014-12-23T10:50:52.075709Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2014-12-23T10:50:52.075716Z 0 [Note] Shutting down plugin 'CSV' 2014-12-23T10:50:52.075721Z 0 [Note] Shutting down plugin 'sha256_password' 2014-12-23T10:50:52.075725Z 0 [Note] Shutting down plugin 'mysql_native_password' 2014-12-23T10:50:52.075862Z 0 [Note] Shutting down plugin 'binlog' 2014-12-23T10:50:52.076150Z 0 [Note] 141223 11:50:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[29 Dec 2014 11:20]
Octavio Jaume
Hi, I could not reinstall MySQL server 5.6 in my Ubuntu 14.04 Server. First, i install MySQL Server 5.6 correctly, and then i reinstall MySQL. While installing, return a error: 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 21673 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys' And then: Unable to set password for the MySQL "root" user. I press intro and the system freeze. I kill start mysql and return: invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mysql-server-5.6 (--configure): subprocess installed post-installation script returned error exit status 143 Setting up mysql-common-5.6 (5.6.19-0ubuntu0.14.04.1) ... Processing triggers for libc-bin (2.19-0ubuntu6.4) ... Processing triggers for ureadahead (0.100.0-16) ... E: Sub-process /usr/bin/dpkg returned an error code (1) W: Operation was interrupted before it could finish I have space in my hard disk. I uninstall all dependencies: dpkg --get-selections|grep mysql apt-get remove --purge mysql* and i remove: /var/log/mysql /var/log/mysql.* /var/lib/mysql /etc/mysql I get .deb of web, and return other error. Can't install mysql-community-server. How to repeat: apt-get install mysql-server-5.6 or apt-get install mysql-server (from .deb)
[29 Dec 2014 11:46]
Octavio Jaume
The same problem with MariaDB
[30 Jan 2015 20:35]
Arturo Reyes Lopez
Hi eveyone, I have the same problem while installing MySQL: Preconfiguring packages ... Selecting previously unselected package mysql-common. (Reading database ... 191841 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.7.5-m15-1ubuntu14.04_amd64.deb) ... Setting up mysql-client-5.5 (5.5.41-0ubuntu0.12.04.1) ... Setting up mysql-server-core-5.5 (5.5.41-0ubuntu0.12.04.1) ... Setting up mysql-server-5.5 (5.5.41-0ubuntu0.12.04.1) ... 150129 22:24:31 [ERROR] Can't read from messagefile '/usr/share/mysql/english/errmsg.sys' have you found any possible solution for this bug? Thank you for your help Have a good day
[31 Jan 2015 10:31]
Octavio Jaume
Hi Arturo Reyes, I do not remember exactly how I did it, but I fixed it using this: - Remove MYSQL: sudo apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5 mysql-client-5.6 mysql-server-5.6 sudo apt-get autoremove sudo apt-get autoclean sudo rm -rf /etc/mysql sudo apt-get install mysql-server mysql-common mysql-client - Link apparmor: sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/usr.sbin.mysqld sudo /etc/init.d/apparmor restart - Install MySQL 5.6: apt-get install mysql-server-5.6 I don't exactly remember the order, but he tries to play with that.
[10 Feb 2015 15:43]
MySQL Verification Team
I couldn't repeat using our MySQL APT Repository: miguel@vbub14:~/Downloads$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.1 LTS Release: 14.04 Codename: trusty miguel@vbub14:~/Downloads$ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.23 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
