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 <rohit.ya...@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 <users@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
