Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-835

AdminApi (thru AdminShell) allows deletion of an active VDB from under a connected user

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 6.2.0
    • 6.2.0
    • AdminApi
    • None

    Description

      I used two AdminShell sessions to demonstrate this: one connected as an administrator and the other connected as a user to a VDB.

      Admin: addVDB("VDB name", "VDB file")
      User: SELECT ...
      Admin: deleteVDB("VDB name","version")
      User: SELECT ...

      At this point the user receives:
      // Error: // Uncaught Exception: TargetError : at Line: 165 : in file: URL: jar:file:/home/pnittel/teiid62RC1/adminshell/lib/teiid-adminshell-6.2.0-SNAPSHOT.jar!/scripts/jdbc.bsh : throw e ;

      Target exception: com.metamatrix.jdbc.MMSQLException: VDB "qt_db2v81ds" version "1" does not exist or not in valid state.

      The MetaMatrix (Console) way of doing things is to defer deletion of the VDB until there are no active connections. Also, it was required that the VDB status be INACTIVE before the request to delete would be honored.

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            metapaul Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: