On Tue, Apr 19, 2005 at 05:39:42PM -0700, Dennis Sacks wrote: > > I am Seeing twelve of these messages every five to ten seconds in the > Postgresql serverlog when my java application is running: > > 2005-04-19 16:43:03 LOG: 00000: duration: 0.246 ms > LOCATION: exec_simple_query, postgres.c:960 > 2005-04-19 16:43:03 LOG: 00000: statement: rollback; begin; > LOCATION: pg_parse_query, postgres.c:464 Looks like the application is aborting its transaction (rollback) and starting a new one (begin). If you're not doing this explicitly then the API is probably doing it under the hood. If you're logging queries then you should be able to figure out where this is happening in the application. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
