[jira] [Closed] (TRAFODION-1238) LP Bug: 1455585 - Error 1234 returned trying to run SQL requests

["Roberta Marton (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Roberta Marton closed TRAFODION-1238.
-------------------------------------
       Resolution: Fixed
    Fix Version/s: 2.0-incubating

Fixed after release 1.1 was released and before moving to Apache release.

> LP Bug: 1455585 - Error 1234 returned trying to run SQL requests
> ----------------------------------------------------------------
>
>                 Key: TRAFODION-1238
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1238
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-security
>            Reporter: Roberta Marton
>            Assignee: Roberta Marton
>            Priority: Blocker
>             Fix For: 2.0-incubating
>
>
> After merging with https://review.trafodion.org/1635, I get the following error when trying to run a query through sqlci:
> showddl user1.games;
> *** ERROR[1234] Authorization need to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
> *** ERROR[2235] Compiler Internal Error: An unknown error, originated from file ../arkcmp/CmpContext.cpp at line 515.
> *** ERROR[8822] The statement was not prepared.
> Following the directions in the message, I try running initialize authorization, drop unsuccessfully:
> initialize authorization, drop;
> *** ERROR[1234] Authorization need to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
> *** ERROR[1234] Authorization need to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
> *** ERROR[1234] Authorization need to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
> *** ERROR[1234] Authorization need to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
> *** ERROR[1234] Authorization need to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
> *** ERROR[1028] The schema must be empty.  It contains at least one object COMPONENTS.
> --- SQL operation failed with errors.
> I cannot run - what can I do?
> Until the problem is fixed, here are some workarounds:
> Workaround #1:
> This problem only occurs in a debug build, do a release build and perform "initialize authorization, drop;"
> Workaround #2:
> If you want to continue to run with a debug build, run the following steps:
> swhbase
> create 'TRAFODION._PRIVMGR_MD_.COLUMN_PRIVILEGES', {NAME => '#1'}
> create 'TRAFODION._PRIVMGR_MD_.SCHEMA_PRIVILEGES', {NAME => '#1'}
> quit
> sqlci
> initialize authorization, drop;
> exit;
> swhbase
> disable 'TRAFODION._PRIVMGR_MD_.COLUMN_PRIVILEGES'
> drop 'TRAFODION._PRIVMGR_MD_.COLUMN_PRIVILEGES'
> disable 'TRAFODION._PRIVMGR_MD_.SCHEMA_PRIVILEGES'
> drop 'TRAFODION._PRIVMGR_MD_.SCHEMA_PRIVILEGES'
> exit
> Workaround #3:
> Otherwise, you can drop trafodion -> initialize trafodion, drop;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)