You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Piotr Pisz <pi...@piszki.pl> on 2021/08/02 11:07:26 UTC
For input string: "9,17"
Hello!
I test CS 4.15.1 in CentOS 8 and generally everything works fine except one,
in the UI in Hosts I get the message as in the title (in the old client
everything is displayed correctly, hosts are added without any problems).
Additionally, during the first run of CS in the mysqld log, I have the
following errors (repeatable situation):
2021-08-02T07:31:52.517022Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'last_sent'; check that column/key exists' on query. Default
database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY last_sent',
Error_code: 1091
2021-08-02T07:31:52.550760Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_alert__last_sent'; check that column/key exists' on query.
Default database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY
i_alert__last_sent', Error_code: 1091
2021-08-02T07:31:52.644593Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T07:31:52.673335Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T07:31:52.702194Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T07:31:52.730876Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T07:31:52.759647Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T07:31:52.786909Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T07:31:52.815723Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T07:31:52.842728Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T07:31:52.871752Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_nsp_id',
Error_code: 1091
2021-08-02T07:31:52.901718Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_host_id',
Error_code: 1091
2021-08-02T07:31:52.930556Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_pxe_devices_physical_network_id', Error_code: 1091
2021-08-02T07:32:22.443707Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_vm_instance__instance_name'; check that column/key exists' on
query. Default database: 'cloud'. Query: 'ALTER TABLE vm_instance DROP KEY
i_vm_instance__instance_name', Error_code: 1091
2021-08-02T08:45:04.860523Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'last_sent'; check that column/key exists' on query. Default
database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY last_sent',
Error_code: 1091
2021-08-02T08:45:04.895740Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_alert__last_sent'; check that column/key exists' on query.
Default database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY
i_alert__last_sent', Error_code: 1091
2021-08-02T08:45:04.995544Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T08:45:05.021827Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T08:45:05.048576Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T08:45:05.074874Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T08:45:05.102186Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T08:45:05.128488Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T08:45:05.154926Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T08:45:05.181582Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T08:45:05.207869Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_nsp_id',
Error_code: 1091
2021-08-02T08:45:05.233866Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_host_id',
Error_code: 1091
2021-08-02T08:45:05.259871Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_pxe_devices_physical_network_id', Error_code: 1091
2021-08-02T08:45:34.566286Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_vm_instance__instance_name'; check that column/key exists' on
query. Default database: 'cloud'. Query: 'ALTER TABLE vm_instance DROP KEY
i_vm_instance__instance_name', Error_code: 1091
It bothers me a bit, I don't know how much I can trust this installation.
Regards,
Piotr
Re: For input string: "9,17"
Posted by Daan Hoogland <da...@gmail.com>.
Piotr,
as for the message in the title; Do you, in Poland, have a locale active
that uses a comma ',' as the decimal separator, as opposed to a point '.'?
this looks like something I saw in German and Dutch installations as well.
as a temp workaround set your locale to "c" or "English". I thought it was
fixed in the latest version, so I might put you on the wrong track.
regards,
On Mon, Aug 2, 2021 at 1:31 PM Rohit Yadav <ro...@shapeblue.com>
wrote:
> Hi Piotr,
>
> Can you share if you're using MySQL 8.x or other specific version? And in
> case the MySQL server was upgraded either before/after upgrading to 4.15.1?
> The error suggests some constraints are blocking the upgrade path
> queries,w hcih shouldn't really happen. You may want to keep a backup of
> the DB dump prior to the upgrade if you've or just after in case you want
> to revert and start again the DB snapshot/dump.
>
>
> Regards.
>
> ________________________________
> From: Piotr Pisz <pi...@piszki.pl>
> Sent: Monday, August 2, 2021 16:37
> To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
> Subject: For input string: "9,17"
>
> Hello!
>
>
>
> I test CS 4.15.1 in CentOS 8 and generally everything works fine except
> one,
> in the UI in Hosts I get the message as in the title (in the old client
> everything is displayed correctly, hosts are added without any problems).
>
> Additionally, during the first run of CS in the mysqld log, I have the
> following errors (repeatable situation):
>
>
>
> 2021-08-02T07:31:52.517022Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'last_sent'; check that column/key exists' on query. Default
> database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY last_sent',
> Error_code: 1091
>
> 2021-08-02T07:31:52.550760Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'i_alert__last_sent'; check that column/key exists' on query.
> Default database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY
> i_alert__last_sent', Error_code: 1091
>
> 2021-08-02T07:31:52.644593Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.673335Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
> exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.702194Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.730876Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
> column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY
> fk_external_dhcp_devices_physical_network_id', Error_code: 1091
>
> 2021-08-02T07:31:52.759647Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.786909Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
> exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.815723Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.842728Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
> column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY
> fk_external_dhcp_devices_physical_network_id', Error_code: 1091
>
> 2021-08-02T07:31:52.871752Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_nsp_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.901718Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_host_id',
> Error_code: 1091
>
> 2021-08-02T07:31:52.930556Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that
> column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY
> fk_external_pxe_devices_physical_network_id', Error_code: 1091
>
> 2021-08-02T07:32:22.443707Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'i_vm_instance__instance_name'; check that column/key exists'
> on
> query. Default database: 'cloud'. Query: 'ALTER TABLE vm_instance DROP KEY
> i_vm_instance__instance_name', Error_code: 1091
>
> 2021-08-02T08:45:04.860523Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'last_sent'; check that column/key exists' on query. Default
> database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY last_sent',
> Error_code: 1091
>
> 2021-08-02T08:45:04.895740Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'i_alert__last_sent'; check that column/key exists' on query.
> Default database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY
> i_alert__last_sent', Error_code: 1091
>
> 2021-08-02T08:45:04.995544Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.021827Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
> exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.048576Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.074874Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
> column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_dhcp_devices DROP FOREIGN KEY
> fk_external_dhcp_devices_physical_network_id', Error_code: 1091
>
> 2021-08-02T08:45:05.102186Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.128488Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
> exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.154926Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.181582Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
> column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY
> fk_external_dhcp_devices_physical_network_id', Error_code: 1091
>
> 2021-08-02T08:45:05.207869Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_nsp_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.233866Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key
> exists'
> on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_host_id',
> Error_code: 1091
>
> 2021-08-02T08:45:05.259871Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that
> column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
> baremetal_pxe_devices DROP FOREIGN KEY
> fk_external_pxe_devices_physical_network_id', Error_code: 1091
>
> 2021-08-02T08:45:34.566286Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
> 'Can't DROP 'i_vm_instance__instance_name'; check that column/key exists'
> on
> query. Default database: 'cloud'. Query: 'ALTER TABLE vm_instance DROP KEY
> i_vm_instance__instance_name', Error_code: 1091
>
>
>
> It bothers me a bit, I don't know how much I can trust this installation.
>
>
>
> Regards,
>
> Piotr
>
>
>
>
>
>
>
--
Daan
Re: For input string: "9,17"
Posted by Rohit Yadav <ro...@shapeblue.com>.
Hi Piotr,
Can you share if you're using MySQL 8.x or other specific version? And in case the MySQL server was upgraded either before/after upgrading to 4.15.1?
The error suggests some constraints are blocking the upgrade path queries,w hcih shouldn't really happen. You may want to keep a backup of the DB dump prior to the upgrade if you've or just after in case you want to revert and start again the DB snapshot/dump.
Regards.
________________________________
From: Piotr Pisz <pi...@piszki.pl>
Sent: Monday, August 2, 2021 16:37
To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
Subject: For input string: "9,17"
Hello!
I test CS 4.15.1 in CentOS 8 and generally everything works fine except one,
in the UI in Hosts I get the message as in the title (in the old client
everything is displayed correctly, hosts are added without any problems).
Additionally, during the first run of CS in the mysqld log, I have the
following errors (repeatable situation):
2021-08-02T07:31:52.517022Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'last_sent'; check that column/key exists' on query. Default
database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY last_sent',
Error_code: 1091
2021-08-02T07:31:52.550760Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_alert__last_sent'; check that column/key exists' on query.
Default database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY
i_alert__last_sent', Error_code: 1091
2021-08-02T07:31:52.644593Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T07:31:52.673335Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T07:31:52.702194Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T07:31:52.730876Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T07:31:52.759647Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T07:31:52.786909Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T07:31:52.815723Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T07:31:52.842728Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T07:31:52.871752Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_nsp_id',
Error_code: 1091
2021-08-02T07:31:52.901718Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_host_id',
Error_code: 1091
2021-08-02T07:31:52.930556Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_pxe_devices_physical_network_id', Error_code: 1091
2021-08-02T07:32:22.443707Z 30 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_vm_instance__instance_name'; check that column/key exists' on
query. Default database: 'cloud'. Query: 'ALTER TABLE vm_instance DROP KEY
i_vm_instance__instance_name', Error_code: 1091
2021-08-02T08:45:04.860523Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'last_sent'; check that column/key exists' on query. Default
database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY last_sent',
Error_code: 1091
2021-08-02T08:45:04.895740Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_alert__last_sent'; check that column/key exists' on query.
Default database: 'cloud'. Query: 'ALTER TABLE alert DROP KEY
i_alert__last_sent', Error_code: 1091
2021-08-02T08:45:04.995544Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T08:45:05.021827Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T08:45:05.048576Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T08:45:05.074874Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_dhcp_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T08:45:05.102186Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_nsp_id',
Error_code: 1091
2021-08-02T08:45:05.128488Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_host_id'; check that column/key
exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_host_id',
Error_code: 1091
2021-08-02T08:45:05.154926Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_pod_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_dhcp_devices_pod_id',
Error_code: 1091
2021-08-02T08:45:05.181582Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_dhcp_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_dhcp_devices_physical_network_id', Error_code: 1091
2021-08-02T08:45:05.207869Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_nsp_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_nsp_id',
Error_code: 1091
2021-08-02T08:45:05.233866Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_host_id'; check that column/key exists'
on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY fk_external_pxe_devices_host_id',
Error_code: 1091
2021-08-02T08:45:05.259871Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'fk_external_pxe_devices_physical_network_id'; check that
column/key exists' on query. Default database: 'cloud'. Query: 'ALTER TABLE
baremetal_pxe_devices DROP FOREIGN KEY
fk_external_pxe_devices_physical_network_id', Error_code: 1091
2021-08-02T08:45:34.566286Z 54 [Warning] [MY-000000] [WSREP] Ignoring error
'Can't DROP 'i_vm_instance__instance_name'; check that column/key exists' on
query. Default database: 'cloud'. Query: 'ALTER TABLE vm_instance DROP KEY
i_vm_instance__instance_name', Error_code: 1091
It bothers me a bit, I don't know how much I can trust this installation.
Regards,
Piotr
RE: For input string: "9,17"
Posted by Piotr Pisz <pi...@piszki.pl>.
Hello,
I guess it's not the locale's fault. I run the test environment on CentOS 8 and 4.15.1, this error appeared when I was using mysql-8-wsrep and galera-4, when I changed the DB to Mysql 8 (native with CentOS 8) the problem did not appear. In both cases, the locals in Mysql were set to en_US.
I also checked what Daan wrote about, the problem occurred in both cases when the locals were set to pl_PL and en_US.
I'm guessing this is something deeper in 4.15.1
But I have a question, why the CentOS 8 packages force you to install mysql-8 dependencies? On other systems it doesn't. We have been using the mariadb-galera cluster for a long time and forcing mysql-8 is a big problem.
Piotr
-----Original Message-----
From: James Steele <js...@gmail.com>
Sent: Wednesday, August 4, 2021 12:30 PM
To: users@cloudstack.apache.org
Subject: Re: For input string: "9,17"
Could someone using Ubuntu 20.04, and the 4.15.1.0 webui - who can click on 'Infrastructure' then 'Hosts' without errors and have it list correctly, please post the output of:
locale -v
It would nice to know a working input locale, and whether UTF or ISO-8859 is needed.
When I click 'Infrastructure' then 'Hosts' in the webui
(http://10.257.0.4:8080/client/) the error message: '(X) For input string: "
"' is shown briefly.
The old client works fine (http://10.257.0.4:8080/client/legacy/).
Thanks!
Re: For input string: "9,17"
Posted by James Steele <js...@gmail.com>.
Could someone using Ubuntu 20.04, and the 4.15.1.0 webui - who can click on 'Infrastructure' then 'Hosts' without errors and have it list correctly, please post the output of:
locale -v
It would nice to know a working input locale, and whether UTF or ISO-8859 is needed.
When I click 'Infrastructure' then 'Hosts' in the webui (http://10.257.0.4:8080/client/) the error message: '(X) For input string: " "' is shown briefly.
The old client works fine (http://10.257.0.4:8080/client/legacy/).
Thanks!