Too many versions error!!

[Julio Cesar]

Hi

How can I fix the error "Too many versions"?

This error happens when I try to alter a table or anything linked with the
table(trigger, sp.. etc)

Code:
Alter table table1 add user_id integer

Thanks

Julio.

[Jeff Overcash (TeamB)]

Back up and restore the DB. This will get the version counts back to 1. Pre IB
6.5 the limit is something like 255 changes.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
This sad little lizard told me that he was a brontosaurus on his mother's
side. I did not laugh; people who boast of ancestry often have little else
to sustain them. Humoring them costs nothing and adds to happiness in
a world in which happiness is in short supply. (RAH)

[J Hall]

In article <3CA0ED8C...@mindspring.com>,
jeffov...@mindspring.com says...

Hi,

> Pre IB
> 6.5 the limit is something like 255 changes.

Has this been changed/fixed in IB6.5? (I can't be bothered to check).

J

[Jeff Overcash (TeamB)]

IB 6.5 only counts it as a change if there is a signature change IIRC. Since
most alterations are not due to signature changes this greatly increases the
limit.

>
> J

[Alexandre Durán Mertens - Departamento Desarrollo - Computer Soft, S.A.]

This change is also made is open source version ?

ADM

[Ded]

> This change is also made is open source version ?

In Firebird - shurely yes, don't know about IB6.

Best regards.

[Jeff Overcash (TeamB)]

"Alexandre Durán Mertens - Departamento Desarrollo - Computer Soft, S.A." wrote:
>
> This change is also made is open source version ?

I do not know.

>
> ADM

[Holger Klemt]

i just tested with ib65 desktop edition, but after 255 changes,
it gives the same error than older ib versions.

...
alter table add
alter table drop
...

the actual value (how many chnages are allowed) is always
visible while working in ibexpert.

--
IBExpert - The most Expert for InterBase --- http://www.ibexpert.com
HK Software - Holger Klemt - Huntestrasse 15 - D-26135 Oldenburg
Telefon Telefax +49 700 IBEXPERT (42397378) www.h-k.de
Schulungen - Projektunterstützung - Delphi - InterBase - AS/400

[Jeff Overcash (TeamB)]

Every time you add something or drop something you have changed the signature
which counts as a change like I said.

Here is what I was told from R&D

"To the best of my understanding "metadata counter" is for changes to the
metadata that alter the underlying structure of a record. Before 6.5 we
used to increment this on almost any type of metadata change.

This was a problem because if the "counter" got to 255 we forced a backup
and restore. This is not a possibility with some very large databases, so
this was altered in 6.5 so you can change metadata as much as you like as
long as it does not alter the underlying structure of a record."

your change changed the underlying structure so would have counted as a change.

--

[Thomas Steinmaurer]

(Talking about Firebird).

AFAIK the limit of 255 hasn't changed, but for specific
DDL statements like creating/altering/dropping a trigger
the format counter of the table won't be increased (as it
was done in older versions).

Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

"Holger Klemt" <hkl...@h-k.de> schrieb im Newsbeitrag
news:3ca241f2$2_1@dnews...

[Holger Klemt]

you are right, it has a better behaviour for example when
activate/deactivate
a trigger (was also counted in earlier versions of ib).

[Massimo Battiston]

Jeff

> Back up and restore the DB. This will get the version counts back to 1. Pre
IB
> 6.5 the limit is something like 255 changes.

Is the counter available? Is it stored into a system table?
Creating a new database via script, does this counter advance as well as
altering an existing structure?

TIA

Ciao,
Max

[Thomas Steinmaurer]

Yes, you can query a system table to get the actual format counter for a
given table.

SELECT RDB$FORMAT FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME = '<YOURTABLE>';

HTH,

Thomas Steinmaurer
IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

"Massimo Battiston" <NOSPAM_m....@tin.it> schrieb im Newsbeitrag
news:3ca2f479_1@dnews...

[Mustafa YILMAZ]

backup and restore it

"Julio Cesar" <jcqu...@hotmail.com> wrote in message
news:3ca0ecbe_1@dnews...