#1622 Hotfix for smolt
Closed: Fixed None Opened 14 years ago by mmcgrath.

= phenomenon =

Frequent Smolt Outages

= reason =

Poorly crafted queries

= Hotfix =
{{{
--- /usr/share/smolt/smoon/hardware/controllers/reports.py.orig 2009-08-21 18:28:58.000000000 +0000
+++ /usr/share/smolt/smoon/hardware/controllers/reports.py 2009-08-21 18:31:45.000000000 +0000
@@ -108,10 +108,10 @@

         # Select the host ID's that have our device ID (from description)
     hl = select([HostLink.host_link_id],
  • HostLink.device_id==d.c.id).alias('hl')
  • HostLink.device_id==d.c.id).limit(5000).alias('hl')
         # Select pub_uuids that match our host ID from device ID from desc)
    
    • profiles = select([Host.pub_uuid, Host.system, Host.vendor], Host.id == hl.c.host_link_id).limit(5000).execute().fetchall()
    • profiles = select([Host.pub_uuid, Host.system, Host.vendor], Host.id == hl.c.host_link_id).execute().fetchall()
      device = args
      return dict(found=found, profiles=profiles, device=device)
      }}}

this is now removed and smolt has been upgrade.

Login to comment on this ticket.

Metadata