NEWS
ioBroker MySQL nach einiger Zeit "connection refused" --> MySQL Problem?
-
Hallo
NUC mit ioBroker und Historian auf einer lokalen MySQL
Ich hatte nun 3x hintereinander, dass grob nach 3 Tagen meine MySQL im Hintergrund von ioBroker "grundlos" nicht mehr da war. Das hab ich dann nur zufällig gemerkt, weil in der Vis eine LogAnzeige steht...
Nun habe ich mal ins MySQL-Log geschaut und staune nicht schlecht (log unten)
- Als Warnung für Euch ... falls auf einmal keine historischen Daten gelogged werden...
- Wie behebe ich das? Die Doku sagt mir nichts und wenn ich google komme ich zum droppen von irgendwelchen internen Tabels ... da hab ich etwas bedenken
Eure Meinung?
Gruss -
2019-05-01T04:58:36.367452Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-05-01T04:58:36.369284Z 0 [Note] mysqld (mysqld 5.7.26-0ubuntu0.18.04.1) starting as process 17250 ... 2019-05-01T04:58:36.374677Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-05-01T04:58:36.374711Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-01T04:58:36.374718Z 0 [Note] InnoDB: Uses event mutexes 2019-05-01T04:58:36.374724Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-05-01T04:58:36.374728Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-01T04:58:36.374733Z 0 [Note] InnoDB: Using Linux native AIO 2019-05-01T04:58:36.374991Z 0 [Note] InnoDB: Number of pools: 1 2019-05-01T04:58:36.375100Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-05-01T04:58:36.376709Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-05-01T04:58:36.386140Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-05-01T04:58:36.388461Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-05-01T04:58:36.400768Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-01T04:58:36.429016Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-05-01T04:58:36.429130Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-05-01T04:58:36.464405Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-05-01T04:58:36.465475Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-05-01T04:58:36.465493Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-05-01T04:58:36.466037Z 0 [Note] InnoDB: Waiting for purge to start 2019-05-01T04:58:36.516314Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 589734102 2019-05-01T04:58:36.516739Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-05-01T04:58:36.517257Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-05-01T04:58:36.526020Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-tr oubleshooting.html for how to resolve the issue. mysqld: Table 'mysql.gtid_executed' doesn't exist 2019-05-01T04:58:36.526090Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2019-05-01T04:58:36.526210Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2019-05-01T04:58:36.529528Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory. 2019-05-01T04:58:36.529727Z 0 [Warning] InnoDB: Cannot open table mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-trou bleshooting.html for how to resolve the issue. 2019-05-01T04:58:36.529747Z 0 [Warning] Failed to open optimizer cost constant tables 2019-05-01T04:58:36.530457Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional. 2019-05-01T04:58:36.530470Z 0 [Warning] System table 'time_zone_name' is expected to be transactional. 2019-05-01T04:58:36.530474Z 0 [Warning] System table 'time_zone' is expected to be transactional. 2019-05-01T04:58:36.530477Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional. 2019-05-01T04:58:36.530481Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional. 2019-05-01T04:58:36.530699Z 0 [Warning] System table 'servers' is expected to be transactional. 2019-05-01T04:58:36.530933Z 0 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50726. Please use mysql_upgrade to fix this error. 2019-05-01T04:58:36.531008Z 0 [ERROR] Column count of performance_schema.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50726. Please use mysql_upgrade to fix this error. 2019-05-01T04:58:36.531067Z 0 [ERROR] Column count of performance_schema.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50726. Please use mysql_upgrade to fix this error. 2019-05-01T04:58:36.531234Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11). 2019-05-01T04:58:36.531493Z 0 [ERROR] Column count of performance_schema.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50560, now running 50726. Please use mysql_upgrade to fix this error. 2019-05-01T04:58:36.531548Z 0 [ERROR] Column count of performance_schema.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50560, now running 50726. Please use mysql_upgrade to fix this error. 2019-05-01T04:58:36.531668Z 0 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2019-05-01T04:58:36.531824Z 0 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11). 2019-05-01T04:58:36.532557Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 3. Created with MySQL 50560, now running 50726. Please use mysql_upgrade to fix this error. 2019-05-01T04:58:36.536546Z 0 [Note] mysqld: ready for connections. Version: '5.7.26-0ubuntu0.18.04.1' socket: '/tmp/tmp.YoLu6wwr9W/mysqld.sock' port: 0 (Ubuntu) 2019-05-01T04:58:36.560792Z 2 [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/inno db-troubleshooting.html for how to resolve the issue. 2019-05-01T04:58:36.563090Z 0 [Note] Giving 0 client threads a chance to die gracefully 2019-05-01T04:58:36.563120Z 0 [Note] Shutting down slave threads 2019-05-01T04:58:36.563132Z 0 [Note] Forcefully disconnecting 0 remaining clients 2019-05-01T04:58:36.563194Z 0 [Note] Binlog end 2019-05-01T04:58:36.565282Z 0 [Note] Shutting down plugin 'ngram' 2019-05-01T04:58:36.565302Z 0 [Note] Shutting down plugin 'partition' 2019-05-01T04:58:36.565307Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2019-05-01T04:58:36.565312Z 0 [Note] Shutting down plugin 'ARCHIVE' 2019-05-01T04:58:36.565316Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2019-05-01T04:58:36.565342Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2019-05-01T04:58:36.565347Z 0 [Note] Shutting down plugin 'MyISAM' 2019-05-01T04:58:36.565354Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2019-05-01T04:58:36.565358Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2019-05-01T04:58:36.565362Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2019-05-01T04:58:36.565365Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2019-05-01T04:58:36.565369Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2019-05-01T04:58:36.565372Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2019-05-01T04:58:36.565376Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2019-05-01T04:58:36.565379Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2019-05-01T04:58:36.565383Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2019-05-01T04:58:36.565386Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2019-05-01T04:58:36.565389Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2019-05-01T04:58:36.565393Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2019-05-01T04:58:36.565396Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2019-05-01T04:58:36.565409Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2019-05-01T04:58:36.565413Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2019-05-01T04:58:36.565417Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2019-05-01T04:58:36.565420Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2019-05-01T04:58:36.565424Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2019-05-01T04:58:36.565427Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2019-05-01T04:58:36.565430Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2019-05-01T04:58:36.565434Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2019-05-01T04:58:36.565437Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2019-05-01T04:58:36.565440Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2019-05-01T04:58:36.565444Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2019-05-01T04:58:36.565447Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2019-05-01T04:58:36.565450Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2019-05-01T04:58:36.565454Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2019-05-01T04:58:36.565458Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2019-05-01T04:58:36.565461Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2019-05-01T04:58:36.565464Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2019-05-01T04:58:36.565468Z 0 [Note] Shutting down plugin 'InnoDB' 2019-05-01T04:58:36.565520Z 0 [Note] InnoDB: FTS optimize thread exiting. 2019-05-01T04:58:36.565585Z 0 [Note] InnoDB: Starting shutdown... 2019-05-01T04:58:36.565643Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190501 6:58:36 2019-05-01T04:58:36.565676Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2019-05-01T04:58:36.565859Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190501 6:58:36 2019-05-01T04:58:38.080886Z 0 [Note] InnoDB: Shutdown completed; log sequence number 589734121 2019-05-01T04:58:38.085720Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-05-01T04:58:38.085778Z 0 [Note] Shutting down plugin 'MEMORY' 2019-05-01T04:58:38.085798Z 0 [Note] Shutting down plugin 'CSV' 2019-05-01T04:58:38.085813Z 0 [Note] Shutting down plugin 'sha256_password' 2019-05-01T04:58:38.085825Z 0 [Note] Shutting down plugin 'mysql_native_password' 2019-05-01T04:58:38.086057Z 0 [Note] Shutting down plugin 'binlog' 2019-05-01T04:58:38.086506Z 0 [Note] mysqld: Shutdown complete