git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: CS 4.10 to 4.11.1 upgrade error


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_ia@xxxxxxxxx>:

> 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_ia@xxxxxxxxx>:
>
>> 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_ia@xxxxxxxxx>:
>>
>>> 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/>


( ! ) Warning: include(msgfooter.php): failed to open stream: No such file or directory in /var/www/git/apache-cloudstack-development/msg07453.html on line 155
Call Stack
#TimeMemoryFunctionLocation
10.0011368808{main}( ).../msg07453.html:0

( ! ) Warning: include(): Failed opening 'msgfooter.php' for inclusion (include_path='.:/var/www/git') in /var/www/git/apache-cloudstack-development/msg07453.html on line 155
Call Stack
#TimeMemoryFunctionLocation
10.0011368808{main}( ).../msg07453.html:0