Google Cloud MAJOR
Global: Cloud Spanner Query and Data UI pages not returning results for tables
August 29, 2022 · 01:30 PM UTC – 07:02 PM UTC · Duration: 29h 32min
Affected Services
Cloud Spanner
Timeline
11:04 PM
Mini Incident Report
We apologize for the inconvenience this service disruption/outage may have caused. We would like to provide some information about this incident below. Please note, this information is based on our best knowledge at the time of posting and is subject to change as our investigation continues. If you have experienced impact outside of what is listed below, please reach out to Google Cloud Support using https://cloud.google.com/support.
(All Times US/Pacific)
Incident Start: 29 August 2022 05:30
Incident End: 30 August 2022 11:02
Duration: 29 hours, 32 minutes
Affected Services and Features:
Google Cloud Platform - Cloud Spanner Console
Regions/Zones: Global
Description:
Google Cloud Spanner Query and Data UI pages, in the Cloud Console, experienced issues returning results for tables globally for 29 hours and 32 minutes. From preliminary analysis, the root cause of the issue was a change in formatting of array column types for display that did not account for nulls.
Customer Impact:
Affected customers may have experienced issues rendering query results on the data page and query page if the table included an array.
This only affected the Spanner Console, gCloud interface worked as expected.
07:22 PM
The issue with Cloud Spanner has been resolved for all affected users as of Tuesday, 2022-08-30 11:02 US/Pacific.
We thank you for your patience while we worked on resolving the issue.
06:54 PM
Summary: Global: Cloud Spanner Query and Data UI pages not returning results for tables
Description: We believe the issue with Cloud Spanner is partially resolved. Our engineers are working to validate the fix is working as expected.
We will provide an update by Tuesday, 2022-08-30 11:30 US/Pacific with current details.
Diagnosis: Data page and Query page will not render query results if the table has an array. This is only affecting the console only, gCloud interface is working as expected.
Workaround: Users may use alternative interfaces such as Cloud SDK (gcloud) or client libraries to query the affected tables.
06:24 PM
Summary: Global: Cloud Spanner Query and Data UI pages not returning results for tables
Description: We believe the issue with Cloud Spanner is partially resolved. Our engineers are working to validate the fix is working as expected.
We will provide an update by Tuesday, 2022-08-30 11:00 US/Pacific with current details.
Diagnosis: Data page and Query page will not render query results if the table has an array. This is only affecting the console only, gCloud interface is working as expected.
Workaround: Users may use alternative interfaces such as Cloud SDK (gcloud) or client libraries to query the affected tables.
05:36 PM
Summary: Global: Cloud Spanner Query and Data UI pages not returning results for tables
Description: Mitigation work is currently underway by our engineering team.
The mitigation is expected to complete by Tuesday, 2022-08-30 10:00 US/Pacific.
We will provide more information by Tuesday, 2022-08-30 10:30 US/Pacific.
Diagnosis: Data page and Query page will not render query results if the table has an array. This is only affecting the console only, gCloud interface is working as expected.
Workaround: Users may use alternative interfaces such as Cloud SDK (gcloud) or client libraries to query the affected tables.
05:32 PM
Summary: Global: Cloud Spanner Query and Data UI pages not returning results for tables
Description: We are experiencing an issue with Cloud Spanner.
Our engineering team continues to investigate the issue.
We will provide an update by Tuesday, 2022-08-30 10:00 US/Pacific with current details.
We apologize to all who are affected by the disruption.
Diagnosis: Data page and Query page will not render query results if the table has an array. This is only affecting the console only, gCloud interface is working as expected.
Workaround: Users may use alternative interfaces such as Cloud SDK (gcloud) or client libraries to query the affected tables.