after update to 4.11 PT4 doesn't work

[ollalla]

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 ?

[themightyjim2k]

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?

[Xys66]

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

[themightyjim2k]

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]

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

[ollalla]

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

[kraada]

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.

[themightyjim2k]

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.

[ollalla]

send new log, ticket id 152128

[kraada]

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.