Re: Backup Restore and MetaData

Article View: borland.public.interbase.opensource

Article #329

Back to borland.public.interbase.opensource Previous Next

#329

From: Thomas Steinmaurer
Date: Mon, 18 Oct 2004 17:37

30 lines
2064 bytes

> It seems in this case:
> while the fix is the same backup/restore
> the problem is not the same.
>
> I have been investigating and have found that
> what Jeff and Bill are talking about is the
> FORMATID value in the RDB$RELATIONS table.
>
> None of these values in any of our systems is over 50.
> Also no "Too many versions" exception message was generated.
>
> All that happenned is that the MetaData was not actually created.
> after a CREATE TABLE/CREATE PROCEDURE statement.
>
> This happened in half of our systems at around the same time.
>
> I am still very perplexed.

Do you explicitely COMMIT DDL statements, or do you
use AUTODDL ON? Perhaps AUTODDL OFF on some
sites?

What tool are you using to create tables, ...?

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com

Technical Details

Message-ID: <4173fe08@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<4172f1e2$1@newsgroups.borland.com> <4172f3fc$1@newsgroups.borland.com> <41730df4$1@newsgroups.borland.com> <41732BF6.C5672172@mindspring.com> <41733375@newsgroups.borland.com> <41733CBC.70EC7E84@mindspring.com> <41734ae2@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,c1763b010e2314bc
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Thomas Steinmaurer" <t.steinmaurer@_no_upscene_spam_.com>
Newsgroups: borland.public.interbase.opensource
References: <4172f1e2$1@newsgroups.borland.com> <4172f3fc$1@newsgroups.borland.com> <41730df4$1@newsgroups.borland.com> <41732BF6.C5672172@mindspring.com> <41733375@newsgroups.borland.com> <41733CBC.70EC7E84@mindspring.com> <41734ae2@newsgroups.borland.com>
Subject: Re: Backup Restore and MetaData
Date: Mon, 18 Oct 2004 19:37:36 +0200
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 62.46.233.82
Message-ID: <4173fe08@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1098120712 62.46.233.82 (18 Oct 2004 10:31:52 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message