Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.2.15
-
Docker version 18.03.0-ce, Linux 4.9.0-4-amd64 #1 SMP Debian 4.9.65-3+deb9u1 (2017-12-23) x86_64
Description
Frecuently, I have corruptions in my mariadb enviroment such as this:
2018-06-27 16:24:29 140642090493696 [ERROR] InnoDB: Clustered record for sec rec not found index `timestamp` of table `x`.`sessions`
|
|
|
InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
|
|
|
0: len 4; hex db2ecc2a; asc . *;;
|
|
|
1: len 30; hex 3374394332527462787047576f5266566d5f61634b306d4f633439616f69; asc 3t9C2RtbxpGWoRfVm_acK0mOc49aoi; (total 43 bytes);
|
|
|
2: len 0; hex ; asc ;;
|
|
|
|
|
InnoDB: clust index record PHYSICAL RECORD: n_fields 9; compact format; info bits 32
|
|
|
0: len 30; hex 334b724636655663366d53354b735f41735f68713138556652325769716d; asc 3KrF6eVc6mS5Ks_As_hq18UfR2Wiqm; (total 43 bytes);
|
|
|
1: len 0; hex ; asc ;;
|
|
|
2: len 6; hex 000005090527; asc ';;
|
|
|
3: len 7; hex 6d00006d482854; asc m mH(T;;
|
|
|
4: len 4; hex 00000000; asc ;;
|
|
|
5: len 13; hex 36362e3234392e37362e313530; asc 66.249.76.150;;
|
|
|
6: len 4; hex db2d408d; asc -@ ;;
|
|
7: len 4; hex 80000000; asc ;;
|
|
8: len 30; hex 746974616e69617c613a313a7b733a31333a2263757272656e74436c6965; asc titania|a:1:{s:13:"currentClie; (total 1491 bytes);
|
|
TRANSACTION 84477223, ACTIVE 0 sec fetching rows
|
|
mysql tables in use 1, locked 1
|
|
31 lock struct(s), heap size 3520, 143 row lock(s), undo log entries 71
|
|
MySQL thread id 332134, OS thread handle 140642090493696, query id 26507658 192.168.1.x x updating
|
|
DELETE FROM sessions
|
|
WHERE (timestamp < '1529916667')
|
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
|