[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
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
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 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
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
participants (4)
-
Guillaume Lefranc -
Justin Swanhart -
Lukas Lehner -
Rhys.Campbell＠swisscom.com