[google-appengine] Index doesn't seem to work
I know I'm using python below, but this is really a question about
indexes.
I am trying to sort a query by price (low to high) and the query looks
like:
q = models.Slot.all()
q.filter('geoboxes =', geobox)
q.filter('date =', dt)
q.order('price')
index.yaml looks like this:
- kind: Slot
properties:
- name: geoboxes
- name: date
- name: price
Now this all works just lovely on the SDK, but despite the indexes
already being built on production, the wuery just will not sort by
price.
Should I delete the index and build it again?
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
Re: [google-appengine] asked to verify after switching from googlemail.com to gmail.com
I had the same problem. On Tue, Jun 8, 2010 at 11:49 AM, Scott Cowan wrote: > Hi I recently changed my email address from googlemail.com to > gmail.com > > now app engine asks to verify my account when creating additional apps > > it then says > > The phone number has been sent too many messages or has already been > used to confirm an account. > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to google-appeng...@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine+unsubscr...@googlegroups.com > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: The API call taskqueue.BulkAdd() was explicitly cancelled.
Stats Page now says "Elevated": http://code.google.com/status/appengine/ On Oct 4, 8:17 am, Col Wilson wrote: > I'm getting very high levels of Errors of this sort while trying to > execute queued tasks: > > "The API call taskqueue.BulkAdd() was explicitly cancelled." > > I have slowed the queue right down and reduced the possible size of > any db.puts and still they come. > > I can't believe that nobody has reported this at any time ever, but > still when I search the group I get no results. There is a Japanese > group talking about it > though:http://groups.google.co.jp/group/google-appengine/browse_thread/threa... > > Help someone please. -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] The API call taskqueue.BulkAdd() was explicitly cancelled.
I'm getting very high levels of Errors of this sort while trying to execute queued tasks: "The API call taskqueue.BulkAdd() was explicitly cancelled." I have slowed the queue right down and reduced the possible size of any db.puts and still they come. I can't believe that nobody has reported this at any time ever, but still when I search the group I get no results. There is a Japanese group talking about it though: http://groups.google.co.jp/group/google-appengine/browse_thread/thread/a781d450b68a4367/2aaa03d3f6bddc09?fwc=1 Help someone please. -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: The API call taskqueue.BulkAdd() was explicitly cancelled.
OK, just found the latency messages from the team. Looks like I'm not alone. APP-ID: motslot -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: Is App Engine Ok now for others? Too many errors in 8:21 AM
Mine seems to have improved too. So far. Let's hope... On Oct 19, 5:05 pm, Rafael Sierra wrote: > On Tue, Oct 19, 2010 at 1:42 PM, Kangesh Gunaseelan wrote: > > Hello, > > I am getting a bunch of HardDeadlineExceededError this morning and Request > > Aborted errors since 8:20 AM PST today. None of the requests in the past > > 20 minutes have succeeded. > > Are others experiencing the issue? > > Google folks, > > Can you please update? > > Thanks! > > I got only 6 errors (all timeouts) and 51.21k requests in the past 9 > hours, it seems fine to me > > > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google App Engine" group. > > To post to this group, send email to google-appeng...@googlegroups.com. > > To unsubscribe from this group, send email to > > google-appengine+unsubscr...@googlegroups.com. > > For more options, visit this group at > >http://groups.google.com/group/google-appengine?hl=en. > > -- > Rafael Sierrahttp://blog.rafaelsdm.com -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] GAE - new SSL certificate has different CNAME from expired one
We last renewed my SSL certificate two years ago - GAE was rather different then and we were using SNI+VIP. This time I ordered the cert and when i went to install I needed to fiddle with my DNS settings to prove that I owned the domain name. This took a while, but I got there. Finally I installed the new certificate using the developers console. That worked. Next I associated the domain name with the new certificate. No obvious problems. However when I checked my site at https://sub.mysite.com, the old certificate was still showing, I waited six hours, but it did not update. What I do notice however is that the cname on the new certificate has changed. On the console the old certificate had: CNAME to: ghs-svc-https-c.ghs-ssl.googlehosted.com While the new one has: CNAME to: ghs.googlehosted.com and my DNS looks like: ;QUESTION sub.mysite.com. IN TXT *;ANSWER* sub.mysite.com*. 3599 IN CNAME ghs-svc-https-c.ghs-ssl.googlehosted.com.* So on the face of it it looks like a good idea to change that to point at ghs.googlehosted.com, but I'm worried because at the moment I (and paying customers) can still see sub.mysite.com albeit without SSL and surely fiddling with the DNS will break that too? If you can offer any advice on this I'd be very thankful. Col -- 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/89166033-50a9-49b1-aa6b-9d380dcbd287%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[google-appengine] Re: GAE - new SSL certificate has different CNAME from expired one
No. This is a single domain certificate not an MDC cert. Should this be an MDC? That's not what I got from the help pages. If you'd like the account details I can PM you? Col On Tuesday, 23 August 2016 00:28:41 UTC+1, Adam (Cloud Platform Support) wrote: > > To clarify, you have 'ghs.googlehosted.com' specified as the Subject > Alternate Name on the new certificate? > > On Friday, August 19, 2016 at 9:33:15 AM UTC-4, Col Wilson wrote: >> >> We last renewed my SSL certificate two years ago - GAE was rather >> different then and we were using SNI+VIP. >> >> This time I ordered the cert and when i went to install I needed to >> fiddle with my DNS settings to prove that I owned the domain name. This >> took a while, but I got there. >> >> Finally I installed the new certificate using the developers console. >> That worked. >> >> Next I associated the domain name with the new certificate. No obvious >> problems. >> >> However when I checked my site at https://sub.mysite.com, the old >> certificate was still showing, I waited six hours, but it did not update. >> >> What I do notice however is that the cname on the new certificate has >> changed. On the console the old certificate had: >> >> CNAME to: ghs-svc-https-c.ghs-ssl.googlehosted.com >> >> >> While the new one has: >> >> CNAME to: ghs.googlehosted.com >> >> >> and >> >> my DNS looks like: >> >> ;QUESTION >> sub.mysite.com. IN TXT >> *;ANSWER* >> sub.mysite.com*. 3599 IN CNAME >> ghs-svc-https-c.ghs-ssl.googlehosted.com >> <http://ghs-svc-https-c.ghs-ssl.googlehosted.com>.* >> >> >> So on the face of it it looks like a good idea to change that to point at >> ghs.googlehosted.com, but I'm worried because at the moment I (and >> paying customers) can still see sub.mysite.com albeit without SSL and >> surely fiddling with the DNS will break that too? >> >> If you can offer any advice on this I'd be very thankful. >> >> Col >> >> >> >> >> -- 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/dcc6b5f9-f9d6-4ff9-8f0d-835579c46b0e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[google-appengine] GAE custom domain is displaying an old deleted SSL cert
First of all I'm sorry I can;t give you my custom domain name, but when I go there it's displaying an expired and deleted (from appengine/settings/certificates) ssl key. It's not a local caching thing because I've tried it on several browser, laptops and networks. I'd really rather it displayed the new one which is associated with it. Is there a fix for this? -- 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/725d75f6-5b2e-4111-9ba3-0442c34b379f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[google-appengine] Problems using generate_records with the bulkloader
I'm using Python 2.5 locally and GAE 1.5.
I'm trying to load data which is not is CSV format. Here's a
simplified model which reflects what I get with a more complex real
life issue:
class Thing(db.Model):
name = db.StringProperty()
class ThingLoader(bulkloader.Loader):
elements = [
('name', str)
]
def __init__(self):
bulkloader.Loader.__init__(self, 'Thing', self.elements)
def generate_records(self, filename):
records = load_records_from_some_datasource()
for record in records:
yield [
record['name']
]
loaders = [Thing]
When I try to bulkload this (both locally or to google) I get:
InternalError: Put accepted 10 entities but returned 0 keys.
I can't work out why the datastore will not allocate keys. Any ideas
what I should do?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~--~~~~--~~--~--~---
[google-appengine] Re: Problems using generate_records with the bulkloader
loaders = [ThingLoader]
is what I meant to type.
On Sep 19, 10:14 am, Col Wilson
wrote:
> I'm using Python 2.5 locally and GAE 1.5.
>
> I'm trying to load data which is not is CSV format. Here's a
> simplified model which reflects what I get with a more complex real
> life issue:
>
> class Thing(db.Model):
> name = db.StringProperty()
>
> class ThingLoader(bulkloader.Loader):
> elements = [
> ('name', str)
> ]
>
> def __init__(self):
> bulkloader.Loader.__init__(self, 'Thing', self.elements)
>
> def generate_records(self, filename):
> records = load_records_from_some_datasource()
> for record in records:
> yield [
> record['name']
> ]
>
> loaders = [Thing]
>
> When I try to bulkload this (both locally or to google) I get:
>
> InternalError: Put accepted 10 entities but returned 0 keys.
>
> I can't work out why the datastore will not allocate keys. Any ideas
> what I should do?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~--~~~~--~~--~--~---
[google-appengine] Re: Problems using generate_records with the bulkloader
Nick, I went back to my real word code and created a CSV and yes, the
same problem...
[INFO] Connecting to localhost:8080/remote_api
[DEBUG ] [Thread-11] ProgressTrackerThread: started
[DEBUG ] [Thread-12] DataSourceThread: started
[INFO] Starting import; maximum 10 entities per post
[DEBUG ] [Thread-12] DataSourceThread: exiting
[DEBUG ] Waiting for worker threads to finish...
[DEBUG ] [Thread-3] Got work item [1-10]
[ERROR ] Retrying on non-fatal datastore error: Put accepted 10
entities but returned 0 keys.
Traceback (most recent call last):
File "C:\Program Files\Google\google_appengine\google\appengine\tools
\bulkloader.py", line 675, in PerformWork
transfer_time = self._TransferItem(thread_pool)
File "C:\Program Files\Google\google_appengine\google\appengine\tools
\bulkloader.py", line 832, in _TransferItem
self.request_manager.PostEntities(self.content)
File "C:\Program Files\Google\google_appengine\google\appengine\tools
\bulkloader.py", line 1239, in PostEntities
datastore.Put(entities)
File "C:\Program Files\Google\google_appengine\google\appengine\api
\datastore.py", line 179, in Put
(num_entities, num_keys))
InternalError: Put accepted 10 entities but returned 0 keys.
[INFO] Backing off due to errors: 1.0 seconds
[DEBUG ] [Thread-3] Got work item [1-10]
On 21 Sep, 14:52, "Nick Johnson (Google)"
wrote:
> Hi Col,
> Can you try loading from CSV (eg, remove your generate_records method) and
> let us know if you see the same problem? Also, can you please include the
> complete stacktrace?
>
> -Nick Johnson
>
> On Sat, Sep 19, 2009 at 12:28 PM, Col Wilson <
>
>
>
>
>
> col.wilson.em...@googlemail.com> wrote:
>
> > loaders = [ThingLoader]
>
> > is what I meant to type.
>
> > On Sep 19, 10:14 am, Col Wilson
> > wrote:
> > > I'm using Python 2.5 locally and GAE 1.5.
>
> > > I'm trying to load data which is not is CSV format. Here's a
> > > simplified model which reflects what I get with a more complex real
> > > life issue:
>
> > > class Thing(db.Model):
> > > name = db.StringProperty()
>
> > > class ThingLoader(bulkloader.Loader):
> > > elements = [
> > > ('name', str)
> > > ]
>
> > > def __init__(self):
> > > bulkloader.Loader.__init__(self, 'Thing', self.elements)
>
> > > def generate_records(self, filename):
> > > records = load_records_from_some_datasource()
> > > for record in records:
> > > yield [
> > > record['name']
> > > ]
>
> > > loaders = [Thing]
>
> > > When I try to bulkload this (both locally or to google) I get:
>
> > > InternalError: Put accepted 10 entities but returned 0 keys.
>
> > > I can't work out why the datastore will not allocate keys. Any ideas
> > > what I should do?
>
> --
> Nick Johnson, Developer Programs Engineer, App Engine
> Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration Number:
> 368047
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~--~~~~--~~--~--~---
[google-appengine] Re: Problems using generate_records with the bulkloader
# models.py
from google.appengine.ext import db
class CainIncident(db.Model):
name = db.StringProperty()
status = db.StringProperty()
date = db.DateProperty()
age = db.IntegerProperty()
type = db.StringProperty()
narrative = db.StringProperty()
blamed = db.StringProperty()
lat = db.FloatProperty()
lon = db.FloatProperty()
created = db.DateTimeProperty(auto_now_add=True)
# data_api.py
import datetime
import os
import re
import sys
sys.path.insert(0, '.')
from google.appengine.api import datastore_types
from google.appengine.ext import db
from google.appengine.tools import bulkloader
from utils.parsedatetime.parsedatetime import Calendar
from models import CainIncident
class CainLoader(bulkloader.Loader):
elements = [
('name', str),
('status', str),
('date', lambda x: datetime.date(*(Calendar().parseDateText(x)
[:3])) ),
('age', int),
('type', str),
('narrative', str),
('blamed', str),
('lat', float),
('lon', float)
]
def __init__(self):
bulkloader.Loader.__init__(self, 'CainIncident',
self.elements)
loaders = [CainLoader]
# cain_raw.csv
"Abbott, Anthony","British Army (BA),",24 October 1976,19,nfNI,"Shot
by snipers while checking abandoned car, Oakfield Street, Ardoyne,
Belfast.",Irish Republican Army (IRA),54.5972686,-5.9301088
"Abercrombie, Aubrey","Ulster Defence Regiment (UDR),",05 February
1980,44,Protestant,"Off duty. Shot at his farm, near Kinawley, County
Fermanagh.",Irish Republican Army (IRA),54.22641,-7.649053
"Abernethy, Colin","Civilian Political Activist (CivPA),",09 September
1988,30,Protestant,"Ulster Clubs member. Shot while travelling on
train to his workplace, Finaghy, Belfast.",Irish Republican Army (IRA),
54.5553948,-5.9930868
"Abrams, Kieran","Civilian (Civ),",05 July 1992,35,Catholic,"Found
beaten to death, North Howard Street, Lower Falls, Belfast.",non-
specific Loyalist group (LOY),54.5972686,-5.9301088
"Acheson, Alfred","Civilian (Civ),",03 June 1973,48,Protestant,"Shot
while in friend's house, Druse Street, Lower Oldpark, Belfast.",Ulster
Volunteer Force (UVF),54.5972686,-5.9301088
"Acheson, Kenneth","Royal Ulster Constabulary (RUC),",02 April
1981,23,Protestant,"Off duty. Killed when detonated booby trap bomb
attached to his car, shortly after leaving Bessbrook Royal Ulster
Constabulary (RUC) base, County Armagh.",Irish Republican Army (IRA),
54.3475392,-6.6561082
"Adams, Nathaniel","Civilian (Civ),",05 April
1975,29,Protestant,"Killed in bomb attack on Mountainview Tavern,
Shankill Road, Belfast.",non-specific Republican group (REP),
54.6040929,-5.9493439
"Adams, Stanley","Ulster Defence Regiment (UDR),",28 October
1976,29,Protestant,"Off duty. Shot while delivering mail, Altmore,
near Pomeroy, County Tyrone.",Irish Republican Army (IRA),
54.5686974,-6.9641998
"Adams, Terence","British Army (BA),",06 December 1982,20,nfNI,"Off
duty. Killed by time bomb left in disco at Droppin Well Bar,
Ballykelly, County Derry.",Irish National Liberation Army (INLA),
54.99405,-7.325508
"Adams, Michael","Ulster Defence Regiment (UDR),",09 April
1990,23,Protestant,"Killed in land mine attack on Ulster Defence
Regiment mobile patrol, Ballydugan Road, Downpatrick, County
Down.",Irish Republican Army (IRA),54.3237914,-5.7205771
On 23 Sep, 08:57, "Nick Johnson (Google)"
wrote:
> Hi Col,
>
> Would you be prepared to send me your script, model definitions, and the
> first few lines of your CSV file? This looks like it could be a bug in the
> SDK.
>
> -Nick Johnson
>
> On Wed, Sep 23, 2009 at 7:40 AM, Col Wilson
>
>
>
>
> > wrote:
>
> > Nick, I went back to my real word code and created a CSV and yes, the
> > same problem...
>
> > [INFO ] Connecting to localhost:8080/remote_api
> > [DEBUG ] [Thread-11] ProgressTrackerThread: started
> > [DEBUG ] [Thread-12] DataSourceThread: started
> > [INFO ] Starting import; maximum 10 entities per post
> > [DEBUG ] [Thread-12] DataSourceThread: exiting
> > [DEBUG ] Waiting for worker threads to finish...
> > [DEBUG ] [Thread-3] Got work item [1-10]
> > [ERROR ] Retrying on non-fatal datastore error: Put accepted 10
> > entities but returned 0 keys.
> > Traceback (most recent call last):
> > File "C:\Program Files\Google\google_appengine\google\appengine\tools
> > \bulkloader.py", line 675, in PerformWork
> > transfer_t
[google-appengine] Re: Problems using generate_records with the bulkloader
Actually I did. It took some messing about, but I post my solution
below so maybe it will help you:
Let us know how you solve it, and good luck.
class CainIncident:
name = db.StringProperty()
created = db.DateTimeProperty(auto_now_add=True)
class CainLoader(bulkloader.Loader):
elements = [
('name', str),
]
def __init__(self):
bulkloader.Loader.__init__(self, 'CainIncident',
self.elements)
def get_data(self):
'''returns an array of hashes like { 'name': 'Some Name'}'''
return [
{ 'name': 'Some Name'},
{ 'name': 'Some Other Name'},
]
def generate_records(self, filename):
data = self.get_data()
for record in data:
yield [
record['name'],
]
loaders = [CainLoader]
On Oct 18, 12:19 am, Walter wrote:
> Did you ever figure out what the problem was? I am being blocked by
> the same issue.
>
> Thanks,
> Walter
>
> On Sep 19, 2:14 am, Col Wilson
> wrote:
>
>
>
> > I'm using Python 2.5 locally and GAE 1.5.
>
> > I'm trying to load data which is not is CSV format. Here's a
> > simplified model which reflects what I get with a more complex real
> > life issue:
>
> > class Thing(db.Model):
> > name = db.StringProperty()
>
> > class ThingLoader(bulkloader.Loader):
> > elements = [
> > ('name', str)
> > ]
>
> > def __init__(self):
> > bulkloader.Loader.__init__(self, 'Thing', self.elements)
>
> > def generate_records(self, filename):
> > records = load_records_from_some_datasource()
> > for record in records:
> > yield [
> > record['name']
> > ]
>
> > loaders = [Thing]
>
> > When I try to bulkload this (both locally or to google) I get:
>
> > InternalError: Put accepted 10 entities but returned 0 keys.
>
> > I can't work out why the datastore will not allocate keys. Any ideas
> > what I should do?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~--~~~~--~~--~--~---
