Commit on Crash

[Gustavo]

Hi,

Last Friday I left a script running. When I came back today I noticed that Windows crashed and restarted (no dump, so no blue screen).

The script consisted of several updates. Commit commands were issued every n rows.

The point is, when Windows closed PLSD and restarted, an extra commit was issued. I was checking the update blocks in order to resume (first and last record from each block) and I found a block where the first 10 or so records were commited, while the remaining 90 were not.

Please, check.

Best regards,
Gustavo

 

[Marco Kalter]

Was this a SQL Window? What is the "Logoff with open transaction" setting (Tools > Preferences > Oracle / Connection)?

 

[Gustavo]

Hi,

It is set to "Ask". The script was running in a Command Window.

Regards,
Gustavo

 

[Marco Kalter]

Did PL/SQL Developer close or was the process killed? If it was killed, there is no control over transaction management.

 

[Gustavo]

I checked with support here and they said a program was updated and it fired a Windows restart. I don't know how PLSD would behave in this situation.