Is it possible that some of your entities in Table1 were stored when
cid was declared unindexed? If so you will need to re-store them so
they get indexed in the implicit cid index and also in the custom
index on cid-ctime.
Whether or not this was the cause of some entities not being included
in the custom index, you should try to re-store those entities that
are missing from your query.
On 19 Jan 2010, at 20:01, Max wrote:
How do we to contact support?
If we pay money then there must be at least email address where I can
send email?
Basic query does not return every second line that it should return.
May be something wrong with index.
Please, help
On Jan 17, 3:59 pm, Max <[email protected]> wrote:
I can't find way to report serious problem.
We have uploaded real customer data and there is bug in datastore
results.
But I can't find way to send screenshots and queries that will not be
seem by everyone.
I can't show customer emails or IDs.
In short problem is that when I do following query (I have changed
IDs
and table names)
SELECT * FROM Table1 WHERE ctime >= DATETIME('2009-12-01 00:00:00')
ORDER BY ctime
key - is key
cid - is indexed long
ctime - is indexed date
first 2 lines are
cid:1234 cid:2009-12-01 00:00:37
cid:2345 ctime:2009-12-01 00:01:11
when I filter it to show cis=2345 only
SELECT * FROM Table1 WHERE cid= 2345 and ctime >=
DATETIME('2009-12-01
00:00:00') ORDER BY ctime
first 2 lines are
cid:2345 ctime:2009-12-01 00:03:26
cid:2345 ctime:2009-12-01 00:15:09
----
I expected to see "cid:2345 ctime:2009-12-01 00:01:11 " as
first line
in second query.
But it is missing.
We have uploaded 5,426,307 entities (9 GBytes) data to datastore and
our report for December 2009 till now showed that
countMissing = 28253
countExists = 17555
----
How can I contact you privately? This data is stored on paid account.
Thanks, Max
--
You received this message because you are subscribed to the Google
Groups "Google App Engine for Java" group.
To post to this group, send email to [email protected]
.
To unsubscribe from this group, send email to [email protected]
.
For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en
.
--
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
