what causes xact_rollback for a database in pg_stat_database to increment?

From: "Hu, Patricia" <Patricia(dot)Hu(at)finra(dot)org>
To: "pgsql general (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org>
Subject: what causes xact_rollback for a database in pg_stat_database to increment?
Date: 2019-12-04 20:48:38
Message-ID: DM6PR10MB3500FA1E35234FE668127DF9FA5D0@DM6PR10MB3500.namprd10.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We've been seeing over 200k rollbacks being recorded for a database at certain hour overnight but can't see the corresponding ROLLBACK statements being recorded in postgresql db logs, even though our log_statement is set to ALL.

I did some tests and confirmed that xact_rollback count increments in scenarios below and am looking further at those.

1. a ROLLBACK is issued explicitly or implicitly(if a transaction or pl/pgsql block/function raises an exception or was aborted)

2. it doesn't reflect the number of records being rolled back

3. even if ROLLBACK statement results in WARNING like "there is no transaction in progress", it increments

Does anyone know on top of his/her head any (other) explanation for such unaccounted for rollbacks?

Thanks,
Patricia

Confidentiality Notice:: This email, including attachments, may include non-public, proprietary, confidential or legally privileged information. If you are not an intended recipient or an authorized agent of an intended recipient, you are hereby notified that any dissemination, distribution or copying of the information contained in or transmitted with this e-mail is unauthorized and strictly prohibited. If you have received this email in error, please notify the sender by replying to this message and permanently delete this e-mail, its attachments, and any copies of it immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2019-12-04 22:15:43 Re: what causes xact_rollback for a database in pg_stat_database to increment?
Previous Message Stephen Frost 2019-12-04 17:56:18 Re: archiving question