Skip to content
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

cache lookup failed for type 0 after upgrading ag from 2.12 to 2.13.1 #643

Open
ns-berumalu opened this issue Jan 3, 2024 · 5 comments
Open

Comments

@ns-berumalu
Copy link

After upgrading ag from 2.12 to 2.13.1 we are seeing cache lookup failed for type 0 errors. Please suggest on this.

postgres=# merge (p:account {'ResInternalID':'xxxx'}) on create set p+={'listed':'false'} merge (r:user {'ResInternalID':'xxxx'}) set r={'listed':'false'} merge (p)-[e:owns {'type':'User'}]->(r);
ERROR: cache lookup failed for type 0

@ns-berumalu
Copy link
Author

HI @emotionbug , could you please check on this

@emotionbug
Copy link
Contributor

@ns-berumalu
I don't work for Bitnine anymore. :(..
AgensGraph too.

@ns-berumalu
Copy link
Author

ns-berumalu commented Jan 3, 2024

@emotionbug , Please suggest to whome should i contact on this

@ns-berumalu
Copy link
Author

Hi @yjy44 , could you please prioritise this

@samoscyberallenh
Copy link

Did you happen to do an pg_dump and import into the new database? I'm asking because, if so, we had a similar issue that we fixed by running these commands (replace "mygraph" with the name of your graph):

ALTER TABLE mygraph.ag_vertex
   ALTER COLUMN properties SET NOT NULL,
   ALTER COLUMN properties SET default json_build_object();

ALTER TABLE mygraph.ag_edge
   ALTER COLUMN id SET NOT NULL,
   ALTER COLUMN start SET NOT NULL,
   ALTER COLUMN "end" SET not NULL,
   ALTER COLUMN properties SET NOT NULL,
   ALTER COLUMN properties SET DEFAULT json_build_object();

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants