Raja Pullela created CLOUDSTACK-8381:
----------------------------------------
Summary: [Master Install] SQL exception are seen in Management
server log
Key: CLOUDSTACK-8381
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8381
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Install and Setup
Affects Versions: 4.6.0
Reporter: Raja Pullela
Priority: Critical
Fix For: 4.6.0
Following error is seen in the Management server log -
SQL Exceptions
2015-04-13 07:49:24,872 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop key last_sent on table alert
exception: Can't DROP 'last_sent'; check that column/key exists
2015-04-13 07:49:24,872 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop key i_alert__last_sent on table alert
exception: Can't DROP 'i_alert__last_sent'; check that column/key exists
2015-04-13 07:49:24,881 DEBUG [c.c.u.d.Upgrade410to420] (main:null) Added index
i_alert__last_sent for table alert
2015-04-13 07:49:24,888 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_nsp_id on table baremetal_dhcp_devices exception:
Error on rename of './cloud/baremetal_dhcp_devices' to './cloud/#sql2-a94-15'
(errno: 152)
2015-04-13 07:49:24,896 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_host_id on table baremetal_dhcp_devices exception:
Error on rename of './cloud/baremetal_dhcp_devices' to './cloud/#sql2-a94-15'
(errno: 152)
2015-04-13 07:49:24,902 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_pod_id on table baremetal_dhcp_devices exception:
Error on rename of './cloud/baremetal_dhcp_devices' to './cloud/#sql2-a94-15'
(errno: 152)
2015-04-13 07:49:24,908 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_physical_network_id on table baremetal_dhcp_devices
exception: Error on rename of './cloud/baremetal_dhcp_devices' to
'./cloud/#sql2-a94-15' (errno: 152)
2015-04-13 07:49:24,915 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_nsp_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-a94-15' (errno:
152)
2015-04-13 07:49:24,921 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_host_id on table baremetal_pxe_devices exception:
Error on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-a94-15'
(errno: 152)
2015-04-13 07:49:24,927 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_pod_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-a94-15' (errno:
152)
2015-04-13 07:49:24,932 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_dhcp_devices_physical_network_id on table baremetal_pxe_devices
exception: Error on rename of './cloud/baremetal_pxe_devices' to
'./cloud/#sql2-a94-15' (errno: 152)
2015-04-13 07:49:24,943 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_pxe_devices_nsp_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-a94-15' (errno:
152)
2015-04-13 07:49:24,949 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_pxe_devices_host_id on table baremetal_pxe_devices exception: Error
on rename of './cloud/baremetal_pxe_devices' to './cloud/#sql2-a94-15' (errno:
152)
2015-04-13 07:49:24,955 DEBUG [c.c.u.d.DatabaseAccessObject] (main:null)
Ignored SQL Exception when trying to drop foreign key
fk_external_pxe_devices_physical_network_id on table baremetal_pxe_devices
exception: Error on rename of './cloud/baremetal_pxe_devices' to
'./cloud/#sql2-a94-15' (errno: 152)
>>>
2015-04-13 07:50:08,590 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught (SQL?)Exception: no network_group Table 'cloud.network_group' doesn't
exist
>>>>
2015-04-13 07:55:40,419 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught exception when inserting system account: Duplicate entry '1' for key
'PRIMARY'
2015-04-13 07:55:40,420 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught SQLException when inserting system user: Duplicate entry '1' for key
'PRIMARY'
2015-04-13 07:55:40,421 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught SQLException when creating admin account: Duplicate entry '2' for key
'PRIMARY'
2015-04-13 07:55:40,421 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught SQLException when inserting admin user: Duplicate entry '2' for key
'PRIMARY'
2015-04-13 07:55:40,423 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught (SQL?)Exception: no network_group Table 'cloud.network_group' doesn't
exist
>>>>
2015-04-13 07:56:52,621 INFO [c.c.u.d.GenericDaoBase] (main:null) Cache
created: [ name = VlanDaoImpl status = STATUS_ALIVE eternal = false
overflowToDisk = false maxEntriesLocalHeap = 30 maxEntriesLocalDisk = 0
memoryStoreEvictionPolicy = LRU timeToLiveSeconds = 3600 timeToIdleSeconds =
300 persistence = none diskExpiryThreadIntervalSeconds = 120
cacheEventListeners: net.sf.ehcache.statistics.LiveCacheStatisticsWrapper
hitCount = 0 memoryStoreHitCount = 0 diskStoreHitCount = 0 missCountNotFound =
0 missCountExpired = 0 maxBytesLocalHeap = 0 overflowToOffHeap = false
maxBytesLocalOffHeap = 0 maxBytesLocalDisk = 0 pinned = false ]
2015-04-13 07:56:52,638 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught exception when inserting system account: Duplicate entry '1' for key
'PRIMARY'
2015-04-13 07:56:52,638 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught SQLException when inserting system user: Duplicate entry '1' for key
'PRIMARY'
2015-04-13 07:56:52,639 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught SQLException when creating admin account: Duplicate entry '2' for key
'PRIMARY'
2015-04-13 07:56:52,639 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught SQLException when inserting admin user: Duplicate entry '2' for key
'PRIMARY'
2015-04-13 07:56:52,640 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
Caught (SQL?)Exception: no network_group Table 'cloud.network_group' doesn't
exist
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
