Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.16
-
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.
|