В веб-интерфейсе.
-
-
Кто может подсумировать что нужно сделать ?
Пример zabbix 5.4 + postgres 13 + TimescaleDB 2.3.1
Обновляю фронт скачиваю пакеты стандартно. Дальше нужно сделать то что по ссылке https://www.zabbix.com/documentation...timescaledb-v2 только для TimescaleDB или TimescaleDB+postgres
/usr/share/doc/zabbix-sql-scripts/postgresql/history_pk_prepare.sql только этот скрипт или что-то ещё нужно. Спасибо
Comment
-
Сначала походу вообще потеряла связь с базой:
2997:20220217:175202.981 database is down: reconnecting in 10 seconds
2997:20220217:175212.986 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
2997:20220217:175212.986 database is down: reconnecting in 10 seconds
2997:20220217:175222.993 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
2997:20220217:175222.993 database is down: reconnecting in 10 seconds
2997:20220217:175232.997 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
2997:20220217:175232.997 database is down: reconnecting in 10 seconds
3539:20220217:175239.314 current database version (mandatory/optional): 06000000/06000000
4062:20220217:185002.392 current database version (mandatory/optional): 05040000/05040000
4062:20220217:185002.392 starting automatic database upgrade
4062:20220217:185002.393 database upgrade failed
4062:20220217:185002.396 database could be upgraded to use primary keys in history tables
4077:20220217:185012.516 current database version (mandatory/optional): 05040000/05040000
4077:20220217:185012.516 starting automatic database upgrade
4077:20220217:185012.516 database upgrade failed
4077:20220217:185012.519 database could be upgraded to use primary keys in history tables
4098:20220217:185022.743 current database version (mandatory/optional): 05040000/05040000
4098:20220217:185022.743 starting automatic database upgrade
4098:20220217:185022.744 database upgrade failed
4098:20220217:185022.746 database could be upgraded to use primary keys in history tables
4113:20220217:185033.013 current database version (mandatory/optional): 05040000/05040000
4113:20220217:185033.013 starting automatic database upgrade
4113:20220217:185033.013 database upgrade failed
4113:20220217:185033.015 database could be upgraded to use primary keys in history tables
4129:20220217:185043.263 current database version (mandatory/optional): 05040000/05040000
4129:20220217:185043.263 starting automatic database upgrade
4129:20220217:185043.263 database upgrade failed
4129:20220217:185043.265 database could be upgraded to use primary keys in history tables
4146:20220217:185053.507 current database version (mandatory/optional): 05040000/05040000
4146:20220217:185053.507 starting automatic database upgrade
4146:20220217:185053.508 database upgrade failed
4146:20220217:185053.509 database could be upgraded to use primary keys in history tables
Comment
-
Ну у вас та же самая проблема с первичными ключами - https://www.zabbix.com/documentation...b_primary_keys
Comment
-
Спасибо за информацию.
Начал преобразовывать базу данных по инструкции. Я сам не очень понимаю в базах данных, но вроде тут какие то ошибки и это настоарживает.
MySQL localhost zabbix JS > util.importTable(CSVPATH + "/history.csv", {"dialect": "csv", "table": "history" });
ERROR: The 'local_infile' global system variable must be set to ON in the target server, after the server is verified to be trusted.
Util.importTable: Invalid preconditions (RuntimeError)
И так несколько раз поодряд при импорте.
Не подскажите, это нормально? И как от этого избавиться?
updated:
Запустил команду:
Code:mysql> set global local_infile=ON;
Старые ошибки исчезли, появились новые:
Code:util.importTable(CSVPATH + "/history_text.csv", {"dialect": "csv", "table": "history_text" }); Importing from file '/var/lib/mysql-files/history_text.csv' to table `zabbix`.`history_text` in MySQL Server at /run%2Fmysqld%2Fmysqld.sock using 6 threads ERROR: [Worker005] history_text.csv: MySQL Error 1114 (HY000): The table 'history_text' is full @ file bytes range [250000141, 299706196): LOAD DATA LOCAL INFILE '/var/lib/mysql-files/history_text.csv' INTO TABLE `zabbix`.`history_text` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES STARTING BY '' TERMINATED BY '\r\n' ERROR: [Worker001] history_text.csv: MySQL Error 1114 (HY000): The table 'history_text' is full @ file bytes range [200000133, 250000141): LOAD DATA LOCAL INFILE '/var/lib/mysql-files/history_text.csv' INTO TABLE `zabbix`.`history_text` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES STARTING BY '' TERMINATED BY '\r\n' ERROR: [Worker000] history_text.csv: MySQL Error 3 (HY000): Error writing file '/tmp/MLfd=227' (OS errno 28 - No space left on device) @ file bytes range [150000109, 200000133): LOAD DATA LOCAL INFILE '/var/lib/mysql-files/history_text.csv' INTO TABLE `zabbix`.`history_text` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES STARTING BY '' TERMINATED BY '\r\n' ERROR: [Worker004] history_text.csv: MySQL Error 3 (HY000): Error writing file '/tmp/MLfd=224' (OS errno 28 - No space left on device) @ file bytes range [100000073, 150000109): LOAD DATA LOCAL INFILE '/var/lib/mysql-files/history_text.csv' INTO TABLE `zabbix`.`history_text` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES STARTING BY '' TERMINATED BY '\r\n' ERROR: [Worker003] history_text.csv: MySQL Error 1114 (HY000): The table 'history_text' is full @ file bytes range [50000030, 100000073): LOAD DATA LOCAL INFILE '/var/lib/mysql-files/history_text.csv' INTO TABLE `zabbix`.`history_text` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES STARTING BY '' TERMINATED BY '\r\n' ERROR: [Worker002] history_text.csv: MySQL Error 1114 (HY000): The table 'history_text' is full @ file bytes range [0, 50000030): LOAD DATA LOCAL INFILE '/var/lib/mysql-files/history_text.csv' INTO TABLE `zabbix`.`history_text` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES STARTING BY '' TERMINATED BY '\r\n' 100% (299.71 MB / 299.71 MB), 32.62 MB/s Total rows affected in zabbix.history_text: Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 Util.importTable: [Worker000] history_text.csv: MySQL Error 3 (HY000): Error writing file '/tmp/MLfd=227' (OS errno 28 - No space left on device) @ file bytes range [150000109, 200000133): LOAD DATA LOCAL INFILE '/var/lib/mysql-files/history_text.csv' INTO TABLE `zabbix`.`history_text` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES STARTING BY '' TERMINATED BY '\r\n' (RuntimeError)
А не подскажите, сколько таблиц нужно преобразовать?
Last edited by Zbbixuser; 18-02-2022, 08:13.Comment
Comment