Servus.
jemand ne Lösung für? :>
Hostname.err
Code
- 200508 17:47:06 mysqld_safe mysqld from pid file /var/db/mysql/Projekt.pid ended
- 200508 17:48:17 mysqld_safe Logging to '/var/db/mysql/Projekt.err'.
- 200508 17:48:18 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2020-05-08 17:48:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2020-05-08 17:48:21 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.36) starting as process 724 ...
- 2020-05-08 17:48:22 724 [Note] Plugin 'FEDERATED' is disabled.
- 2020-05-08 17:48:22 724 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2020-05-08 17:48:22 724 [Note] InnoDB: The InnoDB memory heap is disabled
- 2020-05-08 17:48:22 724 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2020-05-08 17:48:22 724 [Note] InnoDB: Memory barrier is not used
- 2020-05-08 17:48:22 724 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2020-05-08 17:48:23 724 [Note] InnoDB: Not using CPU crc32 instructions
- 2020-05-08 17:48:23 724 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2020-05-08 17:48:23 724 [Note] InnoDB: Completed initialization of buffer pool
- 2020-05-08 17:48:24 724 [Note] InnoDB: Highest supported file format is Barracuda.
- 2020-05-08 17:48:25 724 [Note] InnoDB: 128 rollback segment(s) are active.
- 2020-05-08 17:48:25 724 [Note] InnoDB: Waiting for purge to start
- 2020-05-08 17:48:25 724 [Note] InnoDB: 5.6.36 started; log sequence number 1646681
- 2020-05-08 17:48:25 724 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
- 2020-05-08 17:48:25 724 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
- 2020-05-08 17:48:25 724 [Note] Server hostname (bind-address): '*'; port: 3306
- 2020-05-08 17:48:25 724 [Note] IPv6 is available.
- 2020-05-08 17:48:25 724 [Note] - '::' resolves to '::';
- 2020-05-08 17:48:25 724 [Note] Server socket created on IP: '::'.
- 2020-05-08 17:48:26 724 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
- 2020-05-08 17:48:26 724 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
- 2020-05-08 17:48:26 724 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [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).
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
- 2020-05-08 17:48:26 724 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
- 2020-05-08 17:48:26 724 [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).
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
- 2020-05-08 17:48:26 724 [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).
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
- 2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
- 2020-05-08 17:48:26 724 [Note] Event Scheduler: Loaded 0 events
- 2020-05-08 17:48:26 724 [Note] /usr/local/libexec/mysqld: ready for connections.
- Version: '5.6.36' socket: '/tmp/mysql.sock' port: 3306 Source distribution
- 2020-05-08 17:55:00 724 [Warning] InnoDB: Cannot open table common/priv_settings from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
- 2020-05-08 17:55:00 724 [Warning] InnoDB: Cannot open table common/priv_settings from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
DB Syserr
Code
- SYSERR: May 8 17:55:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
- query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW();
- SYSERR: May 8 17:55:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
- query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings
Danke!