Subject | client freeze when execute statement delete |
---|---|
Author | Marcelo Pitanga |
Post date | 2003-04-22T14:29:14Z |
Hi all,
I've the following statement:
delete from REV where cod in ( select cod from DUP ).
REV has 450000 records
DUP has 3635 records
When i execute this statement my client freeze after some time. I forced a
shutdown by Guardian and when i open your log the following messages is
registered.
DES213 (Server) Tue Apr 22 10:46:59 2003
Database: C:\SPE\Spe.fdb
internal gds software consistency check (Too many savepoints (287))
DES213 (Client) Tue Apr 22 10:47:00 2003
C:\firebird15\bin\fbserver.exe: normal shutdown
my configuration:
DELL PIII-700mhz - 128MB - HD 10Gb free.
Windows ME 4.90.3000
Firebird 1.5 RC1 - 1.5.0.3233
IB Expert Personal Edition 2.5.0.22
what happened?
Thanks in advanced
Marcelo
I've the following statement:
delete from REV where cod in ( select cod from DUP ).
REV has 450000 records
DUP has 3635 records
When i execute this statement my client freeze after some time. I forced a
shutdown by Guardian and when i open your log the following messages is
registered.
DES213 (Server) Tue Apr 22 10:46:59 2003
Database: C:\SPE\Spe.fdb
internal gds software consistency check (Too many savepoints (287))
DES213 (Client) Tue Apr 22 10:47:00 2003
C:\firebird15\bin\fbserver.exe: normal shutdown
my configuration:
DELL PIII-700mhz - 128MB - HD 10Gb free.
Windows ME 4.90.3000
Firebird 1.5 RC1 - 1.5.0.3233
IB Expert Personal Edition 2.5.0.22
what happened?
Thanks in advanced
Marcelo