signum-node icon indicating copy to clipboard operation
signum-node copied to clipboard

Postgres syncing error on mainnet

Open ohager opened this issue 1 year ago • 1 comments

.At block 975094 an error causes to break the sync

postgres.txt message (8).txt

by my previous experience with postgres this is most probably related to uniqueness constraints causing trouble. Need to investigate what is the reason here

ohager avatar Jan 22 '24 12:01 ohager

 org.jooq.exception.DataAccessException: SQL [insert into "at" ("id", "creator_id", "name", "description", "version", "csize", "dsize", "c_user_stack_bytes", "c_call_stack_b
ytes", "creation_height", "ap_code", "height", "ap_code_hash_id") values (-8117348957869510853, -8967851349279777535, 'Test', '                                                                                    
янв 21 18:58:04 explorer java[577504]: ', 2, 256, 256, 256, 256, 975094, E'\\037\\213\\010\\000\\000\\000\\000\\000\\000\\377\\063\\145\\140\\141\\000\\002\\106\\106\\040\\321\\060\\155\\006\\210\\315\\040\\017\
\026\\001\\142\\156\\015\\043\\156\\146\\106\\030\\017\\004\\214\\231\\300\\312\\245\\030\\206\\013\\000\\000\\144\\231\\222\\312\\000\\001\\000\\000'::bytea, 975094, -3168435119094606675)]; ОШИБКА: неверный фор
мат сообщения

ohager avatar Jan 22 '24 12:01 ohager