Windows Server 2012 R2, 64x, 12gb of ram

Hi,

Please specify which MariaDB version you are using, attach your cnf file(s), and paste the result of SHOW CREATE TABLE `table`, {SHOW TABLE STATUS LIKE 'table'}}, SHOW INDEX IN `table`. Feel free to obfuscate the output any way you want, as long as we can still see the general structure of the table and data.

Primitive test doesn't cause the crash:

MariaDB [test]> drop table if exists t;

Query OK, 0 rows affected (0.43 sec)

MariaDB [test]> create table t (f varchar(1024), fulltext index(f), data1 int, data2 int, data3 int) engine=Aria default charset utf8;

Query OK, 0 rows affected (0.62 sec)

MariaDB [test]> insert into t values ('"phrase" 1',1,1,1),('"phrase" 2',2,2,2);

Query OK, 2 rows affected (0.03 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> 

MariaDB [test]> SELECT SQL_NO_CACHE data1, data2, data3 FROM t WHERE MATCH (f) AGAINST('"phrase"' IN BOOLEAN MODE) AND data2 > 0 ORDER BY data2 DESC;

+-------+-------+-------+

| data1 | data2 | data3 |

+-------+-------+-------+

|     2 |     2 |     2 |

|     1 |     1 |     1 |

+-------+-------+-------+

2 rows in set (0.00 sec)

Hi Elena,

I'm using the latest version of Maria, i've attached my config

http://andrew.im/my.ini

I can't run any querys on the plane, but here is a screenshot of the structure

http://i.imgur.com/d8NnsNN.png

I ran a similar query on a smaller Aria table and it was fine, i'm thinking it is a table issue, i dropped it completely and repopulated its data and it is still crashing.

Hi Andrew,

Thanks for the config and the structure.
Regarding the version, MariaDB currently provides 6 major server versions, each of which has a latest version (5.1.67, 5.2.14, 5.3.12, 5.5.42, 10.0.17, 10.1.3), not counting Enterprise builds. So, could you please be more specific?

Thank you.

I'm using 10.0.17

I couldn't reproduce the crash with artificial data, even the same 6+M rows, so I agree, the data is important here.
Would you be able to upload your table (as a set of binary files or as a datadump) to our ftp.askmonty.org/private?

Hi Andrew,

Any news on uploading the data?

Sadly, since it's so dependent on the data, I have to close it as 'can't reproduce'; but please, if you can share the data or somehow else help as to narrow it down, by all means do so, comment on this issue and it will be re-opened.