System 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

System offline

Post by Steve Sokolowski » Wed Jun 07, 2017 12:58 pm

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.
tmopar
Posts: 60
Joined: Sun Apr 16, 2017 1:50 pm

Re: System offline

Post by tmopar » Wed Jun 07, 2017 1:41 pm

The trans id wraparound really came into play eh? can you raise it to a 64 bit unsigned??? What was it beforehand?
User avatar
tucsondirect
Posts: 73
Joined: Mon Jul 20, 2015 8:05 pm

Re: System offline

Post by tucsondirect » Wed Jun 07, 2017 1:59 pm

raising pitchforks!
UPSoft
Posts: 27
Joined: Wed May 24, 2017 10:58 am
Location: Moscow RU

Re: System offline

Post by UPSoft » Wed Jun 07, 2017 2:58 pm

WHY you guys just don't RENT a server?
ap1318
Posts: 1
Joined: Mon Jun 05, 2017 7:15 pm

Re: System offline

Post by ap1318 » Wed Jun 07, 2017 3:24 pm

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.
GregoryGHarding
Posts: 646
Joined: Sun Apr 16, 2017 3:01 pm

Re: System offline

Post by GregoryGHarding » Wed Jun 07, 2017 4:17 pm

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.
UPSoft
Posts: 27
Joined: Wed May 24, 2017 10:58 am
Location: Moscow RU

Re: System offline

Post by UPSoft » Wed Jun 07, 2017 4:50 pm

no, I meant the server. but i got u ap1318
User avatar
tucsondirect
Posts: 73
Joined: Mon Jul 20, 2015 8:05 pm

Re: System offline

Post by tucsondirect » Wed Jun 07, 2017 6:15 pm

Because renting a server that holds thousands and thousands of dollars in crypto currency is a freaking horrible idea
Locked