Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql errors in the logs #16

Open
bastianh opened this issue Mar 9, 2021 · 0 comments
Open

sql errors in the logs #16

bastianh opened this issue Mar 9, 2021 · 0 comments

Comments

@bastianh
Copy link

bastianh commented Mar 9, 2021

I see a lot of sql errors in the logs .. it's working so maybe there are duplicate saves?

I also deleted the database and restartet the server, does not change the spam .)

[historyWorker] Error processing room E31N3@53440 { SequelizeUniqueConstraintError: Validation error
    at Query.formatError (/screeps/node_modules/sequelize/lib/dialects/sqlite/query.js:409:16)
    at Query._handleQueryResponse (/screeps/node_modules/sequelize/lib/dialects/sqlite/query.js:72:18)
    at Statement.afterExecute (/screeps/node_modules/sequelize/lib/dialects/sqlite/query.js:246:27)
  name: 'SequelizeUniqueConstraintError',
  errors:
   [ ValidationErrorItem {
       message: 'room must be unique',
       type: 'unique violation',
       path: 'room',
       value: 'E31N3',
       origin: 'DB',
       instance: [history],
       validatorKey: 'not_unique',
       validatorName: null,
       validatorArgs: [] },
     ValidationErrorItem {
       message: 'tick must be unique',
       type: 'unique violation',
       path: 'tick',
       value: 53440,
       origin: 'DB',
       instance: [history],
       validatorKey: 'not_unique',
       validatorName: null,
       validatorArgs: [] } ],
  fields: [ 'room', 'tick' ],
  parent:
   { Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: histories.room, histories.tick
     errno: 19,
     code: 'SQLITE_CONSTRAINT',
     sql:
      'INSERT INTO `histories` (`id`,`room`,`tick`,`data`,`createdAt`,`updatedAt`) VALUES (NULL,$1,$2,$3,$4,$5);' },
  original:
   { Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: histories.room, histories.tick
     errno: 19,
     code: 'SQLITE_CONSTRAINT',
     sql:
      'INSERT INTO `histories` (`id`,`room`,`tick`,`data`,`createdAt`,`updatedAt`) VALUES (NULL,$1,$2,$3,$4,$5);' },
  sql:
   'INSERT INTO `histories` (`id`,`room`,`tick`,`data`,`createdAt`,`updatedAt`) VALUES (NULL,$1,$2,$3,$4,$5);' }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant