cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daan Hoogland <daan.hoogl...@gmail.com>
Subject Re: For input string: "9,17"
Date Mon, 02 Aug 2021 13:24:50 GMT
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.yadav@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 <piotr@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message