Sounds related to bug 21cb33a02ce2ff1e1b22af275068451a3ab6add5
> -----Original Message----- > From: Mike Tutkowski [mailto:mike.tutkow...@solidfire.com] > Sent: Tuesday, August 27, 2013 4:01 PM > To: dev@cloudstack.apache.org > Subject: Can't bring up a new 4.2 environment > > Hi, > > I've tried twice to create a new 4.2 environment (clean DB, starting over from > scratch), but both times I received the following exception (below). > > System VMs won't start. > > Any thoughts on this? > > Thanks! > Mike > > INFO [cloud.secstorage.PremiumSecondaryStorageManagerImpl] > (secstorage-1:) No running secondary storage vms found in datacenter id=1, > starting one INFO [storage.secondary.SecondaryStorageManagerImpl] > (secstorage-1:) No stopped secondary storage vm is available, need to > allocate a new secondary storage vm INFO > [cloud.consoleproxy.ConsoleProxyManagerImpl] (consoleproxy-1:) No > stopped console proxy is available, need to allocate a new console proxy > INFO [storage.volume.VolumeServiceImpl] (consoleproxy-1:) lock is > acquired for VMTemplateStoragePool 1 WARN > [storage.endpoint.DefaultEndPointSelector] (consoleproxy-1:) can't find > endpoint > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExcepti > on: > Column 'id' in where clause is ambiguous at > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructor > AccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCon > structorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja > va:2155) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java > :2318) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(D > elegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(D > elegatingPreparedStatement.java:96) > at > org.apache.cloudstack.storage.endpoint.DefaultEndPointSelector.findEndPoi > ntInScope(DefaultEndPointSelector.java:119) > at > org.apache.cloudstack.storage.endpoint.DefaultEndPointSelector.findEndPoi > ntForImageMove(DefaultEndPointSelector.java:170) > at > org.apache.cloudstack.storage.endpoint.DefaultEndPointSelector.select(Def > aultEndPointSelector.java:178) > at > org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.copyObj > ect(AncientDataMotionStrategy.java:209) > at > org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.copyAsy > nc(AncientDataMotionStrategy.java:411) > at > org.apache.cloudstack.storage.motion.DataMotionServiceImpl.copyAsync(D > ataMotionServiceImpl.java:55) > at > org.apache.cloudstack.storage.volume.VolumeServiceImpl.createBaseImage > Async(VolumeServiceImpl.java:439) > at > org.apache.cloudstack.storage.volume.VolumeServiceImpl.createVolumeFro > mTemplateAsync(VolumeServiceImpl.java:543) > at > com.cloud.storage.VolumeManagerImpl.recreateVolume(VolumeManagerI > mpl.java:2526) > at > com.cloud.storage.VolumeManagerImpl.prepare(VolumeManagerImpl.java: > 2582) > at > com.cloud.vm.VirtualMachineManagerImpl.advanceStart(VirtualMachineMa > nagerImpl.java:888) > at > com.cloud.vm.VirtualMachineManagerImpl.start(VirtualMachineManagerIm > pl.java:578) > at > com.cloud.vm.VirtualMachineManagerImpl.start(VirtualMachineManagerIm > pl.java:571) > at > com.cloud.consoleproxy.ConsoleProxyManagerImpl.startProxy(ConsoleProx > yManagerImpl.java:556) > at > com.cloud.consoleproxy.ConsoleProxyManagerImpl.allocCapacity(ConsolePr > oxyManagerImpl.java:928) > at > com.cloud.consoleproxy.ConsoleProxyManagerImpl.expandPool(ConsolePr > oxyManagerImpl.java:1672) > at > com.cloud.consoleproxy.ConsoleProxyManagerImpl.expandPool(ConsolePr > oxyManagerImpl.java:157) > at > com.cloud.vm.SystemVmLoadScanner.loadScan(SystemVmLoadScanner.java > :111) > at > com.cloud.vm.SystemVmLoadScanner.access$100(SystemVmLoadScanner.ja > va:33) > at > com.cloud.vm.SystemVmLoadScanner$1.reallyRun(SystemVmLoadScanner.j > ava:81) > at > com.cloud.vm.SystemVmLoadScanner$1.run(SystemVmLoadScanner.java:72) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) > at > java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:31 > 7) > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.ac > cess$101(ScheduledThreadPoolExecutor.java:98) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.ru > nPeriodic(ScheduledThreadPoolExecutor.java:180) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.ru > n(ScheduledThreadPoolExecutor.java:204) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecut > or.java:895) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja > va:918) > at java.lang.Thread.run(Thread.java:680) > > > > -- > *Mike Tutkowski* > *Senior CloudStack Developer, SolidFire Inc.* > e: mike.tutkow...@solidfire.com > o: 303.746.7302 > Advancing the way the world uses the > cloud<http://solidfire.com/solution/overview/?video=play> > *(tm)*