by Barlin63 » Thu Nov 22, 2012 7:03 pm
Ticket submitted with log file loaded with errors like:
2012/11/22 18:52:10.664 [00000]: [0000086C][PostgresConnection (Error)] Unable to execute query: SELECT (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", (sum( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')) as "tourney_date_start", (tourney_summary.id_tourney) as "id_tourney_summary", (tourney_results.val_finish) as "val_finish", (tourney_results.id_tourney) as "__gph__id_tourney", (tourney_results.date_start) as "__gph__tourney_date", (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" FROM tourney_hand_player_statistics, tourney_results, tourney_summary WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='barlin63' AND id_site='100')) AND (tourney_hand_player_statistics.id_tourney = tourney_results.id_tourney AND tourney_hand_player_statistics.id_player = tourney_results.id_player) AND ((tourney_hand_player_statistics.id_gametype = 1)) GROUP BY (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')), (tourney_summary.id_tourney), (tourney_results.val_finish), (tourney_results.id_tourney), (tourney_results.date_start) ORDER BY __gph__tourney_date asc, __gph__id_tourney asc; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/11/22 18:52:10.664 [00000]: [0000086C][Query] Query execution time: 21.83661497 ms
2012/11/22 18:52:10.664 [00000]: [0000086C][Query] Query canceled.
BTW I did not request to cancel a query.