For a first hint you could send knldiag and the trace file from the time you got the error rollback/log_error. The trace file is produced with "dbmcli ... trace_prot akbx" then a file is created in the rundirectory which is named "<dbname>.prt".
Kind regards Uwe -----Urspr�ngliche Nachricht----- Von: Azjukovska Jelena [mailto:[EMAIL PROTECTED] Gesendet: Montag, 8. Dezember 2003 15:58 An: '[EMAIL PROTECTED]' Betreff: Offline mode by delete from records 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 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
