powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / MySQL [игнор отключен] [закрыт для гостей] / Че за ошибка такая ?
5 сообщений из 5, страница 1 из 1
Че за ошибка такая ?
    #38668632
loginovru
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Код: sql
1.
2.
2014-06-12 21:47:00 7f710ad87700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2014-06-12 21:47:00 7f710ad87700 InnoDB: Error: Fetch of persistent statistics requested for table "pa_db"."core_url_rewrite" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.



Добрый день! А это че за ошибка такая ? И как от нее избавиться ?
...
Рейтинг: 0 / 0
Че за ошибка такая ?
    #38668647
Фотография javajdbc
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
loginovru,

баг в инсталяторе и/или баг в
миграции с предыдуших версий.
лечится патчем:

15904130
...
Рейтинг: 0 / 0
Че за ошибка такая ?
    #38668648
loginovru
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
javajdbc,

А он точно поможет ? дело в том что у меня не совсем mysql, а на базе mysql

Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3286
Server version: 10.0.11-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
...
Рейтинг: 0 / 0
Че за ошибка такая ?
    #38668655
loginovru
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
javajdbc,

пропатчил теперь в логе вот такое! Че дальше ? )

Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
140612 22:43:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140612 22:43:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140612 22:43:07 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140612 22:43:07 [Note] InnoDB: The InnoDB memory heap is disabled
140612 22:43:07 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140612 22:43:07 [Note] InnoDB: Compressed tables use zlib 1.2.3
140612 22:43:07 [Note] InnoDB: Using Linux native AIO
140612 22:43:07 [Note] InnoDB: Using CPU crc32 instructions
140612 22:43:07 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140612 22:43:07 [Note] InnoDB: Completed initialization of buffer pool
140612 22:43:07 [Note] InnoDB: Highest supported file format is Barracuda.
140612 22:43:08 [Note] InnoDB: 128 rollback segment(s) are active.
140612 22:43:08 [Note] InnoDB: Waiting for purge to start
140612 22:43:08 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 6652549566
140612 22:43:08 [Note] Plugin 'FEEDBACK' is disabled.
140612 22:43:08 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
140612 22:43:08 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MariaDB 50536, now running 100011. Please us
140612 22:43:08 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MariaDB 50536, now running 100011. Please us
140612 22:43:08 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MariaDB 50536, now running 100011. Plea
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at positio
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MariaDB 50536, now running 100011. Plea
140612 22:43:08 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MariaDB 50536, now running 100011. Please
140612 22:43:08 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
140612 22:43:08 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bi
140612 22:43:08 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
140612 22:43:08 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have
140612 22:43:08 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
140612 22:43:08 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MariaDB 50536, now running 100011. Please use mysql_upgrad
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
140612 22:43:08 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
140612 22:43:08 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
140612 22:43:08 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140612 22:43:08 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
140612 22:43:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.0.11-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  MariaDB Server
...
Рейтинг: 0 / 0
Че за ошибка такая ?
    #38668658
loginovru
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Спасибо за помощь - разобрался!

Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
140612 22:54:44 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140612 22:54:44 [Note] InnoDB: Completed initialization of buffer pool
140612 22:54:44 [Note] InnoDB: Highest supported file format is Barracuda.
140612 22:54:44 [Note] InnoDB: 128 rollback segment(s) are active.
140612 22:54:44 [Note] InnoDB: Waiting for purge to start
140612 22:54:44 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 6657444889
140612 22:54:44 [Note] Plugin 'FEEDBACK' is disabled.
140612 22:54:44 [Note] Event Scheduler: Loaded 0 events
140612 22:54:44 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.0.11-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  MariaDB Server
...
Рейтинг: 0 / 0
5 сообщений из 5, страница 1 из 1
Форумы / MySQL [игнор отключен] [закрыт для гостей] / Че за ошибка такая ?
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]