René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Queue.take in SQLPool can produce deadlock","articleBody":"**Describe the Bug**\r\nIn SQLPool we use take on the queue to wait for a connection to become available. If no connections become available (for example if a single thread is using up all connections) it produces a deadlock causing a lockup of the entire application since all database queries will run into a deadlock\r\n\r\n**To Reproduce**\r\nSteps to reproduce the behavior:\r\n1. Set the pool size to 1\r\n2. Call get once\r\n3. Call get a second time -\u003e gets stuck\r\n\r\n**Expected behavior**\r\nThe pool should use poll instead and throw an Exception after a reasonable amount of waiting time preventing a lockup of the entire application\r\n\r\n**Environment Information:**\r\n - Java Language Level 8\r\n - Version 1.0.3\r\n\r\n**Additional Context**\r\nThe root cause of this might be a different issue since the pool shouldn't have ran out of connections in the first place. We can check this issue once proper exceptions are thrown.\r\n","author":{"url":"https://github.com/JanHolger","@type":"Person","name":"JanHolger"},"datePublished":"2024-11-14T14:01:33.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/58/orm/issues/58"}