Deadlock found when trying to get lock; Try restarting transaction

[el-brujo]

Hi,

Code Select Expand


http://www.myforum.com/index.php?action=search2
Error en la Base de Datos: Deadlock found when trying to get lock; Try restarting transaction
File: /myforum/Sources/Subs.php
Line: 1201

Some users atre trying to ****** my forum using thousand times this error.

Lines 1200-1202 of Subs.php

Code Select Expand

INSERT IGNORE INTO {$db_prefix}log_online
(session, ID_MEMBER, ip, url)
VALUES ('$session_id', $ID_MEMBER, IFNULL(INET_ATON('$user_info[ip]'), 0), '$serialized')", __FILE__, __LINE__);


Any help or ideas?

I try to --> Edit Permissions --> Unregistered Guests --> Search for posts and topics --> 'Disallow' (X) but the attack continue....

I'm using SMF 1.0.4 and some tables with InnoDB like log_online

Thank you in advance.

[Ben_S]

How often is it happening, if it's not too many times I wouldn't worry too much. I beleive 1.1 doesn't log them in the error log because they aren't really serious.

See http://dev.mysql.com/doc/mysql/en/innodb-deadlocks.html