[google-cloud-sql-discuss] Re: Google cloud sql service can not drop database

I'm experiencing this as well. What was the solution for this?

On Wednesday, July 24, 2019 at 12:49:00 PM UTC-7, Harmit Rishi (Cloud Platform Support) wrote:

Hello, 

Thank you for using Google Groups!

Seems like we will need to do some additional investigation for this issue. I would kindly request that you create a private issue with us on our Public Issue Tracker here. Creating the issue private will ensure that your database and project details will not be shared publicly. 

Looking forward to hearing from you.

--
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/0b1a3660-0c77-477f-bdfc-4d336495d594%40googlegroups.com.

[google-cloud-sql-discuss] Recover from a removed SQL instance

I just deleted a Cloud SQL instance. Before deletion, I made a backup using the console to a bucket. But upon

inspection. I noticed that the dump has no data.

Is there a way to recover the data from Google's backup?

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/adf6e17c-f2d6-4136-9753-7ce3f378cc27%40googlegroups.com.

[google-cloud-sql-discuss] not understand my log error for deploy on gcloud

hi, 

i am new with on gcp. i work on django project. I want deploy my project on app engine but, i have a mistake with command line gcloup app deploy. i saw logs but, i not understand. Please can you help me? thanks. PS: sorry for my english

this is my logs

 

--
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/fba3e667-6a23-4770-aa89-661216aa4bab%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL MySQL 2nd Gen Regional Disks?

Hello,

Communications will be sent out to customers soon regarding the roll out. Thanks for your patience.

--
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/166327c6-40e5-45d6-bd2d-ed3f24cd3771%40googlegroups.com.

[google-cloud-sql-discuss] Cloud SQL MySQL 2nd Gen Regional Disks?

I received several emails over the last month or so informing me this feature was being rolled out September 25th. This day has come and gone and nothing has changed. I'm really interested in used this feature to eliminate brutal replication lag. 

--
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/8182b9b2-731c-4ae0-9ccb-30b5f59a2720%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: log_error_verbosity set to terse but error log has entire query

H Nipun,

I suspect that your flag log_statement=all .

• https://www.postgresql.org/docs/9.6/runtime-config-logging.html#GUC-LOG-STATEMENT
  
• https://cloud.google.com/sql/docs/postgres/flags

--
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/cccf7fcf-df6a-46cf-983a-ba9db7844a69%40googlegroups.com.

[google-cloud-sql-discuss] How do I connect to a MySQL instance from my local computer?

Hello,

I have followed this tutorial to connect a MySQL instance via ip address, but when I run the line "mysql --host=123.45.67.89 --user=root --password" in the command prompt, I get the message, " 'mysql' is not recognized as an internal or external command, operable program or batch file."

My end goal is to connect Excel to a Cloud SQL instance via VBA.

What am I missing? / How should I be doing this?

I am running 

• Windows 7 Professional
• Visual Studio 2017
• I downloaded the MySQL Community Server 8.0.17.0 and installed the full version

Any help is appreciated.

Thanks,

Micah

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

--
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/256a440b-60ab-4af8-80b2-311002677b6c%40googlegroups.com.

[google-cloud-sql-discuss] How do I connect to a MySQL instance from my local computer?

Hello,

I have followed this tutorial to connect a MySQL instance via ip address, but when I run the line "mysql --host=123.45.67.89 --user=root --password" in the command prompt, I get the message, " 'mysql' is not recognized as an internal or external command, operable program or batch file."

My end goal is to connect Excel to a Cloud SQL instance via VBA.

What am I missing? / How should I be doing this?

I am running 

• Windows 7 Professional
• Visual Studio 2017
• I downloaded the MySQL Community Server 8.0.17.0 and installed the full version

Any help is appreciated.

Thanks,

Micah

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

--
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/d3215695-4161-4f76-b229-b4e9b6f311c7%40googlegroups.com.

[google-cloud-sql-discuss] How do I connect to a MySQL instance from my local computer?

Hello,

I have followed this tutorial to connect a MySQL instance via ip address, but when I run the line "mysql --host=123.45.67.89 --user=root --password" in the command prompt, I get the message, " 'mysql' is not recognized as an internal or external command, operable program or batch file."

My end goal is to connect Excel to a Cloud SQL instance via VBA.

What am I missing? / How should I be doing this?

I am running 

• Windows 7 Professional
• Visual Studio 2017
• I downloaded the MySQL Community Server 8.0.17.0 and installed the full version

Any help is appreciated.

Thanks,

Micah

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

--
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/be8b7cdf-3a8e-416b-9e4a-ad0e732bd880%40googlegroups.com.

[google-cloud-sql-discuss] How do I connect to a MySQL instance from my local computer?

Hello,

I have followed this tutorial to connect a MySQL instance via ip address, but when I run the line "mysql --host=123.45.67.89 --user=root --password" in the command prompt, I get the message, " 'mysql' is not recognized as an internal or external command, operable program or batch file."

My end goal is to connect Excel to a Cloud SQL instance via VBA.

What am I missing? / How should I be doing this?

I am running 

• Windows 7 Professional
• Visual Studio 2017
• I downloaded the MySQL Community Server 8.0.17.0 and installed the full version

Any help is appreciated.

Thanks,

Micah

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

--
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/4c8abae4-a06e-47fb-be38-ef546b76de7e%40googlegroups.com.

[google-cloud-sql-discuss] How do I connect to a MySQL instance from my local computer?

Hello,

I have followed this tutorial to connect a MySQL instance via ip address, but when I run the line "mysql --host=123.45.67.89 --user=root --password" in the command prompt, I get the message, " 'mysql' is not recognized as an internal or external command, operable program or batch file."

My end goal is to connect Excel to a Cloud SQL instance via VBA.

What am I missing? / How should I be doing this?

I am running 

• Windows 7 Professional
• Visual Studio 2017
• I downloaded the MySQL Community Server 8.0.17.0 and installed the full version

Any help is appreciated.

Thanks,

Micah

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

mysql --host=[INSTANCE_IP] --user=root --password

--
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/0b1ee1f5-6fd7-43ab-8b51-cd28032d48b1%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: log_error_verbosity set to terse but error log has entire query

Hi George. thanks for the reply. setting value to terse in flag has no change on the logs. 

I will raise a question on stack overflow

thanks.

Regards, Nipun Kanade
Application Developer
Email	nipunk@thoughtworks.com
Telephone	+919977893993

On Wed, Sep 25, 2019 at 10:04 PM 'George (Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

Hello Nipun, 

log_error_verbosity flag controls the amount of detail written in the server log for each message that is logged. Valid values are TERSE, DEFAULT, and VERBOSE, each adding more fields to displayed messages. TERSE excludes the logging of DETAIL, HINT, QUERY, and CONTEXT error information, as mentioned on the "Error Reporting and Logging" page. Did you notice any of these error information headers populated with actual values, in your logs? 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching the app engine. For coding and database set up, as well as PostgreSQL flags usage, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help. 

--
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/8f8f18d2-57cf-4013-92a2-046ca1ca43d9%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/CAFrb3ZTjEfpZpm8YHW9E3V1Xm3Zqcjc3XtoMyAPbfSQLeiKg2w%40mail.gmail.com.

[google-cloud-sql-discuss] Re: log_error_verbosity set to terse but error log has entire query

Hello Nipun, 

log_error_verbosity flag controls the amount of detail written in the server log for each message that is logged. Valid values are TERSE, DEFAULT, and VERBOSE, each adding more fields to displayed messages. TERSE excludes the logging of DETAIL, HINT, QUERY, and CONTEXT error information, as mentioned on the "Error Reporting and Logging" page. Did you notice any of these error information headers populated with actual values, in your logs? 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching the app engine. For coding and database set up, as well as PostgreSQL flags usage, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help. 

--
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/8f8f18d2-57cf-4013-92a2-046ca1ca43d9%40googlegroups.com.

[google-cloud-sql-discuss] log_error_verbosity set to terse but error log has entire query

Hi, 

I have a postgres function which is returning an error to my application if the data is old and i have a newer version already in db (idempotency check). 

for one execution of this function it is generating a log message that is spread to over 50 individual logs. 

This is polluting my db-logs and there is no way to filter it out in stack-trace

I tried enabling  log_error_verbosity flag and set it to 'terse' but this is not helping as well. still I am seeing these logs.

Is it a bug or I am doing something wrong?

three issues . 

1. log message spread to ~ 50 log entries
2. log_error_verbosity not working as expected
   
3. log message is also coming as info and not error 
4. 

--
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/8df7b24e-62e7-41a9-9f7f-aa3b226f8ecd%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL export operation was hung up

Ok, thank you.

вторник, 24 сентября 2019 г., 2:40:13 UTC+5 пользователь Elliott (Google Cloud Platform Support) написал:

Hello,

Please note that Google Groups are reserved for general Google Cloud Platform-end product discussions and not for reporting issues, which is why I suggest moving the troubleshooting to Issue Tracker, where issues can be turned private in case we need to gather any project specific details.

--
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/a732b36d-7673-4200-99b1-168920273e61%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL export operation was hung up

Hello,

Please note that Google Groups are reserved for general Google Cloud Platform-end product discussions and not for reporting issues, which is why I suggest moving the troubleshooting to Issue Tracker, where issues can be turned private in case we need to gather any project specific details.

--
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/a6a71907-b2b9-498a-b8bb-d570cbe5f76f%40googlegroups.com.

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

"Client", in the context of online databases, is a database client. You can use database clients (mysql, psql) to connect to Cloud SQL. For details and examples, you may have a look at the "Connecting to Cloud SQL" tutorial. 

--
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/5e189f79-74e2-44d4-b3d1-0ad962eef581%40googlegroups.com.

[google-cloud-sql-discuss] Cloud SQL export operation was hung up

We starts export procedure of PostgreSQL database 21 sept. at 05:00 AM and today (23 sept.) it's still running and we can't cancel it (operation ID: c6d9dc00-0465-4fc4-9c56-01197738a8b4).

What we can do for now?

--
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/4495e8f9-f58c-4d8a-b381-f86ee8f77522%40googlegroups.com.

[google-cloud-sql-discuss] Re: How to access MySQL databases with Multi Users

Hello Iwan, 

You may create multiple users in Cloud SQL, but the default user is employed to establish connection, if you connect using your MySQL client. You may find related detail on the "Connecting MySQL client using public IP" page. Why do you try to log in with a different user? A detailed description, preferably in step-by-step format, would be appreciated. 

--
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/b2f6415d-0f47-4281-a47f-80ec86dde162%40googlegroups.com.

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

Am Dienstag, 17. September 2019 21:27:54 UTC+2 schrieb George (Cloud Platform Support):

Hallo Joe, 

Sie verstehen das richtig. 

You may read more about Cloud SQL in the related official documentation. 

und was ist ein mySQL-Client?  

--
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/671cb8f6-fd89-42bf-9c9a-7846f83ed136%40googlegroups.com.

[google-cloud-sql-discuss] Re: Upgrading Postgres from 9.6 to 11

Hello Alex, 

You may also consider creating a replica and performing the export operation from that replica. There are various strategies to reduce impact on users when migrating your database; you may find relevant information on the Web, for instance the "Time reduction battle while migrating databases from hosted PostgreSQL to Google Cloud SQL" page. 

It may be worthwhile noting here that Google Groups are reserved for general product discussions. We cannot provide you any advice on your system's architecture, and related best solutions. For programming, database management, system architecture, you may publish detailed information in forums such as stackoverflow, where experienced programmers are happy to help.

--
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/aa2d66f6-6945-423a-a105-ce0286139e6e%40googlegroups.com.

[google-cloud-sql-discuss] How to access MySQL databases with Multi Users

I access the MySQL database in the cloud instance from the desktop application.

In the desktop application I have created several users, and entered the user table in the MySQL database. Call it the 'root' user and the 'medco' user

In the cloud instance on the users tab, I also created both users with the same password as the user in the users table.

The problem is, I can only log in using the root user from my desktop application, while the medco user is always rejected.

Please help for the solution

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/87f447ef-0dfd-4bf8-b6ea-be4b15cb6224%40googlegroups.com.

[google-cloud-sql-discuss] Upgrading Postgres from 9.6 to 11

I'd like to be able to upgrade my existing cloudsql postgres 9.6 instance to 11 to use some new pg 11 features.

I've been trying to figure out a good migration plan but it seems like the only option available is sql dump and restore.  The database is 100Gig+ so this will take quite some time, and I'd like to avoid downtime as much as possible.  Are there any options available? I was considering enabling statement logging: log_statement=mod, creating a dump, importing it into a pg-11 instance taking down the db + then scraping the logs to reply the latest updates into the pg-11 instance by downloading the logs and writing a script to re-run the inserts.  Seems doable but I am wondering if anyone faced this before and has had any other solutions?

--
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/5bcf5c77-1d7f-467b-81eb-6643d59e53db%40googlegroups.com.

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

Hallo Joe, 

Sie verstehen das richtig. 

You may read more about Cloud SQL in the related official documentation. 

--
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/7db611d6-8f49-4278-b0ee-5c4e31ab8b00%40googlegroups.com.

[google-cloud-sql-discuss] Cloud SQL

Guten Tag, 

ich bin neu in den Daten- und Cloud Themen. 

Verstehe ich richtig, dass Cloud SQL die eingentliche Datenbank ist und was ist ein mySQL-Client? 

MfG

--
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/458048fe-03a3-41ac-8852-6cc57faa5215%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: MySQL Second Generation read replica downtime?

Hi Nick,

The suggestion posted here is related to the issue initially posted about a read replica instance going into maintenance mode. 

I have also posted some suggestions pertaining the latency issue you are experiencing on you Cloud SQL instance here. Please refer to the other thread and let us know if you have other questions.

--
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/6cdfcdd9-9455-4706-a266-94c4c4f5b9c0%40googlegroups.com.

[google-cloud-sql-discuss] Re: How to connect to Postgres Cloud SQL via SSH tunnel & SSL using GUI

Finally I found a solution from another guy after I post this question in StackOverflow for a month.

https://stackoverflow.com/a/57626621/5808321

The root cause come from program not Cloud SQL. So I need to share answer for someone still facing the problem like me.

--
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/18e288b6-cdb1-4d89-b021-502917a03824%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: MySQL Second Generation read replica downtime?

Thanks for the response.  There are no read replicas here, it's just a single master instance.  I'll open a ticket.

On Thu, 5 Sep 2019 at 18:34, 'Aref Amiri (Cloud Platform Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

This could happen if you delete a read replica and create a new one with the same name. If that is not the case, I would suggest to check QPS ratio on your master instance, as it could overload the read replica, which in this case a good practice would be resharding your master instance to 2 or more instances to split the query load. You can refer to more best practices here.

To further assist you with the issue, I would suggest to create a private issue on Public Issue Tracker page and we will be able to further investigate it with our internal tools and provide you with more meaningful information.

--
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/550d651e-8470-4411-b558-a3ed2e307cbf%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/CACfBfNs8yw7JvDWXG8r6pFA6T6GgQfKLGr-wVq0imkPSCNUoqw%40mail.gmail.com.

[google-cloud-sql-discuss] Re: MySQL Second Generation read replica downtime?

This could happen if you delete a read replica and create a new one with the same name. If that is not the case, I would suggest to check QPS ratio on your master instance, as it could overload the read replica, which in this case a good practice would be resharding your master instance to 2 or more instances to split the query load. You can refer to more best practices here.

To further assist you with the issue, I would suggest to create a private issue on Public Issue Tracker page and we will be able to further investigate it with our internal tools and provide you with more meaningful information.

--
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/550d651e-8470-4411-b558-a3ed2e307cbf%40googlegroups.com.

[google-cloud-sql-discuss] Re: suddenly can't query - think my indexes aren't being used

Hello Nick,

 

The incident related to Cloud SQL that was reported yesterday(September 4th,2019) is set to have been resolved for all affected instances.

 

I would suggest in this case, to check the number of connections to your instance as this could possibly have an effect on the latency as well as resource usage such as CPU. 

 

If that is not the case, I would suggest to open a new private issue on Public Issue Tracker page, and provide the project ID as well as the instance name, as this issue may require to be further investigated. 

--
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/5191ac0a-c47f-492e-a8c1-380ca79f090a%40googlegroups.com.

[google-cloud-sql-discuss] suddenly can't query - think my indexes aren't being used

I understand there was a cloudsql outage yesterday (4th September 2019).  Today my cloud sql Postgres db is unresponsive.  Queries that yesterday responded in under a second are now taking 25mins+.  I think that writes are working ok (although it's difficult to check because querying for new records is so slow).  Is there still a problem?  

--
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/3dab4c61-77cb-46ec-93b3-0dd7bed37ab9%40googlegroups.com.

[google-cloud-sql-discuss] MySQL Second Generation read replica downtime?

 I used MySQL Second Generation read replica, as slave DB, but it suddenly going maintained .

I have only one read replica, it impacts my services, how to I avoid this situation?

Any solutions or practice will be helpful, 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/f02b6033-29fd-4070-8872-06ef4fed27f2%40googlegroups.com.

[google-cloud-sql-discuss] Re: Can't seem to connect to Cloud SQL mysql every few hours

As per the log provided, somewhere in your configuration, the "quite" flag is being called, preventing you from getting more detailed and extended logging information. It would be helpful to know the sequence of events to determine how the proxy is being stopped.

Also note that the Google Groups is a discussion group oriented more towards general opinions, trends, and issues of general nature touching Google Cloud Platform. For technical questions and issues, such as the connection issue reported, you may be better served in dedicated forums such as Stack Overflow, where experienced developers are within reach and ready to help. I recommend you use the tag "cloud-sql-proxy" when posting on Stack Overflow.

On Monday, September 2, 2019 at 7:51:17 AM UTC-4, Paul Choi wrote:

Start Cloud Database Proxy...
2019/09/01 05:40:13 Cloud SQL Proxy logging has been disabled by the -quiet flag. All messages (including errors) will be suppressed.
Sun Sep  1 05:40:13 UTC 2019 - waiting for 127.0.0.1:5432... 1/10
Sun Sep  1 05:40:18 UTC 2019 - waiting for 127.0.0.1:5432... 2/10
Sun Sep  1 05:40:23 UTC 2019 - waiting for 127.0.0.1:5432... 3/10
Sun Sep  1 05:40:28 UTC 2019 - waiting for 127.0.0.1:5432... 4/10
Sun Sep  1 05:40:33 UTC 2019 - waiting for 127.0.0.1:5432... 5/10
Sun Sep  1 05:40:38 UTC 2019 - waiting for 127.0.0.1:5432... 6/10
Sun Sep  1 05:40:43 UTC 2019 - waiting for 127.0.0.1:5432... 7/10
Sun Sep  1 05:40:48 UTC 2019 - waiting for 127.0.0.1:5432... 8/10
Sun Sep  1 05:40:53 UTC 2019 - waiting for 127.0.0.1:5432... 9/10
Sun Sep  1 05:40:58 UTC 2019 - 127.0.0.1:5432 still not reachable, giving up

We are running Apache Airflow with Cloud SQL and Kubernetes. cloud_sql_proxy is started when a new pod starts, and we've been seeing this issue every few hours - although the example above may be the worst case.

The MySQL DB is 2nd generation, mysql 5.7.

Using cloud_sql_proxy 1.15 - we just fetch whatever is the latest during the Docker container build.

airflow@airflow-web-5d8756bfbd-bl2d5:~$ ./cloud_sql_proxy -version

Cloud SQL Proxy: version 1.15; sha d93c53a4824cdaf457656ab49a50001636cf3e36 built Wed Aug 28 23:14:31 UTC 2019

We're definitely not hitting the API request limit for CloudSQL Admin API or anything like that.

And I can't reproduce this issue when I run cloud_sql_proxy locally. There's no more than 30-50 connections to the Mysql db at a given time, and the connections are mostly dormant.

Any idea what it could be? I can't find any useful information to diagnose this issue. As far as I can tell, this is a cloud_sql_proxy behavior and not mysql.

--
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/a8e7d5ff-d35c-4af8-89a4-8a2fe4768783%40googlegroups.com.

[google-cloud-sql-discuss] Can't seem to connect to Cloud SQL mysql every few hours

Start Cloud Database Proxy...
2019/09/01 05:40:13 Cloud SQL Proxy logging has been disabled by the -quiet flag. All messages (including errors) will be suppressed.
Sun Sep  1 05:40:13 UTC 2019 - waiting for 127.0.0.1:5432... 1/10
Sun Sep  1 05:40:18 UTC 2019 - waiting for 127.0.0.1:5432... 2/10
Sun Sep  1 05:40:23 UTC 2019 - waiting for 127.0.0.1:5432... 3/10
Sun Sep  1 05:40:28 UTC 2019 - waiting for 127.0.0.1:5432... 4/10
Sun Sep  1 05:40:33 UTC 2019 - waiting for 127.0.0.1:5432... 5/10
Sun Sep  1 05:40:38 UTC 2019 - waiting for 127.0.0.1:5432... 6/10
Sun Sep  1 05:40:43 UTC 2019 - waiting for 127.0.0.1:5432... 7/10
Sun Sep  1 05:40:48 UTC 2019 - waiting for 127.0.0.1:5432... 8/10
Sun Sep  1 05:40:53 UTC 2019 - waiting for 127.0.0.1:5432... 9/10
Sun Sep  1 05:40:58 UTC 2019 - 127.0.0.1:5432 still not reachable, giving up

We are running Apache Airflow with Cloud SQL and Kubernetes. cloud_sql_proxy is started when a new pod starts, and we've been seeing this issue every few hours - although the example above may be the worst case.

The MySQL DB is 2nd generation, mysql 5.7.

Using cloud_sql_proxy 1.15 - we just fetch whatever is the latest during the Docker container build.

airflow@airflow-web-5d8756bfbd-bl2d5:~$ ./cloud_sql_proxy -version

Cloud SQL Proxy: version 1.15; sha d93c53a4824cdaf457656ab49a50001636cf3e36 built Wed Aug 28 23:14:31 UTC 2019

We're definitely not hitting the API request limit for CloudSQL Admin API or anything like that.

And I can't reproduce this issue when I run cloud_sql_proxy locally. There's no more than 30-50 connections to the Mysql db at a given time, and the connections are mostly dormant.

Any idea what it could be? I can't find any useful information to diagnose this issue. As far as I can tell, this is a cloud_sql_proxy behavior and not mysql.

--
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/7dfd4059-7c47-40b7-bb24-52f4608376fa%40googlegroups.com.