[PayoutManager] [eth1] Payment processing failed

[tuncatunc]

Hi All,

Payment processing to miners has stopped yesterday and all rewards are accumulating in Pool Wallet Address

Pool Wallet Address
I'm mining with T-Rex miner and the pool successfully mines new block however it fails to pay to miners.

Note: 97% of the disk is full and only 5G is left

[2021-08-15 12:03:41.2278] [I] [PayoutManager] Processing payments for pool eth1, block 10830926 
[2021-08-15 12:03:41.2302] [I] [PPLNS Payment] Fetching page 0 of shares for pool eth1, block 10830926 
[2021-08-15 12:03:41.2302] [I] [PPLNS Payment] Balance-calculation for pool eth1, block 10830926 completed with accumulated score 0.5 (100%) 
[2021-08-15 12:03:41.2302] [I] [PPLNS Payment] Adding 1.97841 ETH to balance of 0x1bfc443de53b8b1c3f488dcf797f412f36552c07 for 858.99 M (858993459.2) shares for block 10830926 
[2021-08-15 12:03:41.2334] [I] [PPLNS Payment] Fetching page 0 of discarded shares for pool eth1, block 10830926 
[2021-08-15 12:03:41.2334] [I] [PPLNS Payment] 429.5 M (429496729.6) total discarded shares, block 10830926 
[2021-08-15 12:03:41.2334] [I] [PPLNS Payment] 0x1bfc443de53b8b1c3f488dcf797f412f36552c07 = 429.5 M (429496729.6) discarded shares, block 10830926 
[2021-08-15 12:03:41.2334] [I] [PPLNS Payment] Deleting 1 discarded shares before 2021-08-13T20:01:49.8930420 
[2021-08-15 12:03:41.2334] [I] [PPLNS Payment] 858.99 M (858993459.2) shares contributed to a total payout of 1.97841 ETH (100.00% of block reward) to 1 addresses 
[2021-08-15 12:03:41.2334] [E] [PayoutManager] [eth1] Payment processing failed System.InvalidOperationException: This NpgsqlTransaction has completed; it is no longer usable.
   at Npgsql.NpgsqlTransaction.CheckReady()
   at Npgsql.NpgsqlTransaction.Rollback(Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlTransaction.Rollback()
   at Miningcore.Extensions.ConnectionFactoryExtensions.RunTx(IConnectionFactory factory, Func`3 action, Boolean autoCommit, IsolationLevel isolation) in /home/pool/miningcore/src/Miningcore/Extensions/ConnectionFactoryExtensions.cs:line 58
   at Miningcore.Payments.PayoutManager.UpdatePoolBalancesAsync(IMiningPool pool, PoolConfig config, IPayoutHandler handler, IPayoutScheme scheme, CancellationToken ct) in /home/pool/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 170
   at Miningcore.Payments.PayoutManager.ProcessPoolsAsync(CancellationToken ct) in /home/pool/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 110    at Npgsql.NpgsqlTransaction.CheckReady()
   at Npgsql.NpgsqlTransaction.Rollback(Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlTransaction.Rollback()
   at Miningcore.Extensions.ConnectionFactoryExtensions.RunTx(IConnectionFactory factory, Func`3 action, Boolean autoCommit, IsolationLevel isolation) in /home/pool/miningcore/src/Miningcore/Extensions/ConnectionFactoryExtensions.cs:line 58
   at Miningcore.Payments.PayoutManager.UpdatePoolBalancesAsync(IMiningPool pool, PoolConfig config, IPayoutHandler handler, IPayoutScheme scheme, CancellationToken ct) in /home/pool/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 170
   at Miningcore.Payments.PayoutManager.ProcessPoolsAsync(CancellationToken ct) in /home/pool/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 110

miningcore.log

ethereum_pool.json

Thanks

[Konstantin35]

Duplicate block in the database

[Konstantin35]

yes, they are the ones that can be seen in the logs

[2021-08-15 12:03:41.2302] [I] [PPLNS Payment] Fetching page 0 of shares for pool eth1, block 10830926 
[2021-08-15 12:03:41.2302] [I] [PPLNS Payment] Balance-calculation for pool eth1, block 10830926 completed with accumulated 

[Konstantin35]

Of course, you can fix at the postgresql level to eliminate duplicates, but in the miner it will be known that the block is solved, this is a bad cheat, since the duplicate block should become an uncle or orphaned.

[tuncatunc]

@Konstantin35 should i mark them as orphan or uncle at psql level❓ what's the best solution

[AlphaX-Qortal]

i guess not as uncle because ther is now reward. Uncle have rewards

[tuncatunc]

I may have used pool wallet address to mine ethereum.
Could this be root of the issue?