after update to 4.11 PT4 doesn't work

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny

Re: after update to 4.11 PT4 doesn't work

Postby ollalla » Mon May 19, 2014 5:42 pm

got an error: Unable to rebuild cache.
Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: syntax error at or near "{" LINE 26: ...able) AND live_tourney_player.id_live_table = {live_tabl... ^ )

i think my db is destroyd now and i have to create an new one ?
ollalla
 
Posts: 21
Joined: Wed Mar 21, 2012 1:07 pm

Re: after update to 4.11 PT4 doesn't work

Postby themightyjim2k » Mon May 19, 2014 6:07 pm

I'm having the same problem as them, so I thought I would try a cache rebuild. My database is 15 GB, how long is this going to take? Should I stop the cache rebuild and just send you guys a log of the errors I'm experiencing to make sure I don't need to wait through this?
themightyjim2k
 
Posts: 73
Joined: Mon Mar 10, 2008 11:14 am

Re: after update to 4.11 PT4 doesn't work

Postby Xys66 » Mon May 19, 2014 6:15 pm

I have same problem as ollalla when try to rebuild cache - fatal error.
Xys66
 
Posts: 13
Joined: Sun Apr 01, 2012 8:37 am

Re: after update to 4.11 PT4 doesn't work

Postby themightyjim2k » Mon May 19, 2014 6:20 pm

Unable to rebuild cache

Reason: Error: Unable to execute query: Fatal Error;
Reason: Error: (ERROR: out of memory DETAIL: Failed on request of size 8. CONTEXT: PL/pgSQL function "update_cash_cache_playerrange" line 12 at FOR over SELECT rows )




that's what I get when I try to rebuild the cache. this is frustrating.
themightyjim2k
 
Posts: 73
Joined: Mon Mar 10, 2008 11:14 am

Re: after update to 4.11 PT4 doesn't work

Postby themightyjim2k » Mon May 19, 2014 6:23 pm

after I clicked ok after that error it tried to start vacuuming and analyzing my DB. and I get this:

Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: out of memory DETAIL: Failed on request of size 134217726. )
themightyjim2k
 
Posts: 73
Joined: Mon Mar 10, 2008 11:14 am

Re: after update to 4.11 PT4 doesn't work

Postby ollalla » Mon May 19, 2014 6:28 pm

created a new db and try to import a HH but got an error again
Error: PokerStars: Unable to import hand (#116405614018). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: function update_tourney_custom_cache() does not exist LINE 1: SELECT update_tourney_cache();SELECT update_tourney_custom_c... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. )

then i did a rebuild cache on that new db and got same error as on that old db
Unable to rebuild cache.
Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: syntax error at or near "{" LINE 26: ...able) AND live_tourney_player.id_live_table = {live_tabl... ^ )
ollalla
 
Posts: 21
Joined: Wed Mar 21, 2012 1:07 pm

Re: after update to 4.11 PT4 doesn't work

Postby kraada » Mon May 19, 2014 6:44 pm

Jim, Revert Tuning via Housekeeping -> Revert Tuning then try again.

ollalla and Xys66: could either of you create a new log with the error when you try to rebuild a cache and attach it to your ticket and post here when you have? That error is cut off and I need to see everything that's in it to try to figure out the right next step.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: after update to 4.11 PT4 doesn't work

Postby themightyjim2k » Mon May 19, 2014 6:52 pm

kraada wrote:Jim, Revert Tuning via Housekeeping -> Revert Tuning then try again.



in the process of doing this (with logging enabled). Also submitted a support ticket with previous logs.
themightyjim2k
 
Posts: 73
Joined: Mon Mar 10, 2008 11:14 am

Re: after update to 4.11 PT4 doesn't work

Postby ollalla » Mon May 19, 2014 6:55 pm

send new log, ticket id 152128
ollalla
 
Posts: 21
Joined: Wed Mar 21, 2012 1:07 pm

Re: after update to 4.11 PT4 doesn't work

Postby kraada » Mon May 19, 2014 7:15 pm

Thanks ollalla, I'm forwarding your ticket directly to the head of Quality Assurance, flagged urgent and I'll email him directly about it so that we can get a fix for this as soon as possible.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

PreviousNext

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 4 guests

cron