Subject Re: 2 identical record inserts not stopped by UNIQUE constraint
Author Stan
The same issue happened in a different stored procedure on the same
machine.

I am now trying to reproduce this on a different machine to see
if it is specific to the machine we are using.

thanks,

stan

--- In firebird-support@yahoogroups.com, "Stan" <shizius@...> wrote:
>
> Adam,
>
> I suspect that this issue is a result of the corruption as well.
>
> No, I have no idea what caused the corruption, The machine
> did not reboot or crash. The FB server did not die.
> the Firebird.log only contains a bunch of 10061 socket errors
> which seem to be "normal" during high load.
>
> I guess that it is not out of the question that this machine has bad
> RAM, maybe... No other issues on this machine so far.
>
> If this happens again, I will assume that it is a hardware issue that
> caused the corruption since I have not seen this happen on other test
> machines.
>
> thanks,
>
> stan
>
> --- In firebird-support@yahoogroups.com, "Adam" <s3057043@> wrote:
> >
> >
> > > Number of index page errors : 123
> >
> > Stan,
> >
> > This looks suspicious to me. A unique constraint simply checks the
> > underlying index to determine whether it has been violated. If you are
> > having corruption in index pages, all bets are off.
> >
> > Any hints on what may have caused the corruption?
> >
> > Adam
> >
>