Skip to content

Instantly share code, notes, and snippets.

@kuma-ir

kuma-ir/db-deadlock.log

Created May 7, 2025 13:15
Show Gist options
  • Save kuma-ir/3a535e3b3b93800c18ea29bb02e2673f to your computer and use it in GitHub Desktop.
Save kuma-ir/3a535e3b3b93800c18ea29bb02e2673f to your computer and use it in GitHub Desktop.
Download ZIP
db deadlock
Raw
db-deadlock.log
=== RUN TestCollector_RunVMAndPartner
collector_test.go:272: address1: 0x52FDfc072182654f163F5F0f9A621D729566c74D
collector_test.go:274: address2Whitelisted: 0x2f8282CBe2F9696f3144c0Aa4CED56DBD967dc28
collector_test.go:276: address3Blacklisted: 0x85FbE72b6064289004A531f967898dF5319eE029
collector_test.go:278: address4: 0xE2807d9C1dcE26aF00ca81d4Fe11C23E8EB6752e
collector_test.go:284: addressPartner1Operator1: 0xf3ff4D451E429e182215aAEe06A2D64B6D1aADC9
collector_test.go:286: addressPartner1Operator2: 0x5079832Da0A39e4f1cD6fdFc633C0fA6D58F41C0
collector_test.go:288: addressPartner2Operator1: 0xA6fE18955D8177702fc91d5829f4464fEef626ab
{"l":"info","m":"running points program VM data collector","t":"2025-05-07T13:11:07.387650293Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:27"}
{"l":"info","m":"fetching points multipliers","t":"2025-05-07T13:11:07.387754369Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:88"}
{"l":"debug","t":"2025-05-07T13:11:07.38784483Z","ln":"model/points.go:818","m":"GetLatestPointsMultipliers: executing query"}
{"l":"warn","t":"2025-05-07T13:11:07.389835853Z","ln":"model/points.go:855","m":"GetLatestPointsMultipliers: no multipliers found"}
{"l":"info","db_write_timestamp":"0001-01-01T00:00:00Z","last_updated_timestamp":"0001-01-01T00:00:00Z","m":"multiplier values identical to latest in database, not writing","t":"2025-05-07T13:11:07.38999321Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:100"}
{"l":"info","m":"fetching last history timestamp","t":"2025-05-07T13:11:07.390051319Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:33"}
{"l":"info","last":-62135596800,"m":"last history timestamp","t":"2025-05-07T13:11:07.391058949Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:43"}
{"l":"info","maxSnapshots":1,"m":"fetching next snapshot times","t":"2025-05-07T13:11:07.391150361Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:45"}
{"l":"info","snapshot_times":["1745302271","1745306542"],"m":"next snapshot times","t":"2025-05-07T13:11:07.391289113Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:50"}
{"l":"info","snapshot_time":1745302271,"m":"fetching snapshot data","t":"2025-05-07T13:11:07.391373662Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:64"}
{"l":"info","snapshot_time":1745302271,"size":2,"m":"fetched snapshot","t":"2025-05-07T13:11:07.391453613Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:69"}
{"l":"debug","t":"2025-05-07T13:11:07.391515359Z","ln":"service/db.go:14","m":"executing code in transaction"}
{"l":"info","size":2,"m":"inserting snapshot data","t":"2025-05-07T13:11:07.391920934Z","ln":"log/zerolog.go:182","ln":"points/vm_collector.go:127"}
{"l":"debug","t":"2025-05-07T13:11:07.392915799Z","ln":"model/points.go:713","m":"inserted snapshot timestamp: '1745302271'"}
{"l":"info","size":2,"m":"Scaling snapshot data","t":"2025-05-07T13:11:07.393019414Z","ln":"log/zerolog.go:182","ln":"points/collector.go:104"}
{"l":"info","spent":"139.563µs","m":"Scaled snapshot computed","t":"2025-05-07T13:11:07.393156693Z","ln":"log/zerolog.go:182","ln":"points/collector.go:130"}
{"l":"error","stack":"goroutine 76 [running]:\nruntime/debug.Stack()\n\t/usr/lib/golang/src/runtime/debug/stack.go:26 +0x67\ngithub.com/infrared-dao/backend/internal/service.DoInTx({0x132d778, 0xc000002070}, 0xc0004b5d40, 0xc0006d4280)\n\t/home/kuma/go/src/github.com/infrared-dao/backend/internal/service/db.go:35 +0x377\ngithub.com/infrared-dao/backend/internal/sulaco/service/points.(*Collector).RunVM(0xc0000f4320, {0x132d778, 0xc000002070})\n\t/home/kuma/go/src/github.com/infrared-dao/backend/internal/sulaco/service/points/vm_collector.go:77 +0x1045\ngithub.com/infrared-dao/backend/internal/sulaco/service/points_test.TestCollector_RunVMAndPartner(0xc0000ed1e0)\n\t/home/kuma/go/src/github.com/infrared-dao/backend/internal/sulaco/service/points/collector_test.go:422 +0x33f7\ntesting.tRunner(0xc0000ed1e0, 0x103c1c8)\n\t/usr/lib/golang/src/testing/testing.go:1690 +0x227\ncreated by testing.(*T).Run in goroutine 1\n\t/usr/lib/golang/src/testing/testing.go:1743 +0x826\n","t":"2025-05-07T13:11:08.397139016Z","ln":"service/db.go:35","m":"execution failure, err: failed to ensure partition sulaco.points_data_20250422: pq: deadlock detected"}
collector_test.go:422:
Error Trace: /home/kuma/go/src/github.com/infrared-dao/backend/internal/sulaco/service/points/collector_test.go:422
Error: Received unexpected error:
execution failure, err: failed to ensure partition sulaco.points_data_20250422: pq: deadlock detected
error updating database for snapshot "2025-04-22 06:11:11 +0000 UTC"
github.com/infrared-dao/backend/system/errors.Wrapf
/home/kuma/go/src/github.com/infrared-dao/backend/system/errors/error.go:24
github.com/infrared-dao/backend/internal/sulaco/service/points.(*Collector).RunVM
/home/kuma/go/src/github.com/infrared-dao/backend/internal/sulaco/service/points/vm_collector.go:80
github.com/infrared-dao/backend/internal/sulaco/service/points_test.TestCollector_RunVMAndPartner
/home/kuma/go/src/github.com/infrared-dao/backend/internal/sulaco/service/points/collector_test.go:422
testing.tRunner
/usr/lib/golang/src/testing/testing.go:1690
runtime.goexit
/usr/lib/golang/src/runtime/asm_amd64.s:1700
Test: TestCollector_RunVMAndPartner
controller.go:269: missing call(s) to *points_test.MockVMPointsClient.FetchSnapshotForTime(is anything, is equal to 1745306542 (string)) /home/kuma/go/src/github.com/infrared-dao/backend/internal/sulaco/service/points/collector_test.go:420
controller.go:269: aborting test due to missing call(s)
--- FAIL: TestCollector_RunVMAndPartner (1.20s)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment