Re: CS 4.10 to 4.11.1 upgrade error

2018-05-30 Thread Ivan Kudryavtsev
INF/db/schema-41000to41100.sql file doesn't get executed, > > > therefore, > > > > the idempotent stored procedures do not get created > > > > > > > > > > > > From: Ivan Kudryavtsev > > > > Se

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-29 Thread Daan
s 4.11.1, the > > > META-INF/db/schema-41000to41100.sql file doesn't get executed, > > therefore, > > > the idempotent stored procedures do not get created > > > > > > ____ > > > From: Ivan Kudryavtsev > > &

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-28 Thread Ivan Kudryavtsev
gt; > > it seems that when someone installs 4.11.1, the > > > > > META-INF/db/schema-41000to41100.sql file doesn't get executed, > > > > therefore, > > > > > the idempotent stored procedures do not get created > > > > > > > >

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-28 Thread Daan Hoogland
nsburg < > > > ernie.jvrensb...@shapeblue.com>: > > > > > > > it seems that when someone installs 4.11.1, the > > > > META-INF/db/schema-41000to41100.sql file doesn't get executed, > > > therefore, > > > > the idempotent store

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-28 Thread Ivan Kudryavtsev
, > > > the idempotent stored procedures do not get created > > > > > > > > > From: Ivan Kudryavtsev > > > Sent: Saturday, May 26, 2018 5:26:09 PM > > > To: dev > > > Subject: Re: CS 4.10 to 4.11.1 upgrad

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-28 Thread Daan Hoogland
d > > > > ____ > > From: Ivan Kudryavtsev > > Sent: Saturday, May 26, 2018 5:26:09 PM > > To: dev > > Subject: Re: CS 4.10 to 4.11.1 upgrade error > > > > Rafael, I have read that thread and mentioned it above, but those s

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-28 Thread Ivan Kudryavtsev
#x27;t get executed, therefore, > the idempotent stored procedures do not get created > > > From: Ivan Kudryavtsev > Sent: Saturday, May 26, 2018 5:26:09 PM > To: dev > Subject: Re: CS 4.10 to 4.11.1 upgrade error > > Rafael, I have read that thr

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-28 Thread Ernie Janse van Rensburg
e: CS 4.10 to 4.11.1 upgrade error Rafael, I have read that thread and mentioned it above, but those sql expressions are not connected with the problem above. сб, 26 мая 2018 г., 22:23 Rafael Weingärtner : > Hmm... Isn't there a problem to migrate from 4.10 to 4.11 that is going to > be

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-26 Thread Ivan Kudryavtsev
Rafael, I have read that thread and mentioned it above, but those sql expressions are not connected with the problem above. сб, 26 мая 2018 г., 22:23 Rafael Weingärtner : > Hmm... Isn't there a problem to migrate from 4.10 to 4.11 that is going to > be fixed in 4.11.1? > > On Sat, May 26, 2018 at

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-26 Thread Rafael Weingärtner
Hmm... Isn't there a problem to migrate from 4.10 to 4.11 that is going to be fixed in 4.11.1? On Sat, May 26, 2018 at 12:19 PM, Ivan Kudryavtsev wrote: > Hi, Rafael. The first procedure creation > > CREATE PROCEDURE `cloud`.`IDEMPOTENT_ADD_COLUMN` ( > IN in_table_name VARCHAR(20

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-26 Thread Ivan Kudryavtsev
Hi, Rafael. The first procedure creation CREATE PROCEDURE `cloud`.`IDEMPOTENT_ADD_COLUMN` ( IN in_table_name VARCHAR(200) , IN in_column_name VARCHAR(200) , IN in_column_definition VARCHAR(1000) ) BEGIN DECLARE CONTINUE HANDLER FOR 1060 BEGIN END; SET @ddl = CONCAT('AL

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-26 Thread Rafael Weingärtner
What line are you talking about? On Sat, May 26, 2018 at 3:54 AM, Ivan Kudryavtsev 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 functio

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-25 Thread Ivan Kudryavtsev
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 : > The problem is with that file: > > https

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-25 Thread Ivan Kudryavtsev
The problem is with that file: https://github.com/apache/cloudstack/blob/9187392ff9cd33b53d5b251076fee22b02743477/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 Kudry

Re: CS 4.10 to 4.11.1 upgrade error

2018-05-25 Thread Ivan Kudryavtsev
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 : > Hello, Devs. During upgrade I got an error about missing column: > > SELECT network_offerings.id, network_offerings.name, > network_offerings.unique_name, network_o

CS 4.10 to 4.11.1 upgrade error

2018-05-25 Thread Ivan Kudryavtsev
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,