Missing network_id on restarting/host adding to a new shared network

[Evan McGee <ev...@ringplus.net>]

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