BigQuery Routine部署失败，报错“Unknown option: description”技术求助

分享一个我们遇到的突发BigQuery部署问题，希望能帮到同样踩坑的人，也请Google相关技术人员留意：

我们日常使用Terraform将BigQuery对象（数据集、表、例程等）部署到GCP europe-west2区域，此前每日多次执行都一切正常，但在2021-08-18T21:15:44.033910202Z突然出现例程部署失败的情况，所有失败请求均返回相同错误：

status: { code: 3 message: "Unknown option: description" }

相关错误日志（已隐去项目名称） #

{"protoPayload": { "@type": "type.googleapis.com/google.cloud.audit.AuditLog", "status": { "code": 3, "message": "Unknown option: description" }, "authenticationInfo": { "principalEmail": "deployer-dev@myadminproject.iam.gserviceaccount.com", "serviceAccountDelegationInfo": [ { "firstPartyPrincipal": { "principalEmail": "deployer-dev@myadminproject.iam.gserviceaccount.com" } } ] }, "requestMetadata": { "callerIp": "10.51.0.116", "callerSuppliedUserAgent": "Terraform/0.14.7 (+https://www.terraform.io) Terraform-Plugin-SDK/2.5.0 terraform-provider-google/3.69.0,gzip(gfe)", "callerNetwork": "//compute.googleapis.com/projects/myadminproject/global/networks/__unknown__", "requestAttributes": {}, "destinationAttributes": {} }, "serviceName": "bigquery.googleapis.com", "methodName": "google.cloud.bigquery.v2.RoutineService.InsertRoutine", "authorizationInfo": [ { "resource": "projects/myproject/datasets/p00003818_dp_model", "permission": "bigquery.routines.create", "granted": true, "resourceAttributes": {} } ], "resourceName": "projects/myproject/datasets/p00003818_dp_model/routines/UserProfile_Events_AllCarData_Deployment", "metadata": { "routineCreation": { "routine": { "routineName": "projects/myproject/datasets/p00003818_dp_model/routines/UserProfile_Events_AllCarData_Deployment" }, "reason": "ROUTINE_INSERT_REQUEST" }, "@type": "type.googleapis.com/google.cloud.audit.BigQueryAuditMetadata" } }, "insertId": "ak27xdbke", "resource": { "type": "bigquery_dataset", "labels": { "dataset_id": "p00003818_dp_model", "project_id": "myproject" } }, "timestamp": "2021-08-18T21:15:43.109609Z", "severity": "ERROR", "logName": "projects/myproject/logs/cloudaudit.googleapis.com%2Factivity", "receiveTimestamp": "2021-08-18T21:15:44.033910202Z" }

关键观察与推测 #

• 我们完全没有修改本地配置或操作流程，因此可以排除自身变更导致的问题，推测这是Google端的服务异常。
• 问题呈现传播特性：先在一个项目中出现，数分钟后扩散到另一个项目，这个现象可能对问题定位有参考价值。

复现验证 #

后续我通过BigQuery的Insert Routine接口复现了该问题：

• 当请求Payload中不包含description字段时，例程能够成功创建；
• 当Payload中包含description字段（该字段属于官方文档明确的合法参数）时，请求立即失败并返回上述"Unknown option: description"错误。

内容的提问来源于stack exchange，提问作者jamiet