Good evening,
You need to identify the Windows updates that have an excessively large download_urls column

on the server:

`sudo -u wapt psql



select update_id,title,pg_column_size(download_urls) from wsusupdates where pg_column_size(download_urls)>10000;

` then

delete from wsusupdates where ...

Discussed with Rémy:
- For Windows updates, one KB in particular (Silverlight update) has a very large list of URLs (10MB) and significantly slows down loading => remove this KB from the server database.
- For driver bundles, the console code in version 2.6 unnecessarily loads all the...

Hi Rémy,
No, indeed, there's no automatic purging except for deleting everything via the console interface, which is perhaps a bit too drastic.

Until a better solution is found, the SQL query "

Purge everything older than one year":


delete from logsapi l where l.created_on < current ...

Version 2.6.1.17870-d3b9238d is released with the 2 fixes.

We've fixed both issues:
A release is planned soon (before the end of the week)

https://wapt.tranquil.it/wapt/nightly/w ... -c88b2627/

Hello,
do you have Kerberos authentication enabled on the server side?
Are you using Chrome/Chromium for the web interface?
If so, could you try with Firefox?

There's a different behavior for 401 status errors between the two browsers.

If you have some free time, I can look into it...

Are you sure you're on the latest version, 2.6.1.17834?
I ran a test but couldn't reproduce the access violation.
However, these "Access violation" errors are often dependent on the previous memory state.

Ah... perhaps a regression.

Could you try the script by adding a `pythoncom.CoInitialize()`?
# -*- coding: utf-8 -*-
from setuphelpers import *
from waptwua.client import WaptWUA
import pythoncom

def audit():
try:
pythoncom.CoInitialize()
with EnsureWUAUServRunning():
wua_client ...

I've included the fix in the upcoming 2.7 release.
In the meantime, you'll need to copy the file modified via GPO...

Curious.
Probably related to Windows updates. We haven't touched that in years.
I'll implement a fallback.

Could you try replacing the function with:


`def get_language(full_locale=False, separator='_'):
"""Get the OS default locale (example: fr, en, pl, etc.)

>>> get ...`