Hi Folks - I have opened this new issue and am wondering if others have seen it, and if there are any mitigations to prevent this from happening : https://issues.apache.org/jira/browse/DERBY-7113
>From time to time an Index keeps a value, which has been deleted from the underlying table. This results in an error is the row with the value is selected. SELECT ID from Some.TABLE WHERE IndexedColumn= 'Remembered Value'; ID -------------------- 1680880176 ERROR 0A000: The DRDA command parseSQLDIAGSTT is not currently implemented. The connection has been terminated. If only the Indexed Column is selected, then the Query returns 0 rows and produces no error - because just the index is searched. The Query Plan shows the index being used. Dropping and Recreating the index fixes the issue. However, I can reproduce this by reloading a database backup. Any advice appreciated, Kind Regards, Geraldine ----------------------------------------------------------------------------------------------------------------------- Geraldine McCormack L3 Team Lead - TBSM & Netcool/Impact IBM Ireland Visit the IBM Support Portal to open a case, download fixes, access product documentation, education and training materials. Visit our devcenters (applications and operations) for blogs, docs and resources brought to you by the technical people who create our offerings. ------------------------------------------------------------------
