[MDEV-16906] No groups to be reported (check your GNRs) - mysqld_multi does not see instances - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2.16
Fix Version/s: 10.2.17
Component/s: Configuration
Labels:
None
Environment:
Debian 9.5 9 - Kernel 4.9.0-6
MariaDB 10.2.15 and 10.2.16 and 10.3

Description

Hi,
we tried to setup a new database Server with Debian 9 , MariaDB 10.2 and mysqld_multi with several instances.
We always get this message:

#mysqld_multi report

Reporting MariaDB servers

No groups to be reported (check your GNRs)

In MariadDB 10.2.14 your test Multi Instance is working:

#msqld_multi report

Reporting MariaDB servers

MariaDB server from group: mysqld16 is not running

This happens with MariaDB 10.2.15, 10.2.16 ad 10.3
Mysqld_multi.log has no helpful entries:

Reporting MariaDB servers

No groups to be reported (check your GNRs)

mysqld_multi log file version 2.20; run: Mo Aug  6 15:15:37 2018

best regards
Andreas

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

my.cnf
2 kB
2018-08-07 09:27
mysql_slaves.cnf
1 kB
2018-08-07 09:27

Activity

Ascending order - Click to sort in descending order

Tech Nik created issue - 2018-08-06 13:17

Tech Nik made changes - 2018-08-06 13:18

Field	Original Value	New Value
Description	Hi, we tried to setup a new database Server with debian 9 , MariaDB 10.2 anda mysqld_multi with several instances. We alway get this message: #mysqld_multi report Reporting MariaDB servers No groups to be reported (check your GNRs) In MariadDB 10.2.14 your test Multi Instance is working: #msqld_multi report Reporting MariaDB servers MariaDB server from group: mysqld16 is not running This happens with Mariadb 10.2.15, 10.2.16 ad 10.3 Mysqld_multi.log has no helpful entries: Reporting MariaDB servers No groups to be reported (check your GNRs) mysqld_multi log file version 2.20; run: Mo Aug 6 15:15:37 2018	Hi, we tried to setup a new database Server with Debian 9 , MariaDB 10.2 and mysqld_multi with several instances. We always get this message: #mysqld_multi report Reporting MariaDB servers No groups to be reported (check your GNRs) In MariadDB 10.2.14 your test Multi Instance is working: #msqld_multi report Reporting MariaDB servers MariaDB server from group: mysqld16 is not running This happens with MariaDB 10.2.15, 10.2.16 ad 10.3 Mysqld_multi.log has no helpful entries: Reporting MariaDB servers No groups to be reported (check your GNRs) mysqld_multi log file version 2.20; run: Mo Aug 6 15:15:37 2018 best regards Andreas

Alice Sherepa added a comment - 2018-08-07 09:16

Please provide your .cnf files.
I tried with a group of Mariadb 10.2.16 and 10.3.8 in Docker image of Centos 7.5, seems to work

[root@bc1b8047d3c0 etc]# mysqld_multi report

Reporting MariaDB servers

MariaDB server from group: mysqld2 is not running

MariaDB server from group: mysqld3 is not running

[root@bc1b8047d3c0 etc]# mysqld_multi start 2

[root@bc1b8047d3c0 etc]# mysqld_multi start 3

[root@bc1b8047d3c0 farm]# mysqld_multi report

Reporting MariaDB servers

MariaDB server from group: mysqld2 is running

MariaDB server from group: mysqld3 is running

[root@bc1b8047d3c0 etc]# top -cb |grep [m]ysqld

  798 root      20   0   11828   2720   2388 S   0.0  0.0   0:00.00 /bin/sh /usr/bin/mysqld_safe --socket=/a/m1-10.2.16/dt/my.sock --port=3307 --pid_file=/a/m1-10.2.16/dt/p.id --datadir=/a/m1-10.+

  880 root      20   0 1779240  97720  18388 S   0.0  0.3   0:00.20 /usr/sbin/mysqld --basedir=/usr --datadir=/a/m1-10.2.16/dt --plugin-dir=/usr/lib64/mysql/plugin --user=root --log-error=/a/m1-10.2+

  916 root      20   0   11828   2836   2500 S   0.0  0.0   0:00.00 /bin/sh /usr/bin/mysqld_safe --socket=/a/m0-10.3.8/dt/my.sock --port=3306 --pid-file=/a/m0-10.3.8/dt/p.id --datadir=/a/m0-10.3.+

  998 root      20   0 1779240  97764  18416 S   0.0  0.3   0:00.19 /usr/sbin/mysqld --basedir=/usr --datadir=/a/m0-10.3.8/dt --plugin-dir=/usr/lib64/mysql/plugin --user=root --log-error=/a/m0-10.3.+

Alice Sherepa added a comment - 2018-08-07 09:16 Please provide your .cnf files. I tried with a group of Mariadb 10.2.16 and 10.3.8 in Docker image of Centos 7.5, seems to work [root@bc1b8047d3c0 etc]# mysqld_multi report Reporting MariaDB servers MariaDB server from group: mysqld2 is not running MariaDB server from group: mysqld3 is not running [root@bc1b8047d3c0 etc]# mysqld_multi start 2 [root@bc1b8047d3c0 etc]# mysqld_multi start 3 [root@bc1b8047d3c0 farm]# mysqld_multi report Reporting MariaDB servers MariaDB server from group: mysqld2 is running MariaDB server from group: mysqld3 is running [root@bc1b8047d3c0 etc]# top -cb |grep [m]ysqld 798 root 20 0 11828 2720 2388 S 0.0 0.0 0:00.00 /bin/sh /usr/bin/mysqld_safe --socket=/a/m1-10.2.16/dt/my.sock --port=3307 --pid_file=/a/m1-10.2.16/dt/p.id --datadir=/a/m1-10.+ 880 root 20 0 1779240 97720 18388 S 0.0 0.3 0:00.20 /usr/sbin/mysqld --basedir=/usr --datadir=/a/m1-10.2.16/dt --plugin-dir=/usr/lib64/mysql/plugin --user=root --log-error=/a/m1-10.2+ 916 root 20 0 11828 2836 2500 S 0.0 0.0 0:00.00 /bin/sh /usr/bin/mysqld_safe --socket=/a/m0-10.3.8/dt/my.sock --port=3306 --pid-file=/a/m0-10.3.8/dt/p.id --datadir=/a/m0-10.3.+ 998 root 20 0 1779240 97764 18416 S 0.0 0.3 0:00.19 /usr/sbin/mysqld --basedir=/usr --datadir=/a/m0-10.3.8/dt --plugin-dir=/usr/lib64/mysql/plugin --user=root --log-error=/a/m0-10.3.+

Tech Nik made changes - 2018-08-07 09:27

Attachment		mysql_slaves.cnf [ 46008 ]
Attachment		my.cnf [ 46009 ]

Tech Nik added a comment - 2018-08-07 09:28

Hi,
attached you can find my config files.
Could you please try to reproduce it on a fresh debian 9 installation.
Best regards
Andreas

Tech Nik added a comment - 2018-08-07 09:28 Hi, attached you can find my config files. Could you please try to reproduce it on a fresh debian 9 installation. Best regards Andreas

Alice Sherepa added a comment - 2018-08-07 13:06

thanks for the report! Reproduced on Debian 9:

root@27b421b34a0a:/a/m1-10.2.15# mysqld_multi report

Reporting MariaDB servers

No groups to be reported (check your GNRs)

root@27b421b34a0a:/a/m1-10.2.15# cat /etc/issue

Debian GNU/Linux 9 \n \l

Alice Sherepa added a comment - 2018-08-07 13:06 thanks for the report! Reproduced on Debian 9: root@27b421b34a0a:/a/m1-10.2.15# mysqld_multi report Reporting MariaDB servers No groups to be reported (check your GNRs) root@27b421b34a0a:/a/m1-10.2.15# cat /etc/issue Debian GNU/Linux 9 \n \l

Sergei Golubchik made changes - 2018-08-07 13:23

Description

Hi,
we tried to setup a new database Server with Debian 9 , MariaDB 10.2 and mysqld_multi with several instances.
We always get this message:
#mysqld_multi report
Reporting MariaDB servers
No groups to be reported (check your GNRs)

In MariadDB 10.2.14 your test Multi Instance is working:
#msqld_multi report
Reporting MariaDB servers
MariaDB server from group: mysqld16 is not running

This happens with MariaDB 10.2.15, 10.2.16 ad 10.3
Mysqld_multi.log has no helpful entries:

Reporting MariaDB servers
No groups to be reported (check your GNRs)
mysqld_multi log file version 2.20; run: Mo Aug 6 15:15:37 2018

best regards
Andreas

Hi,
we tried to setup a new database Server with Debian 9 , MariaDB 10.2 and mysqld_multi with several instances.
We always get this message:
{noformat}
#mysqld_multi report
Reporting MariaDB servers
No groups to be reported (check your GNRs)
{noformat}
In MariadDB 10.2.14 your test Multi Instance is working:
{noformat}
#msqld_multi report
Reporting MariaDB servers
MariaDB server from group: mysqld16 is not running
{noformat}
This happens with MariaDB 10.2.15, 10.2.16 ad 10.3
Mysqld_multi.log has no helpful entries:
{noformat}
Reporting MariaDB servers
No groups to be reported (check your GNRs)
mysqld_multi log file version 2.20; run: Mo Aug 6 15:15:37 2018
{noformat}
best regards
Andreas

Sergei Golubchik made changes - 2018-08-07 17:13

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2018-08-07 17:13

Assignee

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2018-08-07 17:13

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2018-08-07 17:14

Fix Version/s

10.2 [ 14601 ]

Sergei Golubchik made changes - 2018-08-09 11:48

Fix Version/s		10.2.17 [ 23111 ]
Fix Version/s	10.2 [ 14601 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:47

Workflow

MariaDB v3 [ 88768 ]

MariaDB v4 [ 154757 ]

People

Assignee:: Sergei Golubchik

Reporter:: Tech Nik

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2018-08-06 13:17

Updated:: 2018-08-09 11:48

Resolved:: 2018-08-09 11:48

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Activity

People

Dates

Git Integration