Delete an unnamed query

From PTAGISWiki

A user created a query without a name and cannot delete it.

• I used the SREE admin console to delete the query but it still appears in the PTAGIS My Queries page.
• I deleted the file in ptagis-1.0/web/sree/WEB-INF/classes/templates (steveb__1.srt)
• I deleted the output file from the query: ptagis-1.0/cvswd/steveb/_1.csv.zip
• I deleted the entry for _1.csv.zip from file.xml
• grepping for __1.srt *xml shows that it still exists in repository.xml
• I can't vi repository.xml because there is a line too long, but vi works on linux
• I copy repository.xml to snapper, make the edit, and copy it back

But it is still visible from My Queries!

I restarted the SREE webapp from the SREE admin console and still the blank query is visible.

The My Queries interface only shows 2 queries, the blank one and one normal one. The SREE admin interface shows about 50 queries for this user.

I deleted all but the good query.

It took a very long time and then logged out of the SREE admin console. Then I couldn't log back in to the admin console.

After several minutes, I saw some replets being deleted in the sree.log file. Then my log in to the admin console succeeded. And all there were still about 50 replets for this user.

Each second, there is a "waiting for locked file" in sree.log and schedule.log

Deleted a batch of about 20 through the admin console. Lots more "waiting for locked file" but after a minute or two, it actually deleted the replets.

After deleting all batches, I got the admin console list of replets down to a single replet.

The My Queries interface still showed the bogus query.

Next I'll try redploying the sree webapp, but I'll have to wait until it isn't so busy.

I did a full restart of weblogic and redeployed all web apps, including SREE. But the null query is still there.

Cleanup of queries for rday

I tried to delete a lot of my old queries to make it easier to identify where the the list of queries comes from.

When I tried deleting all but a few of my queries through the My Queries interface, I got this response:

Successfully deleted 2 query(s).
Failed to delete 24 query(s).
Received the following error messages.
Failed to delete the query. There is no such query (called "JLH 2003" for user "rday" and datasource_id 2).
Failed to delete the query. There is no such query (called "YINN" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "YINN reg tags" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "bravenewworld" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "carter sql error" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "cle elum" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "clee tagging" for user "rday" and datasource_id 2).
Failed to delete the query. There is no such query (called "coil and rkm data types" for user "rday" and datasource_id 1).
Failed to delete the query. There is no such query (called "copy of ICH March 2006" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "count tags by release site all years" for user "rday" and datasource_id 2).
Failed to delete the query. There is no such query (called "ddt 2003" for user "rday" and datasource_id 2).
Failed to delete the query. There is no such query (called "ddt 2003 recap" for user "rday" and datasource_id 6).
Failed to delete the query. There is no such query (called "fall chinook 2005" for user "rday" and datasource_id 2).
Failed to delete the query. There is no such query (called "migration year and HUC" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "prosser 1 week" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "recap test" for user "rday" and datasource_id 4).
Failed to delete the query. There is no such query (called "release date and HUC" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "sample reg tags query" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "sulivan pge" for user "rday" and datasource_id 1).
Failed to delete the query. There is no such query (called "tagtest" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "test for andy" for user "rday" and datasource_id 2).
Failed to delete the query. There is no such query (called "test query on bay" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "tudor" for user "rday" and datasource_id 3).
Failed to delete the query. There is no such query (called "yanke test" for user "rday" and datasource_id 2).

But it successfully removed the entries from My Queries. Now I only have 3 queries in my list.

looking at the source

It appears that the jsp code at qb/queryList.jsp makes some references to cache. Hopefully it will eventually decide the cache is stale and reload and thus clear out the empty query.