Hi, I am not sure if sending this to the right place. I did try to get the answer from pgpool mailing list but no luck . Would appreciate if someone can help here.
We are receving the following error in the postgres database logs: 2009-03-19 02:14:20 PDT [2547]: [79-1] LOG: duration: 0.039 ms statement: RESET ALL 2009-03-19 02:14:20 PDT [2547]: [80-1] LOG: duration: 0.027 ms statement: SET SESSION AUTHORIZATION DEFAULT 2009-03-19 02:14:20 PDT [2547]: [81-1] ERROR: prepared statement "S_1" does not exist 2009-03-19 02:14:20 PDT [2547]: [82-1] STATEMENT: DEALLOCATE "S_1" 2009-03-19 02:14:20 PDT [2547]: [83-1] ERROR: prepared statement "S_4" does not exist 2009-03-19 02:14:20 PDT [2547]: [84-1] STATEMENT: DEALLOCATE "S_4" We receive this errors when we start connecting the java application thorugh pgpool. What causes this problem and how can it be avoided? Postgres version: 8.3.3 pgpool II: 2.0.1 Thanks & Regards, Nimesh.