[google-appengine] Re: bugs in index?
Hi buger,
Sorry for the long delay. Your indexes should now be fixed.
-Nick Johnson
On Thu, Jul 2, 2009 at 4:11 PM, buger wrote:
>
> Ooh, looks like it is my karma of beta-tester. Nick, is it serious
> bug? Maybe I it's not original question, but how it's going, do you
> have progress?)
>
> On 29 июн, 20:40, "Nick Johnson (Google)"
> wrote:
>> Hi buger,
>>
>> I'm looking into it at the moment.
>>
>> -Nick Johnson
>>
>>
>>
>> On Mon, Jun 29, 2009 at 5:38 PM, buger wrote:
>>
>> > Is my problem investigating? Because it is a critical bug...
>>
>> > On Jun 27, 1:25 pm, buger wrote:
>> >> "and this 2 queries return one result!" i mean queries in first
>> >> message
>>
>> >> On Jun 27, 1:19 pm, buger wrote:
>>
>> >> > Oohh, it's more interesting problem than i though. I rebuild my
>> >> > indexes, and this 2 queries return one result!
>> >> > Let's look:
>>
>> >> > SELECT * FROM Video WHERE artist = Key
>> >> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM')
>>
>> >> > This query returns 5 objects, and 4 of them have status value is equal
>> >> > to "2"
>>
>> >> > SELECT * FROM Video WHERE artist = Key
>> >> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
>> >> > status = 2
>> >> > This query return only 1 object. Ooops, what is it? :)
>>
>> >> > my appid is "musicvideobuger"
>>
>> >> > On Jun 26, 2:26 pm, "Nick Johnson (Google)"
>> >> > wrote:
>>
>> >> > > Hi buger,
>>
>> >> > > Is this in production, or on the dev_appserver? In production, your
>> >> > > app does not appear to have the necessary indexes to execute the
>> >> > > second query.
>>
>> >> > > -Nick Johnson
>>
>> >> > > On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>>
>> >> > > > SELECT * FROM Video WHERE artist = Key
>> >> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
>> >> > > > status = 2
>> >> > > > This query gives me 4 results
>>
>> >> > > > But this gives only 1 result!, i'm just added order
>> >> > > > SELECT * FROM Video WHERE artist = Key
>> >> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
>> >> > > > status = 2 ORDER BY created_at desc
>>
>> >> > > > created_at is DateTime property, and all this objects have it
>>
>> >> > > --
>> >> > > Nick Johnson, App Engine Developer Programs Engineer
>> >> > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration
>> >> > > Number: 368047
>>
>> --
>> Nick Johnson, App Engine Developer Programs Engineer
>> Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration
>> Number: 368047
> >
>
--
Nick Johnson, App Engine Developer Programs Engineer
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: bugs in index?
Ooh, looks like it is my karma of beta-tester. Nick, is it serious
bug? Maybe I it's not original question, but how it's going, do you
have progress?)
On 29 июн, 20:40, "Nick Johnson (Google)"
wrote:
> Hi buger,
>
> I'm looking into it at the moment.
>
> -Nick Johnson
>
>
>
> On Mon, Jun 29, 2009 at 5:38 PM, buger wrote:
>
> > Is my problem investigating? Because it is a critical bug...
>
> > On Jun 27, 1:25 pm, buger wrote:
> >> "and this 2 queries return one result!" i mean queries in first
> >> message
>
> >> On Jun 27, 1:19 pm, buger wrote:
>
> >> > Oohh, it's more interesting problem than i though. I rebuild my
> >> > indexes, and this 2 queries return one result!
> >> > Let's look:
>
> >> > SELECT * FROM Video WHERE artist = Key
> >> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM')
>
> >> > This query returns 5 objects, and 4 of them have status value is equal
> >> > to "2"
>
> >> > SELECT * FROM Video WHERE artist = Key
> >> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> >> > status = 2
> >> > This query return only 1 object. Ooops, what is it? :)
>
> >> > my appid is "musicvideobuger"
>
> >> > On Jun 26, 2:26 pm, "Nick Johnson (Google)"
> >> > wrote:
>
> >> > > Hi buger,
>
> >> > > Is this in production, or on the dev_appserver? In production, your
> >> > > app does not appear to have the necessary indexes to execute the
> >> > > second query.
>
> >> > > -Nick Johnson
>
> >> > > On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>
> >> > > > SELECT * FROM Video WHERE artist = Key
> >> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> >> > > > status = 2
> >> > > > This query gives me 4 results
>
> >> > > > But this gives only 1 result!, i'm just added order
> >> > > > SELECT * FROM Video WHERE artist = Key
> >> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> >> > > > status = 2 ORDER BY created_at desc
>
> >> > > > created_at is DateTime property, and all this objects have it
>
> >> > > --
> >> > > Nick Johnson, App Engine Developer Programs Engineer
> >> > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration
> >> > > Number: 368047
>
> --
> Nick Johnson, App Engine Developer Programs Engineer
> 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: bugs in index?
Hi buger,
I'm looking into it at the moment.
-Nick Johnson
On Mon, Jun 29, 2009 at 5:38 PM, buger wrote:
>
> Is my problem investigating? Because it is a critical bug...
>
> On Jun 27, 1:25 pm, buger wrote:
>> "and this 2 queries return one result!" i mean queries in first
>> message
>>
>> On Jun 27, 1:19 pm, buger wrote:
>>
>> > Oohh, it's more interesting problem than i though. I rebuild my
>> > indexes, and this 2 queries return one result!
>> > Let's look:
>>
>> > SELECT * FROM Video WHERE artist = Key
>> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM')
>>
>> > This query returns 5 objects, and 4 of them have status value is equal
>> > to "2"
>>
>> > SELECT * FROM Video WHERE artist = Key
>> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
>> > status = 2
>> > This query return only 1 object. Ooops, what is it? :)
>>
>> > my appid is "musicvideobuger"
>>
>> > On Jun 26, 2:26 pm, "Nick Johnson (Google)"
>> > wrote:
>>
>> > > Hi buger,
>>
>> > > Is this in production, or on the dev_appserver? In production, your
>> > > app does not appear to have the necessary indexes to execute the
>> > > second query.
>>
>> > > -Nick Johnson
>>
>> > > On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>>
>> > > > SELECT * FROM Video WHERE artist = Key
>> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
>> > > > status = 2
>> > > > This query gives me 4 results
>>
>> > > > But this gives only 1 result!, i'm just added order
>> > > > SELECT * FROM Video WHERE artist = Key
>> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
>> > > > status = 2 ORDER BY created_at desc
>>
>> > > > created_at is DateTime property, and all this objects have it
>>
>> > > --
>> > > Nick Johnson, App Engine Developer Programs Engineer
>> > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration
>> > > Number: 368047
> >
>
--
Nick Johnson, App Engine Developer Programs Engineer
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: bugs in index?
Is my problem investigating? Because it is a critical bug...
On Jun 27, 1:25 pm, buger wrote:
> "and this 2 queries return one result!" i mean queries in first
> message
>
> On Jun 27, 1:19 pm, buger wrote:
>
> > Oohh, it's more interesting problem than i though. I rebuild my
> > indexes, and this 2 queries return one result!
> > Let's look:
>
> > SELECT * FROM Video WHERE artist = Key
> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM')
>
> > This query returns 5 objects, and 4 of them have status value is equal
> > to "2"
>
> > SELECT * FROM Video WHERE artist = Key
> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > status = 2
> > This query return only 1 object. Ooops, what is it? :)
>
> > my appid is "musicvideobuger"
>
> > On Jun 26, 2:26 pm, "Nick Johnson (Google)"
> > wrote:
>
> > > Hi buger,
>
> > > Is this in production, or on the dev_appserver? In production, your
> > > app does not appear to have the necessary indexes to execute the
> > > second query.
>
> > > -Nick Johnson
>
> > > On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>
> > > > SELECT * FROM Video WHERE artist = Key
> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > > > status = 2
> > > > This query gives me 4 results
>
> > > > But this gives only 1 result!, i'm just added order
> > > > SELECT * FROM Video WHERE artist = Key
> > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > > > status = 2 ORDER BY created_at desc
>
> > > > created_at is DateTime property, and all this objects have it
>
> > > --
> > > Nick Johnson, App Engine Developer Programs Engineer
> > > 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: bugs in index?
"and this 2 queries return one result!" i mean queries in first
message
On Jun 27, 1:19 pm, buger wrote:
> Oohh, it's more interesting problem than i though. I rebuild my
> indexes, and this 2 queries return one result!
> Let's look:
>
> SELECT * FROM Video WHERE artist = Key
> ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM')
>
> This query returns 5 objects, and 4 of them have status value is equal
> to "2"
>
> SELECT * FROM Video WHERE artist = Key
> ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> status = 2
> This query return only 1 object. Ooops, what is it? :)
>
> my appid is "musicvideobuger"
>
> On Jun 26, 2:26 pm, "Nick Johnson (Google)"
> wrote:
>
> > Hi buger,
>
> > Is this in production, or on the dev_appserver? In production, your
> > app does not appear to have the necessary indexes to execute the
> > second query.
>
> > -Nick Johnson
>
> > On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>
> > > SELECT * FROM Video WHERE artist = Key
> > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > > status = 2
> > > This query gives me 4 results
>
> > > But this gives only 1 result!, i'm just added order
> > > SELECT * FROM Video WHERE artist = Key
> > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > > status = 2 ORDER BY created_at desc
>
> > > created_at is DateTime property, and all this objects have it
>
> > --
> > Nick Johnson, App Engine Developer Programs Engineer
> > 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: bugs in index?
Oohh, it's more interesting problem than i though. I rebuild my
indexes, and this 2 queries return one result!
Let's look:
SELECT * FROM Video WHERE artist = Key
('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM')
This query returns 5 objects, and 4 of them have status value is equal
to "2"
SELECT * FROM Video WHERE artist = Key
('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
status = 2
This query return only 1 object. Ooops, what is it? :)
my appid is "musicvideobuger"
On Jun 26, 2:26 pm, "Nick Johnson (Google)"
wrote:
> Hi buger,
>
> Is this in production, or on the dev_appserver? In production, your
> app does not appear to have the necessary indexes to execute the
> second query.
>
> -Nick Johnson
>
> On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>
> > SELECT * FROM Video WHERE artist = Key
> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > status = 2
> > This query gives me 4 results
>
> > But this gives only 1 result!, i'm just added order
> > SELECT * FROM Video WHERE artist = Key
> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > status = 2 ORDER BY created_at desc
>
> > created_at is DateTime property, and all this objects have it
>
> --
> Nick Johnson, App Engine Developer Programs Engineer
> 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: bugs in index?
It all was in production. And I have right indexes at that moment
(actually had :), when i've done smth wrong with indexes when tried to
fix it, now they marked as error. I tried to vacuum indexed by
instruction, but they marked as error near 20 hours :( )
On Jun 26, 2:26 pm, "Nick Johnson (Google)"
wrote:
> Hi buger,
>
> Is this in production, or on the dev_appserver? In production, your
> app does not appear to have the necessary indexes to execute the
> second query.
>
> -Nick Johnson
>
> On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>
> > SELECT * FROM Video WHERE artist = Key
> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > status = 2
> > This query gives me 4 results
>
> > But this gives only 1 result!, i'm just added order
> > SELECT * FROM Video WHERE artist = Key
> > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> > status = 2 ORDER BY created_at desc
>
> > created_at is DateTime property, and all this objects have it
>
> --
> Nick Johnson, App Engine Developer Programs Engineer
> 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: bugs in index?
Hi buger,
Is this in production, or on the dev_appserver? In production, your
app does not appear to have the necessary indexes to execute the
second query.
-Nick Johnson
On Thu, Jun 25, 2009 at 11:38 PM, buger wrote:
>
> SELECT * FROM Video WHERE artist = Key
> ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> status = 2
> This query gives me 4 results
>
> But this gives only 1 result!, i'm just added order
> SELECT * FROM Video WHERE artist = Key
> ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND
> status = 2 ORDER BY created_at desc
>
> created_at is DateTime property, and all this objects have it
> >
>
--
Nick Johnson, App Engine Developer Programs Engineer
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
-~--~~~~--~~--~--~---
