stakwork / sphinx-relay

Node.js wrapper for communication between sphinx client and lightning node.
MIT License
250 stars 70 forks source link

Crash: invalid input syntax for type numeric: "0-1000 #735

Open kevkevinpal opened 11 months ago

kevkevinpal commented 11 months ago

When looking through proxy logs I saw this error crash relay

node:internal/process/promises:245
          triggerUncaughtException(err, true /* fromPromise */);
          ^

DatabaseError [SequelizeDatabaseError]: invalid input syntax for type numeric: "0-1000"
    at Query.formatError (/home/ec2-user/sphinx-relay/node_modules/sequelize/lib/dialects/postgres/query.js:366:16)
    at /home/ec2-user/sphinx-relay/node_modules/sequelize/lib/dialects/postgres/query.js:72:18
    at tryCatcher (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/promise.js:547:31)
    at Promise._settlePromise (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/promise.js:604:18)
    at Promise._settlePromise0 (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/promise.js:649:10)
    at Promise._settlePromises (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/promise.js:725:18)
    at _drainQueueStep (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/async.js:93:12)
    at _drainQueue (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/async.js:86:9)
    at Async._drainQueues (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/async.js:102:5)
    at Immediate.Async.drainQueues [as _onImmediate] (/home/ec2-user/sphinx-relay/node_modules/bluebird/js/release/async.js:15:14)
    at processImmediate (node:internal/timers:464:21) {
  parent: error: invalid input syntax for type numeric: "0-1000"
      at Parser.parseErrorMessage (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/parser.js:287:98)
      at Parser.handlePacket (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/parser.js:126:29)
      at Parser.parse (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/parser.js:39:38)
      at Socket.<anonymous> (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/index.js:11:42)
      at Socket.emit (node:events:378:20)
      at addChunk (node:internal/streams/readable:313:12)
      at readableAddChunk (node:internal/streams/readable:288:9)
      at Socket.Readable.push (node:internal/streams/readable:227:10)
         at Socket.Readable.push (node:internal/streams/readable:227:10)
      at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
    length: 103,
    severity: 'ERROR',
    code: '22P02',
    detail: undefined,
    hint: undefined,
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'numeric.c',
    line: '624',
    routine: 'numeric_in',
    sql: 'UPDATE "sphinx_subscriptions" SET "total_paid"=$1,"count"=$2,"ended"=$3,"updated_at"=$4 WHERE "id" = $5',
    parameters: [ '0-1000', 1, true, '2023-08-01 03:23:00.213 +00:00', 190 ]
  },
  original: error: invalid input syntax for type numeric: "0-1000"
      at Parser.parseErrorMessage (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/parser.js:287:98)
      at Parser.handlePacket (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/parser.js:126:29)
      at Parser.parse (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/parser.js:39:38)
      at Socket.<anonymous> (/home/ec2-user/sphinx-relay/node_modules/pg-protocol/dist/index.js:11:42)
      at Socket.emit (node:events:378:20)
      at addChunk (node:internal/streams/readable:313:12)
      at readableAddChunk (node:internal/streams/readable:288:9)
      at Socket.Readable.push (node:internal/streams/readable:227:10)
      at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
    length: 103,
    severity: 'ERROR',
    code: '22P02',
    detail: undefined,
    hint: undefined,
    position: undefined,
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'numeric.c',
    line: '624',
    routine: 'numeric_in',
    sql: 'UPDATE "sphinx_subscriptions" SET "total_paid"=$1,"count"=$2,"ended"=$3,"updated_at"=$4 WHERE "id" = $5',
    parameters: [ '0-1000', 1, true, '2023-08-01 03:23:00.213 +00:00', 190 ]
  },
  sql: 'UPDATE "sphinx_subscriptions" SET "total_paid"=$1,"count"=$2,"ended"=$3,"updated_at"=$4 WHERE "id" = $5',
  parameters: [ '0-1000', 1, true, '2023-08-01 03:23:00.213 +00:00', 190 ]
  }