[google-appengine] Re: Google Cloud SQL Incident #18002

[Delyan Spasov]

Thanks Katayoon,

I have created a new ticket. But there is no instance...
This is strange. The console says:
This version has no instances deployed.

Where can I check which Cloud SQL version we are using?


On Friday, August 24, 2018 at 1:17:26 AM UTC+3, Katayoon (Cloud Platform 
Support) wrote:
>
> The incident you mentioned was related to the Cloud SQL v1 instance 
> availability in us-central1-a. 
>
> If you have such an instance and you are still encountering issues related 
> to this instance, I recommend that you open a PRIVATE case in the Issue 
> Tracker  and 
> provide us with your project number and your Cloud SQL instance name so 
> that we would be able to investigate the root cause of the issue 
> efficiently. If not, you may post your full detailed question 
>  to Stack Overflow 
> , using the 
> supported Cloud tags for technical question.
>
>
> - Note that Google Groups are reserved for general Google Cloud 
> Platform-end product discussions and not for reporting issues or technical 
> questions. 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/cc4599ce-67af-4c48-a394-79bc0af2bf1e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Google Cloud SQL Incident #18002

[Delyan Spasov]

It is not up and running. There are still problems. And the logs does not 
tell anything meaningful.
Just this:
The request failed because the instance could not start successfully

Why the instance is not starting successfully?

Can I solve this issue somehow?
Or to create new application on another server. This one is on us-central.
We have another project on server in Europe and there we have no problem. 
Should I move it there?


On Friday, August 17, 2018 at 6:59:30 PM UTC+3, George (Cloud Platform 
Support) wrote:
>
> Your site is up-and-running once again. The issue 
>  has been 
> addressed meanwhile: *"The issue with Cloud SQL First Generation instance 
> unavailability has been resolved for all affected projects as of Thursday, 
> 2018-08-16 10:38 US/Pacific. We will conduct an internal investigation of 
> this issue and make appropriate improvements to our systems to help prevent 
> or minimize future recurrence".* 
>
> It is difficult to decide after fact if the log entry you mention is 
> related to the above issue. 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/7bbc9fae-dfc5-406d-a354-530cc0c05f09%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Google Cloud SQL Incident #18002

[Delyan Spasov]

Our site om Google App Engine Standard is not working - 
https://praktrik.com/. 
There is a message in the console:

We are experiencing an issue with Cloud SQL v1 instance availability in 
> us-central1-a beginning at Thursday, 2018-08-16 08:48 US/Pacific. Our 
> engineering team has identified the problem and is performing mitigation. 
> For everyone who is affected, we apologize for the disruption. We will 
> provide an update by Thursday, 2018-08-16 11:15 US/Pacific with current 
> details.


There is an error log but in the log is not clear if it is caused by this 
issue:


HttpBadRequestError: HttpError accessing 
> :
>  
> response: <{'status': '400', 'content-length': '119', 'x-xss-protection': 
> '1; mode=block', 'x-content-type-options': 'nosniff', 'x-goog-trace-id': 
> '123ff47823337dd14fb64f98f3d8498f', 'transfer-encoding': 'chunked', 'vary': 
> 'Origin, X-Origin, Referer', 'server': 'ESF', '-content-encoding': 'gzip', 
> 'cache-control': 'private', 'date': 'Sun, 08 Jul 2018 19:36:16 GMT', 
> 'x-frame-options': 'SAMEORIGIN', 'alt-svc': 'quic=":443"; ma=2592000; 
> v="43,42,41,39,35"', 'content-type': 'application/json; charset=UTF-8'}>, 
> content <{ "error": { "code": 400, "message": "Precondition check failed.", 
> "status": "FAILED_PRECONDITION" } } >


Does anyone knows if this error log is related to the issue? Can I do 
something to get it working? 

Thanks!

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/01dc4b35-9ad8-41a3-ab96-de8f6bfabfd2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: How to download data from my datastore to the local machine

[Delyan Spasov]

Thank you Alex,

I have read the docs for the remote_api. For some reason it isn't working 
and the error isn't very useful to find our why 
- NotSupportedOnThisPlatform.
I have found bug reports about this, but nobody is giving a working 
solution. 

Fortunately I can connect the remote_api from the console and I wrote a 
simple script to download the data to a file (Good that my database was a 
small one).

Regards

On Friday, March 3, 2017 at 9:43:59 PM UTC+2, Alex (Cloud Platform Support) 
wrote:
>
> In fact, current Cloud Datastore’s NoSQL implementation of relationships 
> between data objects differs from traditional databases. And the observed 
> feature differences in this thread can be related to what is described on 
> the Google Cloud Datastore Overview documentation 
> .
>
> Nevertheless, in case you would want to migrate your data to another 
> Google Cloud application, you can use the Cloud Storage backing up 
> functionality to export a datastore backup into a Storage bucket (See this 
> Backing up data section 
> 
>  
> of the Managing Datastore guide). Note that using this method, also allows 
> to export your data to other Google Cloud Platform services, such as Google 
> BigQuery (See Backup and restore considerations 
> 
> ).
>
> Lastly, here is a guide 
>  
> about Accessing App Engine with Remote API, that may get you further 
> insights on how to write a client to download the data according to your 
> specifications. See step 6 of Using the Remote API in a local client 
> section 
> 
>  
> for an example on how to format and retrieve data from a Datastore instance.
>
> Hope you’ll find this information insightful and feel free to look at 
> different Cloud products as Cloud SQL  
> that may more accurately suit your needs. In case you would like to see the 
> previously available "appcfg.py” [download_data] available in this Cloud 
> Datastore implementation, it is possible to open a Features request on this 
> Issue Tracker and making sure to specify “Feature Requests” under Component.
>
> Regards,
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/3bc69663-dca2-4c83-bf18-eb34299a5436%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: How to download data from my datastore to the local machine

[Delyan Spasov]

Thanks Nicola,

>From the interactive shell I can access the remote_api. But not from my 
application. It is raising NotSupportedOnThisPlatform(). Since this is in 
Python you probably don't know about this error. I found it as an issue but 
I didn't find a solution of it. 

I don't know how to write a client to download the data. I don't know how 
to format it in a way that the local server will accept it and I also don't 
know how to import it in the local server. There is not any documentation 
about it. 

But I think this should be included. It was but they have changed it 
because of the Oauth. OK, then include it again using Oauth. It isn't 
normal to not be able to export your db. This is very low quality service. 


On Tuesday, February 28, 2017 at 9:19:18 AM UTC+2, Nicola Spreafico wrote:
>
> The appcfg client cannot be used anymore because it use a 
> username/password authentication, which has been deprecated in favor of 
> oauth2 (and not supported by the client itself).
> About 1 year ago I had a very very long ticket with google support (issue 
> number #08922843) where we analyzed all this situation, here a couple of 
> comments:
>
> We ended up writing a very simple remote API handler (both server and 
> client) in order to reproduce the same need as you.
> You need to deploy online a version with remote_api enabled and the write 
> a simple client which will download the data (for all the kinds you need) 
> from online and load it inside the local dev-server
>
> In my case the client was written in Java, but because the remote_api 
> exists in python I'm very confident that you can build a client of your own.
> The main thing to take care is (this example is for java language, i think 
> a python counterpart exists as well)
> if ( ... remote api connected to development server ...) {
> options.useDevelopmentServerCredential();
> } else {
> options.useApplicationDefaultCredential();
> }
>
> When you need to connect with the online environment, the 
> application-default is used which need to be configured using GCloud SDK
>
>
>> https://cloud.google.com/sdk/gcloud/reference/beta/auth/application-default/login
>
>
>
>
> Il giorno lunedì 27 febbraio 2017 21:56:47 UTC+1, Delyan Spasov ha scritto:
>>
>> I've wasted lot of time trying to download the datatstore to my local 
>> machine. Nothing works!
>>
>> The appcfg download_data doesn't seem to work any more. There is nothing 
>> about it in the new docs. It's not even mentioned even as deprecation 
>> notice.
>>
>> It is still there in the appcfg. But it doesn't work. 
>> I've tried to upload some old data. It doesn't work.
>> I've tried the remote_api. Tones of errors.
>>
>> They all used to work. What happened?
>> How to work with my database on the local machine?  
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/af71a864-4b98-4687-a704-67de033d1b88%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: How to download data from my datastore to the local machine

[Delyan Spasov]

I read it but I don't understand how to download my database. 

The lack of any normal way of exporting my database is making me nervous 
about using GAE in the future. What if I decide to migrate because of some 
reason? 

I will find some workaround for the current projects (I will have to). But 
I don't see myself starting a new project on GAE. 

Thanks!

On Tuesday, February 28, 2017 at 10:15:39 PM UTC+2, Alex (Cloud Platform 
Support) wrote:
>
> To add up to Nicola’s reply, you may be able to download your data to your 
> local machine by opening the local Datastore viewer as proposed on this 
> Issue Tracker thread 
> . To do 
> so, you will have to access the viewer locally at “
> http://localhost:8000/_ah/admin/datastore” and get the whole data flushed 
> to you local disk.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/51f0d4fa-1e68-4897-b8a9-f482522f1cd5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] How to download data from my datastore to the local machine

[Delyan Spasov]

I've wasted lot of time trying to download the datatstore to my local 
machine. Nothing works!

The appcfg download_data doesn't seem to work any more. There is nothing 
about it in the new docs. It's not even mentioned even as deprecation 
notice.

It is still there in the appcfg. But it doesn't work. 
I've tried to upload some old data. It doesn't work.
I've tried the remote_api. Tones of errors.

They all used to work. What happened?
How to work with my database on the local machine?  

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/8001de68-02d9-4710-9d1f-d90ea04684d8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Duplicate property error after migration to ptyhon 2.7

[Delyan Spasov]

I am trying to migrate my app to python 2.7
The default version which is still using python 2.5 works fine. 
But when I try to run it under 2.7 I get 500 Serever Error with the 
following traceback:

: Class Model already 
has property event_set 
Traceback (most recent call last):
  File "/base/data/home/apps/s~koncerti-bg-hrd/4.367721112548412011/main.app", 
line 37, in 
class Event(search.SearchableModel):
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py",
 line 515, in __init__
_initialize_properties(cls, name, bases, dct)
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py",
 line 430, in _initialize_properties
attr.__property_config__(model_class, attr_name)
  File 
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py",
 line 3686, in __property_config__
self.collection_name))


-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.