duplicate shares on mainnet

[Gabole29]

hello, just installed windows version of public pool app with bitcoin cash node, it was working ok the first minutes but now i have duplicate shares almost 100% of the time and sqllite errors. here is a sample of the logs error, any idea ?

[2025-12-22 19:55:38.115] [info] stdout: QueryFailedError: SQLITE_ERROR: no such column: NaN
at handler (C:\Users\SER5 PRO\AppData\Local\public_pool_app\app-1.0.1\resources\node_modules\typeorm\driver\sqlite\SqliteQueryRunner.js:81:26)
at Statement.errBack (C:\Users\SER5 PRO\AppData\Local\public_pool_app\app-1.0.1\resources\node_modules\sqlite3\lib\sqlite3.js:15:21) {
query: 'UPDATE "client_entity" SET "hashRate" = NaN, "deletedAt" = ?, "updatedAt" = ? WHERE ("address" = ? AND "clientName" = ? AND "sessionId" = ?)',
parameters: [
undefined,
'0NaN-aN-aN aN:aN:aN.NaN',
'mybitcoinaddress',
'bitaxe1',
'752a9a96'
],
driverError: [Error: SQLITE_ERROR: no such column: NaN] {
errno: 1,
code: 'SQLITE_ERROR'
},
errno: 1,
code: 'SQLITE_ERROR'
}

[2025-12-22 19:55:38.116] [info] stderr: {"id":202,"result":null,"error":[22,"Duplicate share",""]}

also, if i put a bc2 adress the miner connect without issue, if i put a bitcoin cash address, there is a connection error...very strange

help appreciated

thank you

[Gabole29]

@Gabole29 hey mate, have you been able to resolve your issue yet?

hi mate thanks for reply. no havent solved it yet. realised i posted in the wrong branch, the bug is related to publi-pool-app but i guess everyone understood. anyway the problem persists. i updated sqlite on my pc, same issue: the miners connect well and sublmit shares for a few minutes, then all shares rejected as duplicate...