引入失败Ingestion failures

.show ingestion failures.show ingestion failures

此命令返回一个结果集,该结果集包含数据引入控制命令运行时发生的任何引入失败。This command returns a result set that includes any ingestion failures that occur when the data ingestion control commands run.

备注

引入流的其他部分发生的引入失败不会出现在此命令的结果集中。Ingestion failures that occur during other parts of the ingestion flow will not appear in the result set of this command. 例如,在将数据引入控制命令发送到 Kusto 数据引擎服务之前,可能会发生这种故障。Such a failure may occur, for example, before data ingestion control commands are sent to the Kusto Data Engine service.

若要详细了解如何监视在涉及排队引入的流中发生的故障,请参阅此指南For more information on monitoring failures that occur in flows that involve queued ingestion, see this guide.

语法Syntax

语法选项Syntax option 描述Description
.show ingestion failures.show ingestion failures 返回所有已记录的引入失败Returns all recorded ingestion failures
.show ingestion failures | where ....show ingestion failures | where ... 返回一组筛选的引入失败Returns a filtered set of ingestion failures
.show ingestion failures with(OperationId="OperationId").show ingestion failures with(OperationId="OperationId") 返回特定操作 ID 的引入失败Returns ingestion failures for a specific Operation ID

结果Results

输出参数Output parameter 类型Type 说明Description
OperationIdOperationId StringString 操作标识符,可用于通过Operation identifier that can be used to view additional operation details via the
.show operations 命令查看其他操作详细信息.show operations command
数据库Database 字符串String 发生失败的数据库Database on which the failure occurred
Table StringString 发生失败的表Table on which the failure occurred
FailedOnFailedOn DateTimeDateTime 对失败进行注册的日期/时间 (UTC)Date/time (in UTC) when the failure was registered
IngestionSourcePathIngestionSourcePath StringString 标识引入源(通常为 Azure Blob URI)Identifies the ingestion source (usually, an Azure Blob URI)
详细信息Details StringString 失败详细信息。Failure details. 提供对实际引入失败根本原因的见解Provides insight into the actual ingestion failure root cause
FailureKindFailureKind StringString 失败类型(永久/暂时)Type of the failure (Permanent/Transient)
RootActivityIdRootActivityId StringString 根活动 ID。Root Activity ID.
OperationKindOperationKind StringString 引入操作类型(阶段),在此期间已对失败进行注册The ingestion operation type (phase) during which the failure was registered
OriginatesFromUpdatePolicyOriginatesFromUpdatePolicy 布尔Boolean 指示在执行更新策略时是否注册了失败Indicates whether the failure was registered while executing an Update Policy

示例Example

OperationIdOperationId 数据库Database Table FailedOnFailedOn IngestionSourcePathIngestionSourcePath 详细信息Details FailureKindFailureKind RootActivityIdRootActivityId OperationKindOperationKind OriginatesFromUpdatePolicyOriginatesFromUpdatePolicy
3827def6-0773-4f2a-859e-c02cf395deaf3827def6-0773-4f2a-859e-c02cf395deaf DB1DB1 Table1Table1 2017-02-14 22:25:03.11473312017-02-14 22:25:03.1147331 ...url......url... ID 为“*****.csv”的流出现 CSV 格式错误*Stream with ID '*****.csv' has a malformed CSV format* 永久性Permanent 3c883942-e446-4999-9b00-d4c664f06ef63c883942-e446-4999-9b00-d4c664f06ef6 DataIngestPullDataIngestPull 00
841fafa4-076a-4cba-9300-4836da0d9c75841fafa4-076a-4cba-9300-4836da0d9c75 DB1DB1 Table1Table1 2017-02-14 22:34:11.25659432017-02-14 22:34:11.2565943 ...url......url... ID 为“*****.csv”的流出现 CSV 格式错误*Stream with ID '*****.csv' has a malformed CSV format* 永久性Permanent 48571bdb-b714-4f32-8ddc-4001838a956c48571bdb-b714-4f32-8ddc-4001838a956c DataIngestPullDataIngestPull 00
e198c519-5263-4629-a158-8d68f7a1022fe198c519-5263-4629-a158-8d68f7a1022f DB1DB1 Table1Table1 2017-02-14 22:34:44.58247412017-02-14 22:34:44.5824741 ...url......url... ID 为“*****.csv”的流出现 CSV 格式错误*Stream with ID '*****.csv' has a malformed CSV format* 永久性Permanent 5e31ab3c-e2c7-489a-827e-e89d2d691ec45e31ab3c-e2c7-489a-827e-e89d2d691ec4 DataIngestPullDataIngestPull 00
a9f287a1-f3e6-4154-ad18-b86438da0929a9f287a1-f3e6-4154-ad18-b86438da0929 DB1DB1 Table1Table1 2017-02-14 22:36:26.55252502017-02-14 22:36:26.5525250 ...url......url... 发生了未知错误:引发了“System.Exception”类型的异常Unknown error occurred: Exception of type 'System.Exception' was thrown 暂时性Transient 9b7bb017-471e-48f6-9c96-d16fcf938d2a9b7bb017-471e-48f6-9c96-d16fcf938d2a DataIngestPullDataIngestPull 00
9edb3ecc-f4b4-4738-87e1-648eed2bd9989edb3ecc-f4b4-4738-87e1-648eed2bd998 DB1DB1 Table1Table1 2017-02-14 23:52:31.54600712017-02-14 23:52:31.5460071 ...url......url... 下载 blob 失败:客户端无法在指定的超时时间内完成操作Failed to download blob: The client couldn't finish the operation within specified timeout 永久性Permanent 21fa0dd6-cd7d-4493-b6f7-78916ce0d61721fa0dd6-cd7d-4493-b6f7-78916ce0d617 DataIngestPullDataIngestPull 00