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 <rberg...@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
>
>
