SQLCODE = -911：“ warehouser_error_message”：“由于dashDB中的异常，无法加载文件<<文件名> .csv.zip”

问题描述

Cloudant Schema Discovery Process（SDP）在加载我的dashDB数据库时报告以下错误消息：

The Cloudant Schema Discovery Process (SDP) is reporting the following error message while loading my dashDB database:

"warehouser_error_message": "File xxxxxx/xxxxxx_nnnn_nnn_n_n.csv.zip
   could not be loaded due to an exception in dashDB. Reason: <DB2 SQL
   Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=4.18.60>"

我该如何解决？

推荐答案

SDP在初始加载期间锁定数据库。 -911错误表示存在锁争用问题。确保您没有对SDP正在加载的数据库表执行任何其他操作。

The SDP locks the database during the initial load. The -911 error indicates there is a lock contention issue. Ensure you aren't performing any other operations on the database table that is being loaded by the SDP.

要查找当前的加载状态，请参见以下问题：

For find the current load status, see this question: How can I tell if my SDP process is still running the 'initial' load?

这篇关于SQLCODE = -911：“ warehouser_error_message”：“由于dashDB中的异常，无法加载文件<<文件名> .csv.zip”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！