Writing this out has helped I'm going to look at the ACTUAL stored procedure in the database see if it's different.
I was right on the money the ACTUAL stored procedure running was incorrect!
Fast BTC payout enabled again!
Topic: [20 gh] NMCBit pool 3% fee prop 6.6% PPS - page 6. (Read 63735 times)
I was right on the money the ACTUAL stored procedure running was incorrect!
Fast BTC payout enabled again!
Both NMC and BTC are limited. seems to be intermittent
Are you having problems, I fixed that issue are you saying you did not get paid or what please give details.
My balance for BTC is now 0, NMC has not changed. Hitting withdraw on either NMC or BTC has the same effect...page spins...fails to load. Only difference between the two is that the BTC balance is now 0and is showing a Tx payment, but no Txid. NMC balance does not change on withdraw, but BTC went to 0. No transaction pending in my client or on bitcoincharts.
PM sent for username.
PM sent for username.
You should be good now.
Sorry for all the trouble.
Davinci
Confirmed.
Able to withdraw both BTC and NMC...no more timing out.
+1
Both NMC and BTC are limited. seems to be intermittent
I have shut down payouts for BTC for now as the following query keeps failing for proportional payouts...
Yet PPS works fine and so does NMC payouts yet they have the exact same query here is the btc PPS query that works...
I'm staring at the code looking for the flaw if it works for PPS it should work for prop but it does not when I manually do it by replacing the variables with live data it works.
Also the failed result is even stranger... the sum of all works and shares are inserted into balance_user_id number 0 (zero) and the sum of the shares are correct but not the sum of the balance so I know for sure the workerhistory table is correct at the time the query. Also PPS insert is executed after Porp query is executed.
At first I thought that I was using the user_id column in workerhistory that happens to be 0 (zero) but I am not look at the code. Writing this out has helped I'm going to look at the ACTUAL stored procedure in the database see if it's different.
Thanks for reading my problem solving process if you see anything let me know.
Instant balance update has been a bitch.
Code:
INSERT INTO btc_balance (balance_user_id, balance, block_id, shares, pps, ppsamount)
SELECT u.user_id, sum(wh.shares)/lShares * lBlockAmount as balance, lBlock_id, sum(wh.shares) as shares, 0 as pps, 0 as ppsamount
FROM user u, pool_worker pw, workerhistory wh
WHERE u.user_id = pw.user_id AND pw.pool_worker_id = wh.worker_id AND
wh.block_id = lBlock_id and wh.chain_id = aBlockChain AND pw.pps = 0
GROUP BY u.user_id;
Yet PPS works fine and so does NMC payouts yet they have the exact same query here is the btc PPS query that works...
Code:
INSERT INTO btc_balance (balance_user_id, balance, block_id, shares, pps, ppsamount)
SELECT u.user_id, sum(wh.shares) * lPPSAmount as balance, lBlock_id, sum(wh.shares) as shares, 1 as pps, lPPSAmount as ppsamount
FROM user u, pool_worker pw, workerhistory wh
WHERE u.user_id = pw.user_id AND pw.pool_worker_id = wh.worker_id AND
wh.block_id = lBlock_id and wh.chain_id = aBlockChain AND pw.pps = 1
GROUP BY u.user_id;
I'm staring at the code looking for the flaw if it works for PPS it should work for prop but it does not when I manually do it by replacing the variables with live data it works.
Also the failed result is even stranger... the sum of all works and shares are inserted into balance_user_id number 0 (zero) and the sum of the shares are correct but not the sum of the balance so I know for sure the workerhistory table is correct at the time the query. Also PPS insert is executed after Porp query is executed.
At first I thought that I was using the user_id column in workerhistory that happens to be 0 (zero) but I am not look at the code. Writing this out has helped I'm going to look at the ACTUAL stored procedure in the database see if it's different.
Thanks for reading my problem solving process if you see anything let me know.
Instant balance update has been a bitch.
It would seem these blocks where not paid proportionally yet...
2011-11-11 10:41:51 509,541 1 03:28:23 hours
2011-11-11 07:13:28 149,399 16 01:08:51 hours
2011-11-11 06:04:37 1,508,424 24 28:08:10 hours
fixing....
2011-11-11 10:41:51 509,541 1 03:28:23 hours
2011-11-11 07:13:28 149,399 16 01:08:51 hours
2011-11-11 06:04:37 1,508,424 24 28:08:10 hours
fixing....
My balance for BTC is now 0, NMC has not changed. Hitting withdraw on either NMC or BTC has the same effect...page spins...fails to load. Only difference between the two is that the BTC balance is now 0and is showing a Tx payment, but no Txid. NMC balance does not change on withdraw, but BTC went to 0. No transaction pending in my client or on bitcoincharts.
PM sent for username.
PM sent for username.
You should be good now.
Sorry for all the trouble.
Davinci
Confirmed.
Able to withdraw both BTC and NMC...no more timing out.
+1
great, i knew it would get resolved eitherway 
My balance for BTC is now 0, NMC has not changed. Hitting withdraw on either NMC or BTC has the same effect...page spins...fails to load. Only difference between the two is that the BTC balance is now 0and is showing a Tx payment, but no Txid. NMC balance does not change on withdraw, but BTC went to 0. No transaction pending in my client or on bitcoincharts.
PM sent for username.
PM sent for username.
You should be good now.
Sorry for all the trouble.
Davinci
Looks like trying to withdraw NMC causes page to keep "loading" but, fails to "404 Not Found". My NMC balance never changed.
Trying to withdraw BTC...same effect as NMC...except now my balance is 0.
=/
That was easy, I deleted the web site from the security group to access the coin daemons (it explains other issues I was seeing). Your balance should not be zero because it would have failed to check if there was enough NMC. Well if it truly failed to send and reduced your balance there will be no Tx number let me know if you see a Tx number for the NMC withdrawal.Trying to withdraw BTC...same effect as NMC...except now my balance is 0.
=/
If you don't I will delete the withdrawal record and you will be good to go.
Let me know your username as well.
Cheers
Davinci
My balance for BTC is now 0, NMC has not changed. Hitting withdraw on either NMC or BTC has the same effect...page spins...fails to load. Only difference between the two is that the BTC balance is now 0and is showing a Tx payment, but no Txid. NMC balance does not change on withdraw, but BTC went to 0. No transaction pending in my client or on bitcoincharts.
PM sent for username.
Looks like trying to withdraw NMC causes page to keep "loading" but, fails to "404 Not Found". My NMC balance never changed.
Trying to withdraw BTC...same effect as NMC...except now my balance is 0.
=/
That was easy, I deleted the web site from the security group to access the coin daemons (it explains other issues I was seeing). Your balance should not be zero because it would have failed to check if there was enough NMC. Well if it truly failed to send and reduced your balance there will be no Tx number let me know if you see a Tx number for the NMC withdrawal.Trying to withdraw BTC...same effect as NMC...except now my balance is 0.
=/
If you don't I will delete the withdrawal record and you will be good to go.
Let me know your username as well.
Cheers
Davinci
Looks like trying to withdraw NMC causes page to keep "loading" but, fails to "404 Not Found". My NMC balance never changed.
Trying to withdraw BTC...same effect as NMC...except now my balance is 0.
=/
Trying to withdraw BTC...same effect as NMC...except now my balance is 0.
=/
I'm having trouble with block...
2011-11-08 20:22:10 193,305 33 01:31:23 hours
I will have to rewrite the payout system something is not right I need to figure it out.
I will have it fixed later tonight EST.
Don't worry I have a Shares table and a workerhistory table with the summaries and it's correct the issue is deleted workers and computer times going off greater than I expect they would in a week.
sorry for the inconvenience.
2011-11-08 20:22:10 193,305 33 01:31:23 hours
I will have to rewrite the payout system something is not right I need to figure it out.
I will have it fixed later tonight EST.
Don't worry I have a Shares table and a workerhistory table with the summaries and it's correct the issue is deleted workers and computer times going off greater than I expect they would in a week.
sorry for the inconvenience.
Seems to have skipped payment on 2 of the fast blocks for me.
I was in the rounds fully for these blocks:
2011-11-08 20:34:47 25,660 30 00:12:37 hours
2011-11-08 20:22:10 193,305 33 01:31:23 hours
However my most recent block credits were for this block:
2011-11-08 22:35:06 250,068 14 02:00:19 hours
Are you having issues or atleast looking into this ?
I was in the rounds fully for these blocks:
2011-11-08 20:34:47 25,660 30 00:12:37 hours
2011-11-08 20:22:10 193,305 33 01:31:23 hours
However my most recent block credits were for this block:
2011-11-08 22:35:06 250,068 14 02:00:19 hours
Are you having issues or atleast looking into this ?
Yep I have checked it and it did skip those blocks looking into it and have marked them as unpaid.
Seems to have skipped payment on 2 of the fast blocks for me.
I was in the rounds fully for these blocks:
2011-11-08 20:34:47 25,660 30 00:12:37 hours
2011-11-08 20:22:10 193,305 33 01:31:23 hours
However my most recent block credits were for this block:
2011-11-08 22:35:06 250,068 14 02:00:19 hours
Are you having issues or atleast looking into this ?
I was in the rounds fully for these blocks:
2011-11-08 20:34:47 25,660 30 00:12:37 hours
2011-11-08 20:22:10 193,305 33 01:31:23 hours
However my most recent block credits were for this block:
2011-11-08 22:35:06 250,068 14 02:00:19 hours
Are you having issues or atleast looking into this ?
A few rounds back (maybe 4 days) I had my "BTC Value" at 9. Then the round continued onward and it decreased over time. No more than an hour before the round ended I still had about 2.7, but only got paid for .0005-.001 on the round. Something seems fishy.
Sorry about the size I can't figure out how to make it smaller in the tags.
Seems to have skipped payment on 2 of the fast blocks for me.
I was in the rounds fully for these blocks:
2011-11-08 20:34:47 25,660 30 00:12:37 hours
2011-11-08 20:22:10 193,305 33 01:31:23 hours
However my most recent block credits were for this block:
2011-11-08 22:35:06 250,068 14 02:00:19 hours
Are you having issues or atleast looking into this ?
I was in the rounds fully for these blocks:
2011-11-08 20:34:47 25,660 30 00:12:37 hours
2011-11-08 20:22:10 193,305 33 01:31:23 hours
However my most recent block credits were for this block:
2011-11-08 22:35:06 250,068 14 02:00:19 hours
Are you having issues or atleast looking into this ?
Website is running really slow and sluggish right now...is everything ok ?
I'm trying to figure out why it sometimes does this I know how to get it to do slow down but not sure of the solution. Eventually I will figure it out I always do. Those name coins are mine
Just wanted to hear that. You are greedy like hell
One man's greed is another mans need to pay the bills and build something of value.
A man making $2 a day thinks all of us is greedy like hell.
How about when it's not a matter of greed but deceit? I guess whatever pays the bill is good?
Gotta love the low stale numbers for sure. You talking about the banking system right? It's designed to transfer wealth from the poor, middle class and those that don't know how it works to those that do understand it to keep them wealthy and in power.
This is the 21st century method of being a king without having the public know that you're family rules the land. I think that would be the downfall of the Rothschilds if someone got them to show off how much they have and control sort of like on a few good men but on a larger scale like ordered the US Army to attach a country to show off they can do that.
I think that would end them.
Banking system included I suppose for sure. They fall in this catagory like no other. It was more of a generalized comment on how the world tend to face the morality of issues and bow to power/control/profit.
Website is running really slow and sluggish right now...is everything ok ?
Those name coins are mine
Just wanted to hear that. You are greedy like hell
One man's greed is another mans need to pay the bills and build something of value.
A man making $2 a day thinks all of us is greedy like hell.
How about when it's not a matter of greed but deceit? I guess whatever pays the bill is good?
Gotta love the low stale numbers for sure. You talking about the banking system right? It's designed to transfer wealth from the poor, middle class and those that don't know how it works to those that do understand it to keep them wealthy and in power.
This is the 21st century method of being a king without having the public know that you're family rules the land. I think that would be the downfall of the Rothschilds if someone got them to show off how much they have and control sort of like on a few good men but on a larger scale like ordered the US Army to attach a country to show off they can do that.
I think that would end them.
Those name coins are mine
Just wanted to hear that. You are greedy like hell
One man's greed is another mans need to pay the bills and build something of value.
A man making $2 a day thinks all of us is greedy like hell.
How about when it's not a matter of greed but deceit? I guess whatever pays the bill is good?
Gotta love the low stale numbers for sure. Jump to: