[CANCELLED][US Region] Database maintenance
Scheduled Maintenance Report for Treasure Data
We decided to cancel this maintenance, because we found that the target Database version has a critical issue causing silent data corruption. So, we will reschedule our Database maintenance once new version fixing this issue is released.
Posted Jun 24, 2022 - 01:19 PDT
On July 6th, 2022 from 13:15 to 14:15 PDT, we will be performing maintenance on the PlazmaDB Metadata database. During the maintenance we will upgrade the version of the Metadata database in order to improve performance and reliability.

Although the maintenance window duration is 60 minutes, the database will only become unreachable for a portion of the operation, which should last no longer than 5 minutes in total. We expect this to be followed by a recovery period of around 30 minutes during which the system will gradually return to full throughput.

# Impact

During the maintenance and recovery, customers may experience the following:

- Streaming, Mobile, and JavaScript/Browser imports delay

Streaming import requests to PlazmaDB (through API, td-agent or fluentd) will continue to be accepted as usual but the requests will remain queued until after the database maintenance is complete. We expect stream import processing to be further delayed during recovery.
The same will apply to import requests from Browsers (Javascript SDK), Mobile (Android, iOS, and Unity SDKs), and Postback APIs.
Streaming import to ADL will have no impact.

- Job execution delay

All jobs (Presto, Hive, Data Connector Integrations, Bulk Import, Export, and Partial Delete jobs submitted from Console, API, Workflow or triggered by our system according to the configured schedule) will be delayed and will be automatically retried until they succeed after the downtime period. During recovery, we expect jobs to begin processing slowly: within 30 minutes job processing should return to full throughput.
Data Workbench and Audience Studio will show that jobs are running longer due to underlying job execution delay due to failure of the underlying Parent Segments, Segments, and Workflows jobs that overlap with the maintenance period. During recovery, we expect processing of Data Workbench and Audience Studio jobs to follow the same recovery pattern as all other jobs.

- Presto JDBC / ODBC Gateway return errors during downtime

The Presto JDBC / ODBC Gateway will return errors during the downtime period.

- Table creation and transfer return errors during downtime

During the downtime period, REST API requests to create tables will fail and will need to be retried. On the other hand, attempts to create tables via SQL or Workflow will be delayed and will be automatically retried until they succeed after the downtime period.

- Data Access API (beta) return errors during downtime

Data Access API (Plazma Public API) for Spark will return errors during downtime period.

# Communication

Beyond this notice, we will provide updates approximately 1 hour before the beginning of the maintenance window, at the start and completion of the operation, and once the verification is completed. At that time, all systems will have returned to full functionality and the Scheduled Maintenance will be closed.

If you have any question or concern about this maintenance, please feel free to reach out to our Support team at support@treasure-data.com.
Posted Jun 01, 2022 - 10:58 PDT
This scheduled maintenance affected: US (Web Interface, REST API, Streaming Import REST API, Mobile/Javascript REST API, Data Connector Integrations, Hadoop / Hive Query Engine, Presto Query Engine, Presto JDBC/ODBC Gateway, Workflow, CDP API, Data Access API (beta)).