Hi Denya,
Your indexes should be fixed now.

-Nick Johnson

On Mon, Sep 21, 2009 at 3:30 PM, Denya <[email protected]> wrote:

> Hey, is there anybody there?
> I can't understand, why my queries fails.
>
> app-id: classificators-ru
>
> Query:
> SELECT * FROM KladrStreetRecord WHERE name = 'Грузинская Б.'
>
> Returns one record with city_code = '77000000000' (type 'string')
>
> Query:
> SELECT * FROM KladrStreetRecord WHERE city_code = '77000000000' AND name =
> 'Грузинская Б.'
>
> Returns none.
>
> WTF?!?!?
>
>
> On Sun, Sep 20, 2009 at 10:56 PM, Denya <[email protected]> wrote:
>
>> Tried to delete indexes -- after 5h status became <<Error>>.Cool, and what?
>> :) I want to rebuild some of them.
>>
>> Now i make vacuum_indexes again and they are <<Deleting>> now... And how much
>> time it take?
>>
>> BTW, i decide to rebuild indexes (delete and create it again) cause there
>> were magic problems with data fetching.
>>
>> Query SELECT * FROM KladrStreetRecord WHERE name = 'Gruz'
>> returned records, where name = 'Gruz', ok
>>
>> Query SELECT * FROM KladrStreetRecord WHERE name >= 'Gruz'
>> returned records, where name = 'Gruzaa', 'Gruzzz', but no 'Gruz'.
>>
>> This is just example, but really some of records disappeared, when i make
>> query with inequality.
>>
>>
>> On Fri, Sep 18, 2009 at 2:43 PM, Nick Johnson (Google) <
>> [email protected]> wrote:
>>
>>> Hi Denya,
>>> Your index is still building. Please email us back if it's been >24 hours
>>> and hasn't built yet.
>>>
>>> -Nick Johnson
>>>
>>>
>>> On Fri, Sep 18, 2009 at 9:11 AM, Denya <[email protected]> wrote:
>>>
>>>> At all, we've got stuked indexes...Hey, anybody can help us? We're
>>>> waitin' for indexes > 5h.
>>>> Yesterday indexes for the same db was built in 5min
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Nick Johnson, Developer Programs Engineer, App Engine
>>> Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration
>>> Number: 368047
>>>
>>>
>>>
>>
>
> >
>


-- 
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 [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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to