Subject | RES: [firebird-support] problem with restore |
---|---|
Author | Fabiano |
Post date | 2012-09-12T14:30:38Z |
Analyze what field compounds the RDB$INDEX_39 indice.
After restoring the database you will find out that you have duplicated
values in this table.
It is a slight corruption. You must delete the duplicated values and then
active this index. Then make a full backup/restore cycle.
Because of this things is important to always test your backups to known if
theirs can be restored.
Sorry my poor English.
Fabiano.
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Sergio
Enviada em: quarta-feira, 12 de setembro de 2012 11:26
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] problem with restore
Hello! I'm having a problem when I restore a database (just in case: the
backup was made with -meta_data option)
I'm getting this error message, but I can't find where is the RDB$INDEX_39.
I use FlameRobin...
gbak: restoring SQL role: RDB$ADMIN
gbak: ERROR:attempt to store duplicate value (visible to active
transactions) in unique index "RDB$INDEX_39"
gbak:Exiting before completion due to errors
_____
Nenhum vírus encontrado nessa mensagem.
Verificado por AVG - www.avgbrasil.com.br
Versão: 2012.0.2221 / Banco de dados de vírus: 2437/5264 - Data de
Lançamento: 09/12/12
[Non-text portions of this message have been removed]
After restoring the database you will find out that you have duplicated
values in this table.
It is a slight corruption. You must delete the duplicated values and then
active this index. Then make a full backup/restore cycle.
Because of this things is important to always test your backups to known if
theirs can be restored.
Sorry my poor English.
Fabiano.
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Sergio
Enviada em: quarta-feira, 12 de setembro de 2012 11:26
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] problem with restore
Hello! I'm having a problem when I restore a database (just in case: the
backup was made with -meta_data option)
I'm getting this error message, but I can't find where is the RDB$INDEX_39.
I use FlameRobin...
gbak: restoring SQL role: RDB$ADMIN
gbak: ERROR:attempt to store duplicate value (visible to active
transactions) in unique index "RDB$INDEX_39"
gbak:Exiting before completion due to errors
_____
Nenhum vírus encontrado nessa mensagem.
Verificado por AVG - www.avgbrasil.com.br
Versão: 2012.0.2221 / Banco de dados de vírus: 2437/5264 - Data de
Lançamento: 09/12/12
[Non-text portions of this message have been removed]