Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

x/perf/storage/app: TestQuery failures #60380

Closed
gopherbot opened this issue May 24, 2023 · 25 comments
Closed

x/perf/storage/app: TestQuery failures #60380

gopherbot opened this issue May 24, 2023 · 25 comments
Labels
NeedsInvestigation Someone must examine and confirm this is a valid issue and not a duplicate of an existing one.
Milestone
Unreleased

Comments

@gopherbot
Copy link 

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"

Issue created automatically to collect these failures.

Example (log):

2023/05/24 04:08:35 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 04:08:35 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:08:35 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 04:08:35 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 04:08:35 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 04:08:35 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 04:08:35 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes
@gopherbot gopherbot added the NeedsInvestigation Someone must examine and confirm this is a valid issue and not a duplicate of an existing one. label May 24, 2023
@gopherbot gopherbot added this to the Unreleased milestone May 24, 2023
@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-2016 perf@d343f639 go@298fe517 x/perf/storage/app.TestQuery (log) 
2023/05/24 04:08:35 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 04:08:35 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:08:35 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:08:35 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 04:08:35 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 04:08:35 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 04:08:35 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 04:08:35 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@5b93af7f x/perf/storage/app.TestQuery (log) 
2023/05/24 04:16:55 context canceled
--- FAIL: TestQuery (0.07s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 04:16:55 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:16:55 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:16:55 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 04:16:55 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 04:16:55 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 04:16:55 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 04:16:55 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 linux-arm64-longtest perf@d343f639 go@220c396e x/perf/storage/app.TestQuery (log) 
2023/05/24 14:41:45 context canceled
--- FAIL: TestQuery (0.05s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 14:41:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 14:41:45 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 14:41:45 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 14:41:45 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 14:41:45 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 14:41:45 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 14:41:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 freebsd-amd64-13_0 perf@d343f639 go@d9fd19a7 x/perf/storage/app.TestQuery (log) 
2023/05/24 14:55:27 context canceled
--- FAIL: TestQuery (0.04s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 14:55:27 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 14:55:27 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 14:55:27 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 14:55:27 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 14:55:27 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 14:55:27 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 14:55:27 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@8c30460b x/perf/storage/app.TestQuery (log) 
2023/05/24 15:10:22 context canceled
--- FAIL: TestQuery (0.07s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 15:10:22 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 15:10:22 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 15:10:22 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 15:10:22 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 15:10:22 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 15:10:22 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 15:10:22 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-arm64-11 perf@d343f639 go@4042b900 x/perf/storage/app.TestQuery (log) 
2023/05/24 15:53:14 context canceled
--- FAIL: TestQuery (0.11s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 15:53:14 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 15:53:14 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 15:53:14 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 15:53:14 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 15:53:14 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 15:53:14 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 15:53:14 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 linux-amd64-longtest-race perf@d343f639 go@ac17bb6f x/perf/storage/app.TestQuery (log) 
2023/05/24 15:57:48 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 15:57:48 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 15:57:48 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 15:57:48 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 15:57:48 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 15:57:48 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 15:57:48 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 15:57:48 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 freebsd-amd64-13_0 perf@d343f639 go@42f387aa x/perf/storage/app.TestQuery (log) 
2023/05/24 17:00:05 context canceled
--- FAIL: TestQuery (0.05s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 17:00:05 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 17:00:05 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 17:00:05 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 17:00:05 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 17:00:05 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 17:00:05 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 17:00:05 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-race perf@d343f639 go@0adcc5ac x/perf/storage/app.TestQuery (log) 
2023/05/24 16:31:50 context canceled
--- FAIL: TestQuery (0.22s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 16:31:50 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 16:31:50 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 16:31:50 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 16:31:50 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 16:31:50 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 16:31:50 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 16:31:50 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 linux-amd64-longtest-race perf@d343f639 go@067dd573 x/perf/storage/app.TestQuery (log) 
2023/05/24 17:27:18 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 17:27:18 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 17:27:18 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 17:27:18 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 17:27:18 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 17:27:18 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 17:27:18 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 17:27:18 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 freebsd-amd64-race perf@d343f639 go@e3798efb x/perf/storage/app.TestQuery (log) 
2023/05/24 17:53:16 context canceled
--- FAIL: TestQuery (0.20s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 17:53:17 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 17:53:17 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 17:53:17 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 17:53:17 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 17:53:17 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 17:53:17 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 17:53:17 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 freebsd-386-12_3 perf@d343f639 go@e3798efb x/perf/storage/app.TestQuery (log) 
2023/05/24 17:53:21 context canceled
--- FAIL: TestQuery (0.06s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 17:53:21 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 17:53:21 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 17:53:21 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 17:53:21 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 17:53:21 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 17:53:21 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 17:53:21 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-04-27 22:15 windows-amd64-2016 perf@d343f639 go@72bf8ace x/perf/storage/app.TestQuery (log) 
2023/05/24 18:22:06 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 18:22:06 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 18:22:06 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 18:22:06 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 18:22:06 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 18:22:06 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 18:22:06 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 18:22:06 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 openbsd-amd64-72 perf@d343f639 go@220c396e x/perf/storage/app.TestQuery (log) 
2023/05/24 07:46:26 context canceled
--- FAIL: TestQuery (0.12s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 07:46:26 context canceled
2023-04-27 22:15 openbsd-amd64-72 perf@d343f639 go@227e7126 x/perf/storage/app.TestQuery (log) 
2023/05/24 07:22:48 context canceled
--- FAIL: TestQuery (0.13s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 07:22:48 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 07:22:48 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 07:22:48 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 07:22:48 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 07:22:48 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 07:22:48 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 07:22:48 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-04-27 22:15 openbsd-amd64-72 perf@d343f639 go@c7f0a8c4 x/perf/storage/app.TestQuery (log) 
2023/05/24 06:57:46 context canceled
--- FAIL: TestQuery (0.12s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 06:57:46 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 06:57:46 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 06:57:46 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 06:57:46 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 06:57:46 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 06:57:46 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 06:57:46 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-04-27 22:15 openbsd-amd64-72 perf@d343f639 go@c6fd0c22 x/perf/storage/app.TestQuery (log) 
2023/05/23 21:28:13 context canceled
--- FAIL: TestQuery (0.12s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/23 21:28:13 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/23 21:28:13 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/23 21:28:13 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/23 21:28:13 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/23 21:28:13 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/23 21:28:13 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/23 21:28:13 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@2a8969cb x/perf/storage/app.TestQuery (log) 
2023/05/24 19:11:43 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 19:11:43 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 19:11:43 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 19:11:43 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 19:11:43 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 19:11:43 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 19:11:43 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 19:11:43 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 linux-amd64-longtest-race perf@d343f639 go@9b57b335 x/perf/storage/app.TestQuery (log) 
2023/05/24 21:05:37 context canceled
--- FAIL: TestQuery (0.18s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 21:05:37 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 21:05:37 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 21:05:37 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 21:05:37 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 21:05:37 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 21:05:37 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 21:05:37 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-race perf@d343f639 go@9b57b335 x/perf/storage/app.TestQuery (log) 
2023/05/24 21:07:13 context canceled
--- FAIL: TestQuery (0.27s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 21:07:14 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 21:07:14 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 21:07:14 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 21:07:14 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 21:07:14 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 21:07:14 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 21:07:14 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 linux-amd64-race perf@d343f639 go@c5ba9d22 x/perf/storage/app.TestQuery (log) 
2023/05/24 22:06:19 context canceled
--- FAIL: TestQuery (0.14s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 22:06:19 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 22:06:19 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 22:06:19 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 22:06:19 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 22:06:19 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 22:06:19 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 22:06:19 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@c5ba9d22 x/perf/storage/app.TestQuery (log) 
2023/05/24 22:06:42 context canceled
--- FAIL: TestQuery (0.07s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 22:06:42 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 22:06:42 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 22:06:42 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 22:06:42 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 22:06:42 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 22:06:42 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 22:06:42 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@05cc9e55 x/perf/storage/app.TestQuery (log) 
2023/05/24 21:58:03 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 21:58:03 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 21:58:03 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 21:58:03 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 21:58:03 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 21:58:03 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 21:58:03 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 21:58:03 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 freebsd-amd64-race perf@d343f639 go@a965318a x/perf/storage/app.TestQuery (log) 
2023/05/24 23:28:06 context canceled
--- FAIL: TestQuery (0.19s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/24 23:28:06 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 23:28:06 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 23:28:06 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/24 23:28:06 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/24 23:28:06 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/24 23:28:06 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/24 23:28:06 Close("uploads/20230524.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 linux-amd64-race perf@d343f639 go@2a4f4fc5 x/perf/storage/app.TestQuery (log) 
2023/05/25 00:11:05 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 00:11:05 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 00:11:05 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 00:11:05 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 00:11:05 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 00:11:05 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 00:11:05 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 00:11:05 Close("uploads/20230525.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@558301a5 x/perf/storage/app.TestQuery (log) 
2023/05/25 00:56:12 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 00:56:12 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 00:56:12 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 00:56:12 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 00:56:12 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 00:56:12 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 00:56:12 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 00:56:12 Close("uploads/20230525.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-arm64-11 perf@d343f639 go@6f7824f7 x/perf/storage/app.TestQuery (log) 
2023/05/25 01:27:27 context canceled
--- FAIL: TestQuery (0.12s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 01:27:27 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 01:27:27 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 01:27:27 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 01:27:27 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 01:27:27 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 01:27:27 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 01:27:27 Close("uploads/20230525.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-2016 perf@d343f639 go@f4086d36 x/perf/storage/app.TestQuery (log) 
2023/05/25 15:45:57 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 15:45:57 context canceled

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 linux-amd64-race perf@d343f639 go@a5be6dbb x/perf/storage/app.TestQuery (log) 
2023/05/25 17:16:41 context canceled
--- FAIL: TestQuery (0.23s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 17:16:41 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 17:16:41 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 17:16:41 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 17:16:41 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 17:16:41 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 17:16:41 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 17:16:41 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-04-27 22:15 netbsd-386-9_3 perf@d343f639 go@a5be6dbb x/perf/storage/app.TestQuery (log) 
2023/05/25 17:13:34 context canceled
--- FAIL: TestQuery (0.05s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 17:13:34 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 17:13:34 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 17:13:34 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 17:13:34 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 17:13:34 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 17:13:34 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 17:13:34 Close("uploads/20230525.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@82d5ebce x/perf/storage/app.TestQuery (log) 
2023/05/25 18:02:35 context canceled
--- FAIL: TestQuery (0.10s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 18:02:35 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 18:02:35 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 18:02:35 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 18:02:35 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 18:02:35 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 18:02:35 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 18:02:35 Close("uploads/20230525.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 dragonfly-amd64-622 perf@d343f639 go@f9d114d0 x/perf/storage/app.TestQuery (log) 
2023/05/25 21:16:32 context canceled
--- FAIL: TestQuery (0.07s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 21:16:32 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 21:16:32 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 21:16:32 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 21:16:32 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 21:16:32 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 21:16:32 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 21:16:32 Close("uploads/20230525.1/0.txt") took 0.00 seconds

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestQuery"
2023-04-27 22:15 windows-amd64-2016 perf@d343f639 go@ee6b9dd4 x/perf/storage/app.TestQuery (log) 
2023/05/25 21:52:19 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023/05/25 21:52:19 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 21:52:19 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 21:52:19 query: q="" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, (SELECT COUNT(*) FROM Records r WHERE r.UploadID = u.UploadID) AS rCount FROM Uploads u WHERE rCount > 0 ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000) j" []interface {}(nil)}
2023/05/25 21:52:19 query: q="j:5" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"j", "5"}}
2023/05/25 21:52:19 query: q="i:5" sql={"SELECT j.UploadID, rCount, (SELECT l0.Value FROM RecordLabels l0 WHERE l0.UploadID = j.UploadID AND Name = ? LIMIT 1) FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"i", "i", "5"}}
2023/05/25 21:52:19 query: q="not:found" sql={"SELECT j.UploadID, rCount FROM (SELECT UploadID, COUNT(*) as rCount FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID) GROUP BY UploadID) j LEFT JOIN Uploads u USING (UploadID) ORDER BY u.Day DESC, u.Seq DESC, u.UploadID DESC LIMIT 1000" []interface {}{"not", "found"}}
2023/05/25 21:52:19 Close("uploads/20230525.1/0.txt") took 0.00 seconds

— watchflakes

@bcmills bcmills closed this as completed Jun 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
NeedsInvestigation Someone must examine and confirm this is a valid issue and not a duplicate of an existing one.
Projects
Test Flakes
Status: Done
Milestone
Unreleased
Development

No branches or pull requests
2 participants
@bcmills @gopherbot