FirebirdSQL / firebird

Firebird server, client and tools
https://firebirdsql.org
1.26k stars 217 forks source link

Gbak cannot restore [CORE1144] #1565

Closed firebird-automations closed 17 years ago

firebird-automations commented 17 years ago

Submitted by: Andrey Lapin (trurl)

Attachments: bankerp_meta.zip

Gbak shows error, while restoring

gbak:restoring exception EX_NOT_CREATE_DOC gbak: committing metadata gbak: ERROR:unsuccessful metadata update gbak: ERROR: T_JUR_PERSONS gbak: ERROR: Implementation of text subtype 65332 not located. gbak:Exiting before completion due to errors

But version 1.5.3 works OK

firebird-automations commented 17 years ago

Commented by: @dyemanov

It should be reproducible with metadata-only backup. Could you provide it?

firebird-automations commented 17 years ago
Modified by: @dyemanov assignee: Adriano dos Santos Fernandes \[ asfernandes \]
firebird-automations commented 17 years ago

Commented by: Andrey Lapin (trurl)

metadata backup

firebird-automations commented 17 years ago
Modified by: Andrey Lapin (trurl) Attachment: bankerp\_meta\.zip \[ 10280 \]
firebird-automations commented 17 years ago

Commented by: @dyemanov

1) This backup cannot be restored using v1.5, it seems that a derived table is used in some view/procedure/trigger (BLR error is thrown).

2) The restore problem is caused by some RDB$RELATION_FIELDS records that have RDB$COLLATION_ID = -1. I don't know how it could happen. But the record referring to a D_TEXT domain stops the restore process because text blobs support collations in v2.0 and there's no such collation with ID = 255 (-1). The issue should go away after updating that column to zero and then backup/restore again.

firebird-automations commented 17 years ago
Modified by: Sean Leyne (seanleyne) status: Open \[ 1 \] =\> Resolved \[ 5 \] resolution: Won't Fix \[ 2 \]
firebird-automations commented 17 years ago
Modified by: @pcisar status: Resolved \[ 5 \] =\> Closed \[ 6 \]
firebird-automations commented 16 years ago
Modified by: @pcisar Workflow: jira \[ 11641 \] =\> Firebird \[ 15434 \]