Hallo zusammen,
ich bräuchte mal ein paar Anreize für eine möglichst leichte Lösung.
Folgendes Problem;
MYSQL startet beim booten der Fliege Files nicht und ist auch laut service mysql-server status nicht aktiv.
Die Logs sagen man solle ein mysql_upgrade durchführen, dafür habe ich jedoch trotz mysql_upgrade -uroot -p --force keinerlei Berechtigung.
Via mysql_safe --skip-grant-tables & habe ich es ebenfalls schon versucht, ohne Erfolg.
Neustarten lässt sich MYSQL auch nicht.
Der Fehler ist aufgetreten nachdem ich die CONFIG Files in Channel 1 Kern1, 2 & 3, Reiche und Neutraler_Channel (ch99) auf lvl 99 gestellt habe. Auch nach rückgängig machen keine Veränderung.
Mittlerweile bekomme ich folgende Fehlermeldung und weiß jetzt nicht mehr weiter, hoffe ihr könnt aushelfen.
2018-04-16 01:42:04 708 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-16 01:42:04 708 [Note] IPv6 is available.
2018-04-16 01:42:04 708 [Note] - '::' resolves to '::';
2018-04-16 01:42:04 708 [Note] Server socket created on IP: '::'.
2018-04-16 01:42:05 708 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50092, now running 50639. Please use mysql_upgrade to fix this error.
2018-04-16 01:42:05 708 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2018-04-16 01:42:05 708 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.39' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2018-04-16 01:43:12 708 [Note] /usr/local/libexec/mysqld: Normal shutdown
2018-04-16 01:43:12 708 [Note] Giving 0 client threads a chance to die gracefully
2018-04-16 01:43:12 708 [Note] Shutting down slave threads
2018-04-16 01:43:12 708 [Note] Forcefully disconnecting 0 remaining clients
2018-04-16 01:43:12 708 [Note] Binlog end
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'partition'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_METRICS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_CMP'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'INNODB_TRX'
2018-04-16 01:43:12 708 [Note] Shutting down plugin 'InnoDB'
2018-04-16 01:43:12 708 [Note] InnoDB: FTS optimize thread exiting.
2018-04-16 01:43:12 708 [Note] InnoDB: Starting shutdown...
2018-04-16 01:43:13 708 [Note] InnoDB: Shutdown completed; log sequence number 1949980
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'BLACKHOLE'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'ARCHIVE'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'MRG_MYISAM'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'MyISAM'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'MEMORY'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'CSV'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'sha256_password'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'mysql_old_password'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'mysql_native_password'
2018-04-16 01:43:13 708 [Note] Shutting down plugin 'binlog'
2018-04-16 01:43:13 708 [Note] /usr/local/libexec/mysqld: Shutdown complete
180416 01:43:13 mysqld_safe mysqld from pid file /var/db/mysql/root602778.kms4.cc.pid ended
180416 01:43:13 mysqld_safe Logging to '/var/db/mysql/root602778.kms4.cc.err'.
180416 01:43:13 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2018-04-16 01:43:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-16 01:43:14 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.39) starting as process 963 ...
2018-04-16 01:43:14 963 [Note] Plugin 'FEDERATED' is disabled.
2018-04-16 01:43:14 963 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-16 01:43:14 963 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 01:43:14 963 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 01:43:14 963 [Note] InnoDB: Memory barrier is not used
2018-04-16 01:43:14 963 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-04-16 01:43:14 963 [Note] InnoDB: Using CPU crc32 instructions
2018-04-16 01:43:14 963 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-16 01:43:14 963 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 01:43:14 963 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-16 01:43:15 963 [Note] InnoDB: 128 rollback segment(s) are active.
2018-04-16 01:43:15 963 [Note] InnoDB: Waiting for purge to start
2018-04-16 01:43:15 963 [Note] InnoDB: 5.6.39 started; log sequence number 1949980
2018-04-16 01:43:15 963 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2018-04-16 01:43:15 963 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2018-04-16 01:43:15 963 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-16 01:43:15 963 [Note] IPv6 is available.
2018-04-16 01:43:15 963 [Note] - '::' resolves to '::';
2018-04-16 01:43:15 963 [Note] Server socket created on IP: '::'.
2018-04-16 01:43:15 963 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50092, now running 50639. Please use mysql_upgrade to fix this error.
2018-04-16 01:43:15 963 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2018-04-16 01:43:15 963 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.39' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2018-04-16 01:52:56 963 [Warning] Host name 'social10.cayopesystems.com' could not be resolved: hostname nor servname provided, or not known
2018-04-16 02:22:28 963 [Note] /usr/local/libexec/mysqld: Normal shutdown
2018-04-16 02:22:28 963 [Note] Giving 45 client threads a chance to die gracefully
2018-04-16 02:22:28 963 [Note] Shutting down slave threads
2018-04-16 02:22:30 963 [Note] Forcefully disconnecting 27 remaining clients
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 13 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 14 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 15 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 16 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 17 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 18 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 19 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 20 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 21 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 22 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 23 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 24 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 25 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 26 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 27 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 28 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 29 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 30 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 31 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 32 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 33 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 34 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 35 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 36 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 37 user: 'core'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 47 user: 'root'
2018-04-16 02:22:30 963 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 48 user: 'root'
2018-04-16 02:22:30 963 [Note] Binlog end
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'partition'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_METRICS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_CMP'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'INNODB_TRX'
2018-04-16 02:22:30 963 [Note] Shutting down plugin 'InnoDB'
2018-04-16 02:22:30 963 [Note] InnoDB: FTS optimize thread exiting.
2018-04-16 02:22:30 963 [Note] InnoDB: Starting shutdown...
2018-04-16 02:22:32 963 [Note] InnoDB: Shutdown completed; log sequence number 1949990
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'BLACKHOLE'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'ARCHIVE'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'MRG_MYISAM'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'MyISAM'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'MEMORY'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'CSV'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'sha256_password'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'mysql_old_password'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'mysql_native_password'
2018-04-16 02:22:32 963 [Note] Shutting down plugin 'binlog'
2018-04-16 02:22:32 963 [Note] /usr/local/libexec/mysqld: Shutdown complete
180416 02:22:32 mysqld_safe mysqld from pid file /var/db/mysql/root602778.kms4.cc.pid ended
180416 02:23:14 mysqld_safe Logging to '/var/db/mysql/root602778.kms4.cc.err'.
180416 02:23:14 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2018-04-16 02:23:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-16 02:23:15 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.39) starting as process 710 ...
2018-04-16 02:23:15 710 [Note] Plugin 'FEDERATED' is disabled.
2018-04-16 02:23:15 710 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-16 02:23:15 710 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 02:23:15 710 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 02:23:15 710 [Note] InnoDB: Memory barrier is not used
2018-04-16 02:23:15 710 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-04-16 02:23:15 710 [Note] InnoDB: Using CPU crc32 instructions
2018-04-16 02:23:15 710 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-16 02:23:15 710 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 02:23:16 710 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-16 02:23:16 710 [Note] InnoDB: 128 rollback segment(s) are active.
2018-04-16 02:23:16 710 [Note] InnoDB: Waiting for purge to start
2018-04-16 02:23:16 710 [Note] InnoDB: 5.6.39 started; log sequence number 1949990
2018-04-16 02:23:16 710 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2018-04-16 02:23:16 710 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2018-04-16 02:23:16 710 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-16 02:23:16 710 [Note] IPv6 is available.
2018-04-16 02:23:16 710 [Note] - '::' resolves to '::';
2018-04-16 02:23:16 710 [Note] Server socket created on IP: '::'.
2018-04-16 02:23:16 710 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50092, now running 50639. Please use mysql_upgrade to fix this error.
2018-04-16 02:23:16 710 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2018-04-16 02:23:16 710 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.39' socket: '/tmp/mysql.sock' port: 3306 Source distribution
180416 03:16:58 mysqld_safe mysqld restarted
2018-04-16 03:17:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-16 03:17:02 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.39) starting as process 1272 ...
2018-04-16 03:17:03 1272 [Note] Plugin 'FEDERATED' is disabled.
2018-04-16 03:17:03 1272 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-16 03:17:03 1272 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 03:17:03 1272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 03:17:03 1272 [Note] InnoDB: Memory barrier is not used
2018-04-16 03:17:03 1272 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-04-16 03:17:03 1272 [Note] InnoDB: Using CPU crc32 instructions
2018-04-16 03:17:03 1272 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-16 03:17:03 1272 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 03:17:04 1272 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-16 03:17:04 1272 [Note] InnoDB: The log sequence numbers 1949990 and 1949990 in ibdata files do not match the log sequence number 1950000 in the ib_logfiles!
2018-04-16 03:17:04 1272 [Note] InnoDB: Database was not shutdown normally!
2018-04-16 03:17:04 1272 [Note] InnoDB: Starting crash recovery.
2018-04-16 03:17:04 1272 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-04-16 03:17:04 1272 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_worker_info uses space ID: 5 at filepath: ./mysql/slave_worker_info.ibd. Cannot open tablespace account/server_settings which uses space ID: 5 at filepath: ./account/server_settings.ibd
2018-04-16 03:17:04 803616000 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./account/server_settings.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
180416 03:17:04 mysqld_safe mysqld from pid file /var/db/mysql/root602778.kms4.cc.pid ended
180416 03:36:52 mysqld_safe Logging to '/var/db/mysql/root602778.kms4.cc.err'.
180416 03:36:53 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2018-04-16 03:36:55 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-16 03:36:55 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.39) starting as process 714 ...
2018-04-16 03:36:55 714 [Note] Plugin 'FEDERATED' is disabled.
2018-04-16 03:36:55 714 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-16 03:36:55 714 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 03:36:55 714 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 03:36:55 714 [Note] InnoDB: Memory barrier is not used
2018-04-16 03:36:55 714 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-04-16 03:36:55 714 [Note] InnoDB: Using CPU crc32 instructions
2018-04-16 03:36:55 714 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-16 03:36:55 714 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 03:36:55 714 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-16 03:36:55 714 [Note] InnoDB: The log sequence numbers 1949990 and 1949990 in ibdata files do not match the log sequence number 1950000 in the ib_logfiles!
2018-04-16 03:36:55 714 [Note] InnoDB: Database was not shutdown normally!
2018-04-16 03:36:55 714 [Note] InnoDB: Starting crash recovery.
2018-04-16 03:36:55 714 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-04-16 03:36:56 714 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_worker_info uses space ID: 5 at filepath: ./mysql/slave_worker_info.ibd. Cannot open tablespace account/server_settings which uses space ID: 5 at filepath: ./account/server_settings.ibd
2018-04-16 03:36:56 803616000 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./account/server_settings.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
180416 03:36:56 mysqld_safe mysqld from pid file /var/db/mysql/root602778.kms4.cc.pid ended
180416 03:41:31 mysqld_safe Logging to '/var/db/mysql/root602778.kms4.cc.err'.
180416 03:41:31 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2018-04-16 03:41:32 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-16 03:41:32 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.39) starting as process 700 ...
2018-04-16 03:41:33 700 [Note] Plugin 'FEDERATED' is disabled.
2018-04-16 03:41:33 700 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-16 03:41:33 700 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 03:41:33 700 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 03:41:33 700 [Note] InnoDB: Memory barrier is not used
2018-04-16 03:41:33 700 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-04-16 03:41:33 700 [Note] InnoDB: Using CPU crc32 instructions
2018-04-16 03:41:33 700 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-16 03:41:33 700 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 03:41:33 700 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-16 03:41:33 700 [Note] InnoDB: The log sequence numbers 1949990 and 1949990 in ibdata files do not match the log sequence number 1950000 in the ib_logfiles!
2018-04-16 03:41:33 700 [Note] InnoDB: Database was not shutdown normally!
2018-04-16 03:41:33 700 [Note] InnoDB: Starting crash recovery.
2018-04-16 03:41:33 700 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-04-16 03:41:33 700 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_worker_info uses space ID: 5 at filepath: ./mysql/slave_worker_info.ibd. Cannot open tablespace account/server_settings which uses space ID: 5 at filepath: ./account/server_settings.ibd
2018-04-16 03:41:33 803616000 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./account/server_settings.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
180416 03:41:33 mysqld_safe mysqld from pid file /var/db/mysql/root602778.kms4.cc.pid ended
180416 03:43:31 mysqld_safe Logging to '/var/db/mysql/root602778.kms4.cc.err'.
180416 03:43:31 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2018-04-16 03:43:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-16 03:43:31 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.39) starting as process 949 ...
2018-04-16 03:43:31 949 [Note] Plugin 'FEDERATED' is disabled.
2018-04-16 03:43:31 949 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-16 03:43:31 949 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 03:43:31 949 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 03:43:31 949 [Note] InnoDB: Memory barrier is not used
2018-04-16 03:43:31 949 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-04-16 03:43:31 949 [Note] InnoDB: Using CPU crc32 instructions
2018-04-16 03:43:31 949 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-04-16 03:43:31 949 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 03:43:32 949 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-16 03:43:32 949 [Note] InnoDB: The log sequence numbers 1949990 and 1949990 in ibdata files do not match the log sequence number 1950000 in the ib_logfiles!
2018-04-16 03:43:32 949 [Note] InnoDB: Database was not shutdown normally!
2018-04-16 03:43:32 949 [Note] InnoDB: Starting crash recovery.
2018-04-16 03:43:32 949 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-04-16 03:43:32 949 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_worker_info uses space ID: 5 at filepath: ./mysql/slave_worker_info.ibd. Cannot open tablespace account/server_settings which uses space ID: 5 at filepath: ./account/server_settings.ibd
2018-04-16 03:43:32 803616000 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./account/server_settings.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
180416 03:43:32 mysqld_safe mysqld from pid file /var/db/mysql/root602778.kms4.cc.pid ended