引入失败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 |