[ https://issues.apache.org/jira/browse/CLOUDSTACK-8381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rajani Karuturi updated CLOUDSTACK-8381: ---------------------------------------- Fix Version/s: (was: 4.6.0) > [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 > > 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)