search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.9k stars 1.06k forks source link

[YSQL] Enable logging of failed transactions in postgres #20825

Open robertsami opened 8 months ago

robertsami commented 8 months ago

Jira Link: DB-9814

Description

Requirements:

  1. Log failed statements in pg logs
  2. Include transaction id

Can be configured by flag

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

robertsami commented 8 months ago

Needed to debug https://github.com/yugabyte/yugabyte-db/issues/20761

rthallamko3 commented 7 months ago

@robertsami , ysql_pg_conf_csv with "log_statement='all';" can log all the statements. Is that sufficient? cc @pkj415 , @IshanChhangani .