On 12/10/18 4:27 PM, Danny Horne via users wrote:
Managed to get it going (found another log file I didn't know
existed!!). Websites are back up now but it looks like I have much work
to do judging by logged errors -
2018-12-11T00:23:09.838450Z 0 [System] [MY-010116] [Server]
/usr/libexec/mysqld (mysqld 8.0.13) starting as process 5200
2018-12-11T00:23:11.373458Z 0 [Warning] [MY-010068] [Server] CA
certificate ca.pem is self signed.
2018-12-11T00:23:11.384224Z 0 [ERROR] [MY-013129] [Server] A message
intended for a client cannot be sent there as no client-session is
attached. Therefore, we're sending the information to the error-log
instead: MY-001146 - Table 'mysql.component' doesn't exist
2018-12-11T00:23:11.384307Z 0 [Warning] [MY-013129] [Server] A message
intended for a client cannot be sent there as no client-session is
attached. Therefore, we're sending the information to the error-log
instead: MY-003543 - The mysql.component table is missing or has an
incorrect definition.
2018-12-11T00:23:11.455427Z 0 [Warning] [MY-010929] [Server] Storage
engine 'MyISAM' does not support system tables. [mysql.user].
2018-12-11T00:23:11.455478Z 0 [Warning] [MY-010929] [Server] Storage
engine 'MyISAM' does not support system tables. [mysql.db].
2018-12-11T00:23:11.455487Z 0 [Warning] [MY-010929] [Server] Storage
engine 'MyISAM' does not support system tables. [mysql.tables_priv].
2018-12-11T00:23:11.455495Z 0 [Warning] [MY-010929] [Server] Storage
engine 'MyISAM' does not support system tables. [mysql.columns_priv].
2018-12-11T00:23:11.455503Z 0 [Warning] [MY-010929] [Server] Storage
engine 'MyISAM' does not support system tables. [mysql.procs_priv].
2018-12-11T00:23:11.455511Z 0 [Warning] [MY-010929] [Server] Storage
engine 'MyISAM' does not support system tables. [mysql.proxies_priv].
2018-12-11T00:23:11.456005Z 0 [ERROR] [MY-013143] [Server] Column count
of mysql.user is wrong. Expected 50, found 45. The table is probably
corrupted
2018-12-11T00:23:11.456042Z 0 [Warning] [MY-010966] [Server] ACL table
mysql.role_edges missing. Some operations may fail.
2018-12-11T00:23:11.456050Z 0 [Warning] [MY-010966] [Server] ACL table
mysql.default_roles missing. Some operations may fail.
2018-12-11T00:23:11.456058Z 0 [Warning] [MY-010966] [Server] ACL table
mysql.global_grants missing. Some operations may fail.
2018-12-11T00:23:11.456065Z 0 [Warning] [MY-010966] [Server] ACL table
mysql.password_history missing. Some operations may fail.
2018-12-11T00:23:11.458828Z 0 [Warning] [MY-010315] [Server] 'user'
entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.458886Z 0 [Warning] [MY-010315] [Server] 'user'
entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.458903Z 0 [Warning] [MY-010315] [Server] 'user'
entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.458920Z 0 [Warning] [MY-010315] [Server] 'user'
entry 'rtadmin@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.458936Z 0 [Warning] [MY-010315] [Server] 'user'
entry 'multi_admin@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.459128Z 0 [Warning] [MY-010323] [Server] 'db' entry
'performance_schema mysql.session@localhost' ignored in
--skip-name-resolve mode.
2018-12-11T00:23:11.459145Z 0 [Warning] [MY-010323] [Server] 'db' entry
'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.459155Z 0 [Warning] [MY-010323] [Server] 'db' entry
'rt rtadmin@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.459165Z 0 [Warning] [MY-010323] [Server] 'db' entry
'trisect\_multi multi_admin@localhost' ignored in --skip-name-resolve mode.
2018-12-11T00:23:11.459306Z 0 [Warning] [MY-010311] [Server]
'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve
mode.
2018-12-11T00:23:11.459325Z 0 [ERROR] [MY-010965] [Server] Missing
system table mysql.global_grants; please run mysql_upgrade to create it.
2018-12-11T00:23:11.463177Z 0 [Warning] [MY-010330] [Server]
'tables_priv' entry 'user mysql.session@localhost' ignored in
--skip-name-resolve mode.
2018-12-11T00:23:11.463210Z 0 [Warning] [MY-010330] [Server]
'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in
--skip-name-resolve mode.
2018-12-11T00:23:11.465057Z 0 [Warning] [MY-010727] [Server] System
table 'func' is expected to be transactional.
2018-12-11T00:23:11.467349Z 0 [Warning] [MY-010405] [Repl] Info table is
not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2018-12-11T00:23:11.467390Z 0 [ERROR] [MY-010422] [Repl] Error in
checking mysql.slave_master_info repository info type of TABLE.
2018-12-11T00:23:11.467404Z 0 [ERROR] [MY-010415] [Repl] Error creating
master info: Error checking repositories.
2018-12-11T00:23:11.467413Z 0 [ERROR] [MY-010426] [Repl] Slave: Failed
to initialize the master info structure for channel ''; its record may
still be present in 'mysql.slave_master_info' table, consider deleting it.
2018-12-11T00:23:11.467422Z 0 [ERROR] [MY-010529] [Repl] Failed to
create or recover replication info repositories.
2018-12-11T00:23:11.469538Z 0 [System] [MY-010931] [Server]
/usr/libexec/mysqld: ready for connections. Version: '8.0.13' socket:
'/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
2018-12-11T00:23:11.537075Z 0 [System] [MY-011323] [Server] X Plugin
ready for connections. Socket: '/var/lib/mysql/mysqlx.sock'
bind-address: '::' port: 33060
Yup. Some of those are fixable via mysql_upgrade, others are fairly
important and appear to be caused by using a newer mysqld that's not
backwards compatible with your previous version. You didn't say which
version of MySQL you were running before and whether 8.0.13 was
compatible with it. Generally, the website has info on what's compatible
and how to convert from old to new.
The entry that bothers me the most is the
Column count of mysql.user is wrong. Expected 50, found 45. The
table is probably corrupted
message. That's going to need fixing.
Also, how did you get it to start?
----------------------------------------------------------------------
- Rick Stevens, Systems Engineer, AllDigital ricks(a)alldigital.com -
- AIM/Skype: therps2 ICQ: 226437340 Yahoo: origrps2 -
- -
- Better to understand a little than to misunderstand a lot. -
----------------------------------------------------------------------