Skip to content

Instantly share code, notes, and snippets.

@Nazgolze
Last active June 6, 2018 08:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Nazgolze/1e7a64efd700186aa927f5b3b6138745 to your computer and use it in GitHub Desktop.
Save Nazgolze/1e7a64efd700186aa927f5b3b6138745 to your computer and use it in GitHub Desktop.
Database Insert Errors
ERROR: integer out of range
STATEMENT: INSERT INTO “trs”(“id”,”blockId”,”type”,”timestamp”,”senderPublicKey”,”requesterPublicKey”,”senderId”,”recipientId”,”amount”,”fee”,”signature”,”signSignature”,”signatures”) VALUES (‘181175095785369468’,’5488578331239914243',0,-3704634000,’\x6dd24c92d91c0082f5be68f7350d87b7cdf105267543f1f61d3043a5c2d8a00b’,null,’3402562013208542942L’,’3402562013208542942L’,1,10000000,’\xcde9a3459b1f5590a9b6f32a5d9c2e85596be9d01ded14fa9d9c5f276a37e2562e40f459c727599323e1ee84435a63316b3a3a50fb3b5d687dc7ea1f1ad9e001',null,null)
ERROR: insert or update on table “blocks” violates foreign key constraint “blocks_previousBlock_fkey”
DETAIL: Key (previousBlock)=(5488578331239914243) is not present in table “blocks”.
STATEMENT: INSERT INTO “blocks”(“id”,”version”,”timestamp”,”height”,”previousBlock”,”numberOfTransactions”,”totalAmount”,”totalFee”,”reward”,”payloadLength”,”payloadHash”,”generatorPublicKey”,”blockSignature”) VALUES (‘13977984917448353211’,0,63803270,6144655,’5488578331239914243',0,0,0,400000000,0,’\xe3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855',’\x6cb825715058d2e821aa4af75fbd0da52181910d9fda90fabe73cd533eeb6acb’,’\x0b534abcbe640cef4df6a579bbffe00eb62401b9090e6d7f1ef72e4dafaa31bdb8594b85007f7d8ed79d4166835334ca2adb0830a175d6ac39263fe5fcf8950f’)
ERROR: insert or update on table “blocks” violates foreign key constraint “blocks_previousBlock_fkey”
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment