400 error on query execution (REST), no error description

[ExtReMLapin]

First time I have this issue, weird.

URL : http://localhost:2480/api/v1/command/NEW_ORANO

Whole json payload :

out.json

Database dump right on error :

ORANO-backup-20260123-214803557.zip

console logs :

2026-01-23 21:39:18.264 INFO  [ArcadeDBServer] <ArcadeDB_0> Databases directory: ./databases
2026-01-23 21:39:18.264 INFO  [ArcadeDBServer] <ArcadeDB_0> Backups directory: ./backups
2026-01-23 21:39:18.598 INFO  [VectorizationProvider] Preferred f32 species is 256
2026-01-23 21:39:18.599 INFO  [VectorizationProvider] Java incubating Vector API enabled. Using PanamaVectorizationProvider.
2026-01-23 21:39:18.601 INFO  [LSMVectorIndex] <ArcadeDB_0> Discovered and loaded graph file: EMBEDDING_0_53222137926900_vecgraph (fileId=36)
2026-01-23 21:39:18.602 INFO  [LSMVectorIndex] <ArcadeDB_0> Discovered and loaded graph file: CHUNK_EMBEDDING_0_53222147549100_vecgraph (fileId=41)
2026-01-23 21:39:18.604 INFO  [LSMVectorIndex] <ArcadeDB_0> Discovered and loaded graph file: NER_EMBEDDING_0_53222156811000_vecgraph (fileId=46)
2026-01-23 21:39:18.605 INFO  [LSMVectorIndex] <ArcadeDB_0> Discovered and loaded graph file: IMAGE_EMBEDDING_0_53222165645100_vecgraph (fileId=51)
2026-01-23 21:39:18.605 INFO  [LSMVectorIndex] <ArcadeDB_0> Discovered and loaded graph file: SUMMARY_EMBEDDING_0_53222174404500_vecgraph (fileId=56)
2026-01-23 21:39:18.606 INFO  [LSMVectorIndex] <ArcadeDB_0> Discovered and loaded graph file: DOCUMENT_EMBEDDING_0_53222183239200_vecgraph (fileId=61)
2026-01-23 21:39:18.651 SEVER [LSMVectorIndex] <ArcadeDB_0> loadVectorsAfterSchemaLoad called for index EMBEDDING_0_53222137926900: dimensions=1024, mutablePages=0, hasGraphFile=true
2026-01-23 21:39:18.651 SEVER [LSMVectorIndex] <ArcadeDB_0> Skipping vector load for index EMBEDDING_0_53222137926900 (dimensions=1024, pages=0)
2026-01-23 21:39:18.651 SEVER [LSMVectorIndex] <ArcadeDB_0> loadVectorsAfterSchemaLoad called for index CHUNK_EMBEDDING_0_53222147549100: dimensions=1024, mutablePages=1, hasGraphFile=true
2026-01-23 21:39:18.652 SEVER [LSMVectorIndex] <ArcadeDB_0> Loading vectors for index CHUNK_EMBEDDING_0_53222147549100 after schema load (dimensions=1024, pages=1, fileId=40)
2026-01-23 21:39:18.659 SEVER [LSMVectorIndex] <ArcadeDB_0> Successfully loaded 21 vector locations for index CHUNK_EMBEDDING_0_53222147549100 (graph will be lazy-loaded on first search)
2026-01-23 21:39:18.659 SEVER [LSMVectorIndex] <ArcadeDB_0> loadVectorsAfterSchemaLoad called for index NER_EMBEDDING_0_53222156811000: dimensions=1024, mutablePages=1, hasGraphFile=true
2026-01-23 21:39:18.660 SEVER [LSMVectorIndex] <ArcadeDB_0> Loading vectors for index NER_EMBEDDING_0_53222156811000 after schema load (dimensions=1024, pages=1, fileId=45)
2026-01-23 21:39:18.660 SEVER [LSMVectorIndex] <ArcadeDB_0> Successfully loaded 54 vector locations for index NER_EMBEDDING_0_53222156811000 (graph will be lazy-loaded on first search)
2026-01-23 21:39:18.661 SEVER [LSMVectorIndex] <ArcadeDB_0> loadVectorsAfterSchemaLoad called for index IMAGE_EMBEDDING_0_53222165645100: dimensions=1024, mutablePages=0, hasGraphFile=true
2026-01-23 21:39:18.661 SEVER [LSMVectorIndex] <ArcadeDB_0> Skipping vector load for index IMAGE_EMBEDDING_0_53222165645100 (dimensions=1024, pages=0)
2026-01-23 21:39:18.661 SEVER [LSMVectorIndex] <ArcadeDB_0> loadVectorsAfterSchemaLoad called for index SUMMARY_EMBEDDING_0_53222174404500: dimensions=1024, mutablePages=1, hasGraphFile=true
2026-01-23 21:39:18.661 SEVER [LSMVectorIndex] <ArcadeDB_0> Loading vectors for index SUMMARY_EMBEDDING_0_53222174404500 after schema load (dimensions=1024, pages=1, fileId=55)
2026-01-23 21:39:18.662 SEVER [LSMVectorIndex] <ArcadeDB_0> Successfully loaded 1 vector locations for index SUMMARY_EMBEDDING_0_53222174404500 (graph will be lazy-loaded on first search)
2026-01-23 21:39:18.662 SEVER [LSMVectorIndex] <ArcadeDB_0> loadVectorsAfterSchemaLoad called for index DOCUMENT_EMBEDDING_0_53222183239200: dimensions=1024, mutablePages=1, hasGraphFile=true
2026-01-23 21:39:18.662 SEVER [LSMVectorIndex] <ArcadeDB_0> Loading vectors for index DOCUMENT_EMBEDDING_0_53222183239200 after schema load (dimensions=1024, pages=1, fileId=60)
2026-01-23 21:39:18.663 SEVER [LSMVectorIndex] <ArcadeDB_0> Successfully loaded 1 vector locations for index DOCUMENT_EMBEDDING_0_53222183239200 (graph will be lazy-loaded on first search)
2026-01-23 21:39:18.684 INFO  [HttpServer] <ArcadeDB_0> - Starting HTTP Server (host=0.0.0.0 port=[2480, 2489] httpsPort=[2490, 2499])...
2026-01-23 21:39:18.724 INFO  [undertow] starting server: Undertow - 2.3.22.Final
2026-01-23 21:39:18.728 INFO  [xnio] XNIO version 3.8.16.Final
2026-01-23 21:39:18.733 INFO  [nio] XNIO NIO Implementation Version 3.8.16.Final
2026-01-23 21:39:18.851 INFO  [HttpServer] <ArcadeDB_0> - HTTP Server started (host=0.0.0.0 port=2480 httpsPort=2490)
2026-01-23 21:39:18.852 INFO  [ArcadeDBServer] <ArcadeDB_0> Available query languages: [sqlscript, mongo, gremlin, java, cypher, js, graphql, sql, opencypher]
2026-01-23 21:39:18.853 INFO  [ArcadeDBServer] <ArcadeDB_0> ArcadeDB Server started in 'development' mode (CPUs=16 MAXRAM=7,98GB)
2026-01-23 21:39:18.854 INFO  [ArcadeDBServer] <ArcadeDB_0> Studio web tool available at http://192.168.0.36:2480
2026-01-23 21:41:03.024 INFO  [BackupDatabaseStatement] <ArcadeDB_0> Backing up database 'EHEHEH' to directory './backups'Executing full backup of database to '.\backups\EHEHEH\EHEHEH-backup-20260123-214103026.zip'...
Full backup completed in 0 seconds 5,38MB -> 238,69KB (95% compressed)

2026-01-23 21:41:18.957 INFO  [LSMTreeIndex] <ArcadeDB_0> Building index 'PIPELINE_CONFIG_0_53540693303900' on 1 properties...
2026-01-23 21:41:18.960 INFO  [LSMTreeIndex] <ArcadeDB_0> Completed building index 'PIPELINE_CONFIG_0_53540693303900': processed 0 records in 2ms
2026-01-23 21:41:19.004 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'EMBEDDING_0_53540740911000' with WAL disabled and transaction chunking...
2026-01-23 21:41:19.006 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'EMBEDDING_0_53540740911000' with 50MB chunk size (WAL disabled)...
2026-01-23 21:41:19.007 INFO  [LSMVectorIndex] <ArcadeDB_0> Completed loading vectors for index 'EMBEDDING_0_53540740911000': 0 records in 1ms (0 rec/sec)
2026-01-23 21:41:19.007 INFO  [LSMVectorIndex] <ArcadeDB_0> Vector index 'EMBEDDING_0_53540740911000' build complete: 0 records, state=READY
2026-01-23 21:41:19.019 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'CHUNK_EMBEDDING_0_53540754457600' with WAL disabled and transaction chunking...
2026-01-23 21:41:19.019 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'CHUNK_EMBEDDING_0_53540754457600' with 50MB chunk size (WAL disabled)...
2026-01-23 21:41:19.019 INFO  [LSMVectorIndex] <ArcadeDB_0> Completed loading vectors for index 'CHUNK_EMBEDDING_0_53540754457600': 0 records in 0ms (NaN rec/sec)
2026-01-23 21:41:19.019 INFO  [LSMVectorIndex] <ArcadeDB_0> Vector index 'CHUNK_EMBEDDING_0_53540754457600' build complete: 0 records, state=READY
2026-01-23 21:41:19.028 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'NER_EMBEDDING_0_53540764632800' with WAL disabled and transaction chunking...
2026-01-23 21:41:19.028 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'NER_EMBEDDING_0_53540764632800' with 50MB chunk size (WAL disabled)...
2026-01-23 21:41:19.029 INFO  [LSMVectorIndex] <ArcadeDB_0> Completed loading vectors for index 'NER_EMBEDDING_0_53540764632800': 0 records in 1ms (0 rec/sec)
2026-01-23 21:41:19.029 INFO  [LSMVectorIndex] <ArcadeDB_0> Vector index 'NER_EMBEDDING_0_53540764632800' build complete: 0 records, state=READY
2026-01-23 21:41:19.038 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'IMAGE_EMBEDDING_0_53540774495500' with WAL disabled and transaction chunking...
2026-01-23 21:41:19.039 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'IMAGE_EMBEDDING_0_53540774495500' with 50MB chunk size (WAL disabled)...
2026-01-23 21:41:19.039 INFO  [LSMVectorIndex] <ArcadeDB_0> Completed loading vectors for index 'IMAGE_EMBEDDING_0_53540774495500': 0 records in 0ms (NaN rec/sec)
2026-01-23 21:41:19.039 INFO  [LSMVectorIndex] <ArcadeDB_0> Vector index 'IMAGE_EMBEDDING_0_53540774495500' build complete: 0 records, state=READY
2026-01-23 21:41:19.047 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'SUMMARY_EMBEDDING_0_53540784065800' with WAL disabled and transaction chunking...
2026-01-23 21:41:19.049 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'SUMMARY_EMBEDDING_0_53540784065800' with 50MB chunk size (WAL disabled)...
2026-01-23 21:41:19.049 INFO  [LSMVectorIndex] <ArcadeDB_0> Completed loading vectors for index 'SUMMARY_EMBEDDING_0_53540784065800': 0 records in 0ms (NaN rec/sec)
2026-01-23 21:41:19.049 INFO  [LSMVectorIndex] <ArcadeDB_0> Vector index 'SUMMARY_EMBEDDING_0_53540784065800' build complete: 0 records, state=READY
2026-01-23 21:41:19.058 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'DOCUMENT_EMBEDDING_0_53540794301300' with WAL disabled and transaction chunking...
2026-01-23 21:41:19.059 INFO  [LSMVectorIndex] <ArcadeDB_0> Building vector index 'DOCUMENT_EMBEDDING_0_53540794301300' with 50MB chunk size (WAL disabled)...
2026-01-23 21:41:19.059 INFO  [LSMVectorIndex] <ArcadeDB_0> Completed loading vectors for index 'DOCUMENT_EMBEDDING_0_53540794301300': 0 records in 0ms (NaN rec/sec)
2026-01-23 21:41:19.059 INFO  [LSMVectorIndex] <ArcadeDB_0> Vector index 'DOCUMENT_EMBEDDING_0_53540794301300' build complete: 0 records, state=READY
2026-01-23 21:48:03.556 INFO  [BackupDatabaseStatement] <ArcadeDB_0> Backing up database 'ORANO' to directory './backups'Executing full backup of database to '.\backups\ORANO\ORANO-backup-20260123-214803557.zip'...
Full backup completed in 0 seconds 897,75KB -> 9,33KB (98% compressed)

[ExtReMLapin]

100% reproduction (note sure it's the right term) rate.

Restarted my app, error happens again, restarted my build of arcadedb (windows), happens again.

If REALLY needed, I can send the whole zipped idextend build (windows)

[ExtReMLapin]

Could be related to size ... or not ?

Doesn't make any sense

https://streamable.com/26vn2h

[lvca]

Checking...

[ExtReMLapin]

It seems to be size related, for example , as you can see in the video :

• Sub-batch 0-102 works
• Sub-batch 0-103 fails
  But
• Sub-batch 1-103 works
• Sub-batch 2-105 fails

[lvca]

We replaced undertow http server with a new release that could be the reason (security update).

[lvca]

@robfrank WDYT?

[ExtReMLapin]

We replaced undertow http server with a new release that could be the reason (security update).

Which commit ? So i can try to revert it on my end and try again, unless you already tested this

[lvca]

I just pushed a revert to go back to Undertow - 2.3.20.Final. @ExtReMLapin could you please pull + rebuild + retest it?

[ExtReMLapin]

Got it, testing