How to resolve "All buckets for <your cached resource> are in use! Cannot perform cache refresh" ?
Article ID: KB0070694
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported versions |
Description
How to resolve "All buckets for <your cached resource> are in use! Cannot perform cache refresh" ?
Issue/Introduction
How to resolve "All buckets for are in use! Cannot perform cache refresh" ?
Resolution
1. Look at all the rows in the cache_status table, WHERE resourceid = <your cached resource>
2. If you see a row for every configured bucket with a status of C or A, then you may have an existing client session that is still connected to TDV and holding a read lock on that bucket with a status of C.
3. Clear out the completed sessions and check if that releases any buckets.
4. If you are permitted, clear the cache and look for any rows in the cache status table where the status is still C. Clearing all rows with the Status C should resolve the issue.
2. If you see a row for every configured bucket with a status of C or A, then you may have an existing client session that is still connected to TDV and holding a read lock on that bucket with a status of C.
3. Clear out the completed sessions and check if that releases any buckets.
4. If you are permitted, clear the cache and look for any rows in the cache status table where the status is still C. Clearing all rows with the Status C should resolve the issue.
Feedback
Yes
No
Powered by
