Bug 1036588

Summary: JON operations/metrics are not working for DV6
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Filip Nguyen <fnguyen>
Component: JONAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 6.0.0CC: fnguyen, vhalbert
Target Milestone: GA   
Target Release: 6.0   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Users have reported several issues with information reported by the JBoss Operations Network plugin for JBoss Data Virtualization.
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-03-10 19:52:00 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
01
none
02
none
03
none
04
none
05
none
06
none
07
none
08
none
09
none
log files from JON server, JON agent and DV server
none
VDB used for testing
none
Dashboard VDB used for testing none

Description Filip Nguyen 2013-12-02 10:22:09 UTC
Created attachment 831510 [details]
01

I have done more thorough testing of the JON plugin and I have found numerous issues with operations/metrics. There are too many that I think I should just create this one to confirm the bugs with engineering. 

Since there are so many bugs I suspect maybe there might be a problem on my side.


Test Setup
***************************************
We have a JON server and JON agent on two separate machines in JON lab. The JON Agent runs version ER5 of data virtualization, isntalled by headless installer. 
Jon server is in version 3.2.0.ER7

Teiid Plugin
Name :	Teiid
Version : 3.0.0
AMPS Version :	2.0
MD5 :e5be9b61fc73d68d57cc425849e92e70
Path :	teiid-rhq-plugin-1.0.0.Final-redhat-4.jar

Testing methodology
***************************************
I am using self created dashboard-vdb.xml that connects to dashboard datasource that is presented in DV ER5. I am submitting a long running request like this [1] and observing what is happening on the server using both JON and JBoss AS Management console. 

Problems found
***************************************
The query runs for very long time (more than several minutes). That should be enough to show this query in statistics in view VDB Monitoring tab (see picture 02). However it is not shown there. Note that the query is really being executed (see picture 01 - the Managemenet console view).

I highlighted the "dash" vdb and scheduled "View VDB requests" operation. The operation succeded, but the result view is probably invalid (see pictures 3 and 4). 

Then I tried "View VDB sessions" operation. This was more successfull than the former, but still, as you can see in picture 5 and 6 there are several usability issues: Created time is shown in weird format, IP Address - is 127.0.0.1 really true? I am executing the query from my laptop against the Lab machine, 

Then I highlighted "data virtualization" node in JON UI and tried "view current requests" operation. This returned the results shown in picture 07. Is it correct that requests IDs are all zeros?  With information from this result I tried to execute operation "Terminate request" and supplied the session id and request id. It failed with the result shown on picture 08. Note that immediatelly after that I tried to terminate request via Management Console (Cancel button) and it succeded, even terminating the request in my laptop's console as seen on picture 09.




[1] "select count(*) from DASHB_PANEL p1, DASHB_PANEL p2 , DASHB_PANEL p3, DASHB_PANEL p4, DASHB_PANEL p5"

Comment 1 Filip Nguyen 2013-12-02 10:22:45 UTC
Created attachment 831512 [details]
02

Comment 2 Filip Nguyen 2013-12-02 10:23:01 UTC
Created attachment 831513 [details]
03

Comment 3 Filip Nguyen 2013-12-02 10:23:19 UTC
Created attachment 831514 [details]
04

Comment 4 Filip Nguyen 2013-12-02 10:23:45 UTC
Created attachment 831515 [details]
05

Comment 5 Filip Nguyen 2013-12-02 10:24:03 UTC
Created attachment 831516 [details]
06

Comment 6 Filip Nguyen 2013-12-02 10:24:21 UTC
Created attachment 831517 [details]
07

Comment 7 Filip Nguyen 2013-12-02 10:24:39 UTC
Created attachment 831518 [details]
08

Comment 8 Filip Nguyen 2013-12-02 10:24:56 UTC
Created attachment 831519 [details]
09

Comment 10 Filip Nguyen 2013-12-02 14:37:04 UTC
Created attachment 831606 [details]
log files from JON server, JON agent and DV server

attaching log files from JON server, JON agent and DV server

Comment 11 Filip Nguyen 2013-12-05 15:44:53 UTC
Created attachment 833221 [details]
VDB used for testing

Comment 12 Filip Nguyen 2013-12-05 15:54:56 UTC
Created attachment 833225 [details]
Dashboard VDB used for testing

Comment 13 JBoss JIRA Server 2013-12-10 20:13:02 UTC
Ted Jones <tejones> updated the status of jira TEIIDRHQ-22 to Resolved