maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxx> 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@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
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>