[server] prevent returning closed cursor to the database pool
In since c8c6ad8 init_repository use repo.internal_cnx() instead of
repo.system_source.get_connection() so it use the pool and we should not close
cursors from the pool before returning it back. Otherwise we may have
"connection already closed" error.
This bug only trigger when connection-pool-size = 1. Since we are moving to use
a dynamic pooler we need to get this fixed.
This does not occur with sqlite since the connection wrapper instantiate new
cursor everytime, but this occur with other databases.
#!/bin/sh
set -e
set -x
if [ -z "$AUTOPKGTEST_TMP" ]; then
echo "Not running as part as autopkgtest" >&2
exit 250
fi
# Switch to unprivileged user if needed
if [ "$(id -u)" = 0 ]; then
apt-get install -q -y sudo
echo 'Defaults !fqdn' > /etc/sudoers.d/fqdn
echo 'nobody ALL=(ALL) NOPASSWD: ALL' > /etc/sudoers.d/nobody
chown nobody:nogroup "$AUTOPKGTEST_TMP"
exec su nobody -s /bin/sh -c "$0"
fi
cd "$AUTOPKGTEST_TMP"
# Create a cube
PACKAGE="cubicweb-mytest"
cubicweb-ctl newcube -s 'Just a test cube' ${PACKAGE#cubicweb-}
cd "$PACKAGE"
UPSTREAM_VERSION=$(python3 setup.py --version)
DEBIAN_VERSION=$(dpkg-parsechangelog -S Version)
# Create source tarball
python3 setup.py sdist
mv "dist/${PACKAGE}-${UPSTREAM_VERSION}.tar.gz" "../${PACKAGE}_${UPSTREAM_VERSION}.orig.tar.gz"
# Install build-dependencies
mk-build-deps --install --root-cmd sudo --remove \
--tool 'apt-get -o Debug::pkgProblemResolver=yes --no-install-recommends --quiet --assume-yes'
# Build!
dpkg-buildpackage
# Output .buildinfo for posterity
cat ../*.buildinfo
# Output package content, again for posterity
debc
# Install the package
sudo debi --with-depends
lintian -i ../*.dsc ../*.changes
# Test if Python module is usable
python3 -c 'import cubicweb_mytest; print(dir(cubicweb_mytest))'
# Run autopkgtest (uh… inception, anyone?)
sudo autopkgtest ../*.changes -- null