[6 Dec 2011 17:25] Paul DuBois Noted in 5.6.4 changelog.
MySQL now supports fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microsecond precision. On Thu, Jun 14, 2012 at 10:05 AM, Deepak Dixit <[email protected] > wrote: > Hi Sachin, > > Which version of mysql are you using? > > This error occurs due to mysql issue, as mysql does not support the > millisecond for timestamp field, and if two request executes on same time > with millisecond timestamp differences then you can get this error message. > (Generally for those screens that have lookups). > > http://bugs.mysql.com/bug.php?id=8523 > > > Thanks & Regards > -- > Deepak Dixit > HotWax Media Pvt. Ltd. > www.hotwaxmedia.com > Contact :- +91-98267-54548 > Skype :- deepakdixit > > On Jun 14, 2012, at 4:10 PM, Sachin wrote: > > > Getting this error: > > > > > > SQL Exception while executing the following:INSERT INTO SERVER_HIT > > > > Exception: org.ofbiz.entity.GenericDataSourceException > > > > > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > > Duplicate entry '44200-root.main-2012-06-14 16:06:28-REQUEST' for key 1 > > > > > > > > > > -- > > View this message in context: > http://ofbiz.135035.n4.nabble.com/SQL-Exception-while-executing-the-following-INSERT-INTO-SERVER-HIT-tp4633545.html > > Sent from the OFBiz - User mailing list archive at Nabble.com. > >
