"Internal error preparing sql filter" due to cancelled request reflects in HTTP500 #9986
Description
This was caught by our E2E tests:
2023-09-29T23:34:53.8487312Z [stderr] [create first user]: �[38;5;45;1mpw:api �[0m<= browserContext.storageState succeeded �[38;5;45m+4ms�[0m
2023-09-29T23:34:53.8561010Z [stderr] [unknown]: [WebServer] �[0m2023-09-29 23:34:53.855 [warn] coderd: GET host=localhost:3000 path=/api/v2/workspaces proto=HTTP/1.1 remote_addr=127.0.0.1 start="2023-09-29T23:34:53.854909951Z" took=417.406µs status_code=500 latency_ms=0 response_body="{\"message\":\"Internal error preparing sql filter.\",\"detail\":\"prepare filter: new partial authorizer: prepare: eval_cancel_error: caller cancelled query execution\"}\n" request_id=ce08988e-6178-4afa-a3ba-3559a07e7a85
2023-09-29T23:34:53.8563849Z �[0m2023-09-29 23:34:53.855 [warn] coderd: GET host=localhost:3000 path=/api/v2/users proto=HTTP/1.1 remote_addr=127.0.0.1 start="2023-09-29T23:34:53.853401857Z" took=1.977349ms status_code=500 latency_ms=1 response_body="{\"message\":\"Internal error fetching users.\",\"detail\":\"(dev error) prepare sql filter: new partial authorizer: prepare: eval_cancel_error: caller cancelled query execution\"}\n" request_id=8a56a1a9-c1a9-4539-9c96-735fffa2c4b2
2023-09-29T23:34:53.8646211Z Finished test create first user: passed
Link: https://github.com/coder/coder/actions/runs/6358309656/attempts/1?pr=9907
Unfortunately, we lost pprof dump due to a job retry.
It also seems to affect also next E2E tests:
2023-09-29T23:34:55.1276518Z [stdout] [app]: [onRequest] method=POST url=http://localhost:3000/api/v2/organizations/31d5754e-64cd-40ca-9ed6-94e061faafea/templateversions postData={"storage_method":"file","file_id":"19beaf28-abda-4f0a-b080-8d61a3068a04","provisioner":"echo","tags":{}}
2023-09-29T23:34:55.1303344Z [stderr] [app]: �[38;5;45;1mpw:api �[0m=> response.body started �[38;5;45m+44ms�[0m
2023-09-29T23:34:55.1306863Z [stdout] [app]: [onConsole] Failed to load resource: the server responded with a status of 404 (Not Found)
2023-09-29T23:34:55.1445452Z [stderr] [app]: �[38;5;45;1mpw:api �[0m click action done �[38;5;45m+14ms�[0m
2023-09-29T23:34:55.1446785Z [stderr] [app]: �[38;5;45;1mpw:api �[0m waiting for scheduled navigations to finish �[38;5;45m+0ms�[0m
2023-09-29T23:34:55.1447679Z [stderr] [app]: �[38;5;45;1mpw:api �[0m<= response.body succeeded �[38;5;45m+0ms�[0m
2023-09-29T23:34:55.1449051Z [stdout] [app]: [onResponse] url=http://localhost:3000/api/v2/organizations/31d5754e-64cd-40ca-9ed6-94e061faafea/templateversions status=404 body={"message":"Resource not found or you do not have access to this resource"}