Sybase ASE Error: Server error:8242, Severity:16, state:1

Yesterday morning, colleagues reflect a system in the process of executing stored procedures error, error information is as follows:

05:00000:00009:2014/06/09 15:45:30.34 Server error:8242, Severity:16, state:1
05:00000:00009:2014/06/09 15:45:30.34 Server The table ' user_files ' in database ' Prodb ' was bound to metadata cache memory. Unbind the table and retry the query later.

A single-table query was attempted on the table, and no error was found, but the process of executing the stored procedure was not executed. After consulting the relevant data, found that the problem is ASE in the lower version of the bug, mainly due to the metadata cache problem, the solution is mainly as follows:

1, upgrade the ASE version, but related to lisence problems.

2. Restart the database. Re-initializes the contents of the metadata cache.

3, without restarting the database, the information in the metadata cache is removed through DBCC CACHEREMOVE (library name, table name).

Due to the fact that there are a lot of problems in the observation log, it is decided to schedule a planned restart of the database to resolve the problem for the sake of insurance.

After restarting, the problem is handled.