Troubleshooting
Common issues and solutions when working with ageSchemaClient.
Connection Issues
Apache AGE Extension Not Found
Problem: Error message about AGE extension not being available.
Solution:
- Ensure Apache AGE is installed
- Create the extension:
CREATE EXTENSION IF NOT EXISTS age;
- Load the extension:
LOAD 'age';
Connection Refused
Problem: Cannot connect to PostgreSQL database.
Solution:
- Verify PostgreSQL is running
- Check host, port, and credentials
- Ensure database exists
- Check firewall settings
Query Issues
Parameter Handling
Problem: Dynamic parameters not working in Cypher queries.
Solution: Use the parameter management system:
query
.match('(p:Person)')
.where('p.name = $name')
.setParam('name', 'Alice')
Performance Issues
Problem: Slow query execution.
Solutions:
- Create appropriate indexes
- Use LIMIT clauses
- Optimize query patterns
- Use batch operations for large datasets
Schema Validation
Validation Errors
Problem: Schema validation failures.
Solution:
- Check data types match schema
- Verify required fields are present
- Validate property constraints