You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Sachin <sa...@gmail.com> on 2012/06/14 12:40:06 UTC
SQL Exception while executing the following:INSERT INTO SERVER_HIT
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.
Re: SQL Exception while executing the following:INSERT INTO
SERVER_HIT
Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
See Jira issues OFBIZ-2208 and OFBIZ-1148.
-----
--
Coherent Software Australia Pty Ltd
http://www.cohsoft.com.au/
Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/
--
View this message in context: http://ofbiz.135035.n4.nabble.com/SQL-Exception-while-executing-the-following-INSERT-INTO-SERVER-HIT-tp4633545p4633663.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT
Posted by Deepak Dixit <de...@hotwaxmedia.com>.
But this fix is not included in release till now :)
mysql 5.6.* is an development release not an stable release.
Thanks & Regards
--
Deepak Dixit
On Jun 14, 2012, at 11:04 PM, Mike wrote:
> [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 <deepak.dixit@hotwaxmedia.com
>> 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.
>>
>>
Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT
Posted by Mike <mz...@gmail.com>.
[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 <deepak.dixit@hotwaxmedia.com
> 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.
>
>
Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT
Posted by Deepak Dixit <de...@hotwaxmedia.com>.
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.