Subject client freeze when execute statement delete
Author Marcelo Pitanga
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