Hallo liebe Community,
und zwar stoße ich auf folgendes Problem:
ich versuche MySQL anstatt über die GUI von der Kommandozeile aus zu starten, jedoch erscheint dabei folgender Output:
# mysqld_safe start 161210 19:08:52 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect. 161210 19:08:52 mysqld_safe Logging to '/var/log/mysql/error.log'. 161210 19:08:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 161210 19:08:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Was bedeutet das und was muss ich tun?
Der Output vom error.log sieht wie folgt aus:
#cat /var/log/mysql/error.log 2016-12-10 16:34:13 1613 [Note] Plugin 'FEDERATED' is disabled. 2016-12-10 16:34:13 1613 [ERROR] Function 'innodb' already exists 2016-12-10 16:34:13 1613 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'. 2016-12-10 16:34:13 1613 [ERROR] Function 'federated' already exists 2016-12-10 16:34:13 1613 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'. 2016-12-10 16:34:13 1613 [ERROR] Function 'blackhole' already exists 2016-12-10 16:34:13 1613 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'. 2016-12-10 16:34:13 1613 [ERROR] Function 'archive' already exists 2016-12-10 16:34:13 1613 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'. 2016-12-10 16:34:13 1613 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-12-10 16:34:13 1613 [Note] InnoDB: The InnoDB memory heap is disabled 2016-12-10 16:34:13 1613 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-12-10 16:34:13 1613 [Note] InnoDB: Memory barrier is not used 2016-12-10 16:34:13 1613 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-12-10 16:34:13 1613 [Note] InnoDB: Using Linux native AIO 2016-12-10 16:34:13 1613 [Note] InnoDB: Using CPU crc32 instructions 2016-12-10 16:34:13 1613 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-12-10 16:34:13 1613 [Note] InnoDB: Completed initialization of buffer pool 2016-12-10 16:34:13 1613 [Note] InnoDB: Highest supported file format is Barracuda. 2016-12-10 16:34:13 1613 [Note] InnoDB: The log sequence numbers 1626087 and 1626087 in ibdata files do not match the log sequence number 1626097 in the ib_logfiles! 2016-12-10 16:34:13 1613 [Note] InnoDB: Database was not shutdown normally! 2016-12-10 16:34:13 1613 [Note] InnoDB: Starting crash recovery. 2016-12-10 16:34:13 1613 [Note] InnoDB: Reading tablespace information from the .ibd files... 2016-12-10 16:34:13 1613 [Note] InnoDB: Restoring possible half-written data pages 2016-12-10 16:34:13 1613 [Note] InnoDB: from the doublewrite buffer... 2016-12-10 16:34:13 1613 [Note] InnoDB: 128 rollback segment(s) are active. 2016-12-10 16:34:13 1613 [Note] InnoDB: Waiting for purge to start 2016-12-10 16:34:13 1613 [Note] InnoDB: 5.6.30 started; log sequence number 1626097 2016-12-10 16:34:13 1613 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2016-12-10 16:34:13 1613 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2016-12-10 16:34:13 1613 [Note] Server socket created on IP: '127.0.0.1'. 2016-12-10 16:34:13 1613 [ERROR] Can't start server : Bind on unix socket: No such file or directory 2016-12-10 16:34:13 1613 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ? 2016-12-10 16:34:13 1613 [ERROR] Aborting 2016-12-10 16:34:13 1613 [Note] Binlog end 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'partition' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'ARCHIVE' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'BLACKHOLE' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_METRICS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_CMP' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'INNODB_TRX' 2016-12-10 16:34:13 1613 [Note] Shutting down plugin 'InnoDB' 2016-12-10 16:34:13 1613 [Note] InnoDB: FTS optimize thread exiting. 2016-12-10 16:34:13 1613 [Note] InnoDB: Starting shutdown... 2016-12-10 16:34:15 1613 [Note] InnoDB: Shutdown completed; log sequence number 1626107 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'CSV' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'MEMORY' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'MyISAM' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'MRG_MYISAM' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'sha256_password' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'mysql_old_password' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'mysql_native_password' 2016-12-10 16:34:15 1613 [Note] Shutting down plugin 'binlog' 2016-12-10 16:34:15 1613 [Note] mysqld: Shutdown complete
Vielen Dank für jegliche Hilfeleistung!