Re: [ADMIN] how to find transaction associated with a lock - Mailing list pgsql-general
| From | Si Chen |
|---|---|
| Subject | Re: [ADMIN] how to find transaction associated with a lock |
| Date | |
| Msg-id | 4105336E.4030604@graciousstyle.com Whole thread Raw |
| In response to | Re: [ADMIN] how to find transaction associated with a lock (Tom Lane <tgl@sss.pgh.pa.us>) |
| Responses |
Re: [ADMIN] how to find transaction associated with a lock
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-general |
Hi Tom, Thanks for your help last week. I had the problem again where things got hung up during a transaction, and it was at the order_header table. Here is what the pg_locks show. Does it confirm what you are saying, which is that multiple transactions have tried to insert into this table? Thanks, Si > > pid | datname | relname | mode -------+---------------+-----------------------------+------------------ 9861 | graciousstyle | billing_account | AccessShareLock 9862 | graciousstyle | billing_account | AccessShareLock 9931 | graciousstyle | billing_account | AccessShareLock 9932 | graciousstyle | billing_account | AccessShareLock 10060 | graciousstyle | billing_account | AccessShareLock 9862 | graciousstyle | carrier_shipment_method | AccessShareLock 9861 | graciousstyle | contact_mech | AccessShareLock 9862 | graciousstyle | contact_mech | AccessShareLock 9931 | graciousstyle | contact_mech | AccessShareLock 9932 | graciousstyle | contact_mech | AccessShareLock 10060 | graciousstyle | contact_mech | AccessShareLock 9861 | graciousstyle | credit_card | AccessShareLock 9931 | graciousstyle | credit_card | AccessShareLock 9932 | graciousstyle | credit_card | AccessShareLock 10060 | graciousstyle | credit_card | AccessShareLock 9862 | graciousstyle | entity_sync_remove | AccessShareLock 9862 | graciousstyle | entity_sync_remove | RowExclusiveLock 9862 | graciousstyle | facility | AccessShareLock 9862 | graciousstyle | facility | RowShareLock 9862 | graciousstyle | geo | AccessShareLock 9862 | graciousstyle | inventory_item | AccessShareLock 9862 | graciousstyle | inventory_item | RowExclusiveLock 9862 | graciousstyle | inventory_item_type | AccessShareLock 9862 | graciousstyle | inventory_item_type | RowShareLock 9861 | graciousstyle | item_issuance | AccessShareLock 9862 | graciousstyle | item_issuance | AccessShareLock 9931 | graciousstyle | item_issuance | AccessShareLock 9932 | graciousstyle | item_issuance | AccessShareLock 10060 | graciousstyle | item_issuance | AccessShareLock 9861 | graciousstyle | order_adjustment | AccessShareLock 9862 | graciousstyle | order_adjustment | AccessShareLock 9931 | graciousstyle | order_adjustment | AccessShareLock 9932 | graciousstyle | order_adjustment | AccessShareLock 9935 | graciousstyle | order_adjustment | AccessShareLock 10060 | graciousstyle | order_adjustment | AccessShareLock 9862 | graciousstyle | order_adjustment | RowExclusiveLock 9862 | graciousstyle | order_adjustment | RowShareLock 9862 | graciousstyle | order_adjustment_attribute | AccessShareLock 9862 | graciousstyle | order_adjustment_attribute | RowShareLock 9861 | graciousstyle | order_adjustment_type | AccessShareLock 9862 | graciousstyle | order_adjustment_type | AccessShareLock 9931 | graciousstyle | order_adjustment_type | AccessShareLock 9932 | graciousstyle | order_adjustment_type | AccessShareLock 10060 | graciousstyle | order_adjustment_type | AccessShareLock 9862 | graciousstyle | order_adjustment_type | RowShareLock 9861 | graciousstyle | order_contact_mech | AccessShareLock 9862 | graciousstyle | order_contact_mech | AccessShareLock 9931 | graciousstyle | order_contact_mech | AccessShareLock 9932 | graciousstyle | order_contact_mech | AccessShareLock 10060 | graciousstyle | order_contact_mech | AccessShareLock 9861 | graciousstyle | order_header | AccessShareLock 9862 | graciousstyle | order_header | AccessShareLock 9931 | graciousstyle | order_header | AccessShareLock 9932 | graciousstyle | order_header | AccessShareLock 9935 | graciousstyle | order_header | AccessShareLock 10060 | graciousstyle | order_header | AccessShareLock 27874 | graciousstyle | order_header | AccessShareLock 9862 | graciousstyle | order_header | RowExclusiveLock 9935 | graciousstyle | order_header | RowExclusiveLock 27874 | graciousstyle | order_header | RowExclusiveLock 9861 | graciousstyle | order_header | RowShareLock 9862 | graciousstyle | order_header | RowShareLock 9931 | graciousstyle | order_header | RowShareLock 9932 | graciousstyle | order_header | RowShareLock 10060 | graciousstyle | order_header | RowShareLock 9861 | graciousstyle | order_item | AccessShareLock 9862 | graciousstyle | order_item | AccessShareLock 9931 | graciousstyle | order_item | AccessShareLock 9932 | graciousstyle | order_item | AccessShareLock 9935 | graciousstyle | order_item | AccessShareLock 10060 | graciousstyle | order_item | AccessShareLock 9862 | graciousstyle | order_item | RowExclusiveLock 9862 | graciousstyle | order_item_inventory_res | AccessShareLock 9862 | graciousstyle | order_item_inventory_res | RowExclusiveLock 9862 | graciousstyle | order_item_type | AccessShareLock 9862 | graciousstyle | order_item_type | RowShareLock 9861 | graciousstyle | order_notification | AccessShareLock 9931 | graciousstyle | order_notification | AccessShareLock 9932 | graciousstyle | order_notification | AccessShareLock 10060 | graciousstyle | order_notification | AccessShareLock 9861 | graciousstyle | order_notification | RowExclusiveLock 9931 | graciousstyle | order_notification | RowExclusiveLock 9932 | graciousstyle | order_notification | RowExclusiveLock 10060 | graciousstyle | order_notification | RowExclusiveLock 9861 | graciousstyle | order_payment_preference | AccessShareLock 9862 | graciousstyle | order_payment_preference | AccessShareLock 9931 | graciousstyle | order_payment_preference | AccessShareLock 9932 | graciousstyle | order_payment_preference | AccessShareLock 10060 | graciousstyle | order_payment_preference | AccessShareLock 9861 | graciousstyle | order_role | AccessShareLock 9862 | graciousstyle | order_role | AccessShareLock 9931 | graciousstyle | order_role | AccessShareLock 9932 | graciousstyle | order_role | AccessShareLock 10060 | graciousstyle | order_role | AccessShareLock 9861 | graciousstyle | order_shipment_preference | AccessShareLock 9862 | graciousstyle | order_shipment_preference | AccessShareLock 9931 | graciousstyle | order_shipment_preference | AccessShareLock 9932 | graciousstyle | order_shipment_preference | AccessShareLock 10060 | graciousstyle | order_shipment_preference | AccessShareLock 9861 | graciousstyle | order_status | AccessShareLock 9862 | graciousstyle | order_status | AccessShareLock 9931 | graciousstyle | order_status | AccessShareLock 9932 | graciousstyle | order_status | AccessShareLock 10060 | graciousstyle | order_status | AccessShareLock 9862 | graciousstyle | order_status | RowExclusiveLock 9862 | graciousstyle | order_type | AccessShareLock 27874 | graciousstyle | order_type | AccessShareLock 9862 | graciousstyle | order_type | RowShareLock 27874 | graciousstyle | order_type | RowShareLock 9861 | graciousstyle | payment_method | AccessShareLock 9862 | graciousstyle | payment_method | AccessShareLock 9931 | graciousstyle | payment_method | AccessShareLock 9932 | graciousstyle | payment_method | AccessShareLock 10060 | graciousstyle | payment_method | AccessShareLock 9861 | graciousstyle | person | AccessShareLock 9862 | graciousstyle | person | AccessShareLock 9931 | graciousstyle | person | AccessShareLock 9932 | graciousstyle | person | AccessShareLock 10060 | graciousstyle | person | AccessShareLock 28124 | graciousstyle | pg_class | AccessShareLock 28124 | graciousstyle | pg_class_oid_index | AccessShareLock 28124 | graciousstyle | pg_locks | AccessShareLock 9861 | graciousstyle | pk_order_header | AccessShareLock 9931 | graciousstyle | pk_order_header | AccessShareLock 9932 | graciousstyle | pk_order_header | AccessShareLock 9935 | graciousstyle | pk_order_header | AccessShareLock 10060 | graciousstyle | pk_order_header | AccessShareLock 9861 | graciousstyle | postal_address | AccessShareLock 9862 | graciousstyle | postal_address | AccessShareLock 9931 | graciousstyle | postal_address | AccessShareLock 9932 | graciousstyle | postal_address | AccessShareLock 10060 | graciousstyle | postal_address | AccessShareLock 9862 | graciousstyle | product | AccessShareLock 9862 | graciousstyle | product | RowShareLock 9862 | graciousstyle | product_assoc | AccessShareLock 9862 | graciousstyle | product_feature_appl | AccessShareLock 9861 | graciousstyle | product_store_email_setting | AccessShareLock 9862 | graciousstyle | product_store_email_setting | AccessShareLock 9931 | graciousstyle | product_store_email_setting | AccessShareLock 9932 | graciousstyle | product_store_email_setting | AccessShareLock 10060 | graciousstyle | product_store_email_setting | AccessShareLock 9862 | graciousstyle | quantity_break | AccessShareLock 9862 | graciousstyle | security_group_permission | AccessShareLock 9862 | graciousstyle | shipment_cost_estimate | AccessShareLock 9861 | graciousstyle | shipment_method_type | AccessShareLock 9862 | graciousstyle | shipment_method_type | AccessShareLock 9931 | graciousstyle | shipment_method_type | AccessShareLock 9932 | graciousstyle | shipment_method_type | AccessShareLock 10060 | graciousstyle | shipment_method_type | AccessShareLock 9861 | graciousstyle | shipment_package_route_seg | AccessShareLock 9862 | graciousstyle | shipment_package_route_seg | AccessShareLock 9931 | graciousstyle | shipment_package_route_seg | AccessShareLock 9932 | graciousstyle | shipment_package_route_seg | AccessShareLock 10060 | graciousstyle | shipment_package_route_seg | AccessShareLock 9861 | graciousstyle | shipment_route_segment | AccessShareLock 9862 | graciousstyle | shipment_route_segment | AccessShareLock 9931 | graciousstyle | shipment_route_segment | AccessShareLock 9932 | graciousstyle | shipment_route_segment | AccessShareLock 10060 | graciousstyle | shipment_route_segment | AccessShareLock 9862 | graciousstyle | simple_sales_tax_lookup | AccessShareLock 9862 | graciousstyle | status_item | AccessShareLock 9931 | graciousstyle | status_item | AccessShareLock 9932 | graciousstyle | status_item | AccessShareLock 9862 | graciousstyle | status_item | RowShareLock 9862 | graciousstyle | status_valid_change | AccessShareLock 9862 | graciousstyle | user_login | AccessShareLock 27874 | graciousstyle | user_login | AccessShareLock 9862 | graciousstyle | user_login_security_group | AccessShareLock 9862 | graciousstyle | work_effort | AccessShareLock (169 rows)
pgsql-general by date: