Yep... it works! Thanks. :) Cheers, Wilder
-----Original Message----- From: Murali Reddy [mailto:murali.re...@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" <wrodrig...@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 >
