Error 1234 returned trying to run SQL requests
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Committed
|
Critical
|
Roberta Marton |
Bug Description
After merging with https:/
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/
*** 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.
create 'TRAFODION.
quit
sqlci
initialize authorization, drop;
exit;
swhbase
disable 'TRAFODION.
drop 'TRAFODION.
disable 'TRAFODION.
drop 'TRAFODION.
exit
Workaround #3:
Otherwise, you can drop trafodion -> initialize trafodion, drop;
Changed in trafodion: | |
importance: | Undecided → Critical |
assignee: | nobody → Roberta Marton (roberta-marton) |
tags: | added: sql-security |
If code is refreshed with https:/ /review. trafodion. org/1635 (which adds the
first phase of column level privileges), authorization is enabled, and running
in debug mode; error 1234 is returned and you are not able to drop or
initialize authorization. SQL requests fail.
The fix is to allow operations to proceed even if TEST129( column privileges regression test).
there are missing privilege manager tables, to turn off checks
for column level privileges (can be turned on by setting cqd CAT_TEST_BOOL)
and to not run catman1/