maria-discuss team mailing list archive

Thread
Date

Re: Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'

To: <weblehner@xxxxxxxxx>, <maria-discuss@xxxxxxxxxxxxxxxxxxx>
From: <Rhys.Campbell@xxxxxxxxxxxx>
Date: Wed, 24 Feb 2016 13:03:25 +0000
Accept-language: en-GB, de-CH, en-US
In-reply-to: <CAA9oQdDiqCHSUt4A+bCOZ=a2qPR7xBw2oV2LDNLyhXNnkfQ_eA@mail.gmail.com>
Thread-index: AQHRbwHt2t8q7gSYYkaAQVxfIuZgMZ87KS8Q
Thread-topic: [Maria-discuss] Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'

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@xxxxxxxxxxxxxxxxxxx] On Behalf Of Lukas Lehner
Sent: Wednesday, February 24, 2016 1:50 PM
To: Maria Discuss <maria-discuss@xxxxxxxxxxxxxxxxxxx>
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-error-cant-create-table-errno-150-on-que

any idea?

howto debug future crashes better?

Lukas

Follow ups

Re: Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'
From: Lukas Lehner, 2016-02-25

References

Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'
From: Lukas Lehner, 2016-02-24