Guest

Preview Tool

Cisco Bug: CSCuj61468 - Informix runs out of temp dbspace for queries with large data

Last Modified

Jun 26, 2014

Products (1)

  • Cisco MediaSense

Known Affected Releases

10.0(1) 10.5(1)

Description (partial)

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)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.