Hi everyone,

We compiled the dyntest.pgc (in src/interfaces/ecpg/test)
and tried it out but it seems like it is not able to
stop after reading the last record and keep going on
forever. sqlcode return is always 0 and never get to 100
where it is supposed to. The dyntest.pgc has not changed from
7.3.4 to 7.4 and it used to work in 7.3.4.

This is PostgreSQL 7.4 in Sparc Solaris 9.

Any idea ?

Gan


$ psql
Welcome to psql 7.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

Field separator is " ".
A=> select * from lucytest;
c1
----------
record 1
record 2
(2 rows)

A=> \q
$
$ ./lucyDyntest74 lucytest
sqlcode=0
1 Columns
c1 varchar(100)

'record 1'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
'record 2'|
sqlcode=0
.....
.....

$
$
$ ldd lucyDyntest74
libecpg.so.4 => /platdb/lib/libecpg.so.4
libc.so.1 => /usr/lib/libc.so.1
libpgtypes.so.1 => /platdb/lib/libpgtypes.so.1
libpq.so.3 => /platdb/lib/libpq.so.3
libm.so.1 => /usr/lib/libm.so.1
libdl.so.1 => /usr/lib/libdl.so.1
libresolv.so.2 => /usr/lib/libresolv.so.2
libsocket.so.1 => /usr/lib/libsocket.so.1
libnsl.so.1 => /usr/lib/libnsl.so.1
libmp.so.2 => /usr/lib/libmp.so.2
/usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1
$

--
+--------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On Wed, Dec 10, 2003 at 01:50:39PM -0600, Seum-Lim Gan wrote:
Do you use any special options to ecpg?

I just tried with CVS HEAD and it runs without a problem. Albeit on an
empty database just showing the system tables.

Anyone else having problems with this test case?

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Hi Michael,

This is how we build dyntest:

/platdb/bin/ecpg -I /platdb/include -o dyntest74.c dyntest.pgc
cc -I/platdb/include -R/platdb/lib -L/platdb/lib -lecpg -o
lucyDyntest74 dyntest74.c


The cc here is the Sun Workshop compiler.

Thanks.

Gan

At 10:03 pm +0100 2003/12/10, Michael Meskes wrote:

--
+--------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Wed, Dec 10, 2003 at 03:29:44PM -0600, Seum-Lim Gan wrote:
This looks like a wrong library. The latest ecpg does need more that
libecpg. It also needs libpgtypes. Since you don't include this i wonder
if you link against an older libecpg.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Hi,

On Thu, Dec 11, 2003 at 04:10:05PM -0600, Seum-Lim Gan wrote:
You misunderstood me. I wasn't talking about libpq but about libpgtypes.
The latest libecpg should depend on libpgtypes. Since yours doesn't I
wonder which on you link to your program.

Could you please tell me which version of libecpg you are using?

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Hi Michael,

Looks like the libecpg we are using is 4.0.

Any idea ?

Gan

-rw-r--r-- 1 postgres postgres 245396 Dec 10 21:57 libpq.a
-rwxr-xr-x 1 postgres postgres 210700 Dec 10 21:57 libpq.so.3.1
lrwxrwxrwx 1 postgres postgres 12 Dec 10 21:57 libpq.so.3 ->
libpq.so.3.1
lrwxrwxrwx 1 postgres postgres 12 Dec 10 21:57 libpq.so -> libpq.so.3.1
-rw-r--r-- 1 postgres postgres 126432 Dec 10 21:57 libpgtypes.a
-rwxr-xr-x 1 postgres postgres 112972 Dec 10 21:58 libpgtypes.so.1.0
lrwxrwxrwx 1 postgres postgres 17 Dec 10 21:58 libpgtypes.so.1
-> libpgtypes.so.1.0
lrwxrwxrwx 1 postgres postgres 17 Dec 10 21:58 libpgtypes.so
-> libpgtypes.so.1.0
-rw-r--r-- 1 postgres postgres 110964 Dec 10 21:58 libecpg.a
-rw-r--r-- 1 postgres postgres 20140 Dec 10 21:58 libecpg_compat.a
-rwxr-xr-x 1 postgres postgres 97528 Dec 10 21:58 libecpg.so.4.0
lrwxrwxrwx 1 postgres postgres 14 Dec 10 21:58 libecpg.so.4 ->
libecpg.so.4.0
lrwxrwxrwx 1 postgres postgres 14 Dec 10 21:58 libecpg.so ->
libecpg.so.4.0
-rwxr-xr-x 1 postgres postgres 23876 Dec 10 21:58 libecpg_compat.so.1.0
lrwxrwxrwx 1 postgres postgres 21 Dec 10 21:58
libecpg_compat.so.1 -> libecpg_compat.so.1.0
lrwxrwxrwx 1 postgres postgres 21 Dec 10 21:58
libecpg_compat.so -> libecpg_compat.so.1.0


At 7:33 am +0100 2003/12/12, Michael Meskes wrote:

--
+--------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Sat, Dec 20, 2003 at 05:48:41AM +0800, Liang, Guang Yu (Lucy) wrote:
Actually I also meant to use a database with no tables defined other
than the system ones.

The same seems to happen with NOT FOUND. The log files says "raising
sqlcode 100 in line 57, 'No data found in line 57.'." more than 500
times. :-(

Did you compile with ENABLE_THREAD_SAFETY?

Is there a way for me to get a login into your machine? The code looks
okay to me. At the moment I have no idea what's going on.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Michael,

Yes, the enable-thread-safety is used in configure file.
Is it expected to be there?

I can try an empty database and let you know the result.

For machine login, I'm afraid it will be agains Lucent
Security policy. Maybe we can try to open a Netmeeting
session and share the desktop to see the same window.

If this is feasible, we will have to work out a time. I'm in
Beijing China and the time Zone is GMT+8. We have 8
hours time difference, right? I will be available in the
morning of Dec 31, say 9:00 am. Please let me know
whether it's a good time for you.

Thanks,
Lucy

-----Original Message-----
From: Michael Meskes [mailto:meskes (AT) postgresql (DOT) org]
Sent: Saturday, December 27, 2003 4:31 AM
To: Liang, Guang Yu (Lucy)
Cc: Seum-Lim Gan; pgsql-bugs (AT) postgresql (DOT) org
Subject: Re: [BUGS] dyntest.pgc not working in 7.4 ?


On Sat, Dec 20, 2003 at 05:48:41AM +0800, Liang, Guang Yu (Lucy) wrote:
Actually I also meant to use a database with no tables defined other
than the system ones.

The same seems to happen with NOT FOUND. The log files says "raising
sqlcode 100 in line 57, 'No data found in line 57.'." more than 500
times. :-(

Did you compile with ENABLE_THREAD_SAFETY?

Is there a way for me to get a login into your machine? The code looks
okay to me. At the moment I have no idea what's going on.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Michael,

As you indicated, we may change some configurations
to see whether it can help.

The configuration parameters I used are as follows:

/bin/env CC=$MYCC ./configure \
--prefix=/platdb \
--with-pgport=5333 \
--without-readline \
--with-CXX \
--with-perl \
--with-java \
--with-pam \
--enable-syslog \
--enable-thread-safety \
--enable-nls 2>&1 1>>$PGLOG

Any suggestions?

Thanks,
Lucy

-----Original Message-----
From: Liang, Guang Yu (Lucy) [mailto:lucyliang (AT) lucent (DOT) com]
Sent: Monday, December 29, 2003 3:10 PM
To: 'Michael Meskes'
Cc: Seum-Lim Gan; pgsql-bugs (AT) postgresql (DOT) org
Subject: Re: [BUGS] dyntest.pgc not working in 7.4 ?


Michael,

Yes, the enable-thread-safety is used in configure file.
Is it expected to be there?

I can try an empty database and let you know the result.

For machine login, I'm afraid it will be agains Lucent
Security policy. Maybe we can try to open a Netmeeting
session and share the desktop to see the same window.

If this is feasible, we will have to work out a time. I'm in
Beijing China and the time Zone is GMT+8. We have 8
hours time difference, right? I will be available in the
morning of Dec 31, say 9:00 am. Please let me know
whether it's a good time for you.

Thanks,
Lucy

-----Original Message-----
From: Michael Meskes [mailto:meskes (AT) postgresql (DOT) org]
Sent: Saturday, December 27, 2003 4:31 AM
To: Liang, Guang Yu (Lucy)
Cc: Seum-Lim Gan; pgsql-bugs (AT) postgresql (DOT) org
Subject: Re: [BUGS] dyntest.pgc not working in 7.4 ?


On Sat, Dec 20, 2003 at 05:48:41AM +0800, Liang, Guang Yu (Lucy) wrote:
Actually I also meant to use a database with no tables defined other
than the system ones.

The same seems to happen with NOT FOUND. The log files says "raising
sqlcode 100 in line 57, 'No data found in line 57.'." more than 500
times. :-(

Did you compile with ENABLE_THREAD_SAFETY?

Is there a way for me to get a login into your machine? The code looks
okay to me. At the moment I have no idea what's going on.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Mon, Dec 29, 2003 at 03:10:12PM +0800, Liang, Guang Yu (Lucy) wrote:
Could you please try to configure without threading? I'd just like to
remove all components not neccessary to see if the problem still arises.

ok.

Actually I'm afraid that won't be enough, as I can send you all things
to test via email as well. The problem is that this has such a long
turnaround. If I could access the machine, or another one with this bug,
myself, I could test debug the whole stuff.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings