You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Remi Bergsma <RB...@schubergphilis.com> on 2015/08/26 22:33:09 UTC
FYI: MariaDB upgrade on CentOS 7 breaks install
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):
---
[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
Re: FYI: MariaDB upgrade on CentOS 7 breaks install
Posted by Remi Bergsma <RB...@schubergphilis.com>.
Missed that one, thx! ;-)
On 27/08/15 12:03, "Wido den Hollander" <wi...@widodh.nl> wrote:
>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
>>
Re: FYI: MariaDB upgrade on CentOS 7 breaks install
Posted by Remi Bergsma <RB...@schubergphilis.com>.
Hi Wei,
Thanks a lot, this solved it! :-)
Can you open a PR please?
Be sure to ping @wido as he might want to test it on Ubuntu as well. I expect this will also work fine.
Thanks, Remi
On 27/08/15 14:37, "Wei ZHOU" <us...@gmail.com> wrote:
>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 <wi...@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
>> >
>>
Re: FYI: MariaDB upgrade on CentOS 7 breaks install
Posted by Wei ZHOU <us...@gmail.com>.
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 <wi...@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
> >
>
Re: FYI: MariaDB upgrade on CentOS 7 breaks install
Posted by Wido den Hollander <wi...@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
>
Re: FYI: MariaDB upgrade on CentOS 7 breaks install
Posted by Wei ZHOU <us...@gmail.com>.
This might be because CS tries to UPDATE and SELECT from the same table
cloud.configuration.
2015-08-26 22:33 GMT+02:00 Remi Bergsma <RB...@schubergphilis.com>:
> 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):
>
> ---
> [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
>
>