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/>
