SQL Exception while executing the following:INSERT INTO SERVER_HIT

[Sachin]

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

[Mike Z]

Well, you simply need to remove the offending record in the server_hit table.  You could probably just empty the table "delete from server_hit" if you don't care about it's contents.

However, it's odd that you would get this error to begin with.  I'm wondering if it has to do with past problems with mysql not resolving down to the millisecond level (like postgresql).

Maybe someone else can chime in.  


------Original Message------
From: Sachin
To: [hidden email]
ReplyTo: [hidden email]
Subject: SQL Exception while executing the following:INSERT INTO SERVER_HIT
Sent: Jun 14, 2012 3:40 AM

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.

Sent via BlackBerry by AT&T

[Deepak Dixit-2]

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 :- [phone]
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.

[Mike Z]

[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 <[hidden email]
> 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 :- [phone]
> 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.
>
>

[Deepak Dixit-2]

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 <[hidden email]
>> 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 :- [phone]
>> 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.
>>
>>

[Sachin]

Thanks deepak...IO am using 5.1 version of mysql....

[Paul Foxworthy]

See Jira issues OFBIZ-2208 and OFBIZ-1148.