ich habe ein problem ich habe die kori files 1.5
wenn ich den server neu aufsetze und den server reboote geht alles wunderbar
aber sobald ich die VM bennde und wieder starte kommt dieser fehler
wäre nett wenn ihr mir helfen könnt
Code
- 170318 17:23:42 mysqld_safe Logging to '/var/db/mysql/soul.err'.
- 170318 17:23:42 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2017-03-18 17:23:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2017-03-18 17:23:48 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.35) starting as process 996 ...
- 2017-03-18 17:23:48 996 [Note] Plugin 'FEDERATED' is disabled.
- 2017-03-18 17:23:48 996 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2017-03-18 17:23:48 996 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-03-18 17:23:48 996 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-03-18 17:23:48 996 [Note] InnoDB: Memory barrier is not used
- 2017-03-18 17:23:48 996 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-03-18 17:23:48 996 [Note] InnoDB: Not using CPU crc32 instructions
- 2017-03-18 17:23:48 996 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2017-03-18 17:23:48 996 [Note] InnoDB: Completed initialization of buffer pool
- 2017-03-18 17:23:49 996 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
- 2017-03-18 17:23:49 996 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
- 2017-03-18 17:23:49 996 [Note] InnoDB: Database physically writes the file full: wait...
- 2017-03-18 17:23:51 996 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
- 2017-03-18 17:23:51 996 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
- 2017-03-18 17:23:52 996 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
- 2017-03-18 17:23:52 996 [Warning] InnoDB: New log files created, LSN=45781
- 2017-03-18 17:23:52 996 [Note] InnoDB: Doublewrite buffer not found: creating new
- 2017-03-18 17:23:52 996 [Note] InnoDB: Doublewrite buffer created
- 2017-03-18 17:23:52 996 [Note] InnoDB: 128 rollback segment(s) are active.
- 2017-03-18 17:23:52 996 [Warning] InnoDB: Creating foreign key constraint system tables.
- 2017-03-18 17:23:52 996 [Note] InnoDB: Foreign key constraint system tables created
- 2017-03-18 17:23:52 996 [Note] InnoDB: Creating tablespace and datafile system tables.
- 2017-03-18 17:23:52 996 [Note] InnoDB: Tablespace and datafile system tables created.
- 2017-03-18 17:23:52 996 [Note] InnoDB: Waiting for purge to start
- 2017-03-18 17:23:52 996 [Note] InnoDB: 5.6.35 started; log sequence number 0
- /usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
- 2017-03-18 17:23:52 996 [Warning] World-writable config file './auto.cnf' has been removed.
- 2017-03-18 17:23:52 996 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4676e323-0bf7-11e7-a638-0800279d7fd8.
- 2017-03-18 17:23:52 996 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
- 2017-03-18 17:23:52 996 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
- 2017-03-18 17:23:52 996 [Note] Server hostname (bind-address): '*'; port: 3306
- 2017-03-18 17:23:52 996 [Note] IPv6 is available.
- 2017-03-18 17:23:52 996 [Note] - '::' resolves to '::';
- 2017-03-18 17:23:52 996 [Note] Server socket created on IP: '::'.
- 2017-03-18 17:23:52 996 [Note] Event Scheduler: Loaded 0 events
- 2017-03-18 17:23:52 996 [Note] /usr/local/libexec/mysqld: ready for connections.
- Version: '5.6.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution
- 2017-03-18 18:03:42 996 [Warning] IP address '123.81.222.136' could not be resolved: hostname nor servname provided, or not known
- 2017-03-18 18:08:27 996 [Note] /usr/local/libexec/mysqld: Normal shutdown
- 2017-03-18 18:08:27 996 [Note] Giving 86 client threads a chance to die gracefully
- 2017-03-18 18:08:49 996 [Note] Event Scheduler: Purging the queue. 0 events
- 2017-03-18 18:08:49 996 [Note] Shutting down slave threads
- 2017-03-18 18:08:51 996 [Note] Forcefully disconnecting 73 remaining clients
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 13 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 15 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 16 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 17 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 18 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 22 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 24 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 25 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 26 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 27 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 28 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 29 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 30 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 31 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 32 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 33 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 34 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 35 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 36 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 37 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 38 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 39 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 40 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 41 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 42 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 43 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 49 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 50 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 51 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 52 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 53 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 54 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 55 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 56 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 57 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 58 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 61 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 62 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 63 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 64 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 65 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 66 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 67 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 68 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 69 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 70 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 71 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 72 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 73 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 75 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 78 user: 'root'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 79 user: 'root'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 80 user: 'root'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 109 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 112 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 113 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 114 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 126 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 127 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 128 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 133 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 136 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 137 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 138 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 139 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 140 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 141 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 145 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 146 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 155 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 157 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 159 user: 'mt2'
- 2017-03-18 18:08:51 996 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 162 user: 'mt2'
- 2017-03-18 18:09:01 996 [Note] Binlog end
- 170318 18:11:23 mysqld_safe Logging to '/var/db/mysql/soul.err'.
- 170318 18:11:24 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2017-03-18 18:11:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2017-03-18 18:11:33 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.35) starting as process 724 ...
- 2017-03-18 18:11:33 724 [Note] Plugin 'FEDERATED' is disabled.
- 2017-03-18 18:11:33 724 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2017-03-18 18:11:33 724 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-03-18 18:11:33 724 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-03-18 18:11:33 724 [Note] InnoDB: Memory barrier is not used
- 2017-03-18 18:11:33 724 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-03-18 18:11:33 724 [Note] InnoDB: Not using CPU crc32 instructions
- 2017-03-18 18:11:33 724 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2017-03-18 18:11:33 724 [Note] InnoDB: Completed initialization of buffer pool
- 2017-03-18 18:11:33 724 [Note] InnoDB: Highest supported file format is Barracuda.
- 2017-03-18 18:11:33 724 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600607 in the ib_logfiles!
- 2017-03-18 18:11:33 724 [Note] InnoDB: Database was not shutdown normally!
- 2017-03-18 18:11:33 724 [Note] InnoDB: Starting crash recovery.
- 2017-03-18 18:11:33 724 [Note] InnoDB: Reading tablespace information from the .ibd files...
- 2017-03-18 18:11:34 724 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_table_stats uses space ID: 1 at filepath: ./mysql/innodb_table_stats.ibd. Cannot open tablespace player/okay_event which uses space ID: 1 at filepath: ./player/okay_event.ibd
- 2017-03-18 18:11:34 29403080 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 ./player/okay_event.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.
- 170318 18:11:35 mysqld_safe mysqld from pid file /var/db/mysql/soul.pid ended