Create Table on local tiledb array fail

[jmyvalour]

mariadb: 11.1.4 Tiledb: 2.25.0 Tiledb-mariaDB: 0.33.0

Hello,

Trying to start a few test with newly created array through a C++ component, I am not able to "create" a new table on a local tile array, And I would like to use mariadb plugin to retrieve / select into the array,

following the documentation:

// The following does not create an array, it just informs MariaDB about its existence create table my_array engine=mytile uri='s3://my_bucket/my_array';

I have the root tile array folders here : '/home/user/test/tile/myarray'

Entering the following command: CREATE TABLE data engine=MyTile uri='/home/user/test/tile/myarray';

results in ERROR 1030 (HY000): Got error 155 "The table does not exist in the storage engine" from storage engine MyTile

The array is store locally, not sure if that's the issue ?

The documentation is providing exemple using s3 and local files from what I understand,

CREATE TABLE data ENGINE=mytile uri='MTR_SUITE_DIR/test_data/data';;

Thank you for your help and support,

[Shelnutt2]

Hello @jmyvalour , thanks for opening this. Local paths are support. I've got a few questions which might help us track down what is happening here.

1. How are you running MariaDB/MyTile? Is this in a docker image?
2. Does MariaDB have access to the path where the array is stored? If MariaDB is run in a docker image, did you mount your local storage volume into the docker container?
3. Can you provide a simple ls of /home/user/test/tile/myarray (or whatever the real path is)?

[jmyvalour]

Hello @Shelnutt2 and thank you for your time, Here are the requested answers:

1. It's running on Ubuntu22 recompiled with clang18 and libc++, then imported the plugin into a mariadb server (11.1.4),
2. Indeed, this is fully local on my setup, mariadb is running on the same server where the files are located
3. _~/workspace/md/data/1$ ll total 552 drwxr-xr-x 8 jeremy jeremy 4096 Sep 23 10:46 ./ drwxr-xr-x 3 jeremy jeremy 4096 Sep 23 10:24 ../ drwxr-xr-x 2 jeremy jeremy 266240 Sep 23 10:27 __commits/ drwxr-xr-x 2 jeremy jeremy 4096 Sep 23 10:46 __fragment_meta/ drwxr-xr-x 2314 jeremy jeremy 270336 Sep 23 10:46 __fragments/ drwxr-xr-x 2 jeremy jeremy 4096 Sep 23 10:46 __labels/ drwxr-xr-x 2 jeremy jeremy 4096 Sep 23 10:46 __meta/ drwxr-xr-x 3 jeremy jeremy 4096 Sep 23 10:46 _schema/

[jmyvalour]

Hello,

I rebuilt mariadb 11.1.4 in a ubuntu22 docker image with Tiledb-mariaDB: 0.33.0 against a TileDB 2.25.0, Mariadb DB is crashing all the time due to the plugin call:

Query (0x75d3b40122d0): CREATE TABLE tmhds (d1 float dimension=1 lower_bound="1.0" upper_bound="20.0" tile_extent="5.0", d2 varchar(255) dimension=1, a int ) ENGINE=mytile

241004 11:31:44 [ERROR] mysqld got signal 11 ; /opt/vcpkg/installed/x64-linux/lib/plugin/ha_mytile.so(_ZN4tile6mytileC2EP10handlertonP11TABLE_SHARE+0x2a)[0x75d4352e1b1a] ha_mytile.cc:0(mytile_create_handler(handlerton*, TABLE_SHARE*, st_mem_root*))[0x75d4352f279d] addr2line: './mariadbd': No such file ./mariadbd(_Z15get_new_handlerP11TABLE_SHAREP11st_mem_rootP10handlerton+0x65)[0x5b40eb665ba5] ./mariadbd(_Z22mysql_create_frm_imageP3THDP14HA_CREATE_INFOP10Alter_infoiPP6st_keyPjP34st_mysql_const_unsigned_lex_string+0x13e)[0x5b40eb99c12e] ./mariadbd(+0x12b2eec)[0x5b40eb99eeec] ./mariadbd(_Z26mysql_create_table_no_lockP3THDP16st_ddl_log_stateS2_P22Table_specification_stP10Alter_infoPbiP10TABLE_LIST+0x1d8)[0x5b40eb99e818] ./mariadbd(+0x12c244b)[0x5b40eb9ae44b] ./mariadbd(_ZN25Sql_cmd_create_table_like7executeEP3THD+0x81a)[0x5b40eb9ad44a] ./mariadbd(_Z21mysql_execute_commandP3THDb+0x7a2)[0x5b40eb8e0a92] ./mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x254)[0x5b40eb8dc974] ./mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xc9e)[0x5b40eb8dad7e] ./mariadbd(_Z10do_commandP3THDb+0x25d)[0x5b40eb8dcd6d] ./mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x14f)[0x5b40eba1bfdf] ./mariadbd(handle_one_connection+0x58)[0x5b40eba1bd68] ./mariadbd(+0x14c0cd9)[0x5b40ebbaccd9] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8609)[0x75d461627609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x75d4613e6353]