Project

General

Profile

Bug #5433

"Command out of sync" Error with Run2Summary Table

Added by Bryan Dannowitz over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
02/13/2014
Due date:
% Done:

100%

Estimated time:
1.00 h
Duration:

Description

Getting this error when submitting a new row to Run2Summary table:

INSERT INTO summary.Run2Summary (runID, runDate, runTime) SELECT 6299, DATE(FROM_UNIXTIME(1392094564)), TIME(FROM_UNIXTIME(1392094564))
>> Error creating RunSummary Entry (Ignoring error): Commands out of sync; you can't run this command now

History

#1 Updated by Bryan Dannowitz over 6 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

In the MySQL C API, whenever a query is run that returns a result, such as a 'SELECT', 'SHOW', 'OPTIMIZE', etc., it is required to store the result via mysql_use/store_query() and then, when done with that result, to free it with mysql_free_result().

This was not done before the Run2Summary INSERT statement, and thus caused this error.

This has been resolved.

#2 Updated by Bryan Dannowitz over 6 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF