Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
GC, NVME
Description
Revisions:
Baseline: 10.6.17 bde552aea348c3a99d7bb92805570aea16490fb0 (Optimized)
|
Patched: bb-10.6-MDEV-31949_ver0: 10.6.18 5d1a254290f8203a8f2fc60d414c09fde6643493 (Optimized)
|
Also verified that the issue does not exist on 10.6.18 567c0973591eb66797bb0f982f312b516f8fe82c (Opt), the revision just before the patch.
mariadbd options:
Master: --no-defaults --log_bin=binlog --binlog_format=ROW --max_connections=10000 --server_id=1
|
Replica: --no-defaults --gtid_strict_mode=1 --relay-log=relaylog --slave-parallel-threads=3100 --slave-parallel-mode=aggressive --slave-parallel-max-queued=65536 --slave_transaction_retries=18446744073709547520 --innodb_lock_wait_timeout=120 --slave_run_triggers_for_rbr=LOGGING --slave_skip_errors=ALL --max_connections=10000 --server_id=2
|
Sysbech prepare and run:
sysbench --mysql-user=root --mysql-socket="${PWD}/socket.sock" --tables=1 --table_size=10000 --mysql-db=test --mysql-ignore-errors=1062,1213,1614,1205 --threads=3000 --time=0 ./replication_xa_sysbench_1.lua prepare
|
sysbench --mysql-user=root --mysql-socket="${PWD}/socket.sock" --tables=1 --table_size=10000 --mysql-db=test --mysql-ignore-errors=1062,1213,1614,1205 --threads=3000 --time=0 ./replication_xa_sysbench_1.lua run &
|
Lua script: replication_xa_sysbench_1.lua, attached.
Leads to:
Baseline (sample end of SHOW PROCESSLIST;):
|
10.6.17 bde552aea348c3a99d7bb92805570aea16490fb0 (Optimized, Replica) |
...
|
| 2900 | system user | | NULL | Slave_worker | 7 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2902 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2901 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2903 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2904 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2906 | system user | | NULL | Slave_worker | 13 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2908 | system user | | NULL | Slave_worker | 8 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2907 | system user | | NULL | Slave_worker | 14 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2909 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2905 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2911 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2912 | system user | | test | Slave_worker | 0 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32333233',X'',1 | 0.000 |
|
| 2915 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2916 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2917 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2918 | system user | | NULL | Slave_worker | 16 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2913 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2919 | system user | | test | Slave_worker | 0 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32383338',X'',1 | 0.000 |
|
| 2914 | system user | | test | Slave_worker | 0 | Update_rows_log_event::ha_update_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 2920 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2921 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2922 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2923 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2924 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2925 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2926 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2927 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2928 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2929 | system user | | NULL | Slave_worker | 21 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2930 | system user | | NULL | Slave_worker | 7 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2931 | system user | | NULL | Slave_worker | 8 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2932 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2933 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2910 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2957 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2958 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2934 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2959 | system user | | test | Slave_worker | 3 | Update_rows_log_event::ha_update_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 2935 | system user | | NULL | Slave_worker | 18 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2936 | system user | | NULL | Slave_worker | 16 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2937 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2960 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2938 | system user | | NULL | Slave_worker | 16 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2939 | system user | | NULL | Slave_worker | 23 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2940 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2941 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2942 | system user | | NULL | Slave_worker | 13 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2943 | system user | | NULL | Slave_worker | 19 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2944 | system user | | NULL | Slave_worker | 24 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2945 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2946 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2947 | system user | | test | Slave_worker | 5 | Update_rows_log_event::ha_update_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 2948 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2949 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2961 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2950 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2962 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2951 | system user | | test | Slave_worker | 3 | Update_rows_log_event::find_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 2963 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2953 | system user | | test | Slave_worker | 0 | Waiting for prior transaction to commit | XA COMMIT X'7869645f36',X'',1 | 0.000 |
|
| 2964 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2965 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2966 | system user | | test | Slave_worker | 2 | Waiting for prior transaction to commit | XA COMMIT X'7869645f373734',X'',1 | 0.000 |
|
| 2967 | system user | | NULL | Slave_worker | 11 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2968 | system user | | NULL | Slave_worker | 42 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2969 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2970 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2971 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2954 | system user | | NULL | Slave_worker | 27 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2952 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2972 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2973 | system user | | NULL | Slave_worker | 16 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2974 | system user | | NULL | Slave_worker | 10 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2975 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2955 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2976 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2977 | system user | | NULL | Slave_worker | 27 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2978 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2979 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2980 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2981 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2956 | system user | | NULL | Slave_worker | 21 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2982 | system user | | NULL | Slave_worker | 8 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2983 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2984 | system user | | NULL | Slave_worker | 8 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2985 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2986 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2987 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2988 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2991 | system user | | NULL | Slave_worker | 25 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2989 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2992 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2993 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2995 | system user | | NULL | Slave_worker | 30 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2994 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2996 | system user | | NULL | Slave_worker | 13 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2990 | system user | | NULL | Slave_worker | 8 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2997 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2998 | system user | | NULL | Slave_worker | 50 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3000 | system user | | NULL | Slave_worker | 8 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3001 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3002 | system user | | NULL | Slave_worker | 13 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3003 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3004 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3006 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3005 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3007 | system user | | test | Slave_worker | 18 | Update_rows_log_event::ha_update_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 2999 | system user | | NULL | Slave_worker | 7 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3009 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3010 | system user | | test | Slave_worker | 0 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31373038',X'',1 | 0.000 |
|
| 3011 | system user | | NULL | Slave_worker | 49 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3012 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3013 | system user | | NULL | Slave_worker | 12 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3014 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3015 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3016 | system user | | test | Slave_worker | 2 | Waiting for prior transaction to commit | XA COMMIT X'7869645f353931',X'',1 | 0.000 |
|
| 3018 | system user | | NULL | Slave_worker | 24 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3017 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3019 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3020 | system user | | test | Slave_worker | 2 | Update_rows_log_event::find_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 3008 | system user | | NULL | Slave_worker | 16 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3022 | system user | | NULL | Slave_worker | 12 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3023 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3021 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3024 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3025 | system user | | NULL | Slave_worker | 14 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3026 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3027 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3028 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3029 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3030 | system user | | NULL | Slave_worker | 19 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3031 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3032 | system user | | NULL | Slave_worker | 26 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3033 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3034 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3035 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3036 | system user | | NULL | Slave_worker | 26 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3037 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3038 | system user | | NULL | Slave_worker | 16 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3039 | system user | | NULL | Slave_worker | 14 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3041 | system user | | test | Slave_worker | 0 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32323934',X'',1 | 0.000 |
|
| 3040 | system user | | NULL | Slave_worker | 12 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3042 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3043 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3045 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3046 | system user | | NULL | Slave_worker | 13 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3047 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3048 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3049 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3050 | system user | | test | Slave_worker | 2 | Update_rows_log_event::ha_update_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 3051 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3052 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3053 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3054 | system user | | NULL | Slave_worker | 18 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3055 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3056 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3057 | system user | | NULL | Slave_worker | 13 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3058 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3059 | system user | | NULL | Slave_worker | 17 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3060 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3061 | system user | | NULL | Slave_worker | 12 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3062 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3063 | system user | | test | Slave_worker | 3 | Update_rows_log_event::ha_update_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 3064 | system user | | NULL | Slave_worker | 18 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3065 | system user | | test | Slave_worker | 3 | Update_rows_log_event::find_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 3066 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3067 | system user | | test | Slave_worker | 1 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31393231',X'',1 | 0.000 |
|
| 3068 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3069 | system user | | test | Slave_worker | 0 | Waiting for prior transaction to commit | XA COMMIT X'7869645f363634',X'',1 | 0.000 |
|
| 3070 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3071 | system user | | NULL | Slave_worker | 10 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3072 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3073 | system user | | NULL | Slave_worker | 4 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3074 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3075 | system user | | NULL | Slave_worker | 11 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3076 | system user | | NULL | Slave_worker | 27 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3077 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3078 | system user | | NULL | Slave_worker | 8 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3079 | system user | | NULL | Slave_worker | 13 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3080 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3081 | system user | | NULL | Slave_worker | 24 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3082 | system user | | NULL | Slave_worker | 9 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3083 | system user | | NULL | Slave_worker | 11 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3044 | system user | | NULL | Slave_worker | 7 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3084 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3085 | system user | | NULL | Slave_worker | 2 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3086 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3087 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3088 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3089 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3090 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3091 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3092 | system user | | test | Slave_worker | 1 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31353033',X'',1 | 0.000 |
|
| 3093 | system user | | NULL | Slave_worker | 3 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3094 | system user | | NULL | Slave_worker | 17 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3095 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3096 | system user | | NULL | Slave_worker | 1 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3097 | system user | | NULL | Slave_worker | 5 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3098 | system user | | NULL | Slave_worker | 15 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3099 | system user | | NULL | Slave_worker | 28 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3100 | system user | | NULL | Slave_worker | 12 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3101 | system user | | NULL | Slave_worker | 29 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3102 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3103 | system user | | NULL | Slave_worker | 18 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3104 | system user | | NULL | Slave_worker | 6 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3105 | system user | | NULL | Slave_worker | 27 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3106 | system user | | test | Slave_worker | 1 | Write_rows_log_event::write_row(-1) on table `b_sessionmgmt` | NULL | 0.000 |
|
| 6 | system user | | NULL | Slave_SQL | 496 | Waiting for room in worker thread event queue | NULL | 0.000 |
|
| 3144 | root | localhost | test | Query | 0 | starting | show processlist | 0.000 |
|
+------+-------------+-----------+------+--------------+------+-------------------------------------------------------------------+-------------------------------------+----------+
|
3103 rows in set (0.035 sec)
|
Versus (sample end of SHOW PROCESSLIST;):
|
bb-10.6-MDEV-31949_ver0_opt 10.6.18 5d1a254290f8203a8f2fc60d414c09fde6643493 (Optimized, Replica) |
...
|
| 2900 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f343834',X'',1 | 0.000 |
|
| 2901 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2902 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2903 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31343433',X'',1 | 0.000 |
|
| 2904 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2905 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2906 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f383139',X'',1 | 0.000 |
|
| 2907 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31353433',X'',1 | 0.000 |
|
| 2908 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2910 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32313032',X'',1 | 0.000 |
|
| 2911 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2913 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31323631',X'',1 | 0.000 |
|
| 2915 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2914 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f373435',X'',1 | 0.000 |
|
| 2916 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f313432',X'',1 | 0.000 |
|
| 2912 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31353830',X'',1 | 0.000 |
|
| 2917 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31393134',X'',1 | 0.000 |
|
| 2918 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31383030',X'',1 | 0.000 |
|
| 2909 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2919 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2920 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2922 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2921 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f323634',X'',1 | 0.000 |
|
| 2924 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31373431',X'',1 | 0.000 |
|
| 2926 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f343036',X'',1 | 0.000 |
|
| 2927 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31373135',X'',1 | 0.000 |
|
| 2928 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2929 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2930 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2931 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31363237',X'',1 | 0.000 |
|
| 2932 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2935 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2933 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31333734',X'',1 | 0.000 |
|
| 2937 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f323337',X'',1 | 0.000 |
|
| 2936 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31393931',X'',1 | 0.000 |
|
| 2938 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2939 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f393336',X'',1 | 0.000 |
|
| 2940 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2941 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32373834',X'',1 | 0.000 |
|
| 2942 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f383336',X'',1 | 0.000 |
|
| 2944 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f363933',X'',1 | 0.000 |
|
| 2945 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f333035',X'',1 | 0.000 |
|
| 2946 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2925 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f3937',X'',1 | 0.000 |
|
| 2949 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2950 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f393832',X'',1 | 0.000 |
|
| 2943 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2951 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f353239',X'',1 | 0.000 |
|
| 2952 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f323736',X'',1 | 0.000 |
|
| 2947 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f353030',X'',1 | 0.000 |
|
| 2953 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31323738',X'',1 | 0.000 |
|
| 2948 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31353835',X'',1 | 0.000 |
|
| 2955 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f3937',X'',1 | 0.000 |
|
| 2956 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2934 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2957 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2958 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2954 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2959 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31343833',X'',1 | 0.000 |
|
| 2960 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f343639',X'',1 | 0.000 |
|
| 2961 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31303238',X'',1 | 0.000 |
|
| 2963 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2965 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31373439',X'',1 | 0.000 |
|
| 2964 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32303432',X'',1 | 0.000 |
|
| 2966 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31303539',X'',1 | 0.000 |
|
| 2967 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2968 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32303537',X'',1 | 0.000 |
|
| 2969 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2970 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2971 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32373732',X'',1 | 0.000 |
|
| 2972 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2973 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2974 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2975 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2976 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2977 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2923 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2978 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2980 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2979 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31353434',X'',1 | 0.000 |
|
| 2981 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31323431',X'',1 | 0.000 |
|
| 2982 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2983 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f333037',X'',1 | 0.000 |
|
| 2984 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f333337',X'',1 | 0.000 |
|
| 2985 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31363034',X'',1 | 0.000 |
|
| 2986 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2987 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f373431',X'',1 | 0.000 |
|
| 2988 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2989 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31323533',X'',1 | 0.000 |
|
| 2990 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2991 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31313530',X'',1 | 0.000 |
|
| 2992 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2993 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2994 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2995 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32373335',X'',1 | 0.000 |
|
| 2962 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f353738',X'',1 | 0.000 |
|
| 2996 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2997 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f383630',X'',1 | 0.000 |
|
| 2998 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 2999 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3001 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3000 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f323334',X'',1 | 0.000 |
|
| 3003 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f363439',X'',1 | 0.000 |
|
| 3005 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3002 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32373238',X'',1 | 0.000 |
|
| 3006 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3004 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f383031',X'',1 | 0.000 |
|
| 3007 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3008 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3011 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f323431',X'',1 | 0.000 |
|
| 3010 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3012 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3013 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3014 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3009 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3015 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31393336',X'',1 | 0.000 |
|
| 3017 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f323639',X'',1 | 0.000 |
|
| 3018 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3016 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3019 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31333137',X'',1 | 0.000 |
|
| 3020 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f343038',X'',1 | 0.000 |
|
| 3021 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f383638',X'',1 | 0.000 |
|
| 3022 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f393337',X'',1 | 0.000 |
|
| 3023 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3024 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3025 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3026 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3027 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31363731',X'',1 | 0.000 |
|
| 3028 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31343031',X'',1 | 0.000 |
|
| 3029 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3030 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3031 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32353135',X'',1 | 0.000 |
|
| 3032 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32373235',X'',1 | 0.000 |
|
| 3033 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3034 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3035 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32323130',X'',1 | 0.000 |
|
| 3037 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3038 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3039 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31343531',X'',1 | 0.000 |
|
| 3040 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3036 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3041 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3042 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3043 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32383437',X'',1 | 0.000 |
|
| 3044 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32373536',X'',1 | 0.000 |
|
| 3045 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3048 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31343937',X'',1 | 0.000 |
|
| 3047 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3049 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32383334',X'',1 | 0.000 |
|
| 3050 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3051 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f353735',X'',1 | 0.000 |
|
| 3052 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31303335',X'',1 | 0.000 |
|
| 3053 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3054 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3055 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f323235',X'',1 | 0.000 |
|
| 3056 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f3530',X'',1 | 0.000 |
|
| 3057 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31303739',X'',1 | 0.000 |
|
| 3058 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3059 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31393737',X'',1 | 0.000 |
|
| 3061 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3062 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3046 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3060 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32353238',X'',1 | 0.000 |
|
| 3063 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32373332',X'',1 | 0.000 |
|
| 3064 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3065 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3066 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3067 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3069 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3070 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3068 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3072 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31383335',X'',1 | 0.000 |
|
| 3073 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3074 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32383931',X'',1 | 0.000 |
|
| 3071 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3076 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32303334',X'',1 | 0.000 |
|
| 3077 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3078 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3079 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3075 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32393831',X'',1 | 0.000 |
|
| 3081 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3080 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32343135',X'',1 | 0.000 |
|
| 3082 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31303031',X'',1 | 0.000 |
|
| 3083 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31353432',X'',1 | 0.000 |
|
| 3084 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3085 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f333133',X'',1 | 0.000 |
|
| 3086 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3087 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3088 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3089 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3090 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3091 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32303534',X'',1 | 0.000 |
|
| 3092 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3093 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31313437',X'',1 | 0.000 |
|
| 3094 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3096 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3095 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3097 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31363432',X'',1 | 0.000 |
|
| 3098 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f363039',X'',1 | 0.000 |
|
| 3100 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3101 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3099 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3102 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3104 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f32383738',X'',1 | 0.000 |
|
| 3103 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 |
|
| 3105 | system user | | NULL | Slave_worker | 1205 | Waiting for prior transaction to commit | NULL | 0.000 |
|
| 3106 | system user | | test | Slave_worker | 1205 | Waiting for prior transaction to commit | XA COMMIT X'7869645f31383133',X'',1 | 0.000 |
|
| 6 | system user | | NULL | Slave_SQL | 1212 | Waiting for room in worker thread event queue | NULL | 0.000 |
|
| 3132 | root | localhost | test | Query | 0 | starting | show processlist | 0.000 |
|
+------+-------------+-----------+------+--------------+------+-----------------------------------------------+-------------------------------------+----------+
|
3103 rows in set (0.035 sec)
|
Note the long thread durations (stopped waiting after 20 minutes). Both tests were running at the same time; the issue is not related to system load.
The issue is visible on the replica immediately upon commencing the sysbench run (10-20 seconds).
Attachments
Issue Links
- blocks
-
MDEV-31949 slow parallel replication of user xa
-
- Stalled
-
-
-
- Closed
-
- is caused by
-
-
- Stalled
-
-
-
- Closed
-