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 >> >> >> >> > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
