Hello I have some unit tests to exercise some code I ve got

Question

Hello I have some unit tests to exercise some code I ve got around `Deployment build from flow` Things have been working fine until I tried adding in `work pool` configuration Not the tests fail with ```except HTTPStatusError as exc gt raise PrefectHTTPStatusError from httpx error exc from exc cause E prefect exceptions PrefectHTTPStatusError Client error 404 Not Found for url E Response detail Work pool lt work pool name gt not found E For more information check ``` This works fine if I m using `work queue` or leave them both out altogether Any suggestions

Chris White · Answer

Hi Josh work pools need to be created before they are referenced by a deployment so if you want to use work pools in your tests then you just need to create it first maybe as a fixture

Josh Paulin · Answer

I tried creating them by calling `client create work pool` in a fixture but that gave back a 500 from the ephemeral cluster

Chris White · Answer

500 usually means the API wasn t available or accessible

Josh Paulin · Answer

This was in the same fixture as the test harness being instantiated

Josh Paulin · Answer

```sqlalchemy exc OperationalError sqlite3 OperationalError no such table work pool SQL INSERT INTO work pool id created updated name description type base job template is paused default queue id concurrency limit VALUES id created updated name description type base job template is paused default queue id concurrency limit parameters id cf6eba98 8b63 4ee0 bc92 0fa9f3c2c02b created 2023 04 13 18 27 47 288283 updated 2023 04 13 18 27 47 288310 name dummy work pool description None type prefect agent base job template is paused 0 default queue id None concurrency limit None Background on this error at <https sqlalche me e 14 e3q8> ```

Josh Paulin · Answer

API is up threw in a `client api healthcheck ` for good measure

Chris White · Answer

oh it looks like you haven t upgraded your DB

Josh Paulin · Answer

This is using the test harness I ve not touched the db at all ever