[MDEV-29267] Crash casued by Semaphore wait has lasted > 600 seconds Created: 2022-08-08  Updated: 2022-09-05  Resolved: 2022-09-05

Status: Closed
Project: MariaDB Server
Component/s: Locking
Affects Version/s: 10.5.16
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: TAO ZHOU Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None


 Description   

After upgrading from 10.5.13 to 10.5.16.
I started having crash on daily basis.
I tried disabling `innodb_stats_auto_recalc`.
It seemed to crash less often, but didn't solve the problem.

There are a whole bunch of issues out there related to semaphore wait, but I can see any of them gives a solution.

Here's the crash log

2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac5b; asc [;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac5b; asc [;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac5b; asc [;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac69; asc i;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac77; asc w;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac87; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac88; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac88; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac88; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac88; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ac88; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199acc4; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199acd2; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199acd6; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199acd6; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199acd6; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 7265706f; asc repo;;
 
2: len 1; hex 72; asc r;;
 
3: len 5; hex 742d736574; asc t-set;;
 
4: len 4; hex 8199ace0; asc ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 73797374; asc syst;;
 
2: len 1; hex 65; asc e;;
 
3: len 5; hex 6d2e737461; asc m.sta;;
 
4: len 4; hex 74757381; asc tus ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 73797374; asc syst;;
 
2: len 1; hex 65; asc e;;
 
3: len 5; hex 6d2e737461; asc m.sta;;
 
4: len 4; hex 74757381; asc tus ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:00:16 4040 [ERROR] InnoDB: Clustered record for sec rec not found index `activity_activity_user_success_createdat_index` of table `abcd-green-xxxx-yyyy`.`activity`
 
InnoDB: sec index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 
0: len 4; hex 76696577; asc view;;
 
1: len 4; hex 73797374; asc syst;;
 
2: len 1; hex 65; asc e;;
 
3: len 5; hex 6d2e737461; asc m.sta;;
 
4: len 4; hex 74757381; asc tus ;;
 
 
 
InnoDB: clust index record PHYSICAL RECORD: n_fields 13; compact format; info bits 0
 
0: len 4; hex 001bbd21; asc !;;
 
1: len 6; hex 000245d7bea2; asc E ;;
 
2: len 7; hex 8c00000249290a; asc I) ;;
 
3: len 4; hex 73656e64; asc send;;
 
4: len 4; hex 00000065; asc e;;
 
5: len 8; hex 000001827976bda3; asc yv ;;
 
6: len 6; hex 70617263656c; asc parcel;;
 
7: SQL NULL;
 
8: SQL NULL;
 
9: SQL NULL;
 
10: len 1; hex 81; asc ;;
 
11: len 30; hex 7b2274656d706c617465223a22616e616c79746963732e6578706f72742e; asc {"template":"analytics.export.; (total 58 bytes);
 
12: len 5; hex 99ad8f2001; asc ;;
 
 
 
TRANSACTION 304478135934576, ACTIVE 5 sec fetching rows
 
mysql tables in use 3, locked 0
 
0 lock struct(s), heap size 1128, 0 row lock(s)
 
MySQL thread id 4040, OS thread handle 22989997197056, query id 648081484 172.62.1.6 abcd-green-xxxx-yyyy Sending data
 
SELECT u.uid AS 'Username', u.first_name AS 'First Name', u.last_name AS 'Last Name', u.email AS 'Email', IF(registration_date IS NULL, 'Not Registered', registration_date) AS 'Registration Date', last_login 'Last Login', total_sessions 'Total Sessions', IF(nd.type IS NULL AND registration_date IS NOT NULL, 'browser', nd.type) AS 'Device Type', u.org_level_3 AS 'Level 3' , u.cost_centre_code_2 AS 'Cost Centre Code 2', u.cost_centre_code_3 AS 'Cost Centre Code 3', LEFT(u.org_level_4,2) AS 'Level 4 Division' , u.location, u.region , u.department_code , u.department, u.terminated_at FROM user u L
 
 
 
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
 
2022-08-07 18:04:55 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 247.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:04:55 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 247.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:05:10 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 262.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:05:10 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 262.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:05:25 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 277.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:05:25 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 277.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:05:40 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 292.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:05:40 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 292.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:05:55 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 307.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:05:55 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 307.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:06:10 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 322.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:06:10 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 322.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:06:25 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 337.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:06:25 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 337.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:06:40 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 352.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:06:40 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 352.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:06:55 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 367.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:06:55 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 367.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:07:10 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 382.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:07:10 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 382.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:07:25 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 397.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:07:25 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 397.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:07:40 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 412.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:07:40 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 412.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:07:55 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 427.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:07:55 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 427.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:08:10 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 442.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:08:10 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 442.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:08:25 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 457.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:08:25 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 457.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:08:40 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 472.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:08:40 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 472.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:08:55 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 487.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:08:55 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 487.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:09:10 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 502.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:09:10 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 502.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:09:25 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 517.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:09:25 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 517.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:09:40 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 532.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:09:40 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 532.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:09:55 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 547.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:09:55 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 547.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:10:10 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 562.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:10:10 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 562.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:10:25 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 577.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:10:25 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 577.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:10:40 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 592.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:10:40 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 592.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:10:55 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 607.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:10:55 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 607.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:11:10 0 [Warning] InnoDB: A long semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 622.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
2022-08-07 18:11:10 0 [Note] InnoDB: A semaphore wait:
 
--Thread 22989500876544 has waited at btr0pcur.cc line 519 for 622.00 seconds the semaphore:
 
X-lock on RW-latch at 0x14eb6b986278 created in file buf0buf.cc line 1174
 
a writer (thread id 22990071187200) has reserved it in mode exclusive
 
number of readers 0, waiters flag 1, lock_word: 0
 
Last time write locked in file row0ins.cc line 2978
 
InnoDB: Pending reads 0, writes 0
 
2022-08-07 18:11:10 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.



 Comments   
Comment by Marko Mäkelä [ 2022-08-08 ]

This looks like MDEV-15020, which was fixed in MariaDB 10.6.5 Can you try upgrading to the 10.6 release series?

Generated at Thu Feb 08 10:07:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.