[Rls-support] RLS does not answer

[Shishir S. Bharathi]

Jens,

I think this has already been reported as due to the mismatch between 
iodbc and the driver.

http://bugzilla.globus.org/globus/show_bug.cgi?id=3403


Shishir



On Wed, 25 May 2005, Jens-S. Voeckler wrote:

> Addendum,
> 
> [pid  8617] send(14, "Qselect version()\0", 18, 0) = 18
> [pid  8617] recv(14, "Pblank\0T\0\1version\0\0\0\0\31\377\377\377\377\377\377D\200\0\0\0JPostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4CSELECT\0Z", 81
> [pid  8617] time(NULL)                  = 1117059692
> [pid  8617] send(14, "Qset DateStyle to \'ISO\'\0", 24, 0) = 24
> [pid  8617] recv(14, "CSET\0Z", 8192, 0) = 6
> [pid  8617] send(14, "Qset geqo to \'OFF\'\0", 19, 0) = 19
> [pid  8617] recv(14, "CSET\0Z", 8192, 0) = 6
> [pid  8617] send(14, "Qset extra_float_digits to 2\0", 29, 0) = 29
> [pid  8617] recv(14, "CSET\0Z", 8192, 0) = 6
> [pid  8617] send(14, "Qselect oid from pg_type where typname=\'lo\'\0", 44, 0) = 44
> [pid  8617] recv(14, "Pblank\0T\0\1oid\0\0\0\0\32\0\4\377\377\377\377CSELECT\0Z", 8192, 0) = 33
> [pid  8617] send(14, "Qselect pg_client_encoding()\0", 29, 0) = 29
> [pid  8617] recv(14, "Pblank\0T\0\1pg_client_encoding\0\0\0\0\23\0@\377\377\377\377D\200\0\0\0\rSQL_ASCIICSELECT\0Z", 8192, 0) = 63
> [pid  8617] send(14, "Qset client_encoding to \'UTF8\'\0", 31, 0) = 31
> [pid  8617] recv(14, "CSET\0Z", 8192, 0) = 6
> [pid  8617] time(NULL)                  = 1117059692
> [pid  8617] send(13, "QBEGIN;insert into t_lfn (name, ref) values (\'asdf\', 1)\0", 56, 0) = 56
> [pid  8617] recv(13, "CBEGIN\0Pblank\0CINSERT 2167057 1\0Z", 8192, 0) = 33
> [pid  8617] send(13, "Qselect id from t_lfn where name = \'asdf\'\0", 42, 0) = 42
> [pid  8617] recv(13, "Pblank\0T\0\1id\0\0\0\0\27\0\4\377\377\377\377D\200\0\0\0\00622CSELECT\0Z", 8192, 0) = 40
> [pid  8617] time(NULL)                  = 1117059692
> [pid  8617] send(13, "Qupdate t_pfn set ref = ref + 1 where name = \'file:///qwer\'\0", 60, 0) = 60
> [pid  8617] recv(13, "Pblank\0CUPDATE 0\0Z", 8192, 0) = 18
> [pid  8617] brk(0)                      = 0x80d3000
> [pid  8617] brk(0x80d4000)              = 0x80d4000
> [pid  8617] time(NULL)                  = 1117059692
> [pid  8617] fstat64(1, {st_mode=S_IFREG|0644, st_size=718252, ...}) = 0
> [pid  8617] mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x412dd000
> [pid  8617] send(13, "QROLLBACK\0", 10, 0) = 10
> [pid  8617] recv(13, "CROLLBACK\0Z", 8192, 0) = 11
> 
> Considering that I see a rollback here, I think that something in the
> statements is not liked by my Pg 8.0.2. I had myself some problems from
> the JDBC side, because the type checking appears to be stricter in Pg8,
> e.g.  don't insert strings into columns of numeric type.
> 
> Where can I find the sequence of statements that you are executing for Pg?
> 
> Aloha,
> Dipl.-Ing. Jens-S. Vöckler   voeckler at cs dot uchicago dot edu
> University of Chicago; Research Institutes Building #402;
> 5640 South Ellis Avenue; Chicago, IL 60637-1433; USA; +1 773 834 6693
> * You can rely on any shared filesystems for only one thing - don't! *
> 

-- 
Frobnitz, pl. Frobnitzem (frob'nitsm) n.:
	An unspecified physical object, a widget.  Also refers to electronic
black boxes.  This rare form is usually abbreviated to FROTZ, or more
commonly to FROB.  Also used are FROBNULE, FROBULE, and FROBNODULE.
Starting perhaps in 1979, FROBBOZ (fruh-bahz'), pl. FROBBOTZIM, has also
become very popular, largely due to its exposure via the Adventure spin-off
called Zork (Dungeon).  These can also be applied to non-physical objects,
such as data structures.