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/build/perfdata, x/perf/storage: test failures #60384

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

x/build/perfdata, x/perf/storage: test failures #60384

gopherbot opened this issue May 24, 2023 · 13 comments
Labels
Builders x/build issues (builders, bots, dashboards) 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

gopherbot commented May 24, 2023 •
edited by prattmic 

#!watchflakes
post <- pkg ~ `^golang.org/x/build/perfdata` || pkg ~ `^golang.org/x/perf/storage`

Issue created automatically to collect these failures.

Example (log):

--- FAIL: TestNewUpload (0.00s)
    db_test.go:181: NewUpload: context canceled

— 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/build/perfdata/db" && test == "TestNewUpload"
2023-05-23 16:16 linux-amd64-race build@26b6615d go@5b93af7f x/build/perfdata/db.TestNewUpload (log) 
--- FAIL: TestNewUpload (0.00s)
    db_test.go:181: NewUpload: context canceled

— watchflakes

@gopherbot gopherbot added the Builders x/build issues (builders, bots, dashboards) 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/build/perfdata/db" && test == "TestNewUpload"
2023-05-23 16:16 linux-amd64-race build@26b6615d go@bfdd3bf3 x/build/perfdata/db.TestNewUpload (log) 
--- FAIL: TestNewUpload (0.00s)
    db_test.go:181: NewUpload: context canceled

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/build/perfdata/db" && test == "TestNewUpload"
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@83dfe5cf x/build/perfdata/db.TestNewUpload (log) 
--- FAIL: TestNewUpload (0.00s)
    db_test.go:181: NewUpload: context canceled

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/build/perfdata/db" && test == "TestNewUpload"
2023-05-23 16:16 linux-amd64-race build@26b6615d go@326df693 x/build/perfdata/db.TestNewUpload (log) 
--- FAIL: TestNewUpload (0.00s)
    db_test.go:181: NewUpload: context canceled

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/build/perfdata/db" && test == "TestNewUpload"
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@08458804 x/build/perfdata/db.TestNewUpload (log) 
--- FAIL: TestNewUpload (0.00s)
    db_test.go:181: NewUpload: context canceled

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg == "golang.org/x/build/perfdata/db" && test == "TestNewUpload"
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@558301a5 x/build/perfdata/db.TestNewUpload (log) 
--- FAIL: TestNewUpload (0.00s)
    db_test.go:181: NewUpload: context canceled

— watchflakes

@bcmills bcmills changed the title x/build/perfdata/db: TestNewUpload failures x/build/perfdata: test failures Jun 13, 2023
@bcmills bcmills mentioned this issue Jun 13, 2023
Closed
@gopherbot

This comment was marked as resolved.

Sign in to view
@bcmills bcmills mentioned this issue Jun 14, 2023
Closed
@prattmic prattmic changed the title x/build/perfdata: test failures x/build/perfdata / x/perf/storage: test failures Jun 14, 2023
@prattmic prattmic changed the title x/build/perfdata / x/perf/storage: test failures x/build/perfdata, x/perf/storage: test failures Jun 14, 2023
@prattmic
Copy link
Member

These are very strange to me. A bunch of failures on different builders at the exact same time implies some kind of outage with a networked service, but these tests shouldn't be using any networked services. They run an in-process server using an in-memory sqlite db.

The "context cancelled" error is strange too. I don't think we do much special with context, and the times seem too short to be a timeout.

cc @mknyszek

@bcmills
Copy link
Contributor

bcmills commented Jun 14, 2023

The end of the failures seems to correspond to https://go.dev/cl/498398.

That suggests that this may have been a regression caused by https://go.dev/cl/497675.

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg ~ `^golang.org/x/build/perfdata` || pkg ~ `^golang.org/x/perf/storage`
2023-05-23 16:16 darwin-arm64-12 build@26b6615d go@220c396e x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 linux-amd64 build@26b6615d go@ac17bb6f x/build/perfdata/app.TestUploads (log) 
2023/05/24 15:57:43 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 15:57:43 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 15:57:43 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 15:57:43 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 15:57:43 query: q="label0:0 label0:5" err=EOF
2023/05/24 15:57:43 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 15:57:43 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64 build@26b6615d go@8c30460b x/build/perfdata/db.TestReplaceUpload (log) 
--- FAIL: TestReplaceUpload (0.00s)
    db_test.go:106: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest build@26b6615d go@83dfe5cf x/build/perfdata/app.TestUploads (log) 
2023/05/24 19:39:58 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:39:58 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:39:58 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:39:58 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:39:58 query: q="label0:0 label0:5" err=EOF
2023/05/24 19:39:58 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 19:39:58 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@f0e356a0 x/build/perfdata/app.TestUpload (log) 
2023/05/25 22:08:44 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 22:08: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/25 22:08: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/25 22:08: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/25 22:08:44 query: q="label0:0 label0:5" err=EOF
2023/05/25 22:08:44 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 22:08:44 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 22:08: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/25 22:08: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/25 22:08: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/25 22:08: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/25 22:08:44 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@ee6b9dd4 x/build/perfdata/db.TestQuery (log) 
2023/05/25 21:50:20 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 21:50:20 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 21:50:20 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 21:50:20 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:50:20 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:50:20 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:50:20 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:50:20 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@ee6b9dd4 x/build/perfdata/db.TestQuery (log) 
--- FAIL: TestQuery (0.00s)
    db_test.go:248: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@ee6b9dd4 x/build/perfdata/db.TestListUploads (log) 
--- FAIL: TestListUploads (0.00s)
    db_test.go:354: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@11bb2922 x/build/perfdata/app.TestUploads (log) 
2023/05/25 19:27:41 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 19:27:41 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 19:27:41 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 19:27:41 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 19:27:41 query: q="label0:0 label0:5" err=EOF
2023/05/25 19:27:41 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 19:27:41 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@82d5ebce x/build/perfdata/app.TestQuery (log) 
2023/05/25 18:00:20 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 18:00:20 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 18:00:20 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 18:00:20 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:00: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/25 18:00: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/25 18:00: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/25 18:00:21 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@aa99c4d2 x/build/perfdata/app.TestQuery (log) 
2023/05/25 17:46:27 context canceled
--- FAIL: TestQuery (0.17s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 17:46:27 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 17:46:27 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 17:46: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 17:46: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 17:46: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 17:46: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 17:46:27 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@a5be6dbb x/build/perfdata/db.TestReplaceUpload (log) 
--- FAIL: TestReplaceUpload (0.00s)
    db_test.go:106: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@d23669db x/build/perfdata/db.TestQuery (log) 
--- FAIL: TestQuery (0.00s)
    db_test.go:248: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@295c237b x/build/perfdata/db.TestListUploads (log) 
--- FAIL: TestListUploads (0.00s)
    db_test.go:354: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@9b57b335 x/build/perfdata/app.TestUploads (log) 
2023/05/24 21:07:18 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:07: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/24 21:07: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/24 21:07: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/24 21:07:18 query: q="label0:0 label0:5" err=EOF
2023/05/24 21:07:18 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 21:07:18 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@a7cb7df4 x/build/perfdata/app.TestQuery (log) 
2023/05/24 20:36:01 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 20:36:01 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 20:36:01 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 20:36:01 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:36:01 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:36:01 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:36:01 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:36:01 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@2a8969cb x/build/perfdata/app.TestQuery (log) 
2023/05/24 19:09:23 context canceled
--- FAIL: TestQuery (0.14s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 19:09:23 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 19:09:23 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 19:09: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:09: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:09: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:09: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:09:23 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@5de20f0f x/build/perfdata/db.TestListUploads (log) 
--- FAIL: TestListUploads (0.00s)
    db_test.go:354: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@72bf8ace x/build/perfdata/app.TestUpload (log) 
2023/05/24 18:21:58 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:21:58 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:21:58 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:21:58 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:21:58 query: q="label0:0 label0:5" err=EOF
2023/05/24 18:21:58 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 18:21:58 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 18:21:58 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:21:58 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:21:58 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:21:58 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:21:58 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@8c30460b x/build/perfdata/app.TestQuery (log) 
2023/05/24 15:10:04 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 15:10:04 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 15:10:04 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 15:10:04 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:04 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:04 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:04 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:04 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@220c396e x/build/perfdata/db.TestQuery (log) 
--- FAIL: TestQuery (0.00s)
    db_test.go:248: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-longtest-race build@26b6615d go@c6fd0c22 x/build/perfdata/db.TestQuery (log) 
--- FAIL: TestQuery (0.00s)
    db_test.go:248: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-race build@26b6615d go@6f7824f7 x/build/perfdata/db.TestQuery (log) 
--- FAIL: TestQuery (0.00s)
    db_test.go:248: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-race build@26b6615d go@558301a5 x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-race build@26b6615d go@04c62893 x/build/perfdata/app.TestUpload (log) 
2023/05/25 00:14:16 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:14:16 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:14:16 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:14:16 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:14:16 query: q="label0:0 label0:5" err=EOF
2023/05/25 00:14:16 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 00:14:16 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 00:14:16 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:14:16 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:14:16 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:14:16 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:14:16 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023-05-23 16:16 linux-amd64-race build@26b6615d go@9b414180 x/build/perfdata/app.TestUpload (log) 
2023/05/24 22:13:22 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:13:22 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:13:22 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:13:22 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:13:22 query: q="label0:0 label0:5" err=EOF
2023/05/24 22:13:22 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 22:13:22 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 22:13: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 22:13: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 22:13: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 22:13: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 22:13:22 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023-05-23 16:16 linux-amd64-race build@26b6615d go@295c237b x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-race build@26b6615d go@85e84a49 x/build/perfdata/app.TestQuery (log) 
2023/05/24 21:26:52 context canceled
--- FAIL: TestQuery (0.18s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 21:26:52 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 21:26:52 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 21:26:52 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:26:52 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:26:52 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:26:52 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:26:52 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-race build@26b6615d go@a6fb97b6 x/build/perfdata/app.TestUpload (log) 
2023/05/24 20:27:16 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 20:27:16 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:16 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:16 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:16 query: q="label0:0 label0:5" err=EOF
2023/05/24 20:27:16 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 20:27:16 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 20:27:16 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:16 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:16 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:16 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:16 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023-05-23 16:16 linux-amd64-race build@26b6615d go@83dfe5cf x/build/perfdata/app.TestUploads (log) 
2023/05/24 19:43:13 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:43: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 19:43: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 19:43: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 19:43:13 query: q="label0:0 label0:5" err=EOF
2023/05/24 19:43:13 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 19:43:13 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-race build@26b6615d go@5de20f0f x/build/perfdata/db.TestQuery (log) 
--- FAIL: TestQuery (0.00s)
    db_test.go:248: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-race build@26b6615d go@42f387aa x/build/perfdata/app.TestQuery (log) 
2023/05/24 17:02:09 context canceled
--- FAIL: TestQuery (0.16s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 17:02:09 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 17:02:09 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 17:02: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/24 17:02: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
(... long comment truncated ...)

— watchflakes

@mknyszek
Copy link
Contributor

I agree with Bryan's assessment. Closing optimistically.

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg ~ `^golang.org/x/build/perfdata` || pkg ~ `^golang.org/x/perf/storage`
2023-05-23 16:16 linux-amd64-race build@26b6615d go@ac17bb6f x/build/perfdata/app.TestUploads (log) 
2023/05/24 16:04:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:04: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 16:04: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 16:04: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 16:04:45 query: q="label0:0 label0:5" err=EOF
2023/05/24 16:04:45 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 16:04:45 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-race build@26b6615d go@c7f0a8c4 x/build/perfdata/app.TestQuery (log) 
2023/05/24 13:57:51 context canceled
--- FAIL: TestQuery (0.18s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 13:57:52 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 13:57:52 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 13:57:52 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:57:52 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:57:52 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:57:52 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:57:52 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 linux-amd64-race build@26b6615d go@298fe517 x/build/perfdata/db.TestReplaceUpload (log) 
--- FAIL: TestReplaceUpload (0.00s)
    db_test.go:106: NewUpload: context canceled
2023-05-23 16:16 linux-amd64-race build@26b6615d go@298fe517 x/build/perfdata/db.TestListUploads (log) 
--- FAIL: TestListUploads (0.00s)
    db_test.go:354: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@789701e9 x/build/perfdata/app.TestQuery (log) 
2023/05/25 18:45:49 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 18:45:49 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 18:45:49 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 18:45: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 18:45: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 18:45: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 18:45: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 18:45:49 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@a5be6dbb x/build/perfdata/app.TestQuery (log) 
2023/05/25 17:16:59 context canceled
--- FAIL: TestQuery (0.07s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 17:16:59 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 17:16:59 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 17:16:59 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:59 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:59 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:59 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:59 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@6f7824f7 x/build/perfdata/app.TestQuery (log) 
2023/05/25 01:11:52 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 01:11:52 context canceled
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@6f7824f7 x/build/perfdata/app.TestUploads (log) 
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 01:11:52 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@326df693 x/build/perfdata/db.TestUploads (log) 
2023/05/24 22:57:47 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:57: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/24 22:57: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/24 22:57: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/24 22:57:47 query: q="label0:0 label0:5" err=EOF
2023/05/24 22:57:47 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 22:57:47 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@326df693 x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@c5ba9d22 x/build/perfdata/app.TestQuery (log) 
2023/05/24 22:05:51 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 22:05:51 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 22:05:51 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 22:05:51 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:05:51 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:05:51 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:05:51 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:05:51 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@85e84a49 x/build/perfdata/app.TestUploads (log) 
2023/05/24 21:27:43 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:27:43 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 21:27:43 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 21:27:43 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 21:27:43 query: q="label0:0 label0:5" err=EOF
2023/05/24 21:27:43 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 21:27:43 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@9b57b335 x/build/perfdata/app.TestQuery (log) 
2023/05/24 21:07:00 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 21:07:00 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 21:07:00 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 21:07:00 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:00 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:00 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:00 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:00 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@0adcc5ac x/build/perfdata/app.TestQuery (log) 
2023/05/24 16:33:55 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 16:33:55 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 16:33:55 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 16:33: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 16:33: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 16:33: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 16:33: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 16:33:55 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@ac17bb6f x/build/perfdata/db.TestListUploads (log) 
--- FAIL: TestListUploads (0.00s)
    db_test.go:354: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@220c396e x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@5b93af7f x/build/perfdata/app.TestQuery (log) 
2023/05/24 04:16:27 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 04:16:27 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:16:27 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:16: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 04:16: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 04:16: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 04:16: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 04:16:27 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-2016 build@26b6615d go@298fe517 x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@f9d114d0 x/build/perfdata/app.TestQuery (log) 
2023/05/25 21:17:46 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 21:17:46 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 21:17:46 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 21:17: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/25 21:17: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/25 21:17: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/25 21:17: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/25 21:17:46 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@11bb2922 x/build/perfdata/app.TestUploads (log) 
2023/05/25 19:33:17 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 19:33:17 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 19:33:17 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 19:33:17 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 19:33:17 query: q="label0:0 label0:5" err=EOF
2023/05/25 19:33:17 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 19:33:17 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@82d5ebce x/build/perfdata/app.TestQuery (log) 
2023/05/25 18:00:39 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 18:00:39 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 18:00:39 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 18:00:39 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:00:39 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:00:39 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:00:39 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:00:39 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@aa99c4d2 x/build/perfdata/app.TestUpload (log) 
2023/05/25 17:47:05 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 17:47:05 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 17:47:05 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 17:47:05 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 17:47:05 query: q="label0:0 label0:5" err=EOF
2023/05/25 17:47:05 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 17:47:05 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 17:47: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 17:47: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 17:47: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 17:47: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 17:47:05 context canceled
--- FAIL: TestUpload (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@d5a05a05 x/build/perfdata/app.TestQuery (log) 
2023/05/25 01:06:12 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/25 01:06:12 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.2/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.3/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.4/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.5/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.6/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.7/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.8/0.txt") took 0.00 seconds
2023/05/25 01:06:12 Close("uploads/20230525.9/0.txt") took 0.00 seconds
2023/05/25 01:06: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 01:06: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 01:06: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 01:06: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 01:06:12 Close("uploads/20230525.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@558301a5 x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@08458804 x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@a965318a x/build/perfdata/app.TestUploads (log) 
2023/05/24 23:25:06 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 23:25:06 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 23:25:06 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 23:25:06 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 23:25:06 query: q="label0:0 label0:5" err=EOF
2023/05/24 23:25:06 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 23:25:06 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@05cc9e55 x/build/perfdata/db.TestUploadIDs (log) 
--- FAIL: TestUploadIDs (0.00s)
    db_test.go:60: NewUpload: context canceled
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@eea26e8e x/build/perfdata/app.TestQuery (log) 
2023/05/24 21:35:36 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 21:35:36 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 21:35:36 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 21:35:36 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:35:36 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:35:36 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:35:36 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:35:36 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@83dfe5cf x/build/perfdata/app.TestQuery (log) 
2023/05/24 19:40:46 context canceled
--- FAIL: TestQuery (0.10s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 19:40:46 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 19:40:46 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 19:40: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 19:40: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 19:40: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 19:40: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 19:40:46 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@5de20f0f x/build/perfdata/app.TestQuery (log) 
2023/05/24 18:59:22 context canceled
--- FAIL: TestQuery (0.08s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 18:59:22 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 18:59:22 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 18:59: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 18:59: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 18:59: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 18:59: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 18:59:22 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@42f387aa x/build/perfdata/app.TestUpload (log) 
2023/05/24 16:59:10 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 16:59:10 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:59:10 query: q="label1:0" sql={"SELECT r.Content FROM (SELECT UploadID, RecordID FROM RecordLabels WHERE Name = ? AND Value = ?) t0 LEFT JOIN Records r USING (
(... long comment truncated ...)

— watchflakes

@gopherbot
Copy link
Author

Found new dashboard test flakes for:

#!watchflakes
post <- pkg ~ `^golang.org/x/build/perfdata` || pkg ~ `^golang.org/x/perf/storage`
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@d9fd19a7 x/build/perfdata/app.TestUploads (log) 
2023/05/24 14:51:58 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 14:51:58 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:51:58 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:51:58 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:51:58 query: q="label0:0 label0:5" err=EOF
2023/05/24 14:51:58 context canceled
--- FAIL: TestUploads (0.00s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 14:51:58 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@220c396e x/build/perfdata/app.TestQuery (log) 
2023/05/24 14:46:51 context canceled
--- FAIL: TestQuery (0.09s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 14:46:51 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 14:46:51 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 14:46:51 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:46:51 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:46:51 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:46:51 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:46:51 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@c6fd0c22 x/build/perfdata/app.TestQuery (log) 
2023/05/24 04:26:18 context canceled
--- FAIL: TestQuery (0.07s)
    upload_test.go:84: post /upload: 500 Internal Server Error
2023/05/24 04:26:18 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.2/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.3/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.4/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.5/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.6/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.7/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.8/0.txt") took 0.00 seconds
2023/05/24 04:26:18 Close("uploads/20230524.9/0.txt") took 0.00 seconds
2023/05/24 04:26: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 04:26: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 04:26: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 04:26: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 04:26:18 Close("uploads/20230524.1/0.txt") took 0.00 seconds
2023-05-23 16:16 windows-amd64-longtest build@26b6615d go@298fe517 x/build/perfdata/db.TestQuery (log) 
--- FAIL: TestQuery (0.00s)
    db_test.go:248: NewUpload: context canceled

— watchflakes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Builders x/build issues (builders, bots, dashboards) 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
4 participants
@mknyszek @prattmic @bcmills @gopherbot