Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.0
-
2017-20, 2017-21
Description
Build tested: Github source 1.1.0-1
[root@localhost mariadb-columnstore-server]# git show
commit 594ef1807a5d6cba45cf7c2bed03cccdc32f177a
Merge: a5f191d ce815f9
Author: David.Hall <david.hall@mariadb.com>
Date: Thu Jun 8 10:12:50 2017 -0500
[root@localhost mariadb-columnstore-engine]# git show
commit ebaf24473c0838989bf504a7c104c511b876fcb8
Author: david hill <david.hill@mariadb.com>
Date: Fri Jun 16 16:53:48 2017 -0500
Recursive CTE caused mysqld to crash.
create table folks (id int, name varchar(20), father int, mother int) engine=columnstore;
insert into folks values (100, 'Alex', 20, 30);
insert into folks values (20, 'Dad', 10, NULL);
insert into folks values (30, 'Mom', NULL, NULL);
insert into folks values (10, 'Grandpa', NULL, NULL);
insert into folks values (98, 'Sister Amy', 20, 30);
select * from folks;
with recursive ancestors as (
select * from folks
where name = 'Alex'
union
select f.*
from folks as f, ancestors as a
where
f.id = a.father or f.id = a.mother
)
select * from ancestors;
with recursive ancestors as ( select * from folks where name = 'Alex' union select f.* from folks as f, ancestors as a where f.id = a.father or f.id = a.mother ) select * from ancestors;
ERROR 2013 (HY000): Lost connection to MySQL server during query
content in /usr/local/mariadb/columnstore/mysql/db/localhost.localdomain.err
170621 22:52:02 mysqld_safe Number of processes running now: 0
170621 22:52:02 mysqld_safe mysqld restarted
2017-06-21 22:52:02 140282559596608 [Note] /usr/local/mariadb/columnstore/mysql//bin/mysqld (mysqld 10.2.6-MariaDB-log) starting as process 26696 ...
170621 22:52:02 Columnstore: Started; Version: 1.0.2-1
170621 22:52:02 InfiniDB: Started; Version: 1.0.2-1
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Uses event mutexes
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Using Linux native AIO
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Number of pools: 1
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Using SSE2 crc32 instructions
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Completed initialization of buffer pool
2017-06-21 22:52:02 140281482487552 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7231013722
InnoDB: Last MySQL binlog file position 0 1526, file name /usr/local/mariadb/columnstore/mysql/db/mysql-bin.000003
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: 128 out of 128 rollback segments are active.
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: Waiting for purge to start
2017-06-21 22:52:02 140282559596608 [Note] InnoDB: 5.7.14 started; log sequence number 7231013731
2017-06-21 22:52:02 140281332619008 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mariadb/columnstore/mysql/db/ib_buffer_pool
2017-06-21 22:52:02 140281332619008 [Note] InnoDB: Buffer pool(s) load completed at 170621 22:52:02
2017-06-21 22:52:02 140282559596608 [Note] Plugin 'FEEDBACK' is disabled.
2017-06-21 22:52:02 140282559596608 [Note] Recovering after a crash using /usr/local/mariadb/columnstore/mysql/db/mysql-bin
2017-06-21 22:52:02 140282559596608 [Note] Starting crash recovery...
2017-06-21 22:52:02 140282559596608 [Note] Crash recovery finished.
2017-06-21 22:52:02 140282559596608 [Note] Server socket created on IP: '::'.
2017-06-21 22:52:02 140282559596608 [Note] Reading of all Master_info entries succeded
2017-06-21 22:52:02 140282559596608 [Note] Added new Master_info '' to hash table
2017-06-21 22:52:02 140282559596608 [Note] /usr/local/mariadb/columnstore/mysql//bin/mysqld: ready for connections.
Version: '10.2.6-MariaDB-log' socket: '/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock' port: 3306 Columnstore 1.1.0-1
Attachments
Issue Links
- relates to
-
MCOL-598 Add CTE functionality to Columnstore
- Closed