Modify/Delete datastore Index on google app engine

Question

My old web.xml was

<datastore-index kind="TBL" ancestor="false"> 
    <property name="Col1" direction="asc" /> 
    <property name="Col2" direction="desc" />
    <property name="Col3" direction="asc" />
    <property name="Col4" direction="asc" />
    <property name="Col5" direction="asc" />
    <property name="Col6" direction="asc" />
    <property name="Col7" direction="asc" />
    <property name="Col8" direction="asc" />                         
</datastore-index>  

My New web.xml is

<datastore-index kind="TBL" ancestor="false"> 
    <property name="Col1" direction="asc" /> 
    <property name="Col2" direction="desc" />
    <property name="Col3" direction="asc" />
    <property name="Col4" direction="asc" />
    <property name="Col5" direction="asc" />
    <property name="Col6" direction="desc" />
    <property name="Col7" direction="asc" />
    <property name="Col8" direction="asc" />                         
</datastore-index>  

Created index on server

TBL  
------------
Col2 ▲ , Col1 ▲ , Col6 ▼  
Col4 ▲ , Col1 ▲ , Col6 ▼  
Col5 ▲ , Col8 ▲ , Col1 ▲ , Col6 ▲ => I got error for this index
Col8 ▲ , Col1 ▲ , Col6 ▲   
Col1 ▲ , Col2 ▼ , Col3 ▲ , Col4 ▲ , Col5 ▲ , Col7 ▲ , Col8 ▲ 
Col1 ▲ , Col2 ▼ , Col3 ▲ , Col4 ▲ , Col5 ▲ , Col6 ▼ , Col7 ▲ , Col8 ▲ 
Col1 ▲ , Col7 ▲  
Col1 ▲ , Col6 ▲  
Col1 ▲ , Col6 ▼  

I am getting index not found error for 3rd index. I want to modify direction for col6 in all index and set it to "desc".

How can i do that? or how can i delete index?

Anybody?

Answer 1

You're looking for the vacuum_indexes command.

http://code.google.com/appengine/docs/python/tools/uploadinganapp.html#Deleting_Unused_Indexes

This will work for both Java and Python apps. In fact, Java's appcfg.sh does not yet support this at all, so you'll need the Python SDK if you're running a Java app.