The server crashes when there is a problem with replicating DDL because the server is inconsistent.  It crashes to initiate an SST or IST in order to become consistent again.

There have historically been various bugs around foreign keys, and I generally don't recommend that they be used with the cluster for that reason, though I'm sure opinions vary on that.

Are you doing rolling schema upgrade (RSU) or total isolation order for your DDL?

Please post the stack trace from the node that crashed, and please file a jira ticket with the contents of it, as well as the DDL executed.

--Justin

On Wed, Mar 2, 2016 at 8:26 AM, Guillaume Lefranc <guillaume.lefranc@mariadb.com> wrote:
the crash is not normal, but you have not posted the stack trace.
If there is one, it would be more worthy to report a bug at jira.mariadb.org so it can be fixed.

On Thu, Feb 25, 2016 at 11:19 AM Lukas Lehner <weblehner@gmail.com> wrote:
thanks for the hint. But is it normal that the hole cluster crashes when user makes an error in table definition?

I googled this error, but never saw that there is a crash

Lukas

On Wed, Feb 24, 2016 at 2:03 PM, <Rhys.Campbell@swisscom.com> wrote:

There’s a foreign key on this table you’re trying to create. There’s something up with the definition of that, different engines or perhaps a data type.

 

Rhys

 

From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=swisscom.com@lists.launchpad.net] On Behalf Of Lukas Lehner
Sent: Wednesday, February 24, 2016 1:50 PM
To: Maria Discuss <maria-discuss@lists.launchpad.net>
Subject: [Maria-discuss] Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp
--
Guillaume Lefranc
Remote DBA Services Manager
MariaDB Corporation

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp