Re: Segmentation fault

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

pgAdmin3 ver.1.10.0 rev.7945:7946

Bombs out with a segmentation fault when trying to view 'Tools->Server
Status'

BR,

- --
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKTkGU2FH5GXCfxAsRAqbeAJwPEk1d0VRLxfghnZcZZFuB/njIzACfUPJ+
iL/A/UlqWwr+U9YWZVUI5qE=
=te/J
-----END PGP SIGNATURE-----

It failed for me as well:
ERROR: could not access file "$libdir/admin81": No such file or directory"

However, it did not crash PgAdmin and the server Status window stayed up and
show records in the Activity portion

I am running pgAdmin3 ver.1.10.0 (Jun 29 2009, rev.7942:7943M) under windows
XP

On Fri, Jul 3, 2009 at 12:36 PM, Pedro Doria Meunier
<pdoria(at)netmadeira(dot)com>wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> pgAdmin3 ver.1.10.0 rev.7945:7946
>
> Bombs out with a segmentation fault when trying to view 'Tools->Server
> Status'
>
> BR,
>
> - --
> Pedro Doria Meunier
> GSM: +351 96 17 20 188
> Skype: pdoriam
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
>
> iD8DBQFKTkGU2FH5GXCfxAsRAqbeAJwPEk1d0VRLxfghnZcZZFuB/njIzACfUPJ+
> iL/A/UlqWwr+U9YWZVUI5qE=
> =te/J
> -----END PGP SIGNATURE-----
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>

On Fri, Jul 3, 2009 at 6:36 PM, Pedro Doria
Meunier<pdoria(at)netmadeira(dot)com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> pgAdmin3 ver.1.10.0 rev.7945:7946
>
> Bombs out with a segmentation fault when trying to view 'Tools->Server
> Status'

What server and version? Is the admin pack installed?

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Dave,

Postgresql 8.3.7 on remote server x64.
Client pc: 32bits
Admin pack installed.

BR,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Dave Page wrote:
> On Fri, Jul 3, 2009 at 6:36 PM, Pedro Doria
> Meunier<pdoria(at)netmadeira(dot)com> wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Hi,
>>
>> pgAdmin3 ver.1.10.0 rev.7945:7946
>>
>> Bombs out with a segmentation fault when trying to view 'Tools->Server
>> Status'
>
> What server and version? Is the admin pack installed?
>
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKUhK82FH5GXCfxAsRAmIDAJ9Np4vIKkdF/jKRaMAkbIRCBtVqjACfVr8+
RJWrtuvloJIjh4YAIZjvQLw=
=6IwP
-----END PGP SIGNATURE-----

On Mon, Jul 6, 2009 at 4:05 PM, Pedro Doria
Meunier<pdoria(at)netmadeira(dot)com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Dave,
>
> Postgresql 8.3.7 on remote server x64.
> Client pc: 32bits
> Admin pack installed.

Sorry - what OS is the client?

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Fedora 8 32 bits

from uname -a
Linux c3po 2.6.26.8-57.fc8 #1 SMP Thu Dec 18 19:19:45 EST 2008 i686
i686 i386 GNU/Linux

BR,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Dave Page wrote:
> On Mon, Jul 6, 2009 at 4:05 PM, Pedro Doria
> Meunier<pdoria(at)netmadeira(dot)com> wrote:
>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
>>
>> Hi Dave,
>>
>> Postgresql 8.3.7 on remote server x64. Client pc: 32bits Admin
>> pack installed.
>
> Sorry - what OS is the client?
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKUkmW2FH5GXCfxAsRAjV2AJ9MUyyYYOpQu4U5NFuegurz5x9KUACcDXSf
hRVDNUuZmSisX212ur+gDqA=
=V6r6
-----END PGP SIGNATURE-----

On Mon, Jul 6, 2009 at 7:59 PM, Pedro Doria
Meunier<pdoria(at)netmadeira(dot)com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Fedora 8 32 bits
>
> from uname -a
> Linux c3po 2.6.26.8-57.fc8 #1 SMP Thu Dec 18 19:19:45 EST 2008 i686
> i686 i386 GNU/Linux

Seems to work OK here, albeit on CentOS. Can you rebuild with
debugging and get a backtrace?

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

Le vendredi 3 juillet 2009 à 20:29:50, Michael Shapiro a écrit :
> It failed for me as well:
> ERROR: could not access file "$libdir/admin81": No such file or directory"
>
> However, it did not crash PgAdmin and the server Status window stayed up
> and show records in the Activity portion
>
> I am running pgAdmin3 ver.1.10.0 (Jun 29 2009, rev.7942:7943M) under
> windows XP
>

Do you have the adminpack installed?

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

I have no idea. Would this be part of the postgres server or part of
PgAdmin?

On Tue, Jul 7, 2009 at 4:02 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>wrote:

> Le vendredi 3 juillet 2009 à 20:29:50, Michael Shapiro a écrit :
> > It failed for me as well:
> > ERROR: could not access file "$libdir/admin81": No such file or
> directory"
> >
> > However, it did not crash PgAdmin and the server Status window stayed up
> > and show records in the Activity portion
> >
> > I am running pgAdmin3 ver.1.10.0 (Jun 29 2009, rev.7942:7943M) under
> > windows XP
> >
>
> Do you have the adminpack installed?
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>

Le mardi 7 juillet 2009 à 23:47:18, Michael Shapiro a écrit :
> I have no idea. Would this be part of the postgres server or part of
> PgAdmin?
>

The adminpack is a contrib module. You need to install it on the server for
pgAdmin to use it. It adds a few functions, like pg_file_write that pgAdmin
needs to be able to write on the config file.

To check if you have this module installed, the simplest thing to do is to
check if pg_file_write function exists. The SQL query should tell you how many
pg_file_write() function you have:

select count(*) from pg_proc where proname='pg_file_write';

0 meaning that you don't have this function.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Michael,

you install the admin pack like this:

psql yourdatabase < /usr/share/pgsql/contrib/ adminpack.sql

As for me running the below select returns "1".

As per David suggestion, i.e. building pgadmin3 with debug support,
I'm afraid that my wxWidgets aren't compiled with it and now it's not
the best time to mess up my WS in order to take all the steps to make
it so. Sorry...

BR,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Guillaume Lelarge wrote:
> Le mardi 7 juillet 2009 à 23:47:18, Michael Shapiro a écrit :
>> I have no idea. Would this be part of the postgres server or part of
>> PgAdmin?
>>
>
> The adminpack is a contrib module. You need to install it on the server
for
> pgAdmin to use it. It adds a few functions, like pg_file_write that
pgAdmin
> needs to be able to write on the config file.
>
> To check if you have this module installed, the simplest thing to do is to
> check if pg_file_write function exists. The SQL query should tell you
how many
> pg_file_write() function you have:
>
> select count(*) from pg_proc where proname='pg_file_write';
>
> 0 meaning that you don't have this function.
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKVGGa2FH5GXCfxAsRApRLAJ9xppDFTX8N3xUenlouCpdDIzdvowCgvUOP
obYYZXWfA9m18jL2mE0oh84=
=CM9T
-----END PGP SIGNATURE-----

The query
select count(*) from pg_proc where proname='pg_file_write';
returns 1

On Wed, Jul 8, 2009 at 1:42 AM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>wrote:

> Le mardi 7 juillet 2009 à 23:47:18, Michael Shapiro a écrit :
> > I have no idea. Would this be part of the postgres server or part of
> > PgAdmin?
> >
>
> The adminpack is a contrib module. You need to install it on the server for
> pgAdmin to use it. It adds a few functions, like pg_file_write that pgAdmin
> needs to be able to write on the config file.
>
> To check if you have this module installed, the simplest thing to do is to
> check if pg_file_write function exists. The SQL query should tell you how
> many
> pg_file_write() function you have:
>
> select count(*) from pg_proc where proname='pg_file_write';
>
> 0 meaning that you don't have this function.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>

Le mercredi 8 juillet 2009 à 16:09:15, Michael Shapiro a écrit :
> The query
> select count(*) from pg_proc where proname='pg_file_write';
> returns 1
>

Which release of PostgreSQL are you using? Did you change it? (I'm thinking
about a 8.1 to something upgrade). Because the error message says you don't
have $libdir/admin81.so (or .dll on Windows) installed ont your server. I see
two ways to get such an error: someone removed or renamed $libdir/admin81.so
or someone upgraded the PostgreSQL server.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

Le mercredi 8 juillet 2009 à 11:06:43, Pedro Doria Meunier a écrit :
> [...]
> As for me running the below select returns "1".
>

Can you check if you still have the error without the adminpack?

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes I do.

BR,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Guillaume Lelarge wrote:
> Le mercredi 8 juillet 2009 à 11:06:43, Pedro Doria Meunier a écrit
> :
>> [...] As for me running the below select returns "1".
>>
>
> Can you check if you still have the error without the adminpack?
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKVQMP2FH5GXCfxAsRArRVAKCAULEoNkv+iVaHGajGddGflixssQCeIpAq
dd+Z/6xbugAse18Ro9Gltqc=
=0Ljx
-----END PGP SIGNATURE-----

PostgreSQL 8.1.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-58)

I am not the admin that installs or runs the server. This server (and the
others below) are at another institution.

NOTE: I have access other servers which do not cause this particular
problem, but have other errors:

PostgreSQL 8.1.11 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-59)
select count(*) from pg_proc where proname='pg_file_write'; returns 0
the scroll bar on the logfile pane doesn't respond to mouse movement:
Logfile pane message: Logs are not available for this server

PostgreSQL 8.1.11 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-59)
select count(*) from pg_proc where proname='pg_file_write'; returns 1
error: /dbms/postgresql/db/dtftest/pg_log is not browsable: No such file
or directory
the scroll bar on the logile file pane works fine and has a log entry in
it:
redirect_stderr not enabled or log_filename misconfigured

On Wed, Jul 8, 2009 at 3:04 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>wrote:

> Le mercredi 8 juillet 2009 à 16:09:15, Michael Shapiro a écrit :
> > The query
> > select count(*) from pg_proc where proname='pg_file_write';
> > returns 1
> >
>
> Which release of PostgreSQL are you using? Did you change it? (I'm thinking
> about a 8.1 to something upgrade). Because the error message says you don't
> have $libdir/admin81.so (or .dll on Windows) installed on your server. I
> see
> two ways to get such an error: someone removed or renamed
> $libdir/admin81.so
> or someone upgraded the PostgreSQL server.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>

I don't think this is really a PgAdmin problem. PgAdmin is running the
postgres function pg_logdir_ls()
which is defined (on my server) as:

CREATE OR REPLACE FUNCTION pg_logdir_ls()
RETURNS SETOF record AS
'$libdir/admin81', 'pg_logdir_ls'
LANGUAGE 'c' VOLATILE STRICT;

So there is some interaction between the C function and the system involving
$libdir/admin81.
Since I don't understand where this function came from (if it isn't part of
the server), or why it is looking for admin81
I will ask the admin of the server to look into this ...

On Wed, Jul 8, 2009 at 3:45 PM, Michael Shapiro <mshapiro51(at)gmail(dot)com>wrote:

> PostgreSQL 8.1.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
> 20030502 (Red Hat Linux 3.2.3-58)
>
> I am not the admin that installs or runs the server. This server (and the
> others below) are at another institution.
>
>
>
>
>
>
> On Wed, Jul 8, 2009 at 3:04 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>wrote:
>
>> Le mercredi 8 juillet 2009 à 16:09:15, Michael Shapiro a écrit :
>> > The query
>> > select count(*) from pg_proc where proname='pg_file_write';
>> > returns 1
>> >
>>
>> Which release of PostgreSQL are you using? Did you change it? (I'm
>> thinking
>> about a 8.1 to something upgrade). Because the error message says you
>> don't
>> have $libdir/admin81.so (or .dll on Windows) installed on your server. I
>> see
>> two ways to get such an error: someone removed or renamed
>> $libdir/admin81.so
>> or someone upgraded the PostgreSQL server.
>>
>>
>> --
>> Guillaume.
>> http://www.postgresqlfr.org
>> http://dalibo.com
>>
>
>

Le mercredi 8 juillet 2009 à 22:59:27, Michael Shapiro a écrit :
> I don't think this is really a PgAdmin problem. PgAdmin is running the
> postgres function pg_logdir_ls()
> which is defined (on my server) as:
>
> CREATE OR REPLACE FUNCTION pg_logdir_ls()
> RETURNS SETOF record AS
> '$libdir/admin81', 'pg_logdir_ls'
> LANGUAGE 'c' VOLATILE STRICT;
>
> So there is some interaction between the C function and the system
> involving $libdir/admin81.
> Since I don't understand where this function came from (if it isn't part of
> the server), or why it is looking for admin81
> I will ask the admin of the server to look into this ...
>

Do you have some news from the admin?

Thanks.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

No, I don't. I think they figure this isn't worth their time to investigate
....

On Mon, Jul 13, 2009 at 10:15 AM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>wrote:

> Le mercredi 8 juillet 2009 à 22:59:27, Michael Shapiro a écrit :
> > I don't think this is really a PgAdmin problem. PgAdmin is running the
> > postgres function pg_logdir_ls()
> > which is defined (on my server) as:
> >
> > CREATE OR REPLACE FUNCTION pg_logdir_ls()
> > RETURNS SETOF record AS
> > '$libdir/admin81', 'pg_logdir_ls'
> > LANGUAGE 'c' VOLATILE STRICT;
> >
> > So there is some interaction between the C function and the system
> > involving $libdir/admin81.
> > Since I don't understand where this function came from (if it isn't part
> of
> > the server), or why it is looking for admin81
> > I will ask the admin of the server to look into this ...
> >
>
> Do you have some news from the admin?
>
> Thanks.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>