I have some users reporting occasional Red Overlays on a Historical Page. I have noticed I get these query strings that hang as Active Queries on my Database Status Page.
Is there anyway I can turn on some verbose logging and figure out what all those ?'s mean. Maybe through some advanced Logging I can figure out which Python script is doing this crazy query?(I inherited this application and have found some other bugs)
If I jump between two “Runs” of Historical my Easy Chart Populates and Table View populates but this Query hangs as Active even though the Page appears to render. This leads me to believe that some some non-essential code is executing, because Page appears OK but I have a Hung Query. I can eventually Fault the DB if I jump between too many Historical Runs and consume all 8 Connections.
Query: SELECT “tagid”,“intvalue”,“floatvalue”,“stringvalue”,“datevalue”,“t_stamp”,“dataintegrity” FROM sqlt_data_21_2018_08 WHERE “t_stamp”>=? and “t_stamp”<=? and (“tagid”=? OR “tagid”=? OR “tagid”=? OR …(see photo for rest)