Last Modified: Nov 27, 2024
Affected Product(s):
BIG-IQ Device
Opened: Jan 09, 2023 Severity: 4-Minor Related Article:
K000134935
An error occurs while generating the Qkview. Gathering System Diagnostics: Please wait ... Loading Postgres configuration from /var/config/rest/service.config.json... Postgres configuration successfully loaded! Checking PostgreSQL availability... PostgreSQL is ready to accept connections. Performing BIG-IQ database backup to /var/tmp/storage_binary_dump/bigiq_db_dump.bin... pg_dump: Dumping the contents of table "shared_ha_sync_files_task" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: canceling statement due to conflict with recovery DETAIL: User query might have needed to see row versions that must be removed. pg_dump: The command was: COPY bigiqliveobjects.shared_ha_sync_files_task (_id, _sid, _parentid, _parenturi, generation, expiration, _module, _system_search_tags, _searchmeta, _ranges, _rbac, _eras, _value) TO stdout; Failed to execute db dump. Exit code 1
The qkview file is not generated. DB dump fails with "ERROR: canceling statement due to conflict with recover" while building/generating the Qkview.
Exact conditions that trigger this are unknown.
If you encounter this error, do the following 1. Try to regenerate qkview again or 2. Apply the workaround in https://stackoverflow.com/a/47661313 (probably not, cause running the qkview again usually fix the issue)
None