Adrian Try setting the interval to run every 2 hours and remove anything more than 2 hours old - please use the admin menu to do this and not a direct edit,
There were indeed past issues (but not quite of the nature that you mention) - and various resolutions. Everything that I am aware of is OK in 4.2.6 and there was one workaround in 4.2.5 and also earlier workarounds for 4.2.x What is your RedBack version, O.S and database (some combinations have specific meaning). Otherwise: a classic error is to run STATEFUL RBOs and to never terminate a session - hence a session never becomes eligible for GC. Typical causes: 1. Using SESSION VARIABLES in IIS to store connection object handles and continually re-using them 2. Storing session data in form data and continually re-using the same form 3. Storing session data in a query string (URL) and people bookmark the URL (invocation uses the same session over and over) 4. IDE mode (possibly ????) and a VERY old version (4.2.3C2 about) and not running a manual GC. 5. Attempting Connection Pooling in java code and re-using session variables (threadsafe, inheritance or usage issue). Useful test: Set GC to run every 999 days and remove anything more than (say) 2 hours old. Run REDBACK.GC at ECL.TCL and compare the count of WWSTATE and WWSESSION before and after. If this clears loads of records then set GC to the reasonable suggested intervals above - if this STILL does not automatically clear down then set GC to the 999 day period and run REDBACK.GC under cron or similar at your required intervals. If you are not on 4.2.5 (minimum) or 4.2.6 then upgrade. NOTE: WWSESSION marches with WWSTATE in the current versions - if you manually clear WWSTATE please clear WWSESSION too. If you upgraded from an earlier version "in situ" then you could have old "debris" in WWSTATE that won't get purged as there is no corresponding record in WWSESSION. (WWSESSION has no records and WWSTATE has some after a GC). Resolution: stop RedBack - clear both - done forever... Regards JayJay ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
