普适数据库中的SQl_satements问题

Question

声明

从MWlog中选择*

正确工作

同时声明：

从MWlog选择*，其中Probe= '230541‘

使用以下错误：<<<<<<<<<<<<<<<<<<<<<<<< select *来自MWlog，其中Probe= '230541‘LNASQL EngineThe应用程序遇到I/O错误(Btrieve错误2)

提示:我们使用禅宗版本：

禅宗控制中心

Zen安装版本14.10.035。

Java版本1.8.0_222。

版权(版权)2020年Actian公司

同样的错误发生在老版本中：

Answer 1

如果只在使用“探测”字段时发生这种情况，则索引可能已损坏。我建议重建档案。您可以使用BUTIL -CLONE和-COPY命令或重建实用程序。我更喜欢BUTIL -克隆/复制。

状态2(在https://docs.actian.com/zen/v14/index.html#page/codes%2F1statcod.htm%23ww178919上)定义为：

2: The application encountered an I/O error This status code typically indicates a corrupt file, an error while reading from or writing to the disk. One of the following has occurred: 
• The file is damaged, and you must recover it. See Advanced Operations Guide for more information on recovering files. •For pre-v6.0 data files, there is a large pre-image file inside a transaction, and there is not enough disk space for a write to the pre-image file. 
• For pre-v6.0 data files, there is one pre-image file for multiple data files. For example, if you name the data files customer.one and customer.two, both files have pre-image files named customer.pre. 
• For pre-v6.0 data files that are larger than 768 MB, there is a conflict among locking mechanisms. The file has not been corrupted. Your application can retry the operation until the conflict is resolved (when the competing application releases the lock your application requires). 
• A pre-v6.0 Btrieve engine attempted to open a v6.x or later MicroKernel file. 
• With Btrieve for Windows NT Server Edition v6.15.445, 32 bit Windows application may return Status 2 or “MKDE Terminated with Service Specific Error 0” after running an application for an extended period of time.