BUG #3272: ECPG YE000 error
The following bug has been logged online:
Bug reference: 3272
Logged by: Taso Hatzi
Email address: taso@aanet.com.au
PostgreSQL version: 8.2.4
Operating system: Red Hat Enterprise Linux ES release 4 (Nahant Update 5)
Description: ECPG YE000 error
Details:
The host is a Dell 2950 Dual Intel Xeon with 2GB RAM
Built 8.2.4 from postgresql-8.2.4-1PGDG.src.rpm
Removed all traces of 7.4.16-1.RHEL4
Everything appeared to go OK.
The application is multi-threaded. It bombs with a YE000 error when
subjected to any sort of work load.
Compiled the application on a Fedora Core release 6 (Zod) box running
8.1.8-1.fc6 and pointed it to the 8.2.4 server and it looks Ok.
I'm not sure what debug info to collect.
It looks to me like a thread isolation problem.
Any pointers on how top proceed gladly received.
Taso Hatzi wrote:
It looks to me like a thread isolation problem.
I don't know anything about the RPM packages, but did you use the
--enable-thread-safety option wuth configure?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Heikki Linnakangas wrote:
I don't know anything about the RPM packages, but did you use the
--enable-thread-safety option wuth configure?
The RPM package enables that option.
$ pg_config
CONFIGURE = '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' '--target=i686-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin'
'--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com'
'--mandir=/usr/share/man' '--infodir=/usr/share/info' '--disable-rpath' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib' '--with-openssl' '--with-pam' '--with-krb5'
'--with-includes=/usr/include' '--with-libraries=/usr/lib' '--enable-nls' '--enable-thread-safety' '--sysconfdir=/etc/sysconfig/pgsql' '--datadir=/usr/share/pgsql' '--with-docdir=/usr/share/doc'
'CFLAGS=-O2 -g -pipe -m32 -march=i686 -mtune=pentium4 -I/usr/include/et' 'CPPFLAGS= -I/usr/include/et' 'build_alias=i686-redhat-linux-gnu' 'host_alias=i686-redhat-linux-gnu'
'target_alias=i686-redhat-linux-gnu'
"Taso Hatzi" <taso@aanet.com.au> writes:
It looks to me like a thread isolation problem.
If you have multiple threads accessing the same connection, it's
up to *you* to provide interlocking to make sure they don't try
to issue concurrent queries; libpq has no internal mutex for that.
I believe similar statements hold for ECPG's state.
regards, tom lane