[MCOL-4148] Server gone away with Union all statement across replication source/target aifter load of 990 rows - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: 1.0.0
Fix Version/s: Icebox
Component/s: MariaDB Server
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)

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: David Hill (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2020-07-06 17:19

Updated:: 2023-10-25 15:23

Resolved:: 2023-10-25 15:23

Git Integration

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