SQL Exception while executing the following:INSERT INTO SERVER_HIT

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

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


Reply | Threaded
Open this post in threaded view
|

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

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
Reply | Threaded
Open this post in threaded view
|

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

Deepak Dixit-2
In reply to this post by Sachin
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.


smime.p7s (6K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

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 :- +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.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

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 :- +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.
>>
>>


smime.p7s (6K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

Sachin
Thanks deepak...IO am using 5.1 version of mysql....
Reply | Threaded
Open this post in threaded view
|

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

Paul Foxworthy
See Jira issues OFBIZ-2208 and OFBIZ-1148.
--
Coherent Software Australia Pty Ltd
http://www.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/