[MDEV-14461] Connect + RocksDB Created: 2017-11-21  Updated: 2018-03-22  Resolved: 2017-12-11

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.2
Fix Version/s: 10.2.12

Type: Bug Priority: Critical
Reporter: Aurélien LEQUOY Assignee: Sergei Petrunia
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Mariadb 10.2

Issue Links:
Relates
relates to MDEV-14123 .rocksdb folder may break workflow wh... Closed

 Description    

create table xt1 (
 
id int not null,
 
msg varchar(32))
 
engine=myisam;
 
 
 
create table xt2 (
 
id int not null,
 
msg varchar(32)); /* engine=innoDB */
 
 
 
create table xt3 (
 
id int not null,
 
msg varchar(32))
 
engine=connect table_type=CSV;
 
 
 
 
 
create table t3 (
 
id int not null,
 
msg varchar(32))
 
engine=connect table_type=PROXY tabname='xt%s'
 
partition by range columns(id) (
 
partition `1` values less than(10),
 
partition `2` values less than(50),
 
partition `3` values less than(MAXVALUE));

Error with RocksDB because hidden directory :

 select partition_name, table_rows from
 
    -> information_schema.partitions where table_name = 't3';
 
ERROR 1102 (42000): Incorrect database name '#mysql50#.rocksdb'



 Comments   
Comment by Aurélien LEQUOY [ 2017-11-21 ]

other point :

insert into t3 values
 
(4, 'four'),(7,'seven'),(10,'ten'),(40,'forty'),
 
(60,'sixty'),(81,'eighty one'),(72,'seventy two'),
 
(11,'eleven'),(1,'one'),(35,'thirty five'),(8,'eight');
 
 
 
select * from t3;
 
ERROR 1296 (HY000): Got error 174 '(1045) Access denied for user 'root'@'localhost' (using password: NO)' from CONNECT

i would it's only make proxy, i mean if same host not instantoate new connexion on DB

Comment by Elena Stepanova [ 2017-11-21 ]

Does the latter problem also only happen with RocksDB enabled?

Comment by Aurélien LEQUOY [ 2017-11-21 ]

yes, if rocksdb was enabled.

this hidden directory make a lot of trouble, it's not firdt time i got troublevwith this.

Comment by Elena Stepanova [ 2017-11-21 ]

I agree. We already have reports about it causing troubles, but I'm going to keep this one as well, as yet another proof that it must be sorted out before RocksDB goes to the next level.

Comment by Sergei Petrunia [ 2017-12-11 ]

Fixed as part of fix for MDEV-14123. Marking as a duplicate.

Comment by Aurélien LEQUOY [ 2018-03-22 ]

solved confirmed

Generated at Thu Feb 08 08:13:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.