Cisco Bug: CSCuj61468 - Informix runs out of temp dbspace for queries with large data
Jun 26, 2014
- Cisco MediaSense
Known Affected Releases
Symptom: With 4M+ records some of the queries that cause JOINs result in data sets too large to fit in temp DBSpace which then fail. When the limits of the temp DBSpace are hit the queries will fail with out of memory messages in the logs. Conditions: Very large data sets with queries against any of the related Recording* tables (tracks, participants, URLs, tags) and RecordingSessions, or against 2 of the related Recording* tables other than Sessions will result in very large joins. Queries will run slowly under these conditions, and multiple users accessing any query methods at the same time increases the overhead substantially. This occurs in MS 10.0(1) and earlier.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.
Bug Details Include
- Full Description (including symptoms, conditions and workarounds)
- Known Fixed Releases
- Related Community Discussions
- Number of Related Support Cases