arcadedb: Receive `ArrayIndexOutOfBoundsException` when inserting to type with full text index with multiple properties defined.

ArcadeDB Version:

ArcadeDB Server v23.12.1 (build df4e3d56e9063a245b46bca14001e393dc7f8001/1704296563159/main)

OS and JDK Version:

Linux 5.10.0-26-amd64 - OpenJDK 64-Bit Server VM 11.0.21 (Temurin-11.0.21+9)

Expected behavior

No errors when inserting new records to a type that has a full text index containing multiple fields.

Actual behavior

For the most part this works as expected, however now and again we find when inserting to a document type we starting receiving ArrayIndexOutOfBoundsException errors.

We then drop and create the full text index which resolves the error.

I don’t seem to get the same issue with full text indexes with a single property however because it feels quite random it might be that I haven’t come across it yet.

Steps to reproduce

I have not yet found a way to consistently reproduce the issue, I will keep trying though.

About this issue

Original URL
State: closed
Created 5 months ago
Comments: 16 (9 by maintainers)

Commits related to this issue

fix: API should return an error when a full-text index is built as composite Fixed issue #1435 — committed to ArcadeData/arcadedb by lvca 5 months ago
fix: error on reload of full text index after db closing Fixed issue #1435 — committed to ArcadeData/arcadedb by lvca 5 months ago
fix: replace full text index in index map Fixed issue #1435 — committed to ArcadeData/arcadedb by lvca 5 months ago

Most upvoted comments

Now you have reproduced the issue you might not need this but I noticed that if I create a database with a full text index then restart the docker container the reported type of the index in studio switches from FULL_TEXT to LSM_TREE.

Before the restart

                {
                    "name": "authentication-token[ip,userAction]",
                    "typeName": "authentication-token",
                    "type": "FULL_TEXT",
                    "unique": false,
                    "properties": [
                        "ip",
                        "userAction"
                    ],
                    "automatic": true
                }

After the restart

                {
                    "name": "authentication-token[ip,userAction]",
                    "typeName": "authentication-token",
                    "type": "LSM_TREE",
                    "unique": false,
                    "properties": [
                        "ip",
                        "userAction"
                    ],
                    "automatic": true
                }

alan-strickland-red on Jan 29, 2024