Status as of Monday, December 18, 2017

Steve Sokolowski avatar
Steve Sokolowski
Archived posts: 4559
Joined: Aug 27, 2014

Status as of Monday, December 18, 2017

by Steve Sokolowski · · Post #13859

Good morning!
  • Chris is going to try yesterday's release, which we hope will reduce the network connectivity issues, this evening.
  • I spent time this morning on the electricity usage chart on the homepage, and resolved the issue that was causing the chart to not display any values over the past week. After the release, this chart should return to displaying electricity usage.
  • My efforts for the remainder of the year will be focused on resolving system bugs and issues.
  • There is a deadlock issue with payouts. Right now, our solution is to simply retry every hour, and generally about half the coins succeed each time. Payouts will still be delivered before the deadline for now, but it's possible that we may eventually have to start shutting mining down for a few minutes each day to issue the payouts. This is a complex problem that's going to take a long time to resolve, and I'm going to spend some time during the holiday week trying to figure out if there is a way to order the queries across all the parts of the system that reference the balance tables. Theoretically, deadlocks can be resolved if all transactions obtain the locks in the same order of tables, followed by the same order of rows, I think.
Steve Sokolowski avatar
Steve Sokolowski
Archived posts: 4559
Joined: Aug 27, 2014

Re: Status as of Monday, December 18, 2017

by Steve Sokolowski · · Post #13861

Constance actually figured out the solution to the the deadlocks pretty simply. All we need to do is to store the payout rows in a separate table. Then the locks are held open on that table while the transaction goes out to the network and it can be rolled back in the case of failure.

After that transaction is committed and the payout is sent, then one transaction per person can be executed to delete the row from the temporary table and insert the row in to the permanent table. That eliminates the need to worry about the order of payouts while still being absolutely sure that somewhere in the database matches what actually happened.
keksik
Archived posts: 43
Joined: Dec 08, 2017

Re: Status as of Monday, December 18, 2017

by keksik · · Post #13970

Hi Steve,

i can see there could be an issue with payments. curently i have negative balance, -0.06ltc, so aprox -20usd

i can see today 3 outgoing payments:

Payout Litecoin -0.04879526 To: LUk2tpJYFFEne7W9… 12/19/2017
Payout Litecoin -0.04879526 To: LUk2tpJYFFEne7W9…
ID: 5f0b236fec73113d825f176044fedc49fab8b6e67a8e86b42b44d0600d45d68b 12/19/2017
Payout Litecoin -0.09759053 To: LUk2tpJYFFEne7W9… 12/19/2017

i have only 1x l3+,but some folks could have more and it can make you a lot of trouble..check for this man.
bpvarsity12
Archived posts: 4
Joined: Dec 19, 2017

Re: Status as of Monday, December 18, 2017

by bpvarsity12 · · Post #13996

keksik wrote:Hi Steve,

i can see there could be an issue with payments. curently i have negative balance, -0.06ltc, so aprox -20usd

i can see today 3 outgoing payments:

Payout Litecoin -0.04879526 To: LUk2tpJYFFEne7W9… 12/19/2017
Payout Litecoin -0.04879526 To: LUk2tpJYFFEne7W9…
ID: 5f0b236fec73113d825f176044fedc49fab8b6e67a8e86b42b44d0600d45d68b 12/19/2017
Payout Litecoin -0.09759053 To: LUk2tpJYFFEne7W9… 12/19/2017

i have only 1x l3+,but some folks could have more and it can make you a lot of trouble..check for this man.
I have the same issue. Last night I saw 3 outgoing payments but this morning it's just one.
Steve Sokolowski avatar
Steve Sokolowski
Archived posts: 4559
Joined: Aug 27, 2014

Re: Status as of Monday, December 18, 2017

by Steve Sokolowski · · Post #13998

bpvarsity12 wrote:
keksik wrote:Hi Steve,

i can see there could be an issue with payments. curently i have negative balance, -0.06ltc, so aprox -20usd

i can see today 3 outgoing payments:

Payout Litecoin -0.04879526 To: LUk2tpJYFFEne7W9… 12/19/2017
Payout Litecoin -0.04879526 To: LUk2tpJYFFEne7W9…
ID: 5f0b236fec73113d825f176044fedc49fab8b6e67a8e86b42b44d0600d45d68b 12/19/2017
Payout Litecoin -0.09759053 To: LUk2tpJYFFEne7W9… 12/19/2017

i have only 1x l3+,but some folks could have more and it can make you a lot of trouble..check for this man.
I have the same issue. Last night I saw 3 outgoing payments but this morning it's just one.
Those payouts never happened. I deleted them to correct the error.