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

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

2012-09-13 Thread Thomas Steinmaurer

 the querys are executed in a copy of that db. On tuesday, i recognized the 
 issue (that came without any reason). After a gbak, i stopped programs that 
 were using the database, stopped the default instance and made a copy to a 
 different volume, so i have a database i can Analyse. Currently, i made 
 another copy, that i use to Analyse it with IBFirstAid 2.6.

 I think this is a very weird issue

I wonder if index RDB$INDEX_20 is corrupt. What's the result of:

select
   rdb$collation_name || ''
from
   rdb$collations
group by
   rdb$collation_name || ''
having
   count(*)  1


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
 To:  firebird-support@yahoogroups.com



 The Result is:

 RDB$RELATION_NAMERDB$FIELD_NAME
 RDB$COLLATIONSRDB$COLLATION_NAME

 Thought 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 (13-Sep-2012 14:13)
 From: Thomas Steinmaurer t...@iblogmanager.com
 To: firebird-support@yahoogroups.com



 Thanks for your quick response.
 The query
 select
 rdb$collation_name
 from
 rdb$collations
 group by
 rdb$collation_name
 having
 count(*)  1

 results in:

 RDB$COLLATION_NAME
 NULL

 And what's the result of:

 select
 i.rdb$relation_name
 , s.rdb$field_name
 from
 rdb$indices i join rdb$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 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 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

 Here`s the clue: The database is working fine. There are no duplicated 
 roles, no duplicated datasets, index-reorg is working fine, gfix could`t 
 find ANY errors.

 I tried to find out, which relation RDB$INDEX_20 has. It refers to a 
 table named Abrechnung, Column named RUECKBUCHUNG. But there are no 
 duplicated values. In fact, Column RUECKBUCHUNG is always empty (IS 
 NULL).

 Any Ideas?

 IMHO, RDB$INDEX_20 is an index on the RDB$COLLATIONS system table. This
 can be proved by:

 select
 i.rdb$relation_name
 , s.rdb$field_name
 from
 rdb$indices i join rdb$index_segments s on (i.rdb$index_name =
 s.rdb$index_name)
 where
 i.rdb$index_name = 'RDB$INDEX_20'

 So, basically this means, there are duplicate values in
 RDB$COLLATIONS.RDB$COLLATION_NAME. What do you get by executing the
 following query?

 select
 rdb$collation_name
 from
 rdb$collations
 group by
 rdb$collation_name
 having
 count(*)  1

 Greetings from Austria (lost 1:2 unlucky). ;-)

 Regards,
 Thomas




 [Non-text portions of this message have been removed]



 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu. Try Knowledgebase and FAQ links !

 Also search the knowledgebases at http://www.ibphoenix.com

 ++
 Yahoo! Groups Links








 [Non-text portions of this message have been removed]



 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu. Try Knowledgebase and FAQ links !

 Also search the knowledgebases at http://www.ibphoenix.com

 ++
 Yahoo! Groups Links







 [Non-text portions of this message have been removed]



 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu.  Try Knowledgebase and FAQ links !

 Also search the knowledgebases at http://www.ibphoenix.com

 ++
 Yahoo! Groups Links

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

2012-09-13 Thread Alexey Kovyazin

Hello Maik,

 database, stopped the default instance and made a copy to a different 
volume, so i have a database i can Analyse. Currently, i made another 
copy, that i use to Analyse it with IBFirstAid 2.6.

This is a database corruption, but our IBFirstAID will not help in this 
case, since it's a system index problem.
You can contact support at ib-aid.com to get professional recovery 
support through remote desktop.

Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)




 database, stopped the default instance and made a copy to a different 
 volume, so i have a database i can Analyse. Currently, i made another 
 copy, that i use to Analyse it with IBFirstAid 2.6.

 I think this is a very weird issue

 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 
 mailto:ts%40iblogmanager.com
 To: firebird-support@yahoogroups.com 
 mailto:firebird-support%40yahoogroups.com

  The Result is:
 
  RDB$RELATION_NAMERDB$FIELD_NAME
  RDB$COLLATIONSRDB$COLLATION_NAME

 Thought 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 (13-Sep-2012 14:13)
  From: Thomas Steinmaurer t...@iblogmanager.com 
 mailto:ts%40iblogmanager.com
  To: firebird-support@yahoogroups.com 
 mailto:firebird-support%40yahoogroups.com
 
 
 
  Thanks for your quick response.
  The query
  select
  rdb$collation_name
  from
  rdb$collations
  group by
  rdb$collation_name
  having
  count(*)  1
 
  results in:
 
  RDB$COLLATION_NAME
  NULL
 
  And what's the result of:
 
  select
  i.rdb$relation_name
  , s.rdb$field_name
  from
  rdb$indices i join rdb$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 
 Value in unique Index (13-Sep-2012 14:03)
  From: Thomas Steinmaurer t...@iblogmanager.com 
 mailto:ts%40iblogmanager.com
  To: firebird-support@yahoogroups.com 
 mailto:firebird-support%40yahoogroups.com
 
 
 
  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
 
  Here`s the clue: The database is working fine. There are no 
 duplicated roles, no duplicated datasets, index-reorg is working fine, 
 gfix could`t find ANY errors.
 
  I tried to find out, which relation RDB$INDEX_20 has. It refers 
 to a table named Abrechnung, Column named RUECKBUCHUNG. But there 
 are no duplicated values. In fact, Column RUECKBUCHUNG is always 
 empty (IS NULL).
 
  Any Ideas?
 
  IMHO, RDB$INDEX_20 is an index on the RDB$COLLATIONS system table. This
  can be proved by:
 
  select
  i.rdb$relation_name
  , s.rdb$field_name
  from
  rdb$indices i join rdb$index_segments s on (i.rdb$index_name =
  s.rdb$index_name)
  where
  i.rdb$index_name = 'RDB$INDEX_20'
 
  So, basically this means, there are duplicate values in
  RDB$COLLATIONS.RDB$COLLATION_NAME. What do you get by executing the
  following query?
 
  select
  rdb$collation_name
  from
  rdb$collations
  group by
  rdb$collation_name
  having
  count(*)  1
 
  Greetings from Austria (lost 1:2 unlucky). ;-)
 
  Regards,
  Thomas
 
 
 
 
  [Non-text portions of this message have been removed]
 
 
 
  
 
  ++
 
  Visit http://www.firebirdsql.org and click the Resources item
  on the main (top) menu. Try Knowledgebase and FAQ links !
 
  Also search the knowledgebases at http://www.ibphoenix.com
 
  ++
  Yahoo! Groups Links
 
 
 
 
 
 
 
 
  [Non-text portions of this message have been removed]
 
 
 
  
 
  ++
 
  Visit http://www.firebirdsql.org and click the Resources item
  on the main (top) menu. Try Knowledgebase and FAQ links !
 
  Also search the knowledgebases at http://www.ibphoenix.com
 
  ++
  Yahoo! Groups Links
 
 
 

 [Non-text portions of this message have been removed]

 



[Non-text portions of this message have been removed]

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

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

2 matches

Site Navigation

Mail list logo

Footer information