Skip to content

SequelizeDatabaseError: invalid input syntax for type numeric: "0186a0"  #51

@majecty

Description

@majecty

This error occurred at 1b68ea1

{ SequelizeDatabaseError: invalid input syntax for type numeric: "0186a0"                                                                                                                                                                
    at Query.formatError (/home/ubuntu/indexer/node_modules/sequelize/lib/dialects/postgres/query.js:363:16)                                                                                                                             
    at query.catch.err (/home/ubuntu/indexer/node_modules/sequelize/lib/dialects/postgres/query.js:86:18)                                                                                                                                
    at tryCatcher (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/util.js:16:23)                                                                                                                           
    at Promise._settlePromiseFromHandler (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:512:31)                                                                                                
    at Promise._settlePromise (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:569:18)                                                                                                           
    at Promise._settlePromise0 (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:614:10)                                                                                                          
    at Promise._settlePromises (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:690:18)                                                                                                          
    at _drainQueueStep (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/async.js:138:12)                                                                                                                    
    at _drainQueue (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/async.js:131:9)                                                                                                                         
    at Async._drainQueues (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/async.js:147:5)                                                                                                                  
    at Immediate.Async.drainQueues [as _onImmediate] (/home/ubuntu/indexer/node_modules/sequelize/node_modules/bluebird/js/release/async.js:17:14)                                                                                       
    at runCallback (timers.js:705:18)                                                                                                                                                                                                    
    at tryOnImmediate (timers.js:676:5)                                                                                                                                                                                                  
    at processImmediate (timers.js:658:5)                                                                                                                                                                                                
    at process.topLevelDomainCallback (domain.js:120:23)                                                                                                                                                                                 
  name: 'SequelizeDatabaseError',                                                                                                                                                                                                        
  parent:                                                                                                                                                                                                                                
   { error: invalid input syntax for type numeric: "0186a0"                                                                                                                                                                              
       at Connection.parseE (/home/ubuntu/indexer/node_modules/pg/lib/connection.js:554:11)                                                                                                                                              
       at Connection.parseMessage (/home/ubuntu/indexer/node_modules/pg/lib/connection.js:379:19)                                                                                                                                        
       at Socket.<anonymous> (/home/ubuntu/indexer/node_modules/pg/lib/connection.js:119:22)                                                                                                                                             
       at Socket.emit (events.js:182:13)                                                                                                                                                                                                 
       at Socket.EventEmitter.emit (domain.js:441:20)                                                                                                                                                                                    
       at addChunk (_stream_readable.js:283:12)                                                                                                                                                                                          
       at readableAddChunk (_stream_readable.js:264:11)                                                                                                                                                                                  
       at Socket.Readable.push (_stream_readable.js:219:10)                                                                                                                                                                              
       at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)                                                                                                                                                           
     name: 'error',                                                                                                                                                                                                                      
     length: 108,                                                                                                                                                                                                                        
     severity: 'ERROR',                                                                                                                                                                                                                  
     code: '22P02',                                                                                                                                                                                                                      
     detail: undefined,                                                                                                                                                                                                                  
     hint: undefined,
     position: '207',
     internalPosition: undefined,
     internalQuery: undefined,
     where: undefined,
     schema: undefined,
     table: undefined,
     column: undefined,
     dataType: undefined,
     constraint: undefined,
     file: 'numeric.c',
     line: '621',
     routine: 'numeric_in',
     sql:
      'INSERT INTO "Pays" ("transactionHash","receiver","quantity","createdAt","updatedAt") VALUES (\'bb27d1caed7ad9acf82e30810fea166d432d8aa145ce6579f1b06a74d98994be\',\'wccq8hpt3p988eu5ch62zr92wmd5fjfs7rp354vjgay\',\'0186a0\',\'2019-02-01 09:44:00.218 +00:00\',\'2019-02-01 09:44:00.218 +00:00\') RETURNING *;' },
  original:
   { error: invalid input syntax for type numeric: "0186a0"
       at Connection.parseE (/home/ubuntu/indexer/node_modules/pg/lib/connection.js:554:11)
       at Connection.parseMessage (/home/ubuntu/indexer/node_modules/pg/lib/connection.js:379:19)
       at Socket.<anonymous> (/home/ubuntu/indexer/node_modules/pg/lib/connection.js:119:22)
       at Socket.emit (events.js:182:13)
       at Socket.EventEmitter.emit (domain.js:441:20)
       at addChunk (_stream_readable.js:283:12)
       at readableAddChunk (_stream_readable.js:264:11)
       at Socket.Readable.push (_stream_readable.js:219:10)
       at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
     name: 'error',
     length: 108,
     severity: 'ERROR',
     code: '22P02',
     detail: undefined,
     hint: undefined,
     position: '207',
     internalPosition: undefined,
     internalQuery: undefined,
     where: undefined,
     schema: undefined,
     table: undefined,
     column: undefined,
     dataType: undefined,
     constraint: undefined,
     file: 'numeric.c',
     line: '621',
     routine: 'numeric_in',
     sql:
      'INSERT INTO "Pays" ("transactionHash","receiver","quantity","createdAt","updatedAt") VALUES (\'bb27d1caed7ad9acf82e30810fea166d432d8aa145ce6579f1b06a74d98994be\',\'wccq8hpt3p988eu5ch62zr92wmd5fjfs7rp354vjgay\',\'0186a0\',\'2019-02-01 09:44:00.218 +00:00\',\'2019-02-01 09:44:00.218 +00:00\') RETURNING *;' },
  sql:
   'INSERT INTO "Pays" ("transactionHash","receiver","quantity","createdAt","updatedAt") VALUES (\'bb27d1caed7ad9acf82e30810fea166d432d8aa145ce6579f1b06a74d98994be\',\'wccq8hpt3p988eu5ch62zr92wmd5fjfs7rp354vjgay\',\'0186a0\',\'2019-02-01 09:44:00.218 +00:00\',\'2019-02-01 09:44:00.218 +00:00\') RETURNING *;' }
{ code: 103, message: 'DBError' }

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions