Jump to content
Калькуляторы

Вопрос спецам по Lanbilling'y переход с 1.9 до 2.0

Reply to this topic

Andrei   

Andrei
Posted · Report post

Вопрос скорее даже не по ЛБ, а по mysql

В логе mysql-сервера, на котором крутится ЛБ, вот такая ругань: 

2024-08-01T09:50:19.754013Z 0 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2024-08-01T09:50:19.754083Z 0 [Warning] InnoDB: Recalculation of persistent statistics requested for table `billing`.`radius_stat_cache` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2024-08-01T09:51:19.385888Z 0 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2024-08-01T09:51:19.385960Z 0 [Warning] InnoDB: Recalculation of persistent statistics requested for table `radius`.`radius_stat_cache` but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.

Захожу  в mysql, таблица на месте, но: 

mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
...
| innodb_table_stats        |
...
+---------------------------+
31 rows in set (0.01 sec)

mysql> select count(*) from innodb_table_stats;
ERROR 1146 (42S02): Table 'mysql.innodb_table_stats' doesn't exist
mysql> describe innodb_table_stats;
ERROR 1146 (42S02): Table 'mysql.innodb_table_stats' doesn't exist

 

Побилось что-то служебное  похоже, т.к. сам биллинг работает нормально.

Как пофиксить?

Share this post

Link to post
Share on other sites

Andrei   

Andrei
Posted · Report post
1 час назад, No_name сказал:

Попробуй 😉

Это само собой 🙂

1 час назад, No_name сказал:

в моей версии мускуля нет такой таблицы

в какой? 

 mysql --version
mysql  Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using  EditLine wrapper

 

Share this post

Link to post
Share on other sites

Andrei   

Andrei
Posted · Report post
4 часа назад, No_name сказал:

Попробуй 😉

По первой же ссылке https://stackoverflow.com/questions/15767652/mysql-error-table-mysql-innodb-table-stats-not-found
Но
  

mysql> drop table innodb_table_stats;
ERROR 1051 (42S02): Unknown table 'mysql.innodb_table_stats'
mysql> CREATE TABLE `innodb_table_stats` (
    ->   `database_name` varchar(64) NOT NULL,
    ->   `table_name` varchar(199) NOT NULL,
    ->   `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    ->   `n_rows` bigint(20) unsigned NOT NULL,
    ->   `clustered_index_size` bigint(20) unsigned NOT NULL,
    ->   `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
    ->   PRIMARY KEY (`database_name`,`table_name`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0;
ERROR 1813 (HY000): Tablespace '`mysql`.`innodb_table_stats`' exists.
mysql> describe innodb_table_stats;
ERROR 1146 (42S02): Table 'mysql.innodb_table_stats' doesn't exist

 

Share this post

Link to post
Share on other sites

Andrei   

Andrei
Posted · Report post
23 минуты назад, No_name сказал:

Файлы удалял?

Невзирая на ошибку при drop table ?
Я не потеряю при этом доступ к базам с рабочими данными?

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing Программное обеспечение, биллинг и *unix системы