What line are you talking about? On Sat, May 26, 2018 at 3:54 AM, Ivan Kudryavtsev <kudryavtsev...@bw-sw.com> wrote:
> After I manually set delimiter ENDTHAT in the beginning of the file and in > the end, expressions have been correctly processed and upgrade path > completed well. I was able to start 4.11.1 and it functions well. > > 2018-05-26 12:52 GMT+07:00 Ivan Kudryavtsev <kudryavtsev...@bw-sw.com>: > > > The problem is with that file: > > > > https://github.com/apache/cloudstack/blob/9187392ff9cd33b53d5b251076fee2 > > 2b02743477/engine/schema/src/main/resources/META-INF/db/ > > schema-41000to41100.sql > > > > The expressions don't run on mysql and maria as well without the > delimiter. > > > > 2018-05-26 12:27 GMT+07:00 Ivan Kudryavtsev <kudryavtsev...@bw-sw.com>: > > > >> Hello, I found that db upgrade routing is incompatible at least with > >> MariaDB 10.2.10 > >> > >> 2018-05-26 12:03 GMT+07:00 Ivan Kudryavtsev <kudryavtsev...@bw-sw.com>: > >> > >>> Hello, Devs. During upgrade I got an error about missing column: > >>> > >>> SELECT network_offerings.id, network_offerings.name, > >>> network_offerings.unique_name, network_offerings.display_text, > >>> network_offerings.nw_rate, network_offerings.mc_rate, > >>> network_offerings.traffic_type, network_offerings.specify_vlan, > >>> network_offerings.system_only, network_offerings.service_offering_id, > >>> network_offerings.tags, network_offerings.default, > >>> network_offerings.availability, network_offerings.state, > >>> network_offerings.removed, network_offerings.created, > >>> network_offerings.guest_type, network_offerings.dedicated_lb_service, > >>> network_offerings.shared_source_nat_service, > >>> network_offerings.specify_ip_ranges, network_offerings.sort_key, > >>> network_offerings.uuid, network_offerings.redundant_router_service, > >>> network_offerings.conserve_mode, network_offerings.elastic_ip_service, > >>> network_offerings.eip_associate_public_ip, > >>> network_offerings.elastic_lb_service, network_offerings.inline, > >>> network_offerings.is_persistent, network_offerings.for_vpc, > >>> network_offerings.egress_default_policy, network_offerings.concurrent_ > connections, > >>> network_offerings.keep_alive_enabled, network_offerings.supports_ > streched_l2, > >>> network_offerings.supports_public_access, > >>> network_offerings.internal_lb, network_offerings.public_lb, > >>> network_offerings.service_package_id FROM network_offerings WHERE > >>> network_offerings.unique_name = _binary'QuickCloudNoServices' AND > >>> network_offerings.removed IS NULL ORDER BY RAND() LIMIT 1; > >>> ERROR 1054 (42S22): Unknown column 'network_offerings.for_vpc' in > 'field > >>> list' > >>> > >>> I have read > >>> https://markmail.org/message/f42kqr3mx4r4hgih > >>> > >>> But it seems nothing connected to the error in proposed SQL expressions > >>> fixes. > >>> > >>> -- > >>> With best regards, Ivan Kudryavtsev > >>> Bitworks Software, Ltd. > >>> Cell: +7-923-414-1515 > >>> WWW: http://bitworks.software/ <http://bw-sw.com/> > >>> > >>> > >> > >> > >> -- > >> With best regards, Ivan Kudryavtsev > >> Bitworks Software, Ltd. > >> Cell: +7-923-414-1515 > >> WWW: http://bitworks.software/ <http://bw-sw.com/> > >> > >> > > > > > > -- > > With best regards, Ivan Kudryavtsev > > Bitworks Software, Ltd. > > Cell: +7-923-414-1515 > > WWW: http://bitworks.software/ <http://bw-sw.com/> > > > > > > > -- > With best regards, Ivan Kudryavtsev > Bitworks Software, Ltd. > Cell: +7-923-414-1515 > WWW: http://bitworks.software/ <http://bw-sw.com/> > -- Rafael Weingärtner
