Print Page - Deadlock found when trying to get lock; Try restarting transaction

Title: Deadlock found when trying to get lock; Try restarting transaction
Post by: el-brujo on June 15, 2005, 05:40:43 PM

Hi,

Code Select


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

		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.

Title: Re: Deadlock found when trying to get lock; Try restarting transaction
Post by: Ben_S on June 15, 2005, 07:51:24 PM

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

Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: el-brujo on June 15, 2005, 05:40:43 PM