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

[Alexey Kovyazin]

Hello Maik,

I think this is Ok to use such workaround, since everything is Ok.

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



 Hello Alexey,

 as if i tried different things i found an unusal way to solve that 
 problem. Now i wanted to ask you (and the whole group) what 
 side-effects can (or will) be caused by this procedure.

 - i dropped the idexes (INDEX_20  INDEX_26)
 - i modified the RDB$RELATIONS table to remove the SYSTEMFLAG off of 
 the RDB$COLLATIONS
 - after that i was abled to drop that corrupt RDB$COLLATIONS table
 - i disconnected the database
 - i reconnected the database and received an error (missing table / 
 some relations)
 - i executed a script to rebuild the RDB$COLLATIONS table ant its indexes
 - i modified the RDB$COLLATIONS table to add the SYSTEMFLAGS for that 
 table and its indexes
 - then i re-inserted the 148 datasets that were originally in the 
 COLLATIONS-table

 Now, backup/restore/everything else is working fine. Or it seems so.
 All of that has been done in an testing-environment!

 Now i need to know if there is anything that i should be worried 
 about. If so: where`s my mistake?

 Greetings from Germany!
 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: Alexey Kovyazin a...@ib-aid.com mailto:ak%40ib-aid.com
 To: firebird-support@yahoogroups.com 
 mailto:firebird-support%40yahoogroups.com

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

[firebird-support] Delphi + Firebird + BLOB + MSWord document + Stream

[emailx45]

Dear friends,
 
I would like to know, if its possible, a help of you!
 
I need to know how to save one file MS Word Doc or Docx in a BLOB and read it 
by stream, but, dont to use save in disk before!
 
I search in internet for a long time, but, only found the same procedure...
 
Can you help me?
 
Scenary:
  -- Delphi xe2
  -- Firebird 2.5
  -- FIBPLus 7.3
  -- Windows 7
 
   I know how to save the file (doc. jpg, etc...) in a BLOB field (binary type)
   I know how to read (using save in disk and read the file)
 
  But, I need read the BLOB content by STREAM, or be, read portions of file 
into BLOB
 
Thanks for you!
 
Note: If you can not help me, please if you can show me Some site or user who 
can give me a hint about this problem!