Quota Exceeded notifications repeated daily

Started by ronny

Quota Exceeded notifications repeated daily   12 October 2016, 22:21

Hi Andrew,

The Bandwidth Manager is sending notifications daily, like it is stuck in a loop. This only happens to users who have reached their assigned quota, they get their first notification and then one notification everyday thereafter, even though their rate limit does not change in the GUI.

I have sent the log showing this and a backup of the configuration through the contact centre. The tracking ID for my message is U9E-Z68-****
SoftPerfect Support forum - Andrew avatar image

Re: Quota Exceeded notifications repeated daily   13 October 2016, 14:56

Hi Ronny,

I have responded to your message in the contact centre. Please see my response and we can continue troubleshooting there.

Andrew

Re: Quota Exceeded notifications repeated daily   20 October 2016, 00:41

Hi Andrew,

I have tested with 3 different SMTP Servers, and 2 SMS gateways, in varies combinations. This all points back to the Bandwidth Manager.

If you look at the log below, after every 'database maintenance' the bandwidth manager is stating it has changed the rate limit of a rule which is already at a reduced rate, so the rate has not changed. It happens everyday without fail, for the same rules. However in the GUI the rate limit is correct and no changes happen.
When the Log shows the rate limit has changed (which in fact it has not) it sends a message, which I have confirmed with SMTP logs that the messages are coming from the Bandwidth Manager.

I am not sure what to do, as this is not a problem I am able to diagnose, seems to be a bug in the software. The only thing I can think of is the number of rules I have now is causing this, verse what I had before the problem started.

18/10/2016 19:00:48	Rate limit changed for N0040 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0166 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0151 from 896 kB : 8,39 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0140 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0107 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0075 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0069 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0020 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0017 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:42:09	Rate limit changed for N0015 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 17:41:47	Database maintenance complete (4409 records deleted)
18/10/2016 17:29:07	Rate limit changed for N0151 from 896 kB : 8,39 Mb/s to 128 kB : 1,05 Mb/s
18/10/2016 12:45:11	Rate limit changed for N0069 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Rate limit changed for N0166 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Rate limit changed for N0140 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Rate limit changed for N0107 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Rate limit changed for N0075 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Rate limit changed for N0020 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Rate limit changed for N0017 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Rate limit changed for N0015 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 21:14:58	Database maintenance complete (4492 records deleted)
17/10/2016 09:23:26	Rate limit changed for N0015 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
17/10/2016 00:00:06	Rate limit changed for N0128 from 512 kB : 5,24 Mb/s to 1 MB : 10,5 Mb/s
16/10/2016 21:12:22	Rate limit changed for N0166 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
16/10/2016 21:12:22	Rate limit changed for N0140 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
16/10/2016 21:12:22	Rate limit changed for N0128 from 1 MB : 10,5 Mb/s to 512 kB : 5,24 Mb/s
16/10/2016 21:12:22	Rate limit changed for N0107 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
16/10/2016 21:12:22	Rate limit changed for N0075 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
16/10/2016 21:12:22	Rate limit changed for N0020 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
16/10/2016 21:12:22	Rate limit changed for N0017 from 512 kB : 4,19 Mb/s to 128 kB : 1,05 Mb/s
16/10/2016 21:12:22	Database maintenance complete (4427 records deleted)
SoftPerfect Support forum - Andrew avatar image

Re: Quota Exceeded notifications repeated daily   20 October 2016, 13:54

It is indeed a bug. It only happened when a database maintenance was performed and records were deleted. This caused the ruleset to be reloaded and notifications to be sent.

Thanks for pointing it out! We've just fixed this and included it in version 3.1.8.

Re: Quota Exceeded notifications repeated daily   21 October 2016, 02:12

Hi Andrew,

Thank you, I have loaded 3.1.8, will see how things go laugh

Also what is {STREAM_ADDR}? What does it display exactly in notifications?
It would be nice to have {RULE_NAME} for notifications. thinking
SoftPerfect Support forum - Andrew avatar image

Re: Quota Exceeded notifications repeated daily   21 October 2016, 09:47

Some admins use the notification mechanism to send e-mails to themselves, e.g. when a quota is used up. As they have the same e-mail in all the rules, {STREAM_ADDR} allows to tell whose quota is used up. When tracking is used, it will contain IP or MAC address of the user whose stream has used a quota.

It's a good idea to add {RULE_NAME} as well, we'll do that.

Re: Quota Exceeded notifications repeated daily   29 November 2016, 18:09

Hi Andrew,

The problem is back sad Version 3.1.8 on Server 2012 R2.

28/11/2016 18:40:55 Database maintenance complete (4986 records deleted)
28/11/2016 13:48:01 Rate limit changed for N0078 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
28/11/2016 10:34:45 Rate limit changed for N0147 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
28/11/2016 00:00:29 Rate limit changed for N0128 from 524 kb : 5,24 Mb/s to 1,05 Mb : 10,5 Mb/s
27/11/2016 18:39:05 Database maintenance complete (4950 records deleted)
27/11/2016 18:30:04 Rate limit changed for N0127 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
27/11/2016 18:30:04 Rate limit changed for N0085 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
27/11/2016 17:12:28 Rate limit changed for N0090 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
27/11/2016 11:33:03 Rate limit changed for N0023 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
26/11/2016 20:57:44 Rate limit changed for N0112 from 655 kb : 6,29 Mb/s to 131 kb : 1,05 Mb/s
26/11/2016 18:37:03 Database maintenance complete (4947 records deleted)
26/11/2016 17:35:55 Rate limit changed for N0177 from 524 kb : 4,19 Mb/s to 1,05 Mb : 10,5 Mb/s
26/11/2016 16:45:23 Rate limit changed for N0128 from 1,05 Mb : 10,5 Mb/s to 524 kb : 5,24 Mb/s
26/11/2016 16:31:22 Rate limit changed for N0158 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
26/11/2016 16:08:20 Rate limit changed for N0027 from 1,05 Mb : 10,5 Mb/s to 131 kb : 1,05 Mb/s
26/11/2016 14:11:12 Rate limit changed for N0012 from 1,05 Mb : 10,5 Mb/s to 131 kb : 1,05 Mb/s
26/11/2016 12:53:36 Rate limit changed for N0106 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
26/11/2016 12:21:58 Rate limit changed for N0057 from 131 kb : 1,05 Mb/s to 524 kb : 4,19 Mb/s
26/11/2016 10:08:55 Rate limit changed for N0057 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
25/11/2016 18:35:19 Database maintenance complete (4899 records deleted)
24/11/2016 18:33:38 Database maintenance complete (4861 records deleted)
24/11/2016 08:53:57 Rate limit changed for N0016 from 1,05 Mb : 10,5 Mb/s to 131 kb : 1,05 Mb/s
23/11/2016 18:31:57 Database maintenance complete (4727 records deleted)
23/11/2016 15:18:13 Rate limit changed for N0071 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
22/11/2016 18:30:16 Database maintenance complete (4768 records deleted)
22/11/2016 16:00:34 Rate limit changed for N0069 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
21/11/2016 18:28:34 Database maintenance complete (4033 records deleted)
21/11/2016 00:00:15 Rate limit changed for N0128 from 524 kb : 5,24 Mb/s to 1,05 Mb : 10,5 Mb/s
20/11/2016 18:26:52 Database maintenance complete (4619 records deleted)
19/11/2016 18:24:54 Database maintenance complete (4654 records deleted)
18/11/2016 18:23:13 Database maintenance complete (4727 records deleted)
17/11/2016 18:21:33 Database maintenance complete (4722 records deleted)
17/11/2016 17:41:29 Rate limit changed for N0168 from 918 kb : 8,39 Mb/s to 131 kb : 1,05 Mb/s
17/11/2016 11:19:00 Rate limit changed for N0128 from 1,05 Mb : 10,5 Mb/s to 524 kb : 5,24 Mb/s
16/11/2016 18:19:50 Database maintenance complete (4734 records deleted)
16/11/2016 10:57:49 Rate limit changed for N0154 from 655 kb : 6,29 Mb/s to 131 kb : 1,05 Mb/s
15/11/2016 19:52:46 Rate limit changed for N0040 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
15/11/2016 18:18:09 Database maintenance complete (4640 records deleted)
15/11/2016 17:41:06 Rate limit changed for N0162 from 655 kb : 6,29 Mb/s to 131 kb : 1,05 Mb/s
14/11/2016 18:16:28 Database maintenance complete (4663 records deleted)
14/11/2016 00:00:05 Rate limit changed for N0128 from 524 kb : 5,24 Mb/s to 1,05 Mb : 10,5 Mb/s
13/11/2016 18:14:39 Database maintenance complete (4617 records deleted)
13/11/2016 12:19:12 Rate limit changed for N0015 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s
12/11/2016 18:12:41 Database maintenance complete (4558 records deleted)
12/11/2016 12:03:14 Rate limit changed for N0149 from 524 kb : 4,19 Mb/s to 131 kb : 1,05 Mb/s

And what does this mean?

11/11/2016 11:18:20 TDequeueThread Access violation at address 00007FFCEFDEDD8E in module 'ntdll.dll'. Write of address 0000000000000024
11/11/2016 11:18:20 TCoreThread Access violation at address 00007FFCEFDEDD8E in module 'ntdll.dll'. Write of address 0000000000000024
11/11/2016 11:18:20 TCoreThread Access violation at address 00007FFCEFDEDD8E in module 'ntdll.dll'. Write of address 0000000000000024
SoftPerfect Support forum - Andrew avatar image

Re: Quota Exceeded notifications repeated daily   29 November 2016, 23:17

There doesn't seem to be a problem with the above messages for rule N0128. As you can see it changes between two set values according to the usage:
  • 14/11/2016 00:00:05 N0128 from 524 kb : 5,24 Mb/s to 1,05 Mb : 10,5 Mb/s - Monday quota reset
  • 17/11/2016 11:19:00 N0128 from 1,05 Mb : 10,5 Mb/s to 524 kb : 5,24 Mb/s - Quota exceeded
  • 21/11/2016 00:00:15 N0128 from 524 kb : 5,24 Mb/s to 1,05 Mb : 10,5 Mb/s - Monday quota reset
  • 26/11/2016 16:45:23 N0128 from 1,05 Mb : 10,5 Mb/s to 524 kb : 5,24 Mb/s - Quota exceeded
  • 28/11/2016 00:00:29 N0128 from 524 kb : 5,24 Mb/s to 1,05 Mb : 10,5 Mb/s - Monday quota reset

Regarding the Access violation errors, we've been trying to track it down for a while, without success so far. It appears to occur extremely infrequently and somewhere deep down in OS files. I guess we'll just add a workaround to restart the service automatically if such an error occurs.

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 **     **  ********        **  ********  **    ** 
 **     **     **           **     **     **   **  
 **     **     **           **     **     **  **   
 **     **     **           **     **     *****    
 **     **     **     **    **     **     **  **   
 **     **     **     **    **     **     **   **  
  *******      **      ******      **     **    ** 

Message: