| From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg_waldump and PREPARE |
| Date: | 2019-04-25 15:36:16 |
| Message-ID: | CAHGQGwEvhASad4JJnCv=0dW2TJypZgW_Vpb-oZik2a3utCqcrA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
pg_waldump report no detail information about PREPARE TRANSACTION record,
as follows.
rmgr: Transaction len (rec/tot): 250/ 250, tx: 485,
lsn: 0/020000A8, prev 0/02000060, desc: PREPARE
I'd like to modify pg_waldump, i.e., xact_desc(), so that it reports
detail information like GID, as follows. Attached patch does that.
This would be helpful, for example, when diagnosing 2PC-related
trouble by checking the status of 2PC transaction with the specified GID.
Thought?
rmgr: Transaction len (rec/tot): 250/ 250, tx: 485,
lsn: 0/020000A8, prev 0/02000060, desc: PREPARE gid abc: 2004-06-17
05:26:27.500240 JST
I will add this to next CommitFest page.
Regards,
--
Fujii Masao
| Attachment | Content-Type | Size |
|---|---|---|
| prepare-xact-desc.patch | application/octet-stream | 7.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2019-04-25 15:53:16 | Re: TRACE_SORT defined by default |
| Previous Message | Tom Lane | 2019-04-25 15:32:21 | Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6 |