BUG #16667: COMMIT AND CHAIN does not udpates database metrics ie. xact_commit

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: axgrech(at)gmail(dot)com
Subject: BUG #16667: COMMIT AND CHAIN does not udpates database metrics ie. xact_commit
Date: 2020-10-12 13:55:20
Message-ID: 16667-f86da4a2ede6435f@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16667
Logged by: COMMIT AND CHAIN - pg_stat_database metrics are not updated
Email address: axgrech(at)gmail(dot)com
PostgreSQL version: 12.4
Operating system: RHEL 7.8
Description:

We have an application that uses a new feature COMMIT AND CHAIN, the
application works generaly OK, but we have noticed that the pg_stat_database
(xact_commit/xact_rollback) are not updated, as they are if we used
BEGIN/COMMIT/BEGIN.
according to the documentation COMMIT AND CHAIN commits current transaction
and starts a new transaction with the same characteristic as current, what
we believe should impact number of transactions reported by the database.

There is some change when we stop our application (the app is server type,
that keeps database connection open all the time), however pg_stat_number
numbers does not matches (ok, i have not checked it with details, but it
looks it does not).

As the pg_stat_database metrics (i am not sure about other metrics) are not
updated, the monitoring tools does not report any activity on the database.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2020-10-12 14:19:38 Re: BUG #16666: Slight memory leak when running pg_ctl reload
Previous Message PG Bug reporting form 2020-10-12 13:32:13 BUG #16666: Slight memory leak when running pg_ctl reload