Error: Record 0 is wrong length in table (2630)

[Tomasz Dubiel]

Hello.

We had already 2 cases of this error and I would like to ask you for an advice.

On customers' databases on Firebird 3.0 (so far only Linux) something bad happens and after that, since that moment, every creation of any table and inserting into it values ends with errors:

Error: Record 0 is wrong length in table ... (2631).

Those errors are only visible when running gfix and backup. I can create table, do inserts and selects and while doing this I get expected results.

However, after that, every newly created table is broken. Gfix reports errors and gbak also does it, preventing successful backup.

Does anyone have any clue what bad could happen? So far we don't know the reason of this and every time we have to first drop all broken tables and perform backup restore.

And we don't know how to check for this. We would probably have to run test scripts and then perform database validation.

I have such broken database and I can check something what you might suggest me to do.

Best regards,

Tomek.

[Tomasz Dubiel]

Another symptom of a problem (I don't know whether it's the same or it's the second one): we couldn't do an insert of a value 'test' into a column varchar(255) of a broken table - Firebird returned an error: "conversion error from string 'test'".

[Tomasz Dubiel]

Do you have some ideas?

Best regards.