mysqli error 1205

    Spoiler anzeigen

    mysqli error: [1205: Lock wait timeout exceeded; try restarting transaction] in EXECUTE("INSERT IGNORE INTO xt_sessions2 (expiry, sessdata, expireref, sesskey, created, modified)
    VALUES (NOW() + INTERVAL 1440 SECOND,'_USE_CACHE_COUNTRIES%7Cb%3A0%3B_USE_CACHE_LANGUAGE_CONTENT%7Cb%3A0%3Bcustomer%7CO%3A8%3A%22customer%22%3A13%3A%7Bs%3A12%3A%22customers_id%22%3Bi%3A0%3Bs%3A16%3A%22customers_status%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22customer_info%22%3Ba%3A1%3A%7Bs%3A12%3A%22account_type%22%3Bi%3A0%3B%7Ds%3A24%3A%22customer_default_address%22%3Ba%3A0%3A%7B%7Ds%3A25%3A%22customer_shipping_address%22%3Ba%3A0%3A%7B%7Ds%3A24%3A%22customer_payment_address%22%3Ba%3A0%3A%7B%7Ds%3A5%3A%22error%22%3Bb%3A0%3Bs%3A11%3A%22_master_key%22%3Bs%3A12%3A%22customers_id%22%3Bs%3A15%3A%22_master_key_add%22%3Bs%3A15%3A%22address_book_id%22%3Bs%3A6%3A%22_table%22%3Bs%3A12%3A%22xt_customers%22%3Bs%3A10%3A%22_table_add%22%3Bs%3A22%3A%22xt_customers_addresses%22%3Bs%3A22%3A%22password_special_signs%22%3Bi%3A3%3Bs%3A9%3A%22master_id%22%3Bs%3A12%3A%22customers_id%22%3B%7Dgeoip_country%7Cs%3A2%3A%22DE%22%3Bselected_currency%7Cs%3A3%3A%22EUR%22%3Bcart%7CO%3A4%3A%22cart%22%3A24%3A%7Bs%3A12
    %3A%22show_content%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22show_sub_content%22%3Ba%3A0%3A%7B%7Ds%3A7%3A%22content%22%3Ba%3A0%3A%7B%7Ds%3A13%3A%22content_total%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A40%3A%22%3Cspan%20class%3D%22price-tag%22%3EEUR%20%200%2C00%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3Bs%3A4%3A%22data%22%3Ba%3A2%3A%7Bs%3A5%3A%22PRICE%22%3Ba%3A2%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3B%7Ds%3A10%3A%22PRICE_OTAX%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A14%3A%22date_available%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22date_expired%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A11%3A%22content_tax%22%3Ba%3A0%3A%7B%7Ds%3A13%3A%22content_count%22%3Bi%3A0%3Bs%3A14%3A%22content_weight%22%3Bi%3A0%3Bs%3A11%3A%22sub_content%22%3Ba%3A0%3A%7B%7Ds%3A17%3A%22sub_content_total%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A40%3A%22%3Cspan%20class%3D%22pri
    ce-tag%22%3EEUR%20%200%2C00%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3Bs%3A4%3A%22data%22%3Ba%3A2%3A%7Bs%3A5%3A%22PRICE%22%3Ba%3A2%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3B%7Ds%3A10%3A%22PRICE_OTAX%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A14%3A%22date_available%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22date_expired%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A15%3A%22sub_content_tax%22%3Ba%3A0%3A%7B%7Ds%3A17%3A%22sub_content_count%22%3Bi%3A0%3Bs%3A18%3A%22sub_content_weight%22%3Bi%3A0%3Bs%3A4%3A%22type%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22total%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A40%3A%22%3Cspan%20class%3D%22price-tag%22%3EEUR%20%200%2C00%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3Bs%3A4%3A%22data%22%3Ba%3A2%3A%7Bs%3A5%3A%22PRICE%22%3Ba%3A2%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3
    Bs%3A5%3A%22plain%22%3Bd%3A0%3B%7Ds%3A10%3A%22PRICE_OTAX%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A14%3A%22date_available%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22date_expired%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A3%3A%22tax%22%3Ba%3A0%3A%7B%7Ds%3A6%3A%22weight%22%3Bi%3A0%3Bs%3A14%3A%22total_discount%22%3Bi%3A0%3Bs%3A38%3A%22cart_total_full_for_customers_discount%22%3Bi%3A0%3Bs%3A23%3A%22cart_total_full_coupons%22%3Bi%3A0%3Bs%3A8%3A%22discount%22%3Bs%3A5%3A%22false%22%3Bs%3A15%3A%22cart_total_full%22%3Bi%3A0%3Bs%3A22%3A%22content_total_physical%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A40%3A%22%3Cspan%20class%3D%22price-tag%22%3EEUR%20%200%2C00%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3Bs%3A4%3A%22data%22%3Ba%3A2%3A%7Bs%3A5%3A%22PRICE%22%3Ba%3A2%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3B%7Ds%3A10%3A%22PRICE_OTAX%22%3Ba%3A4%3A%7Bs%3A8%3A
    %22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A14%3A%22date_available%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22date_expired%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A23%3A%22content_weight_physical%22%3Bi%3A0%3Bs%3A14%3A%22total_physical%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A40%3A%22%3Cspan%20class%3D%22price-tag%22%3EEUR%20%200%2C00%3C%2Fspan%3E%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A10%3A%22plain_otax%22%3Bd%3A0%3Bs%3A4%3A%22data%22%3Ba%3A2%3A%7Bs%3A5%3A%22PRICE%22%3Ba%3A2%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3B%7Ds%3A10%3A%22PRICE_OTAX%22%3Ba%3A4%3A%7Bs%3A8%3A%22formated%22%3Bs%3A9%3A%22EUR%20%200%2C00%22%3Bs%3A5%3A%22plain%22%3Bd%3A0%3Bs%3A14%3A%22date_available%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22date_expired%22%3Bs%3A0%3A%22%22%3B%7D%7D%7D%7Dbrotkrumen%7Cs%3A54%3A%22https%3A%2F%2Flandgang-groemitz.de%2Fde%2Freviews%2Fwrite%3Finfo%3D276%22%3Binfo_handler%7Ca%3A2%3A%7Bs%3A3%3A%22pos%22%3Bs%3A5%3A%22s
    tore%22%3Bs%3A4%3A%22data%22%3Ba%3A1%3A%7Bs%3A5%3A%22error%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A12%3A%22info_message%22%3Bs%3A59%3A%22Um%20eine%20Bewertung%20zu%20schreiben%20m%C3%BCssen%20Sie%20angemeldet%20sein.%22%3B%7D%7D%7D%7D', '', '1d4d7e0dae5fa1c8a0c0acd96d0780a8', NOW(), NOW())")
    #0 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtFramework/library/vendor/adodb/adodb-php/adodb.inc.php(1329): ADODB_Error_Handler(...)
    #1 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtFramework/library/vendor/adodb/adodb-php/adodb.inc.php(1269): _Execute(...)
    #2 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtFramework/library/adodb-xt/adodb-session2-xt.php(745): Execute(...)
    #3 (): write(...)
    #4 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtFramework/classes/class.xtLink.php(365): session_write_close(...)
    #5 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/plugins/xt_reviews/pages/reviews.php(54): _redirect(...)
    #6 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/index.php(113): include('/var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/plugins/xt_reviews/pages/reviews.php')


    SERVER_NAME => landgang-groemitz.de


    HTTP_HOST => landgang-groemitz.de


    Current Shop Id = 1
    All Stores: id: 1 - Name: landgang-groemitz.de


    see xtLogs/db_error.log

    Zitat von LANDGANG

    see xtLogs/db_error.log

    Ich denke deine error-Logs wären hier interessant, auch wenn das ja eher nach einem Fehler deiner Shop-Software schreit.

    [RS] 2000 G11 | 3x 1000 G12 Pro | 2x Vincent van Bot | Piccolo | Piccolo ARMore
    [VPS] 1000 G9 | 500 G11s | mikro G11s | 4x nano G11s | 4x piko G11s
    [WH] 8000 SE | 4000 SE | 2000 SE | 2x Spezial

    (2022-07-26 14:51:27) mysqli error: [1205: Lock wait timeout exceeded; try restarting transaction] in EXECUTE("DELETE FROM xt_sessions2 WHERE /*! BINARY */ sesskey = '7f9fbeb7708fa8b80207ff69eb854c79'")

    #0 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtFramework/library/vendor/adodb/adodb-php/adodb.inc.php(1329): ADODB_Error_Handler(...)

    #1 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtFramework/library/vendor/adodb/adodb-php/adodb.inc.php(1293): _Execute(...)

    #2 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtFramework/library/adodb-xt/adodb-session2-xt.php(834): Execute(...)

    #3 (): destroy(...)

    #4 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtCore/pages/page_action/checkout.success.php(50): session_destroy(...)

    #5 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtCore/pages/checkout.php(221): include('/var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtCore/pages/page_action/checkout.success.php')

    #6 /var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/index.php(113): include('/var/www/vhosts/hosting138334.a2e52.netcup.net/httpdocs/xtCore/pages/checkout.php')

    Schau mal hier

    Edit: aRaphael ist schnell wie eine [hier das Enten-Smiley denken]

    [RS] 2000 G11 | 3x 1000 G12 Pro | 2x Vincent van Bot | Piccolo | Piccolo ARMore
    [VPS] 1000 G9 | 500 G11s | mikro G11s | 4x nano G11s | 4x piko G11s
    [WH] 8000 SE | 4000 SE | 2000 SE | 2x Spezial

    Einmal editiert, zuletzt von Bud (4. Januar 2023 um 21:26)