Deadlock on cron

[robcxyz]

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