Advertisement
nubooya

Untitled

Jan 1st, 2023
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.35 KB | None | 0 0
  1. {
  2. "code": "40P01",
  3. "detail": "Process 8528 waits for ShareLock on transaction 2099276; blocked by process 8597.\nProcess 8597 waits for ShareLock on transaction 2099275; blocked by process 8528.",
  4. "file": "deadlock.c",
  5. "hint": "See server log for query details.",
  6. "length": 345,
  7. "line": "1146",
  8. "name": "error",
  9. "originalStack": "error: insert into \"catalogs_mccp\" (\"book_type_id\", \"catalog_authors\", \"catalog_avg_rating\", \"catalog_copyright\", \"catalog_cover\", \"catalog_cover_original\", \"catalog_description\", \"catalog_dimention\", \"catalog_eavissn\", \"catalog_edition\", \"catalog_eisbn\", \"catalog_eissn\", \"catalog_epublish_date\", \"catalog_file\", \"catalog_file_ext\", \"catalog_file_moco\", \"catalog_file_size\", \"catalog_file_size_info\", \"catalog_file_version\", \"catalog_info\", \"catalog_isbn\", \"catalog_isdrm\", \"catalog_isfree\", \"catalog_language\", \"catalog_link\", \"catalog_notes\", \"catalog_pages\", \"catalog_parent\", \"catalog_price\", \"catalog_publish_city\", \"catalog_publish_date\", \"catalog_result_object\", \"catalog_series\", \"catalog_sku\", \"catalog_source_product\", \"catalog_status\", \"catalog_sub_title\", \"catalog_target_market\", \"catalog_title\", \"catalog_unpublish_date\", \"catalog_volume\", \"category_id\", \"content_id\", \"content_media_id\", \"created_at\", \"created_by\", \"ddc_id\", \"deleted_at\", \"edu_level_id\", \"id\", \"organization_id\", \"sub_category\", \"updated_at\", \"updated_by\") 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) on conflict (\"id\") do update set \"book_type_id\" = excluded.\"book_type_id\", \"catalog_authors\" = excluded.\"catalog_authors\", \"catalog_avg_rating\" = excluded.\"catalog_avg_rating\", \"catalog_copyright\" = excluded.\"catalog_copyright\", \"catalog_cover\" = excluded.\"catalog_cover\", \"catalog_cover_original\" = excluded.\"catalog_cover_original\", \"catalog_description\" = excluded.\"catalog_description\", \"catalog_dimention\" = excluded.\"catalog_dimention\", \"catalog_eavissn\" = excluded.\"catalog_eavissn\", \"catalog_edition\" = excluded.\"catalog_edition\", \"catalog_eisbn\" = excluded.\"catalog_eisbn\", \"catalog_eissn\" = excluded.\"catalog_eissn\", \"catalog_epublish_date\" = excluded.\"catalog_epublish_date\", \"catalog_file\" = excluded.\"catalog_file\", \"catalog_file_ext\" = excluded.\"catalog_file_ext\", \"catalog_file_moco\" = excluded.\"catalog_file_moco\", \"catalog_file_size\" = excluded.\"catalog_file_size\", \"catalog_file_size_info\" = excluded.\"catalog_file_size_info\", \"catalog_file_version\" = excluded.\"catalog_file_version\", \"catalog_info\" = excluded.\"catalog_info\", \"catalog_isbn\" = excluded.\"catalog_isbn\", \"catalog_isdrm\" = excluded.\"catalog_isdrm\", \"catalog_isfree\" = excluded.\"catalog_isfree\", \"catalog_language\" = excluded.\"catalog_language\", \"catalog_link\" = excluded.\"catalog_link\", \"catalog_notes\" = excluded.\"catalog_notes\", \"catalog_pages\" = excluded.\"catalog_pages\", \"catalog_parent\" = excluded.\"catalog_parent\", \"catalog_price\" = excluded.\"catalog_price\", \"catalog_publish_city\" = excluded.\"catalog_publish_city\", \"catalog_publish_date\" = excluded.\"catalog_publish_date\", \"catalog_result_object\" = excluded.\"catalog_result_object\", \"catalog_series\" = excluded.\"catalog_series\", \"catalog_sku\" = excluded.\"catalog_sku\", \"catalog_source_product\" = excluded.\"catalog_source_product\", \"catalog_status\" = excluded.\"catalog_status\", \"catalog_sub_title\" = excluded.\"catalog_sub_title\", \"catalog_target_market\" = excluded.\"catalog_target_market\", \"catalog_title\" = excluded.\"catalog_title\", \"catalog_unpublish_date\" = excluded.\"catalog_unpublish_date\", \"catalog_volume\" = excluded.\"catalog_volume\", \"category_id\" = excluded.\"category_id\", \"content_id\" = excluded.\"content_id\", \"content_media_id\" = excluded.\"content_media_id\", \"created_at\" = excluded.\"created_at\", \"created_by\" = excluded.\"created_by\", \"ddc_id\" = excluded.\"ddc_id\", \"deleted_at\" = excluded.\"deleted_at\", \"edu_level_id\" = excluded.\"edu_level_id\", \"id\" = excluded.\"id\", \"organization_id\" = excluded.\"organization_id\", \"sub_category\" = excluded.\"sub_category\", \"updated_at\" = excluded.\"updated_at\", \"updated_by\" = excluded.\"updated_by\" - deadlock detected\n at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:287:98)\n at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:126:29)\n at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:39:38)\n at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)\n at Socket.emit (events.js:400:28)\n at Socket.emit (domain.js:475:12)\n at addChunk (internal/streams/readable.js:293:12)\n at readableAddChunk (internal/streams/readable.js:267:9)\n at Socket.Readable.push (internal/streams/readable.js:206:10)\n at TCP.onStreamRead (internal/stream_base_commons.js:188:23)\n at TCP.callbackTrampoline (internal/async_hooks.js:130:17)",
  10. "routine": "DeadLockReport",
  11. "severity": "ERROR",
  12. "where": "while inserting index tuple (3137,1) in relation \"catalogs_mccp\""
  13. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement