1
votes

In cloud SQL, I am getting an error on exporting one particular Postgres database using SQL type export. The error I see in the notification is "Unknown error." If I retry from notification it shows "The server has encountered a problem. Please try again." How to fix this?

enter image description here

Notification on failure: enter image description here

On Clicking Retry: enter image description here

log: enter image description here

2

2 Answers

0
votes

More information about an export operations can be gathered by checking the status of the export (here is how), and looking into the operations logs (here is how). If the logs do not reveal insights to help fix the issue, then more details should be shared as to how the export operation is performed by looking at the different methods (explained here). Be as explicit as possible, and please share the expanded logs while obfuscating private information.

0
votes

I actually had the same issue recently (including the same "connection to client lost" in the logs). When searching noticed that there was maintenance pending on the sql instance. After scheduling the maintenance and rebooting the instance, exporting worked once again.