Re: [google-cloud-sql-discuss] Re: Error exporting PostgreSQL to GCS

Hi Nicolas,

please find below the output of the suggested command, which is not much more informative than what is shown in the UI. Reading the message I decided to try if there might be a permissions issue, so I added the DB's service account to the bucket, but that made no difference.

My understanding of why we're paying Google $2500/mo to operate a SQL database is that we'd be spending less time on Stack Overflow, not more. Please correct me if I am wrong.

Best,

- Friedrich


```
{
"kind": "sql#operation",
"targetLink": "https://www.googleapis.com/sql/v1beta4/projects/$PROJECT/instances/$INSTANCE",
"status": "DONE",
"user": "$ACCOUNT@$PROJECT.iam.gserviceaccount.com",
"insertTime": "2019-07-02T07:53:55.078Z",
"startTime": "2019-07-02T07:53:55.236Z",
"endTime": "2019-07-02T07:55:26.728Z",
"error": {
"kind": "sql#operationErrors",
"errors": [
{
"kind": "sql#operationError",
"code": "ERROR_RDBMS",
"message": "Error while uploading file to gs://$PROJECT-cloudsql-backup/$EXPORT-20190702-1562054036993020801.partial.sql: Unknown error\n"
}
]
},
"operationType": "EXPORT",
"exportContext": {
"uri": "gs://$PROJECT-cloudsql-backup/$EXPORT-20190702.sql",
"databases": [
"$DATABASE"
],
"kind": "sql#exportContext",
"sqlExportOptions": {
"schemaOnly": false,
"mysqlExportOptions": {
"masterData": 0
}
},
"fileType": "SQL"
},
"name": "4da5da56-fcd5-45c8-9864-9450ca0c0af4",
"targetId": "$INSTANCE",
"selfLink": "https://www.googleapis.com/sql/v1beta4/projects/$PROJECT/operations/4da5da56-fcd5-45c8-9864-9450ca0c0af4",
"targetProject": "$PROJECT"
}
```

> On 2. Jul 2019, at 01:19, 'Nicolas (Google Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:
>
> Hi Friedrich,
>
> I would recommend you to bring your question to Stackoverflow with the output of the equivalent gcloud command with the --log-http flag so the community have extra information to help you troubleshoot this issue. The command could look something like this :
>
> gcloud sql export sql [INSTANCE_NAME] [BUCKET_NAME]/sqldumpfile.gz\ --database=[DATABASE_NAME]\
> --log-http
>
>
> On Friday, June 28, 2019 at 2:53:01 PM UTC-4, Friedrich Lindenberg wrote:
> Hey all,
>
> I'm trying to export two fairly large databases from Cloud SQL to a bucket, but the UI job gets cancelled after a few minutes. The operations logs only shows this:
>
> Error while uploading file to gs://xxx/xxx_2019-06-28 (17:37:32)-1561736277136192705.partial: Unknown error
>
> I had to have assigned ownership of the DBs to separate users, perhaps there is a permissions problem --do I need to transfer ownership of the DBs back to cloudsqladmin for export?
>
> - Friedrich
>
> --
> You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/CXYhX6s8itk/unsubscribe.
> To unsubscribe from this group and all its topics, 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/3a0c8f8e-8323-4530-9ed0-eaffc9604907%40googlegroups.com.

--
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/A7779235-CBB2-43C8-804A-2F83200F019F%40occrp.org.