bug(cnpg): huge parameterized inserts #1046

New issue

Closed

opened 2026-03-28 04:31:09 +00:00 by mfreeman451 · 1 comment

mfreeman451 commented

2026-03-28 04:31:09 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #2882
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2882
Original created: 2026-02-21T07:15:14Z

Describe the bug
Theres gotta be a better way to do this:

postgres {"level":"info","ts":"2026-02-21T07:13:20.448816436Z","logger":"postgres","msg":"record","logging_pod":"cnpg-2","record":{"log_time":"2026-02-21 07:13:20.448 UTC","user_name":"serviceradar","database_name":"serviceradar","process_id":"154","connection_from":"10.42.221.108:38342","session_id":"69995ae9.9a","session_line_num":"2","command_tag":"INSERT","session_start_time":"2026-02-21 07:12:41 UTC","virtual_transaction_id":"16/13","transaction_id":"17955150","error_severity":"ERROR","sql_state_code":"XX002","message":"right sibling's left-link doesn't match: block 9731 links to 9732 instead of expected 1 in index \"_hyper_10_90_chunk_process_metrics_timestamp_idx\"","query":"INSERT INTO \"platform\".\"process_metrics\" (\"name\",\"pid\",\"status\"
,\"timestamp\",\"partition\",\"start_time\",\"created_at\",\"host_id\",\"memory_usage\",\"device_id\",\"agent_id\",\"gateway_id\",\"cpu_usage\") 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,$59,$60,$61,$62,$63,$64,$65),($66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78),($79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91),($92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104),($105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117),($118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130),($131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143),($144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156),($157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169),($170,$171,$172,$173,$174,$175,$176,$177
,$178,$179,$180,$181,$182),($183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195),($196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208),($209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221),($222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234),($235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247),($248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260),($261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273),($274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286),($287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299),($300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312),($313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325),($326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338),($339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351),($352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

Imported from GitHub. Original GitHub issue: #2882 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2882 Original created: 2026-02-21T07:15:14Z --- **Describe the bug** Theres gotta be a better way to do this: ``` postgres {"level":"info","ts":"2026-02-21T07:13:20.448816436Z","logger":"postgres","msg":"record","logging_pod":"cnpg-2","record":{"log_time":"2026-02-21 07:13:20.448 UTC","user_name":"serviceradar","database_name":"serviceradar","process_id":"154","connection_from":"10.42.221.108:38342","session_id":"69995ae9.9a","session_line_num":"2","command_tag":"INSERT","session_start_time":"2026-02-21 07:12:41 UTC","virtual_transaction_id":"16/13","transaction_id":"17955150","error_severity":"ERROR","sql_state_code":"XX002","message":"right sibling's left-link doesn't match: block 9731 links to 9732 instead of expected 1 in index \"_hyper_10_90_chunk_process_metrics_timestamp_idx\"","query":"INSERT INTO \"platform\".\"process_metrics\" (\"name\",\"pid\",\"status\" ,\"timestamp\",\"partition\",\"start_time\",\"created_at\",\"host_id\",\"memory_usage\",\"device_id\",\"agent_id\",\"gateway_id\",\"cpu_usage\") 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,$59,$60,$61,$62,$63,$64,$65),($66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78),($79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90,$91),($92,$93,$94,$95,$96,$97,$98,$99,$100,$101,$102,$103,$104),($105,$106,$107,$108,$109,$110,$111,$112,$113,$114,$115,$116,$117),($118,$119,$120,$121,$122,$123,$124,$125,$126,$127,$128,$129,$130),($131,$132,$133,$134,$135,$136,$137,$138,$139,$140,$141,$142,$143),($144,$145,$146,$147,$148,$149,$150,$151,$152,$153,$154,$155,$156),($157,$158,$159,$160,$161,$162,$163,$164,$165,$166,$167,$168,$169),($170,$171,$172,$173,$174,$175,$176,$177 ,$178,$179,$180,$181,$182),($183,$184,$185,$186,$187,$188,$189,$190,$191,$192,$193,$194,$195),($196,$197,$198,$199,$200,$201,$202,$203,$204,$205,$206,$207,$208),($209,$210,$211,$212,$213,$214,$215,$216,$217,$218,$219,$220,$221),($222,$223,$224,$225,$226,$227,$228,$229,$230,$231,$232,$233,$234),($235,$236,$237,$238,$239,$240,$241,$242,$243,$244,$245,$246,$247),($248,$249,$250,$251,$252,$253,$254,$255,$256,$257,$258,$259,$260),($261,$262,$263,$264,$265,$266,$267,$268,$269,$270,$271,$272,$273),($274,$275,$276,$277,$278,$279,$280,$281,$282,$283,$284,$285,$286),($287,$288,$289,$290,$291,$292,$293,$294,$295,$296,$297,$298,$299),($300,$301,$302,$303,$304,$305,$306,$307,$308,$309,$310,$311,$312),($313,$314,$315,$316,$317,$318,$319,$320,$321,$322,$323,$324,$325),($326,$327,$328,$329,$330,$331,$332,$333,$334,$335,$336,$337,$338),($339,$340,$341,$342,$343,$344,$345,$346,$347,$348,$349,$350,$351),($352,$353,$354,$355,$356,$357,$358,$359,$360,$361,$362,$ ``` **To Reproduce** Steps to reproduce the behavior: 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. See error **Expected behavior** A clear and concise description of what you expected to happen. **Screenshots** If applicable, add screenshots to help explain your problem. **Desktop (please complete the following information):** - OS: [e.g. iOS] - Browser [e.g. chrome, safari] - Version [e.g. 22] **Smartphone (please complete the following information):** - Device: [e.g. iPhone6] - OS: [e.g. iOS8.1] - Browser [e.g. stock browser, safari] - Version [e.g. 22] **Additional context** Add any other context about the problem here.

mfreeman451 commented

2026-03-28 04:31:09 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2882#issuecomment-4145543340
Original created: 2026-03-27T21:49:58Z

closing, stale

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2882#issuecomment-4145543340 Original created: 2026-03-27T21:49:58Z --- closing, stale