Author: nunofsantos Date: 2008-12-11 17:16:42 -0500 (Thu, 11 Dec 2008) New Revision: 2987 Modified: mgmt/trunk/mint/python/mint/sql.py Log: remove 'select ... for update' from the expiration sql Modified: mgmt/trunk/mint/python/mint/sql.py =================================================================== --- mgmt/trunk/mint/python/mint/sql.py 2008-12-11 21:47:23 UTC (rev 2986) +++ mgmt/trunk/mint/python/mint/sql.py 2008-12-11 22:16:42 UTC (rev 2987) @@ -151,22 +151,16 @@ if table.endswith("_stats"): parent_table = table[0:table.find("_stats")] sql = """ - select * from %s - where qmf_update_time < now() - interval '%%(threshold)s seconds' - for update; delete from %s where qmf_update_time < now() - interval '%%(threshold)s seconds' - """ % (table, table) + """ % (table) if self.keepCurrStats: sql += " and id not in (select stats_curr_id from %s)" % (parent_table) else: sql = """ - select * from %s - where qmf_create_time < now() - interval '%%(threshold)s seconds' - for update; delete from %s where qmf_create_time < now() - interval '%%(threshold)s seconds' - """ % (table, table) + """ % (table) return sql class SqlGetBrokerRegistration(SqlOperation):