get items sometimes doesn't work

[lilithxxx]

Expected Behavior

After putting an item in the queue, get must always fetch the item in the queue

Actual Behavior

After putting an item in the queue, sometimes randomly the get function does not fetches the item

Steps to Reproduce the Problem

1. Put an item
2. get the item with a timeout, i.e block until item is available
3. although the item is available in the queue (ive checked the database manually to see that the item is indeed committed to the db) the get function blocks and does not return
4. I must emphasize that this behavior occurs randomly and such these steps might not work for someone else.

Specifications

• Version: 1.9.1
• Python version: 3.11.6
• Postgres version: 16.1