ServerHit Error

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

ServerHit Error

Andrew Sykes
Hi,

Has anyone ever looked into the ServerHit Error that seem to appear
fairly frequently.

It looks roughly like this...

     [java] ERROR 23503: INSERT on table 'SERVER_HIT' caused a violation
of foreign key constraint 'SERVER_HIT_VISIT' for key (10004).  The
statement has been rolled back.

I'm sure you've seen the rest, so I'll spare everyone the full stack
trace.

What it the cause of this?
--
Kind Regards
Andrew Sykes <[hidden email]>
Sykes Development Ltd
http://www.sykesdevelopment.com

Reply | Threaded
Open this post in threaded view
|

Re: ServerHit Error

Andrew Sykes
Ok,

To answer my own question...
http://jira.ofbiz.org/browse/OFBIZ-800

- Andrew

On Fri, 2006-09-22 at 10:48 +0100, Andrew Sykes wrote:

> Hi,
>
> Has anyone ever looked into the ServerHit Error that seem to appear
> fairly frequently.
>
> It looks roughly like this...
>
>      [java] ERROR 23503: INSERT on table 'SERVER_HIT' caused a violation
> of foreign key constraint 'SERVER_HIT_VISIT' for key (10004).  The
> statement has been rolled back.
>
> I'm sure you've seen the rest, so I'll spare everyone the full stack
> trace.
>
> What it the cause of this?
--
Kind Regards
Andrew Sykes <[hidden email]>
Sykes Development Ltd
http://www.sykesdevelopment.com

Reply | Threaded
Open this post in threaded view
|

Re: ServerHit Error

Jacques Le Roux
Administrator
It's interesting to notice that when old Jira will be closed we will lose such informations. Anyway, too much info kill info ;o)

Jacques

From: "Andrew Sykes" <[hidden email]>

> Ok,
>
> To answer my own question...
> http://jira.ofbiz.org/browse/OFBIZ-800
>
> - Andrew
>
> On Fri, 2006-09-22 at 10:48 +0100, Andrew Sykes wrote:
> > Hi,
> >
> > Has anyone ever looked into the ServerHit Error that seem to appear
> > fairly frequently.
> >
> > It looks roughly like this...
> >
> >      [java] ERROR 23503: INSERT on table 'SERVER_HIT' caused a violation
> > of foreign key constraint 'SERVER_HIT_VISIT' for key (10004).  The
> > statement has been rolled back.
> >
> > I'm sure you've seen the rest, so I'll spare everyone the full stack
> > trace.
> >
> > What it the cause of this?
> --
> Kind Regards
> Andrew Sykes <[hidden email]>
> Sykes Development Ltd
> http://www.sykesdevelopment.com
Reply | Threaded
Open this post in threaded view
|

Re: ServerHit Error

David E Jones-2

Chances are quite a few people missed this as I think I just dropped  
it at the bottom of a related thread, but we are planning to get  
another server setup to run Jira with this old data in place. It  
won't be on a big box or a big internet connection and we probably  
won't make it available publicly, but it will still be somewhere.... ;)

-David


On Sep 22, 2006, at 12:40 PM, Jacques Le Roux wrote:

> It's interesting to notice that when old Jira will be closed we  
> will lose such informations. Anyway, too much info kill info ;o)
>
> Jacques
>
> From: "Andrew Sykes" <[hidden email]>
>> Ok,
>>
>> To answer my own question...
>> http://jira.ofbiz.org/browse/OFBIZ-800
>>
>> - Andrew
>>
>> On Fri, 2006-09-22 at 10:48 +0100, Andrew Sykes wrote:
>>> Hi,
>>>
>>> Has anyone ever looked into the ServerHit Error that seem to appear
>>> fairly frequently.
>>>
>>> It looks roughly like this...
>>>
>>>      [java] ERROR 23503: INSERT on table 'SERVER_HIT' caused a  
>>> violation
>>> of foreign key constraint 'SERVER_HIT_VISIT' for key (10004).  The
>>> statement has been rolled back.
>>>
>>> I'm sure you've seen the rest, so I'll spare everyone the full stack
>>> trace.
>>>
>>> What it the cause of this?
>> --
>> Kind Regards
>> Andrew Sykes <[hidden email]>
>> Sykes Development Ltd
>> http://www.sykesdevelopment.com