559 questions
0
votes
1
answer
16
views
I need to create non nullable columns in a GridDB Cloud collection container
I´m trying to create a table (collection container) using GridDB Cloud, using a Python script, as shown in GridDB Developers Quick Start Guide, available here. The script runs fine, but with the ...
0
votes
0
answers
18
views
GridDB TQL Query Fails with "Syntax Error" on TimeSeries Container
I am working with GridDB and trying to run a TQL (TimeSeries Query Language) query on a TimeSeries container. However, I keep encountering a syntax error.
I have a TimeSeries container named ...
0
votes
0
answers
27
views
Write-ahead log corruption after high-frequency Inserts
data corruption issues after performing high-frequency write operations into GridDB. The write-ahead log (WAL) appears to be corrupted, and some of the recently inserted records are lost, or the data ...
1
vote
0
answers
35
views
Issue Connecting .NET Core with GridDB REST API
I am trying to connect my .NET Core service with GridDB using a REST API, but I am facing an issue while retrieving data.
Here's what I have done so far:
Set Up GridDB Server.
Installed and ...
1
vote
0
answers
16
views
How can I implement automatic data expiration in GridDB using the TTL feature with Java?
I am working with IoT data stored in GridDB where each record contains sensor readings. To manage storage efficiently, I want to automatically expire and delete outdated records after a certain period....
0
votes
0
answers
38
views
How can I implement an event-driven local cache synchronization for real-time sensor data in GridDB using Python?
I am working on a real-time IoT application where sensor readings (including a timestamp, sensor ID, and measurement value) are stored in GridDB. To reduce the query load and improve response times ...
0
votes
0
answers
19
views
Node synchronization having delays in GridDB
New data appears instantly when queried from primary nodes but takes a few minutes to show up on secondary nodes. Restarting a node forces synchronization, but that’s not practical in production. ...
0
votes
0
answers
73
views
SAP B1 Matrix fill with GridDB Data on Dispatcher
I am using SAP Business One Version 10.0 SDK to get/fill data to a Matrix from GriDDB v5.5.0.
I made the .ard package and installed on client which works as expected.
When i go to SAP Business One ...
0
votes
0
answers
25
views
Optimizing TQL Queries for High-Frequency Time-Series Data Ingestion in GridDB
I am developing a GridDB-based application that ingests large volumes of time-series data from IoT devices. My application uses TQL (GridDB Query Language) to query and aggregate this data in real-...
0
votes
0
answers
32
views
Bulk Data Import and Dynamic Schema Evolution with GridDB Python API
I am working on a GridDB-based application that requires bulk data import from CSV files using the Python API. Additionally, the schema of the incoming data can evolve over time, so I need a strategy ...
1
vote
0
answers
26
views
How to fix 305009 SQL_PROC_MULTIPLE_TUPLE error in GridDB when using scalar subqueries?
I'm working with GridDB and have encountered an error that I'm struggling to resolve. The error message is:
305009 SQL_PROC_MULTIPLE_TUPLE ERROR SQL execution failed. Data operation may be duplicated. ...
1
vote
0
answers
14
views
How to resolve 305010 SQL_PROC_UNSUPPORTED_TYPE_CONVERSION error in GridDB?
I'm currently working with GridDB and encountered an error that I can't seem to resolve. The error message is:
305010 SQL_PROC_UNSUPPORTED_TYPE_CONVERSION ERROR SQL execution failed. Argument of data ...
1
vote
0
answers
26
views
GridDB Cloud Replication Delays with Eventual Consistency - Inserts Lagging for Minutes
I'm running a 5-node GridDB Cloud cluster with eventual consistency enabled, which handles real-time data streaming from multiple sources. Writes occur on the primary nodes, while reads happen on ...
1
vote
0
answers
32
views
Indexing and Query Performance Degradation in GridDB Cloud with High Insert Load
Problem Statement:
I’m using GridDB Cloud to store time-series data from multiple IoT devices. The system ingests about 5,000 records per second while running frequent range queries on timestamps. ...
0
votes
0
answers
17
views
Issue Uploading CSV Data to GridDB Cloud – Data Not Ingesting Properly
I'm trying to upload stock market data from a CSV file into GridDB Cloud, but I'm encountering issues with the ingestion process. I followed the steps outlined in the GridDB Cloud Quick Start Guide ([...
0
votes
0
answers
23
views
What is the best practice for managing GridDB Cloud connections in a serverless environment like AWS Lambda?
I am developing an AWS Lambda function in Node.js to interface with GridDB Cloud. I implemented a connection reuse mechanism in my code to avoid establishing a new connection on each invocation, but I ...
1
vote
0
answers
13
views
Integrating GridDB Cloud WebAPI with Chart.js for Real-Time Data Visualization
I am developing a web-based dashboard to visualize IoT sensor data that I store in GridDB Cloud. I want to use the GridDB Cloud WebAPI to retrieve data and then render it with Chart.js. However, I am ...
0
votes
0
answers
15
views
How can I correctly upload binary image data to GridDB Cloud?
I am trying to upload image files to GridDB Cloud using the Python client, but I am encountering a type mismatch error. I set up my container schema like this:
import griddb_python as griddb
factory =...
0
votes
0
answers
23
views
How do I fix my transaction management code in GridDB Cloud (Java) for high-frequency IoT data ingestion?
I am developing an IoT application that ingests sensor data at a high frequency into GridDB Cloud using the Java client. I tried to implement transaction management, but my code seems to be causing ...
1
vote
0
answers
24
views
How to Reduce Write Latency in GridDB Cloud for High-Frequency Inserts?
I’m working on an IoT project that collects real-time sensor data from thousands of devices. Each device sends a new reading every second, and I need to insert this data into GridDB Cloud as ...
1
vote
0
answers
49
views
How to Connect to GridDB Cloud from a Remote Java Application?
I recently started exploring GridDB Cloud, and I want to connect to my instance from a Java application running on a different machine. I've followed the GridDB Cloud Quick Start Guide and performed ...
1
vote
0
answers
34
views
GridDB_Python - unable to get row count on griddb table
I'm trying to write and read large data on griddb using python, and I'll try it first for small data. But when I wanted to calculate the row count, I failed to get it, even though I had tried several ...
2
votes
0
answers
48
views
How can I implement user authentication in a GridDB application?
I am working on a GridDB-based application and need to implement user authentication to manage access to the database securely.
I am developing a GridDB-based application and aim to implement user ...
1
vote
0
answers
16
views
10090 TXN_OTHER_PRIVILEGE_EXISTS ERROR in GridDB – User/DB Administration Issue
I'm working with GridDB and attempting to create a new user and grant it privileges on a specific database. However, I keep encountering the following error:
10090 TXN_OTHER_PRIVILEGE_EXISTS ERROR ...
0
votes
0
answers
20
views
In version 5.7.0 of GridDB, GroupByRange fails to retrieve values as expected
When I use GroupByRange to perform window queries on time series data, the query executes successfully and returns the message: The query had been executed. However, when calling get to retrieve the ...
0
votes
0
answers
48
views
How to Use GridDB for Event-Based Triggering in Time-Series Data?
I am building an event-based monitoring system using GridDB. The goal is to trigger alerts when specific conditions are met in time-series data. For example:
If a value exceeds a threshold for more ...
1
vote
1
answer
27
views
I’m getting an ‘Unacceptable timestamp string specified’ error when inserting a row on a GridDB container
Question: I’m getting an ‘Unacceptable timestamp string specified’ error when inserting a row on a GridDB container
I’m running GridDB version 5.5.0-40191 CE on Windows 11 WSL, with Ubuntu installed. ...
1
vote
1
answer
14
views
Error D20332 while trying to insert BLOB data into a container using CLI on GridDB
I’m running GridDB version 5.5.0-40191 CE on Windows 11 WSL, with Ubuntu installed. I’m trying to insert lines in a table using CLI (gs_sh). The table layout is shown below:
CREATE TABLE DimEmployee (...
1
vote
1
answer
23
views
I'm getting error D20432 while inserting a new row in a GridDB container using CLI
I´m running GridDB on Windows WSL, with Ubuntu installed. Using the guidelines provided in this tutorial video from GridDB’s channel (https://www.youtube.com/watch?v=5bdc2UNLnj8), I created the ...
0
votes
0
answers
14
views
Why SQL_INVALID_AUTHORIZATION error in GridDB?
I am working with GridDB and trying to connect to a container using the following configuration:
Host: 192.168.0.1
Port: 10001
Username: Farwa_USR
Password: Allah_123@
Container: Farwa_container
I am ...
1
vote
0
answers
37
views
GridDB_Python - Group By query execution error
I am looking into griddb again for a project. Currently I want to do data aggregation, and for the syntax I refer to this guidance
I have tried several times, but I always get errors when performing ...
0
votes
0
answers
31
views
Why is GridDB returning inconsistent query results with large-scale parallel writes?
I’m using GridDB in a distributed environment to handle high-volume data writes and queries simultaneously. While testing the system under load, I encountered an issue where query results are ...
0
votes
0
answers
17
views
Why does the JDBC_ALREADY_CLOSED error occur in GridDB?
I am working on a Java application with GridDB and using JDBC to interact with the database. While running my application, I encountered the following error:
JDBC_ALREADY_CLOSED ERROR
Status check of ...
0
votes
0
answers
24
views
How to Integrate GridDB with Oracle APEX to Fetch and Display Data Dynamically?
I am working on an Oracle APEX application and want to integrate it with a GridDB database. My objective is to fetch data from GridDB and display it dynamically in an interactive report or classic ...
0
votes
0
answers
43
views
How can I store and query geospatial data in GridDB?
`I am working on a project that requires handling geospatial data, including coordinates (latitude and longitude) and performing spatial queries like proximity searches. I would like to store and ...
0
votes
1
answer
32
views
Why does GridDB's JDBC driver throw the JDBC_OPTIONAL_FEATURE_NOT_SUPPORTED error?
I am working on a Java application using GridDB as the database and the JDBC driver for GridDB. While executing an SQL query to retrieve the auto-generated keys, I encounter the following exception:
...
2
votes
0
answers
12
views
GridDB Compilation Fails Due to Missing NumPy Headers?
While trying to compile the GridDB Python client, I’m getting the following error:
fatal error C1083: Cannot open include file: 'numpy/arrayobject.h': No such file or directory
I’ve installed NumPy ...
4
votes
0
answers
38
views
ImportError: libgridstore.so.0 when importing GridDB in Python3.10
I'm trying to get GridDB working on my WSL/Ubuntu environment. I have followed https://pypi.org/project/griddb-python/ to install griddb and was successful but when trying to import the module I'm ...
1
vote
0
answers
20
views
GridDB Installation: Python Interpreter Architecture Mismatch with CMake?
I’m trying to install GridDB on my Windows system, but I’m encountering an architecture mismatch between the Python interpreter and the CMake configuration. The error message shows:
CMake Error at C:/...
2
votes
0
answers
56
views
How to Fill Missing Timestamps with Interpolated Values in GridDB Time-Series Queries?
I am working on a time-series data analysis project using GridDB. My dataset has irregular intervals, with missing timestamps in some cases. I need to fill these gaps with interpolated values during ...
2
votes
0
answers
24
views
How to setup griddb-python on JupyterLab
I'm trying to install griddb-python on my JupyterLab notebook and running into error. I'm trying to connect to my griddb running in Docker as part of WSL/Ubuntu.
%pip install griddb-python
Collecting ...
1
vote
1
answer
39
views
Installing Griddb Python client vs. 0.8.5 on Windows WSL
I’m running Windows Subsystem Linux (WSL) to run GridDB. I’m trying to install the Python client, version 0.8.5, available here, following the instructions from GridDB Docs, available here.
However, ...
1
vote
0
answers
23
views
How to fix this error "Incorrect data types or column count mismatch when inserting rows" in GridDB
Cause: Incorrect data types or column count mismatch when inserting rows.
Solution:
Verify that the row data matches the container schema.
For Blob type, ensure the binary data is passed as a ...
1
vote
0
answers
39
views
How to efficiently query large datasets in GridDB with filtering and pagination?
I'm working with GridDB for storing and querying large datasets, and I'm trying to implement an efficient way to filter and paginate the data. Specifically, I need to:
Filter records based on ...
2
votes
0
answers
25
views
How to improve GridDB Memory Usage for Long-Running Queries?
I am using GridDB CE to handle time-series data and run long-running analytical queries. During these queries, I observe significant memory usage spikes that degrade performance or lead to errors. ...
1
vote
0
answers
13
views
Handling Fix_List and Provider Mode with Connection Pooling and Failover
I am working on integrating a Java application with a GridDB server using the GridDB JDBC driver, and I want to optimize the configuration for Fix_List and Provider modes. While I understand the ...
1
vote
0
answers
57
views
How to efficiently query and aggregate time-series data in GridDB for a specific time window with a rolling sum?
I’m working with GridDB to store and query time-series data. The data represents sensor readings taken every minute and is stored in a container with the following structure:
CREATE TABLE ...
0
votes
0
answers
35
views
Grid DB Connection Issue using gss-client
I have installed the Grid DB server on my RHEL machine and further I am trying to connect to the GridDB server. From the online docs, I see that there are two different downloads - Server & ...
1
vote
0
answers
29
views
How can I handle transactions across multiple containers in GridDB?
I am working on a project using GridDB and need to manage transactions across multiple containers. Specifically, I want to ensure that if one operation fails, all changes in the transaction are rolled ...
1
vote
1
answer
42
views
How to optimize query performance in GridDB for large time-series datasets?
I’m working on a project that involves managing large time-series datasets in GridDB. Currently, I’m experiencing significant query latency issues as the dataset size grows. While GridDB performs well ...