#402 Message window hangs Squirrel wuth many masseges

2.2final
closed
Rob Manning
Core (461)
5
2007-04-11
2006-07-24
No

When i execute a procedure with cursor and that
procedure starts to update line by line, Squirrel hang
or consumes all memory and CPU from my machine.
Something like 50000 rows inserted:
1 row updated.
1 row updated.
1 row updated.
1 row updated.
1 row updated.
1 row updated.
1 row updated.
1 row updated.
etc

Discussion

  • Rob Manning
    Rob Manning
    2006-12-11

    • assigned_to: colbell --> manningr
     
  • Rob Manning
    Rob Manning
    2006-12-11

    A create table and 6000+ inserts demonstrating the problem

     
    Attachments
  • Rob Manning
    Rob Manning
    2006-12-11

    Logged In: YES
    user_id=1287991
    Originator: NO

    I've attached a sample script which creates a "test" table, then proceeds to stick 6000+ rows in it (it needs Oracle, unless you change the varchar2 columns to varchar). When I execute it I see the count climb sequentially up until about 480, then the result panel doesn't change until about 1500, then after that, SQuirreL appear to become unresponsive. At that point, even attaching a debugger is not safe - I killed Eclipse before it came back; I wanted to save the script. In any case, don't execute all of the insert statements in the script - unless you want to see SQuirreL become unresponsive.

    Rob
    File Added: big_insert_script.zip

     
  • Rob Manning
    Rob Manning
    2007-03-27

    • status: open --> pending
     
  • Rob Manning
    Rob Manning
    2007-03-27

    Logged In: YES
    user_id=1287991
    Originator: NO

    The issue that I produced with the large input script has been addressed in the latest snapshot with large script support now implemented. However, I'm not sure that this adequately reproduces the original submitter's issue as it may only involve one sql statement. Can the original submitter please submit a small script with the procedure used in the original bug description?

    Rob

     
  • Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
    • status: pending --> closed