[root@primary-lb ~]# pkg install mysql65-server [ root@primary-lb ~]# service mysql-server onestart Starting mysql. [root@primary-lb ~]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.43 Source distribution Copyright (c) 2000, 2019, 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> CREATE DATABASE `hyphenated-table`; Query OK, 1 row affected (0.00 sec) mysql> \r hypenated-table Connection id: 2 Current database: hypenated-table mysql> CREATE TABLE fts_table(id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, text_field TEXT, FULLTEXT idx (text_field)) ENGINE=InnoDB; Query OK, 0 rows affected (0.07 sec) mysql> INSERT INTO fts_table(text_field) VALUES('lorem ipsum dolor sit amet'); Query OK, 1 row affected (0.00 sec) mysql> ^DBye [root@primary-lb ~]# service mysql-server onestop Stopping mysql. Waiting for PIDS: 23052. [root@primary-lb ~]# pkg install mysql57-server [root@primary-lb ~]# service mysql-server onestart Starting mysql. [root@primary-lb ~]# mysql_upgrade Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK mysql.engine_cost OK mysql.event OK mysql.func OK mysql.general_log OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.server_cost OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Upgrading the sys schema. Checking databases. hypenated-table.fts_table OK sys.sys_config OK Upgrade process completed successfully. Checking if update is needed. [root@primary-lb ~]# service mysql-server onestop Stopping mysql. Waiting for PIDS: 25783. [root@primary-lb ~]# pkg install mysql80-server [root@primary-lb ~]# service mysql-server onestart Starting mysql. [root@primary-lb ~]# tail -n 44 /var/db/mysql/primary-lb.err 2019-02-26T22:53:51.6NZ mysqld_safe Logging to '/var/db/mysql/primary-lb.err'. 2019-02-26T22:53:51.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 100 200 100 200 100 2019-02-26T22:53:51.670007Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2019-02-26T22:53:51.670051Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release. 2019-02-26T22:53:51.670081Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2019-02-26T22:53:51.670110Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release. 2019-02-26T22:53:51.670131Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2019-02-26T22:53:51.673027Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.14) starting as process 27166 2019-02-26T22:53:55.680225Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2019-02-26T22:53:55.680234Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2019-02-26T22:53:55.680248Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './hypenated-table/FTS_0000000000000014_BEING_DELETED.ibd' OS error: 71 2019-02-26T22:53:55.680260Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `hypenated-table/FTS_0000000000000014_BEING_DELETED` because it could not be opened. 2019-02-26T22:53:55.680279Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2019-02-26T22:53:55.680287Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2019-02-26T22:53:55.680296Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './hypenated-table/FTS_0000000000000014_BEING_DELETED_CACHE.ibd' OS error: 71 2019-02-26T22:53:55.680337Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `hypenated-table/FTS_0000000000000014_BEING_DELETED_CACHE` because it could not be opened. 2019-02-26T22:53:55.680363Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2019-02-26T22:53:55.680371Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2019-02-26T22:53:55.680382Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './hypenated-table/FTS_0000000000000014_CONFIG.ibd' OS error: 71 2019-02-26T22:53:55.680391Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `hypenated-table/FTS_0000000000000014_CONFIG` because it could not be opened. 2019-02-26T22:53:55.680406Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2019-02-26T22:53:55.680414Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2019-02-26T22:53:55.680423Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './hypenated-table/FTS_0000000000000014_DELETED.ibd' OS error: 71 2019-02-26T22:53:55.680431Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `hypenated-table/FTS_0000000000000014_DELETED` because it could not be opened. 2019-02-26T22:53:55.680449Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2019-02-26T22:53:55.680457Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2019-02-26T22:53:55.680466Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './hypenated-table/FTS_0000000000000014_DELETED_CACHE.ibd' OS error: 71 2019-02-26T22:53:55.680475Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `hypenated-table/FTS_0000000000000014_DELETED_CACHE` because it could not be opened. 2019-02-26T22:53:56.350459Z 2 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2019-02-26T22:53:56.350469Z 2 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2019-02-26T22:53:56.350478Z 2 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './hypenated-table/FTS_0000000000000014_BEING_DELETED.ibd' OS error: 71 2019-02-26T22:53:56.350656Z 2 [ERROR] [MY-012592] [InnoDB] Operating system error number 14 in a file operation. 2019-02-26T22:53:56.350675Z 2 [ERROR] [MY-012596] [InnoDB] Error number 14 means 'Bad address' 2019-02-26T22:53:56.350697Z 2 [ERROR] [MY-012646] [InnoDB] File (unknown): 'stat' returned OS error 114. 2019-02-26T22:53:56.350743Z 2 [ERROR] [MY-012121] [InnoDB] Cannot find space id 9 in the tablespace memory cache, though the file '(null)' in a rename operation should have that ID. 2019-02-26T22:53:56.350765Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for hypenated-table.fts_table 2019-02-26T22:53:56.785471Z 2 [Warning] [MY-010772] [Server] db.opt file not found for test database. Using default Character set. 2019-02-26T22:53:57.113330Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables. 2019-02-26T22:53:57.114743Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-02-26T22:53:58.848808Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.14) Source distribution. 2019-02-26T22:53:58.6NZ mysqld_safe mysqld from pid file /var/db/mysql/primary-lb.pid ended