Bulk deletion of records issue.

[jchellap]

Hi All,

I tried to delete around 5 Lakhs records through a query . But, some problem occured after that I am not able to access the database.

I could see some new files after that in the database files related path.

Any database experts can say what may be the problem?

 

[jdpjamesp]

Not really enough info to go on yet. You can't access the db? So what errors are you getting? What version of Progress is it? Is there anything in the db log files that might suggest what's going on?

 

[jchellap]

I am sorry for not providing the enough informations.

Here is the details you wanted.

1.Progress Version 8
2.HP-UX uklhrmp1 B.11.11 U 9000/800
3. I have tried to delete the records 5 lakhs records from a customized table xxad_det.
4. When I ran the below deletion query it comes out from the progress editior
OUTPUT TO VALUE(m_file).
DO TRANSACTION ON ERROR UNDO, RETRY:
FOR EACH xxad_det WHERE xxad_type = "xxxxx" AND
xxad_date >= 01/01/2011 AND xxad_date <= 12/31/2011
EXCLUSIVE-LOCK:
cnt = cnt + 1.
IF cnt = 500000 THEN LEAVE.
ELSE DO:
EXPORT DELIMITER "|" xxad_det.
DELETE xxad_det.
END.
END.
END.
OUTPUT CLOSE.
END.
After that, I am not able to login to server.

 

[jdpjamesp]

So what errors are you receiving that are stopping you logging in?

 

[RealHeavyDude]

Just speculating: The transaction scoping of your procedure allows for a very big, long running transaction which might have blown your before image. That you would see in the log file of the concerned database.

Heavy Regards, RealHeavyDude.