[prev in list] [next in list] [prev in thread] [next in thread] 

List:       wine-devel
Subject:    Re: Problem with the wine-gitlab mailing list archive?
From:       Jeremy Newman <jnewman () codeweavers ! com>
Date:       2022-11-02 14:32:32
Message-ID: a085cc8e-a400-13cb-97c0-2a2f08489760 () codeweavers ! com
[Download RAW message or body]

It is not an OOM issue. Plenty of memory, and the swap is never touched.

The only thing I see in the logs is this:

```
Oct 28 03:28:55 2022 (1302774) Uncaught runner exception: (raised as a 
result of Query-invoked autoflush; consider using a session.no_autoflush 
block if th
is flush is occurring prematurely)
(pymysql.err.OperationalError) (2006, "MySQL server has gone away 
(ConnectionResetError(104, 'Connection reset by peer'))")
...snip traceback...
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked 
autoflush; consider using a session.no_autoflush block if this flush is 
occurring prematurely)
(pymysql.err.OperationalError) (2006, "MySQL server has gone away 
(ConnectionResetError(104, 'Connection reset by peer'))")

```

Looks like it is not recovering from a mysql disconnect.

It could be due to mysql wait_timeout being low (currently 60). I could 
try to raise that and see if that helps.

-N

On 11/1/22 8:49 PM, Mohamad Al-Jaf wrote:
> Are the messages getting stuck in the spool directory? Check the log
> in /opt/mailman/var/logs/mailman.log. You can also check the spool
> message with the command $ mailman qfile. It appears this issue can
> occur if there's insufficient memory. A quick solution is to just add
> more swap memory.[1]
> 
> If anything, you can always set up a cron job to periodically restart
> the mail services and databases, though this would be a hacky
> solution.
> 
> Hope this helps.
> 
> [1] https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/IYPKZZIIDJOOFH7WVF7Z474RJA7ICRKM/
>                 
> --
> Kind regards,
> Mohamad
> 
> On Sat, Oct 22, 2022 at 1:17 PM Jeremy Newman <jnewman@codeweavers.com> wrote:
> > 
> > I tweaked a few mariadb settings, restarted the db, and restarted the
> > mailman services. That seems to have kicked it into gear again. Nothing
> > was lost, looks like things just got stuck.
> > 
> > -N
> > 
> > 
> > On 10/22/22 11:07 AM, Jeremy Newman wrote:
> > > On 10/22/22 10:08 AM, Francois Gouget wrote:
> > > > 
> > > > The wine-gitlab mailing list archive shows no new message since last
> > > > Tuesday (2022-10-18). Yet I did receive emails on that list since then.
> > > > 
> > > > https://www.winehq.org/mailman3/hyperkitty/list/wine-gitlab@winehq.org/
> > > > 
> > > > What's going on?
> > > > 
> > > > 
> > > 
> > > Don't know. Hyperkitty is not adding them to the archive. This new
> > > version of mailman is not making me very happy. I've tried rebuilding
> > > the search index a few times, but the script always crashes.
> > > 
> > > It seems to be affecting all the lists. I think it is because MariaDB is
> > > overloaded and timing out.
> > > 
> > > -N
> > 
> > 
> > 


[prev in list] [next in list] [prev in thread] [next in thread]