Re: Re-8: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-25 Thread Alexey Kovyazin
IT-Systemadministrator processed by David.fx Subject: Re: Re-6: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 17:46) From: Alexey Kovyazin a...@ib-aid.com mailto:ak%40ib-aid.com To: firebird-support@yahoogroups.com mailto:firebird-support%40yahoogroups.com

Re-8: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-18 Thread Maik Sommer - Finas GmbH
Lutherstadt Maik Sommer IT-Systemadministrator processed by David.fx Subject: Re: Re-4: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 14:29) From: Thomas Steinmaurer t...@iblogmanager.com mailto:ts%40iblogmanager.com To: firebird-support@yahoogroups.com

Re-8: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-14 Thread Maik Sommer - Finas GmbH
check of all relations: Ok 14.09.2012 09:42:05 INFO: --- Finished diagnose regards Maik Sommer IT-Systemadministrator processed by David.fx Subject: Re: Re-6: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 17:46) From

[firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Maik Sommer - Finas GmbH
Hello there, i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine. Doing a restore is failing due to the following error: gbak: ERROR:attempt to store duplicate value (visible to active transactions) in unique index RDB$INDEX_20 gbak:Exiting before completion due to

Re: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Thomas Steinmaurer
i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine. Doing a restore is failing due to the following error: gbak: ERROR:attempt to store duplicate value (visible to active transactions) in unique index RDB$INDEX_20 gbak:Exiting before completion due to errors

Re-2: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Maik Sommer - Finas GmbH
by David.fx Subject: Re: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 14:03) From:Thomas Steinmaurer t...@iblogmanager.com To: firebird-support@yahoogroups.com i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine. Doing

Re: Re-2: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Thomas Steinmaurer
$index_segments s on (i.rdb$index_name = s.rdb$index_name) where i.rdb$index_name = 'RDB$INDEX_20' Regards, Thomas Greetings from Lutherstadt Wittenberg :-) Maik Sommer IT-Systemadministrator processed by David.fx Subject: Re: [firebird-support] Restore fails due to duplicate

Re-4: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Maik Sommer - Finas GmbH
The Result is: RDB$RELATION_NAMERDB$FIELD_NAME RDB$COLLATIONSRDB$COLLATION_NAME Regards Maik Sommer IT-Systemadministrator processed by David.fx Subject: Re: Re-2: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 14:13) From:Thomas

Re: Re-6: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Thomas Steinmaurer
Regards, Thomas Mit freundlichen Grüßen aus der Lutherstadt Maik Sommer IT-Systemadministrator processed by David.fx Subject: Re: Re-4: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 14:29) From:Thomas Steinmaurer t...@iblogmanager.com

Re-8: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Maik Sommer - Finas GmbH
in the database the faulty backup is based on? Regards, Thomas Regards Maik Sommer IT-Systemadministrator processed by David.fx Subject: Re: Re-2: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 14:13) From: Thomas Steinmaurer t...@iblogmanager.com

Re: Re-8: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Thomas Steinmaurer
the Result is NULL Question: An index-reorg should fix this, right? Because i`ve done so tuesday night... How did you do that? Regards, Thomas

Re-10: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Maik Sommer - Finas GmbH
Subject: Re: Re-8: [firebird-support] Restore fails due to duplicate Value in unique Index (13-Sep-2012 15:55) From:Thomas Steinmaurer t...@iblogmanager.com To: firebird-support@yahoogroups.com the Result is NULL Question: An index-reorg should fix this, right? Because i`ve done so

Re: Re-6: [firebird-support] Restore fails due to duplicate Value in unique Index

2012-09-13 Thread Alexey Kovyazin
so and that's weird. And you have executed both queries in the database the faulty backup is based on? Regards, Thomas Regards Maik Sommer IT-Systemadministrator processed by David.fx Subject: Re: Re-2: [firebird-support] Restore fails due to duplicate Value in unique Index