Deadlock beim als gelesen Markieren

Cyperghost · Feb 18th 2022

Wir haben seit dem Update auf die Version 5.4, die wir bei einigen Kunden vorgenommen haben das Problem mit Deadlocks. Am Anfang hatte ich erst unseren Push++ Server in Vermutung, jedoch als der zweite Kunde ebenfalls kam, der aber keinen Installiert hat, konnte ich nun diesen auch ausschließen.

Und zwar tritt dies bei der Funktion wcf\system\user\notification\UserNotificationHandler::markAsConfirmed auf, in beiden Installation.

Hier sind die beiden Deadlock logs, beim ersten erkennt man das dort die Funktion des Push++ aufgerufen wird, beim zweiten ist dies aber nicht der Fall und ist auch ein anderer Kunde.

Code

2022-02-17 14:34:34 70674727 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2022-02-17 14:34:34 70674727 [Note] InnoDB:
*** (1) TRANSACTION:
TRANSACTION 15468259240, ACTIVE 0 sec starting index read
mysql tables in use 3, locked 3
LOCK WAIT 4 lock struct(s), heap size 1128, 71 row lock(s)
MySQL thread id 70674726, OS thread handle 140025800201984, query id 5662784736 2a01:4f8:fff0:4a:500::2 c01005 Searching rows for update
UPDATE  wcf1_user_notification
                SET     confirmTime = '1645104874'
                WHERE confirmTime = '0' AND eventID = '12' AND userID IN ('4290') AND objectID IN ('256235','256530','256902','257336','257379','257886','257887','257888','257891') -- '/forum/index.php?ajax-proxy/&t=8eff9e28bd3082a8681288bcbc62cb161cb9a9ce88284cbfba537359897 (wbb\\data\\thread\\ThreadPushAction:getNewPosts)'
2022-02-17 14:34:34 70674727 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 56311 page no 3980 n bits 1232 index 7d875388a2a9335d0c1ad2bfae7d8fcc_fk of table "c01005_forum"."wcf1_user_notification" trx id 15468259240 lock_mode X waiting
Record lock, heap no 621 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc04d; asc    M;;
2022-02-17 14:34:34 70674727 [Note] InnoDB: *** (2) TRANSACTION:
TRANSACTION 15468259239, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
61 lock struct(s), heap size 8312, 8445 row lock(s)
MySQL thread id 70674727, OS thread handle 140025811916544, query id 5662784711 2a01:4f8:fff0:4a:500::2 c01005 Searching rows for update
UPDATE  wcf1_user_notification
                SET     confirmTime = '1645104874'
                WHERE confirmTime = '0' AND eventID = '12' AND userID IN ('287') AND objectID IN ('256235','256260','256268','256530','256560','256563','256692','256731','256790','256902','256918','256963','257336','257373','257379','257812','257885','257886','257888','257889','257890','257891') -- '/forum/index.php?ajax-proxy/&t=b88ac91207c08e4bc8a9712b6349ceb1cf2d44bbf95ed4df113c178ebe7 (wbb\\data\\thread\\ThreadPushAction:getNewPosts)'
2022-02-17 14:34:34 70674727 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 56311 page no 3980 n bits 1232 index 7d875388a2a9335d0c1ad2bfae7d8fcc_fk of table "c01005_forum"."wcf1_user_notification" trx id 15468259239 lock_mode X
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;
Record lock, heap no 621 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc04d; asc    M;;
Record lock, heap no 622 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc04e; asc    N;;
Record lock, heap no 623 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc04f; asc    O;;
Record lock, heap no 624 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc050; asc    P;;
Record lock, heap no 625 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc051; asc    Q;;
Record lock, heap no 626 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc052; asc    R;;
Record lock, heap no 627 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc053; asc    S;;
Record lock, heap no 628 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc054; asc    T;;
Record lock, heap no 629 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc055; asc    U;;
Record lock, heap no 630 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc056; asc    V;;
Record lock, heap no 631 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc058; asc    X;;
Record lock, heap no 632 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc059; asc    Y;;
Record lock, heap no 633 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc05b; asc    [;;
Record lock, heap no 634 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc05c; asc    \;;
Record lock, heap no 635 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc05d; asc    ];;
Record lock, heap no 636 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc05e; asc    ^;;
Record lock, heap no 637 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc05f; asc    _;;
Record lock, heap no 638 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc060; asc    `;;
Record lock, heap no 639 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc061; asc    a;;
Record lock, heap no 640 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc062; asc    b;;
Record lock, heap no 641 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc063; asc    c;;
Record lock, heap no 642 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc064; asc    d;;
Record lock, heap no 643 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc065; asc    e;;
Record lock, heap no 644 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc066; asc    f;;
Record lock, heap no 645 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc067; asc    g;;
Record lock, heap no 646 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc068; asc    h;;
Record lock, heap no 647 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc069; asc    i;;
Record lock, heap no 648 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc06a; asc    j;;
Record lock, heap no 649 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc06b; asc    k;;
Record lock, heap no 650 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc06c; asc    l;;
Record lock, heap no 651 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc06d; asc    m;;
Record lock, heap no 652 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc06e; asc    n;;
Record lock, heap no 653 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc06f; asc    o;;
Record lock, heap no 654 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc070; asc    p;;
Record lock, heap no 655 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc071; asc    q;;
Record lock, heap no 656 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc072; asc    r;;
Record lock, heap no 657 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc073; asc    s;;
Record lock, heap no 658 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc074; asc    t;;
Record lock, heap no 659 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc075; asc    u;;
Record lock, heap no 660 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc08d; asc     ;;
Record lock, heap no 661 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc08e; asc     ;;
Record lock, heap no 662 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc091; asc     ;;
Record lock, heap no 663 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc092; asc     ;;
Record lock, heap no 664 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc093; asc     ;;
Record lock, heap no 665 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc094; asc     ;;
Record lock, heap no 666 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc096; asc     ;;
Record lock, heap no 667 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc097; asc     ;;
Record lock, heap no 668 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc098; asc     ;;
Record lock, heap no 669 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0a7; asc     ;;
Record lock, heap no 670 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0a8; asc     ;;
Record lock, heap no 671 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0b1; asc     ;;
Record lock, heap no 672 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0b8; asc     ;;
Record lock, heap no 673 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0b9; asc     ;;
Record lock, heap no 674 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0ba; asc     ;;
Record lock, heap no 675 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0bb; asc     ;;
Record lock, heap no 676 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0bc; asc     ;;
Record lock, heap no 677 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0bd; asc     ;;
Record lock, heap no 678 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0be; asc     ;;
Record lock, heap no 679 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0bf; asc     ;;
Record lock, heap no 680 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0c0; asc     ;;
Record lock, heap no 681 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0c1; asc     ;;
Record lock, heap no 682 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0c2; asc     ;;
Record lock, heap no 683 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0c3; asc     ;;
Record lock, heap no 684 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0c4; asc     ;;
Record lock, heap no 685 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0c5; asc     ;;
Record lock, heap no 686 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc0c6; asc     ;;
Record lock, heap no 687 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc179; asc    y;;
Record lock, heap no 688 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc17a; asc    z;;
Record lock, heap no 689 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc17b; asc    {;;
Record lock, heap no 690 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc17c; asc    |;;
Record lock, heap no 691 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc17d; asc    };;
Record lock, heap no 692 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc17e; asc    ~;;
Record lock, heap no 693 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc17f; asc     ;;
Record lock, heap no 694 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc181; asc     ;;
Record lock, heap no 695 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc184; asc     ;;
Record lock, heap no 696 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a2; asc     ;;
Record lock, heap no 697 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a3; asc     ;;
Record lock, heap no 698 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a4; asc     ;;
Record lock, heap no 699 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a5; asc     ;;
Record lock, heap no 700 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a6; asc     ;;
Record lock, heap no 701 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a7; asc     ;;
Record lock, heap no 702 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a8; asc     ;;
Record lock, heap no 703 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1a9; asc     ;;
Record lock, heap no 704 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1aa; asc     ;;
Record lock, heap no 705 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ab; asc     ;;
Record lock, heap no 706 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ac; asc     ;;
Record lock, heap no 707 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ad; asc     ;;
Record lock, heap no 708 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ae; asc     ;;
Record lock, heap no 709 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1af; asc     ;;
Record lock, heap no 710 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1b0; asc     ;;
Record lock, heap no 711 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1b1; asc     ;;
Record lock, heap no 712 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1b2; asc     ;;
Record lock, heap no 713 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1b5; asc     ;;
Record lock, heap no 714 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1b7; asc     ;;
Record lock, heap no 715 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1b8; asc     ;;
Record lock, heap no 716 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1b9; asc     ;;
Record lock, heap no 717 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ba; asc     ;;
Record lock, heap no 718 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1bb; asc     ;;
Record lock, heap no 719 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1bc; asc     ;;
Record lock, heap no 720 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1bd; asc     ;;
Record lock, heap no 721 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1be; asc     ;;
Record lock, heap no 722 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c1; asc     ;;
Record lock, heap no 723 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c2; asc     ;;
Record lock, heap no 724 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c3; asc     ;;
Record lock, heap no 725 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c4; asc     ;;
Record lock, heap no 726 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c6; asc     ;;
Record lock, heap no 727 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c7; asc     ;;
Record lock, heap no 728 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c8; asc     ;;
Record lock, heap no 729 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1c9; asc     ;;
Record lock, heap no 730 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ca; asc     ;;
Record lock, heap no 731 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1cb; asc     ;;
Record lock, heap no 732 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1cc; asc     ;;
Record lock, heap no 733 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1cd; asc     ;;
Record lock, heap no 734 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ce; asc     ;;
Record lock, heap no 735 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1cf; asc     ;;
Record lock, heap no 736 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d0; asc     ;;
Record lock, heap no 737 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d1; asc     ;;
Record lock, heap no 738 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d4; asc     ;;
Record lock, heap no 739 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d5; asc     ;;
Record lock, heap no 740 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d6; asc     ;;
Record lock, heap no 741 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d7; asc     ;;
Record lock, heap no 742 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d8; asc     ;;
Record lock, heap no 743 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1d9; asc     ;;
Record lock, heap no 744 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1da; asc     ;;
Record lock, heap no 745 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1db; asc     ;;
Record lock, heap no 746 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1dc; asc     ;;
Record lock, heap no 747 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1dd; asc     ;;
Record lock, heap no 748 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1de; asc     ;;
Record lock, heap no 749 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1df; asc     ;;
Record lock, heap no 750 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e0; asc     ;;
Record lock, heap no 751 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e1; asc     ;;
Record lock, heap no 752 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e2; asc     ;;
Record lock, heap no 753 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e3; asc     ;;
Record lock, heap no 754 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e4; asc     ;;
Record lock, heap no 755 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e5; asc     ;;
Record lock, heap no 756 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e7; asc     ;;
Record lock, heap no 757 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1e8; asc     ;;
Record lock, heap no 758 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ef; asc     ;;
Record lock, heap no 759 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1f0; asc     ;;
Record lock, heap no 760 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1f2; asc     ;;
Record lock, heap no 761 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1f3; asc     ;;
Record lock, heap no 762 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1f4; asc     ;;
Record lock, heap no 763 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1f5; asc     ;;
Record lock, heap no 764 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1f6; asc     ;;
Record lock, heap no 765 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1f7; asc     ;;
Record lock, heap no 766 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1fc; asc     ;;
Record lock, heap no 767 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1fd; asc     ;;
Record lock, heap no 768 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1fe; asc     ;;
Record lock, heap no 769 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc1ff; asc     ;;
Record lock, heap no 770 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc200; asc     ;;
Record lock, heap no 771 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc201; asc     ;;
Record lock, heap no 772 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc202; asc     ;;
Record lock, heap no 773 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc203; asc     ;;
Record lock, heap no 774 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc204; asc     ;;
Record lock, heap no 775 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc205; asc     ;;
Record lock, heap no 776 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc206; asc     ;;
Record lock, heap no 777 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc207; asc     ;;
Record lock, heap no 778 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc208; asc     ;;
Record lock, heap no 779 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc209; asc     ;;
Record lock, heap no 780 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc20a; asc     ;;
Record lock, heap no 781 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc20b; asc     ;;
Record lock, heap no 782 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc20c; asc     ;;
Record lock, heap no 783 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc20d; asc     ;;
Record lock, heap no 784 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc20e; asc     ;;
Record lock, heap no 785 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc20f; asc     ;;
Record lock, heap no 786 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc210; asc     ;;
Record lock, heap no 787 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc211; asc     ;;
Record lock, heap no 788 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc212; asc     ;;
Record lock, heap no 789 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc213; asc     ;;
Record lock, heap no 790 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc214; asc     ;;
Record lock, heap no 791 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc215; asc     ;;
Record lock, heap no 792 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc216; asc     ;;
Record lock, heap no 793 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc217; asc     ;;
Record lock, heap no 794 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc218; asc     ;;
Record lock, heap no 795 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc219; asc     ;;
Record lock, heap no 796 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc21a; asc     ;;
Record lock, heap no 797 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc21b; asc     ;;
Record lock, heap no 798 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc21c; asc     ;;
Record lock, heap no 799 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc21d; asc     ;;
Record lock, heap no 800 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc21e; asc     ;;
Record lock, heap no 801 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc21f; asc     ;;
Record lock, heap no 802 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc220; asc     ;;
Record lock, heap no 803 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc221; asc    !;;
Record lock, heap no 804 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc222; asc    ";;
Record lock, heap no 805 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc223; asc    #;;
Record lock, heap no 806 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc224; asc    $;;
Record lock, heap no 807 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc225; asc    %;;
Record lock, heap no 808 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc226; asc    &;;
Record lock, heap no 809 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc227; asc    ';;
Record lock, heap no 810 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc228; asc    (;;
Record lock, heap no 811 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc229; asc    );;
Record lock, heap no 812 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc22a; asc    *;;
Record lock, heap no 813 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc22b; asc    +;;
Record lock, heap no 814 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc22c; asc    ,;;
Record lock, heap no 815 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc22d; asc    -;;
Record lock, heap no 816 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc22e; asc    .;;
Record lock, heap no 817 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc22f; asc    /;;
Record lock, heap no 818 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc230; asc    0;;
Record lock, heap no 819 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc231; asc    1;;
Record lock, heap no 820 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc232; asc    2;;
Record lock, heap no 821 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc233; asc    3;;
Record lock, heap no 822 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc234; asc    4;;
Record lock, heap no 823 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc235; asc    5;;
Record lock, heap no 824 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc236; asc    6;;
Record lock, heap no 825 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc237; asc    7;;
Record lock, heap no 826 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc238; asc    8;;
Record lock, heap no 827 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc239; asc    9;;
Record lock, heap no 828 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc23a; asc    :;;
Record lock, heap no 829 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc23b; asc    ;;;
Record lock, heap no 830 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc23c; asc    <;;
Record lock, heap no 831 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc23d; asc    =;;
Record lock, heap no 832 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc23e; asc    >;;
Record lock, heap no 833 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc23f; asc    ?;;
Record lock, heap no 834 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc240; asc    @;;
Record lock, heap no 835 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc241; asc    A;;
Record lock, heap no 836 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc242; asc    B;;
Record lock, heap no 837 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc243; asc    C;;
Record lock, heap no 838 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc244; asc    D;;
Record lock, heap no 839 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc245; asc    E;;
Record lock, heap no 840 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc246; asc    F;;
Record lock, heap no 841 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc247; asc    G;;
Record lock, heap no 842 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc248; asc    H;;
Record lock, heap no 843 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc249; asc    I;;
Record lock, heap no 844 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc24a; asc    J;;
Record lock, heap no 845 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc24b; asc    K;;
Record lock, heap no 846 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc24c; asc    L;;
Record lock, heap no 847 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc24d; asc    M;;
Record lock, heap no 848 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc24e; asc    N;;
Record lock, heap no 849 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc24f; asc    O;;
Record lock, heap no 850 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc250; asc    P;;
Record lock, heap no 851 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc251; asc    Q;;
Record lock, heap no 852 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc252; asc    R;;
Record lock, heap no 853 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc253; asc    S;;
Record lock, heap no 854 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc254; asc    T;;
Record lock, heap no 855 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc255; asc    U;;
Record lock, heap no 856 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc256; asc    V;;
Record lock, heap no 857 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc257; asc    W;;
Record lock, heap no 858 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc258; asc    X;;
Record lock, heap no 859 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc259; asc    Y;;
Record lock, heap no 860 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc25a; asc    Z;;
Record lock, heap no 861 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc25b; asc    [;;
Record lock, heap no 862 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc25c; asc    \;;
Record lock, heap no 863 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc25d; asc    ];;
Record lock, heap no 864 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc25e; asc    ^;;
Record lock, heap no 865 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc25f; asc    _;;
Record lock, heap no 866 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc260; asc    `;;
Record lock, heap no 867 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc261; asc    a;;
Record lock, heap no 868 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc262; asc    b;;
Record lock, heap no 869 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc263; asc    c;;
Record lock, heap no 870 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc264; asc    d;;
Record lock, heap no 871 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc265; asc    e;;
Record lock, heap no 872 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc266; asc    f;;
Record lock, heap no 873 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc267; asc    g;;
Record lock, heap no 874 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc268; asc    h;;
Record lock, heap no 875 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc269; asc    i;;
Record lock, heap no 876 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc26a; asc    j;;
Record lock, heap no 877 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc26b; asc    k;;
Record lock, heap no 878 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc26c; asc    l;;
Record lock, heap no 879 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc26d; asc    m;;
Record lock, heap no 880 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc26e; asc    n;;
Record lock, heap no 881 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc26f; asc    o;;
Record lock, heap no 882 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc270; asc    p;;
Record lock, heap no 883 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc271; asc    q;;
Record lock, heap no 884 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc272; asc    r;;
Record lock, heap no 885 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc273; asc    s;;
Record lock, heap no 886 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc274; asc    t;;
Record lock, heap no 887 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc275; asc    u;;
Record lock, heap no 888 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc276; asc    v;;
Record lock, heap no 889 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc277; asc    w;;
Record lock, heap no 890 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc278; asc    x;;
Record lock, heap no 891 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc279; asc    y;;
Record lock, heap no 892 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc27a; asc    z;;
Record lock, heap no 893 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc27b; asc    {;;
Record lock, heap no 894 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc27c; asc    |;;
Record lock, heap no 895 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc27d; asc    };;
Record lock, heap no 896 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc27e; asc    ~;;
Record lock, heap no 897 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc27f; asc     ;;
Record lock, heap no 898 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc280; asc     ;;
Record lock, heap no 899 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc281; asc     ;;
Record lock, heap no 900 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc282; asc     ;;
Record lock, heap no 901 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc283; asc     ;;
Record lock, heap no 902 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc284; asc     ;;
Record lock, heap no 903 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc285; asc     ;;
Record lock, heap no 904 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc286; asc     ;;
Record lock, heap no 905 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc287; asc     ;;
Record lock, heap no 906 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc288; asc     ;;
Record lock, heap no 907 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc289; asc     ;;
Record lock, heap no 908 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc28a; asc     ;;
Record lock, heap no 909 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc28b; asc     ;;
Record lock, heap no 910 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc28c; asc     ;;
Record lock, heap no 911 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc28d; asc     ;;
Record lock, heap no 912 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc28e; asc     ;;
Record lock, heap no 913 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc28f; asc     ;;
Record lock, heap no 914 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc290; asc     ;;
Record lock, heap no 915 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc291; asc     ;;
Record lock, heap no 916 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc292; asc     ;;
Record lock, heap no 917 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc293; asc     ;;
Record lock, heap no 918 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc294; asc     ;;
Record lock, heap no 919 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc295; asc     ;;
Record lock, heap no 920 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc296; asc     ;;
Record lock, heap no 921 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc297; asc     ;;
Record lock, heap no 922 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc298; asc     ;;
Record lock, heap no 923 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc299; asc     ;;
Record lock, heap no 924 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc29a; asc     ;;
Record lock, heap no 925 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc29b; asc     ;;
Record lock, heap no 926 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc29c; asc     ;;
Record lock, heap no 927 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc29d; asc     ;;
Record lock, heap no 928 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc29e; asc     ;;
Record lock, heap no 929 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc29f; asc     ;;
Record lock, heap no 930 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a0; asc     ;;
Record lock, heap no 931 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a1; asc     ;;
Record lock, heap no 932 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a2; asc     ;;
Record lock, heap no 933 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a3; asc     ;;
Record lock, heap no 934 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a4; asc     ;;
Record lock, heap no 935 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a5; asc     ;;
Record lock, heap no 936 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a6; asc     ;;
Record lock, heap no 937 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a7; asc     ;;
Record lock, heap no 938 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a8; asc     ;;
Record lock, heap no 939 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2a9; asc     ;;
Record lock, heap no 940 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2aa; asc     ;;
Record lock, heap no 941 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ab; asc     ;;
Record lock, heap no 942 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ac; asc     ;;
Record lock, heap no 943 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ad; asc     ;;
Record lock, heap no 944 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ae; asc     ;;
Record lock, heap no 945 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2af; asc     ;;
Record lock, heap no 946 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b0; asc     ;;
Record lock, heap no 947 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b1; asc     ;;
Record lock, heap no 948 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b2; asc     ;;
Record lock, heap no 949 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b3; asc     ;;
Record lock, heap no 950 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b4; asc     ;;
Record lock, heap no 951 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b5; asc     ;;
Record lock, heap no 952 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b6; asc     ;;
Record lock, heap no 953 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b7; asc     ;;
Record lock, heap no 954 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b8; asc     ;;
Record lock, heap no 955 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2b9; asc     ;;
Record lock, heap no 956 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ba; asc     ;;
Record lock, heap no 957 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2bb; asc     ;;
Record lock, heap no 958 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2bc; asc     ;;
Record lock, heap no 959 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2bd; asc     ;;
Record lock, heap no 960 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2be; asc     ;;
Record lock, heap no 961 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2bf; asc     ;;
Record lock, heap no 962 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c0; asc     ;;
Record lock, heap no 963 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c1; asc     ;;
Record lock, heap no 964 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c2; asc     ;;
Record lock, heap no 965 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c3; asc     ;;
Record lock, heap no 966 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c4; asc     ;;
Record lock, heap no 967 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c5; asc     ;;
Record lock, heap no 968 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c6; asc     ;;
Record lock, heap no 969 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c7; asc     ;;
Record lock, heap no 970 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c8; asc     ;;
Record lock, heap no 971 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2c9; asc     ;;
Record lock, heap no 972 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ca; asc     ;;
Record lock, heap no 973 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2cb; asc     ;;
Record lock, heap no 974 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2cc; asc     ;;
Record lock, heap no 975 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2cd; asc     ;;
Record lock, heap no 976 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ce; asc     ;;
Record lock, heap no 977 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2cf; asc     ;;
Record lock, heap no 978 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d0; asc     ;;
Record lock, heap no 979 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d1; asc     ;;
Record lock, heap no 980 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d2; asc     ;;
Record lock, heap no 981 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d3; asc     ;;
Record lock, heap no 982 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d4; asc     ;;
Record lock, heap no 983 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d5; asc     ;;
Record lock, heap no 984 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d6; asc     ;;
Record lock, heap no 985 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d7; asc     ;;
Record lock, heap no 986 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d8; asc     ;;
Record lock, heap no 987 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2d9; asc     ;;
Record lock, heap no 988 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2da; asc     ;;
Record lock, heap no 989 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2db; asc     ;;
Record lock, heap no 990 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2dc; asc     ;;
Record lock, heap no 991 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2dd; asc     ;;
Record lock, heap no 992 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2de; asc     ;;
Record lock, heap no 993 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2df; asc     ;;
Record lock, heap no 994 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e0; asc     ;;
Record lock, heap no 995 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e1; asc     ;;
Record lock, heap no 996 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e2; asc     ;;
Record lock, heap no 997 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e3; asc     ;;
Record lock, heap no 998 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e4; asc     ;;
Record lock, heap no 999 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e5; asc     ;;
Record lock, heap no 1000 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e6; asc     ;;
Record lock, heap no 1001 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e7; asc     ;;
Record lock, heap no 1002 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e8; asc     ;;
Record lock, heap no 1003 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2e9; asc     ;;
Record lock, heap no 1004 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ea; asc     ;;
Record lock, heap no 1005 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2eb; asc     ;;
Record lock, heap no 1006 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ec; asc     ;;
Record lock, heap no 1007 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ed; asc     ;;
Record lock, heap no 1008 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ee; asc     ;;
Record lock, heap no 1009 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2ef; asc     ;;
Record lock, heap no 1010 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2f0; asc     ;;
Record lock, heap no 1011 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2f1; asc     ;;
Record lock, heap no 1012 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2f2; asc     ;;
Record lock, heap no 1013 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2f3; asc     ;;
Record lock, heap no 1014 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000000c; asc     ;;
 1: len 4; hex 800fc2f4; asc     ;;
2022-02-17 14:34:34 70674727 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 56311 page no 4594 n bits 192 index PRIMARY of table "c01005_forum"."wcf1_user_notification" trx id 15468259239 lock_mode X locks rec but not gap waiting
Record lock, heap no 44 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 800fda68; asc    h;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 4; hex 80000004; asc     ;;
 4: len 4; hex 8000000c; asc     ;;
 5: len 4; hex 8003ed0e; asc     ;;
 6: len 4; hex 80000000; asc     ;;
 7: len 30; hex 353431383633393732633266313133656330353061633365373361383933; asc 541863972c2f113ec050ac3e73a893; (total 40 bytes);
 8: len 4; hex 8000139c; asc     ;;
 9: len 4; hex 80000008; asc     ;;
 10: len 4; hex 80000000; asc     ;;
 11: len 4; hex 800010c2; asc     ;;
 12: len 4; hex e2085138; asc   Q8;;
 13: len 1; hex 81; asc  ;;
 14: len 4; hex 80000000; asc     ;;
 15: len 6; hex 613a303a7b7d; asc a:0:{};;
2022-02-17 14:34:34 70674727 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)

Display More

Code

2022-02-16 16:55:07 69478210 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2022-02-16 16:55:07 69478210 [Note] InnoDB:
*** (1) TRANSACTION:
TRANSACTION 15456944144, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
LOCK WAIT 96 lock struct(s), heap size 24696, 497 row lock(s)
MySQL thread id 69478207, OS thread handle 140024254281472, query id 5565768169 2a01:4f8:fff0:4a:5600::2 beatrice Searching rows for update
UPDATE  wcf2_user_notification
                SET     confirmTime = '1645026910'
                WHERE confirmTime = '0' AND eventID = '11' AND userID IN ('36') AND objectID IN ('3291493','3291606') -- '/index.php?ajax-proxy/&t=b7c25c5a068115f5dad3fad1b3f004b2db5fd28f3877cb1fd38750bf848ce0a4- (wbb\\data\\post\\PostAction:quickReply)'
2022-02-16 16:55:07 69478210 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 217519 page no 952 n bits 208 index PRIMARY of table "beatrice_community"."wcf2_user_notification" trx id 15456944144 lock_mode X locks rec but not gap waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80ea1ac1; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 4; hex 80000004; asc     ;;
 4: len 4; hex 8000000b; asc     ;;
 5: len 4; hex 8032150d; asc  2  ;;
 6: len 4; hex 80000000; asc     ;;
 7: len 30; hex 303236663362633666343939363132306164323337626562313432656139; asc 026f3bc6f4996120ad237beb142ea9; (total 40 bytes);
 8: len 4; hex 800039b5; asc   9 ;;
 9: len 4; hex 80000001; asc     ;;
 10: len 4; hex 80000000; asc     ;;
 11: len 4; hex 8000348f; asc   4 ;;
 12: len 4; hex e1fc3eaa; asc   > ;;
 13: len 1; hex 81; asc  ;;
 14: len 4; hex 80000000; asc     ;;
 15: len 6; hex 613a303a7b7d; asc a:0:{};;
2022-02-16 16:55:07 69478210 [Note] InnoDB: *** (2) TRANSACTION:
TRANSACTION 15456944143, ACTIVE 0 sec starting index read
mysql tables in use 2, locked 2
738 lock struct(s), heap size 90232, 11915 row lock(s)
MySQL thread id 69478210, OS thread handle 140025811916544, query id 5565768166 2a01:4f8:fff0:4a:5600::2 beatrice Updating
DELETE FROM wcf2_user_notification_to_user
                    WHERE       notificationID NOT IN (
                                    SELECT  notificationID
                                    FROM    wcf2_user_notification
                                    WHERE   confirmTime = '0'
                                ) -- '/index.php?ajax-proxy/&t=ec37299cc8fcd2eb522bcf3b56c2fe93930d51c1c46452c3cdcf702a7d287a75- (wbb\\data\\post\\PostAction:quickReply)'
2022-02-16 16:55:07 69478210 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 217519 page no 952 n bits 208 index PRIMARY of table "beatrice_community"."wcf2_user_notification" trx id 15456944143 lock mode S locks rec but not gap
Record lock, heap no 13 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80ea1ac1; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 4; hex 80000004; asc     ;;
 4: len 4; hex 8000000b; asc     ;;
 5: len 4; hex 8032150d; asc  2  ;;
 6: len 4; hex 80000000; asc     ;;
 7: len 30; hex 303236663362633666343939363132306164323337626562313432656139; asc 026f3bc6f4996120ad237beb142ea9; (total 40 bytes);
 8: len 4; hex 800039b5; asc   9 ;;
 9: len 4; hex 80000001; asc     ;;
 10: len 4; hex 80000000; asc     ;;
 11: len 4; hex 8000348f; asc   4 ;;
 12: len 4; hex e1fc3eaa; asc   > ;;
 13: len 1; hex 81; asc  ;;
 14: len 4; hex 80000000; asc     ;;
 15: len 6; hex 613a303a7b7d; asc a:0:{};;
Record lock, heap no 16 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80ea1ac4; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 4; hex 80000004; asc     ;;
 4: len 4; hex 80000013; asc     ;;
 5: len 4; hex 80012573; asc   %s;;
 6: len 4; hex 80000000; asc     ;;
 7: len 30; hex 383466303832346137633334346465316634353835303831343030346233; asc 84f0824a7c344de1f45850814004b3; (total 40 bytes);
 8: len 4; hex 8000396a; asc   9j;;
 9: len 4; hex 80000001; asc     ;;
 10: len 4; hex 80000000; asc     ;;
 11: len 4; hex 80000cf5; asc     ;;
 12: len 4; hex e1fc3ebf; asc   > ;;
 13: len 1; hex 81; asc  ;;
 14: len 4; hex 80000000; asc     ;;
 15: len 6; hex 613a303a7b7d; asc a:0:{};;
Record lock, heap no 17 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80ea1ac5; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 4; hex 80000004; asc     ;;
 4: len 4; hex 80000013; asc     ;;
 5: len 4; hex 80012573; asc   %s;;
 6: len 4; hex 80000000; asc     ;;
 7: len 30; hex 383466303832346137633334346465316634353835303831343030346233; asc 84f0824a7c344de1f45850814004b3; (total 40 bytes);
 8: len 4; hex 8000396a; asc   9j;;
 9: len 4; hex 80000001; asc     ;;
 10: len 4; hex 80000000; asc     ;;
 11: len 4; hex 800038a8; asc   8 ;;
 12: len 4; hex e1fc3ebf; asc   > ;;
 13: len 1; hex 81; asc  ;;
 14: len 4; hex 80000000; asc     ;;
 15: len 6; hex 613a303a7b7d; asc a:0:{};;
2022-02-16 16:55:07 69478210 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 217519 page no 557 n bits 144 index PRIMARY of table "beatrice_community"."wcf2_user_notification" trx id 15456944143 lock mode S locks rec but not gap waiting
Record lock, heap no 32 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80eba905; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 4; hex 80000004; asc     ;;
 4: len 4; hex 80000009; asc     ;;
 5: len 4; hex 803239db; asc  29 ;;
 6: len 4; hex 80000000; asc     ;;
 7: len 30; hex 333938626233356130376634303036363639633861323734386533656235; asc 398bb35a07f4006669c8a2748e3eb5; (total 40 bytes);
 8: len 4; hex 8000033b; asc    ;;;
 9: len 4; hex 80000002; asc     ;;
 10: len 4; hex 80000000; asc     ;;
 11: len 4; hex 80000024; asc    $;;
 12: len 4; hex e20d1dcc; asc     ;;
 13: len 1; hex 81; asc  ;;
 14: len 4; hex 80000000; asc     ;;
 15: len 6; hex 613a303a7b7d; asc a:0:{};;
2022-02-16 16:55:07 69478210 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)

Display More

Hier zu noch den Error Log aus dem WSC, sofern benötigt

Requested URL: POST /forum/index.php?ajax-proxy/&t=8eff9e28bd3082a8681288bcbc62cb161cb9a9ce88284cbfba5373598970a14a-4lrtG3otW6pw5qwT54DoFQ==

Referrer: https://www.xxx/forum/thread/1642-welches-spiel-spielt-ihr-aktuell/?postID=257812

Error Message: Could not execute statement 'UPDATE wcf1_user_notification SET confirmTime = ? WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?)'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /storagepool/c01005/htdocs/xxx/lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1: 1645104874

Query Parameter 2: 0

Query Parameter 3: 12

Query Parameter 4: 4290

Query Parameter 5: 256235

Query Parameter 6: 256530

Query Parameter 7: 256902

Query Parameter 8: 257336

Query Parameter 9: 257379

Query Parameter 10: 257886

Query Parameter 11: 257887

Query Parameter 12: 257888

Query Parameter 13: 257891

Stacktrace

/storagepool/c01005/htdocs/xxx/lib/system/user/notification/UserNotificationHandler.class.php (925): wcf\system\database\statement\PreparedStatement->execute(…)
/storagepool/c01005/htdocs/xxx/forum/lib/data/thread/ThreadAction.class.php (481): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
/storagepool/c01005/htdocs/xxx/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadAction->markAsRead(…)
/storagepool/c01005/htdocs/xxx/forum/lib/data/thread/ThreadPushAction.class.php (106): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/xxx/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadPushAction->getNewPosts(…)
/storagepool/c01005/htdocs/xxx/lib/action/AJAXProxyAction.class.php (86): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/xxx/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/storagepool/c01005/htdocs/xxx/lib/action/AbstractAction.class.php (53): wcf\action\AJAXInvokeAction->execute(…)
/storagepool/c01005/htdocs/xxx/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/storagepool/c01005/htdocs/xxx/lib/system/request/Request.class.php (89): wcf\action\AJAXInvokeAction->__run(…)
/storagepool/c01005/htdocs/xxx/lib/system/request/RequestHandler.class.php (119): wcf\system\request\Request->execute(…)
/storagepool/c01005/htdocs/xxx/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

Type: PDOException

File (Line): /storagepool/c01005/htdocs/xxx/lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/storagepool/c01005/htdocs/xxx/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/storagepool/c01005/htdocs/xxx/lib/system/user/notification/UserNotificationHandler.class.php (925): wcf\system\database\statement\PreparedStatement->execute(…)
/storagepool/c01005/htdocs/xxx/forum/lib/data/thread/ThreadAction.class.php (481): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
/storagepool/c01005/htdocs/xxx/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadAction->markAsRead(…)
/storagepool/c01005/htdocs/xxx/forum/lib/data/thread/ThreadPushAction.class.php (106): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/xxx/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadPushAction->getNewPosts(…)
/storagepool/c01005/htdocs/xxx/lib/action/AJAXProxyAction.class.php (86): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/xxx/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/storagepool/c01005/htdocs/xxx/lib/action/AbstractAction.class.php (53): wcf\action\AJAXInvokeAction->execute(…)
/storagepool/c01005/htdocs/xxx/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/storagepool/c01005/htdocs/xxx/lib/system/request/Request.class.php (89): wcf\action\AJAXInvokeAction->__run(…)
/storagepool/c01005/htdocs/xxx/lib/system/request/RequestHandler.class.php (119): wcf\system\request\Request->execute(…)
/storagepool/c01005/htdocs/xxx/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)

<<<<<<<<b8de1ab5e841b379f5c3f51da0cb3b195b5bef09<<<<
Thu, 17 Feb 2022 13:34:34 +0000
Message: Could not execute statement 'UPDATE  wcf1_user_notification                 SET     confirmTime = ?                 WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?)'
PHP version: 8.0.14
WoltLab Suite version: 5.4.14
Request URI: POST /forum/index.php?ajax-proxy/&t=8eff9e28bd3082a8681288bcbc62cb161cb9a9ce88284cbfba5373598970a14a-4lrtG3otW6pw5qwT54DoFQ==
Referrer: https://www.xxx/forum/thread/1642-welches-spiel-spielt-ihr-aktuell/?postID=257812
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36
Peak Memory Usage: 10098544/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'UPDATE  wcf1_user_notification                 SET     confirmTime = ?                 WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?)'
Error Code: 40001
File: /storagepool/c01005/htdocs/xxx/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YToxMzp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7aToxNjQ1MTA0ODc0O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjA7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO2k6MTI7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6NDI5MDt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7aToyNTYyMzU7fWk6NTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNiI7aToxO2k6MjU2NTMwO31pOjY7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDciO2k6MTtpOjI1NjkwMjt9aTo3O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA4IjtpOjE7aToyNTczMzY7fWk6ODthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgOSI7aToxO2k6MjU3Mzc5O31pOjk7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEwIjtpOjE7aToyNTc4ODY7fWk6MTA7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDExIjtpOjE7aToyNTc4ODc7fWk6MTE7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEyIjtpOjE7aToyNTc4ODg7fWk6MTI7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEzIjtpOjE7aToyNTc4OTE7fX0=
Stack Trace: [{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":925,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/forum\/lib\/data\/thread\/ThreadAction.class.php","line":481,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/forum\/lib\/data\/thread\/ThreadPushAction.class.php","line":106,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"getNewPosts","class":"wbb\\data\\thread\\ThreadPushAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AJAXProxyAction.class.php","line":86,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/forum\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
Error Code: 40001
File: /storagepool/c01005/htdocs/xxx/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":925,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/forum\/lib\/data\/thread\/ThreadAction.class.php","line":481,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/forum\/lib\/data\/thread\/ThreadPushAction.class.php","line":106,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"getNewPosts","class":"wbb\\data\\thread\\ThreadPushAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AJAXProxyAction.class.php","line":86,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/xxx\/forum\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
<<<<

**Tim Düsterhus** · Feb 18th 2022

Hallo,

Deadlock-Meldungen mit den passenden Log-Einträgen. Ein Traum

Das kann möglicherweise ein Fehler in deinem Plugin sein. Ich kann gerne mal reinschauen, wenn du mir den Plugin-Store-Eintrag verlinkst.
Der Deadlock ist mir bereits „notorisch bekannt“, den bekommt man aber nicht weg, solange die user_notification_to_user-Tabelle existiert. Ich habe für WoltLab Suite 5.4 schon versucht die Chance dafür mit diesem Commit zu reduzieren: https://github.com/WoltLab/WCF…473328940ea2359f431de581f. Mit WoltLab Suite 6.0 wird die Tabelle spätestens entfernt werden.

jens1o · Feb 18th 2022

Quote from Tim Düsterhus

Der Deadlock ist mir bereits „notorisch bekannt“, den bekommt man aber nicht weg, solange die user_notification_to_user-Tabelle existiert.

Falls du etwas Zeit übrig hast... kannst du mir erklären, wieso dieser Deadlock auftritt? Eventuell sollte ich schauen, dass ich Plugins von mir ggf. anpasse…

Ich interpretiere aus dem Log, dass InnoDB nicht damit klarkommt, wenn relativ gleichzeitig Spalten gelöscht werden (DELETE) und dieselben auch abgeändert werden sollen (UPDATE). Aber wieso kommt es zu einem unausweislichen Deadlock? Gibt es keine fortlaufende Query-ID anhand man abwägen kann welche Query zuerst ausgeführt werden soll?

Cyperghost · Feb 18th 2022

Quote from Tim Düsterhus

Der Deadlock ist mir bereits „notorisch bekannt“, den bekommt man aber nicht weg, solange die user_notification_to_user-Tabelle existiert. Ich habe für WoltLab Suite 5.4 schon versucht die Chance dafür mit diesem Commit zu reduzieren: https://github.com/WoltLab/WCF…473328940ea2359f431de581f. Mit WoltLab Suite 6.0 wird die Tabelle spätestens entfernt werden.

Es handelt sich um folgendes Plugin was die Fehler verursacht

File

Push++ WBB/WSF Integration

Cyperghost

Sep 26th 2022

Und das hier ist natürlich die Basis davon, falls relevant

File

Push++

Push ++ is a push server that does not require any additional systems or servers to use. Say: No Java or Javascript.

Cyperghost

Sep 26th 2022

**Tim Düsterhus** · Feb 18th 2022

Hallo,

Quote from jens1o

Falls du etwas Zeit übrig hast... kannst du mir erklären, wieso dieser Deadlock auftritt? Eventuell sollte ich schauen, dass ich Plugins von mir ggf. anpasse…

Die ganze Thematik ist etwas, über das man Vorlesungen an der Universität besucht, das hier in einem Forenbeitrag verständlich herunterzubrechen ist kaum möglich

Die kurze Zusammenfassung ist aber: MySQL führt Queries parallel aus und Queries locken nicht atomar. Entsprechend gibt es kein „zuerst ausführen“.

Quote from Cyperghost

Es handelt sich um folgendes Plugin was die Fehler verursacht

Danke, schaue ich mir bei Gelegenheit an.

**Tim Düsterhus** · Feb 18th 2022

Hallo,

Quote from Cyperghost

eventID = '12'

Cyperghost Kannst du mir für die Instanz sagen, welches Notification-Event das ist?

Cyperghost · Feb 18th 2022

Quote from Tim Düsterhus

Hallo,
Cyperghost Kannst du mir für die Instanz sagen, welches Notification-Event das ist?

Reicht dir Post und wbb\system\user\notification\event\PostUserNotificationEvent

**Tim Düsterhus** · Feb 18th 2022

Hallo,

ja, danke. In dem Fall kein Fehler in deinem Plugin. Die entsprechende Code-Stelle in unserem Code ist mit 5.5 aus anderen Gründen schon neu geschrieben und nach meiner ersten Beurteilung nicht mehr von einem Deadlock betroffen.

PoooMukkel · Feb 22nd 2022

Ich oute mich hier mal als jemand, der von dem Fehler betroffen ist.

Nachdem Cyperghost alle seine Versuche, den Fehler zu beheben, rückgängig gemacht und dieses Thema hier erstellt hat, treten diese Deadlock-Fehler nun wieder mehrfach am Tag auf.

Requested URL: POST /forum/index.php?ajax-proxy/&t=10e58ae544249f6dddeee772770c86c26e90d92453fa1f3dc43a3bc1d632858a-ecetUziKmlDywB/WDT/l/Q==

Referrer: https://www.compiware-forum.de/forum/thread/1900-was-hast-du-dir-aktuell-gekauft/?pageNo=408

Error Message: Could not execute statement 'UPDATE wcf1_user_notification SET confirmTime = ? WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?,?,?)'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /storagepool/c01005/htdocs/compiware-forum.de/lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1: 1645470759

Query Parameter 2: 0

Query Parameter 3: 13

Query Parameter 4: 11102

Query Parameter 5: 258562

Query Parameter 6: 258563

Query Parameter 7: 258564

Query Parameter 8: 258567

Query Parameter 9: 258569

Query Parameter 10: 258572

Query Parameter 11: 258585

Query Parameter 12: 258592

Query Parameter 13: 258593

Query Parameter 14: 258597

Query Parameter 15: 258598

Stacktrace

/storagepool/c01005/htdocs/compiware-forum.de/lib/system/user/notification/UserNotificationHandler.class.php (925): wcf\system\database\statement\PreparedStatement->execute(…)
/storagepool/c01005/htdocs/compiware-forum.de/forum/lib/data/thread/ThreadAction.class.php (481): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadAction->markAsRead(…)
/storagepool/c01005/htdocs/compiware-forum.de/forum/lib/data/thread/ThreadPushAction.class.php (106): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadPushAction->getNewPosts(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AJAXProxyAction.class.php (86): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AbstractAction.class.php (53): wcf\action\AJAXInvokeAction->execute(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/system/request/Request.class.php (89): wcf\action\AJAXInvokeAction->__run(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/system/request/RequestHandler.class.php (119): wcf\system\request\Request->execute(…)
/storagepool/c01005/htdocs/compiware-forum.de/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

Type: PDOException

File (Line): /storagepool/c01005/htdocs/compiware-forum.de/lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/storagepool/c01005/htdocs/compiware-forum.de/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/system/user/notification/UserNotificationHandler.class.php (925): wcf\system\database\statement\PreparedStatement->execute(…)
/storagepool/c01005/htdocs/compiware-forum.de/forum/lib/data/thread/ThreadAction.class.php (481): wcf\system\user\notification\UserNotificationHandler->markAsConfirmed(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadAction->markAsRead(…)
/storagepool/c01005/htdocs/compiware-forum.de/forum/lib/data/thread/ThreadPushAction.class.php (106): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/data/AbstractDatabaseObjectAction.class.php (216): wbb\data\thread\ThreadPushAction->getNewPosts(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AJAXProxyAction.class.php (86): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AbstractAction.class.php (53): wcf\action\AJAXInvokeAction->execute(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/system/request/Request.class.php (89): wcf\action\AJAXInvokeAction->__run(…)
/storagepool/c01005/htdocs/compiware-forum.de/lib/system/request/RequestHandler.class.php (119): wcf\system\request\Request->execute(…)
/storagepool/c01005/htdocs/compiware-forum.de/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)

Mon, 21 Feb 2022 19:12:39 +0000
Message: Could not execute statement 'UPDATE  wcf1_user_notification                 SET     confirmTime = ?                 WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?,?,?)'
PHP version: 8.0.14
WoltLab Suite version: 5.4.14
Request URI: POST /forum/index.php?ajax-proxy/&t=10e58ae544249f6dddeee772770c86c26e90d92453fa1f3dc43a3bc1d632858a-ecetUziKmlDywB/WDT/l/Q==
Referrer: https://www.compiware-forum.de/forum/thread/1900-was-hast-du-dir-aktuell-gekauft/?pageNo=408
User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.99 Safari/537.36
Peak Memory Usage: 9945576/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'UPDATE  wcf1_user_notification                 SET     confirmTime = ?                 WHERE confirmTime = ? AND eventID = ? AND userID IN (?) AND objectID IN (?,?,?,?,?,?,?,?,?,?,?)'
Error Code: 40001
File: /storagepool/c01005/htdocs/compiware-forum.de/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YToxNTp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7aToxNjQ1NDcwNzU5O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjA7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO2k6MTM7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6MTExMDI7fWk6NDthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNSI7aToxO2k6MjU4NTYyO31pOjU7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDYiO2k6MTtpOjI1ODU2Mzt9aTo2O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA3IjtpOjE7aToyNTg1NjQ7fWk6NzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgOCI7aToxO2k6MjU4NTY3O31pOjg7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDkiO2k6MTtpOjI1ODU2OTt9aTo5O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMCI7aToxO2k6MjU4NTcyO31pOjEwO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMSI7aToxO2k6MjU4NTg1O31pOjExO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMiI7aToxO2k6MjU4NTkyO31pOjEyO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMyI7aToxO2k6MjU4NTkzO31pOjEzO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxNCI7aToxO2k6MjU4NTk3O31pOjE0O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxNSI7aToxO2k6MjU4NTk4O319
Stack Trace: [{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":925,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/forum\/lib\/data\/thread\/ThreadAction.class.php","line":481,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/forum\/lib\/data\/thread\/ThreadPushAction.class.php","line":106,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"getNewPosts","class":"wbb\\data\\thread\\ThreadPushAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":86,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/forum\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
Error Code: 40001
File: /storagepool/c01005/htdocs/compiware-forum.de/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":925,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/forum\/lib\/data\/thread\/ThreadAction.class.php","line":481,"function":"markAsConfirmed","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/forum\/lib\/data\/thread\/ThreadPushAction.class.php","line":106,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"getNewPosts","class":"wbb\\data\\thread\\ThreadPushAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":86,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/storagepool\/c01005\/htdocs\/compiware-forum.de\/forum\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Wenn ich das richtig verstanden habe, dürfte dieser Fehler im WSC 5.5 nicht mehr auftreten, korrekt?

Gibt es etwas, dass ich jetzt bereits tun kann, um diesen Fehler zu fixen?

**Tim Düsterhus** · Oct 10th 2022

Hallo,

Quote from Tim Düsterhus

Mit WoltLab Suite 6.0 wird die Tabelle spätestens entfernt werden.

das ist mittlerweile erfolgt:

Remove wcf1_user_notification_to_user · WoltLab/WCF@92524f9

Queries involving this table are a constant source of deadlocks.

github.com

Entsprechend setze ich dieses Thema mal vorsichtig auf „Behoben mit 6.0.x“.

Deadlock beim als gelesen Markieren

Tim Düsterhus Feb 18th 2022

Tim Düsterhus Oct 10th 2022

Tim Düsterhus Oct 10th 2022

Tim Düsterhus Oct 10th 2022

Participate now!

Share

Similar Threads

Artikel: Alle als gelesen markieren entfernt badge in ungelesene nicht

Artikel als gelesen markieren markiert alles als gelesen

Artikel als gelesen markieren(mobile Ansicht)

Alle Benachrichtigungen / Moderation als gelesen markieren / löschen

Alle Bilder mobil als "angesehen/gelesen" markieren

Tags