--=-xP7BeI2+YpUKj+LbelQJ
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Is it possible for a whole set of sequences to suddenly 'jump'?
I have a set of claims tables that cover the claim itself, the customer,
contact points etc. Yesterday there was a power failure and the server
suffered an immediate power outage. When the server came back,
everything seemed fine, apart from the fact that the claim related
sequences had all jumped and left a gap of 33 (last was 52 before power
failure, next one allocated after power failure 85). This seems
consistent across all the tables related to the claim (it may be across
the tables in the database - I haven't checked all of them as yet).
Does this sound feasible and if so, what is the cause?
--=-xP7BeI2+YpUKj+LbelQJ
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.12.3">
</HEAD>
<BODY>
Is it possible for a whole set of sequences to suddenly 'jump'?<BR>
<BR>
I have a set of claims tables that cover the claim itself, the customer,
contact points etc. Yesterday there was a power failure and the server
suffered an immediate power outage. When the server came back, everything
seemed fine, apart from the fact that the claim related sequences had all
jumped and left a gap of 33 (last was 52 before power failure, next one
allocated after power failure 85). This seems consistent across all the
tables related to the claim (it may be across the tables in
the database - I haven't checked all of them as yet).<BR>
<BR>
Does this sound feasible and if so, what is the cause?<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
--=-xP7BeI2+YpUKj+LbelQJ--
|
