Whoville
Login
Register
Whoville
Login
Register
System Apps
Directory
Help
Language
Like Us
QRator
Random Channel
Report Bug
Search
Support Hubzilla
Delete queue of messages
Thu, 11 Jul 2024 19:38:02 +0200
View Profile
Hubzilla Support Forum
adminsforum@hubzilla.org
od
wrote the following
post
Thu, 11 Jul 2024 19:38:44 +0200
Delete queue of messages
od
wrote the following
post
Tue, 13 Feb 2024 10:48:16 +0100
Messages not sent nor received
The server administration shows thousands of 'messages queued'
What does this mean?
How to fix please?
Please what are the instructions to delete the queue of messages, for a hubzilla server?
Link to Source
Link on Hub
show all
10 comments
Thu, 11 Jul 2024 21:06:06 +0200
View Profile
Der Pepe (Hubzilla) ⁂ ⚝
pepecyb@hub.hubzilla.hu
As far as I know, this is only possible directly in the database in the outq table.
1
Max Kostikov
Link to Source
Link on Hub
Sat, 13 Jul 2024 14:35:11 +0200
View Profile
od
od@tiksi.net
@
Der Pepe (Hubzilla)
@
node9.org ;-) open culture ~ sustainable media
@
techriot
@
Jupiter Rowland
Have also read another forum post, perhaps related:
https://hubzilla.org/display/22b10cd2-3d3f-4b20-9e60-2d4d07427075
There is a 'connection' with a 'node9' server, but no 'connection' with users on 'netzgemeinde' server. After deletion of all rows that include url of these servers, after a few minutes, the database table 'outq' becomes populated again with these urls and the queue begins to grow.
Any suggestions to fix please?
Should the servers administrators be contacted?
Link to Source
Link on Hub
Tue, 16 Jul 2024 20:02:16 +0200
View Profile
od
od@tiksi.net
@
Der Pepe (Hubzilla)
How did you know about the database table 'outq'? :)
The database log (now many gb size) shows:
"
...
dba_driver.php:463:db_logger: dba_pdo: ERROR: UPDATE outq SET outq_scheduled = '...' WHERE outq_posturl = 'https://hub.netzgemeinde.eu/post'
...
CONTEXT: while rechecking updated tuple (3,24) in relation "outq"
...
LOG_INFO::queue_fn.php:270:queue_deliver: deliver: remote zot6 delivery failed to
https://hub.netzgemeinde.eu/post
...
network.php:384:z_post_url: z_post_url: error:
https://hub.netzgemeinde.eu/post
:
...
queue_fn.php:231:queue_deliver: deliver: dest:
https://hub.netzgemeinde.eu/post
driver: zot6
...
queue_fn.php:270:queue_deliver: deliver: remote zot6 delivery failed to
https://hub.netzgemeinde.eu/post
...
network.php:384:z_post_url
: z_post_url: error:
https://hub.netzgemeinde.eu/post
:
...
"
Please any ideas to fix?
#
hubzilla
, #
hubzillabug
, #
hubzillabug202402
, #
hubzillaadminstrator
, #
hubzillaserver
, #
hubzillapostgresql
, #
hubzillaoutq
Link to Source
Link on Hub
Tue, 16 Jul 2024 20:34:11 +0200
View Profile
Der Pepe (Hubzilla) ⁂ ⚝
pepecyb@hub.hubzilla.hu
What is in the queue in the admin web interface? Are there a lot of deliveries stuck at hub.netzgemeinde.eu?
Link to Source
Link on Hub
Tue, 16 Jul 2024 20:36:00 +0200
View Profile
Jupiter Rowland
jupiter_rowland@hub.netzgemeinde.eu
@
Der Pepe (Hubzilla)
Oh no, not again...
Then again, I still do get some posts or comments with quite a bit of delay, but it isn't like the whole hub feels sluggish again.
Link to Source
Link on Hub
Tue, 16 Jul 2024 22:55:23 +0200
View Profile
od
od@tiksi.net
@
Der Pepe (Hubzilla)
Thousands of entries for the netzgemeinde domain.
Link to Source
Link on Hub
Tue, 16 Jul 2024 23:12:54 +0200
View Profile
Der Pepe (Hubzilla) ⁂ ⚝
pepecyb@hub.hubzilla.hu
@
od
It doesn't solve the fundamental problem of why so many deliveries are stuck at hub.netzgemeinde.eu, but personally I would delete them from the outq table (
DELETE FROM outq WHERE outq_posturl LIKE '%hub.netzgemeinde.eu%';
).
What does @
Mario Vavti
think? That shouldn't cause any problems, should it?
Link to Source
Link on Hub
Wed, 17 Jul 2024 20:04:40 +0200
View Profile
od
od@zotum.net
Deletion has no effect; within minutes, the database table becomes populated with the same data.
Link to Source
Link on Hub
Wed, 17 Jul 2024 21:02:51 +0200
View Profile
Der Pepe (Hubzilla) ⁂ ⚝
pepecyb@hub.hubzilla.hu
Ok, then you really need to contact @
Mario Vavti
. I have no idea why the domain is causing so much trouble.
Link to Source
Link on Hub
Mon, 22 Jul 2024 12:49:03 +0200
View Profile
od
od@zotum.net
If a domain url in the database table 'outq' reports "invalid signature". The 'response' header shows an expiration date many decades in the past!
What could be the cause?
Link to Source
Link on Hub
Conversation Features
Loading...
Conversation Features
Loading...
Login
Email or nickname
Password
Remember me
Login
Register
Password Reset
Remote Authentication