MariaDB

Table corruption with key-cache-segments > 51

Bug #605375 reported by Philip Stoev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
High
Unassigned
MariaDB 5.2

Bug Description

In Maria 5.2, the main.ctype_latin1_de test fails when run with key-cache-segments > 51 :

perl mysql-test-run.pl --mysqld=--key-cache-segments=52 main.ctype_latin1_de

main.ctype_latin1_de [ fail ]
        Test ended at 2010-07-14 15:01:23

CURRENT_TEST: main.ctype_latin1_de
--- /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result 2010-07-12 17:43:46.149554000 +0300
+++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject 2010-07-14 15:01:23.744825496 +0300
@@ -139,13 +139,17 @@
 a
 check table t1;
 Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check error Size of indexfile is: 1024 Should be: 2048
+test.t1 check error Corrupt
 select * from t1 where a like "�%";
 a b
 � 1
 �a 1
 �c 1
 �o 1
+Warnings:
+Error 145 Table './test/t1' is marked as crashed and should be repaired
+Error 1194 Table 't1' is marked as crashed and should be repaired
 select * from t1 where a like binary "%�%";
 a b
 � 2

mysqltest: Result length mismatch

The test basically inserts some non-ascii values in a table and then runs CHECK TABLE

Michael Widenius (monty)
Changed in maria:
importance: Undecided → High
Revision history for this message
Igor Babaev (igorb-seattle) wrote : Re: [Bug 605375] [NEW] Table corruption with key-cache-segments > 51

Philip Stoev wrote:
> Public bug reported:
>
> In Maria 5.2, the main.ctype_latin1_de test fails when run with key-
> cache-segments > 51 :
>
> perl mysql-test-run.pl --mysqld=--key-cache-segments=52
> main.ctype_latin1_de
>
> main.ctype_latin1_de [ fail ]
> Test ended at 2010-07-14 15:01:23
>
> CURRENT_TEST: main.ctype_latin1_de
> --- /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result 2010-07-12 17:43:46.149554000 +0300
> +++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject 2010-07-14 15:01:23.744825496 +0300
> @@ -139,13 +139,17 @@
> a
> check table t1;
> Table Op Msg_type Msg_text
> -test.t1 check status OK
> +test.t1 check error Size of indexfile is: 1024 Should be: 2048
> +test.t1 check error Corrupt
> select * from t1 where a like "�%";
> a b
> � 1
> �a 1
> �c 1
> �o 1
> +Warnings:
> +Error 145 Table './test/t1' is marked as crashed and should be repaired
> +Error 1194 Table 't1' is marked as crashed and should be repaired
> select * from t1 where a like binary "%�%";
> a b
> � 2
>
> mysqltest: Result length mismatch
>
> The test basically inserts some non-ascii values in a table and then
> runs CHECK TABLE
>
> ** Affects: maria
> Importance: Undecided
> Status: New
>
>
> ** Tags: cache key segmented
>
 Philip,

I failed to reproduce this bug with the current 5.2 tree.

Regards,
Igor.

Sergei Golubchik (sergii)
Changed in maria:
milestone: none → 5.2
Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :
Download full text (3.6 KiB)

Hello,

It seems that this bug was fixed by the following push:

Changed by: Sergei Golubchik <email address hidden>
Changed at: Sat 24 Jul 2010 09:10:03
Branch: 5.2
Revision: 2832

Changed files:

  a.. mysys/mf_keycache.c MODIFIED
  b.. storage/example/ha_example.cc MODIFIED
  c.. storage/xtradb/Makefile.am MODIFIED
Comments:
buildbot detected problems
If you are happy with such a solution, feel free to close the bug. Thank
you.Philip Stoev
----- Original Message -----
From: "Igor Babaev" <email address hidden>
To: <email address hidden>
Sent: Tuesday, July 27, 2010 1:42 AM
Subject: Re: [Bug 605375] [NEW] Table corruption with key-cache-segments >
51

Philip Stoev wrote:
> Public bug reported:
>
> In Maria 5.2, the main.ctype_latin1_de test fails when run with key-
> cache-segments > 51 :
>
> perl mysql-test-run.pl --mysqld=--key-cache-segments=52
> main.ctype_latin1_de
>
> main.ctype_latin1_de [ fail ]
> Test ended at 2010-07-14 15:01:23
>
> CURRENT_TEST: main.ctype_latin1_de
> --- /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result
> 2010-07-12 17:43:46.149554000 +0300
> +++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject
> 2010-07-14 15:01:23.744825496 +0300
> @@ -139,13 +139,17 @@
> a
> check table t1;
> Table Op Msg_type Msg_text
> -test.t1 check status OK
> +test.t1 check error Size of indexfile is: 1024 Should
> be: 2048
> +test.t1 check error Corrupt
> select * from t1 where a like "�%";
> a b
> � 1
> �a 1
> �c 1
> �o 1
> +Warnings:
> +Error 145 Table './test/t1' is marked as crashed and should be
> repaired
> +Error 1194 Table 't1' is marked as crashed and should be repaired
> select * from t1 where a like binary "%�%";
> a b
> � 2
>
> mysqltest: Result length mismatch
>
> The test basically inserts some non-ascii values in a table and then
> runs CHECK TABLE
>
> ** Affects: maria
> Importance: Undecided
> Status: New
>
>
> ** Tags: cache key segmented
>
 Philip,

I failed to reproduce this bug with the current 5.2 tree.

Regards,
Igor.

--
Table corruption with key-cache-segments > 51
https://bugs.launchpad.net/bugs/605375
You received this bug notification because you are a direct subscriber
of the bug.

Status in Maria: New

Bug description:
In Maria 5.2, the main.ctype_latin1_de test fails when run with
key-cache-segments > 51 :

perl mysql-test-run.pl --mysqld=--key-cache-segments=52 main.ctype_latin1_de

main.ctype_latin1_de [ fail ]
        Test ended at 2010-07-14 15:01:23

CURRENT_TEST: main.ctype_latin1_de
--- /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result
2010-07-12 17:43:46.149554000 +0300
+++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject
2010-07-14 15:01:23.744825496 +0300
@@ -139,13 +139,17 @@
 a
 check table t1;
 Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check error Size of indexfile is: 1024 Should be:
2048
+test.t1 check error Corrupt
 select * from t1 where a like "�%";
 a b
 � 1
 �a 1
 �c 1
 �o ...

Read more...

Revision history for this message
Igor Babaev (igorb-seattle) wrote :

Philip Stoev wrote:
> Hello,
>
> It seems that this bug was fixed by the following push:
>
> Changed by: Sergei Golubchik <email address hidden>
> Changed at: Sat 24 Jul 2010 09:10:03
> Branch: 5.2
> Revision: 2832
>
> Changed files:
>
> a.. mysys/mf_keycache.c MODIFIED
> b.. storage/example/ha_example.cc MODIFIED
> c.. storage/xtradb/Makefile.am MODIFIED
> Comments:
> buildbot detected problems
> If you are happy with such a solution, feel free to close the bug. Thank
> you.Philip Stoev
 I'm ok with Sergei's change, but I don't know how to close the bug
(there is no 'closed' button there).

Regards,
Igor.

> ----- Original Message -----
> From: "Igor Babaev" <email address hidden>
> To: <email address hidden>
> Sent: Tuesday, July 27, 2010 1:42 AM
> Subject: Re: [Bug 605375] [NEW] Table corruption with key-cache-segments >
> 51
>
>
> Philip Stoev wrote:
>> Public bug reported:
>>
>> In Maria 5.2, the main.ctype_latin1_de test fails when run with key-
>> cache-segments > 51 :
>>
>> perl mysql-test-run.pl --mysqld=--key-cache-segments=52
>> main.ctype_latin1_de
>>
>> main.ctype_latin1_de [ fail ]
>> Test ended at 2010-07-14 15:01:23
>>
>> CURRENT_TEST: main.ctype_latin1_de
>> --- /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result
>> 2010-07-12 17:43:46.149554000 +0300
>> +++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject
>> 2010-07-14 15:01:23.744825496 +0300
>> @@ -139,13 +139,17 @@
>> a
>> check table t1;
>> Table Op Msg_type Msg_text
>> -test.t1 check status OK
>> +test.t1 check error Size of indexfile is: 1024 Should
>> be: 2048
>> +test.t1 check error Corrupt
>> select * from t1 where a like "�%";
>> a b
>> � 1
>> �a 1
>> �c 1
>> �o 1
>> +Warnings:
>> +Error 145 Table './test/t1' is marked as crashed and should be
>> repaired
>> +Error 1194 Table 't1' is marked as crashed and should be repaired
>> select * from t1 where a like binary "%�%";
>> a b
>> � 2
>>
>> mysqltest: Result length mismatch
>>
>> The test basically inserts some non-ascii values in a table and then
>> runs CHECK TABLE
>>
>> ** Affects: maria
>> Importance: Undecided
>> Status: New
>>
>>
>> ** Tags: cache key segmented
>>
> Philip,
>
> I failed to reproduce this bug with the current 5.2 tree.
>
> Regards,
> Igor.
>

Philip Stoev (philip-stoev)
Changed in maria:
status: New → Fix Committed
Daniel Bartholomew (dbart)
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.