Hello!
We have found several “ROLLBACK” statements in the postgresql.log
on all nodes in the cluster.
Example:
2024-09-27 00:22:01 UTC pid=[21967][5] db=[DataBaseName] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[21967][11] db=[DataBaseName] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[21973][5] db=[DataBaseNameX] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[21973][11] db=[DataBaseNameX] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[21974][5] db=[postgres] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[21974][11] db=[postgres] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[21974][15] db=[postgres] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[21967][15] db=[DataBaseName] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[22007][5] db=[DataBaseName] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
2024-09-27 00:22:01 UTC pid=[22007][11] db=[DataBaseName] usr=[netdata] client=[localhost] app=[[unknown]] LOG: statement: ROLLBACK
We have checked permissions and the overall configuration, and everything seems to be in order.
Do you know if this is expected behavior, or could it be a misconfiguration?
Thanks for your help,
Richard Barrantes