[MDEV-6817] query cache bug (resturning inconsistent/old result set) with aria table parallel inserts, row format = page - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.3.12, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.2.27, 10.3.18, 10.4.8
Component/s: Query Cache, Storage Engine - Aria
Labels:
None

Sprint:
10.0.20

Description

hi guys, i'm running a stress test with query cache and aria...
the table:

CREATE TABLE `errors` (

	`id1` INT(11) NOT NULL DEFAULT '0',

	`id2` INT(11) NOT NULL DEFAULT '0',

	`err_id` INT(11) NOT NULL DEFAULT '0',

	`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',

	`erro` LONGBLOB NOT NULL,

	PRIMARY KEY (`id1`, `id2`, `err_id`)

COLLATE='latin1_swedish_ci'

ENGINE=Aria;

(using page table type!)

i startup a php script:

<?php

$pid=pcntl_fork();

if($pid==0) $pid=pcntl_fork();

if($pid==0) $pid=pcntl_fork();

// three different process

// connect to database

$conn=mysql_connect(/* connection parameters */);

mysql_select_db(/*select database*/);

// and start a infinite loop

$contador=0;

while(1){

		$SQL=	"SELECT MAX(err_id) FROM errors ".

			"WHERE id1=1 AND id2=2";

IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";

		$tmp_tbl=mysql_query($SQL);

		$err_id=mysql_result($tmp_tbl,0,0);

IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";

		mysql_free($tmp_tbl);

		$err_id++;if($err_id<=0) $err_id=1;

		$SQL=	"INSERT INTO errors (".

				"id1,id2,err_id,datahora,erro".

			") VALUES (".

				"1,2,$err_id,'".microtime(1)."','test '".

			")";

		$ok=mysql_query($SQL); /* autocommit = 1 */

		if($ok){

			$contador=0;

			continue;

		$contador++;

		usleep(500); // wait a bit...

aria variables:

Variable_name	Value
aria_block_size	8192
aria_checkpoint_interval	30
aria_checkpoint_log_activity	1048576
aria_force_start_after_recovery_failures	0
aria_group_commit	none
aria_group_commit_interval	0
aria_log_file_size	1073741824
aria_log_purge_type	immediate
aria_max_sort_file_size	9223372036853727232
aria_page_checksum	ON
aria_pagecache_age_threshold	300
aria_pagecache_buffer_size	134217728
aria_pagecache_division_limit	100
aria_recover	NORMAL
aria_repair_threads	1
aria_sort_buffer_size	268434432
aria_stats_method	nulls_unequal
aria_sync_log_dir	NEWFILE
aria_used_for_temp_tables	ON

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

–
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:

time ->

-----INSERT-------

---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)

---------------------SELECT ---- (got from query cache, wrong query cache value)

the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag, or use SQL_NO_CACHE) i see that the err_id is different from err_id of php script

in other words
1)the table wasn't invalidated correctly
2)the query was cached in a state that aria engine should report to don't cache (concurrent insert? page flush? anything like a buffer or cache being used while updating table?)

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb
—
no problem with innodb
no problem with myisam
no problem with aria using row_format fixed/dynamic, only with aria-page

Attachments

Issue Links

is blocked by

MDEV-7314 Concurrent "INSERT INTO table SELECT MAX(id)+1 FROM table" are hitting deadlocks on Aria tables using ROW_FORMAT=PAGE

Closed

Activity

Ascending order - Click to sort in descending order

roberto spadim created issue - 2014-09-30 21:10

roberto spadim made changes - 2014-09-30 21:13

Field	Original Value	New Value
Description	hi guys, i'm running a stress test with query cache and aria... the table: {code} CREATE TABLE `errors` ( `id1` INT(11) NOT NULL DEFAULT '0', `id2` INT(11) NOT NULL DEFAULT '0', `err_id` INT(11) NOT NULL DEFAULT '0', `datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000', `erro` LONGBLOB NOT NULL, PRIMARY KEY (`id1`, `id2`, `err_id`) ) COLLATE='latin1_swedish_ci' ENGINE=Aria; {code} i startup a php script: {code} <?php $pid=pcntl_fork(); if($pid==0) $pid=pcntl_fork(); if($pid==0) $pid=pcntl_fork(); // three different process // connect to database $conn=mysql_connect(/* connection parameters /); mysql_select_db(/select database/); // and start a infinite loop $contador=0; while(1){ $SQL= "SELECT MAX(err_id) FROM errors ". "WHERE id1=1 AND id2=2"; IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n"; $tmp_tbl=mysql_query($SQL); $err_id=mysql_result($tmp_tbl,0,0); IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n"; mysql_free($tmp_tbl); $err_id++;if($err_id<=0) $err_id=1; $SQL= "INSERT INTO errors (". "id1,id2,err_id,datahora,erro". ") VALUES (". "1,2,$err_id,'".microtime(1)."','test '". ")"; $ok=mysql_query($SQL); if($ok){ $contador=0; continue; } $contador++; usleep(500); // wait a bit... } {code} aria variables: \|\| Variable_name* \|\| Value \|\| \|\| aria_block_size \|\| 8192 \|\| \|\| aria_checkpoint_interval \|\| 30 \|\| \|\| aria_checkpoint_log_activity \|\| 1048576 \|\| \|\| aria_force_start_after_recovery_failures \|\| 0 \|\| \|\| aria_group_commit \|\| none \|\| \|\| aria_group_commit_interval \|\| 0 \|\| \|\| aria_log_file_size \|\| 1073741824 \|\| \|\| aria_log_purge_type \|\| immediate \|\| \|\| aria_max_sort_file_size \|\| 9223372036853727232 \|\| \|\| aria_page_checksum \|\| ON \|\| \|\| aria_pagecache_age_threshold \|\| 300 \|\| \|\| aria_pagecache_buffer_size \|\| 134217728 \|\| \|\| aria_pagecache_division_limit \|\| 100 \|\| \|\| aria_recover \|\| NORMAL \|\| \|\| aria_repair_threads \|\| 1 \|\| \|\| aria_sort_buffer_size \|\| 268434432 \|\| \|\| aria_stats_method \|\| nulls_unequal \|\| \|\| aria_sync_log_dir \|\| NEWFILE \|\| \|\| aria_used_for_temp_tables \|\| ON \|\| autocommit=1 concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error -- what i think is happen? at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute, the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag) i see that the err_id is different from err_id of php script in other words the table wasn't invalidated correctly could we recheck if the aria engine invalidation is ok or not? i will test again with myisam, and after innodb	hi guys, i'm running a stress test with query cache and aria... the table: {code} CREATE TABLE `errors` ( `id1` INT(11) NOT NULL DEFAULT '0', `id2` INT(11) NOT NULL DEFAULT '0', `err_id` INT(11) NOT NULL DEFAULT '0', `datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000', `erro` LONGBLOB NOT NULL, PRIMARY KEY (`id1`, `id2`, `err_id`) ) COLLATE='latin1_swedish_ci' ENGINE=Aria; (using page table type!) {code} i startup a php script: {code} <?php $pid=pcntl_fork(); if($pid==0) $pid=pcntl_fork(); if($pid==0) $pid=pcntl_fork(); // three different process // connect to database $conn=mysql_connect(/* connection parameters /); mysql_select_db(/select database/); // and start a infinite loop $contador=0; while(1){ $SQL= "SELECT MAX(err_id) FROM errors ". "WHERE id1=1 AND id2=2"; IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n"; $tmp_tbl=mysql_query($SQL); $err_id=mysql_result($tmp_tbl,0,0); IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n"; mysql_free($tmp_tbl); $err_id++;if($err_id<=0) $err_id=1; $SQL= "INSERT INTO errors (". "id1,id2,err_id,datahora,erro". ") VALUES (". "1,2,$err_id,'".microtime(1)."','test '". ")"; $ok=mysql_query($SQL); if($ok){ $contador=0; continue; } $contador++; usleep(500); // wait a bit... } {code} aria variables: \|\| Variable_name* \|\| Value \|\| \|\| aria_block_size \|\| 8192 \|\| \|\| aria_checkpoint_interval \|\| 30 \|\| \|\| aria_checkpoint_log_activity \|\| 1048576 \|\| \|\| aria_force_start_after_recovery_failures \|\| 0 \|\| \|\| aria_group_commit \|\| none \|\| \|\| aria_group_commit_interval \|\| 0 \|\| \|\| aria_log_file_size \|\| 1073741824 \|\| \|\| aria_log_purge_type \|\| immediate \|\| \|\| aria_max_sort_file_size \|\| 9223372036853727232 \|\| \|\| aria_page_checksum \|\| ON \|\| \|\| aria_pagecache_age_threshold \|\| 300 \|\| \|\| aria_pagecache_buffer_size \|\| 134217728 \|\| \|\| aria_pagecache_division_limit \|\| 100 \|\| \|\| aria_recover \|\| NORMAL \|\| \|\| aria_repair_threads \|\| 1 \|\| \|\| aria_sort_buffer_size \|\| 268434432 \|\| \|\| aria_stats_method \|\| nulls_unequal \|\| \|\| aria_sync_log_dir \|\| NEWFILE \|\| \|\| aria_used_for_temp_tables \|\| ON \|\| autocommit=1 concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error -- what i think is happen? at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute, the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag) i see that the err_id is different from err_id of php script in other words the table wasn't invalidated correctly could we recheck if the aria engine invalidation is ok or not? i will test again with myisam, and after innodb

roberto spadim made changes - 2014-09-30 21:30

Priority

Major [ 3 ]

Blocker [ 1 ]

roberto spadim made changes - 2014-09-30 21:56

Affects Version/s

10.1.1 [ 16801 ]

roberto spadim made changes - 2014-09-30 21:57

Link

This issue relates to ~~MDEV-4687~~ [ ~~MDEV-4687~~ ]

roberto spadim made changes - 2014-09-30 21:58

Labels

Aria querycache querycache_result

roberto spadim made changes - 2014-09-30 22:00

Description

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL);

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute, the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute, the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb

roberto spadim made changes - 2014-09-30 22:02

Description

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute, the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:
{code}
time ->
-----INSERT-------
---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)
---------------------SELECT ---- (got from query cache, wrong query cache value)
{code}
the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb

roberto spadim made changes - 2014-09-30 22:03

Description

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:
{code}
time ->
-----INSERT-------
---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)
---------------------SELECT ---- (got from query cache, wrong query cache value)
{code}
the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:
{code}
time ->
-----INSERT-------
---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)
---------------------SELECT ---- (got from query cache, wrong query cache value)
{code}
the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag, or use SQL_NO_CACHE) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb

roberto spadim made changes - 2014-09-30 22:04

Description

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:
{code}
time ->
-----INSERT-------
---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)
---------------------SELECT ---- (got from query cache, wrong query cache value)
{code}
the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag, or use SQL_NO_CACHE) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:
{code}
time ->
-----INSERT-------
---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)
---------------------SELECT ---- (got from query cache, wrong query cache value)
{code}
the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag, or use SQL_NO_CACHE) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb
---
no problem with innodb
no problem with myisam
no problem with aria using row_format fixed/dynamic, only with aria-page

Elena Stepanova made changes - 2014-09-30 23:43

Priority

Blocker [ 1 ]

Major [ 3 ]

Sergei Golubchik made changes - 2014-10-10 20:48

Assignee

Michael Widenius [ monty ]

Sergei Golubchik made changes - 2014-10-10 20:48

Fix Version/s

10.0 [ 16000 ]

roberto spadim made changes - 2014-10-24 08:36

Description

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:
{code}
time ->
-----INSERT-------
---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)
---------------------SELECT ---- (got from query cache, wrong query cache value)
{code}
the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag, or use SQL_NO_CACHE) i see that the err_id is different from err_id of php script

in other words the table wasn't invalidated correctly

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb
---
no problem with innodb
no problem with myisam
no problem with aria using row_format fixed/dynamic, only with aria-page

hi guys, i'm running a stress test with query cache and aria...
the table:
{code}
CREATE TABLE `errors` (
`id1` INT(11) NOT NULL DEFAULT '0',
`id2` INT(11) NOT NULL DEFAULT '0',
`err_id` INT(11) NOT NULL DEFAULT '0',
`datahora` DECIMAL(22,7) NOT NULL DEFAULT '0.0000000',
`erro` LONGBLOB NOT NULL,
PRIMARY KEY (`id1`, `id2`, `err_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=Aria;
(using page table type!)
{code}

i startup a php script:

{code}
<?php
$pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
if($pid==0) $pid=pcntl_fork();
// three different process

// connect to database
$conn=mysql_connect(/* connection parameters */);
mysql_select_db(/*select database*/);

// and start a infinite loop
$contador=0;
while(1){
$SQL= "SELECT MAX(err_id) FROM errors ".
"WHERE id1=1 AND id2=2";
IF($contador%1000==0 && $contador>1000) echo "\n$SQL\n";
$tmp_tbl=mysql_query($SQL);
$err_id=mysql_result($tmp_tbl,0,0);
IF($contador%1000==0 && $contador>1000) echo "\n$err_id\n";
mysql_free($tmp_tbl);
$err_id++;if($err_id<=0) $err_id=1;
$SQL= "INSERT INTO errors (".
"id1,id2,err_id,datahora,erro".
") VALUES (".
"1,2,$err_id,'".microtime(1)."','test '".
")";
$ok=mysql_query($SQL); /* autocommit = 1 */

if($ok){
$contador=0;
continue;
}
$contador++;
usleep(500); // wait a bit...
}
{code}

aria variables:
|| *Variable_name* || *Value* ||
|| aria_block_size || 8192 ||
|| aria_checkpoint_interval || 30 ||
|| aria_checkpoint_log_activity || 1048576 ||
|| aria_force_start_after_recovery_failures || 0 ||
|| aria_group_commit || none ||
|| aria_group_commit_interval || 0 ||
|| aria_log_file_size || 1073741824 ||
|| aria_log_purge_type || immediate ||
|| aria_max_sort_file_size || 9223372036853727232 ||
|| aria_page_checksum || ON ||
|| aria_pagecache_age_threshold || 300 ||
|| aria_pagecache_buffer_size || 134217728 ||
|| aria_pagecache_division_limit || 100 ||
|| aria_recover || NORMAL ||
|| aria_repair_threads || 1 ||
|| aria_sort_buffer_size || 268434432 ||
|| aria_stats_method || nulls_unequal ||
|| aria_sync_log_dir || NEWFILE ||
|| aria_used_for_temp_tables || ON ||

autocommit=1
concurrent_insert isn't a problem, i tested with 0,1,2 this give the same error

--
what i think is happen?
at query cache code there's a consideration about when or when not include the query at query cache, while a insert and another aria table is invalidated and a "select" query execute:
{code}
time ->
-----INSERT-------
---SELECCCCCCT--- (cached after invalidation - shoudn't be cached)
---------------------SELECT ---- (got from query cache, wrong query cache value)
{code}
the value of the new insert field err_id isn't updated at the right time, in other words when i connect with a externall tool and set autocommit=0 (to get a different query cache flag, or use SQL_NO_CACHE) i see that the err_id is different from err_id of php script

in other words
1)the table wasn't invalidated correctly
2)the query was cached in a state that aria engine should report to don't cache (concurrent insert? page flush? anything like a buffer or cache being used while updating table?)

could we recheck if the aria engine invalidation is ok or not?
i will test again with myisam, and after innodb
---
no problem with innodb
no problem with myisam
no problem with aria using row_format fixed/dynamic, only with aria-page

roberto spadim made changes - 2014-11-17 20:38

Priority

Major [ 3 ]

Critical [ 2 ]

roberto spadim made changes - 2014-12-13 01:03

Link

This issue relates to ~~MDEV-4687~~ [ ~~MDEV-4687~~ ]

roberto spadim made changes - 2014-12-13 03:53

Summary

query cache bug with aria table

query cache bug with aria table, row format = page

roberto spadim made changes - 2014-12-13 19:59

Link

This issue is blocked by ~~MDEV-7314~~ [ ~~MDEV-7314~~ ]

roberto spadim made changes - 2014-12-14 08:28

Summary

query cache bug with aria table, row format = page

query cache bug (resturning inconsistent/old result set) with aria table parallel inserts, row format = page

Michael Widenius made changes - 2015-01-18 14:23

Status

Open [ 1 ]

In Progress [ 3 ]

Michael Widenius made changes - 2015-01-18 16:25

Assignee

Michael Widenius [ monty ]

Oleksandr Byelkin [ sanja ]

Oleksandr Byelkin made changes - 2015-04-15 11:13

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Oleksandr Byelkin made changes - 2015-04-16 10:51

Assignee

Oleksandr Byelkin [ sanja ]

Elena Stepanova [ elenst ]

Elena Stepanova made changes - 2015-04-16 15:50

Fix Version/s		10.1 [ 16100 ]
Affects Version/s		5.3.12 [ 12000 ]
Affects Version/s		10.1 [ 16100 ]
Affects Version/s		10.0 [ 16000 ]
Affects Version/s		5.5 [ 15800 ]
Affects Version/s	10.0.12 [ 15201 ]
Affects Version/s	10.1.1 [ 16801 ]
Assignee	Elena Stepanova [ elenst ]	Oleksandr Byelkin [ sanja ]
Labels	Aria querycache querycache_result	Aria querycache querycache_result verified

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 55060 ]

MariaDB v3 [ 62683 ]

Sergei Golubchik made changes - 2015-06-09 16:56

Sprint

10.0.20 [ 5 ]

Oleksandr Byelkin made changes - 2015-06-10 12:15

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2015-06-17 01:05

Sprint

10.0.20 [ 5 ]

10.0.20, 10.1.6-1 [ 5, 6 ]

Sergei Golubchik made changes - 2015-06-17 01:06

Rank

Ranked higher

Sergei Golubchik made changes - 2015-06-17 01:25

Sprint

10.0.20, 10.1.6-1 [ 5, 6 ]

10.0.20 [ 5 ]

Oleksandr Byelkin made changes - 2015-06-17 09:48

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Oleksandr Byelkin made changes - 2015-07-27 14:17

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Oleksandr Byelkin made changes - 2015-07-28 11:50

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Elena Stepanova made changes - 2015-10-20 13:21

Priority

Critical [ 2 ]

Major [ 3 ]

Oleksandr Byelkin made changes - 2018-06-08 06:56

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Oleksandr Byelkin made changes - 2018-06-08 09:08

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Oleksandr Byelkin made changes - 2018-07-18 04:59

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Oleksandr Byelkin made changes - 2018-07-18 05:46

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Oleksandr Byelkin made changes - 2018-07-20 11:52

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Elena Stepanova made changes - 2019-05-01 22:37

Fix Version/s

10.0 [ 16000 ]

Elena Stepanova made changes - 2019-05-01 23:08

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]

Elena Stepanova made changes - 2019-05-01 23:08

Labels

Aria querycache querycache_result verified

Sergey Vojtovich made changes - 2019-06-05 12:16

Assignee

Oleksandr Byelkin [ sanja ]

Michael Widenius [ monty ]

Michael Widenius made changes - 2019-09-03 23:01

Fix Version/s

10.1 [ 16100 ]

Michael Widenius made changes - 2019-09-04 07:11

issue.field.resolutiondate

2019-09-04 07:11:21.0

2019-09-04 07:11:21.045

Michael Widenius made changes - 2019-09-04 07:11

Fix Version/s		10.2.27 [ 23717 ]
Fix Version/s		10.3.18 [ 23719 ]
Fix Version/s		10.4.8 [ 23721 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:40

Workflow

MariaDB v3 [ 62683 ]

MariaDB v4 [ 148277 ]

People

Assignee:: Michael Widenius

Reporter:: roberto spadim

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2014-09-30 21:10

Updated:: 2019-09-04 07:11

Resolved:: 2019-09-04 07:11

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration