Page 1 of 1

intermittent Errors in dbmanager

Posted: 05 Oct 2012, 00:50
by bitrhymes
We are seeing few of these errors every hour, any idea? It works most of time, it probably happens under heavy load.

19:28:55.830 - [ SEVERE ] > DbManager error during command execution: INSERT INTO usr_coll (user_id, itid, cnt) VALUES(1000040,23,1)
at it.gotoandplay.smartfoxserver.db.DbManager.executeCommand(DbManager.java:345)

Re: intermittent Errors in dbmanager

Posted: 05 Oct 2012, 11:09
by rjgtav
Hi.
If you try that SQL statement directly on your database, does it work? If it doesn't, then you're probably specifying some values that aren't allowed by the data type.