cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit Yadav <rohit.ya...@shapeblue.com>
Subject Re: For input string: "9,17"
Date Mon, 02 Aug 2021 11:31:15 GMT
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




 


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