Den 2014-03-23 09:37 skrev Jesus Garcia såhär:
>
>> I had a database corruption recently and was told that it may have
>> been caused by dropping tables while the database was online with
>> other users connected. Apparently there is some kind of race
>> condition in the page allocation that can
> Excuse me but what does GTT mean ?
Global temporary tables.
Tables, which data is persitent for a transaction or a connection
(depending on the table definition).
Thomas
--
Mit freundlichen Grüßen,
Thomas Beckmann
Diplom-Informatiker
Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 -
Excuse me but what does GTT mean ?
Can you please tell us how did you solve the issue. Could you mend the
database using gfix ?
Regards,
Aldo
El 23/03/14 04:39, Kjell Rilbe escribió:
Den 2014-03-23 03:46 skrev Aldo Caruso såhär:
My concern was about logical or business rules issues, not ab
> I had a database corruption recently and was told that it may have been
> caused by dropping tables while the database was online with other users
> connected. Apparently there is some kind of race condition in the page
> allocation that can cause the same page to be allocated to different "t
My concern was about logical or business rules issues, not about
database corruption, which I didn't know could happen.
Why does corruption happen mixing DDL and DML in the same transaction ?
Aldo
El 22/03/14 20:55, Carlos H. Cantu escribió:
No, corruption can happen if you mix DDL and DML i
Carlos,
Frequently I modify stored procedures and triggers.
If some user were connected before I started my transaction (the
one which changes the stored procedure) he will still be using the
unmodified version of the stored procedure. On the other hand, users who
connects after I com
> El 23/03/2014, a las 00:44, "Carlos H. Cantu"
> escribió:
>
> It depends on what kind of changes you plan to do. Some of them still
> needs exclusive access, otherwise you may end up with an "object is in
> use" error.
>
>
I think Aldo asks If it is "sure", because there are comments, some
It depends on what kind of changes you plan to do. Some of them still
needs exclusive access, otherwise you may end up with an "object is in
use" error.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
AC> Hello,
AC>I
Hello,
I wonder if is it sure to perform changes to the database metadata
while there are still users connected.
Up to now, I allways shut the database down, perform DDL changes, and
put it back on line.
Is it actually necessary to do that ?
Thanks for any help.
Aldo Caruso
12 matches
Mail list logo