New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
SQL Error [22023]: ERROR: label_id must be 1 .. 65535 #1837
Comments
Roughly, how many distinct labels? Edit: Additionally, how are you inserting all of these nodes |
SELECT count(id) FROM ag_catalog.ag_label al; --26
SELECT max(id) FROM ag_catalog.ag_label al ; --26 There is roughly 26 distinct labels.(The size of data set is very small).
SELECT * FROM cypher('SchemaGraph', $$
CREATE (:Category {name: 'CategoryTest1'})
$$) AS (n agtype); The issue is very specific to Nodes whose Labels are already existing, If I try to create Nodes with new Labels, no issues. |
@devcode100 This is happening when using the command line in PostgreSQL? Or through a driver? |
@jrgemignani , Both through psql cli and DBearver(SQL GUI Client), getting the issue. |
@devcode100 I have not been able to reproduce this and I created 120,000 nodes as shown below, in both the latest and PG16 release 1.5.0. It could be that your install got messed up?
|
@devcode100 I should note that, for each of my tests, I used fresh installs of PostgreSQL version 16.1 and Apache AGE master and release 1.5.0. I'm not sure what specific version of 16 you are using, though. Here I have created over 13M nodes without issue -
I think your install might be bad.
|
@jrgemignani , appreciate your effort to replicate.
The current postgres server setup have is a single node one and I haven't encountered any issues with DB so far. |
@devcode100 I have tried this against PostgreSQL version 16.2 and the master branch, without issue -
|
@devcode100 I have tried this against PostgreSQL version 16.2 and release 1.5.0, without issue -
|
@jrgemignani - I have dropped the Graph where I got the issue and working on new Graph schema now. I have not encountered the issue so far. |
Describe the bug
Upon trying to create new Nodes, getting the below error:
SQL Error [22023]: ERROR: label_id must be 1 .. 65535
The issue is very specific to Nodes whose Labels are already existing, If I try to create Nodes with new Labels, no issues.
The volume of data is <100 (total number of Nodes across various Labels).
There is no steps I could think of to replicate this issue, it came randomly and exists.
How are you accessing AGE (Command line, driver, etc.)?
What is the necessary configuration info needed?
What is the command that caused the error?
Expected behavior
The Nodes should have been created.
Environment (please complete the following information):
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: