| Subject | RE: [ib-support] Restoring Problem |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-11-08T00:14:30Z |
At 09:36 AM 08-11-02 +1100, you wrote:
10. Restoring a beta 2 database in Fb 1 is a same-level restore.
I saw the previous posting and thought "Some time this guy will realise
that, without more information, he's not going to get an answer to this."
If it is barfing while restoring an index, you may have a composite index
in there that exceeds the width limit for an index (about 253 bytes, less
if a multi-byte charset or a non-default collation sequence is involved).
It might be something else though - for example, using an IB 5.6 client
library on the machine where the restore is happening might throw this sort
of error.
My suggestion in the first instance would be to restore the db inside your
beta 2 setup (if you can) and then simply see whether you can connect to
the restored db under a Fb 1 server (ensuring of course that you are using
a properly-matching client version). Or alternatively, open the old
version of the db in RC 2 or Fb1 if you can, and drop the offending index.
heLen
>AFAIK, you can't go back - the ODS are different. You can go forward from 1No, this is incorrect. Fb beta 2 and Firebird 1 are both ODS
>to 2 but not back 2 to 1
10. Restoring a beta 2 database in Fb 1 is a same-level restore.
I saw the previous posting and thought "Some time this guy will realise
that, without more information, he's not going to get an answer to this."
If it is barfing while restoring an index, you may have a composite index
in there that exceeds the width limit for an index (about 253 bytes, less
if a multi-byte charset or a non-default collation sequence is involved).
It might be something else though - for example, using an IB 5.6 client
library on the machine where the restore is happening might throw this sort
of error.
My suggestion in the first instance would be to restore the db inside your
beta 2 setup (if you can) and then simply see whether you can connect to
the restored db under a Fb 1 server (ensuring of course that you are using
a properly-matching client version). Or alternatively, open the old
version of the db in RC 2 or Fb1 if you can, and drop the offending index.
heLen
> -----Original Message-----
> From: Sandeep Chandra [mailto:sandeep@...]
> Sent: Friday, 8 November 2002 8:16
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Restoring Problem
>
>
> I posted this message yesterday, didn't get any replies, it's quite
> urgent, can anyone help please.
>
> I'm trying to restore a database on Linux (Firebird 1) from a backup
> file created from Firebird beta 2, and I get this error message
>
> Implementation Limit exceeded
> block size exceeds implementation restriction
>
> This happens when the server is restoring an Index.
>
> Regards
>
> Sandeep
>
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/