René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] - Payments taking a long time to clear, or don't clear","articleBody":"Hi guys - thanks for making your tool available to the Nostr community!\r\n\r\nWe'd like to report an issue we have observed with the 'paid relay' feature, which we have deployed to relay.nquiz.io\r\n\r\nWhen we do a fresh deploy, everything works as it should.\r\n\r\nBut, after some time of usage, generating multiple invoices, of which some are paid, some not, some expired, some not - the relay stops processing payments.  So, even though the user has paid the lightning invoice, the relay can't figure it out and the user doesn't get admitted (`/invoices` page never says \"payment successful\", QR code remains on screen)\r\n\r\nAfter we notice that this is happening, we perform the following hack:\r\n\r\n1. Launch the docker nostream-db container bash:  `docker exec -it nostream-db bash`\r\n2. Log in to the DB: `psql -U nostr_ts_relay`\r\n3. Remove all of the invoices:  `delete from invoices;`\r\n\r\nAfter these steps, the relay begins to admit users again.\r\n\r\nIs this something you are aware of?  If so, is there a fix planned, or are there any workarounds we can use?\r\n\r\n**System:**\r\n - OS: [Ubuntu]\r\n - Platform: [docker]\r\n\r\n\r\n\r\n","author":{"url":"https://github.com/nQuiz","@type":"Person","name":"nQuiz"},"datePublished":"2023-11-06T23:44:45.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/342/nostream/issues/342"}