Segmentation fault

[Pedro Doria Meunier]

-----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: [phone]
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@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Michael Shapiro-5]

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@...> 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: [phone]
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@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Dave Page-7]

On Fri, Jul 3, 2009 at 6:36 PM, Pedro Doria
Meunier<pdoria@...> 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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Pedro Doria Meunier]

-----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: [phone]
Skype: pdoriam
 



Dave Page wrote:

> On Fri, Jul 3, 2009 at 6:36 PM, Pedro Doria
> Meunier<pdoria@...> 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-----


--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Dave Page-7]

On Mon, Jul 6, 2009 at 4:05 PM, Pedro Doria
Meunier<pdoria@...> 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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Pedro Doria Meunier]

-----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: [phone]
Skype: pdoriam
 



Dave Page wrote:

> On Mon, Jul 6, 2009 at 4:05 PM, Pedro Doria
> Meunier<pdoria@...> 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-----


--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Dave Page-7]

On Mon, Jul 6, 2009 at 7:59 PM, Pedro Doria
Meunier<pdoria@...> 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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Guillaume Lelarge-3]

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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Michael Shapiro-5]

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@...> 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

[Guillaume Lelarge-3]

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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Pedro Doria Meunier]

-----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: [phone]
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-----


--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Michael Shapiro-5]

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@...> 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

[Guillaume Lelarge-3]

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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Guillaume Lelarge-3]

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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Pedro Doria Meunier]

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

Yes I do.

BR,

Pedro Doria Meunier
GSM: [phone]
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-----


--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Michael Shapiro-5]

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@...> 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

[Michael Shapiro-5]

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@...> 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@...> 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

[Guillaume Lelarge-3]

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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Michael Shapiro-5]

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@...> 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