You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Andrew Sykes <an...@sykesdevelopment.com> on 2006/09/22 11:48:12 UTC
ServerHit Error
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 <an...@sykesdevelopment.com>
Sykes Development Ltd
http://www.sykesdevelopment.com
Re: ServerHit Error
Posted by David E Jones <jo...@undersunconsulting.com>.
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" <an...@sykesdevelopment.com>
>> 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 <an...@sykesdevelopment.com>
>> Sykes Development Ltd
>> http://www.sykesdevelopment.com
Re: ServerHit Error
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <an...@sykesdevelopment.com>
> 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 <an...@sykesdevelopment.com>
> Sykes Development Ltd
> http://www.sykesdevelopment.com
Re: ServerHit Error
Posted by Andrew Sykes <an...@sykesdevelopment.com>.
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 <an...@sykesdevelopment.com>
Sykes Development Ltd
http://www.sykesdevelopment.com