malthe / pq

A PostgreSQL job queueing system
376 stars 41 forks source link

get items sometimes doesn't work #72

Open lilithxxx opened 11 months ago

lilithxxx commented 11 months ago

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