Currency change - check its still running?

[r0bly0ns]

I set off a currency change on my PT4 DB 10 days ago, however it hasn't updated the 'Elapsed time' for 2 days now.

Is there any way of checking its still running and hasn't crashed? (Log files etc..)

Thanks,
Rob.

[kraada]

If you have logging on you can check the end of the log; each line has a timestamp and you can see when the last entry was.

[r0bly0ns]

I don't believe I have PT4 logging enabled (can't see anything in the PT4 install directory being written to).

Anyone know of anything in Postgres I can check?

Windows BTW.

Thanks,
Rob.

[kraada]

It doesn't write to the install directory it's in %userprofile%/Local/PokerTracker 4/ -- it's the text file called PokerTracker4 that's there. PostgreSQL's logging isn't high enough by default to log every query so that won't be sufficient to tell you what's going on there. Do you see CPU time being used in Task Manager for a postgres.exe process?

[r0bly0ns]

Thanks for the feedback.

Logging does not appear to be turned on, however I have managed to get some information out of postgres by querying the pg_stat_activity table.

It is still running as querying this I can see the individual queries being fired off to update the cash_hand_player_statistics table, however it seems incredibly slow. I've been monitoring it all afternoon and it is still processing hands that were created within an hour of the ones it was processing around 4 hours ago....

[kraada]

That does seem incredibly slow. How much data is left? I believe those updates would run in ascending order of id_hand.

[r0bly0ns]

It seems to be stuck in 23:00 - 00:00 in July 4th Last year

pg_stat_activity shows it is currently running the below query (truncated by the output of my program).
"UPDATE cash_hand_player_statistics SET val_curr_conv = '0.66470000' WHERE id_hand IN (139996,140034,140086,139660,140306,140101,140182,139799,139797,140290,140173,140054,139891,139882,139881,139878,140243,140269,140074,139472,139468,139957,139867,139862,140279,139849,139904,139916,140044,140041,140264,139712,139707,140153,140113,139568,140061,139426,140238,140237,140234,140232,140135,139423,140071,139645,139618,139610,139606,139605,140121,140180,140168,140025,140023,140019,140137,140189,140016,140196,139836,139633,139989,139507,139506,139523,139522,140036,139711,139710,139706,140111,139662,140082,139787,139569,139559,139981,140062,140136,140157,140100,140125,139987,139663,139659,139661,139657,139658,139656,139655,139654,139652,139651,139653,139650,139648,139647,139649,139646,139222,139221,140676,140675,140325,140324,140323,140322,139550,139549,139548,139975,139974,139973,139972,139971,139970,139969,139968,139967,139966,139965,139964,139297,139296,139295,139294,139293,139292,139624,139623,139622,139621,139620"

If I look at the date_played and conversion value of any of these hands, they fall between that one hour period (ish), but have had their val_curr_conv set.

I have tried running a query for 1-5th March this year, and that showed all hands in that period have also had their conversion value changed.
If I run the query for 7th March this year (The day I started the process), it shows most have been updated but some seemingly random groups haven't been.
eg:
id_session, date_played, val_curr_conv
368506;"2014-03-07 15:10:53";0.59740000
368469;"2014-03-07 15:10:53";0.59740000
368544;"2014-03-07 15:10:53";0.59740000
368409;"2014-03-07 15:10:53";0.59740000
368382;"2014-03-07 15:10:56";1.00000000
368413;"2014-03-07 15:10:56";1.00000000
368412;"2014-03-07 15:10:56";1.00000000
368381;"2014-03-07 15:10:56";1.00000000
368380;"2014-03-07 15:10:56";1.00000000
368494;"2014-03-07 15:10:56";1.00000000
368385;"2014-03-07 15:10:58";0.59740000
368420;"2014-03-07 15:10:58";0.59740000
368425;"2014-03-07 15:10:58";0.59740000

Does anyone know what order the update actually runs in? Does anyone from PT look at these posts who might be able to ask the developers?

The progress bar was chugging along quite nicely, updating the elapsed time and estimated time values 2 - 3 times a day for 9 days, but hasn't changed now since Sunday morning.

[WhiteRider]

Are there any hands in your database which were played in the currency that you have now set My Currency to? That would explain the "1" values.
What versions of PT4 and PostgreSQL do you have?
Roughly how big is your database?

If it's still running it would be better to let it finish, but of course that depends on how long it is going to take - I wouldn't expect it to take days unless your database is absolutely massive.

[WhiteRider]

I have spoken to one of the developers about this and he suggests that this will not complete and you will need to end the process and run it again.

[r0bly0ns]

Thanks Whiterider

No, all my games are played in $ and I was changing the my currency to £

I am running PT 4.10.9.
The DB is postgres V9.0 and is 47GB according to pgAdmin, which does seem excessively large to me.


If I end the process now, what will the implications be if I use the DB again before running the conversion?