Crash Recovery don't restore all windows

[Lukasz Indeka]

Windows 11 + PL/SQL Developer 16 (64 bit) beta 8 (the problem occurred in earlier beta, but not sure in which) + Multi session mode

Steps to reproduce (I'm not sure if all are needed, but it happens with this sequence):

• Open some SQL file with a query and run it.
• Session -> Log off -> All
• Open Test Window and add some code:
  
  

  declare
    -- Local variables here
    i integer;
  begin
    -- Test statements here
    dbms_output.put_line('test');
  end;

• Session -> Set Main Connection -> Recent -> Select some other connection than from the first SQL Window
• Run to the 6th line
• Open new SQL Window and run i.e.:
  

  select sysdate from dual;

• Select the Test Window Tab
• In Windows(R) Task Manager select PL/SQL Developer and End task
• Run new instance of PL/SQL Developer
• On the Oracle Logon, log to the second connection
• On the Crasah Recovery, select Restore connections and choose killed

Only two first windows were recovered - The "select from dual;" was lost.

In real world, it happened with much more windows opened - and much more lost. I had to kill PL/SQL Developer because it froze. I'm not sure what triggers the problem.

 

[Marco Kalter]

We'll investigate.

 

[Marco Kalter]

Can you let me know your settings from Preferences > Files > Backup? Specifically the "Save on execute" and "Save on time interval" options.

 

[Lukasz Indeka]

I've attached a screenshot - I used to use the default values. This was probably a problem cause. I've changed it to more safe values.

 

[Lukasz Indeka]

I had to kill PL/SQL again. Only 2 tabs were reopened and "Save on time interval" which I set to 1 minute is now empty and cannot be modified.

 

[Marco Kalter]

We'll continue to investigate...