We have a problem to delete the records from the table.
Kernel 7.4.3 Build 017-123-039-277
Runtime Environment : X64/SUN 7.4.3 Build 017-123-039-277
The table has the following structure and contains 2.708.926 records:
create table ref
(r_id integer CONSTRAINT pk_ref PRIMARY KEY,
r_parent integer not null,
r_type varchar(20) not null,
r_ref varchar(256) not null,
r_root integer not null,
r_custom varchar(256) not null)
The reference to other table is taken away.
At first we have deleted 500.000 records successfully.
Then we have deleted the next 250.000 records. In the Diagnosis file
"Database Messages" has appeared:
2003-11-27 15:39:14 100 WNG 11824 COMMUNIC Releasing T92 command
timeout
2003-11-27 15:39:14 100 11007 COMMUNIC wait for
connection T92
If we attempted to delete the next 20.000 records, the instance has gone to
offline mode and could not be booted up without complete recovery.
The error <http://dict.leo.org/?p=lURE.&search=error> message
<http://dict.leo.org/?p=lURE.&search=message> in the "Database Messages"
and "Database Errors" beginns with the row:
2003-11-27 15:42:59 113 ERR 52050 SHUTDOWN rollback/log_error
I can send the whole massage according to demand.
Thank you very much in advance for your help!
Best regards
Jelena Azjukovska
