cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajani Karuturi (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CLOUDSTACK-8381) [Master Install] SQL exception are seen in Management server log
Date Wed, 12 Aug 2015 06:15:46 GMT

     [ 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)

Mime
View raw message