Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1110

LP Bug: 1438856 - Internal error returns during authentication after grant/revoke component priv



    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1 (pre-incubation)
    • Component/s: sql-security
    • Labels:


      The following is returned during authentication for a valid user:

          • ERROR[8837] Internal error occurred. User: TRAFODION

      This seems to happen after component privileges are granted/revoked in a previous session.

      To reproduce the problem you could do the following:

      Log on to the system as yourself, then switch to trafodion.
      Revoke the privilege in sqlci: revoke component privilege show on sql_operations from "PUBLIC";
      Try to connect through ODBC/JDBC from your client. The error should occur.

      More details can be found in email thread. I have not included it here since there are system info and passwords everywhere. Let me know if you need more details. Here is a summary:

      ... was again reporting internal errors on <cluster>. I really think this is because we authenticate as one user say <user1> and in next session try to access the metadata as that user ( even if it is for the same user <user1> or Trafodion ). This raises error 4481 leading to internal error.

      Should we be resetting the id back to DB__ROOT after each disconnect ? or is there some other solution ?




            • Assignee:
              cliffgray Cliff Gray
              paul.low Paul Low
            • Votes:
              0 Vote for this issue
              3 Start watching this issue


              • Created: