Can not import from storage

[James McManus]

When I attempt to import a file using the console, to cloud sql, from storage I get the following message when I "Browse" for the file:

Object not available. Either it does not exist or you do not have access. Try browsing for the object instead.

I've done this many times before and have not had this problem. I've tried changing permissions on the file, in storage, but have the same problem. I can also can download the file, directly using a url, so I do not think the problem is with storage. 

If I change the path, to the file, in the cloud sql import "Browse" console to:

danudata/danunews%2F2016%2Flatest_news_feed080916.csv

I no longer get the error message, but it then fails to import the data.

This appears to be a problem with google sql import console. Has anybody else had this problem? Are there solutions?

Thanks

Jim

[Thomas Locke]

I'm also getting the exact same message via the portal, which is very frustrating. Not being able to import is having a detrimental effect on the business I'm working with.

Interestingly I've also been running automatic nightly db imports via the gcloud sdk for the last few months. The last successful import occurred on Friday the 5th August.   

The error I get from running the import via gcloud now is below;

ERROR: (gcloud.sql.instances.import) ERROR_RDBMS

This error usually points to some permission issues, however the permissions look to be correct and they were the same permissions that always worked pre August the 6th.

I actually think the issue is related to the mysql db user that GCP uses to perform the import. The error in the operation log would seem to confirm thi.s 

 ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Regards,

Thomas

[David Newgas]

Hi folks,

The Cloud SQL team is working on the issue that Jim describes.

I believe that the issue Thomas describes is actually different.  I suggest you take a look at what line 14 of your import file actually says. You will likely find that it is a command that requires SUPER privilage, perhaps attempting to installing a plugin, or creating an event or trigger with a DEFINER set. You should be able to modify the import file not to have anything that requires SUPER privileges and it'll import. If you want to share the offending line I'll try and help.

David

--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/bc21d141-dcec-4c25-aa70-a591bc194534%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[James McManus]

I've been able to import using gcloud, but still have the same problem using the console. The fact that I can use %2F in place of /, and the error goes away, makes me think it is a problem with javascript in the front end. The string with %2F eventually fails when importing, but that make sense since gcloud would not recognize it.

Jim

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscr...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/bc21d141-dcec-4c25-aa70-a591bc194534%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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/wHB164qEsoM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bYF_%2BpH0TamsiaM_Fz%2BLvVvJQpDs5Eqt0%3DMbqqL%2Bpu9Vw%40mail.gmail.com.

[Vadim Berezniker]

Sorry about that James, it should be fixed soon.

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/bc21d141-dcec-4c25-aa70-a591bc194534%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
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/wHB164qEsoM/unsubscribe.

To unsubscribe from this group and all its topics, send an email to google-cloud-sql-d...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bYF_%2BpH0TamsiaM_Fz%2BLvVvJQpDs5Eqt0%3DMbqqL%2Bpu9Vw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAFXM4AxWOzns4YPdWu3GfLsfFYL6V%3D4hw183_8oAAseT1K7fTw%40mail.gmail.com.

[Gaurav Dubey]

 I am also getting same error , I exported dumb from first gen cloud sql and importing from to second gen cloud sql getting error ERROR 1227 (42000) at line 22: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Line number 22 : CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET utf8 */;

Please help i am facing this issue from last 15 days

[Rohit Manglik]

Hi,

I am also getting same error. Is there any workaround for this problem?

 ERROR 1227 (42000) at line 22: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I am having a down time because of this error.

Any lead?

[Vadim Berezniker]

When you perform the export, you should specify the databases you want to export.

The issue stems from the fact that the export you have tries to perform DDL changes on the mysql database which we do not allow. 

Alternatively, edit your existing export to remove any statements that modify the mysql database.

--

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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ccd228e7-95d4-454f-90e2-91cd34c40998%40googlegroups.com.

[Brett Peary]

It should say this in the docs. Basically, you can't import a whole instance through the console, I guess. An error to that effect would help. Too bad I spent 4 hours trying to figure out why it was not working. 

On Sunday, November 20, 2016 at 9:15:06 AM UTC+9, Vadim Berezniker wrote:

When you perform the export, you should specify the databases you want to export.

The issue stems from the fact that the export you have tries to perform DDL changes on the mysql database which we do not allow. 

Alternatively, edit your existing export to remove any statements that modify the mysql database.

On Fri, Nov 18, 2016 at 1:01 PM Rohit Manglik <rohit....@gmail.com> wrote:

Hi,

I am also getting same error. Is there any workaround for this problem?

 ERROR 1227 (42000) at line 22: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I am having a down time because of this error.

Any lead?

On Tuesday, 9 August 2016 22:09:12 UTC+5:30, James McManus wrote:

When I attempt to import a file using the console, to cloud sql, from storage I get the following message when I "Browse" for the file:

Object not available. Either it does not exist or you do not have access. Try browsing for the object instead.

I've done this many times before and have not had this problem. I've tried changing permissions on the file, in storage, but have the same problem. I can also can download the file, directly using a url, so I do not think the problem is with storage. 

If I change the path, to the file, in the cloud sql import "Browse" console to:

danudata/danunews%2F2016%2Flatest_news_feed080916.csv

I no longer get the error message, but it then fails to import the data.

This appears to be a problem with google sql import console. Has anybody else had this problem? Are there solutions?

Thanks

Jim

--
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+unsub...@googlegroups.com.

[J Ramon Marco]

Hi all,

Same issue, I have solved it trying to do same but by command line:

LOAD DATA INFILE ... CHARACTER SET 'utf8'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\"'.

Regards.

More info: https://cloud.google.com/sql/docs/mysql/import-export/importing

[J Ramon Marco]

Hi all,

I've got same issue, I solved it trying to do same by command line:

LOAD DATA INFILE ... CHARACTER SET 'utf8'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\"'.

More info: https://cloud.google.com/sql/docs/mysql/import-export/importing

El martes, 9 de agosto de 2016, 18:39:12 (UTC+2), James McManus escribió: