[google-cloud-sql-discuss] Re: Connection Pool

Hey Ricardo,

How are you timing the operation? Is it possible that this time could also involve the creation of objects? You could attempt to create a temporary Compute Engine instance in the same region and test connection times from there, as well, to get another angle on determining how much the time observed in your timing code is influenced by the instance itself.

Cheers,

Nick
Cloud Platform Community Support

On Friday, August 26, 2016 at 9:12:13 AM UTC-4, Ricardo Meneghin Filho wrote:

How much time is it expected to take to make a new connection? I have an appengine instance on the same region as my second gen cloud sql server and each request takes 300 ~ 1000 ms just to make a connection, which is by far the lengthiest operation in the servlet lifetime.

Em terça-feira, 7 de maio de 2013 18:58:58 UTC-3, Joe Faith escreveu:

Hi Roland

The discussion never ends!

I'd be interested in your use case or requirements.

In particular, since the time to create a new connection is similar to that required to test the liveness of an existing connection, then I'm not sure how a connection pool would help?

j

On Tue, May 7, 2013 at 1:11 PM, Roland Beuker <roland...@arcus-business.com> wrote:

Hello Joe,

Is this the end of this discussion or is Google developing some kind of connection pooling towards Google Cloud SQL?

Regards,

Roland

Op vrijdag 2 maart 2012 18:07:05 UTC+1 schreef Joe Faith het volgende:

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

J

On Fri, Mar 2, 2012 at 1:16 AM, Rémi Bastide <remi.b...@gmail.com> wrote:

Good question ! I'm in need of the answer as well...

Le mardi 1 novembre 2011 19:44:30 UTC+1, javabuddy a écrit :

How to establish Connection Pool in GAE using AppEngineDriver in Cloud
SQL or native datastore??

Thanks

 

 

--
Joe Faith | Product Manager | Google Cloud

--
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.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Joe Faith | Product Manager | Google Cloud

--
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/c4bc7add-3c35-42d2-9d79-39b34de86ab2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Errors when setting root password or attempting to list users on second gen instance using gcloud

Hey Mark,

Thanks for getting in touch with us about this. A few questions:

Is this still occurring?

How long after creating the instance were you running these commands? 

What is the output of "gcloud beta sql instances list"?

If you could email me directly with your project ID and the name of the instance, we could also take a look directly. Usually issues like this should be reported to the Cloud SQL Public Issue Tracker, but we're happy to start work here and transfer there if something is found which will require progress updates. 

Cheers,

Nick
Cloud Platform Community Support

On Friday, August 26, 2016 at 3:51:49 PM UTC-4, Mark Betz wrote:

Hi, folks. I have a second gen. instance that has been created in our project using mysql 5.7. Nothing else has been done after using the console to create this instance. If I try to execute ...

$ gcloud sql instances set-root-password my_instance --password my_password

... I get the error "ERROR: (gcloud.sql.instances.set-root-password) The instance or operation is not in an appropriate state to handle the request."

On a perhaps related note if I try ...

$ gcloud beta sql users list --instance my_instance

... I get "ERROR: (gcloud.beta.sql.users.list) This operation isn"t valid for this instance."

Any help would be appreciated. The ability to execute these commands in script is intrinsic to our approach for managing access to database secrets in our kubernetes cluster.

Thanks very much!

--Mark

--
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/6d091c3d-a265-47df-8966-9696bf299bf3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Errors when setting root password or attempting to list users on second gen instance using gcloud

Hi, folks. I have a second gen. instance that has been created in our project using mysql 5.7. Nothing else has been done after using the console to create this instance. If I try to execute ...

$ gcloud sql instances set-root-password my_instance --password my_password

... I get the error "ERROR: (gcloud.sql.instances.set-root-password) The instance or operation is not in an appropriate state to handle the request."

On a perhaps related note if I try ...

$ gcloud beta sql users list --instance my_instance

... I get "ERROR: (gcloud.beta.sql.users.list) This operation isn"t valid for this instance."

Any help would be appreciated. The ability to execute these commands in script is intrinsic to our approach for managing access to database secrets in our kubernetes cluster.

Thanks very much!

--Mark

--
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/798e6f8f-379b-4ca9-b742-882a76ed67b9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Connection Pool

How much time is it expected to take to make a new connection? I have an appengine instance on the same region as my second gen cloud sql server and each request takes 300 ~ 1000 ms just to make a connection, which is by far the lengthiest operation in the servlet lifetime.

Em terça-feira, 7 de maio de 2013 18:58:58 UTC-3, Joe Faith escreveu:

Hi Roland

The discussion never ends!

I'd be interested in your use case or requirements.

In particular, since the time to create a new connection is similar to that required to test the liveness of an existing connection, then I'm not sure how a connection pool would help?

j

On Tue, May 7, 2013 at 1:11 PM, Roland Beuker <roland...@arcus-business.com> wrote:

Hello Joe,

Is this the end of this discussion or is Google developing some kind of connection pooling towards Google Cloud SQL?

Regards,

Roland

Op vrijdag 2 maart 2012 18:07:05 UTC+1 schreef Joe Faith het volgende:

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

J

On Fri, Mar 2, 2012 at 1:16 AM, Rémi Bastide <remi.b...@gmail.com> wrote:

Good question ! I'm in need of the answer as well...

Le mardi 1 novembre 2011 19:44:30 UTC+1, javabuddy a écrit :

How to establish Connection Pool in GAE using AppEngineDriver in Cloud
SQL or native datastore??

Thanks

 

 

--
Joe Faith | Product Manager | Google Cloud

--
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.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Joe Faith | Product Manager | Google Cloud

--
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/92bc65eb-17bb-4f52-b075-e44f9cb366a4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Anyway to disable only_full_group_by on 5.7

This is also affecting me. Need some way to remove only_full_group_by.

--
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/333dfcd2-c3f9-4eb9-8756-449fa9ceaa1e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: UNABLE TO DOWNLOAD DATA

The screens provided are of your own application. That's your own error message.

In case I misread the original post, are you the developer of this application, or are you just trying to use it?

On Wednesday, August 17, 2016 at 3:21:09 AM UTC-4, iLiNS Ghana wrote:

Hi 

Please find attached screen shots of the problem i posted earlier.

Below are the URLs of the sites i'm having problems with

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/filter///

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/export///

Thanks.

On Tuesday, August 16, 2016 at 11:59:35 AM UTC, ili...@gmail.com wrote:

Hi 

Please find attached screen shots of the problem i posted earlier.

Below are the URLs of the sites i'm having problems with

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/filter///

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/export///

Thanks.

On Monday, August 15, 2016 at 8:51:19 PM UTC, ili...@gmail.com wrote:

Hi, my name is Ebenezer.

I'm having challenges downloading data from my app engine. When i select a form to download data from, i get this error message "problem persist data or accessing data" and then the page refreshes itself. This happens several times until am able to download the data. Now am completely unable to even download the data.

I will be grateful for your help to fix this issue.

Thanks.

--
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/ddbb4da0-a5b4-4723-89ea-68b12efaa8c9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Linking Microsoft Access Tables

Hey Thomas,

It appears there are many Microsoft resources out there for migrating Access to a Microsoft SQL solution, and perhaps some for creating a mysqldump file. I found a Serverfault thread where users discussed dumping an Access DB to SQL. It might be necessary to put your DB into a read-only mode for the duration of the dump. Once you've produced a mysqldump file you'll want to try to import it to Cloud SQL. You can also import from CSV (all of this is in the Cloud SQL documentation). Cloud SQL supports replication.

As for administration, you'll have to set up a third-party tool for running queries, inspecting the data, as we currently only offer monitoring and administration interfaces for more abstract instance-level concerns in the "Developers Console > Cloud SQL" section. If this is your first time working with the Cloud Platform, you might want to get started with a Free Trial and make heavy use of the Getting Started guides, documentation and tutorials.

I hope this is helpful, let me know if you have any further questions!

Cheers,

Nick
Cloud Platform Community Support

On Wednesday, August 17, 2016 at 2:26:39 AM UTC-4, Thomas Dahl wrote:

I am very much a Newbee..  But, I have built a very complex replicated Access Database that has run perfectly for 15 years with a 7-8 users replicating to a Master sitting on our server.  It works great.  I am very proud of myself to have done this...

Now that Access is no longer supporting replication I need to figure out a way to move my back-end tables into SharePoint or some other Backend Server.

As I am very new to this whole concept I am looking for an easy solution.

Does anyone see a way to use Cloud SQL for this?  Any resources I can use?  Any literature?  Anything...   I am starting from a very low level of knowledge and cannot spend bundles of money or time getting it working.  Our Backend is just under 600Mb in size with a lot of records.

I presume that there are tools to help me administrate the Cloud SQL database...  I am not great at using a command line to run and administrate it.

Any help or starting points would be very much appreciated..!!

Regards
Thomas

--
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/18a44060-6587-4723-accd-9b2dfc78acac%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: UNABLE TO DOWNLOAD DATA

Hi 

Please find attached screen shots of the problem i posted earlier.

Below are the URLs of the sites i'm having problems with

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/filter///

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/export///

Thanks.

On Tuesday, August 16, 2016 at 11:59:35 AM UTC, ili...@gmail.com wrote:

Hi 

Please find attached screen shots of the problem i posted earlier.

Below are the URLs of the sites i'm having problems with

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/filter///

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/export///

Thanks.

On Monday, August 15, 2016 at 8:51:19 PM UTC, ili...@gmail.com wrote:

Hi, my name is Ebenezer.

I'm having challenges downloading data from my app engine. When i select a form to download data from, i get this error message "problem persist data or accessing data" and then the page refreshes itself. This happens several times until am able to download the data. Now am completely unable to even download the data.

I will be grateful for your help to fix this issue.

Thanks.

--
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/72f69823-7d65-438e-ab46-544eb3e284c7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Linking Microsoft Access Tables

I am very much a Newbee..  But, I have built a very complex replicated Access Database that has run perfectly for 15 years with a 7-8 users replicating to a Master sitting on our server.  It works great.  I am very proud of myself to have done this...

Now that Access is no longer supporting replication I need to figure out a way to move my back-end tables into SharePoint or some other Backend Server.

As I am very new to this whole concept I am looking for an easy solution.

Does anyone see a way to use Cloud SQL for this?  Any resources I can use?  Any literature?  Anything...   I am starting from a very low level of knowledge and cannot spend bundles of money or time getting it working.  Our Backend is just under 600Mb in size with a lot of records.

I presume that there are tools to help me administrate the Cloud SQL database...  I am not great at using a command line to run and administrate it.

Any help or starting points would be very much appreciated..!!

Regards
Thomas

--
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/a0e7fe0a-76f1-44f5-829a-cc18cd64e1f6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: UNABLE TO DOWNLOAD DATA

Hi 

Please find attached screen shots of the problem i posted earlier.

Below are the URLs of the sites i'm having problems with

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/filter///

https://ilins-odk-data.appspot.com/Aggregate.html#submissions/export///

Thanks.

On Monday, August 15, 2016 at 8:51:19 PM UTC, ili...@gmail.com wrote:

Hi, my name is Ebenezer.

I'm having challenges downloading data from my app engine. When i select a form to download data from, i get this error message "problem persist data or accessing data" and then the page refreshes itself. This happens several times until am able to download the data. Now am completely unable to even download the data.

I will be grateful for your help to fix this issue.

Thanks.

--
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/3d52dc02-f7b9-42aa-90c3-935266d2a2bf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Can not import from storage

Sorry about that James, it should be fixed soon.

On Thu, Aug 11, 2016 at 7:01 AM James McManus <jmpmcmanus@gmail.com> wrote:

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

On Wed, Aug 10, 2016 at 12:17 PM, 'David Newgas' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

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

On Wed, Aug 10, 2016 at 3:17 AM, Thomas Locke <thomas@relatelabs.com> wrote:

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

On Tuesday, August 9, 2016 at 5:39:12 PM UTC+1, 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+unsubscribe@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+unsubscribe@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-discuss+unsubscribe@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.
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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p3%2BL8s-SaWzwZdnYn5PBjpeAJ-jFDLzzHpUzXYXMoUEbA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: UNABLE TO DOWNLOAD DATA

Please provide the exact URLs for the page you're accessing, as it's unclear what page or site you're referring to. Screen shots are helpful. Please also copy and paste the exact error instead of paraphrasing it so it can be identified and searched on.

On Monday, August 15, 2016 at 4:51:19 PM UTC-4,  wrote:

Hi, my name is Ebenezer.

I'm having challenges downloading data from my app engine. When i select a form to download data from, i get this error message "problem persist data or accessing data" and then the page refreshes itself. This happens several times until am able to download the data. Now am completely unable to even download the data.

I will be grateful for your help to fix this issue.

Thanks.

--
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/5ab87d12-e1e5-44ea-9814-1e1d5cd4d361%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] UNABLE TO DOWNLOAD DATA

Hi, my name is Ebenezer.

I'm having challenges downloading data from my app engine. When i select a form to download data from, i get this error message "problem persist data or accessing data" and then the page refreshes itself. This happens several times until am able to download the data. Now am completely unable to even download the data.

I will be grateful for your help to fix this issue.

Thanks.

--
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/f888cdb1-6857-4438-929f-05747140ef20%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] BUG IN UI: Second Generation shows as First Generation

Thanks for the report, this has already been fixed and should be live soon.

On Thu, Aug 11, 2016 at 11:24 AM Marcelo Pham <marchie@gmail.com> wrote:

Hello,

Found a web UI bug (see attached screenshot): on the left menu it says "(First Gen)", when in reality it is a Second Generation (see right side)

--
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/9d397595-352c-46fb-9a4c-c3b14e0b2994%40googlegroups.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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p3S-C3hA-vkvVhgxWAcURSdDJ1CT77oh1gsG2hmt08D_Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] BUG IN UI: Second Generation shows as First Generation

Hello,

Found a web UI bug (see attached screenshot): on the left menu it says "(First Gen)", when in reality it is a Second Generation (see right side)

--
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/9d397595-352c-46fb-9a4c-c3b14e0b2994%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Can not import from storage

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

On Wed, Aug 10, 2016 at 12:17 PM, 'David Newgas' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

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

On Wed, Aug 10, 2016 at 3:17 AM, Thomas Locke <thomas@relatelabs.com> wrote:

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

On Tuesday, August 9, 2016 at 5:39:12 PM UTC+1, 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+unsubscribe@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+unsubscribe@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-discuss+unsubscribe@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.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Can not import from storage

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

On Wed, Aug 10, 2016 at 3:17 AM, Thomas Locke <thomas@relatelabs.com> wrote:

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

On Tuesday, August 9, 2016 at 5:39:12 PM UTC+1, 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+unsubscribe@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 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/CAJZK_bYF_%2BpH0TamsiaM_Fz%2BLvVvJQpDs5Eqt0%3DMbqqL%2Bpu9Vw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Google Cloud Second Generation Utf8Mb4 Problem

On Wed, Aug 10, 2016 at 7:58 AM, Tolga Tanrıverdi <tolgatanriverdi@gmail.com> wrote:

We are using Google Cloud Sql Second Generation with our AppEngine application. However today we've discovered some problem, we cannot insert emoji characters to our database because we cannot change some server flags to utf8mb4 character encoding.

We've changed character_set_server flag to utf8mb4 but it wasnt enough

We have to change: character_set_system character_set_client collaction_connection

The mysql docs (for 5.6 and 5.7) say "character_set_system  The character set used by the server for storing identifiers. The value is always utf8."  You don't need to set this one to store utf8mb4 values (if you want to use emoji for your column names, you're out of luck ;)).

The other two (character_set_client and collation_connection) can be set at the session level.  I'll look into making these settable.

 

flags to utf8mb4 also, but second generation db is not allowing root user to change those flags. What can we do to solve this problem

Does anyone have any idea about that?

Thanks

--
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/96ffa068-077c-4677-9aea-7a26d2f3c471%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Lee Schumacher | Software Engineer | lschumacher@google.com | (650) 336-5330

--
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/CAOMt%3DViGNe36BTqz5W60bmOykLTh%2BM9KhYkFYYUdkCPB_V%2BqLw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Google Cloud Second Generation Utf8Mb4 Problem

We are using Google Cloud Sql Second Generation with our AppEngine application. However today we've discovered some problem, we cannot insert emoji characters to our database because we cannot change some server flags to utf8mb4 character encoding.

We've changed character_set_server flag to utf8mb4 but it wasnt enough

We have to change: character_set_system character_set_client collaction_connection

flags to utf8mb4 also, but second generation db is not allowing root user to change those flags. What can we do to solve this problem

Does anyone have any idea about that?

Thanks

--
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/96ffa068-077c-4677-9aea-7a26d2f3c471%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Can not import from storage

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

On Tuesday, August 9, 2016 at 5:39:12 PM UTC+1, 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+unsubscribe@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.

[google-cloud-sql-discuss] Re: Unable to import data dump to cloud SQL, ERROR(2013) (HY000) at line 3916: lost connection to Mysql server during query

Hey Karan,

A specific issue like this should be posted to Stack Overflow. When you do post there, be sure to include the following information:

* What command or code you're using to attempt to connect
* What auth configuration you've done on the instance

Feel free to post the question here once you've posted to Stack Overflow.

Cheers,

Nick
Cloud Platform Community Support

On Friday, August 5, 2016 at 4:03:14 PM UTC-4, karan.malhotra@myrefers.com wrote:

I am trying to import my sql dump from EC2 instance to cloud sql but it is giving me the following error every time:-

ERROR(2013) (HY000) at line 3916: lost connection to Mysql server during query

Cloud sql Ram:- 8 GB

Dump size:- 3 GB

Thanks in Advance..!!

--
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/424681ee-071f-4112-aaa1-83cc464b7bf9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Can not import from storage

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a3758d04-7f30-47c1-9535-0eb1b5da15b6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Anyway to disable only_full_group_by on 5.7

I'm having the same issue too. I assume the best work around is to rebuild the database in mysql v 5.6? The others suggested in this group didn't work for me.

On Friday, June 3, 2016 at 2:29:32 PM UTC+1, Matt Bourne wrote:

It seems like there is no super access and although you can add flags there appears no way to remove default flags like only_full_group_by

--
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/5032e6b1-2fc5-4e47-bc0e-48777d3d97cc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Unable to import data dump to cloud SQL, ERROR(2013) (HY000) at line 3916: lost connection to Mysql server during query

I am trying to import my sql dump from EC2 instance to cloud sql but it is giving me the following error every time:-

ERROR(2013) (HY000) at line 3916: lost connection to Mysql server during query

Cloud sql Ram:- 8 GB

Dump size:- 3 GB

Thanks in Advance..!!

--
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/2a851173-d5d9-4a11-891b-172d0600122f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: Cloud SQL Gen 1

Yep it was related. I'll try and make sure our incident report covers the Cloud SQL impact.

On Fri, Aug 5, 2016 at 2:01 AM, Aditya Agarwalla <adi.agarwalla@gmail.com> wrote:

Ok. Must be related. Thanks

On Friday, August 5, 2016 at 2:27:12 PM UTC+5:30, PaulM wrote:

This incident just appeared on the Google Cloud Status page.

It is related to Compute engine but it s networking issue so might be related.

https://status.cloud.google.com/incident/compute/16015

On Friday, 5 August 2016 09:51:53 UTC+1, PaulM wrote:

I am also unable to connect to my Cloud SQL instance (First Gen, MySQL 5.5, us-central) from a remote network. Started happening this morning (0830 UTC, 05 August).

I have not made any configuration changes and am connecting from an authorized external network.

Looks like a Google issue.

On Friday, 5 August 2016 09:39:56 UTC+1, Aditya Agarwalla wrote:

Is it just for me or my instance is not accessible by any of the authorized networks (external). GAE connections are working as usual though.

Thanks

--
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/360814e8-cb9b-41d0-a947-eee1fe70be09%40googlegroups.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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bYLJH_NdkdpA3Mw9d1B3MHaeSQGSh0PkG9s7eOHtirFeA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL Gen 1

Ok. Must be related. Thanks

On Friday, August 5, 2016 at 2:27:12 PM UTC+5:30, PaulM wrote:

This incident just appeared on the Google Cloud Status page.

It is related to Compute engine but it s networking issue so might be related.

https://status.cloud.google.com/incident/compute/16015

On Friday, 5 August 2016 09:51:53 UTC+1, PaulM wrote:

I am also unable to connect to my Cloud SQL instance (First Gen, MySQL 5.5, us-central) from a remote network. Started happening this morning (0830 UTC, 05 August).

I have not made any configuration changes and am connecting from an authorized external network.

Looks like a Google issue.

On Friday, 5 August 2016 09:39:56 UTC+1, Aditya Agarwalla wrote:

Is it just for me or my instance is not accessible by any of the authorized networks (external). GAE connections are working as usual though.

Thanks

--
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/360814e8-cb9b-41d0-a947-eee1fe70be09%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL Gen 1

This incident just appeared on the Google Cloud Status page.

It is related to Compute engine but it s networking issue so might be related.

https://status.cloud.google.com/incident/compute/16015

On Friday, 5 August 2016 09:51:53 UTC+1, PaulM wrote:

I am also unable to connect to my Cloud SQL instance (First Gen, MySQL 5.5, us-central) from a remote network. Started happening this morning (0830 UTC, 05 August).

I have not made any configuration changes and am connecting from an authorized external network.

Looks like a Google issue.

On Friday, 5 August 2016 09:39:56 UTC+1, Aditya Agarwalla wrote:

Is it just for me or my instance is not accessible by any of the authorized networks (external). GAE connections are working as usual though.

Thanks

--
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/e1b42c12-0d57-42dd-946e-34b232814dc4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: getting error 10060 when connecting to my Cloud SQL Gen 1 instance

I am experiencing the same thing. I think it might be related to this current networking issue that just popped up on the google cloud status page:

https://status.cloud.google.com/incident/compute/16015

On Friday, 5 August 2016 09:54:06 UTC+1, Julien Maille wrote:

It started around 9:30am Paris time (1hour and a half ago)

I have restarted the instance from the console, but the issue persists.

Looking at the logs, nothing was changed recently.

Is there anything I can do?

--
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/6a2df65c-7289-47c5-9c5d-168ab8a54c11%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] getting error 10060 when connecting to my Cloud SQL Gen 1 instance

It started around 9:30am Paris time (1hour and a half ago)

I have restarted the instance from the console, but the issue persists.

Looking at the logs, nothing was changed recently.

Is there anything I can do?

--
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/6675a757-8bc5-4af0-b59b-d2e0f21e0fee%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL Gen 1

I am also unable to connect to my Cloud SQL instance (First Gen, MySQL 5.5, us-central) from a remote network. Started happening this morning (0830 UTC, 05 August).

I have not made any configuration changes and am connecting from an authorized external network.

Looks like a Google issue.

On Friday, 5 August 2016 09:39:56 UTC+1, Aditya Agarwalla wrote:

Is it just for me or my instance is not accessible by any of the authorized networks (external). GAE connections are working as usual though.

Thanks

--
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/a1306d1f-0fb1-4eaa-ace5-1bf164a0d766%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cloud SQL Gen 1

Is it just for me or my instance is not accessible by any of the authorized networks (external). GAE connections are working as usual though.

Thanks

--
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/bf472d20-bd8f-475a-8d25-567604c0b10d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Anyway to disable only_full_group_by on 5.7

By default Cloud SQL leaves the sql mode at the default, which includes strict_trans_tables in 5.7 but does not in 5.5 or 5.6.  So if you are running 5.5 or 5.6 it is already off by default.

If you are running 5.7 you can turn it off globally by setting the sql_mode flag to anything else, or blank. Because of the issue outlined earlier in this thread, this will remove some of the other modes too. The only way to remove just that one flag is to set the sql_mode session variable each time you connect as outlined earlier.

David

On Wed, Aug 3, 2016 at 10:19 AM, Hajar Homayouni <homayouni.hajar@gmail.com> wrote:

Hi,

How can I disable Strict mode in Cloud sql?

On Friday, June 3, 2016 at 10:34:35 AM UTC-6, David Newgas wrote:

Hi,

ONLY_FULL_GROUP_BY isn't actually a database flag, it is one of the possible parameters of the sql_mode database flag. sql_mode is one of the supported flags in Cloud SQL, which means you can change it by editing the instance properties. In order to remove ONLY_FULL_GROUP_BY but leave the other default modes you would need to set sql_mode to STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE(etc). Unfortunately it seems that our validation only allows you to set one mode. This is a bug, which I am reporting now.

In the mean time the best workaround is to use SET SESSION sql_mode='...' at the start of each session to remove the mode.

David

On Fri, Jun 3, 2016 at 6:29 AM, Matt Bourne <matt...@gmail.com> wrote:

It seems like there is no super access and although you can add flags there appears no way to remove default flags like only_full_group_by

--
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/b977f133-5127-4a54-9fa6-cdc7be6ac465%40googlegroups.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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/40ef3feb-bd42-4030-bf3c-f3475b2f9d95%40googlegroups.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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bZt%3D%2BOR40JFtKuDKjg0DC%2B6LPciLGusWbMMG%2Bgy7z8jag%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.