Hello Richard,
Follow these steps
How to repair a corrupt Firebird database?
http://ib-aid.com/articles/item135
Regards,
Alexey Kovyazin
IBSurgeon
Hi to all,
I have error to my database while connecting it to my IBOConsole.
Detail Message:
ISC ERROR CODE:335544335
ISC ERROR
No, dialect was and still is 3
I backed up (after making another copy) installed 2.5.1.26351, then
restored.
I can run on the remote customer server (2.5.1) side-by-side with my
server (2.1) and see a fail - vs - success on the same data.
Its not a regional settings thing either because I also
On Tue, 25 Oct 2011 12:27:21 +0100, Alan J Davies
alan.dav...@aldis-systems.co.uk wrote:
No, dialect was and still is 3
I backed up (after making another copy) installed 2.5.1.26351, then
restored.
I can run on the remote customer server (2.5.1) side-by-side with my
server (2.1) and see a
gastrocus wrote:
INSERT INTO T1 (type, name, sysid, flag) values (1, 'Z', 1, 0)
WHERE NOT EXISTS (SELECT 1 FROM T1 WHERE name = 'Z')
You can apply select to rdb$database table which always returns one row:
INSERT INTO T1 (type, name, sysid, flag)
SELECT 1, 'Z', 1, 0 FROM
Hello,
I have the following situation. A table is used to store values that are
generated quite frequently. A second process will read the values and do
something with them. After that processing the read values are no longer needed
and they can (should!) be deleted from the database. However,
On Tue, Oct 25, 2011 at 11:24 AM, fernnaj y...@fernandonajera.com wrote:
The question is: if I have a select in one transaction that is suffering
from the cleaning up after a deletion of say 1 million rows (and it's taking
forever to return results), will another transaction that just writes
Hi -
Using FB2.5, I'm doing a simple restore of my database alias MYDB
Before doing so, I shut it down:
gfix -user sysdba -password masterkey -shut full -force 0 MYDB
Here is the restore command:
gbak -user sysdba -password masterkey -r o c:\backups\MYDB1.fbk MYDB
Is the database file
Hello Ann,
Thank you so much for your prompt answer! A few questions follow...
In SuperServer, all queries are
threads in the server process which schedules them on a round-robin basis,
giving each a quantum of time. So again, the inserts will be slower than
normal, but will not run while
Using Firebird embedded via Ado provider and noticed that occasionally our c#
application takes several minutes to start up - twenty minutes in fact. After
shutting down the application and connecting to the same database with IBexpert
the same delay is observed.
I'm pretty sure this is
Hello, jacobhavkrog!
Tuesday, October 25, 2011, 8:38:14 PM, you wrote:
j Using FB2.5, I'm doing a simple restore of my database alias MYDB
j Before doing so, I shut it down:
j gfix -user sysdba -password masterkey -shut full -force 0 MYDB
j Here is the restore command:
j gbak -user sysdba
On Tue, Oct 25, 2011 at 1:57 PM, fernnaj y...@fernandonajera.com wrote:
The last bit will not run while the garbage is being collected can have
two meanings for me. One is that the insert will be blocked completely until
the garbage collector finishes the cleaning of 1 million rows for the
I have the following situation. A table is used to store values that are
generated quite frequently. A second process will read the values and do
something with them. After that processing the read values are no longer
needed and they can (should!) be deleted from the database. However, the
Hi Thomas,
Perhaps your read process couldn't delete the record but mark it with a
flag and a cleanup process scheduled e.g. in the night deletes the
marked records followed by initiating a manual SELECT COUNT(*) on that
table in case of co-operative garbage collection.
Instead of marking
13 matches
Mail list logo
