Po aktualizacji zgłasza błędy

eltonik

Po aktualizacji zgłasza co chwilę błąd:

who=1

type=256

message=mysqlt error: [1213: Deadlock found when trying to get lock; try

restarting transaction] in EXECUTE("DELETE FROM recordbrowser_words_map

WHERE tab_id='5' AND record_id=1009")

error file=/var/www/libs/adodb/adodb-errorhandler.inc.php

error line=77

Zmienia się tylko klauzala WHERE, ale zapytanie jest takie samo.

ajb

Potrzebuję dalszą część raportu błędu. Najlepiej cały.

eltonik

Proszę

who=1

type=256

message=mysqlt error: [1053: Server shutdown in progress] in EXECUTE("DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594")

error file=/var/www/libs/adodb/adodb-errorhandler.inc.php

error line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "mysqlt error: [1053: Server shutdown in progress] in EXECUTE(\"DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594\")

", "/var/www/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1053, "Server shutdown in progress", "DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594", false, Object (ADODB_mysqlt), "DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594", false, "mysqlt error: [1053: Server shutdown in progress] in EXECUTE(\"DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594\")

"))

File: /var/www/libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("mysqlt error: [1053: Server shutdown in progress] in EXECUTE(\"DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594\")

", 256)

File: /var/www/libs/adodb/adodb.inc.php

    line 1071

    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1053, "Server shutdown in progress", "DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594", false, "Object (ADODB_mysqlt)")

File: /var/www/libs/adodb/adodb.inc.php

    line 1027

    function called: _Execute("DELETE FROM recordbrowser_words_map WHERE tab_id='10' AND record_id=2594")

[PHP core called function]

    function called: Execute("DELETE FROM recordbrowser_words_map WHERE tab_id=? AND record_id=?", Array ("10", 2594))

File: /var/www/include/database.php

    line 359

    function called: call_user_func_array(Array (Object (ADODB_mysqlt), "Execute"), Array ("DELETE FROM recordbrowser_words_map WHERE tab_id=? AND record_id=?", Array (#2)))

File: /var/www/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 3315

    function called: Execute("DELETE FROM recordbrowser_words_map WHERE tab_id=%s AND record_id=%d", Array (10, "2594"))

File: /var/www/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 3385

    function called: index_record("premium_listmanager_element", Array (#14), Array (Array (#17), Array (#15), Array (#14), Array (#17), Array (#15), Array (#15), Array (#15), Array (#15), Array (#15), Array (#14)), 10)

File: /var/www/modules/Utils/RecordBrowser/indexer.php

    line 17

    function called: indexer(3, 1)

ajb

To nie ten błąd... ten to raczej kwestia serwera. Wyłączanie mysql?

Pozdrawiam,
Adam

eltonik

No to ten, nie resetowałem mySQLa, trochę sypie błędami

who=1

type=256

message=mysqlt error: [1213: Deadlock found when trying to get lock; try restarting transaction] in EXECUTE("DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765")

error file=/var/www/libs/adodb/adodb-errorhandler.inc.php

error line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "mysqlt error: [1213: Deadlock found when trying to get lock; try restarting transaction] in EXECUTE(\"DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765\")

", "/var/www/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1213, "Deadlock found when trying to get lock; try restarting transaction", "DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765", false, Object (ADODB_mysqlt), "DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765", false, "mysqlt error: [1213: Deadlock found when trying to get lock; try restarting transaction] in EXECUTE(\"DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765\")

"))

File: /var/www/libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("mysqlt error: [1213: Deadlock found when trying to get lock; try restarting transaction] in EXECUTE(\"DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765\")

", 256)

File: /var/www/libs/adodb/adodb.inc.php

    line 1071

    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1213, "Deadlock found when trying to get lock; try restarting transaction", "DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765", false, "Object (ADODB_mysqlt)")

File: /var/www/libs/adodb/adodb.inc.php

    line 1027

    function called: _Execute("DELETE FROM recordbrowser_words_map WHERE tab_id='2' AND record_id=2765")

[PHP core called function]

    function called: Execute("DELETE FROM recordbrowser_words_map WHERE tab_id=? AND record_id=?", Array ("2", 2765))

File: /var/www/include/database.php

    line 359

    function called: call_user_func_array(Array (Object (ADODB_mysqlt), "Execute"), Array ("DELETE FROM recordbrowser_words_map WHERE tab_id=? AND record_id=?", Array (#2)))

File: /var/www/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 3315

    function called: Execute("DELETE FROM recordbrowser_words_map WHERE tab_id=%s AND record_id=%d", Array (2, "2765"))

File: /var/www/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 3385

    function called: index_record("contact", Array (#39), Array (#35), 2)

File: /var/www/modules/Utils/RecordBrowser/indexer.php

    line 17

    function called: indexer(3, 2)

ajb

Ok, prawdopodobnie znam przyczynę tego błędu. spróbuj zamienić plik modules/Utils/RecordBrowser/indexer.php na taki:

<?php

if (!isset($_GET['cid']) || !isset($_GET['token']))

	die('Invalid request: '.print_r($_GET,true));

	

define('CID',$_GET['cid']);

define('READ_ONLY_SESSION',true);

require_once('../../../include.php');

if(!isset($_SESSION['rb_indexer_token']) || $_SESSION['rb_indexer_token']!=$_GET['token'])

    die('Invalid token');

$total = 0;

$file = DATA_DIR . '/Utils_RecordBrowser/last';

$fp = fopen($file, 'a+');

flock($fp, LOCK_EX);

fseek($fp, SEEK_SET, 0);

$timestamp = (int) fgets($fp, 15);

if($timestamp < time() - 120) {

    ModuleManager::load_modules();

    Base_AclCommon::set_sa_user();

    Utils_RecordBrowserCommon::indexer(3,$total);

    if($total == 0) {

        ftruncate($fp, 0);

        fwrite($fp, time());

        fflush($fp);

    }

}

flock($fp, LOCK_UN);

fclose($fp);

?>setTimeout('rb_indexer("<?php print($_GET['token']); ?>")',<?php print($total==0?180000:1000);?>);

Pozdrawiam,
Adam

shacky

Witam,
wg. mnie to jest problem poziomu izolacji oraz braku ew. indeksu na kolumnach (tab_id, record_id) - proszę sprawdzić poziom izolacji oraz czy istnieje indeks w tabeli recordbrowser_words_map.

Więcej o poziomach izolacji:
http://www.ovaistariq.net/597/understan ... GYezXWFoVk

Pozdrawiam
Paweł

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge