MySQL Flex in read-only mode after SQL import

Question

We have a MySQL Flex database that has gone into read-only mode twice. Both times it happened during an import of a SQL dump.

Can someone help:

• understand why this is being triggered;
• understand how to recover from it? We've noticed that it goes away overnight but it we would like a quicker solution

This is the error we get when trying to run a write query on the service:

SQL Error [1290] [HY000]: The MySQL server is running with the --read-only option so it cannot execute this statement
  The MySQL server is running with the --read-only option so it cannot execute this statement
 

Answer 1

Hi @Manuel Capinha

Please inspect the server's storage, as it may be reaching capacity during the data import operation.

You can verify this by accessing the portal and navigating to Monitoring-Metrics.

If this is indeed the issue, you may need to consider increasing the storage capacity during data import.

Snippet from the document-

Thank you!