09.03.0100 cursor failures on various architectures

From: Christoph Berg <christoph(dot)berg(at)credativ(dot)de>
To: PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Cc: psqlodbc(at)packages(dot)debian(dot)org
Subject: 09.03.0100 cursor failures on various architectures
Date: 2014-02-12 10:45:24
Message-ID: 20140212104524.GA4409@msgid.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I've uploaded 09.03.0100 to Debian, but the build daemons for various
architectures are reporting regression test failures for the "cursors"
test, e.g. on mipsel:

/usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --psqldir='/usr/lib/postgresql/9.3/bin' --launcher=./launcher --dbname=contrib_regression sampletables connect stmthandles select commands multistmt getresult prepare params notice arraybinding insertreturning dataatexecution boolsaschar cvtnulldate alter quotes cursors positioned-update catalogfunctions
(using postmaster on localhost, port 5432)
============== dropping database "contrib_regression" ==============
HINWEIS: Datenbank „contrib_regression“ existiert nicht, wird übersprungen
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
[...]
test cursors ... FAILED
[...]

=======================
1 of 20 tests failed.
=======================

regression.diffs:
*** /home/myon/psqlodbc-09.03.0100/test/expected/cursors.out 2013-12-17 15:16:00.000000000 +0100
--- /home/myon/psqlodbc-09.03.0100/test/results/cursors.out 2014-02-12 11:33:34.787112560 +0100
***************
*** 1,7 ****
\! ./src/cursors-test
connected
! SQL_CURSOR_COMMIT_BEHAVIOR: SQL_CB_PRESERVE
! SQL_CURSOR_ROLLBACK_BEHAVIOR: SQL_CB_PRESERVE

foo1 foo2 foo3 foo4 foo5 foo6 foo7 foo8 foo9 foo10 foo11 foo12 foo13 foo14 foo15 foo16 foo17 foo18 foo19 foo20 ... foo3207 foo3208 foo3209 foo3210
Fetched 3210 rows altogether
--- 1,7 ----
\! ./src/cursors-test
connected
! SQL_CURSOR_COMMIT_BEHAVIOR: unknown (728104962)
! SQL_CURSOR_ROLLBACK_BEHAVIOR: unknown (728104962)

foo1 foo2 foo3 foo4 foo5 foo6 foo7 foo8 foo9 foo10 foo11 foo12 foo13 foo14 foo15 foo16 foo17 foo18 foo19 foo20 ... foo3207 foo3208 foo3209 foo3210
Fetched 3210 rows altogether

The problem is the same on mips, mipsel, powerpc, s390x, and sparc.
(With different numbers in brackets after the "unknown".)

s390x has that problem, plus an additional diff for positioned-update:

*** /«PKGBUILDDIR»/test/expected/positioned-update.out Tue Dec 17 14:16:00 2013
--- /«PKGBUILDDIR»/test/results/positioned-update.out Wed Feb 5 17:09:31 2014
***************
*** 13,19 ****
2 2
3 3
4 4
! 105 5
7 7
8 8
9 9
--- 13,19 ----
2 2
3 3
4 4
! 5 5
7 7
8 8
9 9

The full build logs can be seen on
https://buildd.debian.org/status/package.php?p=psqlodbc

(ia64 is also failing, but that looks like a unixodbc problem, and
ia64 will be going away in Debian soonish anyway.)

Does anyone have an idea what's the problem here? The package was
building basically fine before; some builds were somewhat fragile due
to unixodbc problems and had to be retried manually, but these
failures are new and are reproducible.

Mit freundlichen Grüßen,
Christoph Berg
--
Senior Berater, Tel.: +49 (0)21 61 / 46 43-187
credativ GmbH, HRB Mönchengladbach 12080, USt-ID-Nummer: DE204566209
Hohenzollernstr. 133, 41061 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
pgp fingerprint: 5C48 FE61 57F4 9179 5970 87C6 4C5A 6BAB 12D2 A7AE

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Nils Gösche 2014-02-13 17:53:20 Null Characters in Strings, Version 9.3.1
Previous Message Itnal, Prakash (NSN - IN/Bangalore) 2014-02-11 11:07:44 Crash observed on psqlODBC driver