Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error for standby database: WAL control functions cannot be executed during recovery #196

Closed
roruizi2022 opened this issue Oct 31, 2022 · 2 comments
Assignees
Milestone

Comments

@roruizi2022
Copy link

Zabbix version 6.2
Mamonsu version 3.5.2
База данных в режиме stanby
Ошибка в Zabbix :

WAL  - plugin wal caught error: {'S': 'ERROR', 'V': 'ERROR', 'C': '55000', 'recovery is in progress', 'H': 'WAL control functions cannot be executed during recovery.', 'F': 'xlogfuncs.c', 'L': '338', 'R': 'pg_current_wal_lsn'}

Ошибка в журнале базы:

mamonsu_user@mamonsu_database STATEMENT:
                SELECT pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), '0/00000000');
 mamonsu_user@mamonsu_database ERROR:  recovery is in progress
 mamonsu_user@mamonsu_database HINT:  WAL control functions cannot be executed during recovery.

Скорее всего не проверяется условие select pg_is_in_recovery(); (возвращает true)
Может быть можно временно отключить данную метрику на уровне Zabbix?

Спасибо!

@cuprumtan cuprumtan self-assigned this Jan 23, 2023
@cuprumtan cuprumtan modified the milestones: 3.5.3, next Jan 23, 2023
@cuprumtan
Copy link
Contributor

Related issue

@roruizi2022
Copy link
Author

В последней версии все работает. Спасибо!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants