Strange behavior of Suprnova total-earnings stats

l0ud

newbie

Activity: 23

Merit: 0

Quote from: ocminer on February 16, 2018, 10:37:54 PM

Quote from: l0ud on February 16, 2018, 04:19:57 AM

Quote from: ocminer on February 15, 2018, 04:24:20 PM

The 10 day limit only limits PAID Earnings.. so all withdrawn funds are deleted from the DB after 10 days, of course if you don't. Withdraw, I can't and won't delete anything.

Aha, well that clears it up a bit, I guess, thanks

but I had a 36 hour run there where I actually did not make any new earnings which caused me to believe that I lost money that had not been withdrawed within 10 days.
Usually I pull in about 2 ZCL per 24 hours, but yesterday and half the day before that I made like 0,3 ZCL in total with no major changes in hashing power, rig downtime or blocks mined..

Check the netstats for zcl.. through the roof because of the upcoming btcp hardfork.. so much more people mining zcl and that means higher difficulty, lower reward for everyone

I know but I'm pulling around 50k Sol/s so it should have been more than 0,3 ZCL in 36 hours, unless there was some downtime on the pool that I dont know about, but I guess thats fine either way. This gave me the push needed to set up a wallet where I control the private keys so I could prepare for the fork so something good came out of it

l0ud

newbie

Activity: 23

Merit: 0

Quote from: ocminer on February 15, 2018, 04:24:20 PM

The 10 day limit only limits PAID Earnings.. so all withdrawn funds are deleted from the DB after 10 days, of course if you don't. Withdraw, I can't and won't delete anything.

Aha, well that clears it up a bit, I guess, thanks

but I had a 36 hour run there where I actually did not make any new earnings which caused me to believe that I lost money that had not been withdrawed within 10 days.
Usually I pull in about 2 ZCL per 24 hours, but yesterday and half the day before that I made like 0,3 ZCL in total with no major changes in hashing power, rig downtime or blocks mined..

ocminer

legendary

Activity: 2688

Merit: 1240

Quote from: l0ud on February 16, 2018, 04:19:57 AM

Quote from: ocminer on February 15, 2018, 04:24:20 PM

The 10 day limit only limits PAID Earnings.. so all withdrawn funds are deleted from the DB after 10 days, of course if you don't. Withdraw, I can't and won't delete anything.

Aha, well that clears it up a bit, I guess, thanks

but I had a 36 hour run there where I actually did not make any new earnings which caused me to believe that I lost money that had not been withdrawed within 10 days.
Usually I pull in about 2 ZCL per 24 hours, but yesterday and half the day before that I made like 0,3 ZCL in total with no major changes in hashing power, rig downtime or blocks mined..

Check the netstats for zcl.. through the roof because of the upcoming btcp hardfork.. so much more people mining zcl and that means higher difficulty, lower reward for everyone

ocminer

legendary

Activity: 2688

Merit: 1240

The 10 day limit only limits PAID Earnings.. so all withdrawn funds are deleted from the DB after 10 days, of course if you don't. Withdraw, I can't and won't delete anything.

No estimate yet for the API on the older pools, I'm tesing new DB optimizations on some newer pools but performance is still not what I'm expecting. I might do some rate limiting on the API maybe...

manicminer3018

newbie

Activity: 17

Merit: 0

@l0ud: Unfortunately no, it's also to actual earnings. This was the reason why I created this topic.

@ocminer: Any response please?

manicminer3018

newbie

Activity: 17

Merit: 0

Hi @ocminer, any update on the API, please?

Would be sufficient to get for example last 10 transactions from transaction api (without sum, etc.).

I tried to use curl to log-in but I suppose there is some protection so I'm not able to download transactions in any way.

Your help will be appreciated. Thank you!

ocminer

legendary

Activity: 2688

Merit: 1240

Quote from: manicminer3018 on January 23, 2018, 01:47:05 PM

So the best way is to download and parse html? ;-( Wouldn't be possible to simplify API call only to last 24 hour (or at least 1hour, this would be sufficient too) ?

Hmm, yes .. I need to add rate limiting then.. I'm busy with a few other things currently but will keep it in mind

manicminer3018

newbie

Activity: 17

Merit: 0

So the best way is to download and parse html? ;-( Wouldn't be possible to simplify API call only to last 24 hour (or at least 1hour, this would be sufficient too) ?

ocminer

legendary

Activity: 2688

Merit: 1240

Quote from: manicminer3018 on January 23, 2018, 12:57:17 PM

Ok, now with updated message "Earnings Data is only kept for maximum 10 days" it's clear. So I suppose @ocminer, you are admin, right?

Because gettransactions API is down and earnings is kept only for 10days, what is the best way how to automatically download hour/day income for stats?

PS: Would be sufficient to get "gettransactions" with last 24hour for example. With such data it would be possible to keep track of mining

You can keep track of the earnings on the pool directly, the API was enabled by mistake, I simply forgot to disable that call a while back when I was searching for a performance issue as the query is quite slow on larger pools

manicminer3018

newbie

Activity: 17

Merit: 0

Ok, now with updated message "Earnings Data is only kept for maximum 10 days" it's clear. So I suppose @ocminer, you are admin, right?

Because gettransactions API is down and earnings is kept only for 10days, what is the best way how to automatically download hour/day income for stats?

PS: Would be sufficient to get "gettransactions" with last 24hour for example. With such data it would be possible to keep track of mining

ocminer

legendary

Activity: 2688

Merit: 1240

Quote from: manicminer3018 on January 23, 2018, 11:45:28 AM

In case that data is kept only for 10days, why "Last Month" and "All time" rows at all? But ok, I will try to wait more days what happen. In the meanwhile I will try different pools.

Historical reasons, in newer pools they're removed.. so you only have last 10 days there.

Yes, simply compare pools and you'll see the earnings are the same

sir_blacks

jr. member

Activity: 119

Merit: 3

Ocminer like a joke because your appi & site implementation problem if a Eve player (Eve online game) what it is use to relay on spreadsheet (exel) see how it work site for sure it will wardeck & chase on all galaxy possible

manicminer3018

newbie

Activity: 17

Merit: 0

In case that data is kept only for 10days, why "Last Month" and "All time" rows at all? But ok, I will try to wait more days what happen. In the meanwhile I will try different pools.

ocminer

legendary

Activity: 2688

Merit: 1240

Quote from: manicminer3018 on January 23, 2018, 11:37:41 AM

I tried refresh earning report in new window with keeping the previous results in another tab:

As you can see, this is original report:

and now, this is the new one

As you can see, earning values again changed from 1.78378286ZCL to 1.78138356ZCL

BUT!

Why doesn't changed "Last day" value and "Last week"? Why only "Last month" and "All time"? This is very strange. I don't think this is caused only by confirming.

Also worth mentioning that after I reported this to suprnova they shuted down the API for reading these values but without any response to my questions.

Data is only kept for 10 days and then deleted. Thats why "last month" and "all time" changes - the older data is simply deleted, so your earnings of course decrease because the old, already paid data simply gets purged from the database.

manicminer3018

newbie

Activity: 17

Merit: 0

I tried refresh earning report in new window with keeping the previous results in another tab:

As you can see, this is original report:

https://i.imgur.com/2fHACvR.png

and now, this is the new one

https://i.imgur.com/CeFaldo.png

As you can see, earning values again changed from 1.78378286ZCL to 1.78138356ZCL

BUT!

Why isn't changed "Last day" value and "Last week"? Why only "Last month" and "All time"? This is very strange. I don't think this is caused only by confirming.

Also worth mentioning that after I reported this to suprnova they shuted down the API for reading these values but without any response to my questions.

manicminer3018

newbie

Activity: 17

Merit: 0

Thanks for clarification. This makes sense although it's pretty large portion of mined currency ;-(

When I wrote my first post I had about 1.7994 ZCL. Now, two hours later (without mining anything new) I had 1.7837 ZCL. And the maximum was 1.8118 ZCL about 5 hours before.

So, the 0.0124 ZCL reduction after ~5hours when I mined ~0.49991671/day ZCL, about 2.5%

As you stated, I checked my transactions. But numbers in the transaction are the same before and also after reduction (as you can see in attached pastebin links). This is still confusing for me.

ocminer

legendary

Activity: 2688

Merit: 1240

The coins can't just disappear, check your Transactions, there are Credits and Debits, with every confirmation a portion of the coins gets paid so of course sometimes you see less and sometimes you see more as you only have a "gliding view" of the last XXX transactions.

Create a new account, mine in the new account for 1-2 h and you'll see that you actually only get more in your account because payments have not yet started as the coins are not yet confirmed. Then wait until the coins mature and you get paid - you'll see the balance on the account get less and then it'll get more again because new coins are mined etc..

manicminer3018

newbie

Activity: 17

Merit: 0

Unfortunately, nothing is cool. Dashboard displays exactly same values like in API. So if I refresh the dashboard, I see like money is disappearing.

PS: And now suprnova stats API stopped working at all. Last ~8 minutes returns only blank page.

ocminer

legendary

Activity: 2688

Merit: 1240

Just compare the TX Summary from the Dashboard on the pool itself, the API is deprecated since there's a precision problem with small numbers as you can see 5.4e-7 for example means 0.000000054 coins

If you earnings on the dashboard are cool, all is good

manicminer3018

newbie

Activity: 17

Merit: 0

Few more observations:

This is transaction log from 2018-01-23 15:20:26
https://pastebin.com/qxCcWZwV

And this one minute later from 2018-01-23 15:21:47
https://pastebin.com/DcB9nvaR

Two almost exact transaction lists generated one minute each other. The only difference is in number of confirmations and total amount. How is this possible??

https://www.dropbox.com/s/myuqynoifvpw4mo/TOTALCMD_2018-01-23_15-29-00.png?dl=0

One minute diff and my account lost 0.002 ZCL. Also Fee was lowered, so it wasn't caused by fee.

Topic: Strange behavior of Suprnova total-earnings stats (Read 221 times)