SQLTalk 12.0.1 Problem with Execution Plan

A forum for submitting bug reports for SQLBase. Only one bug report per thread.

SQLTalk 12.0.1 Problem with Execution Plan

Postby phil@informasys.com » Wed Feb 15, 2017 1:09 pm

Using SQLTalk 12.0.1.10862. If the Execution Plan dialog (which is modeless) is open, then execute a longer running command, such as UNLOAD DATABASE on a database that will take enough time to do this, then while the command is executing, close the Execution Plan window with the X, or System menu-Close, or Alt-F4 (when you can get control of the Execution Plan dialog) , you will get a GCI SEA Session ended abnormally. For a very brief moment, another widow appears, then disappears (so I don't know what it is telling me). Very reproducible...
phil@informasys.com
 
Posts: 142
Joined: Mon Oct 22, 2007 12:40 pm

Re: SQLTalk 12.0.1 Problem with Execution Plan

Postby mvandine » Wed Feb 15, 2017 6:23 pm

Hi Phil,

Perhaps a clarification...

Are you using two SQLTalk sessions? When I use one SQLTalk session, do a 'select * from systables;' then show the execution plan, then go back into the SQLTalk pane and do an unload database command, I can't get to the execution plan window at all. Alt-tab only shows the SQLTalk main screen and the execution plan as one entity and I can't close the execution plan window.

Please let me know.

Best regards,

Mike
User avatar
mvandine
 
Posts: 4120
Joined: Wed Feb 14, 2007 4:15 pm
Location: Perth, Western Australia

Re: SQLTalk 12.0.1 Problem with Execution Plan

Postby iivanov » Thu Feb 16, 2017 2:43 am

Hi Mike,

I can reproduce it also with this steps:
1) connect to db
2) Show Execution plan
3) unload db
now you can't close the plan dialog, but if you
4) Alt-Tab to another app
5) Alt-Tab back to SQLTalk
6) You can close the plan dialog and get the "Session ended abnormaly" error

In my case, if I start SQLTalk again I don't get the error, I get "Program not responding" instead.
Igor Ivanovic
Image
Image
Join us at the new TD, TDM & SQLBase community forum, just follow the link:
Team Developer Community Forum
iivanov
 
Posts: 382
Joined: Thu Dec 20, 2007 5:47 am

Re: SQLTalk 12.0.1 Problem with Execution Plan

Postby mvandine » Thu Feb 16, 2017 5:34 pm

Thanks, Igor.

however, I can't get the session terminated error. I only get the SQLTalk is not responding message. Once the unload is done, the execution plan window is still there and operates as normal.

Best regards,
Mike Vandine
Gupta Technologies
User avatar
mvandine
 
Posts: 4120
Joined: Wed Feb 14, 2007 4:15 pm
Location: Perth, Western Australia

Re: SQLTalk 12.0.1 Problem with Execution Plan

Postby phil@informasys.com » Thu Feb 16, 2017 5:37 pm

Igor, thank you for the confirmation.
Mike, single SQLTalk instance, single database session.
What was scary is the Session ended abnormally is sometimes an indication of an SB service issue. You know what we've been through since moving to 12.0.
BTW, running everything 32 bit.
Phil
phil@informasys.com
 
Posts: 142
Joined: Mon Oct 22, 2007 12:40 pm


Return to Bug Reports

Who is online

Users browsing this forum: No registered users and 2 guests