Hey everyone,
Having another strange error while trying to get a shared network host up and
running. I can create the shared network successfully using the UI
(Infrastructure -> Zones -> RP -> RP Network 1 -> Guest -> Network -> Add guest
network), but when trying to add a host or restart the network, it gives the
following:
2013-04-29 04:41:18,364 WARN [cloud.network.NetworkManagerImpl]
(Job-Executor-10:job-154) Failed to implement network Ntwk[257|Guest|6]
elements and resources as a part of network restart due to
com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
org.apache.commons.dbcp.DelegatingPreparedStatement@2a43dfc2
at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1311)
at
com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34)
at
com.cloud.network.router.VirtualNetworkApplianceManagerImpl.persist(VirtualNetworkApplianceManagerImpl.java:2492)
...
Caused by: java.sql.SQLException: Field 'network_id' doesn't have a default
value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
...
Here's the full gist at DEBUG level:
https://gist.github.com/emcgee/ec2f805544814eb5ae11 -- (running 4.0.2)
One interesting thing I noticed: the "State" of the Shared Network never gets
passed "Setup" when looking at it in the UI. Here's a gist of listNetworks, if
that's instructive at all. https://gist.github.com/emcgee/47796b2320b42ec3e8d3
Cheers,
Evan