You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "edinim (via GitHub)" <gi...@apache.org> on 2023/05/11 22:15:37 UTC

[GitHub] [age] edinim opened a new issue, #915: ag function does not exist - agtype_volatile_wrapper

edinim opened a new issue, #915:
URL: https://github.com/apache/age/issues/915

   **Describe the bug**
   CREATE and MERGE functions are throwing exceptions.
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   - DBeaver
   
   **What is the command that caused the error?**
   ```pgsql
   SELECT * 
   FROM cypher('graph_name', $$
       CREATE (n)
   $$) as (v agtype);
   ```
   ```
   SQL Error [XX000]: ERROR: ag function does not exist
     Detail: agtype_volatile_wrapper(1)
     Position: 39
   
   
   Error position: line: 2 pos: 38
   ```
   
   **Expected behavior**
   A single vertex should be created
   
   **Environment (please complete the following information):**
   - Age Version: 1.2.0
   - PostgreSQL 11.13 (Debian 11.13-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
   
   **Additional context**
   It was working fine, but after the Kubernetes db pod got restarted, these commands started throwing the exception.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] humzakt commented on issue #915: ag function does not exist - agtype_volatile_wrapper

Posted by "humzakt (via GitHub)" <gi...@apache.org>.
humzakt commented on issue #915:
URL: https://github.com/apache/age/issues/915#issuecomment-1574769734

   I believe you are not editing and loading the code correctly. Have a look at this article for detailed guidance [Guide to Modifying the Apache Age Source code](https://dev.to/humzakt/getting-started-with-age-and-postgresql-setting-up-and-modifying-the-source-code-49n3)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] moiz697 commented on issue #915: ag function does not exist - agtype_volatile_wrapper

Posted by "moiz697 (via GitHub)" <gi...@apache.org>.
moiz697 commented on issue #915:
URL: https://github.com/apache/age/issues/915#issuecomment-1551778371

   Sudo make PG_CONFIG=path/to/postgre/bin/pg_config install
   
   after this run postgres 
   run this CREATE EXTENSION age;
   LOAD 'age';
   SET search_path = ag_catalog, "$user", public;  


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] safi50 commented on issue #915: ag function does not exist - agtype_volatile_wrapper

Posted by "safi50 (via GitHub)" <gi...@apache.org>.
safi50 commented on issue #915:
URL: https://github.com/apache/age/issues/915#issuecomment-1546079088

   Did you check if your **AGE** extension was properly initialized after Kubernetes db pod restarted ? 
   Enter the following in your psql cli to get list of postgres extensions:
   ```
   SELECT * FROM pg_extension
   ```
   If age is enabled, you'll see it in the list of estensions, if not, run: 
   ```
   CREATE EXTENSION age;
   LOAD 'age';
   SET search_path = ag_catalog, "$user", public;
   ```
   Try running your query again after running above.  Also confirm that `DBeaver` is correctly connected to your PostgreSQL database and the AGE extension is available in the connected database.  Try restarting  Dbeaver and refreshing the PostgreSQL server. 
   
    


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] jrgemignani closed issue #915: ag function does not exist - agtype_volatile_wrapper

Posted by "jrgemignani (via GitHub)" <gi...@apache.org>.
jrgemignani closed issue #915: ag function does not exist - agtype_volatile_wrapper
URL: https://github.com/apache/age/issues/915


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] edinim commented on issue #915: ag function does not exist - agtype_volatile_wrapper

Posted by "edinim (via GitHub)" <gi...@apache.org>.
edinim commented on issue #915:
URL: https://github.com/apache/age/issues/915#issuecomment-1546116719

   An update:
   I dropped the age extension and the graphs dropped automatically too, created the extension again and now it working again as before.
   
   Leaving the issue open if anyone has an answer about what may have happened. 
   
   @safi50 Thank you for your reply, and yes the extension was enabled and I restarted the db multiple times. Looks like the extension itself crashed.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org