cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wei ZHOU <ustcweiz...@gmail.com>
Subject Re: FYI: MariaDB upgrade on CentOS 7 breaks install
Date Thu, 27 Aug 2015 12:37:42 GMT
Hi Remi,

Can you test the following change?

# git diff setup/db/db/schema-421to430.sql
diff --git a/setup/db/db/schema-421to430.sql
b/setup/db/db/schema-421to430.sql
index 3f2ad02..0a96ea0 100644
--- a/setup/db/db/schema-421to430.sql
+++ b/setup/db/db/schema-421to430.sql
@@ -111,8 +111,7 @@ CREATE TABLE `cloud`.`async_job_join_map` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 #realhostip changes, before changing table and adding default value
-UPDATE `cloud`.`configuration` SET value = CONCAT("*.",(SELECT
`temptable`.`value` FROM (SELECT * FROM `cloud`.`configuration` WHERE
`name`="consoleproxy.url.domain") AS `temptable` WHERE
`temptable`.`name`="consoleproxy.url.domain")) W
-UPDATE `cloud`.`configuration` SET `value` = CONCAT("*.",(SELECT
`temptable`.`value` FROM (SELECT * FROM `cloud`.`configuration` WHERE
`name`="secstorage.ssl.cert.domain") AS `temptable` WHERE
`temptable`.`name`="secstorage.ssl.cert.dom
+UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE
`name`="consoleproxy.url.domain" OR `name`="secstorage.ssl.cert.domain";

 ALTER TABLE `cloud`.`configuration` ADD COLUMN `default_value`
VARCHAR(4095) COMMENT 'Default value for a configuration parameter';
 ALTER TABLE `cloud`.`configuration` ADD COLUMN `updated` datetime COMMENT
'Time this was updated by the server. null means this row is obsolete.';




2015-08-27 12:03 GMT+02:00 Wido den Hollander <wido@widodh.nl>:

> On 08/26/2015 10:33 PM, Remi Bergsma wrote:
> > Hi all,
> >
> > Not sure if MariaDB is even supported, but for those who use it:
> >
> > Today I run into an issue with the latest MariaDB on CentOS7 (it was
> upgraded from 5.5.41 -> 5.5.44). After the upgrade I could no longer
> install CloudStack due to the following error (traced it to this file by
> executing all steps manually):
> >
> > ---
>
> I've seen this as well on a clean install on Ubuntu 14.04, even with
> MariaDB 10.
>
> I posted it on the list before:
>
> http://mail-archives.apache.org/mod_mbox/cloudstack-dev/201508.mbox/%3C55C1C38F.9090901@widodh.nl%3E
>
> Wido
>
> > [root@cs3 db]# mysql cloud <
> /data/git/cs3/cloudstack/developer/target/db/db/schema-421to430.sql
> > ERROR 2013 (HY000) at line 114: Lost connection to MySQL server during
> query
> >
> > Trying to get some variables.
> > Some pointers may be invalid and cause the dump to abort.
> > Query (0x7fc8909cd318): UPDATE `cloud`.`configuration` SET value =
> CONCAT("*.",(SELECT `temptable`.`value` FROM (SELECT * FROM
> `cloud`.`configuration` WHERE `name`="consoleproxy.url.domain") AS
> `temptable` WHERE `temptable`.`name`="consoleproxy.url.domain")) WHERE
> `name`="consoleproxy.url.domain"
> > Connection ID (thread ID): 10
> > Status: NOT_KILLED
> >
> > Optimizer switch:
> index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off
> >
> > The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html
> contains
> > information that should help you find out what is causing the crash.
> > ---
> >
> > The MySQL server crashed, then restarted. I haven't debugged it further
> but a downgrade works:
> >
> > systemctl stop mariadb
> > yum remove mariadb-libs
> > yum install mariadb-1:5.5.41-2.el7_0.x86_64
> > yum install mariadb-server-1:5.5.41-2.el7_0.x86_64
> > systemctl start mariadb
> >
> > Just in case someone else runs into it.
> >
> > Regards,
> > Remi
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message