|
|
Post by chris on Jan 12, 2015 19:01:22 GMT
batchoy -- I noticed this one paid up correctly today as expected, and that the rate has been reinstated. The only dangling feature is the accrued interest is still showing as accrued. I didn't mention it yet, as I fully expect it will fix itself overnight and reset to £0.00 (+some pence) tomorrow. If not, then something's gone wrong. This thing of "accrued interest remaining accrued after a payment" seems to happen on glitched loans, and on those that pay a day early. Magic happens at midnight. Indeed there's a recalculation overnight that will automatically correct any issues unless there is a genuine bug. Let me know if it's still a problem in the morning.
|
|
mikeb
Posts: 1,072 
Likes: 472
|
Post by mikeb on Jan 13, 2015 18:42:28 GMT
Magic happened, so nothing to worry about there, today came up with 1 days worth of accrued on the clock.
|
|
mikeb
Posts: 1,072
Likes: 472
|
Post by mikeb on Feb 6, 2015 9:20:46 GMT
chris the accrued interest run has fallen over again, probably tripped over at CWE ?? The first few loans (by most recent) have been updated and nothing beyond. Can you kick it again?
|
|
|
|
Post by chris on Feb 6, 2015 9:35:49 GMT
chris the accrued interest run has fallen over again, probably tripped over at CWE ?? The first few loans (by most recent) have been updated and nothing beyond. Can you kick it again? It tripped up on W**d G****n. It's updating now.
|
|
|
|
Post by Jack Barlow on Feb 7, 2015 8:47:38 GMT
chris, looks like it's tripped again today.
|
|
|
|
Post by chris on Feb 7, 2015 8:55:38 GMT
chris, looks like it's tripped again today. Thanks, it's been kicked. Pesky deadlocks. Changes being made.
|
|
|
|
Post by Jack Barlow on Feb 8, 2015 13:50:35 GMT
chris, looks like it might need another kick today too.
|
|
|
|
Post by chris on Feb 8, 2015 14:04:46 GMT
chris, looks like it might need another kick today too. Done. I've made some more adjustments to try and help it but I think there's a couple of database queries that need restructuring to make deadlocks impossible. As the site grows, and the automated systems grow, there's more things trying to update the database at the same time.
|
|
TFTO
Member of DD Central
Posts: 143
Likes: 71
|
Post by TFTO on Feb 9, 2015 12:14:03 GMT
Did this fail again last night?
|
|
ianb
Posts: 161
Likes: 54
|
Post by ianb on Feb 9, 2015 13:45:13 GMT
summat's gone wrong - loan 87 I got an interest repayment but accrued amount not reset, and principal repayment made but hasn't picked me back up to my target amount. (these reported to dominic)
|
|
mikeb
Posts: 1,072
Likes: 472
|
Post by mikeb on Feb 9, 2015 19:15:22 GMT
Did this fail again last night? Yes. About 15 loans (of 77) haven't updated this time. Random scattering, no particular order. As ianb noted, some have paid up and not reset back to £0.00 (wait for midnight). chris more WD40 needed on the database.
|
|
TFTO
Member of DD Central
Posts: 143
Likes: 71
|
Post by TFTO on Feb 11, 2015 7:28:16 GMT
Accruals wrong again last night! chris Please re-run and put some code in to re-try whenever a deadlock occurs. |
|
|
|
Post by chris on Feb 11, 2015 7:30:19 GMT
Accruals wrong again last night! chris Please re-run and put some code in to re-try whenever a deadlock occurs. There is code to retry when a deadlock occurs. It's occurring frequently as accrued interest is currently stored against each loan unit in what is a very congested table. The plan is to move accrued interest off that table into its own one but that affects a fair bit of display code so isn't that quick a fix.
|
|
|
|
Post by trilby on Feb 12, 2015 13:25:09 GMT
As ianb mentioned, loan 87 repaid principal a couple of days ago which reduced my holding to below my target, but despite my having cash free and units being available in the loan the system hasn't brought me back up to my target. Is this intentional?
|
|
ianb
Posts: 161
Likes: 54
|
Post by ianb on Feb 12, 2015 19:59:59 GMT
I reckon that the problem is still outstanding - my holding on that loan hasn't budged since I spotted the problem early in the week.
|
|
