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'

Hi

http://dba.stackexchange.com/questions/130307/galera-crash-error-slave-sql-e...

any idea?

howto debug future crashes better?

Lukas

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'

Hi

http://dba.stackexchange.com/questions/130307/galera-crash-error-slave-sql-e...

any idea?

howto debug future crashes better?

Lukas

_______________________________________________ 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