Hello,
during testing I have found following possible errors:
1) when raising since date filter, calendar is not working properly - after clicking on left or right arrow for changing month PT4 freezes, calendar is hidden - after few seconds PT4 starts to listen again but date filter seems to be activated .. I hope this is not desired functionality
2) adjusted value calculation is extremely slow (in comparison with hem)
3) adjusted value calculation (C net adjusted $) is completely errorneus on 3000 sng super turbo tourneys it gives me 50% adjusted ROI :O - HEM gives me on the same sample about 3% ROI = you are calculating this really bad and it seems to be critical error for me! - or maybe I don't really get what is this calculation for. Is this graph showing me how much I should have won in $?
4) adjusted value calculation (C net adjusted $) is shown only in graph - final value should be listed also in overview on the left side of a graph
PT4 list of possible errors
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
6 posts
• Page 1 of 1
PT4 list of possible errors
by vojtmen » Sat Feb 04, 2012 12:49 pm
- vojtmen
- Posts: 18
- Joined: Wed Feb 02, 2011 4:55 pm
Re: PT4 list of possible errors
by kraada » Sat Feb 04, 2012 1:43 pm
(1) I just tested and am not able to reproduce this behavior. Please reproduce it and attach the PokerTracker4.log file to a support ticket so that we can investigate further for you what is causing this behavior on your system.
(2) Where are you looking for this value that you are finding is slow?
(3) Can you attach one or more of these tournaments to a separate support ticket for us? That will help us investigate to figure out what we can do to improve results in this area.
(4) You can add that value to the graph by clicking the blue Configure link next to the Show Information Box area - that will allow you to add any stat to the information box in the graph that you would like to see.
(2) Where are you looking for this value that you are finding is slow?
(3) Can you attach one or more of these tournaments to a separate support ticket for us? That will help us investigate to figure out what we can do to improve results in this area.
(4) You can add that value to the graph by clicking the blue Configure link next to the Show Information Box area - that will allow you to add any stat to the information box in the graph that you would like to see.
- kraada
- Moderator
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Re: PT4 list of possible errors
by vojtmen » Sun Feb 19, 2012 7:17 am
1) I don't know where the log file is stored ... and don't have time to look for it. (the same behaviour occurs when you select any specific date) - calendar only allows to change a month once - than it is hidden ..
2) In the view stats section under statistics. Other probable error connected with this problem - from time to time very frustrating thing occurs: (for more than 10000 tourneys loaded), when you press view stats button (and you are in statistics section) and have ADJ checkbox checked (probably it is stored from previous session), then PT4 stops listening and it is probably calculating ADJ value for all tourneys .. I have to wait about 20 minutes, until calculation is done (I have very fast computer!). In that period PT4 is not listening .. (maybe some wait/sleep/notify/something corruption /deadlock/raise condition). I am not able to stop calculation - it is always started when you get to statistics section
3) no I don't have time to extract these tourneys from my backup - but I am pretty sure, that when you play some pokerstars sng tourneys (maybe it is only super turbos), you will see how erroneously your software calculates EV.
4) thanks - but I can't test it, because I am still waiting for PT4 to start listening! Do you even know how to work with threads?
5) when I filter (even for 50 tourneys area) tourneys by choosing some area in my graph I have to wait also more than tolerable time (about 30 secs)
Maybe there is sth. with my database (incorrect version?) - I have latest 9.1.2.1 PostgreSQL database and other applications work just fine with it? I have tested my other PSQL database speed and it seems to work just fine. PT4 database is completely new - all tourneys have been loaded after installation of PT4 (I did not use conversion from PT3).
2) In the view stats section under statistics. Other probable error connected with this problem - from time to time very frustrating thing occurs: (for more than 10000 tourneys loaded), when you press view stats button (and you are in statistics section) and have ADJ checkbox checked (probably it is stored from previous session), then PT4 stops listening and it is probably calculating ADJ value for all tourneys .. I have to wait about 20 minutes, until calculation is done (I have very fast computer!). In that period PT4 is not listening .. (maybe some wait/sleep/notify/something corruption /deadlock/raise condition). I am not able to stop calculation - it is always started when you get to statistics section
3) no I don't have time to extract these tourneys from my backup - but I am pretty sure, that when you play some pokerstars sng tourneys (maybe it is only super turbos), you will see how erroneously your software calculates EV.
4) thanks - but I can't test it, because I am still waiting for PT4 to start listening! Do you even know how to work with threads?
5) when I filter (even for 50 tourneys area) tourneys by choosing some area in my graph I have to wait also more than tolerable time (about 30 secs)
Maybe there is sth. with my database (incorrect version?) - I have latest 9.1.2.1 PostgreSQL database and other applications work just fine with it? I have tested my other PSQL database speed and it seems to work just fine. PT4 database is completely new - all tourneys have been loaded after installation of PT4 (I did not use conversion from PT3).
- vojtmen
- Posts: 18
- Joined: Wed Feb 02, 2011 4:55 pm
Re: PT4 list of possible errors
by kraada » Sun Feb 19, 2012 10:55 am
(1) You can find the log file by clicking File --> Show User Data Folder in PT4. The file is in the window that will open and may appear as a text file named PokerTracker4.
(2) If you don't want to see the graphs, might I recommend trying the Summary report? They don't have the graphs and thus if you stay there you won't have to deal with that potential loading time (then if you want to specifically see graphs you can either switch or look to the Graphs page.
(3) We are doing the best we can to fix all errors that we find. Some of these errors can be very nuanced so while we are doing our best the more examples of problems we can get the better.
(4) I have been assured PT4 is a fully multi-threaded application.
(5) That does sound like a long time - again, log files showing query times will help considerably in diagnosing what we can do about this.
We do not officially support PostgreSQL 9.1 - we only officially support as far as 9.0, though lately we haven't been hearing of problems relating to 9.1 there were considerable problems with it early in one of the first 9.1 releases.
(2) If you don't want to see the graphs, might I recommend trying the Summary report? They don't have the graphs and thus if you stay there you won't have to deal with that potential loading time (then if you want to specifically see graphs you can either switch or look to the Graphs page.
(3) We are doing the best we can to fix all errors that we find. Some of these errors can be very nuanced so while we are doing our best the more examples of problems we can get the better.
(4) I have been assured PT4 is a fully multi-threaded application.
(5) That does sound like a long time - again, log files showing query times will help considerably in diagnosing what we can do about this.
We do not officially support PostgreSQL 9.1 - we only officially support as far as 9.0, though lately we haven't been hearing of problems relating to 9.1 there were considerable problems with it early in one of the first 9.1 releases.
- kraada
- Moderator
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Re: PT4 list of possible errors
by vojtmen » Thu Mar 01, 2012 5:02 pm
I am very sorry for my latest rude post. I was very frustrated while I was waiting for calculation results ..
1) thanks. Only error strings I have found:
2012/03/01 21:35:22.518 [00024]: [- Main -][wxWidgets] 21:35:22: Error: Failed to copy the file 'C:\Program Files\PokerTracker 4/Data/Config/HelpMessages.cfg' to 'C:\Users\xxx\AppData\Local\PokerTracker 4/Config/HelpMessages.cfg' (error 2: file not found)
2012/03/01 21:36:33.271 [00099]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_hand_summary.id_hand) as "id_hand", (tourney_hand_summary.id_site) as "id_site", (tourney_hand_summary.hand_no) as "hand_no", (tourney_hand_summary.id_gametype) as "id_gametype_summary", (tourney_hand_summary.flg_note) as "flg_note", (tourney_hand_summary.flg_tag) as "flg_tag", (timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) as "date_played_summary", (tourney_hand_summary.id_blinds) as "id_blinds", (tourney_hand_summary.card_1) as "id_flop1", (tourney_hand_summary.card_2) as "id_flop2", (tourney_hand_summary.card_3) as "id_flop3", (tourney_hand_summary.card_4) as "id_turn", (tourney_hand_summary.card_5) as "id_river", (player_winner.player_name) as "str_winner", (tourney_hand_summary.id_win_hand) as "id_win_hand", (tourney_hand_summary.amt_pot) as "amt_pot" FROM tourney_hand_summary, player player_winner WHERE (player_winner.id_player = tourney_hand_summary.id_winner) AND ((date_trunc('day', ((timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) + INTERVAL '-7 HOURS')) = date_trunc('day', (now() + INTERVAL '-7 HOURS')))) AND (((1=1))) LIMIT 100; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/03/01 21:36:35.305 [00106]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_hand_summary.id_hand) as "id_hand", (tourney_hand_summary.id_site) as "id_site", (tourney_hand_summary.hand_no) as "hand_no", (tourney_hand_summary.id_gametype) as "id_gametype_summary", (tourney_hand_summary.flg_note) as "flg_note", (tourney_hand_summary.flg_tag) as "flg_tag", (timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) as "date_played_summary", (tourney_hand_summary.id_blinds) as "id_blinds", (tourney_hand_summary.card_1) as "id_flop1", (tourney_hand_summary.card_2) as "id_flop2", (tourney_hand_summary.card_3) as "id_flop3", (tourney_hand_summary.card_4) as "id_turn", (tourney_hand_summary.card_5) as "id_river", (player_winner.player_name) as "str_winner", (tourney_hand_summary.id_win_hand) as "id_win_hand", (tourney_hand_summary.amt_pot) as "amt_pot" FROM tourney_hand_summary, player player_winner WHERE (player_winner.id_player = tourney_hand_summary.id_winner) AND ((date_trunc('day', ((timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) + INTERVAL '-7 HOURS')) = date_trunc('day', (now() + INTERVAL '-7 HOURS')))) AND (((1=1))) LIMIT 100; Reason: Fatal Error (ERROR: canceling statement due to user request )
this error is repeated about 10000 times (maybe for every hand) ..
Regarding calendar problem there is following log string:
2012/03/01 21:50:52.039 [99999]: [- Main -][cbiReportOptions] Loading report options...
2012/03/01 21:50:52.194 [00154]: [- Main -][cbiReportOptions] Loaded.
2012/03/01 21:50:52.197 [00004]: [- Main -][cbiReportFilters] Loading report filters...
2012/03/01 21:50:52.245 [00047]: [- Main -][cbiReportFilters] Loaded.
2012/03/01 21:50:52.266 [00022]: [- Main -][wpReportPage] Creating report on demand: Personal Results
2012/03/01 21:50:52.334 [00068]: [- Main -][wpReportPage] Report successfully created.
2012/03/01 21:50:52.404 [00070]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2012/03/01 21:50:52.435 [00030]: [- Main -][StatManager] Unable to use cache due to column: cnt_tourneys (cnt_tourneys)
2012/03/01 21:50:52.440 [00005]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2012/03/01 21:50:52.441 [00002]: [00001180][Query::QueryThread] Thread [0x00001180]: Begin
2012/03/01 21:50:52.441 [00000]: [00001180][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:52.442 [00001]: [00001434][Query::QueryThread] Thread [0x00001434]: Begin
2012/03/01 21:50:52.443 [00000]: [00001434][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:52.443 [00000]: [00001180][Query] Executing SQL (Thread): SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc
2012/03/01 21:50:52.447 [00004]: [00001434][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(distinct tourney_summary.id_tourney)) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))))* 1.0 )/((count(distinct tourney_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) as "cnt_days_played_tourney", (CASE WHEN ( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end)))) * 1.0 )/( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) )) ELSE 0 END) as "net_per_day_curr_conv", (sum(tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty )) as "amt_buyin_ttl", (sum(tourney_results.amt_won + tourney_summary.amt_bounty * tourney_results.cnt_bounty)) as "amt_won" FROM tourney_summary, tourney_results, player WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) GROUP BY (player.player_name)
2012/03/01 21:50:52.512 [00065]: [- Main -][cbiReportFilters] Populating report filters...
2012/03/01 21:50:52.976 [00464]: [00001434][Query] Query execution time: 529.23046085 ms
2012/03/01 21:50:59.358 [06382]: [- Main -][Query] Cancelling query...
2012/03/01 21:50:59.407 [00049]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/03/01 21:50:59.408 [00000]: [00001180][Query] Query execution time: 6965.16442732 ms
2012/03/01 21:50:59.408 [00000]: [- Main -][PostgresConnection] [0x07fb3778] Disconnecting from database: PT4_DB
2012/03/01 21:50:59.408 [00000]: [- Main -][PostgresConnection] Connecting to database: PT4_DB
2012/03/01 21:50:59.460 [00052]: [- Main -][PostgresConnection] [0x07fb3778] Successfully connected to: PT4_DB [153398328] (PostgreSQL version 90102)
2012/03/01 21:50:59.476 [00016]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2012/03/01 21:50:59.490 [00014]: [- Main -][StatManager] Unable to use cache due to column: cnt_tourneys (cnt_tourneys)
2012/03/01 21:50:59.495 [00005]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2012/03/01 21:50:59.497 [00002]: [00001180][Query::QueryThread] Thread [0x00001180]: Begin
2012/03/01 21:50:59.497 [00000]: [00001180][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:59.499 [00002]: [00001180][Query] Executing SQL (Thread): SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_summary, tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (((tourney_summary.date_start >= '2012/03/01 06:00:00'))) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc
2012/03/01 21:50:59.499 [00000]: [00001434][Query::QueryThread] Thread [0x00001434]: Begin
2012/03/01 21:50:59.499 [00000]: [00001434][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:59.524 [00025]: [00001434][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(distinct tourney_summary.id_tourney)) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))))* 1.0 )/((count(distinct tourney_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) as "cnt_days_played_tourney", (CASE WHEN ( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end)))) * 1.0 )/( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) )) ELSE 0 END) as "net_per_day_curr_conv", (sum(tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty )) as "amt_buyin_ttl", (sum(tourney_results.amt_won + tourney_summary.amt_bounty * tourney_results.cnt_bounty)) as "amt_won" FROM tourney_summary, tourney_results, player WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (((tourney_summary.date_start >= '2012/03/01 06:00:00'))) GROUP BY (player.player_name)
2012/03/01 21:50:59.559 [00035]: [00001434][Query] Query execution time: 34.88173776 ms
2012/03/01 21:51:02.935 [03376]: [- Main -][Query] Cancelling query...
2012/03/01 21:51:02.984 [00049]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_summary, tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (((tourney_summary.date_start >= '2012/03/01 06:00:00'))) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/03/01 21:51:02.984 [00000]: [00001180][Query] Query execution time: 3485.26397908 ms
2012/03/01 21:51:02.984 [00000]: [- Main -][PostgresConnection] [0x07fb3778] Disconnecting from database: PT4_DB
2012/03/01 21:51:02.984 [00000]: [- Main -][PostgresConnection] Connecting to database: PT4_DB
2012/03/01 21:51:03.036 [00052]: [- Main -][PostgresConnection] [0x07fb3778] Successfully connected to: PT4_DB [153398328] (PostgreSQL version 90102)
2012/03/01 21:51:03.052 [00016]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2012/03/01 21:51:03.066 [00014]: [- Main -][StatManager] Unable to use cache due to column: cnt_tourneys (cnt_tourneys)
2012/03/01 21:51:03.071 [00004]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2012/03/01 21:51:03.073 [00003]: [00001180][Query::QueryThread] Thread [0x00001180]: Begin
2012/03/01 21:51:03.074 [00000]: [00001180][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:51:03.075 [00001]: [00001180][Query] Executing SQL (Thread): SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_summary, tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (((tourney_summary.date_start >= '2012/02/01 06:00:00'))) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc
2012/03/01 21:51:03.075 [00000]: [00001434][Query::QueryThread] Thread [0x00001434]: Begin
2012/03/01 21:51:03.075 [00000]: [00001434][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:51:03.080 [00005]: [00001434][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(distinct tourney_summary.id_tourney)) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))))* 1.0 )/((count(distinct tourney_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) as "cnt_days_played_tourney", (CASE WHEN ( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end)))) * 1.0 )/( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) )) ELSE 0 END) as "net_per_day_curr_conv", (sum(tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty )) as "amt_buyin_ttl", (sum(tourney_results.amt_won + tourney_summary.amt_bounty * tourney_results.cnt_bounty)) as "amt_won" FROM tourney_summary, tourney_results, player WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (((tourney_summary.date_start >= '2012/02/01 06:00:00'))) GROUP BY (player.player_name)
2012/03/01 21:51:03.206 [00126]: [00001434][Query] Query execution time: 125.32423814 ms
2012/03/01 21:51:07.395 [04190]: [00001180][Query] Query execution time: 4320.70318993 ms
2012/03/01 21:51:07.545 [00149]: [00001180][ptQueryCtrlBase::Populate] Thread [0x00001180]: Begin
2012/03/01 21:51:07.586 [00041]: [00001180][PostgresConnection] [0x07fb3778] Disconnecting from database: PT4_DB
2012/03/01 21:51:07.586 [00000]: [00001180][PostgresConnection] Connecting to database: PT4_DB
2012/03/01 21:51:07.690 [00105]: [00001180][PostgresConnection] [0x07fb3778] Successfully connected to: PT4_DB [153398328] (PostgreSQL version 90102)
2) thanks I will try that
3) ok, I will send you (or post you some problem tourneys) when I get to my tourney txt log files' backup
4) it occurs only on random basis so it might be some rare raise condition .. I will look into my log files when it occurs again and send you related part of it.
5) the same here
1) thanks. Only error strings I have found:
2012/03/01 21:35:22.518 [00024]: [- Main -][wxWidgets] 21:35:22: Error: Failed to copy the file 'C:\Program Files\PokerTracker 4/Data/Config/HelpMessages.cfg' to 'C:\Users\xxx\AppData\Local\PokerTracker 4/Config/HelpMessages.cfg' (error 2: file not found)
2012/03/01 21:36:33.271 [00099]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_hand_summary.id_hand) as "id_hand", (tourney_hand_summary.id_site) as "id_site", (tourney_hand_summary.hand_no) as "hand_no", (tourney_hand_summary.id_gametype) as "id_gametype_summary", (tourney_hand_summary.flg_note) as "flg_note", (tourney_hand_summary.flg_tag) as "flg_tag", (timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) as "date_played_summary", (tourney_hand_summary.id_blinds) as "id_blinds", (tourney_hand_summary.card_1) as "id_flop1", (tourney_hand_summary.card_2) as "id_flop2", (tourney_hand_summary.card_3) as "id_flop3", (tourney_hand_summary.card_4) as "id_turn", (tourney_hand_summary.card_5) as "id_river", (player_winner.player_name) as "str_winner", (tourney_hand_summary.id_win_hand) as "id_win_hand", (tourney_hand_summary.amt_pot) as "amt_pot" FROM tourney_hand_summary, player player_winner WHERE (player_winner.id_player = tourney_hand_summary.id_winner) AND ((date_trunc('day', ((timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) + INTERVAL '-7 HOURS')) = date_trunc('day', (now() + INTERVAL '-7 HOURS')))) AND (((1=1))) LIMIT 100; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/03/01 21:36:35.305 [00106]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_hand_summary.id_hand) as "id_hand", (tourney_hand_summary.id_site) as "id_site", (tourney_hand_summary.hand_no) as "hand_no", (tourney_hand_summary.id_gametype) as "id_gametype_summary", (tourney_hand_summary.flg_note) as "flg_note", (tourney_hand_summary.flg_tag) as "flg_tag", (timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) as "date_played_summary", (tourney_hand_summary.id_blinds) as "id_blinds", (tourney_hand_summary.card_1) as "id_flop1", (tourney_hand_summary.card_2) as "id_flop2", (tourney_hand_summary.card_3) as "id_flop3", (tourney_hand_summary.card_4) as "id_turn", (tourney_hand_summary.card_5) as "id_river", (player_winner.player_name) as "str_winner", (tourney_hand_summary.id_win_hand) as "id_win_hand", (tourney_hand_summary.amt_pot) as "amt_pot" FROM tourney_hand_summary, player player_winner WHERE (player_winner.id_player = tourney_hand_summary.id_winner) AND ((date_trunc('day', ((timezone('UTC', tourney_hand_summary.date_played + INTERVAL '0 HOURS')) + INTERVAL '-7 HOURS')) = date_trunc('day', (now() + INTERVAL '-7 HOURS')))) AND (((1=1))) LIMIT 100; Reason: Fatal Error (ERROR: canceling statement due to user request )
this error is repeated about 10000 times (maybe for every hand) ..
Regarding calendar problem there is following log string:
2012/03/01 21:50:52.039 [99999]: [- Main -][cbiReportOptions] Loading report options...
2012/03/01 21:50:52.194 [00154]: [- Main -][cbiReportOptions] Loaded.
2012/03/01 21:50:52.197 [00004]: [- Main -][cbiReportFilters] Loading report filters...
2012/03/01 21:50:52.245 [00047]: [- Main -][cbiReportFilters] Loaded.
2012/03/01 21:50:52.266 [00022]: [- Main -][wpReportPage] Creating report on demand: Personal Results
2012/03/01 21:50:52.334 [00068]: [- Main -][wpReportPage] Report successfully created.
2012/03/01 21:50:52.404 [00070]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2012/03/01 21:50:52.435 [00030]: [- Main -][StatManager] Unable to use cache due to column: cnt_tourneys (cnt_tourneys)
2012/03/01 21:50:52.440 [00005]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2012/03/01 21:50:52.441 [00002]: [00001180][Query::QueryThread] Thread [0x00001180]: Begin
2012/03/01 21:50:52.441 [00000]: [00001180][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:52.442 [00001]: [00001434][Query::QueryThread] Thread [0x00001434]: Begin
2012/03/01 21:50:52.443 [00000]: [00001434][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:52.443 [00000]: [00001180][Query] Executing SQL (Thread): SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc
2012/03/01 21:50:52.447 [00004]: [00001434][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(distinct tourney_summary.id_tourney)) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))))* 1.0 )/((count(distinct tourney_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) as "cnt_days_played_tourney", (CASE WHEN ( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end)))) * 1.0 )/( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) )) ELSE 0 END) as "net_per_day_curr_conv", (sum(tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty )) as "amt_buyin_ttl", (sum(tourney_results.amt_won + tourney_summary.amt_bounty * tourney_results.cnt_bounty)) as "amt_won" FROM tourney_summary, tourney_results, player WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) GROUP BY (player.player_name)
2012/03/01 21:50:52.512 [00065]: [- Main -][cbiReportFilters] Populating report filters...
2012/03/01 21:50:52.976 [00464]: [00001434][Query] Query execution time: 529.23046085 ms
2012/03/01 21:50:59.358 [06382]: [- Main -][Query] Cancelling query...
2012/03/01 21:50:59.407 [00049]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/03/01 21:50:59.408 [00000]: [00001180][Query] Query execution time: 6965.16442732 ms
2012/03/01 21:50:59.408 [00000]: [- Main -][PostgresConnection] [0x07fb3778] Disconnecting from database: PT4_DB
2012/03/01 21:50:59.408 [00000]: [- Main -][PostgresConnection] Connecting to database: PT4_DB
2012/03/01 21:50:59.460 [00052]: [- Main -][PostgresConnection] [0x07fb3778] Successfully connected to: PT4_DB [153398328] (PostgreSQL version 90102)
2012/03/01 21:50:59.476 [00016]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2012/03/01 21:50:59.490 [00014]: [- Main -][StatManager] Unable to use cache due to column: cnt_tourneys (cnt_tourneys)
2012/03/01 21:50:59.495 [00005]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2012/03/01 21:50:59.497 [00002]: [00001180][Query::QueryThread] Thread [0x00001180]: Begin
2012/03/01 21:50:59.497 [00000]: [00001180][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:59.499 [00002]: [00001180][Query] Executing SQL (Thread): SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_summary, tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (((tourney_summary.date_start >= '2012/03/01 06:00:00'))) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc
2012/03/01 21:50:59.499 [00000]: [00001434][Query::QueryThread] Thread [0x00001434]: Begin
2012/03/01 21:50:59.499 [00000]: [00001434][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:50:59.524 [00025]: [00001434][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(distinct tourney_summary.id_tourney)) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))))* 1.0 )/((count(distinct tourney_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) as "cnt_days_played_tourney", (CASE WHEN ( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end)))) * 1.0 )/( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) )) ELSE 0 END) as "net_per_day_curr_conv", (sum(tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty )) as "amt_buyin_ttl", (sum(tourney_results.amt_won + tourney_summary.amt_bounty * tourney_results.cnt_bounty)) as "amt_won" FROM tourney_summary, tourney_results, player WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (((tourney_summary.date_start >= '2012/03/01 06:00:00'))) GROUP BY (player.player_name)
2012/03/01 21:50:59.559 [00035]: [00001434][Query] Query execution time: 34.88173776 ms
2012/03/01 21:51:02.935 [03376]: [- Main -][Query] Cancelling query...
2012/03/01 21:51:02.984 [00049]: [00001180][PostgresConnection (Error)] Unable to execute query: SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_summary, tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (((tourney_summary.date_start >= '2012/03/01 06:00:00'))) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/03/01 21:51:02.984 [00000]: [00001180][Query] Query execution time: 3485.26397908 ms
2012/03/01 21:51:02.984 [00000]: [- Main -][PostgresConnection] [0x07fb3778] Disconnecting from database: PT4_DB
2012/03/01 21:51:02.984 [00000]: [- Main -][PostgresConnection] Connecting to database: PT4_DB
2012/03/01 21:51:03.036 [00052]: [- Main -][PostgresConnection] [0x07fb3778] Successfully connected to: PT4_DB [153398328] (PostgreSQL version 90102)
2012/03/01 21:51:03.052 [00016]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2012/03/01 21:51:03.066 [00014]: [- Main -][StatManager] Unable to use cache due to column: cnt_tourneys (cnt_tourneys)
2012/03/01 21:51:03.071 [00004]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2012/03/01 21:51:03.073 [00003]: [00001180][Query::QueryThread] Thread [0x00001180]: Begin
2012/03/01 21:51:03.074 [00000]: [00001180][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:51:03.075 [00001]: [00001180][Query] Executing SQL (Thread): SELECT (sum(tourney_hand_player_statistics.amt_won)) as "amt_chips_won", (sum(tourney_hand_player_statistics.amt_expected_won)) as "amt_expected_won", (tourney_hand_player_statistics.id_hand) as "id_hand", (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) as "date" FROM tourney_summary, tourney_hand_player_statistics WHERE (tourney_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (((tourney_summary.date_start >= '2012/02/01 06:00:00'))) GROUP BY (tourney_hand_player_statistics.id_hand), (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) ORDER BY (timezone('UTC', tourney_hand_player_statistics.date_played + INTERVAL '-7 HOURS')) asc
2012/03/01 21:51:03.075 [00000]: [00001434][Query::QueryThread] Thread [0x00001434]: Begin
2012/03/01 21:51:03.075 [00000]: [00001434][Query] Connecting to database: PokerTracker 4 DB
2012/03/01 21:51:03.080 [00005]: [00001434][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(distinct tourney_summary.id_tourney)) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))))* 1.0 )/((count(distinct tourney_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) as "cnt_days_played_tourney", (CASE WHEN ( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) ) <> 0 THEN (( ((sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end)))-(sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end)))) * 1.0 )/( (count( distinct date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-7 HOURS')))) )) ELSE 0 END) as "net_per_day_curr_conv", (sum(tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty )) as "amt_buyin_ttl", (sum(tourney_results.amt_won + tourney_summary.amt_bounty * tourney_results.cnt_bounty)) as "amt_won" FROM tourney_summary, tourney_results, player WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='xxx' AND id_site='100')) AND (((tourney_summary.date_start >= '2012/02/01 06:00:00'))) GROUP BY (player.player_name)
2012/03/01 21:51:03.206 [00126]: [00001434][Query] Query execution time: 125.32423814 ms
2012/03/01 21:51:07.395 [04190]: [00001180][Query] Query execution time: 4320.70318993 ms
2012/03/01 21:51:07.545 [00149]: [00001180][ptQueryCtrlBase::Populate] Thread [0x00001180]: Begin
2012/03/01 21:51:07.586 [00041]: [00001180][PostgresConnection] [0x07fb3778] Disconnecting from database: PT4_DB
2012/03/01 21:51:07.586 [00000]: [00001180][PostgresConnection] Connecting to database: PT4_DB
2012/03/01 21:51:07.690 [00105]: [00001180][PostgresConnection] [0x07fb3778] Successfully connected to: PT4_DB [153398328] (PostgreSQL version 90102)
2) thanks I will try that
3) ok, I will send you (or post you some problem tourneys) when I get to my tourney txt log files' backup
4) it occurs only on random basis so it might be some rare raise condition .. I will look into my log files when it occurs again and send you related part of it.
5) the same here
- vojtmen
- Posts: 18
- Joined: Wed Feb 02, 2011 4:55 pm
Re: PT4 list of possible errors
by WhiteRider » Fri Mar 02, 2012 4:15 am
"ERROR: canceling statement due to user request" means that the query was cancelled - probably because you changed to another report or something.
Please attach the full log file to a Support Ticket so that we have all of the information it contains (you can compress it if it is too big to upload directly, which is a 5MB limit) and describe the exact problem that you see and the time you saw it. You can also attach screenshots to help describe the problem.
Please attach the full log file to a Support Ticket so that we have all of the information it contains (you can compress it if it is too big to upload directly, which is a 5MB limit) and describe the exact problem that you see and the time you saw it. You can also attach screenshots to help describe the problem.
- WhiteRider
- Moderator
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
6 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 15 guests
