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....@lists.launchpad.net]
On Behalf Of Sharma, Anoop
Sent: Tuesday, January 06, 2015 10:38 AM
To: Varnau, Steve (Trafodion); Johnson, Stacey;
[email protected]
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....@lists.launchpad.net]
On Behalf Of Varnau, Steve (Trafodion)
Sent: Tuesday, January 06, 2015 10:29 AM
To: Johnson, Stacey;
[email protected]<mailto:[email protected]>
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....@lists.launchpad.net]
On Behalf Of Johnson, Stacey
Sent: Tuesday, January 06, 2015 10:18
To:
[email protected]<mailto:[email protected]>
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)
--
Mailing list: https://launchpad.net/~trafodion-firefighters
Post to : [email protected]
Unsubscribe : https://launchpad.net/~trafodion-firefighters
More help : https://help.launchpad.net/ListHelp
