System offline
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
System offline
I took the system offline.
The database failed with a "multi-xact wraparound" error. This error occurs when vacuuming isn't completed often enough. The vacuum process wasn't completing because of database overload, which occurred because too many miners joined the pool over the past few days. The resolution involves not only fixing the problem, but also more performance improvements. We had just gotten the CPU under control and now it's the database.
I'm getting in contact with Chris to see what, if anything, can be done about this error short of a full recovery from backup. He will update everyone later this afternoon on his progress.
The database failed with a "multi-xact wraparound" error. This error occurs when vacuuming isn't completed often enough. The vacuum process wasn't completing because of database overload, which occurred because too many miners joined the pool over the past few days. The resolution involves not only fixing the problem, but also more performance improvements. We had just gotten the CPU under control and now it's the database.
I'm getting in contact with Chris to see what, if anything, can be done about this error short of a full recovery from backup. He will update everyone later this afternoon on his progress.
Re: System offline
The trans id wraparound really came into play eh? can you raise it to a 64 bit unsigned??? What was it beforehand?
- tucsondirect
- Posts: 73
- Joined: Mon Jul 20, 2015 8:05 pm
Re: System offline
raising pitchforks!
Re: System offline
WHY you guys just don't RENT a server?
Re: System offline
UPSoft,
Renting a server would not solve anything. The issue is not hardware related. You will have databases on rented servers as well. It is inevitable with evil SQL.
Renting a server would not solve anything. The issue is not hardware related. You will have databases on rented servers as well. It is inevitable with evil SQL.
-
- Posts: 646
- Joined: Sun Apr 16, 2017 3:01 pm
Re: System offline
i think by rent a server he means rent a service.. when prohashing IS a service you cant really hire a service to run your shit tey'd just be part of the company.
Re: System offline
no, I meant the server. but i got u ap1318
- tucsondirect
- Posts: 73
- Joined: Mon Jul 20, 2015 8:05 pm
Re: System offline
Because renting a server that holds thousands and thousands of dollars in crypto currency is a freaking horrible idea