SQLite cursor timeout in tests

[padraic-shafer]

I occasionally see timeouts in unit tests run on GitHub, stemming from the sqlite module. I'm not sure whether we simply need to increase the timeout for these tests, or if there is something more subtle like a race condition between tests using the db.

https://github.com/bluesky/databroker/blob/b7846d5e4d921338bf51fa73fafe4375e1b148ec/databroker/assets/sqlite.py#L121-L123

The failures are infrequent, but could be suggestive of being "on the edge" of an instability that might be triggered by the timing of usage on systems in the wild.

• https://github.com/padraic-shafer/databroker/actions/runs/8826890932/job/24233297726#step:7:1431
• https://github.com/bluesky/databroker/actions/runs/8823364014/job/24223636169#step:7:1491
• https://github.com/bluesky/databroker/actions/runs/8716193593/job/23909335292#step:7:1774