# 2021-10-26-14:00:00 +0800 Fix price of t1.small cluster tier

- Cause:

Due to the db schema refactoring migration, the price of t1.small cluster tier components are not set.

- Operation:

  - Adjust the price of t1.small cluster tier to `0.153` on Management Portal

  - Execute the following SQL commands:

    ``` sql
    select * from machine_profiles where instance_type = 'n1-standard-1'; -- The machine_profile id is 517962
    select * from regions where name = 'asia-northeast1';; -- The region id is 118905
    select * from region_machines where machine_profile_id = 517962 and region_id=118905;; -- The region_machine id is 260035
    select * from region_machine_prices where region_machine_id = 260035 order by effected_at; -- The id of the record is 377340
    update region_machine_prices set effected_at='2021-09-30 12:00:00' where id=377340;
    ```

  - Check it on pricing and billing page

- Impact:
The price will be corrected

- Recovery operation:

Execute the following SQL command to revert the changes

- Time window:

2021-10-26 14:00 ~ 14:30 CST