Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#841 Crash instance with error SQL

1.2.3
open
nobody
Murmur (142)
5
2012-10-30
2011-11-06
Xavier
No

Hello,

Since few days we have some mysql errors, without reason :

<W>2011-11-05 21:59:22.408 71 => <8:mAMBA(67)> Updated ACL in channel Home[18:1]
<F>2011-11-05 21:59:30.375 SQL Error [INSERT INTO group_members (group_id, server_id, user_id, addit) VALUES (?, ?, ?, ?)]: Cannot add or update a child row: a foreign key constraint fails (servmumble_mumble14.group_members, CONSTRAINT group_members_del_user FOREIGN KEY (server_id, user_id) REFERENCES users (server_id, user_id) ON DELETE CASCADE) QMYSQL3: Unable to execute statement

Mumble version : 1.2.3 Stable

Best regards.

Discussion

  • Your database is broken because it contains entries which violate the foreign key constraints. You have to manually find and fix or remove those entries.

     
  • Xavier
    Xavier
    2011-11-08

    Ok, and we have this too :

    <F>2011-11-08 05:10:37.355 SQL Error [INSERT INTO slog (server_id, msg) VALUES(?,?)]: Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement

     
  • Xavier
    Xavier
    2011-11-08

    AND :

    <F>2011-11-08 05:25:12.648 SQL Error [SELECT server_id FROM servers]: Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement

     
  • Xavier
    Xavier
    2012-01-07

    Hi,

    We have this error again and in our database, we don't have this reference :
    group_members_del_user

    For group_members, we have :
    - group_members_users
    - group_members_del_group

    For users :
    - users_id
    - users_name
    - users_channel

    Best regards,