#11921: xmlPlans and NPE in log for multiple SQL in Sybase ASE

tariqrahiman reported 2014-04-22T18:28:01Z · last modified 2014-06-02T19:28:27Z

xmlPlans and NPE in log for multiple SQL in Sybase ASE

Dev	kin-hong
QA	NielsGron

Priority	Low
Complexity	Unknown

Component	Q Analyzer - Visual Explain Plan
Version	14.0

Version: 15.0.0-dev-247

Build #: 37464

Build Date: 2014-Apr-22 07:36:33 AM

NPE in log for multiple SQL in Sybase ASE

Against Sybase ASE 15.7 at 10.168.11.82, open Query Window with Visual Explain against aquafold database and Execute below queries.

You get NPE

SELECT * FROM dbo.sysalternates where suid is not null and altsuid is not null

SELECT * FROM dbo.syscolumns where id is not null and length > 100

INSERT INTO TESTTABLE VALUES ('T')

Sybase ASE 15

1. Connect to Sybase ASE 15

2. Open a query window against the NORTHWIND database

3. Copy the below SQL and execute twice

4. You can see that the some logs with xmlPlan=<? .. and java.lang.NullPointerException is generated.

See attached screenshot

select count(*) FROM dbo.Employees

select count(*) from dbo.Categories

select count(*) from dbo.CustomerDemographics

select count(*) from dbo.Customers

select count(*) from dbo.employee

select count(*) from dbo.Employees

select count(*) from dbo.Employees_ref

select count(*) from dbo.EmployeeTerritories

select count(*) from dbo.fetchsizetest

select count(*) from dbo.IPTEST

select count(*) from dbo.Order Details

select count(*) from dbo.Orders

select count(*) from dbo.Products

select count(*) from dbo.prt_hash_table

select count(*) from dbo.prt_hash_table1

select count(*) from dbo.prt_lst_table1

select count(*) from dbo.prt_rndrbn_table1

select count(*) from dbo.prt_rng_table1

select count(*) from dbo.Region

select count(*) from dbo.Shippers

select count(*) from dbo.Suppliers

select count(*) from dbo.T1

select count(*) from dbo.T2

select count(*) from dbo.Territories

select count(*) from dbo.test_employee

select count(*) from dbo.test_table

select count(*) from dbo.tmtest

1 attachment

Screen Shot 2014-04-22 at 11.25.55 AM.png

2014-04-22T18:28:03Z

160 KB

All Comments (3) Change History

ivangron 2014-05-30T21:48:16Z · (edited)

This occurs in class ASEExplainPlanPlanel.java at

line 672: if(ASEExplainPlanPanel.workerThread.isInterrupted(~

To reproduce you need to run a select statement and then an insert statement with explain plan on. Its not consistent but 50/50 so easy to reproduce. The NPE is thrown because workerThread object is null.

Will reassign to Kin and assign Niels as QA

I used the following two statements to reproduce:

SELECT * FROM dbo.syscolumns where id is not null and length > 100

INSERT INTO TESTTABLE VALUES ('T')

kin-hong 2014-06-02T16:26:30Z · Edited by

NielsGron

It seems that the original implementation attempted to limit explain plan generation to a single thread (but did not correctly interrupt the current running thread). In ADS, we support creating explain plan per SQL, so there is no need to stay with single-threaded limitation.

tariqrahiman 2014-06-02T19:28:27Z

Verified in ADS Version: 14.0.15 and 15.0.0-dev-304

Search Tips

Aqua Data Studio / nhilam

xmlPlans and NPE in log for multiple SQL in Sybase ASE

1 attachment

Issue #11921

Completion

Search Tips

Aqua Data Studio / nhilam

Title

xmlPlans and NPE in log for multiple SQL in Sybase ASE

1 attachment

Issue #11921

Completion