ec245098815310f5064a4f43174a458508a7571f
galt
  Sat May 30 02:05:07 2020 -0700
tweak input order of blatServers table

diff --git src/hg/utils/blatServersCheck/blatServersCheck.c src/hg/utils/blatServersCheck/blatServersCheck.c
index 6c2dc69..dab0a4f 100644
--- src/hg/utils/blatServersCheck/blatServersCheck.c
+++ src/hg/utils/blatServersCheck/blatServersCheck.c
@@ -288,31 +288,31 @@
 verbose(1, "Reading table %s\n", blatServersTableName);
 
 
 totalRows = sqlTableSize(conn, blatServersTableName);
 verbose(1,"totalRows=%d\n", totalRows);
 
 verbose(1,"\n");
 
 if (totalRows==0)
     {
     errAbort("table %s is empty!", blatServersTableName);
     }
 
 int errCount = 0;
 
-sqlSafef(query,sizeof(query), "select db, host, port, isTrans from %s", blatServersTableName);
+sqlSafef(query,sizeof(query), "select db, host, port, isTrans from %s order by db,port", blatServersTableName);
 sr = sqlGetResult(conn, query);
 while ((row = sqlNextRow(sr)) != NULL)
     {
     char *db      = row[0];
     char *host    = row[1];
     char *portStr = row[2];
     unsigned int port  = sqlUnsigned(portStr);
     unsigned int trans = sqlUnsigned(row[3]);
     boolean isTrans = (trans == 1);
 
     if (hostFilter && !sameString(hostFilter, host))
 	continue;   // skip
 
     int res = statusServer(host, portStr, isTrans, versionHash);
     int res2 = 0;