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: TestUpload failures #60388

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

x/perf/storage/app: TestUpload failures #60388

gopherbot opened this issue May 24, 2023 · 17 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 == "TestUpload"

Issue created automatically to collect these failures.

Example (log):

2023/05/24 04:25:25 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:25:25 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 04:25:25 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 04:25:25 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 04:25:25 query: q="label0:0 label0:5" err=EOF
2023/05/24 04:25:25 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:25:25 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:25:25 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:25:25 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:25:25 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:25:25 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— 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
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-ppc64le-power9osu perf@d343f639 go@5b93af7f x/perf/storage/app.TestUpload (log) 
2023/05/24 04:25:25 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:25:25 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 04:25:25 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 04:25:25 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 04:25:25 query: q="label0:0 label0:5" err=EOF
2023/05/24 04:25:25 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:25:25 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:25:25 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:25:25 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:25:25 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:25:25 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:25:25 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@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 == "TestUpload"
2023-04-27 22:15 freebsd-amd64-race perf@d343f639 go@c7f0a8c4 x/perf/storage/app.TestUpload (log) 
2023/05/24 13:56:29 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 13:56:29 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 13:56:29 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 13:56:29 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 13:56:29 query: q="label0:0 label0:5" err=EOF
2023/05/24 13:56:29 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 13:56:29 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 13:56:29 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 13:56:29 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 13:56:29 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 13:56:29 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 13:56:29 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 windows-amd64-longtest perf@d343f639 go@227e7126 x/perf/storage/app.TestUpload (log) 
2023/05/24 14:21:44 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 14:21:44 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 14:21:44 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 14:21:44 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 14:21:44 query: q="label0:0 label0:5" err=EOF
2023/05/24 14:21:44 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 14:21:44 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 14:21:44 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:21:44 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:21:44 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:21:44 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:21:44 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-amd64-sid perf@d343f639 go@ac17bb6f x/perf/storage/app.TestUpload (log) 
2023/05/24 16:03:29 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:03:29 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 16:03:29 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 16:03:29 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 16:03:29 query: q="label0:0 label0:5" err=EOF
2023/05/24 16:03:29 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 16:03:29 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 16:03:29 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:03:29 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:03:29 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:03:29 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:03:29 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 freebsd-amd64-race perf@d343f639 go@0adcc5ac x/perf/storage/app.TestUpload (log) 
2023/05/24 16:34:13 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:34:13 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 16:34:13 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 16:34:13 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 16:34:13 query: q="label0:0 label0:5" err=EOF
2023/05/24 16:34:13 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 16:34:13 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 16:34: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/24 16:34: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/24 16:34: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/24 16:34: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/24 16:34:13 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 dragonfly-amd64-622 perf@d343f639 go@067dd573 x/perf/storage/app.TestUpload (log) 
2023/05/24 17:23:12 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:23:12 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 17:23:12 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 17:23:12 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 17:23:12 query: q="label0:0 label0:5" err=EOF
2023/05/24 17:23:12 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 17:23:12 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 17:23: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/24 17:23: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/24 17:23: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/24 17:23: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/24 17:23:12 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 android-386-emu perf@d343f639 go@e3798efb x/perf/storage/app.TestUpload (log) 
2023/05/24 18:04:50 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:04:50 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 18:04:50 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 18:04:50 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 18:04:50 query: q="label0:0 label0:5" err=EOF
2023/05/24 18:04:50 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 18:04:50 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 18:04: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 18:04: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 18:04: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 18:04: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 18:04:51 context canceled
--- FAIL: TestUpload (0.02s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-amd64-race perf@d343f639 go@72bf8ace x/perf/storage/app.TestUpload (log) 
2023/05/24 18:22:38 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:22:38 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 18:22:38 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 18:22:38 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 18:22:38 query: q="label0:0 label0:5" err=EOF
2023/05/24 18:22:38 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 18:22:38 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 18:22:38 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:38 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:38 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:38 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:38 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023-04-27 22:15 windows-amd64-2016 perf@d343f639 go@e3798efb x/perf/storage/app.TestUpload (log) 
2023/05/24 17:52:42 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:52:42 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 17:52:42 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 17:52:42 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 17:52:42 query: q="label0:0 label0:5" err=EOF
2023/05/24 17:52:42 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 17:52:42 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 17:52: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 17:52: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 17:52: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 17:52: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 17:52:42 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-amd64-race perf@d343f639 go@2a8969cb x/perf/storage/app.TestUpload (log) 
2023/05/24 19:13:23 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:13:23 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 19:13:23 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 19:13:23 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 19:13:23 query: q="label0:0 label0:5" err=EOF
2023/05/24 19:13:23 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 19:13:23 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 19:13:23 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:13:23 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:13:23 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:13:23 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:13:23 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-amd64-race perf@d343f639 go@83dfe5cf x/perf/storage/app.TestUpload (log) 
2023/05/24 19:37:55 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:37:55 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 19:37:55 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 19:37:55 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 19:37:55 query: q="label0:0 label0:5" err=EOF
2023/05/24 19:37:55 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 19:37:55 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 19:37: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 19:37: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 19:37: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 19:37: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 19:37:55 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-386-buster perf@d343f639 go@1ddab592 x/perf/storage/app.TestUpload (log) 
2023/05/24 22:39:56 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:39:56 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 22:39:56 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 22:39:56 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 22:39:56 query: q="label0:0 label0:5" err=EOF
2023/05/24 22:39:56 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 22:39:56 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 22:39:56 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:39:56 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:39:56 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:39:56 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:39:56 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-386-longtest perf@d343f639 go@326df693 x/perf/storage/app.TestUpload (log) 
2023/05/24 22:56:38 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:56:38 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/24 22:56:38 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/24 22:56:38 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/24 22:56:38 query: q="label0:0 label0:5" err=EOF
2023/05/24 22:56:38 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 22:56:38 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 22:56:38 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:56:38 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:56:38 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:56:38 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:56:38 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 freebsd-amd64-race perf@d343f639 go@d4bd855c x/perf/storage/app.TestUpload (log) 
2023/05/25 00:25:18 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:25:18 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/25 00:25:18 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/25 00:25:18 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/25 00:25:18 query: q="label0:0 label0:5" err=EOF
2023/05/25 00:25:18 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 00:25:18 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 00:25: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/25 00:25: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/25 00:25: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/25 00:25: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/25 00:25:18 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-386-buster perf@d343f639 go@d5a05a05 x/perf/storage/app.TestUpload (log) 
2023/05/25 01:04:08 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 01:04:08 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/25 01:04:08 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/25 01:04:08 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/25 01:04:08 query: q="label0:0 label0:5" err=EOF
2023/05/25 01:04:08 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 01:04:08 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 01:04:08 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:04:08 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:04:08 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:04:08 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:04:08 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error
2023-04-27 22:15 linux-amd64-longtest-race perf@d343f639 go@d4bd855c x/perf/storage/app.TestUpload (log) 
2023/05/25 00:26:07 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:26:07 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/25 00:26:07 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/25 00:26:07 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/25 00:26:07 query: q="label0:0 label0:5" err=EOF
2023/05/25 00:26:07 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 00:26:07 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 00:26:07 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:26:07 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:26:07 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:26:07 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:26:07 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 windows-arm64-11 perf@d343f639 go@326df693 x/perf/storage/app.TestUpload (log) 
2023/05/25 04:44:09 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 04:44:09 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/25 04:44:09 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/25 04:44:09 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/25 04:44:09 query: q="label0:0 label0:5" err=EOF
2023/05/25 04:44:09 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 04:44:09 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 04:44:09 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 04:44:09 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 04:44:09 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 04:44:09 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 04:44:09 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 linux-amd64-race perf@d343f639 go@055c186f x/perf/storage/app.TestUpload (log) 
2023/05/25 13:08:47 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 13:08:47 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/25 13:08:47 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/25 13:08:47 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/25 13:08:47 query: q="label0:0 label0:5" err=EOF
2023/05/25 13:08:47 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 13:08:47 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 13:08:48 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 13:08:48 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 13:08:48 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 13:08:48 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 13:08:48 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 13:08:48 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 13:08:48 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 13:08: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/25 13:08: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/25 13:08: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/25 13:08: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/25 13:08:48 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/perf/storage/app" && test == "TestUpload"
2023-04-27 22:15 windows-amd64-race perf@d343f639 go@055c186f x/perf/storage/app.TestUpload (log) 
2023/05/25 13:09:11 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 13:09:11 query: q="label0:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "0"}}
2023/05/25 13:09:11 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label1", "0"}}
2023/05/25 13:09:11 query: q="label0:5 name:Name" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 INNER JOIN (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t1 USING (UploadID, RecordID) LEFT JOIN Records r USING (UploadID, RecordID)" []interface {}{"label0", "5", "name", "Name"}}
2023/05/25 13:09:11 query: q="label0:0 label0:5" err=EOF
2023/05/25 13:09:11 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 13:09:11 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 13:09:11 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 13:09:11 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 13:09:11 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 13:09:11 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 13:09:11 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— 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