Postgres Pro
Downloads
Home   >   mailing lists

ERROR: permission denied to finish prepared transaction - Mailing list pgsql-general

From David Kerr
Subject ERROR: permission denied to finish prepared transaction
Date
Msg-id 20100216205728.GA42266@mr-paradox.net
Whole thread Raw
Responses Re: ERROR: permission denied to finish prepared transaction
List pgsql-general
Tree view 
I'm seeing a bunch of these error messages:
Feb 16 12:04:51 QA-HC01-DB01 postgres-hc01[26420]: [2-1] user=xy,db=x,pid=26420 ERROR:  permission denied to finish
preparedtransaction 
Feb 16 12:04:51 QA-HC01-DB01 postgres-hc01[26420]: [2-2] user=xy,db=x,pid=26420 HINT:  Must be superuser or the user
thatprepared the 
transaction.
Feb 16 12:04:51 QA-HC01-DB01 postgres-hc01[26420]: [2-3] user=xy,db=x,pid=26420 STATEMENT:  ROLLBACK PREPARED
Feb 16 12:04:51 QA-HC01-DB01 postgres-hc01[26420]: [2-4]

'1197822575_uwQAAAAAAABHVE1JRAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==_AQAAAAAAAABHVE1JRAAAAAAAAA
Feb 16 12:04:51 QA-HC01-DB01 postgres-hc01[26420]: [2-5]
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=='


As far as I can tell, that means that user xy is trying to rollback a prepared TX that it didn't create.
is that the only reason this error would show up?

I'm asking becase, as far as I can tell, xy is the only user on the box that would be doing prepared tx's

this is 8.3

Thanks

Dave

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion
Next
From: Richard Huxton
Date:
Subject: Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion