[gold-users] Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Command line client failure: "Failed receiving reply: (No HTTP header returned by server.)."

RNothdurft at spirit21.de RNothdurft at spirit21.de
Wed Jul 28 12:39:37 MDT 2010


Hi Scott,

- updated DBI from cpan with (cpan -i DBI) -> problem still there
- updated DBI by yast ->  no success
- updated whole perl -> no success
- recompiled and -installed gold -> no success
- installed mysql (modification of bank.sql on CREATE INDEX ... WHERE ... 
-line, cause mysql-syntax doesn't accept WHERE there), recompiled and 
-installed gold -> success :)

no idea where the problem is with postgresql...

Thanks for your help anyway. tell me if you're still interested in finding 
the problem with pg.

Kind regards,
Richard


Richard Nothdurft
DHBW-Student der SPIRIT/21 AG
Otto-Lilienthal-Str. 36, 71034 Böblingen
Mobil: 0177/7427024
E-Mail: rnothdurft at spirit21.de
Internet: http://www.spirit21.de


gold-users-bounces at supercluster.org schrieb am 27.07.2010 17:40:48:

> Scott Jackson <scottmo at adaptivecomputing.com> 
> Gesendet von: gold-users-bounces at supercluster.org
> 
> 27.07.2010 17:40
> 
> Bitte antworten an
> Gold Users Mailing List <gold-users at supercluster.org>
> 
> An
> 
> Gold Users Mailing List <gold-users at supercluster.org>
> 
> Kopie
> 
> gold-users-bounces at supercluster.org
> 
> Thema
> 
> Re: [gold-users] Antwort: Re: Antwort: Re: Antwort: Re: Command line
> client failure: "Failed receiving reply: (No HTTP header returned 
byserver.)."
> 
> Richard,
> 
> What I would recommend at this point would be to install the latest perl 

> DBI module from CPAN for your architecture/operating system.
> 
> Something like:
> 
> cpan -i DBI
> 
> I have a hunch that this will fix it.
> 
> Thanks,
> 
> Scott
> 
> RNothdurft at spirit21.de wrote:
> > Hi Scott,
> >
> > i got an error in line "my ($id) = $sth->fetchrow_array();" (see 
below).
> >
> > Thanks,
> > Richard
> >
> > >
> > > Richard,
> > >
> > > Oops, I meant to ask for the output of:
> > >
> > > echo "select * from g_key_generator" | psql gold
> >    g_name    | g_next_id
> > -------------+-----------
> >  Account     |         1
> >  Allocation  |         1
> >  Reservation |         1
> >  Quotation   |         1
> >  Job         |         1
> >  Transaction |       271
> >  Request     |       273
> > (7 rows)
> > >
> > > ...although some of your other output suggests that this may not be 
the
> > > problem.
> > >
> > > Bummer, I think we will have to debug it.
> > >
> > > Please examine the goldd script and remove the -T flag from the perl
> > > magic line if it is there (it should not be there in the latest
> > > versions) and add the -d flag. The top line should look something 
like:
> > >
> > > #! /usr/bin/perl -wd
> > >
> > > Then start goldd. It should drop you into the perl debugger.
> > >
> > > Keep nexting (n) until you get past the fork and it opens a daughter
> > > perl debugger.
> > >
> > > In the daughter perl debugger enter:
> > >
> > >  b Gold::Database::nextId
> > >
> > > c
> > >
> > > It should hang...
> > >
> > > In another terminal, issue a gold client command like glsuser.
> > >
> > > You should get another daughter perl debugger in nextId:
> > >
> > > Now you need to next through it and try to figure out what is 
happening:
> > >
> > >
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1758):
> > > 1758:       my ($self, $object) = @_;
> > >   DB<2> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1760):
> > > 1760:       if ($log->is_trace())
> > > 1761:       {
> > >   DB<2> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1762):
> > > 1762:           $log->trace("invoked with arguments: (", join(', ', 
> > @_[1
> > > .. $#_]), ")");
> > >   DB<2> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1766):
> > > 1766:       my $dbh = $self->{_handle};
> > >   DB<2> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1769):
> > > 1769:       my $count = $dbh->do(
> > > 1770:           "UPDATE g_key_generator set g_next_id=g_next_id+1 
WHERE
> > > g_name='$object'"
> > > 1771:       );
> > >   DB<2> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1772):
> > > 1772:       if ($count != 1)
> > > 1773:       {
> > >   DB<2> p $count
> > > 1
> > >   DB<3> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1779):
> > > 1779:       my $sth = $dbh->prepare(
> > > 1780:           "SELECT g_next_id-1 FROM g_key_generator WHERE
> > > g_name='$object'");
> > >   DB<3> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1781):
> > > 1781:       $sth->execute();
> > >   DB<3> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1782):
> > > 1782:       my ($id) = $sth->fetchrow_array();
> > >   DB<3> n
> > here i got an error:
> > Gold::Database::nextId(/opt/gold/lib/Gold/Database.pm:1780):
> > 1780:       my ($id) = $sth->fetchrow_array();
> >   DB<3> n
> > Signal SEGV at /opt/gold/lib/Gold/Proxy.pm line 181
> >         Gold::Proxy::__ANON__[/opt/gold/lib/Gold/Proxy.pm:182]() 
> > called at /opt/gold/lib/perl5/Error.pm line 379
> >         eval {...} called at /opt/gold/lib/perl5/Error.pm line 371
> >         Error::subs::try('CODE(0x3134dc0)', 'HASH(0x320e9b0)') called 
> > at /opt/gold/lib/Gold/Proxy.pm line 187
> >         Gold::Proxy::new('Gold::Proxy', 'request', 
> > 'Gold::Request=HASH(0x31348f8)') called at ./goldd line 297
> >         main::__ANON__[./goldd:341]() called at 
> > /opt/gold/lib/perl5/Error.pm line 379
> >         eval {...} called at /opt/gold/lib/perl5/Error.pm line 371
> >         Error::subs::try('CODE(0x129c4b0)', 'HASH(0x321d350)') called 
> > at ./goldd line 374
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1783):
> > > 1783:       unless ($id)
> > > 1784:       {
> > >   DB<3> p $id
> > > 343
> > >   DB<4> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1788):
> > > 1788:       if ($log->is_trace())
> > > 1789:       {
> > >   DB<4> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1790):
> > > 1790:           $log->trace("generated new id $id for $object");
> > >   DB<4> n
> > > Gold::Database::nextId(/opt/gold-3.0/lib/Gold/Database.pm:1793):
> > > 1793:       return $id;
> > >
> > >
> > > Let me know what additional clues this process reveals.
> > >
> > > Thanks,
> > >
> > > Scott
> > >
> > >
> > >
> > >
> > >
> > >
> > > RNothdurft at spirit21.de wrote:
> > > > Hi Scott,
> > > >
> > > > thank you very much for your support. There's sadly no possibility 
to
> > > > connect directly to the system, your requested informations are 
> > below.
> > > > Tell me if there's something more i can do to help finding the 
> > problem.
> > > >
> > > > Kind regards,
> > > > Richard
> > > >
> > > >
> > > >
> > > >
> > > > Richard Nothdurft
> > > > DHBW-Student der SPIRIT/21 AG
> > > > Otto-Lilienthal-Str. 36, 71034 Böblingen
> > > > Mobil: 0177/7427024
> > > > E-Mail: rnothdurft at spirit21.de
> > > > Internet: http://www.spirit21.de <http://www.spirit21.de/> 
> > <http://www.spirit21.de/>
> > > >
> > > >
> > > > gold-users-bounces at supercluster.org schrieb am 26.07.2010 
19:55:30:
> > > >
> > > > > Scott Jackson <scottmo at adaptivecomputing.com>
> > > > > Gesendet von: gold-users-bounces at supercluster.org
> > > > >
> > > > > 26.07.2010 19:55
> > > > >
> > > > > Bitte antworten an
> > > > > Gold Users Mailing List <gold-users at supercluster.org>
> > > > >
> > > > > An
> > > > >
> > > > > Gold Users Mailing List <gold-users at supercluster.org>
> > > > >
> > > > > Kopie
> > > > >
> > > > > Thema
> > > > >
> > > > > Re: [gold-users] Antwort: Re: Command line client failure: 
"Failed
> > > > > receiving reply: (No HTTP header returned by server.)."
> > > > >
> > > > > Richard,
> > > > >
> > > > > OK, we are going to need to dive in. If there is any way I can 
> > be given
> > > > > login access to your system, it will make it that much faster.
> > > > >
> > > > > Where was gold installed (PATH)? Can you give me the head of
> > > > config.log?
> > > > /opt/gold
> > > > for config.log see attachment
> > > > >
> > > > > Then please send me the goldd.conf and gold.conf in 
$prefix/etc/.
> > > > see attachment
> > > > >
> > > > >  From the database referred to therein, please send the results 
of:
> > > > >
> > > > > echo "\d g_key_generator" | psql gold_db_name
> > > >  Table "public.g_key_generator"
> > > >   Column   |          Type           | Modifiers
> > > > -----------+-------------------------+-----------
> > > >  g_name    | character varying(1024) | not null
> > > >  g_next_id | integer                 | not null
> > > > Indexes:
> > > >     "g_key_generator_name_idx" btree (g_name)
> > > > >
> > > > > and
> > > > >
> > > > > echo "\l" | psql gold_db_name
> > >
> > >
> > > >         List of databases
> > > >    Name    |   Owner   | Encoding
> > > > -----------+-----------+----------
> > > >  gold      | goldadmin | UTF8
> > > >  postgres  | postgres  | UTF8
> > > >  template0 | postgres  | UTF8
> > > >  template1 | postgres  | UTF8
> > > > >
> > > > > Please also give me the output from
> > > > >
> > > > > ps -ef|egrep -i "gold|post|pg"
> > > > postfix   2036  3775  0 Jul21 ?        00:00:00 qmgr -l -t fifo -u
> > > > root      3775     1  0 Jul07 ?        00:00:02 
> > /usr/lib/postfix/master
> > > > 1002     10236     1  0 18:02 pts/1    00:00:00 /usr/bin/perl -w
> > > > /opt/gold/sbin/goldd
> > > > postfix  12934  3775  0 19:34 ?        00:00:00 pickup -l -t fifo 
-u
> > > > root     14958 31483  0 20:42 pts/1    00:00:00 su goldadmin
> > > > 1002     15044 14959  0 20:44 pts/1    00:00:00 egrep -i 
gold|post|pg
> > > > postgres 27736     1  0 Jul21 ?        00:00:05 
> > /usr/bin/postmaster -D
> > > > /var/lib/pgsql/data
> > > > postgres 27737 27736  0 Jul21 ?        00:00:02 postgres: logger 
> > process
> > > > postgres 27739 27736  0 Jul21 ?        00:00:08 postgres: writer 
> > process
> > > > postgres 27740 27736  0 Jul21 ?        00:00:05 postgres: wal 
writer
> > > > process
> > > > postgres 27741 27736  0 Jul21 ?        00:00:04 postgres: 
autovacuum
> > > > launcher process
> > > > postgres 27742 27736  0 Jul21 ?        00:00:06 postgres: stats
> > > > collector process
> > > > >
> > > > > and
> > > > >
> > > > > lsof | grep gold
> > > > goldd     10236  goldadmin  cwd       DIR      8,2     4096 
> > 434177 /tmp
> > > > goldd     10236  goldadmin  rtd       DIR      8,2     4096 2 /
> > > > goldd     10236  goldadmin  txt       REG      8,2  1644816 364253
> > > > /usr/bin/perl
> > > > goldd     10236  goldadmin  mem       REG      8,2   110440 
4726880
> > > > /usr/lib64/libsasl2.so.2.0.22
> > > > goldd     10236  goldadmin  mem       REG      8,2    64680 
4726986
> > > > /usr/lib64/liblber-2.4.so.2.2.0
> > > > goldd     10236  goldadmin  mem       REG      8,2    84984 
8568869
> > > > /lib64/libresolv-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    10336 
8568911
> > > > /lib64/libkeyutils-1.2.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    35800 
4726907
> > > > /usr/lib64/libkrb5support.so.0.1
> > > > goldd     10236  goldadmin  mem       REG      8,2    14688 
8568950
> > > > /lib64/libcom_err.so.2.1
> > > > goldd     10236  goldadmin  mem       REG      8,2   154776 
4726895
> > > > /usr/lib64/libk5crypto.so.3.1
> > > > goldd     10236  goldadmin  mem       REG      8,2   664216 
4726905
> > > > /usr/lib64/libkrb5.so.3.3
> > > > goldd     10236  goldadmin  mem       REG      8,2   303416 
4726990
> > > > /usr/lib64/libldap_r-2.4.so.2.2.0
> > > > goldd     10236  goldadmin  mem       REG      8,2   181808 
4726891
> > > > /usr/lib64/libgssapi_krb5.so.2.2
> > > > goldd     10236  goldadmin  mem       REG      8,2  1547056 366434
> > > > /usr/lib64/libcrypto.so.0.9.8
> > > > goldd     10236  goldadmin  mem       REG      8,2   317856 366435
> > > > /usr/lib64/libssl.so.0.9.8
> > > > goldd     10236  goldadmin  mem       REG      8,2   150864 
4727056
> > > > /usr/lib64/libpq.so.5.1
> > > > goldd     10236  goldadmin  mem       REG      8,2   432101 41821
> > > > /opt/gold/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Pg/Pg.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    47784 
8568858
> > > > /lib64/libnss_files-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    43744 
8568862
> > > > /lib64/libnss_nis-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    89232 
8568852
> > > > /lib64/libnsl-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    31792 
8568854
> > > > /lib64/libnss_compat-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2   209076 41702
> > > > /opt/gold/lib/perl5/x86_64-linux-thread-multi/auto/Params/
> > > Validate/Validate.so
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2    26896 491551
> > > > 
> > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/MIME/Base64/Base64.so 

> >
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2    31104 492428
> > > > /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/
> > > Digest/SHA1/SHA1.so
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2    26912 483765
> > > > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/Digest/MD5/MD5.so
> > > > goldd     10236  goldadmin  mem       REG      8,2   166648 485209
> > > > /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/Compress/Raw/
> > > Zlib/Zlib.so
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2    23040 483780
> > > > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/File/Glob/Glob.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    47848 483787
> > > > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/List/Util/Util.so
> > > > goldd     10236  goldadmin  mem       REG      8,2   339264 509287
> > > > 
> > 
/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/DBI.so 

> >
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2    31208 483795
> > > > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/Socket/Socket.so
> > > > goldd     10236  goldadmin  mem       REG      8,2   783752 501592
> > > > /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/
> > > XML/LibXML/LibXML.so
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2    27080 483783
> > > > /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/IO/IO.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    88704 
8568878
> > > > /lib64/libz.so.1.2.3
> > > > goldd     10236  goldadmin  mem       REG      8,2  1430024 365276
> > > > /usr/lib64/libxml2.so.2.7.1
> > > > goldd     10236  goldadmin  mem       REG      8,2    18840 500773
> > > > /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/
> > > XML/LibXML/Common/Common.so
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2   187920 483790
> > > > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/POSIX/POSIX.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    22888 483776
> > > > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/Fcntl/Fcntl.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    10488 491629
> > > > /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/Sys/Hostname/
> > > Hostname.so
> > > >
> > > > goldd     10236  goldadmin  mem       REG      8,2    36008 
8568871
> > > > /lib64/librt-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    35360 491641
> > > > 
> > 
/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/Time/HiRes/HiRes.so
> > > > goldd     10236  goldadmin  mem       REG      8,2  1400360 
8568841
> > > > /lib64/libc-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2   130284 
8568867
> > > > /lib64/libpthread-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    59984 
8568845
> > > > /lib64/libcrypt-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2    14872 
8568847
> > > > /lib64/libdl-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2   350648 
8568849
> > > > /lib64/libm-2.9.so
> > > > goldd     10236  goldadmin  mem       REG      8,2   127672 
8568834
> > > > /lib64/ld-2.9.so
> > > > goldd     10236  goldadmin    0r      CHR      1,3      0t0 2225
> > > > /dev/null
> > > > goldd     10236  goldadmin    1w      CHR      1,3      0t0 2225
> > > > /dev/null
> > > > goldd     10236  goldadmin    2u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > goldd     10236  goldadmin    3r      REG      8,2    15708 41943
> > > > /opt/gold/sbin/goldd
> > > > goldd     10236  goldadmin    4w      REG      8,2  2155142 42136
> > > > /opt/gold/log/goldd.log
> > > > goldd     10236  goldadmin    5u     IPv4 12542069      0t0 TCP
> > > > *:7112 (LISTEN)
> > > > bash      14959  goldadmin  cwd       DIR      8,2     4096 41874
> > > > /opt/gold/etc
> > > > bash      14959  goldadmin  rtd       DIR      8,2     4096 2 /
> > > > bash      14959  goldadmin  txt       REG      8,2   715072 
1777675
> > > > /bin/bash
> > > > bash      14959  goldadmin  mem       REG      8,2    47784 
8568858
> > > > /lib64/libnss_files-2.9.so
> > > > bash      14959  goldadmin  mem       REG      8,2    43744 
8568862
> > > > /lib64/libnss_nis-2.9.so
> > > > bash      14959  goldadmin  mem       REG      8,2    89232 
8568852
> > > > /lib64/libnsl-2.9.so
> > > > bash      14959  goldadmin  mem       REG      8,2    31792 
8568854
> > > > /lib64/libnss_compat-2.9.so
> > > > bash      14959  goldadmin  mem       REG      8,2   293936 
8568896
> > > > /lib64/libncurses.so.5.6
> > > > bash      14959  goldadmin  mem       REG      8,2  1400360 
8568841
> > > > /lib64/libc-2.9.so
> > > > bash      14959  goldadmin  mem       REG      8,2    14872 
8568847
> > > > /lib64/libdl-2.9.so
> > > > bash      14959  goldadmin  mem       REG      8,2   263568 
8568939
> > > > /lib64/libreadline.so.5.2
> > > > bash      14959  goldadmin  mem       REG      8,2   127672 
8568834
> > > > /lib64/ld-2.9.so
> > > > bash      14959  goldadmin  mem       REG      8,2   256444 476399
> > > > /usr/lib/locale/en_US.utf8/LC_CTYPE
> > > > bash      14959  goldadmin  mem       REG      8,2   952254 476400
> > > > /usr/lib/locale/en_US.utf8/LC_COLLATE
> > > > bash      14959  goldadmin  mem       REG      8,2       54 476381
> > > > /usr/lib/locale/en_US.utf8/LC_NUMERIC
> > > > bash      14959  goldadmin  mem       REG      8,2     2454 467301
> > > > /usr/lib/locale/en_US.utf8/LC_TIME
> > > > bash      14959  goldadmin  mem       REG      8,2      286 467300
> > > > /usr/lib/locale/en_US.utf8/LC_MONETARY
> > > > bash      14959  goldadmin  mem       REG      8,2       52 476374
> > > > /usr/lib/locale/en_US.utf8/LC_MESSAGES/SYS_LC_MESSAGES
> > > > bash      14959  goldadmin  mem       REG      8,2       34 476311
> > > > /usr/lib/locale/en_US.utf8/LC_PAPER
> > > > bash      14959  goldadmin  mem       REG      8,2       77 476324
> > > > /usr/lib/locale/en_US.utf8/LC_NAME
> > > > bash      14959  goldadmin  mem       REG      8,2      155 467297
> > > > /usr/lib/locale/en_US.utf8/LC_ADDRESS
> > > > bash      14959  goldadmin  mem       REG      8,2       59 476290
> > > > /usr/lib/locale/en_US.utf8/LC_TELEPHONE
> > > > bash      14959  goldadmin  mem       REG      8,2       23 476312
> > > > /usr/lib/locale/en_US.utf8/LC_MEASUREMENT
> > > > bash      14959  goldadmin  mem       REG      8,2    26050 476168
> > > > /usr/lib64/gconv/gconv-modules.cache
> > > > bash      14959  goldadmin  mem       REG      8,2      373 467298
> > > > /usr/lib/locale/en_US.utf8/LC_IDENTIFICATION
> > > > bash      14959  goldadmin    0u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > bash      14959  goldadmin    1u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > bash      14959  goldadmin    2u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > bash      14959  goldadmin  255u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > lsof      15098  goldadmin  cwd       DIR      8,2     4096 41874
> > > > /opt/gold/etc
> > > > lsof      15098  goldadmin  rtd       DIR      8,2     4096 2 /
> > > > lsof      15098  goldadmin  txt       REG      8,2   127416 364531
> > > > /usr/bin/lsof
> > > > lsof      15098  goldadmin  mem       REG      8,2    14872 
8568847
> > > > /lib64/libdl-2.9.so
> > > > lsof      15098  goldadmin  mem       REG      8,2  1400360 
8568841
> > > > /lib64/libc-2.9.so
> > > > lsof      15098  goldadmin  mem       REG      8,2   113904 
8568931
> > > > /lib64/libselinux.so.1
> > > > lsof      15098  goldadmin  mem       REG      8,2   127672 
8568834
> > > > /lib64/ld-2.9.so
> > > > lsof      15098  goldadmin  mem       REG      8,2   256444 476399
> > > > /usr/lib/locale/en_US.utf8/LC_CTYPE
> > > > lsof      15098  goldadmin  mem       REG      8,2    26050 476168
> > > > /usr/lib64/gconv/gconv-modules.cache
> > > > lsof      15098  goldadmin    0u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > lsof      15098  goldadmin    1w     FIFO      0,7      0t0 
> > 12654992 pipe
> > > > lsof      15098  goldadmin    2u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > lsof      15098  goldadmin    3r      DIR      0,3        0 1
> > > > /proc
> > > > lsof      15098  goldadmin    4r      DIR      0,3        0 
12654996
> > > > /proc/15098/fd
> > > > lsof      15098  goldadmin    5w     FIFO      0,7      0t0 
> > 12655000 pipe
> > > > lsof      15098  goldadmin    6r     FIFO      0,7      0t0 
> > 12655001 pipe
> > > > grep      15099  goldadmin  cwd       DIR      8,2     4096 41874
> > > > /opt/gold/etc
> > > > grep      15099  goldadmin  rtd       DIR      8,2     4096 2 /
> > > > grep      15099  goldadmin  txt       REG      8,2   245152 
1777693
> > > > /bin/grep
> > > > grep      15099  goldadmin  mem       REG      8,2  1400360 
8568841
> > > > /lib64/libc-2.9.so
> > > > grep      15099  goldadmin  mem       REG      8,2   127672 
8568834
> > > > /lib64/ld-2.9.so
> > > > grep      15099  goldadmin  mem       REG      8,2   256444 476399
> > > > /usr/lib/locale/en_US.utf8/LC_CTYPE
> > > > grep      15099  goldadmin  mem       REG      8,2   952254 476400
> > > > /usr/lib/locale/en_US.utf8/LC_COLLATE
> > > > grep      15099  goldadmin  mem       REG      8,2       54 476381
> > > > /usr/lib/locale/en_US.utf8/LC_NUMERIC
> > > > grep      15099  goldadmin  mem       REG      8,2     2454 467301
> > > > /usr/lib/locale/en_US.utf8/LC_TIME
> > > > grep      15099  goldadmin  mem       REG      8,2      286 467300
> > > > /usr/lib/locale/en_US.utf8/LC_MONETARY
> > > > grep      15099  goldadmin  mem       REG      8,2       52 476374
> > > > /usr/lib/locale/en_US.utf8/LC_MESSAGES/SYS_LC_MESSAGES
> > > > grep      15099  goldadmin  mem       REG      8,2       34 476311
> > > > /usr/lib/locale/en_US.utf8/LC_PAPER
> > > > grep      15099  goldadmin  mem       REG      8,2       77 476324
> > > > /usr/lib/locale/en_US.utf8/LC_NAME
> > > > grep      15099  goldadmin  mem       REG      8,2      155 467297
> > > > /usr/lib/locale/en_US.utf8/LC_ADDRESS
> > > > grep      15099  goldadmin  mem       REG      8,2       59 476290
> > > > /usr/lib/locale/en_US.utf8/LC_TELEPHONE
> > > > grep      15099  goldadmin  mem       REG      8,2       23 476312
> > > > /usr/lib/locale/en_US.utf8/LC_MEASUREMENT
> > > > grep      15099  goldadmin  mem       REG      8,2    26050 476168
> > > > /usr/lib64/gconv/gconv-modules.cache
> > > > grep      15099  goldadmin  mem       REG      8,2      373 467298
> > > > /usr/lib/locale/en_US.utf8/LC_IDENTIFICATION
> > > > grep      15099  goldadmin    0r     FIFO      0,7      0t0 
> > 12654992 pipe
> > > > grep      15099  goldadmin    1u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > grep      15099  goldadmin    2u      CHR    136,1      0t0 3
> > > > /dev/pts/1
> > > > lsof      15100  goldadmin  cwd       DIR      8,2     4096 41874
> > > > /opt/gold/etc
> > > > lsof      15100  goldadmin  rtd       DIR      8,2     4096 2 /
> > > > lsof      15100  goldadmin  txt       REG      8,2   127416 364531
> > > > /usr/bin/lsof
> > > > lsof      15100  goldadmin  mem       REG      8,2    14872 
8568847
> > > > /lib64/libdl-2.9.so
> > > > lsof      15100  goldadmin  mem       REG      8,2  1400360 
8568841
> > > > /lib64/libc-2.9.so
> > > > lsof      15100  goldadmin  mem       REG      8,2   113904 
8568931
> > > > /lib64/libselinux.so.1
> > > > lsof      15100  goldadmin  mem       REG      8,2   127672 
8568834
> > > > /lib64/ld-2.9.so
> > > > lsof      15100  goldadmin  mem       REG      8,2   256444 476399
> > > > /usr/lib/locale/en_US.utf8/LC_CTYPE
> > > > lsof      15100  goldadmin  mem       REG      8,2    26050 476168
> > > > /usr/lib64/gconv/gconv-modules.cache
> > > > lsof      15100  goldadmin    4r     FIFO      0,7      0t0 
> > 12655000 pipe
> > > > lsof      15100  goldadmin    7w     FIFO      0,7      0t0 
> > 12655001 pipe
> > > > >
> > > > >
> > > > > I am looking for rogue processes which might be holding onto
> > > > > locks/transactions in the database.
> > > > >
> > > > > Next, I would try to run what it is trying to run manually:
> > > > >
> > > > > psql gold
> > > > >
> > > > > gold> UPDATE g_key_generator set g_next_id=g_next_id+1 WHERE
> > > > > g_name='Request';
> > > > gold=# UPDATE g_key_generator set g_next_id=g_next_id+1 WHERE
> > > > gold-# g_name='Request';
> > > > UPDATE 1
> > > > > gold> SELECT g_next_id-1 FROM g_key_generator WHERE 
> > g_name='Request';
> > > > >
> > > > > and see what kind of response you get.
> > > > gold=# SELECT g_next_id-1 FROM g_key_generator WHERE 
g_name='Request';
> > > >  ?column?
> > > > ----------
> > > >       272
> > > > (1 row)
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Scott
> > > > >
> > > > >
> > > > >
> > > > > RNothdurft at spirit21.de wrote:
> > > > > > Hi Scott,
> > > > > >
> > > > > > thanks for your reply. Followed the steps below, but the 
problem
> > > > still
> > > > > > exists.
> > > > > >
> > > > > > Kind regards,
> > > > > > Richard
> > > > > >
> > > > > >
> > > > > > Richard Nothdurft
> > > > > > DHBW-Student der SPIRIT/21 AG
> > > > > > Otto-Lilienthal-Str. 36, 71034 Böblingen
> > > > > > Mobil: 0177/7427024
> > > > > > E-Mail: rnothdurft at spirit21.de
> > > > > > Internet: http://www.spirit21.de <http://www.spirit21.de/> 
> > <http://www.spirit21.de/>
> > > > <http://www.spirit21.de/>
> > > > > >
> > > > > >
> > > > > >
> > > > > > *Scott Jackson <scottmo at adaptivecomputing.com>*
> > > > > > Gesendet von: gold-users-bounces at supercluster.org
> > > > > >
> > > > > > 26.07.2010 17:36
> > > > > > Bitte antworten an
> > > > > > Gold Users Mailing List <gold-users at supercluster.org>
> > > > > >
> > > > > >
> > > > > > 
> > > > > > An
> > > > > >    Gold Users Mailing List <gold-users at supercluster.org>
> > > > > > Kopie
> > > > > > 
> > > > > > Thema
> > > > > >    Re: [gold-users] Command line client failure: "Failed 
receiving
> > > > > > reply: (No HTTP header returned by server.)."
> > > > > >
> > > > > >
> > > > > >
> > > > > > 
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Hi Richard,
> > > > > >
> > > > > > Just getting back from vacation. I've mostly seen this when
> > > > someone has
> > > > > > run the bootstrap command more than once, thereby creating 
> > multiple
> > > > > > entries in the g_key_generator table. My suggested plan of 
attack
> > > > would
> > > > > > be to drop the db, create it again as the gold user, then 
> > bootstrap it
> > > > > > again (as the gold user). Then restart goldd. Let me know if 
> > that does
> > > > > > not fix the problem.
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Scott
> > > > > >
> > > > > > RNothdurft at spirit21.de wrote:
> > > > > > > Hi,
> > > > > > >
> > > > > > > i've run into a problem with a new gold installation. After
> > > > > > > installing, configuring and starting gold, all command line 
> > clients
> > > > > > > are responding with:
> > > > > > > "Failed receiving reply: (No HTTP header returned by 
server.)."
> > > > > > >
> > > > > > > As you can see in the server log below, gold seems to fail
> > > > generating
> > > > > > > a new request id. I checked the permissions in postgreSQL 
db,
> > > > but they
> > > > > > > are ok.
> > > > > > >
> > > > > > > Any suggestions?
> > > > > > >
> > > > > > > Kind regards,
> > > > > > > Richard
> > > > > > >
> > > > > > > #########
> > > > > > > gold.log:
> > > > > > > #########
> > > > > > > 2010-07-21 12:04:27 INFO  Gold::BEGIN  /opt/gold/bin/glsuser 

> > (PID
> > > > > > > 4898) Started *******************************************
> > > > > > > 2010-07-21 12:04:27 INFO  main::  Built request: (Query, 
root,
> > > > [(User,
> > > > > > > , )], [(Name, Sort, , ), (Name, , , ), (Active, , , ),
> > > > (CommonName, ,
> > > > > > > , ), (PhoneNumber, , , ), (EmailAddress, , , ), 
> > (DefaultProject, , ,
> > > > > > > ), (Description, , , )], [], [(Special, False, , , , , )], 
[],
> > > > [], 0,
> > > > > > > 0, 0, )
> > > > > > > 2010-07-21 12:04:27 INFO  Gold::Message::sendChunk  Writing 
> > message
> > > > > > > payload (598, <?xml version="1.0" encoding="UTF-8"?>
> > > > > > > <Envelope><Body><Request action="Query"
> > > > > > > actor="root"><Object>User</Object><Get name="Name"
> > > > > > > op="Sort"></Get><Get name="Name"></Get><Get 
> > name="Active"></Get><Get
> > > > > > > name="CommonName"></Get><Get name="PhoneNumber"></Get><Get
> > > > > > > name="EmailAddress"></Get><Get 
name="DefaultProject"></Get><Get
> > > > > > > name="Description"></Get><Where
> > > > > > >
> > > > > > name="Special">False</Where></Request></
> > > > > Body><Signature><DigestValue>Z3jUt/NMs8TtDXuaV+H2dhnrfK8=</
> > > > > DigestValue><SignatureValue>HuHzdcp/zZkvCB0yZRGfcovkeGE=</
> > > > > SignatureValue><SecurityToken
> > > > > >
> > > > > > > type="Symmetric"></SecurityToken></Signature></Envelope>
> > > > > > > ).
> > > > > > > 2010-07-21 12:04:27 ERROR Gold::Exception::new  No HTTP 
header
> > > > > > > returned by server. at /opt/gold/lib/Gold/Reply.pm line 340
> > > > > > > 2010-07-21 12:04:27 ERROR Gold::Chunk::__ANON__  Failed 
> > receiving
> > > > > > > reply (No HTTP header returned by server.).
> > > > > > > 2010-07-21 12:04:27 INFO  main::  /opt/gold/bin/glsuser (PID 

> > 4898)
> > > > > > > Exiting with status code (246)
> > > > > > >
> > > > > > > ###########
> > > > > > > goldd.log:
> > > > > > > ###########
> > > > > > > 2010-07-21 12:04:27.342 INFO  main::  New Connection 
Received
> > > > > > > 2010-07-21 12:04:27.344 TRACE Gold::Message::new  invoked 
with
> > > > > > > arguments: (connection => IO::Socket::INET=GLOB(0x23a0ad8))
> > > > > > > 2010-07-21 12:04:27.344 TRACE Gold::Message::receiveChunk 
> >  invoked
> > > > > > > with arguments: ()
> > > > > > > 2010-07-21 12:04:27.345 DEBUG Gold::Message::receiveChunk 
Read
> > > > > > > message header (POST /SSSRMAP3 HTTP/1.1
> > > > > > > Content-Type: text/xml; charset="utf-8"
> > > > > > > Transfer-Encoding: chunked
> > > > > > >
> > > > > > > ).
> > > > > > > 2010-07-21 12:04:27.345 INFO  Gold::Message::receiveChunk 
Read
> > > > > > > message payload (598, <?xml version="1.0" encoding="UTF-8"?>
> > > > > > > <Envelope><Body><Request action="Query"
> > > > > > > actor="root"><Object>User</Object><Get name="Name"
> > > > > > > op="Sort"></Get><Get name="Name"></Get><Get 
> > name="Active"></Get><Get
> > > > > > > name="CommonName"></Get><Get name="PhoneNumber"></Get><Get
> > > > > > > name="EmailAddress"></Get><Get 
name="DefaultProject"></Get><Get
> > > > > > > name="Description"></Get><Where
> > > > > > >
> > > > > > name="Special">False</Where></Request></
> > > > > Body><Signature><DigestValue>Z3jUt/NMs8TtDXuaV+H2dhnrfK8=</
> > > > > DigestValue><SignatureValue>HuHzdcp/zZkvCB0yZRGfcovkeGE=</
> > > > > SignatureValue><SecurityToken
> > > > > >
> > > > > > > type="Symmetric"></SecurityToken></Signature></Envelope>
> > > > > > > ).
> > > > > > > 2010-07-21 12:04:27.346 TRACE Gold::Message::unmarshallChunk
> > > >  invoked
> > > > > > > with arguments: (<?xml version="1.0" encoding="UTF-8"?>
> > > > > > > <Envelope><Body><Request action="Query"
> > > > > > > actor="root"><Object>User</Object><Get name="Name"
> > > > > > > op="Sort"></Get><Get name="Name"></Get><Get 
> > name="Active"></Get><Get
> > > > > > > name="CommonName"></Get><Get name="PhoneNumber"></Get><Get
> > > > > > > name="EmailAddress"></Get><Get 
name="DefaultProject"></Get><Get
> > > > > > > name="Description"></Get><Where
> > > > > > >
> > > > > > name="Special">False</Where></Request></
> > > > > Body><Signature><DigestValue>Z3jUt/NMs8TtDXuaV+H2dhnrfK8=</
> > > > > DigestValue><SignatureValue>HuHzdcp/zZkvCB0yZRGfcovkeGE=</
> > > > > SignatureValue><SecurityToken
> > > > > >
> > > > > > > type="Symmetric"></SecurityToken></Signature></Envelope>
> > > > > > > )
> > > > > > > 2010-07-21 12:04:27.347 TRACE Gold::Chunk::authenticate 
> >  invoked
> > > > with
> > > > > > > arguments: (XML::LibXML::Document=SCALAR(0x2383bd8))
> > > > > > > 2010-07-21 12:04:27.348 DEBUG Gold::Chunk::authenticate  The
> > > > security
> > > > > > > token type is (Symmetric).
> > > > > > > 2010-07-21 12:04:27.348 DEBUG Gold::Chunk::authenticate  The
> > > > > > > canonicalized body text is (<Body><Request action="Query"
> > > > > > > actor="root"><Object>User</Object><Get name="Name"
> > > > > > > op="Sort"></Get><Get name="Name"></Get><Get 
> > name="Active"></Get><Get
> > > > > > > name="CommonName"></Get><Get name="PhoneNumber"></Get><Get
> > > > > > > name="EmailAddress"></Get><Get 
name="DefaultProject"></Get><Get
> > > > > > > name="Description"></Get><Where
> > > > > > > name="Special">False</Where></Request></Body>).
> > > > > > > 2010-07-21 12:04:27.348 DEBUG Gold::Chunk::authenticate  The
> > > > > > > base64-encoded message digest is 
(Z3jUt/NMs8TtDXuaV+H2dhnrfK8=).
> > > > > > > 2010-07-21 12:04:27.349 DEBUG Gold::Chunk::authenticate  The
> > > > > > > base64-encoded MAC is (HuHzdcp/zZkvCB0yZRGfcovkeGE=).
> > > > > > > 2010-07-21 12:04:27.349 TRACE Gold::Request::new  invoked 
with
> > > > > > > arguments: ()
> > > > > > > 2010-07-21 12:04:27.351 DEBUG Gold::Message::unmarshallChunk
> > > > > > >  Extracted the request ((Query, root, [(User, , )], [(Name,
> > > > Sort, , ),
> > > > > > > (Name, , , ), (Active, , , ), (CommonName, , , ), 
(PhoneNumber,
> > > > , , ),
> > > > > > > (EmailAddress, , , ), (DefaultProject, , , ), (Description, 
> > , , )],
> > > > > > > [], [(Special, False, , , , , )], [], [], 0, 0, 100000, )).
> > > > > > > 2010-07-21 12:04:27.351 DEBUG Gold::Message::receiveChunk 
Read
> > > > > > > message tail (0).
> > > > > > > 2010-07-21 12:04:27.352 TRACE Gold::Proxy::new  invoked with
> > > > > > > arguments: (request => Gold::Request=HASH(0x23920b0))
> > > > > > > 2010-07-21 12:04:27.352 TRACE Gold::Database::new  invoked 
with
> > > > > > > arguments: ()
> > > > > > > 2010-07-21 12:04:27.356 TRACE Gold::Database::nextId 
> >  invoked with
> > > > > > > arguments: (Request)
> > > > > > > <end of log>
> > > > > > >
> > > > > > >
> > > > > > > Richard Nothdurft
> > > > > > > DHBW-Student der SPIRIT/21 AG
> > > > > > > Otto-Lilienthal-Str. 36, 71034 Böblingen
> > > > > > > Mobil: 0177/7427024
> > > > > > > E-Mail: rnothdurft at spirit21.de
> > > > > > > Internet: http://www.spirit21.de <http://www.spirit21.de/> 
> > <http://www.spirit21.de/>
> > > > <http://www.spirit21.de/>
> >
> >
> >
> > SPIRIT/21 AG
> >
> > Sitz der Gesellschaft: Böblingen
> > Vorstand: Dietmar Wendt (Vorsitzender), Philipp Steffen, Joachim 
Gutheil
> > Vorsitzender des Aufsichtsrates: Siegfried J. Althaus
> > Registergericht: Amtsgericht Stuttgart, Registernummer: HRB 244681
> > Umsatzsteuer-Identifikationsnummer: DE 198412560
> > 
------------------------------------------------------------------------
> >
> > _______________________________________________
> > gold-users mailing list
> > gold-users at supercluster.org
> > http://www.supercluster.org/mailman/listinfo/gold-users
> > 
> _______________________________________________
> gold-users mailing list
> gold-users at supercluster.org
> http://www.supercluster.org/mailman/listinfo/gold-users


SPIRIT/21 AG

Sitz der Gesellschaft: Böblingen
Vorstand: Dietmar Wendt (Vorsitzender), Philipp Steffen, Joachim Gutheil
Vorsitzender des Aufsichtsrates: Siegfried J. Althaus
Registergericht: Amtsgericht Stuttgart, Registernummer: HRB 244681
Umsatzsteuer-Identifikationsnummer: DE 198412560
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.supercluster.org/pipermail/gold-users/attachments/20100728/86abd9e5/attachment-0001.html 


More information about the gold-users mailing list