Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

execMain.c

Blame
    • Alvaro Herrera's avatar
      f88d4cfc
      Setup error context callback for transaction lock waits · f88d4cfc
      Alvaro Herrera authored
      With this in place, a session blocking behind another one because of
      tuple locks will get a context line mentioning the relation name, tuple
      TID, and operation being done on tuple.  For example:
      
      LOG:  process 11367 still waiting for ShareLock on transaction 717 after 1000.108 ms
      DETAIL:  Process holding the lock: 11366. Wait queue: 11367.
      CONTEXT:  while updating tuple (0,2) in relation "foo"
      STATEMENT:  UPDATE foo SET value = 3;
      
      Most usefully, the new line is displayed by log entries due to
      log_lock_waits, although of course it will be printed by any other log
      message as well.
      
      Author: Christian Kruse, some tweaks by Álvaro Herrera
      Reviewed-by: Amit Kapila, Andres Freund, Tom Lane, Robert Haas
      f88d4cfc
      History
      Setup error context callback for transaction lock waits
      Alvaro Herrera authored
      With this in place, a session blocking behind another one because of
      tuple locks will get a context line mentioning the relation name, tuple
      TID, and operation being done on tuple.  For example:
      
      LOG:  process 11367 still waiting for ShareLock on transaction 717 after 1000.108 ms
      DETAIL:  Process holding the lock: 11366. Wait queue: 11367.
      CONTEXT:  while updating tuple (0,2) in relation "foo"
      STATEMENT:  UPDATE foo SET value = 3;
      
      Most usefully, the new line is displayed by log entries due to
      log_lock_waits, although of course it will be printed by any other log
      message as well.
      
      Author: Christian Kruse, some tweaks by Álvaro Herrera
      Reviewed-by: Amit Kapila, Andres Freund, Tom Lane, Robert Haas