SMF Support > Server Performance and Configuration

Deadlock found when trying to get lock; Try restarting transaction

(1/1)

el-brujo:
Hi,


--- Code: ---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
--- End code ---

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

Lines 1200-1202 of Subs.php


--- Code: --- 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__);

--- End code ---

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

Navigation

[0] Message Index