Notification email delay

Forum News, Announcements and any issues you're having with the forum

Moderator: myglaren

User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Notification email delay

Post by xantia_v6 »

The notification delay is fixed for now, but I think that it may come back, it is not clear what is going on with the database lock, but we shall see.
User avatar
mickthemaverick
Donor 2024
Posts: 13524
Joined: 11 May 2019, 17:56
Location: Hertford
My Cars: 70+ former cars (list available) including 11 Citroens, 3 Renaults
Current cars: 2004 Subaru Legacy 2.5 SEn, 1994 Mazda MX3
x 6011

Re: Notification email delay

Post by mickthemaverick »

Thanks Mike, it is working properly at the moment as is evidenced by this response. Well done !! :) :) :)
I used to be indecisive, now I'm not so sure!
I used to ride on two wheels, but now I need all four!
User avatar
mickthemaverick
Donor 2024
Posts: 13524
Joined: 11 May 2019, 17:56
Location: Hertford
My Cars: 70+ former cars (list available) including 11 Citroens, 3 Renaults
Current cars: 2004 Subaru Legacy 2.5 SEn, 1994 Mazda MX3
x 6011

Re: Notification email delay

Post by mickthemaverick »

Sorry to say no notifications as yet from the last 5 posts which have gone on!! :cry:
I used to be indecisive, now I'm not so sure!
I used to ride on two wheels, but now I need all four!
Hell Razor5543
Donor 2023
Posts: 13727
Joined: 01 Apr 2012, 09:47
Location: Reading
My Cars: C5 Mk2 VTX+ estate.
x 2993

Re: Notification email delay

Post by Hell Razor5543 »

mickthemaverick wrote: 19 Jul 2020, 17:33 Sorry to say no notifications as yet from the last 5 posts which have gone on!! :cry:
Ah, that is to save postage costs. The system waits until there are enough emails to get a job lot discount, and then dispatches them to you.
James
ex BX 1.9
ex Xantia 2.0HDi SX
ex Xantia 2.0HDi LX
Ex C5 2.0HDi VTR
Ex C5 2.0HDi VTR

C5 2.2HDi VTX+
Yes, I am paranoid, but am I paranoid ENOUGH?
Out amongst the stars, looking for a world of my own!
User avatar
mickthemaverick
Donor 2024
Posts: 13524
Joined: 11 May 2019, 17:56
Location: Hertford
My Cars: 70+ former cars (list available) including 11 Citroens, 3 Renaults
Current cars: 2004 Subaru Legacy 2.5 SEn, 1994 Mazda MX3
x 6011

Re: Notification email delay

Post by mickthemaverick »

Just had 10 emails 5 mins after Steve posted ! :(
I used to be indecisive, now I'm not so sure!
I used to ride on two wheels, but now I need all four!
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Notification email delay

Post by xantia_v6 »

I have a theory that we have run into a bug or design flaw in the form software that has been exposed by changing to a different web server package.

I will live with this problem for a few days while trying to track down the root cause.
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Notification email delay

Post by xantia_v6 »

While browsing the forum source code looking for potential problems, i did find what appears to be a bug.
I have made a small correction to it and we are now testing the results.
User avatar
GiveMeABreak
Forum Admin Team
Posts: 37014
Joined: 15 Sep 2015, 19:38
Location: West Wales
My Cars: C3 Aircross SUV HDi Flair Peperoncino Red (The Chili Hornet)
C5 X7 2.0 HDi Exclusive Mativoire Beige (The Golden Hornet)
C3 1.6 HDi Exclusive Aluminium Grey (The Silver Hornet)
C5 MK II 2.0 HDi Exclusive Obsidian Black
C5 MK I 2.0 HDi SX Wicked Red
Xantia S2 2.0 HDi SX Hermes Red
C15 Romahome White
XM 2.0 Turbo Prestige Emerald Green Pearlescent
XM 2.0 Turbo Prestige Polar White
XM 2.0 SX Polar White
CX 20 Polar White
GS 1220 Geranium Red
CX 2.4 Prestige C-Matic Nevada Beige
GS 1000 Cedreat Yellow
x 5648

Re: Notification email delay

Post by GiveMeABreak »

Have you checked the task queue setting?

To ensure notification emails go out immediately while still making use of the task queue, set the configuration parameter "queue_interval" to 0. Also ensure email package size is set to a very large number.

The queue_interval parameter is not accessible via the Administration Control Panel or anywhere else in the web interface. You'll have to set it directly in the database's config table.

But contrary to the above, the support Team commented that "If you set the Email Package Size to zero on the Email Settings page, phpBB does not queue up the emails."

https://www.phpbb.com/community/viewtopic.php?t=2164504"
Please Don't PM Me For Technical Help

Marc
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Notification email delay

Post by xantia_v6 »

Yes I have investigated the settings and have chosen values which should work, although I think that the overall algorithm could be improved a little.

The bug that I spotted above however means that the algorithm has never (at least for the past 4 years) worked as intended, as most of the time the email queue was locked, just occasionally being unlocked to send out a bunch of queued emails.
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Notification email delay

Post by xantia_v6 »

The problem is evidently still present and is definitely a problem with the cron_lock. I will take a look at it tonight, unfortunately this bug only seems to be visible on the live forum, so is a bit tricky to track down.
Hell Razor5543
Donor 2023
Posts: 13727
Joined: 01 Apr 2012, 09:47
Location: Reading
My Cars: C5 Mk2 VTX+ estate.
x 2993

Re: Notification email delay

Post by Hell Razor5543 »

Alright, who has pinched/lost the key to the email queue?
James
ex BX 1.9
ex Xantia 2.0HDi SX
ex Xantia 2.0HDi LX
Ex C5 2.0HDi VTR
Ex C5 2.0HDi VTR

C5 2.2HDi VTX+
Yes, I am paranoid, but am I paranoid ENOUGH?
Out amongst the stars, looking for a world of my own!
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Notification email delay

Post by xantia_v6 »

I believe that the problem is now fixed. I did find a couple of instances of inappropriate coding in the forum software, but I have to put my hand up and say that the actual cause of the problem was a piece of code that I wrote in a new security plugin that I installed a couple of weeks ago.

It was not connected with the server software reconfiguration that I started a few days ago. The faulty code was not even part of the mail delivery system, it just happened to share the same background task lock.
User avatar
mickthemaverick
Donor 2024
Posts: 13524
Joined: 11 May 2019, 17:56
Location: Hertford
My Cars: 70+ former cars (list available) including 11 Citroens, 3 Renaults
Current cars: 2004 Subaru Legacy 2.5 SEn, 1994 Mazda MX3
x 6011

Re: Notification email delay

Post by mickthemaverick »

Brilliant Mike, nothing beats actually finding a cause. Have a beer on me Cheers
I used to be indecisive, now I'm not so sure!
I used to ride on two wheels, but now I need all four!
Post Reply