ETH payout bug

[SsNiPeR1]

I can't payout my mined ethers on a private chain [2022-07-11 22:05:49.3346] [I] [PayoutManager] Processing payments for pool resin, block 16124 [2022-07-11 22:05:49.3390] [E] [PayoutManager] [resin] Payment processing failed System.ArgumentNullException: Value cannot be null. (Parameter 'source') at System.Linq.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument) at System.Linq.Enumerable.Where[TSource](IEnumerable1 source, Func2 predicate) at Miningcore.Payments.PayoutHandlerBase.UpdateBlockRewardBalancesAsync(IDbConnection con, IDbTransaction tx, IMiningPool pool, Block block, CancellationToken ct) in /root/miningcore/src/Miningcore/Payments/PayoutHandlerBase.cs:line 90 at Miningcore.Blockchain.Ethereum.EthereumPayoutHandler.UpdateBlockRewardBalancesAsync(IDbConnection con, IDbTransaction tx, IMiningPool pool, Block block, CancellationToken ct) in /root/miningcore/src/Miningcore/Blockchain/Ethereum/EthereumPayoutHandler.cs:line 229 at Miningcore.Payments.PayoutManager.<>c__DisplayClass17_1.<<UpdatePoolBalancesAsync>b__4>d.MoveNext() in /root/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 185 --- End of stack trace from previous location --- at Miningcore.Extensions.ConnectionFactoryExtensions.RunTx(IConnectionFactory factory, Func3 action, Boolean autoCommit, IsolationLevel isolation) in /root/miningcore/src/Miningcore/Extensions/ConnectionFactoryExtensions.cs:line 61 at Miningcore.Payments.PayoutManager.UpdatePoolBalancesAsync(IMiningPool pool, PoolConfig poolConfig, IPayoutHandler handler, IPayoutScheme scheme, CancellationToken ct) in /root/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 164 at Miningcore.Payments.PayoutManager.ProcessPoolsAsync(CancellationToken ct) in /root/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 104 at System.Linq.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument) at System.Linq.Enumerable.Where[TSource](IEnumerable1 source, Func2 predicate) at Miningcore.Payments.PayoutHandlerBase.UpdateBlockRewardBalancesAsync(IDbConnection con, IDbTransaction tx, IMiningPool pool, Block block, CancellationToken ct) in /root/miningcore/src/Miningcore/Payments/PayoutHandlerBase.cs:line 90 at Miningcore.Blockchain.Ethereum.EthereumPayoutHandler.UpdateBlockRewardBalancesAsync(IDbConnection con, IDbTransaction tx, IMiningPool pool, Block block, CancellationToken ct) in /root/miningcore/src/Miningcore/Blockchain/Ethereum/EthereumPayoutHandler.cs:line 229 at Miningcore.Payments.PayoutManager.<>c__DisplayClass17_1.<<UpdatePoolBalancesAsync>b__4>d.MoveNext() in /root/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 185 --- End of stack trace from previous location --- at Miningcore.Extensions.ConnectionFactoryExtensions.RunTx(IConnectionFactory factory, Func3 action, Boolean autoCommit, IsolationLevel isolation) in /root/miningcore/src/Miningcore/Extensions/ConnectionFactoryExtensions.cs:line 61 at Miningcore.Payments.PayoutManager.UpdatePoolBalancesAsync(IMiningPool pool, PoolConfig poolConfig, IPayoutHandler handler, IPayoutScheme scheme, CancellationToken ct) in /root/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 164 at Miningcore.Payments.PayoutManager.ProcessPoolsAsync(CancellationToken ct) in /root/miningcore/src/Miningcore/Payments/PayoutManager.cs:line 104

[SsNiPeR1]

ok now it says npgsql error transaction has completed and no longer usable

[oliverw]

    "persistence": {
        "postgres": {
            ...
            "commandTimeout": 600,

Try adding the commandTimeout and restart the pool.

[SsNiPeR1]

    "persistence": {
        "postgres": {
            ...
            "commandTimeout": 600,

Try adding the commandTimeout and restart the pool.

the same.

[SsNiPeR1]

got this fixed by adding more ram.

[oliverw]

got this fixed by adding more ram.

Interesting 🤔

[SsNiPeR1]

REOPEN: RAM was not the issue

[SsNiPeR1]

The issue is in the database

[oliverw]

Tracked in linked issue.