0e7d9cb854ff492af1565a061fe0070a3f0f693e
braney
  Thu Dec 17 17:33:44 2020 -0800
add a flush tables after loading trackDb and hgFindSpec tables to
prevent an error with myisamchk saying that they are still open

diff --git src/hg/makeDb/hgFindSpec/hgFindSpec.c src/hg/makeDb/hgFindSpec/hgFindSpec.c
index 32d03eb..8014f5d 100644
--- src/hg/makeDb/hgFindSpec/hgFindSpec.c
+++ src/hg/makeDb/hgFindSpec/hgFindSpec.c
@@ -326,30 +326,31 @@
     sqlUpdate(conn, query);
 
     /* Load in settings fields. */
     for (hfs = hfsList; hfs != NULL; hfs = hfs->next)
 	{
 	if (hfs->settingsHash != NULL)
 	    {
 	    char *settings = settingsFromHash(hfs->settingsHash);
 	    updateBigTextField(conn, hgFindSpecName, "searchName",
 			       hfs->searchName, 
 			       "searchSettings", settings);
 	    freeMem(settings);
 	    }
 	}
 
+    sqlUpdate(conn, NOSQLINJ "flush tables");
     sqlDisconnect(&conn);
     if (verboseLevel() > 0)
 	printf("Loaded database %s\n", database);
     }
     unlink(tab);
 }
 
 void adjustTrackDbName(char *hgFindSpecName)
 /* Some hgFindSpec info is pulled from the trackDb table.  When the 
  * hgFindSpec name is hgFindSpec_$USER and the user's ~/.hg.conf file 
  * specifies trackDb_$USER, that works fine.  However, when the 
  * hgFindSpec name is just hgFindSpec (as for make alpha / make strict 
  * invocations), but ~/hg.conf says trackDb_$USER, they're inconsistent.
  * So to make a long story short -- circumvent the ~/.hg.conf!  */
 {