Release Notes

Moved data connector setup from gadmin to GSQL. Streamlined the user experience for creating loading jobs for data stored in AWS, GCP, and Azure, directly integrating the data streaming connector with GSQL and reducing the steps needed to load data.

Added a new set of loading job token functions for string manipulation.

[3.9.2] Added configuration parameter KafkaConnect.AllowedTaskPerCPU to set a maximum number of concurrent connector tasks.

[3.9.2] The default mode for the Kafka Connector is EOF="true"

[3.9.3] Added -max_percent_error option to RUN LOADING JOB to automatically abort the job if the number of invalid data lines exceeds the given threshold.

Full support for multiple edges of the same type between vertices, to simplify application design for time series data and other complex large data sets.

[3.9.3] Integrates OpenCypher to speed up creating and migrating graph queries.

[3.9.3] Relaxed the rules for GSQL usernames.

[3.9.3] FUNCTION, ROW, POLICY added to reserved words list.

to_string() is now a built-in GSQL function, supporting all primitive and scalar accumulator data types. This means user-defined functions in Exprfunctions.hpp may no longer use the name to_string() (case-insensitive).

Added support for batch deletion of multiple edges between vertices, both with GSQL DELETE and as a REST endpoint.

Standardized SHOW PACKAGE for packaged queries to follow the same behavior as other SHOW catalog commands.

[3.9.2] outdegree vertex function vertex function can also be used with vertex input parameters in the query-body statements, not only with SELECT block vertex aliases.

[3.9.3] Added parameters for GPE query routing based on CPU usage

Fixed issue where an external Kafka loading records, 7 days or older, would fall short of the topic offset (TP-4604).

Fixed issue when a deleted vertex type would make policy_filter_index very large (GLE-6290).

Fixed issue where gsql --precompile encountered an Authentication failed error during an upgrade if the TigerGraph password was not the default (GLE-6371).

Fixed issue where GSQL APIs would encounter occasional slowness due to initSession in BaseInternalHandler not synchronizing (GLE-6347).

Fixed issue where after a gbar/gadmin restore the query would return an error response if GSE was not restarted (CORE-3148).

Fixed issue where deleted attribute would store the original value (CORE-3154).

Fixed issue where GSE may reuse segments in the cases where the GSE leader switches (CORE-3161).

Fixed crash when query thread would keep running after JobListener is shutdown (CORE-1730).

Fixed GPE crash when using INSERT with an UNKNOWN accumulator (GLE-5038).

Fixed crash when running interpret query with dynamic value (GLE-5600).

Fixed JSON Viewer crash on browser when displaying a large response (TOOLS-2283).

Fixed issue where DISTINCT for aggregation functions wasn’t working (GLE-5678).

Fixed issue of missing files in AdminPortal when downloading an output (TOOLS-2499).

Fixed issue primary id could not set a color config for a vertex (TOOLS-2478).

Fixed issue where administrator could not set a privilege to vertex primary_id in Role Management page of Admin Portal (TOOLS-2430).

Fixed issue where error messages of abort requests created large file sizes (CORE-2705).

Fixed issue where user could download query results from the label “View Table Result” without proper privilege (TOOLS-2404).

Fixed issue where multiple vertex types return when selecting one vertex type (GLE-5325).

Fixed issue of SHOW statement parser error for catalog object created using CREATE statement (GLE-5719).

Fixed support for outdegree() with a collection of edge types in INTERPRET mode (GLE-5476).

Fixed issue where delete or edit vertex attributes were incorrect in GraphStudio (TOOLS-2258).

Fixed issue in GraphStudio when "=” appeared as a missing parameter in an INTERPRET query (TOOLS-2298).

Fixed argument error when passing a negative float parameter in GSQL cli in a {key: value} format. (GLE-6004).

Fixed GSE crash when lease_expire_time_ms_ was not updating (CORE-2693).

Fixed issue where AWS credential user with access permission failed to create data_source to specified bucket (TP-4049).

Fixed issue where there was a failure to backup during upgrading from a free tier (TP-3922).

Fixed the case when the configured backup’s s3 service, such as ceph s3, only supported bucket path style (TP-3931).

Fixed issue to avoid cloning cluster again when restore had already succeeded (TP-3948).

Fixed TG container PostStart Handler script error handling problem (TP-3914).

Fixed restpp status refresh issue (CORE-1905).

Fixed GSQL jobs getting stuck when a related service is down (GLE-5365).

Fixed expansion getting stuck at importing to GSQL/GUI (TOOLS-2306).

Improved Restore when aborting all loading and the connect-offset will also clear (TP-3670).

Improved Kubernetes Operator by upgrading the Golang version to a higher to resolve previous version vulnerabilities (TP-3711).

Improved Insights table widget to be more consistent with GraphStudio (TOOLS-2375).

Improved insights search for two replicas when generating a pattern (TOOLS-2443).

Improved logs to show sso username and login related information (GLE-5970).

Improved error message details when during a failure to find a request record when deleting (CORE-2686).

Improved when a default user is deleted and the leader API would do a user check when permission is not needed (GLE-5678).

Added memory check in DistrbutedTopologyStore (CORE-2496).

LDAP now has more detailed error messages (GLE-5559).

Implemented a new connector fail status to show error messages in GSQL console (TP-3465).

Improved Insights tables by adding overflow (TOOLS-2312).

Updated aws-sdk-go version to fix CVE scan vulnerability (TP-2879).

Fixed GPE crash caused by aborted query still being used by running thread.

Fixed crash issue after RESTPP auth refresh.

Fixed GSE crash due to check failure when refreshing leader info after 60 minute timeout.

Fixed GPE crash and non-recovery due to Kafka and GPE offset when adjacent vertices were deleted.

Fixed data inconsistency when GSE consumed deletion requests from Kafka on update of committed_next_id_map

Fixed GRAPH scope command failure due to missing privilege check in v3.9.2.

Fixed failure to compile query when using edge variables in DML-sub delete statement.

Fixed subtypeid error message inconsistency.

Fixed /deleted_vertex_check false alert when GSE doesn’t have a segment.

Security: Updated JDK to 11.0.20 to address vulnerability scan issues.

Improved performance of GPE abort function.

Fixed a GPE crash caused by GetVertexTypeId failing to get the type from a vertex.

Fixed a RESTPP/WorkloadManager deadlock when multiple queries are waiting to execute.

Fixed a deadlock-like state when free disk space became very low during data loading.

Fixed a problem with GSQL not responding because no GSQL leader was elected.

Fixed importing pre-3.7 user-defined tuple (UDT) data which uses default-width INT or UINT fields. The import process will set pre-3.7 default-width fields to be 4 bytes. 3.7+ default-width fields are explicitly

Fixed GSQL not installing queries with certain collection accumulator expressions.

Restored the functionality of the --ssl option of the GSQL Client.

Fixed a situation that can result in different cluster nodes having differently compiled versions of the same query, resulting in an MD5 check error.

Fixed a situation where a request to install one query results in several other queries also being installed.

Removed an exclusive lock when Interpret Query is running, which had been preventing concurrent GSQL operations

Fixed a null pointer error when attempting to import into GraphStudio a Solution tarball of a tag-based graph.

Fixed a case where a schema change did not run because not all libudf.so files had been cleared out.

Fixed an internal classification error for FIXED_BINARY data, which caused a schema_check test failure.

Fixed a bug where if a loading job used TEMP_TABLE and VERTEX_MUST_EXIST, then the VERTEX_MUST_EXIST option would not be displayed (by LS or SHOW JOB), nor would it included in a database export.

Fixed a GSQL query bug where it did not handle string parameters properly if they contained “&”.

Fixed a bug when upgrading to 3.9 that caused the old installation’s default QueryUDF files to be copied and overwrite the new 3.9 default QueryUDF files, so that queries using UDFs could not be installed.

Fixed a GSQL log bug where the PermissionUtil.java function was logging a stale Command Type rather than the current Command Type.

Restored limited ability to run subqueries having a SET<VERTEX> parameter.

Modified the /deleted_vertex_check and /data_consistency_check endpoints to be global, not associated with any particular graph.

Fix a SET type attribute bug in which the set’s values were not being deduplicated.

Patched a user authorization issue that prevented a user registered on a primary cluster from running a query on the secondary cluster.

Provided a more comprehensive fix to a node sorting issue when upgrading a cluster with 10 or more nodes to v3.9.

Removed a restriction when load data into an edge defined for multiple FROM-TO vertex type pairs. The load statement no longer must have a USING clause.

Fixed a signed integer overflow error in loader status report messages, if more than 2^31 lines of data were loaded. set to 8 bytes.

Improved the display of FLOAT and DOUBLE numbers so they have the correct number of digits of precision (max. 7 or 16, respectively).

Fixed a GraphStudio bug in which a vertex attribute which had been deleted was still showing until the browserpage was refreshed.

When adding a UDF with PUT, check that the UDF is defined as an inline function, as required.

Security: Updated JDK to 11.9.18-10 to address some vulnerability scan issues.

Security: Updated JSON to 20230227 to address some vulnerability scan issues.

Improved system security by applying more restrictive file permissions to several files.

No longer include examples of the data being loading in the Kafka loader log file, for better data security.

Added lazy initialization of vertex data, for large graphs with more that 20K segments in the gstore.

Improved query installation memory usage and speed by optimizing gcc9 options.

Fixed a GraphStudio slowness issue when creating or editing vertices with hundreds of attributes.

Removed the 5-minute wait that the streaming loader used to decide if all the input data had been consumed.