ERROR 1030 (HY000): Got error 122 from storage engine

[vincent]

Hi,
I've compiled from source lp:codership-maria and lp:galera/0.8 today.
Set it up between two node in two datacenters.
I'm getting this error while trying to insert a row:

# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 27
Server version: 5.1.56-MariaDB-log wsrep_0.8

This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
and you are welcome to modify and redistribute it under the GPL v2
license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]> use test
Database changed
MariaDB [test]> create table bla (`id` int(11) NOT NULL
AUTO_INCREMENT,`created_at` datetime DEFAULT NULL,PRIMARY KEY
(`id`))ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci -> ;
Query OK, 0 rows affected (0.06 sec)

MariaDB [test]> insert into bla values (1, NULL);
ERROR 1030 (HY000): Got error 122 from storage engine

with an error in syslog:
Jun 28 12:53:10 li116-21 mysqld: 110628 12:53:10 [Warning] WSREP:
galera_append_query() is deprecated
Jun 28 12:53:10 li116-21 mysqld: 110628 12:53:10 [Warning] WSREP: row
key failed: insert into bla values (1, NULL),

Is there a special branch on codership-maria / galera to make them
work together?

regards

Vincent

[Alex Yurchenko]

Hi Vincent,

First off, lp:codership-maria branch is not tested much and is not
recommended for use or evaluation. If you're looking for InnoDB plugin
support, regular lp:codership-mysql/0.8 supports that just fine. Make
sure that you use release_0.8.0b tag (-r 3074)

Secondly, please check binlog_format value. It should be ROW.

Regards,
Alex

--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011

[vincent]

Thanks for the answer
setting binlog_format to row did the trick...I should have have read
the http://www.codership.com/content/galera-configuration

I will use the mysql version.

regards

Vincent

On 29 juin, 15:21, Alex Yurchenko <alexey.yurche...@codership.com>
wrote:

[Alex Yurchenko]

Great! Thanks for reporting this. I pushed some checks to prevent such
situations.

Thanks,
Alex

On Wed, 29 Jun 2011 06:54:05 -0700 (PDT), vincent wrote:
> Thanks for the answer
> setting binlog_format to row did the trick...I should have have read
> the http://www.codership.com/content/galera-configuration
>
> I will use the mysql version.
>
> regards
>
> Vincent
>

--