search

benjamin-wilson / public-pool

GNU General Public License v3.0
175 stars 48 forks source link

Duplicate share on mainnet #54

Open Retropex opened 1 month ago

Retropex commented 1 month ago

same problem of #50 but on mainnet:

0|main  | {"id":112,"result":null,"error":[22,"Duplicate share",""]}
0|main  | QueryFailedError: SQLITE_ERROR: no such column: NaN
0|main  |     at handler (/home/leo/.public-pool/src/driver/sqlite/SqliteQueryRunner.ts:113:26)
0|main  |     at Statement.errBack (/home/leo/.public-pool/node_modules/sqlite3/lib/sqlite3.js:15:21) {
0|main  |   query: 'UPDATE "client_entity" SET "hashRate" = NaN, "deletedAt" = ?, "updatedAt" = ? WHERE ("address" = ? AND "clientName" = ? AND "sessionId" = ?)',
0|main  |   parameters: [
0|main  |     undefined,
0|main  |     '0NaN-aN-aN aN:aN:aN.NaN',
0|main  |     '******',
0|main  |     'bitaxe',
0|main  |     '1c1b40b3'
0|main  |   ],
0|main  |   driverError: [Error: SQLITE_ERROR: no such column: NaN] {
0|main  |     errno: 1,
0|main  |     code: 'SQLITE_ERROR'
0|main  |   },
0|main  |   errno: 1,
0|main  |   code: 'SQLITE_ERROR'
0|main  | }
image
Retropex commented 1 month ago

Apparently the problem isn't here on a old commit deed775d5561a2c9a21dfe595260225ec676344f (chosen randomly for testing)

benjamin-wilson commented 2 weeks ago

Testing this again tonight, are you able to reproduce this still? I have not been able to reproduce it. Any reproduction steps?