Release notes

The field name _id is now reserved for the primary key column. Attempting to include it in the data will cause an error.

Raijin now automatically sets sane values for memory settings based on the following limits, in order of precedence: CGroups v2 memory limits, NOMAD_MEMORY_LIMIT environment variable, or available physical memory.

Following the fix of column statistics in affected databases must be rebuilt using JSON export and import

This version introduces new multidimensional table partitioning

Updated OpenAPI spec with latest Query and Ingestion endpoints

Raijin 2.0 falls back to standard sorting if optimized hits memory limit

Fixed issue with missing heap files after flush during recovery

Due to partitioning changes, existing databases must be manually exported, recreated, and imported into the new storage layout when upgrading from v1.5 or older to Raijin v2.0

Due to directory structure changes in Raijin v1.5, migration from v1.4 or older requires backing up the old data, upgrading Raijin, copying the database folders from /opt/raijin/data to the new /opt/raijin/data/db/ location, starting Raijin v2.0, and verifying database accessibility

Table and view renaming doesn’t work appropriately when destination database is different from source one

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin

This version introduces the use of the data directory as the base that contains all the stateful files

Metrics endpoint does not require authentication anymore

Introduced support of Authorization header in API

LIKE/ILIKE now use substring search instead of regex

Fixed issue with target list in certain subselect cases

Added missing /authentications/current endpoint to Swagger docs

Due to directory structure changes in Raijin v1.5, migration from v1.4 or older requires backing up the old data, upgrading Raijin, copying the database folders from /opt/raijin/data to the new /opt/raijin/data/db/ location, starting Raijin v1.5, and verifying database accessibility

Table and view renaming doesn’t work appropriately when destination database is different from source one

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin

This version introduces SHOW USERS, SHOW VERSION and SHOW VIEWS commands

Increased column name length limit

Extended partition management endpoints to target partitions by directory name

Introduced UNSIGNED data type syntax

Fixed issue where swagger ignores https

MATCH predicate now throws error on non-string columns

Added support for unordered selects

Fixed error when stopping/restarting Raijin with locked tables

Table and view renaming doesn’t work appropriately when destination database is different from source one.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

This version introduces username/password authentication.

Implemented protected SQL statements execution, granular user authorization via SQL GRANT command and user management capabilities like CREATE/DROP USER.

Raijin can now detect and respect CGroups memory limits.

This version introduces optimization to avoid unnecessary data merging during aggregation and sorting.

Fixed memory leaks and reduced memory usage during queries.

Table and view renaming doesn’t work appropriately when destination database is different from source one.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

Ingestion API response now contains details about ingestion errors.

SQL views were added to Raijin for easier analytics over raw data.

This version introduces the ability to update the partitioning expression.

Table and view renaming doesn’t work appropriately when destination database is different from source one.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

The current release contains changes that break compatibility with earlier versions. It is necessary to export your data, recreate databases and tables, then import the data after the new install.

The FLUSH TABLES WITH READ LOCK and UNLOCK TABLES SQL commands have been implemented to make backups easier.

Audit logging has been added to Raijin. Currently it logs SELECT and INSERT statements as well. The next version will have configuration to control what is audited.

Partition management has been updated to support a full archival life-cycle.

If Raijin is started with a command line switch missing an expected parameter, it will exit with a segmentation fault.

FIXED: If the database runs out of disk space and is restarted, the database will be irrecoverably damaged. Disk space monitoring can help avoid this issue.
Using EnableWal=false in raijin.conf disables Write Ahead Logging and prevents this error.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

Please take a time to backup your important data before updating Raijin!

Raijin now supports HTTPS-connection and uses SSL-authentication. Default server certificates are available on install. Use SSL settings paragraph in raijin.conf to enable it.

If the database runs out of disk space and is restarted, the database will be irrecoverably damaged. Disk space monitoring can help avoid this issue.
Using EnableWal=false in raijin.conf disables Write Ahead Logging and prevents this error.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

We added beta-version of JSON file upload through the UI. We recommend to use COPY function for ingesting big portions of data rather than UI functionality though.

Log handling and rotation have been slightly changed. See Logging settings paragraph in raijin.conf for details.

If the database runs out of disk space and is restarted, the database will be irrecoverably damaged. Disk space monitoring can help avoid this issue.
Using EnableWal=false in raijin.conf disables Write Ahead Logging and prevents this error.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

If the database runs out of disk space and is restarted, the database will be irrecoverably damaged. Disk space monitoring can help avoid this issue.
Using EnableWal=false in raijin.conf disables Write Ahead Logging and prevents this error.

If the timezone or timezone definitions are changed while Raijin is running it will keep using the timezone it cached on start. To enforce the new timezone setting, please restart Raijin.

This hotfix release corrects a bug causing incompatibility with nginx reverse proxies.

If the database runs out of disk space and is restarted, the database will be irrecoverably damaged. Disk space monitoring can help avoid this issue.
Using EnableWal=false in raijin.conf disables Write Ahead Logging and prevents this error.

When running in a container please make sure time zone is set to TZ=Etc/UTC. There is currently a crash present in the logic determining the time zone when it is not set. This issue is scheduled to be corrected in the next release.

The Raijin plugin for Grafana sets the visible fields based on the first record. Make sure you formulate your query so that the first record has all the fields you require in your visualization. This issue is scheduled to be corrected in the next release.

If the database runs out of disk space and is restarted, the database will be irrecoverably damaged. Disk space monitoring can help avoid this issue.
Using EnableWal=false in raijin.conf disables Write Ahead Logging and prevents this error.

When running in a container please make sure time zone is set to TZ=Etc/UTC. There is currently a crash present in the logic determining the time zone when it is not set. This issue is scheduled to be corrected in the next release.

The Raijin plugin for Grafana sets the visible fields based on the first record. Make sure you formulate your query so that the first record has all the fields you require in your visualization. This issue is scheduled to be corrected in the next release.

If the database runs out of disk space and is restarted, the database will be irrecoverably damaged. Disk space monitoring can help avoid this issue.
Using EnableWal=false in raijin.conf disables Write Ahead Logging and prevents this error.

Autodetecting JSON datetime values is currently broken. The issue can be avoided by setting up a minimal table schema specifying the column type as DATETIME.