Yes, I have shutdown Firebird (via Services) and copied the FDB file. After
restart of the Firebird service and restart of my own program, Firebird "hangs"
again. I took the FDB file to my own computer (Firebird 2.5.8 64 bit) and did
run gstat on it.
I tested a few databases with gfix:
Number of record level errors : 1
Number of database page errors : 374
Number of record level errors : 2
Number of database page errors : 67
Number of record level errors : 2
So there are problems in
Transactions don't seem to cause the problems:
Database header page information:
Flags 0
Checksum12345
Generation 1399534
Page size 16384
ODS version 11.2
Oldest transaction
04.01.2019 19:50, dam...@wxs.nl [firebird-support] wrote:
> Because some customers have a bad habit when switching of computers, I
> register abnormal
> termination of my program. I can also detect power failures etc with this
> feature. But it
> seems normal.
But the databases definitely
I tested a few problematic databases with gfix:
Number of record level errors : 1
Number of database page errors : 374
Number of record level errors : 2
Number of database page errors : 67
Number of record level errors : 2
Because some
I have a few customers still working on XP with Firebird 2.5.8 32 bit. And it
seems that a problem is introduced in 2.5.7 or 2.5.8. In semi regular periods,
the Firebird server hangs (hogs CPU). This reappears after a restart of the
Firebird server and accessing the database again. Only
04.01.2019 14:34, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> I need to alter procedures on running Firebird 3.0 database and I need to
> disconnect all
> the users for doing that (there is 'procedure in use' control exception
You just must perform ALTER in WAIT transaction.
If
Especially - what happens to the SQL (especially update) commands that are
running during the restart of the service? I know that service is not waiting
for the completion of those commands. I fear that some interrupted commands can
introduce gds corruption errors, that is my greated concern in
Hi!
Sometimes I need to alter procedures on running Firebird 3.0 database and I
need to disconnect all the users for doing that (there is 'procedure in use'
control exception, there is no similar control for triggers). Sometimes I have
no other option than to restart Firebird Windows
04.01.2019 11:26, leaw...@gmx.de [firebird-support] wrote:
> that does not work - Unknown Column error -206
RTFM Language Reference. In SQL queries PSQL variables must be used with
colon.
--
WBR, SD.
14 matches
Mail list logo