ROLLBACK statements found on postgresql.log

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

1 Like