You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Wilder Rodrigues <WR...@schubergphilis.com> on 2014/03/21 11:11:33 UTC
[MASTER] SQL error due to unknown column
Hi all,
Got an error on latest Master and cannot even login via the UI... is anyone working on this?
ERROR [c.c.n.r.VirtualNetworkApplianceManagerImpl] (RouterStatusMonitor-1:ctx-b82e43b9) Fail to complete the CheckRouterTask!
com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@6e6970b6: SELECT networks.id, networks.mode, networks.broadcast_domain_type, networks.traffic_type, networks.name, networks.display_text, networks.broadcast_uri, networks.gateway, networks.cidr, networks.network_cidr, networks.network_offering_id, networks.vpc_id, networks.physical_network_id, networks.data_center_id, networks.related, networks.guru_name, networks.state, networks.dns1, networks.domain_id, networks.account_id, networks.set_fields, networks.guru_data, networks.dns2, networks.network_domain, networks.removed, networks.created, networks.reservation_id, networks.uuid, networks.guest_type, networks.acl_type, networks.restart_required, networks.specify_ip_ranges, networks.ip6_gateway, networks.ip6_cidr, networks.display_network, networks.network_acl_id, networks.streched_l2 FROM networks INNER JOIN network_offerings ON networks.network_offering_id=network_offerings.id WHERE networks.removed IS NULL AND (network_offerings.redundant_router_service = 1 )
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'networks.streched_l2' in 'field list'
at sun.reflect.GeneratedConstructorAccessor86.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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:1053)
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.java:2155)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:419)
... 30 more
Cheers,
Wilder
RE: [MASTER] SQL error due to unknown column
Posted by Wilder Rodrigues <WR...@schubergphilis.com>.
Yep... it works! Thanks. :)
Cheers,
Wilder
-----Original Message-----
From: Murali Reddy [mailto:Murali.Reddy@citrix.com]
Sent: Friday, March 21, 2014 11:24 AM
To: dev@cloudstack.apache.org
Subject: Re: [MASTER] SQL error due to unknown column
Sorry my mistake. I forgot to merge a commit that has necessary schema change.
Can you please try now.
On 21/03/14 3:41 PM, "Wilder Rodrigues" <WR...@schubergphilis.com>
wrote:
>Hi all,
>
>Got an error on latest Master and cannot even login via the UI... is
>anyone working on this?
>
>ERROR [c.c.n.r.VirtualNetworkApplianceManagerImpl]
>(RouterStatusMonitor-1:ctx-b82e43b9) Fail to complete the CheckRouterTask!
>com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
>com.mysql.jdbc.JDBC4PreparedStatement@6e6970b6: SELECT networks.id,
>networks.mode, networks.broadcast_domain_type, networks.traffic_type,
>networks.name, networks.display_text, networks.broadcast_uri,
>networks.gateway, networks.cidr, networks.network_cidr,
>networks.network_offering_id, networks.vpc_id,
>networks.physical_network_id, networks.data_center_id,
>networks.related, networks.guru_name, networks.state, networks.dns1,
>networks.domain_id, networks.account_id, networks.set_fields,
>networks.guru_data, networks.dns2, networks.network_domain,
>networks.removed, networks.created, networks.reservation_id,
>networks.uuid, networks.guest_type, networks.acl_type,
>networks.restart_required, networks.specify_ip_ranges,
>networks.ip6_gateway, networks.ip6_cidr, networks.display_network,
>networks.network_acl_id, networks.streched_l2 FROM networks INNER JOIN
>network_offerings ON networks.network_offering_id=network_offerings.id
>WHERE networks.removed IS NULL AND
>(network_offerings.redundant_router_service = 1 )
>
>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>Unknown column 'networks.streched_l2' in 'field list'
> at
>sun.reflect.GeneratedConstructorAccessor86.newInstance(Unknown Source)
> at
>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCon
>str
>uctorAccessorImpl.java:45)
> at
>java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> 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:1053)
> 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.java
>:21
>55)
> at
>com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
> at
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delega
>tin
>gPreparedStatement.java:96)
> at
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delega
>tin
>gPreparedStatement.java:96)
> at
>com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase
>.ja
>va:419)
> ... 30 more
>
>Cheers,
>Wilder
>
Re: [MASTER] SQL error due to unknown column
Posted by Murali Reddy <Mu...@citrix.com>.
Sorry my mistake. I forgot to merge a commit that has necessary schema
change.
Can you please try now.
On 21/03/14 3:41 PM, "Wilder Rodrigues" <WR...@schubergphilis.com>
wrote:
>Hi all,
>
>Got an error on latest Master and cannot even login via the UI... is
>anyone working on this?
>
>ERROR [c.c.n.r.VirtualNetworkApplianceManagerImpl]
>(RouterStatusMonitor-1:ctx-b82e43b9) Fail to complete the CheckRouterTask!
>com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
>com.mysql.jdbc.JDBC4PreparedStatement@6e6970b6: SELECT networks.id,
>networks.mode, networks.broadcast_domain_type, networks.traffic_type,
>networks.name, networks.display_text, networks.broadcast_uri,
>networks.gateway, networks.cidr, networks.network_cidr,
>networks.network_offering_id, networks.vpc_id,
>networks.physical_network_id, networks.data_center_id, networks.related,
>networks.guru_name, networks.state, networks.dns1, networks.domain_id,
>networks.account_id, networks.set_fields, networks.guru_data,
>networks.dns2, networks.network_domain, networks.removed,
>networks.created, networks.reservation_id, networks.uuid,
>networks.guest_type, networks.acl_type, networks.restart_required,
>networks.specify_ip_ranges, networks.ip6_gateway, networks.ip6_cidr,
>networks.display_network, networks.network_acl_id, networks.streched_l2
>FROM networks INNER JOIN network_offerings ON
>networks.network_offering_id=network_offerings.id WHERE networks.removed
>IS NULL AND (network_offerings.redundant_router_service = 1 )
>
>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>Unknown column 'networks.streched_l2' in 'field list'
> at
>sun.reflect.GeneratedConstructorAccessor86.newInstance(Unknown Source)
> at
>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstr
>uctorAccessorImpl.java:45)
> at
>java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> 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:1053)
> 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.java:21
>55)
> at
>com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
> at
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegatin
>gPreparedStatement.java:96)
> at
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegatin
>gPreparedStatement.java:96)
> at
>com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.ja
>va:419)
> ... 30 more
>
>Cheers,
>Wilder
>