trafodion-firefighters team mailing list archive

["Marton, Roberta S" <roberta.marton@xxxxxx>]

Cliff did some analysis of catman1 TEST138 failure.  It looks like one of the select requests we perform to get privilege information is not returning information as expected:

This is the analysis for the failure of catman test 138 on HortonWorks in the daily build of January 6, 2015.

The first difference is at line 1194
1192-1196
>>create table user1_t1 (c1 int not null primary key, c2 int);

*** ERROR[1017] You are not authorized to perform this operation.

--- SQL operation failed with errors.
The "not authorized" error is from a CREATE TABLE statement being performed by user SQL_USER1.  The schema is a private schema (owned by DB__ROOT), so a user cannot create a table in the schema unless they have the CREATE_TABLE or CREATE component privilege.

The test expects the CREATE TABLE command to succeed.  The rest of the test fails because the expected table is not present.

A user has a DDL privilege if they have been granted the privilege directly, or it has been granted to a role granted to the user, or the privilege has been granted to PUBLIC.  In this section of the test, the user (SQL_USER1) does not have the CREATE or CREATE_TABLE privilege, but the CREATE privilege has been granted to PUBLIC, therefore, the CREATE TABLE should succeed.

Since the CREATE TABLE command fails with a "not authorized" error, there are two possibilities.

1)      The write (INSERT) of the privilege failed.

2)      The read (SELECT) of the privilege failed.

After the privilege is granted to PUBLIC, the test issues a GET command to verify the privilege was granted.  Here is the output from the GET commands just prior to the CREATE TABLE command:

1154-1166
>>get privileges on component sql_operations for "PUBLIC";

Privilege information on Component SQL_OPERATIONS for PUBLIC
============================================================

CREATE
CREATE_SCHEMA
SHOW

--- SQL operation complete.
>>get privileges on component sql_operations for sql_user1;

--- SQL operation complete.
Clearly the INSERT succeeded, therefore, the SELECT must have failed.

Here is the SELECT statement that is not returning expected values:

SELECT COUNT(*) FROM TRAFODION.PRIVMGR_MD.COMPONENT_PRIVILEGES
       WHERE COMPONENT_UID = 1 AND
             (OPERATION_CODE = 'CT' OR OPERATION_CODE = 'C0') AND
             (GRANTEE_ID = -1 OR GRANTEE_ID = 33334)

The user ID for PUBLIC is -1, and for SQL_USER1 it is 33334.  CT is the operation code for CREATE_TABLE and C0 is the operation code for CREATE.  The query is looking for one or more rows where either the CREATE or CREATE_TABLE privilege has been granted to either the user or PUBLIC.  Most of the time the result is one, but sometimes the query either fails or returns zero.

It is interesting that it sometimes fails on Hortonworks.  The other platforms seem to work.

LP bug 1408155 has been created for this problem and we will continue to monitor the daily builds.

   Roberta

From: Trafodion-firefighters [mailto:trafodion-firefighters-bounces+roberta.marton=hp.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Sharma, Anoop
Sent: Tuesday, January 06, 2015 10:38 AM
To: Varnau, Steve (Trafodion); Johnson, Stacey; trafodion-firefighters@xxxxxxxxxxxxxxxxxxx
Cc: Chen, Alice (Trafodion); Chen, Qifan; Qin, Hao (Howard, HPIT-GADSC)
Subject: Re: [Trafodion-firefighters] Daily build 2015-01-06 08:30:00 UTC of trafodion/core -- Test Failures

test042 is a compiletime/querycache related issue. It is expecting query to compile in a certain time
but is exceeding it during build/regression. We have seen this failure at other runs as well.
compiler folks should look at this and see if the test need to be modified since we cant expect
a query to compile within a time period on different machines.

anoop


From: Trafodion-firefighters [mailto:trafodion-firefighters-bounces+anoop.sharma=hp.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Varnau, Steve (Trafodion)
Sent: Tuesday, January 06, 2015 10:29 AM
To: Johnson, Stacey; trafodion-firefighters@xxxxxxxxxxxxxxxxxxx<mailto:trafodion-firefighters@xxxxxxxxxxxxxxxxxxx>
Cc: Chen, Alice (Trafodion)
Subject: Re: [Trafodion-firefighters] Daily build 2015-01-06 08:30:00 UTC of trafodion/core -- Test Failures


*       catman1 TEST138 failed on horton platform, passed on other two.

*       compGeneral TEST042 failed on all three platforms.

*       executor TEST025 failed on two platforms, passed on horton.

*       hive TEST020 failed on cloudera, passed on Horton.

o   hive on cloudera-manager platform has always timed-out.  I'm *still* trying to debug this.

*       jdbc_test fails 4 TestBasic tests on cloudera, 17 TestBasic on Horton, and java core on cloudera-manager.

*       phoenix-part(1&2)-T4 has a build failure in the tests on cloudera-manager platform.

*       phoenix-part(1&2)-T2 has java core on all platforms.

-Steve

From: Trafodion-firefighters [mailto:trafodion-firefighters-bounces+steve.varnau=hp.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Johnson, Stacey
Sent: Tuesday, January 06, 2015 10:18
To: trafodion-firefighters@xxxxxxxxxxxxxxxxxxx<mailto:trafodion-firefighters@xxxxxxxxxxxxxxxxxxx>
Subject: [Trafodion-firefighters] Daily build 2015-01-06 08:30:00 UTC of trafodion/core -- Test Failures


Build failed.



- traf-pub-release http://logs.trafodion.org/daily/traf-pub-release/a6bbe5c : SUCCESS in 33m 13s

- traf-pub-debug http://logs.trafodion.org/daily/traf-pub-debug/8233cdc : SUCCESS in 23m 15s

- core-regress-core-cdh5.1 http://logs.trafodion.org/daily/core-regress-core-cdh5.1/c549f45 : SUCCESS in 1h 56m 18s

- core-regress-core-cm5.1 http://logs.trafodion.org/daily/core-regress-core-cm5.1/2e69cf1 : SUCCESS in 2h 20m 11s

- core-regress-core-hdp2.1 http://logs.trafodion.org/daily/core-regress-core-hdp2.1/b04638e : SUCCESS in 1h 56m 05s

- core-regress-charsets-cdh5.1 http://logs.trafodion.org/daily/core-regress-charsets-cdh5.1/ed3f813 : SUCCESS in 1h 19m 40s

- core-regress-charsets-cm5.1 http://logs.trafodion.org/daily/core-regress-charsets-cm5.1/01a938e : SUCCESS in 1h 36m 28s

- core-regress-charsets-hdp2.1 http://logs.trafodion.org/daily/core-regress-charsets-hdp2.1/7cbe2fb : SUCCESS in 1h 16m 15s

- core-regress-qat-cdh5.1 http://logs.trafodion.org/daily/core-regress-qat-cdh5.1/f8d8453 : SUCCESS in 1h 10m 19s

- core-regress-qat-cm5.1 http://logs.trafodion.org/daily/core-regress-qat-cm5.1/abd179f : SUCCESS in 1h 28m 57s

- core-regress-qat-hdp2.1 http://logs.trafodion.org/daily/core-regress-qat-hdp2.1/a32e646 : SUCCESS in 1h 10m 15s

- core-regress-udr-cdh5.1 http://logs.trafodion.org/daily/core-regress-udr-cdh5.1/b754de2 : SUCCESS in 1h 04m 17s

- core-regress-udr-cm5.1 http://logs.trafodion.org/daily/core-regress-udr-cm5.1/5401ede : SUCCESS in 1h 26m 20s

- core-regress-udr-hdp2.1 http://logs.trafodion.org/daily/core-regress-udr-hdp2.1/abed9fc : SUCCESS in 1h 01m 04s

- core-regress-catman1-cdh5.1 http://logs.trafodion.org/daily/core-regress-catman1-cdh5.1/ee66ede : SUCCESS in 2h 17m 57s

- core-regress-catman1-cm5.1 http://logs.trafodion.org/daily/core-regress-catman1-cm5.1/61810ab : SUCCESS in 2h 57m 55s

- core-regress-catman1-hdp2.1 http://logs.trafodion.org/daily/core-regress-catman1-hdp2.1/3c13605 : FAILURE in 2h 12m 17s

- core-regress-compGeneral-cdh5.1 http://logs.trafodion.org/daily/core-regress-compGeneral-cdh5.1/6f8bf4e : FAILURE in 2h 21m 26s

- core-regress-compGeneral-cm5.1 http://logs.trafodion.org/daily/core-regress-compGeneral-cm5.1/211b7f9 : FAILURE in 2h 49m 25s

- core-regress-compGeneral-hdp2.1 http://logs.trafodion.org/daily/core-regress-compGeneral-hdp2.1/4651a81 : FAILURE in 2h 18m 51s

- core-regress-executor-cdh5.1 http://logs.trafodion.org/daily/core-regress-executor-cdh5.1/c555548 : SUCCESS in 2h 15m 00s

- core-regress-executor-cm5.1 http://logs.trafodion.org/daily/core-regress-executor-cm5.1/2180b3e : FAILURE in 3h 14m 04s

- core-regress-executor-hdp2.1 http://logs.trafodion.org/daily/core-regress-executor-hdp2.1/474b711 : FAILURE in 2h 12m 42s

- core-regress-fullstack2-cdh5.1 http://logs.trafodion.org/daily/core-regress-fullstack2-cdh5.1/60eadc6 : SUCCESS in 41m 56s

- core-regress-fullstack2-cm5.1 http://logs.trafodion.org/daily/core-regress-fullstack2-cm5.1/58ec3ea : SUCCESS in 58m 08s

- core-regress-fullstack2-hdp2.1 http://logs.trafodion.org/daily/core-regress-fullstack2-hdp2.1/6329dd2 : SUCCESS in 37m 57s

- core-regress-hive-cdh5.1 http://logs.trafodion.org/daily/core-regress-hive-cdh5.1/e62a0c3 : FAILURE in 1h 35m 56s

- core-regress-hive-cm5.1 http://logs.trafodion.org/daily/core-regress-hive-cm5.1/0537942 : FAILURE in 3h 20m 32s

- core-regress-hive-hdp2.1 http://logs.trafodion.org/daily/core-regress-hive-hdp2.1/8b8e475 : SUCCESS in 1h 29m 38s

- core-regress-seabase-cdh5.1 http://logs.trafodion.org/daily/core-regress-seabase-cdh5.1/986f7e5 : SUCCESS in 2h 25m 10s

- core-regress-seabase-cm5.1 http://logs.trafodion.org/daily/core-regress-seabase-cm5.1/fdf7d62 : SUCCESS in 3h 01m 52s

- core-regress-seabase-hdp2.1 http://logs.trafodion.org/daily/core-regress-seabase-hdp2.1/e70eb6c : SUCCESS in 2h 23m 46s

- phoenix_part1_T4-cdh5.1 http://logs.trafodion.org/daily/phoenix_part1_T4-cdh5.1/1b8cce7 : SUCCESS in 1h 51m 25s

- phoenix_part2_T4-cdh5.1 http://logs.trafodion.org/daily/phoenix_part2_T4-cdh5.1/e9238ed : SUCCESS in 1h 45m 44s

- phoenix_part1_T4-cm5.1 http://logs.trafodion.org/daily/phoenix_part1_T4-cm5.1/073cb3f : FAILURE in 43m 48s

- phoenix_part2_T4-cm5.1 http://logs.trafodion.org/daily/phoenix_part2_T4-cm5.1/8611fc3 : FAILURE in 42m 38s

- phoenix_part1_T4-hdp2.1 http://logs.trafodion.org/daily/phoenix_part1_T4-hdp2.1/625bab0 : SUCCESS in 1h 47m 37s

- phoenix_part2_T4-hdp2.1 http://logs.trafodion.org/daily/phoenix_part2_T4-hdp2.1/6111807 : SUCCESS in 1h 44m 51s

- phoenix_part1_T2-cdh5.1 http://logs.trafodion.org/daily/phoenix_part1_T2-cdh5.1/15d866a : FAILURE in 33m 37s (non-voting)

- phoenix_part2_T2-cdh5.1 http://logs.trafodion.org/daily/phoenix_part2_T2-cdh5.1/bd1f003 : FAILURE in 1h 18m 02s (non-voting)

- phoenix_part1_T2-cm5.1 http://logs.trafodion.org/daily/phoenix_part1_T2-cm5.1/9ba2d36 : FAILURE in 49m 05s (non-voting)

- phoenix_part2_T2-cm5.1 http://logs.trafodion.org/daily/phoenix_part2_T2-cm5.1/3cd7cb2 : FAILURE in 42m 11s (non-voting)

- phoenix_part1_T2-hdp2.1 http://logs.trafodion.org/daily/phoenix_part1_T2-hdp2.1/43dd8b1 : FAILURE in 29m 36s (non-voting)

- phoenix_part2_T2-hdp2.1 http://logs.trafodion.org/daily/phoenix_part2_T2-hdp2.1/d05a5cb : FAILURE in 35m 00s (non-voting)

- pyodbc_test-cdh5.1 http://logs.trafodion.org/daily/pyodbc_test-cdh5.1/15b7225 : SUCCESS in 33m 30s (non-voting)

- pyodbc_test-cm5.1 http://logs.trafodion.org/daily/pyodbc_test-cm5.1/822eec1 : SUCCESS in 58m 07s (non-voting)

- pyodbc_test-hdp2.1 http://logs.trafodion.org/daily/pyodbc_test-hdp2.1/d7bf405 : SUCCESS in 31m 37s (non-voting)

- jdbc_test-cdh5.1 http://logs.trafodion.org/daily/jdbc_test-cdh5.1/74b3d51 : FAILURE in 1h 31m 02s (non-voting)

- jdbc_test-cm5.1 http://logs.trafodion.org/daily/jdbc_test-cm5.1/ddead4c : FAILURE in 1h 30m 44s (non-voting)

- jdbc_test-hdp2.1 http://logs.trafodion.org/daily/jdbc_test-hdp2.1/e2d4e5e : FAILURE in 1h 30m 08s (non-voting)