| Subject | Re: [firebird-support] restore - attempt to store duplicate value |
|---|---|
| Author | Milan Babuskov |
| Post date | 2005-12-16T16:01:13Z |
mat wrote:
from the "problematic" one. While pumping, you'll probably run into the
record that has problems, so you can identify it and fix it.
P.S. Don't hijack other threads by deleting the message body and
subject. Write a new message instead.
P.P.S. Set line-wrap to some reasonable value.
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org
> During restore of my database using FB 1.5.2.4731i've got the following error "Attempt to store duplicated value (visible to active transactions) in unique index rdb$index_2". Restore with deactivated indexes doesn't work also. So is my database corrupted seriously? And how can I fix it? How can I find out which values are duplicated?You could create an empty database (using gbak -m) and pump the data
from the "problematic" one. While pumping, you'll probably run into the
record that has problems, so you can identify it and fix it.
P.S. Don't hijack other threads by deleting the message body and
subject. Write a new message instead.
P.P.S. Set line-wrap to some reasonable value.
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org