Last night, at 2:12 EST, 2^31 rows had been inserted in the daily balances table, causing the next row to fail due to overflow. For several hours afterward, the mining server queued up shares in memory and allowed mining to continue, until it eventually ran out of memory and crashed.
We apologize for the problem. Mining should be back to normal. I changed the type of the column to BIGINT so that it won't overflow, and Chris will compute and adjust balances for the day so that everyone receives credit for the time they mined.
Feel free to ask any questions you might have as we continue to work on the unrelated performance improvements, which I intend to release within the week.
id column overflow last night
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.
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.
- Steve Sokolowski
- Posts: 4585
- Joined: Wed Aug 27, 2014 3:27 pm
- Location: State College, PA
- Chris Sokolowski
- Site Admin
- Posts: 945
- Joined: Wed Aug 27, 2014 12:47 pm
- Location: State College, PA
Re: id column overflow last night
The server was offline for 32878 seconds, from 02:12:20 to 11:20:19. I will be correcting everyone's balances for the missing shares by increasing everyone's February 14 earnings by 61.43%, regardless of whether you were mining around that time or not. The balances have been corrected as of five minutes ago and will be paid today. Please let me know if you have any questions.