Friday, May 31, 2019

[google-cloud-sql-discuss] Cloud Sql Backup Error Blocking Cloud Sql


Hi,

I have a cloud-sql instance with an automated backup enabled, today just after the backup I received the following error appeared in operation :-

May 31, 2019, 5:57:24 AMDelete backup An unknown error occurred


Following that following code error appeared in the cloud-sql log ; -
2019-05-31 05:55:35.424 IST 2019-05-31T00:25:35.423588Z 17866 [ERROR] InnoDB: Write to file ./ibtmp1failed at offset 10801456873472, 1048576 bytes should have been written, only 0 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quot

After this cloud-sql became almost unresponsive to the queries  until I have to restart the instance. My question is  Automated Backup is the root cause of problem ? If yes, how shall I avoid it in future so that my business does not suffers . 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/65912345-bf49-45c3-9084-081a04648569%40googlegroups.com.

No comments:

Post a Comment