Why do I see Queries Failing Mid-Stream in MetaMatrix?
Issue
Description of problem:
In four of our test production systems, we are seeing sporadic query failures. As you will see in the log attached, MMX is 1) receiving the request 2) mediating the query (translation from VQL level SQL to source specific SQL), 3) sending the source specific SQL query to the datasource, 4) receiving several batches of results (2000 rows at a time), 5) not receiving the final batch, 6) closing the query and 7) indicating that the query completed but with a final row count of "-1". Normally, when a query returns with a row count of "-1", the "errorOccurred" field states "true". These queries have been in use for a while but it wasn't until this past Monday that the queries have been failing in MetaMatrix.
I turned up the logging level and captured an instance of the failure.
Environment
MetaMatrix Enterprise Server 5.5.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
