Hi all,
I have a web application with a bunch of unit tests which involve accessing a PostgreSQL database. My schema contains composite types and stored procedures.
When running the tests, I'm getting a "com.impossibl.postgres.jdbc.PGSQLSimpleException: cache lookup failed for type 64790" when trying to call a stored procedure whose parameter is an array of a composite type (e.g. "create function foo(param comp_type[]")
The funny thing is, when I run the specific test in isolation the problem disappears.
Note that the tests are grouped into fixtures and each fixture resets the database when run (it drops all tables, types, and functions then recreates them) and they are run serially (so it's not a parallel execution problem). Also, each test is run inside a transaction that's set to rollback after the test is finished in order to reduce the amount database resets.
I'm having problems understanding what's causing the problem but i suspect that the rapid database resets paired with transaction use (abuse?) are the ones causing it. I've tried delays but those don't fix the problems.