Error 100: is offline
Posted by: John Deal
Date: August 04, 2011 08:33AM

Hello!

I have a multi-threaded application that has one MySQL DB connection per thread (maximum 5 threads with DB connections). I am sometimes getting Error 100 (returned by mysql_stmt_errno()) with the associated message "is offline" (returned by mysql_stmt_error()) on a mysql_stmt_fetch() statement. Both the client and MySQL server are on the same system and very little DB activity.

I can not find any documentation on this error. Is this the same as CR_SERVER_LOST? Also is it standard practice to look for this error and if encountered try the fetch again?

This is on a Ubuntu 9.10 64-bit system with MySQL Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (x86_64).

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 100: is offline
6935
August 04, 2011 08:33AM
2190
August 05, 2011 09:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.