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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• External issue URL: https://bugs.launchpad.net/bugs/1443617
• Assignee: Unassigned
• Reporter: JiepingZhang
• Created: 22/Jul/15 18:20
• Updated: 07/Oct/15 06:25
• Resolved: 07/Oct/15 06:25

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)