Skip to content

Deadlock on cron  #77

Open
Open
Deadlock on cron #77

Description

@robcxyz
robcxyz
opened on May 5, 2024
SELECT pid, age(pg_catalog.clock_timestamp(), query_start), usename, query, wait_event_type, wait_event
FROM pg_stat_activity
WHERE state = 'active' AND query LIKE '%transactions%' AND (wait_event_type IS NOT NULL OR wait_event IS NOT NULL);
545335,"ALTER TABLE ""transactions"" ALTER COLUMN ""value_decimal"" TYPE decimal",AccessExclusiveLock,relation,transactions,active
545335,"ALTER TABLE ""transactions"" ALTER COLUMN ""value_decimal"" TYPE decimal",ShareLock,relation,transactions,active
539678,"INSERT INTO ""transactions"" (""hash"",""log_index"",""type"",""method"",""from_address"",""to_address"",""block_number"",""log_count"",""version"",""value"",""value_decimal"",""step_limit"",""timestamp"",""block_timestamp"",""nid"",""nonce"",""transaction_index"",""block_hash"",""transaction_fee"",""signature"",""data_type"",""data"",""cumulative_step_used"",""step_used"",""step_price"",""score_address"",""logs_bloom"",""status"",""transaction_type"") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29) ON CONFLICT (""hash"",""log_index"") DO UPDATE SET ""hash""=""excluded"".""hash"",""log_index""=""excluded"".""log_index"",""type""=""excluded"".""type"",""method""=""excluded"".""method"",""from_address""=""excluded"".""from_address"",""to_address""=""excluded"".""to_address"",""block_number""=""excluded"".""block_number"",""log_count""=""excluded"".""log_count"",""version""=""excluded"".""version"",""value""=""excluded"".""value"",""value_decimal""=""excluded"".""value_decimal"",""step_limit""=""excluded"".""step_limit"",""timestamp""=""excluded"".""timestamp"",""block_timestamp""=""exc",RowExclusiveLock,relation,transactions,active
545405,"ALTER TABLE ""transactions"" ALTER COLUMN ""value_decimal"" TYPE decimal",ShareLock,relation,transactions,active
545406,"ALTER TABLE ""transactions"" ALTER COLUMN ""value_decimal"" TYPE decimal",ShareLock,relation,transactions,active
545418,"SELECT ""transactions"".""from_address"",""transactions"".""to_address"",""transactions"".""value"",""transactions"".""block_timestamp"",""transactions"".""hash"",""transactions"".""block_number"",""transactions"".""transaction_fee"",""transactions"".""status"",""transactions"".""type"",""transactions"".""method"",""transactions"".""value_decimal"",""transactions"".""data"",""transactions"".""transaction_type"" FROM ""transactions"" WHERE type = $1 ORDER BY block_number desc, transaction_index LIMIT 25",AccessShareLock,relation,transactions,active
539397,"INSERT INTO ""transactions"" (""hash"",""log_index"",""type"",""method"",""from_address"",""to_address"",""block_number"",""log_count"",""version"",""value"",""value_decimal"",""step_limit"",""timestamp"",""block_timestamp"",""nid"",""nonce"",""transaction_index"",""block_hash"",""transaction_fee"",""signature"",""data_type"",""data"",""cumulative_step_used"",""step_used"",""step_price"",""score_address"",""logs_bloom"",""status"",""transaction_type"") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29) ON CONFLICT (""hash"",""log_index"") DO UPDATE SET ""hash""=""excluded"".""hash"",""log_index""=""excluded"".""log_index"",""type""=""excluded"".""type"",""method""=""excluded"".""method"",""from_address""=""excluded"".""from_address"",""to_address""=""excluded"".""to_address"",""block_number""=""excluded"".""block_number"",""log_count""=""excluded"".""log_count"",""version""=""excluded"".""version"",""value""=""excluded"".""value"",""value_decimal""=""excluded"".""value_decimal"",""step_limit""=""excluded"".""step_limit"",""timestamp""=""excluded"".""timestamp"",""block_timestamp""=""exc",RowExclusiveLock,relation,transactions,active
329541,"SELECT ""transactions"".""from_address"",""transactions"".""to_address"",""transactions"".""value"",""transactions"".""block_timestamp"",""transactions"".""hash"",""transactions"".""block_number"",""transactions"".""transaction_fee"",""transactions"".""status"",""transactions"".""type"",""transactions"".""method"",""transactions"".""value_decimal"",""transactions"".""data"",""transactions"".""transaction_type"" FROM ""transactions"" WHERE type = $1 ORDER BY block_number desc, transaction_index LIMIT 25",AccessShareLock,relation,transactions,active
539859,"SELECT ""transactions"".""from_address"",""transactions"".""to_address"",""transactions"".""value"",""transactions"".""block_timestamp"",""transactions"".""hash"",""transactions"".""block_number"",""transactions"".""transaction_fee"",""transactions"".""status"",""transactions"".""type"",""transactions"".""method"",""transactions"".""value_decimal"",""transactions"".""data"",""transactions"".""transaction_type"" FROM ""transactions"" WHERE type = $1 ORDER BY block_number desc, transaction_index LIMIT 25",AccessShareLock,relation,transactions,active
539678,"INSERT INTO ""transactions"" (""hash"",""log_index"",""type"",""method"",""from_address"",""to_address"",""block_number"",""log_count"",""version"",""value"",""value_decimal"",""step_limit"",""timestamp"",""block_timestamp"",""nid"",""nonce"",""transaction_index"",""block_hash"",""transaction_fee"",""signature"",""data_type"",""data"",""cumulative_step_used"",""step_used"",""step_price"",""score_address"",""logs_bloom"",""status"",""transaction_type"") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29),($30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58) ON CONFLICT (""hash"",""log_index"") DO UPDATE SET ""hash""=""excluded"".""hash"",""log_index""=""excluded"".""log_index"",""type""=""excluded"".""type"",""method""=""excluded"".""method"",""from_address""=""excluded"".""from_address"",""to_address""=""excluded"".""to_address"",""block_number""=""excluded"".""block_number"",""log_count""=""excluded"".""log_count"",""version""=""excluded"".""version"",""value""=""excluded"".""value"",""value_decimal""=""ex",RowExclusiveLock,relation,transactions,active
545476,"INSERT INTO ""transactions"" (""hash"",""log_index"",""type"",""method"",""from_address"",""to_address"",""block_number"",""log_count"",""version"",""value"",""value_decimal"",""step_limit"",""timestamp"",""block_timestamp"",""nid"",""nonce"",""transaction_index"",""block_hash"",""transaction_fee"",""signature"",""data_type"",""data"",""cumulative_step_used"",""step_used"",""step_price"",""score_address"",""logs_bloom"",""status"",""transaction_type"") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29) ON CONFLICT (""hash"",""log_index"") DO UPDATE SET ""hash""=""excluded"".""hash"",""log_index""=""excluded"".""log_index"",""type""=""excluded"".""type"",""method""=""excluded"".""method"",""from_address""=""excluded"".""from_address"",""to_address""=""excluded"".""to_address"",""block_number""=""excluded"".""block_number"",""log_count""=""excluded"".""log_count"",""version""=""excluded"".""version"",""value""=""excluded"".""value"",""value_decimal""=""excluded"".""value_decimal"",""step_limit""=""excluded"".""step_limit"",""timestamp""=""excluded"".""timestamp"",""block_timestamp""=""exc",RowExclusiveLock,relation,transactions,active
545480,"ALTER TABLE ""transactions"" ALTER COLUMN ""block_number"" TYPE bigint",AccessExclusiveLock,relation,transactions,active
545480,"ALTER TABLE ""transactions"" ALTER COLUMN ""block_number"" TYPE bigint",ShareLock,relation,transactions,active
329514,"SELECT ""transactions"".""from_address"",""transactions"".""to_address"",""transactions"".""value"",""transactions"".""block_timestamp"",""transactions"".""hash"",""transactions"".""block_number"",""transactions"".""transaction_fee"",""transactions"".""status"",""transactions"".""type"",""transactions"".""method"",""transactions"".""value_decimal"",""transactions"".""data"",""transactions"".""transaction_type"" FROM ""transactions"" WHERE type = $1 ORDER BY block_number desc, transaction_index LIMIT 25",AccessShareLock,relation,transactions,active
545418,"SELECT ""transactions"".""from_address"",""transactions"".""to_address"",""transactions"".""value"",""transactions"".""block_timestamp"",""transactions"".""hash"",""transactions"".""block_number"",""transactions"".""transaction_fee"",""transactions"".""status"",""transactions"".""type"",""transactions"".""method"",""transactions"".""value_decimal"",""transactions"".""data"",""transactions"".""transaction_type"" FROM ""transactions"" WHERE type = $1 ORDER BY block_number desc, transaction_index LIMIT 25",AccessShareLock,relation,transactions,active
545481,"ALTER TABLE ""transactions"" ALTER COLUMN ""block_number"" TYPE bigint",ShareLock,relation,transactions,active
545482,"ALTER TABLE ""transactions"" ALTER COLUMN ""block_number"" TYPE bigint",ShareLock,relation,transactions,active

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions