#808 Murmur crash arround midnight due of a SQL prepare error

Current_GIT
invalid
nobody
Murmur (142)
unspecified
5
2013-12-16
2011-06-30
Anonymous
No

Hello,

I noticed that murmur has tendancy to crash arround midnight when I use it with a MySQL database

Here's the log I get :

<F>2011-06-27 00:01:51.953 SQL Error [INSERT INTO murmur_slog (server_id, msg) VALUES(?,?)]: Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement

QSslSocket: cannot resolve SSLv2_client_method
QSslSocket: cannot resolve SSLv2_server_method
<W>2011-06-27 00:01:52.810 Initializing settings from /home/mumble/mumble/release/mumble-server.ini (basepath /home/mumble/mumble/release)
<W>2011-06-27 00:01:52.811 OpenSSL: OpenSSL 1.0.0d 8 Feb 2011
<W>2011-06-27 00:01:52.819 SSL: Adding recommended CA UTN-USERFirst-Client Authentication and Email
<F>2011-06-27 00:01:52.870 SQL Error [SELECT value FROM murmur_meta WHERE keystring = 'version']: Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement

I'm using the git version of murmur on a Debian 7 (wheezy) in 64 bits. MySQL 5.1.57

If you need more details, I'm all ears.

Thank you in advance for solving this bug !

Discussion

  • fwaggle
    fwaggle
    2011-10-07

    This appears to be a duplicate of #3296378?

     

  • Anonymous
    2011-12-21

    Yes it appears to be the same issue :)

     

  • Anonymous
    2011-12-21

    At midnight a backup script is running, based on mysqldump command. I suppose that this command does a FLUSH TABLE that could explain why it crashes that way...

     
    Last edit: Anonymous 2014-07-31
  • Kissaki
    Kissaki
    2013-12-16

    • status: open --> invalid
    • Version: --> unspecified