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

LP Bug: 1443617 - Drop table got Error[4254]: Object has invalid state and can't be accessed

    XMLWordPrintableJSON

    Details

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

      Description

      I have run into this error for several times, so I am filing a bug to trace this issue.

      Sometimes drop table will fail with ERROR[4254], object has invalid state and cannot be accessed.

      >>set schema odbctest;

      — SQL operation complete.
      >>drop table GTN2BSG5FQ cascade;

          • ERROR[4254] Object TRAFODION.ODBCTEST.GTN2BSG5FQ has invalid state and cannot be accessed. Use cleanup command to drop it.

      — SQL operation failed with errors.

      The table above is on onyx13(16.235.158.113)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhangjie JiepingZhang
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: