E! Error in plugin: Error 1054: Unknown column 'status' in 'where clause'"

[gregfr]

Greetings

I've just made a very simple set up:

• a system with Galera Manager
• an empty system which has been installed by Galera Manager

both are running a fresh clean Debian 11.

the node log is filled with this error:

telegraf[6057]: 2023-03-22T15:57:11Z E! [inputs.execd] stderr: "2023/03/22 16:57:11 E! Error in plugin: Error 1054: Unknown column 'status' in 'where clause'" 

what am I doing wrong?

thanks in advance

Regards

[RomkaKharkov]

Hi,

I have same issue. Anyone know how to fix ?

// 
// gmd version 1.7.5 (os/arch: linux/amd64, git: e5325a9)
// "Debian GNU/Linux 11 (bullseye)"
// Server version: 10.6.14-MariaDB-1:10.6.14+maria~deb11 mariadb.org binary distribution
// (nodes installed via GM)
//

[lemarakis]

Hello, I am facing the same issue. Have you found any solution? https://github.com/codership/galera-manager-support/issues/99#issue-2206828775

[arenner-git]

Hi,

same setup, same problem here.

[lemarakis]

Fresh install with : gm-installer version 1.13.0 (linux/amd64) Debian 12 Galera Manager 1.8.4

Same problem, every 1 sec I am getting the following 5 records on syslog

• Mar 31 00:29:23 MariaDB-221 gma[1010]: time="2024-03-31T00:29:23+02:00" level=info msg="Connecting (used scheme http)..."

• Mar 31 00:29:23 MariaDB-221 gma[1010]: time="2024-03-31T00:29:23+02:00" level=info msg="Creating agentcom stream..."

• Mar 31 00:29:23 MariaDB-221 gma[1010]: time="2024-03-31T00:29:23+02:00" level=error msg="Failed to create stream: rpc error: code = Unavailable desc = connection error: desc = \"error reading server preface: http2: frame too large\""

• Mar 31 00:29:23 MariaDB-221 gma[1010]: time="2024-03-31T00:29:23+02:00" level=error msg="Error while serving: rpc error: code = Unavailable desc = connection error: desc = \"error reading server preface: http2: frame too large\"; sleeping for 1 second"

• Mar 31 00:29:24 MariaDB-221 telegraf[6062]: 2024-03-30T22:29:24Z E! [inputs.execd] stderr: "2024/03/31 00:29:24 E! Error in plugin: Error 1054: Unknown column 'status' in 'where clause'"

Edit: I stopped the agent with systemctl stop gma, the messages about gma stopped as well.

Still getting the following from telegraf and inputs.execd plugin

• Mar 31 00:41:07 MariaDB-221 telegraf[7196]: 2024-03-30T22:41:07Z E! [inputs.execd] stderr: "2024/03/31 00:41:07 E! Error in plugin: Error 1054: Unknown column 'status' in 'where clause'"

Any Ideas?

[lemarakis]

The logs from telegraf stopped when changed the /etc/telegraf/mysql_wsrep-telegraf-plugin.conf as suggested here https://github.com/influxdata/telegraf/issues/7968#issuecomment-672718669