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

Source: Internet
Author: User
Tags sybase

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.