From Peter Sanchez to ~sircmpwn/sr.ht-discuss
Just a follow up that this indeed appears to have resolved the issue. I should have thought of the celery brokers. Thanks again! Peter -- Peter Sanchez pjs@petersanchez.com https://petersanchez.com P.S. What I'm up to now: https://petersanchez.com/now/
From Peter Sanchez to ~sircmpwn/sr.ht-discuss
>Could it be that you have configured the same redis database for all >the webhooks in your config.ini? >Every service needs a dedicated one. I did in fact have every service (except lists celery master) using the same redis db. I just updated it so each one has it's own (though lists celery master and worker share the same one as the config comment notes). Thank you Thorbon, let's see if this fixes it. Peter --
From Peter Sanchez to ~sircmpwn/sr.ht-discuss
Hi all. I host my own copy of srht and have had this issue forever and
I'm finally annoyed enough to look into this and I'm at a bit of a loss
here.
Every time someone submits a patch or mails one of my lists I get like 8
error emails essentially summed up with this traceback:
```
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "list_webhook_delivery" does not exist
From Peter Sanchez to ~sircmpwn/public-inbox
--- In my local testing this is working. Please review. I left it to call the before function before every attempt because each use case is different. Leave it up to the developer to decide how the before function behaves if it's the first attempt or not. task.go | 41 +++++++++++++++++++++++++++++------------ 1 file changed, 29 insertions(+), 12 deletions(-) diff --git a/task.go b/task.go index 8cef704..8056796 100644 --- a/task.go [message trimmed]
From Peter Sanchez to ~sircmpwn/public-inbox
--- This is just a helper to easily identify queues. queue.go | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/queue.go b/queue.go index 110412c..83a5c6e 100644 --- a/queue.go +++ b/queue.go @@ -80,6 +80,11 @@ func (q *Queue) Now(now func() time.Time) { q.now = now } [message trimmed]
From Peter Sanchez to ~sircmpwn/sr.ht-dev
On 08/04, Conrad Hoffmann wrote: >When a user updates their profile, the database gets updated >accordingly, but the webhooks get called with data retrieved before the >update. > >Make the update statement return the new values and apply them to the >user object that gets passed to the webhooks. I believe this will resolve this ticket: https://todo.sr.ht/~sircmpwn/meta.sr.ht/192
From Peter Sanchez to ~sircmpwn/sr.ht-packages
On 02/17, Denis Laxalde wrote: >(Having a second look.) > >This user does not exist. But we're having an 'hg' user (see >debian/srht-hg.postinst), should we use the same one here? You're right. The user is 'hg'. Sorry about that, I should have verified before just assuming all the users followed the same pattern.
From Peter Sanchez to ~sircmpwn/sr.ht-packages
--- debian/rules | 7 +++++++ debian/srht-todo.install | 1 + debian/srht-todo.postinst | 3 +++ debian/srht-todo.postrm | 21 +++++++++++++++++++++ debian/srht-todo.srht-todo-api.service | 13 +++++++++++++ 5 files changed, 45 insertions(+) create mode 100644 debian/srht-todo.install create mode 100644 debian/srht-todo.postrm create mode 100644 debian/srht-todo.srht-todo-api.service diff --git a/debian/rules b/debian/rules index 4abedcb..2d27bca 100755 --- a/debian/rules [message trimmed]
From Peter Sanchez to ~sircmpwn/sr.ht-packages
--- debian/rules | 7 +++++++ debian/srht-lists.install | 1 + debian/srht-lists.postinst | 3 +++ debian/srht-lists.postrm | 21 +++++++++++++++++++++ debian/srht-lists.srht-lists-api.service | 13 +++++++++++++ 5 files changed, 45 insertions(+) create mode 100644 debian/srht-lists.install create mode 100644 debian/srht-lists.postrm create mode 100644 debian/srht-lists.srht-lists-api.service diff --git a/debian/rules b/debian/rules index 1f0e430..3f8c644 100755 --- a/debian/rules [message trimmed]
From Peter Sanchez to ~sircmpwn/sr.ht-packages
# HG changeset patch # User Peter Sanchez <peter@netlandish.com> # Date 1645051197 21600 # Wed Feb 16 16:39:57 2022 -0600 # Node ID b48a2faef25007557c3846811a6d4952e697208c # Parent a834e88829f173d439f0cfca106a67d14e0acc99 Add GraphQL API diff --git a/debian/rules b/debian/rules --- a/debian/rules +++ b/debian/rules @@ -16,11 +16,14 @@ override_dh_auto_build: make SRHT_PATH=${SRHT_PATH} dh_auto_build [message trimmed]