[google-cloud-sql-discuss] Re: MySQL update outside the maintenance window

Thanks for sharing such a piece of great knowledge. Its really helpful for big man tree stand.

On Friday, 12 November 2021 at 02:33:08 UTC+5 Aref Amiri (Cloud Platform Support) wrote:

The machine hosting your instance is managed on Google backed and you won't have access to it, however, if you believe that is the issue, I'd suggest creating a Private Issue Tracker and provide the instance name and the project, and the engineering team can investigate it further.

On Thursday, November 11, 2021 at 9:59:58 AM UTC-5 sh...@getexpain.com wrote:

Thanks for the reply. Regarding the last bullet (the hardware failure option) - can I know in some way that this is what happened?

On Wednesday, November 10, 2021 at 5:28:45 PM UTC+2 pa...@google.com wrote:

When a preferred maintenance window is configured for instances, it only guarantees that the maintenance event will not start outside the window. It does not guarantee to finish within the specified window as stated here. (which I believe is probably what happened in your case).

Also, in addition to regular maintenance (which is done during the maintenance window) there are some other occasions when your instance may go through a downtime like this. Here are some examples:

• You or another user on GCP changes instance size, flags, replication type, etc. 
• Metadata update of an instance, which can be triggered by admin or users in the instance ACL (Access Control List).
• The machine hosting your instance has a hardware failure. Redundant storage and ACID storage engine means your data is safe in such a case, but MySQL must then be started on a new instance, resulting in a downtime period.

On Wednesday, November 10, 2021 at 10:53:00 AM UTC+1 sh...@getexpain.com wrote:

Hi all!

Lately our MySQL server (hosted on Cloud SQL) had an update out of the maintenance time window. I'd like to understand a few things about that:

1. Should we anticipate more updates to our servers outside of the maintenance time window that we configured?
2. Was there a way that we could have known about this update before it happened? 
3. Is there a way to make sure all updates will be executed within the maintenance window? 

Thank you!
Shay.

--
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/cb378a4b-7d7e-4491-b108-e9b921ff4753n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL export to CSV then load to BigQuery

We already support a null marker that should do the job for the user. See https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv#csv-options

On Thursday, December 16, 2021 at 10:49:44 AM UTC-5 tay...@aeris.net wrote:

Hi everyone

I am trying to export my data from Cloud SQL to CSV file storing in google cloud storage then load the file to BigQuery as external table.

The exporting is working well, the null value can be exported as "N or \N.

But seems like we don't have any null marker setting on BigQuery external table to tell BigQuery load the "N or \N to null value to my external table?

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/898e3f27-5e01-4cb6-a076-a15a27e492fan%40googlegroups.com.

[google-cloud-sql-discuss] Re: SQL Export taking forever

Thanks. FYI - resolved the issue - the "restart" button worked even though everything else was disabled.

On Wednesday, December 15, 2021 at 2:01:31 PM UTC-5 Elliott (Google Cloud Platform Support) wrote:

Hello,

As Google Groups is meant for general discussions and opinions, I would suggest for you to reach out to Support through the regular channel here as this relates to your own project. As I look now, I see no common issues that would affect Cloud SQL.

[1] https://cloud.google.com/support/docs

On Wednesday, December 15, 2021 at 1:25:43 PM UTC-5 John.C...@thp.org wrote:

I began an export on a Cloud SQL database that usually takes a few minutes, from the console. It has been running for 16 hours, and I cannot see anyway to stop it. Advise??? 

--
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/f75c5ea5-2830-42c7-bd60-52504ce35714n%40googlegroups.com.

[google-cloud-sql-discuss] Cloud SQL export to CSV then load to BigQuery

Hi everyone

I am trying to export my data from Cloud SQL to CSV file storing in google cloud storage then load the file to BigQuery as external table.

The exporting is working well, the null value can be exported as "N or \N.

But seems like we don't have any null marker setting on BigQuery external table to tell BigQuery load the "N or \N to null value to my external table?

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/a230da7e-c94e-4206-9e5b-0e40ff4701b7n%40googlegroups.com.

[google-cloud-sql-discuss] Re: SQL Export taking forever

Hello,

As Google Groups is meant for general discussions and opinions, I would suggest for you to reach out to Support through the regular channel here as this relates to your own project. As I look now, I see no common issues that would affect Cloud SQL.

[1] https://cloud.google.com/support/docs

On Wednesday, December 15, 2021 at 1:25:43 PM UTC-5 John.C...@thp.org wrote:

I began an export on a Cloud SQL database that usually takes a few minutes, from the console. It has been running for 16 hours, and I cannot see anyway to stop it. Advise??? 

--
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/c09ec6d9-a1e8-4fb9-ba26-576be84a27aan%40googlegroups.com.

[google-cloud-sql-discuss] SQL Export taking forever

I began an export on a Cloud SQL database that usually takes a few minutes, from the console. It has been running for 16 hours, and I cannot see anyway to stop it. Advise??? 

--
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/04e32045-12c7-4a12-94c8-d8c9cd7eb8d5n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Big Query Linear Regression param issue

Hello

I believe you are inquiring about further explanation of the optimize strategy [1] and specifically the auto strategy and batch gradient descent arguments. I can see that you have posted the same query on stackoverflow [2], however your current post was submitted to the Google Cloud SQL discussion group. In order to receive the best response from the community, can you kindly re-post your inquiry to the appropriate group. I suggest posting to the Google Cloud Developers [3]  or additionally to the discuss BigQuery community [4].

[1] https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-create-glm

[2] https://stackoverflow.com/questions/70263074/big-query-linear-regression-param

[3] https://groups.google.com/g/google-cloud-dev 

[4] https://cloud.google.com/bigquery/docs/getting-support 

On Tuesday, December 7, 2021 at 1:40:43 PM UTC-5 najafmu...@gmail.com wrote:

What is the actual meaning of these two points in Big Query. I get that in 2nd, maybe, by total cardinality it actually means no. of features. What about point 1?

1. If total cardinalities of training features are more than 10,000, batch_gradient_descentstrategy is used.
2. If there is over-fitting issue, that is, the number of training examples is less than 10x, where x is total cardinality, batch_gradient_descent strategy is used.

--
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/758ef56c-22cd-44d2-9cab-1ea0f92c5788n%40googlegroups.com.

[google-cloud-sql-discuss] Big Query Linear Regression param issue

What is the actual meaning of these two points in Big Query. I get that in 2nd, maybe, by total cardinality it actually means no. of features. What about point 1?

1. If total cardinalities of training features are more than 10,000, batch_gradient_descentstrategy is used.
2. If there is over-fitting issue, that is, the number of training examples is less than 10x, where x is total cardinality, batch_gradient_descent strategy is used.

--
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/50a0ee65-8996-4a20-88d8-0c30735d8505n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Failed to serialize json to table row

I was able to find this question in Stack Overflow with a similar error message [1]. For them the issue was caused because their output did not match the template output.

[1]: https://stackoverflow.com/questions/68484851/

On Monday, November 29, 2021 at 10:16:21 AM UTC+1 selm...@gmail.com wrote:

Hi,

Has anyone seen 'Failed to serialize json to table row' in BigQuery table error before?

I am trying to use PubSub Topic to BigQuery Dataflow.

The Dataflow job appears to be sending the incoming JSON published message to the table specified in BigQuery.

But, when I check the error table, I see 'Failed to serialize json to table row'

Any hints are much 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/eb7ee17c-7207-4080-8f7b-a96921ce92efn%40googlegroups.com.