Horton

Re: [GENERAL] pg_upgrade problem

hubert depesz lubaczewski <depesz@depesz.com>

View thread
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-09-06T11:13:58Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. ltree support for multibyte encodings. Patch was made by

Hi,

Worked a bit to get the ltree problem down to smallest possible, repeatable, situation.

Initial setup:

1. PostgreSQL 8.3.11, configured with:
    ./configure                        \
        --prefix=/opt/pgsql-8.3.11-int \
        --disable-rpath                \
        --without-perl                 \
        --without-python               \
        --without-tcl                  \
        --without-openssl              \
        --without-pam                  \
        --without-krb5                 \
        --without-gssapi               \
        --enable-nls                   \
        --enable-integer-datetimes     \
        --enable-thread-safety         \
        --with-libxml                  \
        --with-libxslt                 \
        --without-ldap
Built and installed with contrib modules.

2. PostgreSQL 9.0.5 (pre), from git checkout, head of 9.0 branch. Configured with:
    ./configure \
            --prefix=/opt/pgsql-9.0.5a-int \
            --enable-debug \
            --enable-cassert \
            --disable-rpath \
            --without-perl \
            --without-python \
            --without-tcl \
            --without-openssl \
            --without-pam \
            --without-krb5 \
            --without-gssapi \
            --enable-nls \
            --enable-integer-datetimes \
            --enable-thread-safety \
            --with-libxml \
            --with-libxslt \
            --without-ldap

Now with these two in place, I can make the test:

=$ mkdir /var/tmp/test
=$ cd /var/tmp/test/
=$ export LD_LIBRARY_PATH=/opt/pgsql-8.3.11-int/lib/
=$ export PATH="/opt/pgsql-8.3.11-int/bin:$PATH"
=$ mkdir data-8.3
=$ initdb -D data-8.3
=$ pg_ctl -D data-8.3 -l logfile-8.3 start
=$ psql -d postgres -f /opt/pgsql-8.3.11-int/share/contrib/ltree.sql
=$ psql -d postgres -c "create table z (x ltree)"
=$ psql -d postgres -c "insert into z (x) values ('a.b')"
=$ pg_ctl -D data-8.3/ stop
=$ export LD_LIBRARY_PATH=/opt/pgsql-9.0.5a-int/lib/:/opt/pgsql-8.3.11-int/lib/
=$ export PATH=/opt/pgsql-9.0.5a-int/bin/:/opt/pgsql-8.3.11-int/bin/:~/bin:/usr/local/bin:/usr/bin:/bin
=$ mkdir data-9.0
=$ initdb -D data-9.0/
=$ perl -pi -e 's/#port = 5432/port=7654/' data-9.0/postgresql.conf
=$ pg_upgrade -v -b /opt/pgsql-8.3.11-int/bin/ -B /opt/pgsql-9.0.5a-int/bin/ -d $( pwd )/data-8.3/ -D $( pwd )/data-9.0 -k -l pg_upgrade.log -p 5432 -P 7654
=$ pg_ctl -D data-9.0 -l logfile-9.0 start
=$ psql -p 7654 -d postgres -c "select * from z"
WARNING:  detected write past chunk end in ExecutorState 0xc500a0
WARNING:  problem in alloc set ExecutorState: req size > alloc size for chunk 0xc500d8 in block 0xc4dfd0
WARNING:  problem in alloc set ExecutorState: bad single-chunk 0xc500d8 in block 0xc4dfd0
WARNING:  problem in alloc set ExecutorState: bogus aset link in block 0xc4dfd0, chunk 0xc500d8
WARNING:  problem in alloc set ExecutorState: found inconsistent memory block 0xc4dfd0
connection to server was lost

Hope it helps.

Best regards,

depesz