Are there any recommendations on how to run python...
# generala
aloof-airline-74337
05/28/2024, 10:47 PMAre there any recommendations on how to run python tests that interact with a postgresql database concurrently? I'm hitting concurrency issues despite having used
[pytest].execution_slot_varexecution_slot_varh
happy-kitchen-89482
05/28/2024, 11:09 PMHow are you using
execution_slot_varhappy-kitchen-89482
05/28/2024, 11:10 PMYou may not need a dedicated postgresql instance, but at least a dedicated tablespace
a
aloof-airline-74337
05/28/2024, 11:29 PMI am suffixing its value to each db name when we create a DB. We do that per
unittest.TestCasealoof-airline-74337
05/28/2024, 11:30 PMI'm seeing the sharded dbs get created, but we have alembic migrations that create extensions, and apparently those can race (since multiple `unittest.TestCase`s can run in the same execution slot I'm guessing)
aloof-airline-74337
05/28/2024, 11:30 PMNow that I'm typing this out would it be easier to run 1
unittest.TestCaseh
happy-kitchen-89482
05/29/2024, 1:38 PMMultiple test files can run per slot, yes, depending on how you have test batching set up
happy-kitchen-89482
05/29/2024, 1:39 PMBut if you have multiple TestCases per file then even single file per batch won't save you...
a
aloof-airline-74337
05/30/2024, 5:19 PMYeah there are some places where we have more than one TestCase per file. We also subclass it to set up migrations per class etc so without much refactoring the easiest thing to do was to spawn a dedicated pg instance per TestCase. Should hold us over until after we migrate. Would be nice to refactor our test setup afterwards...