Webservice Error

[renclav]

Hi All

Occasionally, I get an error,

"[TeraWurflWebservice] ERROR: Error: Commands out of sync; you can't run this command now"

not every day, but it does occur often enough.

Anyone else seen this, know what's up?

Thanks
Dylan

[kamermans]

This happens when a command is issued to MySQL and it's response is not completely consumed before another query is sent. It's likely that you're using the MySQL5 adapter since it's the only one that issues queries that return multiple result sets. I'll have to look at the code to see why this might be happening, but, in the meantime, can you try editing the MySQL5 database connector PHP file and changing:

Code: Select all

public $db_implements_ris = true;


to

Code: Select all

public $db_implements_ris = false;


If the problems goes away I will know where to look for the problem.

[renclav]

Thank you Steve, I have implemented the fix on our live servers and will let you know towards the end of next week if this error is still occurring.

Regards
Dylan

[kamermans]

Great - thanks! Also, you should note that this could decrease performance for uncached device lookups, particularly if MySQL is not on the same server as Tera-WURFL since there will be more, larger queries. On the other hand, it may decrease the load on the MySQL server since more of the logic is being performed in PHP.

[renclav]

Happy to report the error has not reared it's head since the aforementioned edit