x/perf/storage/db: TestUpload failures

[gopherbot]

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

Issue created automatically to collect these failures.

Example (log):

2023/05/24 04:15:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:15:45 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:15:45 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:15:45 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:15:45 query: q="label0:0 label0:5" err=EOF
2023/05/24 04:15:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:15: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 04:15: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 04:15: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 04:15: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 04:15:45 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

[gopherbot]

Found new dashboard test flakes for:

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

2023-04-27 22:15 windows-amd64-race perf@d343f639 go@5b93af7f x/perf/storage/db.TestUpload (log)

2023/05/24 04:15:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:15:45 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:15:45 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:15:45 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:15:45 query: q="label0:0 label0:5" err=EOF
2023/05/24 04:15:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:15:45 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:15: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 04:15: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 04:15: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 04:15: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 04:15:45 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

[gopherbot]

Found new dashboard test flakes for:

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

2023-04-27 22:15 windows-amd64-race perf@d343f639 go@a6fb97b6 x/perf/storage/db.TestUpload (log)

2023/05/24 20:27:21 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 20:27:21 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 20:27:21 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 20:27:21 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 20:27:21 query: q="label0:0 label0:5" err=EOF
2023/05/24 20:27:21 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 20:27:21 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 20:27: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 20:27: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 20:27: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 20:27: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 20:27:21 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes

[gopherbot]

Found new dashboard test flakes for:

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

2023-04-27 22:15 linux-amd64-race perf@d343f639 go@cfe8b43b x/perf/storage/db.TestUpload (log)

2023/05/25 21:57:49 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 21:57:49 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 21:57:49 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 21:57:49 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 21:57:49 query: q="label0:0 label0:5" err=EOF
2023/05/25 21:57:49 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 21:57:49 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 21:57:49 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:57:49 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:57:49 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:57:49 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:57:49 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:83: post /upload: 500 Internal Server Error

— watchflakes