[MCOL-4148] Server gone away with Union all statement across replication source/target aifter load of 990 rows Created: 2020-07-06  Updated: 2023-10-25  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.0.0
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description    

MariaDB [columnstore_db]> use innodb_db;
 
Reading table information for completion of table and column names
 
You can turn off this feature to get a quicker startup with -A
 
 
 
Database changed
 
MariaDB [innodb_db]> insert into num values (0,1), (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1);
 
Query OK, 10 rows affected (0.001 sec)
 
Records: 10 Duplicates: 0 Warnings: 0
 
 
 
MariaDB [innodb_db]>
 
MariaDB [innodb_db]> select count(*) count_innodb, min(n), max(n) from innodb_db.num union all
 
-> select count(*) count_innodb, min(n), max(n) from columnstore_db.num;
 
+--------------+--------+--------+
 
| count_innodb | min(n) | max(n) |
 
+--------------+--------+--------+
 
| 10 | 0 | 9 |
 
| 10 | 0 | 9 |
 
+--------------+--------+--------+
 
2 rows in set (0.047 sec)
 
 
 
MariaDB [innodb_db]> insert into num select n, 1
 
-> from ( select n1.n + n2.n * 10 + n3.n * 100 n
 
-> from num n1 join num n2 using (id) join num n3 using (id)
 
-> ) a where n > 9
 
-> order by 1;
 
Query OK, 990 rows affected (0.005 sec)
 
Records: 990 Duplicates: 0 Warnings: 0
 
 
 
MariaDB [innodb_db]>
 
MariaDB [innodb_db]>
 
MariaDB [innodb_db]> select count(*) count_innodb, min(n), max(n) from innodb_db.num union all
 
-> select count(*) count_innodb, min(n), max(n) from columnstore_db.num;
 
ERROR 2006 (HY000): MySQL server has gone away
 
No connection. Trying to reconnect...
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
 
ERROR: Can't connect to the server
 
 
 
unknown [innodb_db]> select count(*) count_innodb, min(n), max(n) from innodb_db.num ;
 
No connection. Trying to reconnect...
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
 
ERROR: Can't connect to the server
 
 
 
unknown [innodb_db]> exit
 
Bye
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo mariadb
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl status mariadb-columnstore
 
● mariadb-columnstore.service - mariadb-columnstore
 
Loaded: loaded (/usr/lib/systemd/system/mariadb-columnstore.service; enabled; vendor preset: disabled)
 
Active: active (exited) since Thu 2020-07-02 03:09:50 CST; 1 day 2h ago
 
Process: 28622 ExecStop=/usr/bin/mariadb-columnstore-stop.sh (code=exited, status=0/SUCCESS)
 
Process: 29949 ExecStart=/usr/bin/mariadb-columnstore-start.sh (code=exited, status=0/SUCCESS)
 
Main PID: 29949 (code=exited, status=0/SUCCESS)
 
Memory: 0B
 
CGroup: /system.slice/mariadb-columnstore.service
 
 
 
Jul 02 03:09:43 k28b03375.eu95sqa systemd[1]: Starting mariadb-columnstore...
 
Jul 02 03:09:44 k28b03375.eu95sqa mariadb-columnstore-start.sh[29949]: Job for mcs-storagemanager.service failed because the control process exited with error code. See "systemctl status mcs-storagemanager.service" and "journalctl -xe" for details.
 
Jul 02 03:09:50 k28b03375.eu95sqa systemd[1]: Started mariadb-columnstore.
 
Hint: Some lines were ellipsized, use -l to show in full.
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl status mariadb-columnstore
 
● mariadb-columnstore.service - mariadb-columnstore
 
Loaded: loaded (/usr/lib/systemd/system/mariadb-columnstore.service; enabled; vendor preset: disabled)
 
Active: active (exited) since Thu 2020-07-02 03:09:50 CST; 1 day 2h ago
 
Process: 28622 ExecStop=/usr/bin/mariadb-columnstore-stop.sh (code=exited, status=0/SUCCESS)
 
Process: 29949 ExecStart=/usr/bin/mariadb-columnstore-start.sh (code=exited, status=0/SUCCESS)
 
Main PID: 29949 (code=exited, status=0/SUCCESS)
 
Memory: 0B
 
CGroup: /system.slice/mariadb-columnstore.service
 
 
 
Jul 02 03:09:43 k28b03375.eu95sqa systemd[1]: Starting mariadb-columnstore...
 
Jul 02 03:09:44 k28b03375.eu95sqa mariadb-columnstore-start.sh[29949]: Job for mcs-storagemanager.service failed because the control process exited with error code. See "systemctl status mcs-storagemanager.service" and "journalctl -xe" for details.
 
Jul 02 03:09:50 k28b03375.eu95sqa systemd[1]: Started mariadb-columnstore.
 
Hint: Some lines were ellipsized, use -l to show in full.
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl status mariadb
 
● mariadb.service - MariaDB 10.5.4 database server
 
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
 
Drop-In: /etc/systemd/system/mariadb.service.d
 
└─migrated-from-my.cnf-settings.conf
 
Active: active (running) since Fri 2020-07-03 05:31:55 CST; 59ms ago
 
Docs: man:mariadbd(8)
 
https://mariadb.com/kb/en/library/systemd/
 
Process: 165496 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 
Process: 165424 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
 
Process: 165421 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 
Main PID: 165468 (mariadbd)
 
Status: "Taking your SQL requests now..."
 
Memory: 65.9M
 
CGroup: /system.slice/mariadb.service
 
└─165511 addr2line -C -f -e /lib64/libc.so.6
 
 
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max open files 16364 16364 files
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max locked memory 65536 65536 bytes
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max address space unlimited unlimited bytes
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max file locks unlimited unlimited locks
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max pending signals 2061767 2061767 signals
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max msgqueue size 819200 819200 bytes
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max nice priority 0 0
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max realtime priority 0 0
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Max realtime timeout unlimited unlimited us
 
Jul 03 05:31:55 k28b03375.eu95sqa mariadbd[165468]: Core pattern: core
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo mariadb
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl restart mariadb
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo mariadb
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl stop mariadb
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl start mariadb
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl status mariadb
 
● mariadb.service - MariaDB 10.5.4 database server
 
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
 
Drop-In: /etc/systemd/system/mariadb.service.d
 
└─migrated-from-my.cnf-settings.conf
 
Active: activating (auto-restart) (Result: signal) since Fri 2020-07-03 05:33:43 CST; 1s ago
 
Docs: man:mariadbd(8)
 
https://mariadb.com/kb/en/library/systemd/
 
Process: 167340 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 
Process: 167316 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=SEGV)
 
Process: 167267 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
 
Process: 167264 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 
Main PID: 167316 (code=killed, signal=SEGV)
 
Status: "Taking your SQL requests now..."
 
 
 
Jul 03 05:33:43 k28b03375.eu95sqa systemd[1]: Unit mariadb.service entered failed state.
 
Jul 03 05:33:43 k28b03375.eu95sqa systemd[1]: mariadb.service failed.
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl status mariadb-columnstore
 
● mariadb-columnstore.service - mariadb-columnstore
 
Loaded: loaded (/usr/lib/systemd/system/mariadb-columnstore.service; enabled; vendor preset: disabled)
 
Active: active (exited) since Thu 2020-07-02 03:09:50 CST; 1 day 2h ago
 
Process: 28622 ExecStop=/usr/bin/mariadb-columnstore-stop.sh (code=exited, status=0/SUCCESS)
 
Process: 29949 ExecStart=/usr/bin/mariadb-columnstore-start.sh (code=exited, status=0/SUCCESS)
 
Main PID: 29949 (code=exited, status=0/SUCCESS)
 
Memory: 0B
 
CGroup: /system.slice/mariadb-columnstore.service
 
 
 
Jul 02 03:09:43 k28b03375.eu95sqa systemd[1]: Starting mariadb-columnstore...
 
Jul 02 03:09:44 k28b03375.eu95sqa mariadb-columnstore-start.sh[29949]: Job for mcs-storagemanager.service failed because the control process exited with error code. See "systemctl status mcs-storagemanager.service" and "journalctl -xe" for details.
 
Jul 02 03:09:50 k28b03375.eu95sqa systemd[1]: Started mariadb-columnstore.
 
Hint: Some lines were ellipsized, use -l to show in full.
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl restart mariadb-columnstore
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo systemctl restart mariadb
 
 
 
[j.tommaney@k28b03375.eu95sqa /usr/bin]
 
$sudo mariadb
 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)



 Comments   
Comment by David Hall (Inactive) [ 2020-08-12 ]

I can't reproduce the problem in 1.5.4 latest:

MariaDB [innodb_db]> insert into num select n, 1 from ( select n1.n + n2.n * 10 + n3.n * 100 n from num n1 join num n2 using (id) join num n3 using (id) ) a where n > 9 order by 1;
 
Query OK, 990 rows affected (2.420 sec)
 
Records: 990  Duplicates: 0  Warnings: 0
 
 
 
MariaDB [innodb_db]> select count(*) count_innodb, min(n), max(n) from innodb_db.num union all select count(*) count_innodb, min(n), max(n) from columnstore_db.num;
 
+--------------+--------+--------+
 
| count_innodb | min(n) | max(n) |
 
+--------------+--------+--------+
 
|         1000 |      0 |    999 |
 
|           10 |      0 |      9 |
 
+--------------+--------+--------+
 
2 rows in set (0.045 sec)

Generated at Thu Feb 08 02:48:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.