Re: [JDBC] [BUGS] Incorrect response code after XA recovery

2013-07-31 Thread Jeremy Whiting
Hi Tom, The driver currently doesn't report back to the calling client (tm) XAException.XAER_NOTA code as Ondrej and Tom Jenkinson have identified. Instead it returns XAException.XAER_RMERR. See line 416 https://github.com/pgjdbc/pgjdbc/blob/master/org/postgresql/xa/PGXAConnection.java#416 whic

Re: [BUGS] BUG #8318: memory leak during CREATE TEMPORARY TABLE

2013-07-31 Thread Kevin Grittner
"g.bakalar...@icm.edu.pl" wrote: > Kevin Grittner wrote: >> "g.bakalar...@icm.edu.pl" wrote: >> >>> When doing these kind of statements >> >>> execute : CREATE TEMPORARY TABLE [...] >> >>> After few days [...] my huge server (192GB of RAM), gets stucked >>> due to no memory available (usually %c

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-07-31 Thread Bruce Momjian
On Tue, Jul 30, 2013 at 10:17:52AM -0400, Jesse Denardo wrote: > Name: Jesse Denardo > Release: 9.2.2 -> 9.3beta2 > Test Type: Install/Upgrade Test > Test Detail: pg_upgrade in a fresh install of 9.3beta2 > Platform: Debian Linux 6.0.5 > Installation Method: From source > Platform Detail: Debian Li

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-07-31 Thread Alvaro Herrera
Bruce Momjian escribió: > On Tue, Jul 30, 2013 at 10:17:52AM -0400, Jesse Denardo wrote: > So, first, this is new in 9.3, and second, it seems the comment "we need > to reset pg_control so that the new server doesn't attempt to read > multis older than the cutoff value" is not working. Alvaro, ca

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-07-31 Thread Bruce Momjian
On Wed, Jul 31, 2013 at 12:56:33PM -0400, Alvaro Herrera wrote: > Bruce Momjian escribió: > > On Tue, Jul 30, 2013 at 10:17:52AM -0400, Jesse Denardo wrote: > > > So, first, this is new in 9.3, and second, it seems the comment "we need > > to reset pg_control so that the new server doesn't attempt

Re: [BUGS] BUG #8318: memory leak during CREATE TEMPORARY TABLE

2013-07-31 Thread G . Bakalarski
> "g.bakalar...@icm.edu.pl" wrote: > >> When doing these kind of statements > >> execute : CREATE TEMPORARY TABLE [...] > >> After few days [...] my huge server (192GB of RAM), gets stucked >> due to no memory available (usually %commit is around 103-105%), >> linux OOM killer goes into action - i

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-07-31 Thread Jesse Denardo
$ 9.2_dev/bin/pg_controldata data pg_control version number:922 Catalog version number: 201204301 Database system identifier: 5789770930315980286 Database cluster state: shut down pg_control last modified: Tue 30 Jul 2013 09:57:54 AM EDT

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-07-31 Thread Alvaro Herrera
Jesse Denardo escribió: > $ 9.2_dev/bin/pg_controldata data > Latest checkpoint's NextMultiXactId: 2982 > Latest checkpoint's NextMultiOffset: 6479 So what's happening here is that the MultiXact 2982 lives in a SLRU page that doesn't exist. pg_upgrade didn't copy the pg_multixact files from t

[BUGS] postgresql 8.4 on android table with debian installed (Debian Kit APK)

2013-07-31 Thread f...@libero.it
problem: I have build from source posgresql (8.4) on a android table whith a minimal linux debian installed."configure" process and "make" (compiling source) and "make install": all are OK!! Also initdb works fine (/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data). but postgresql (launched wi

Re: [BUGS] postgresql 8.4 on android table with debian installed (Debian Kit APK)

2013-07-31 Thread Alvaro Herrera
f...@libero.it wrote: > problem: > I have build from source posgresql (8.4) on a android table whith a minimal > linux debian installed."configure" process and "make" (compiling source) and > "make install": all are OK!! > Also initdb works fine (/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/da

Re: [BUGS] postgresql 8.4 on android table with debian installed (Debian Kit APK)

2013-07-31 Thread Mark Kirkwood
On 01/08/13 09:13, f...@libero.it wrote: problem: LOG: could not create IPv6 socket: Permission denied LOG: could not create IPv4 socket: Permission denied WARNING: could not create listen socket for "localhost" FATAL: could not create any TCP/IP sockets See http://android-dls.com/

[BUGS] pgBench cannot use prepared statements and reconnections

2013-07-31 Thread Josh Berkus
To wit: [jberkus@pgx-test prepare]$ pgbench -c 4 -C -T 180 -l -r -M prepared bench starting vacuum...end. Client 1 aborted in state 7: ERROR: prepared statement "P0_7" does not exist Client 0 aborted in state 7: ERROR: prepared statement "P0_7" does not exist Client 3 aborted in state 7: ERROR:

Re: [BUGS] pgBench cannot use prepared statements and reconnections

2013-07-31 Thread Mark Kirkwood
On 01/08/13 10:08, Josh Berkus wrote: To wit: [jberkus@pgx-test prepare]$ pgbench -c 4 -C -T 180 -l -r -M prepared bench starting vacuum...end. Client 1 aborted in state 7: ERROR: prepared statement "P0_7" does not exist Client 0 aborted in state 7: ERROR: prepared statement "P0_7" does not e

Re: [BUGS] pgBench cannot use prepared statements and reconnections

2013-07-31 Thread Mark Kirkwood
On 01/08/13 11:08, Mark Kirkwood wrote: On 01/08/13 10:08, Josh Berkus wrote: To wit: [jberkus@pgx-test prepare]$ pgbench -c 4 -C -T 180 -l -r -M prepared bench starting vacuum...end. Client 1 aborted in state 7: ERROR: prepared statement "P0_7" does not exist Client 0 aborted in state 7: ERR