db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject Re: column number mismatch error
Date Thu, 14 Feb 2008 17:07:48 GMT
On Thu, Feb 14, 2008 at 10:49 AM, Amir Michail <amichail@gmail.com> wrote:
> On Thu, Feb 14, 2008 at 4:30 AM, Knut Anders Hatlen <Knut.Hatlen@sun.com> wrote:
>  > Amir Michail <amichail@gmail.com> writes:
>  >
>  >  > On Feb 13, 2008 7:13 PM, Amir Michail <amichail@gmail.com> wrote:
>  >  >>
>  >  >> On Feb 13, 2008 3:51 PM, Amir Michail <amichail@gmail.com> wrote:
>  >  >> > Hi,
>  >  >> >
>  >  >> > What does this error mean?
>  >  >> >
>  >  >> > ERROR XSCH5: In a base table there was a mismatch between the
>  >  >> > requested column number 9 and the maximum number of columns 10.
>  >  >> >
>  >  >> > This happens when I tried to add a reference to a primary key.
>  >
>  >  Hi Amir,
>  >
>  >  Could you post the SQL statement you are trying to execute and the
>  >  schema for the tables involved? I think the error means that an attempt
>  >  to add a column to a table/conglomerate failed because the conglomerate
>  >  already has a column with the given id. I think this is an internal
>  >  error, and it could be a bug in Derby.
>  >
>
>  The integrity check did not reveal any error.

Assuming the db is corrupted (even though the integrity check does not
find anything wrong), is there an easy way to reconstruct the db from
scratch?  Is there a simple procedure I can follow?

Amir

>
>  But this fails:
>
>  ij> alter table levels add column shape_id int references shapes;
>
> ERROR XSCH5: In a base table there was a mismatch between the
>  requested column number 9 and the maximum number of columns 10.
>
>  Amir
>
>
>
>  >
>  >  >> Do you think my db is corrupted?
>  >  >
>  >  > What's the command for checking db integrity?
>  >
>  >  http://db.apache.org/derby/docs/10.3/adminguide/cadminconsist01.html
>  >
>  >  --
>  >  Knut Anders
>  >
>

Mime
View raw message