Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
23.10.4, 23.10.6
-
None
Description
How to reproduce:
Date/time: 2025-07-11 14:30:05 |
Signal: 11 |
 |
/usr/bin/PrimProc(+0xbcbe6)[0x5612d8c69be6] |
/lib64/libpthread.so.0(+0x12990)[0x7fd7e85b0990] |
/lib64/librowgroup.so(_ZNK8rowgroup8RowGroup14getColumnWidthEj+0x6)[0x7fd7e9213706] |
/lib64/libjoiner.so(_ZN6joiner12TypelessData3cmpERKN8rowgroup8RowGroupERKSt6vectorIjSaIjEERKS0_SB_PS8_PS3_+0x300)[0x7fd7e9271190] |
/usr/bin/PrimProc(+0x625ef)[0x5612d8c0f5ef] |
/usr/bin/PrimProc(+0x9d35b)[0x5612d8c4a35b] |
/lib64/libthreadpool.so(_ZN10threadpool18PriorityThreadPool9threadFcnENS0_8PriorityE+0x6e0)[0x7fd7e834bfa0] |
/usr/bin/PrimProc(+0xbeec1)[0x5612d8c6bec1] |
/lib64/libpthread.so.0(+0x81ca)[0x7fd7e85a61ca] |
/lib64/libc.so.6(clone+0x43)[0x7fd7e6cb98d3] |
How to reproduce:
If cluster exists, execute attached reproinit.sql
mysql < reproinit.sql
|
It creates database d1 and 4 tables , fill tables with dummy data.
table group_g01 = 1 row
table group_g02 = 1 row
table p = 200000 rows
table c = 500000 rows
Crash happens with this select
SELECT
|
v.c36 AS hst,
|
m.p6 AS g,
|
COALESCE(g0.eg_id,'MARIA') AS g01, |
COALESCE(g1.eg_id,'MARIA') AS g02, |
SUM(v.c758 * m.p42 / 100 + v.c759 * m.p42 / 100 + v.c760 * m.p42 / 100) AS sval |
FROM
|
c AS v
|
JOIN p m on (v.c4 = m.a4)
|
LEFT OUTER JOIN group_g01 AS g0 ON g0.key_id=m.p6
|
LEFT OUTER JOIN group_g02 AS g1 ON g1.key_id=m.p6
|
WHERE
|
1=1 |
GROUP BY c36,p6,g01,g02;
|
| hst | g | g01 | g02 | sval |
|
+------+------+------+------+------+
|
+------+------+------+------+------+
|
ERROR 1815 (HY000): Internal error: InetStreamSocket::readToMagic: Remote is closed |
0 rows in set (51.508 sec) |
Can be reproduced with attached docker-compose environment.
deflate collmass9
cd colmass9/mariadb-columnstore-docker/
change fake enterprise key in file .secrets with a real key
docker login docker.mariadb.com
with your credentials
Current values in .env are
RELEASE_NUMBER=10.6.23-19
RELEASE_NUMBER=10.6.23-19
can be changed in file .env
Build images:
./build -t mcs:23.10.6 |
Create environment
docker compose up -d
|
docker exec -it mcsf1 provision mcsf1 mcsf2 mcsf3
|
- copy reproinit.sql into docker container
docker cp reproinit.sql mcsf1:/var/lib/mysql
|
login into the contaIner with
docker exec -it mcsf1 bash
In the container, run reproinit
cd /var/lib/mysql
mysql < reproinit.sql
In Mariadb promt.
use d1;
and fire above select.
If you get a foreign engine error, it might be needed to set the crossengine user.
On docke Linux Prompt
mcsSetConfig CrossEngineSupport Host 127.0.0.1 |
mcsSetConfig CrossEngineSupport Port 3306 |
mcsSetConfig CrossEngineSupport User util_user
|
mcsSetConfig CrossEngineSupport Password Maria2016!
|
On MariaDB prompt:
CREATE USER 'util_user'@'127.0.0.1' IDENTIFIED BY 'Maria2016!'; |
GRANT SELECT, PROCESS ON *.* TO 'util_user'@'127.0.0.1'; |