PokerTracker

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 ?

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?

I have same problem as ollalla when try to rebuild cache - fatal error.

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.

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. )

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... ^ )

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 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.

send new log, ticket id 152128

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.