One mining server offline

News updates about the Prohashing pool
Forum rules
The News forum is only for updates about the Prohashing pool.

Replies to posts in this forum should be related to the news being announced. If you need support on another issue, please post in the forum related to that topic or seek one of the official support options listed in the top right corner of the forums page or on prohashing.com/about.

For the full list of PROHASHING forums rules, please visit https://prohashing.com/help/prohashing- ... rms-forums.
Locked
User avatar
Steve Sokolowski
Posts: 4585
Joined: Wed Aug 27, 2014 3:27 pm
Location: State College, PA

One mining server offline

Post by Steve Sokolowski » Sun May 02, 2021 10:40 am

One of the mining servers is currently offline for an unknown cause, affecting about one-tenth of miners.

We're investigating and hope to update everyone with more information shortly. The issue may be related to some strange live data issues we've been experiencing the past few days, but we can't be certain at this point.
futurebit
Posts: 11
Joined: Sat May 18, 2019 1:42 pm

Re: One mining server offline

Post by futurebit » Sun May 02, 2021 10:51 am

thanks. i just see the Push message on the phone from CheckPool...
User avatar
Steve Sokolowski
Posts: 4585
Joined: Wed Aug 27, 2014 3:27 pm
Location: State College, PA

Re: One mining server offline

Post by Steve Sokolowski » Sun May 02, 2021 11:29 am

I traced this problem down to one database table and woke Chris up to investigate it. For some reason, trying to select from the table just locks thing s up and never returns the data.
Daeghan
Posts: 10
Joined: Sat May 01, 2021 12:35 pm

Re: One mining server offline

Post by Daeghan » Sun May 02, 2021 11:44 am

You guys are awesome and super fast! Thanks for fixing these issues!
User avatar
Steve Sokolowski
Posts: 4585
Joined: Wed Aug 27, 2014 3:27 pm
Location: State College, PA

Re: One mining server offline

Post by Steve Sokolowski » Sun May 02, 2021 11:46 am

The mining server is back online after Chris killed 100 instances of this query that had backed up.

What happened is that this query never had any problems until now, when the number of new customers has risen significantly and therefore the table scans it was doing became very long. He's working on a way to make it perform faster with indexes so that this doesn't happen again. Until then, the coin selection data will be slightly out of date, but the effects on profitability are likely to be close to zero change since he should have it fixed within an hour or two.
futurebit
Posts: 11
Joined: Sat May 18, 2019 1:42 pm

Re: One mining server offline

Post by futurebit » Sun May 02, 2021 12:55 pm

thank you also for explaining the problem. It's something that no company has done before.

You're gorgeous

Its working again!!! :lol: :lol: :lol: :lol: :lol:
Locked