intermittent Errors in dbmanager

Post here your questions about Actionscript and Java server side extensions development.

Moderators: Lapo, Bax

Post Reply
bitrhymes
Posts: 27
Joined: 22 Dec 2011, 01:11

intermittent Errors in dbmanager

Post 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)
User avatar
rjgtav
Posts: 2813
Joined: 19 Apr 2009, 11:31
Location: Lisbon, Portugal

Re: intermittent Errors in dbmanager

Post 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.
Skills: SFS Pro, SFS2X, AS2.0/AS3.0, Java, HTML5/CSS3/JS, C#
Portfolio: https://rjgtav.wordpress.com/
SFS Tutorials: http://sfs-tutor.blogspot.com/ - Discontinued. Some examples may be bugged.
Post Reply