Обсуждение: 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: <br /><div style="margin-left: 40px;">ERROR: could not access file "$libdir/admin81": No such
fileor directory"<br /></div><br />However, it did not crash PgAdmin and the server Status window stayed up and show
recordsin the Activity portion<br /><br />I am running pgAdmin3 ver.1.10.0 (Jun 29 2009, rev.7942:7943M) under windows
XP<br/><br /><div class="gmail_quote">On Fri, Jul 3, 2009 at 12:36 PM, Pedro Doria Meunier <span dir="ltr"><<a
href="mailto:pdoria@netmadeira.com">pdoria@netmadeira.com</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">-----BEGIN PGP SIGNED
MESSAGE-----<br/> Hash: SHA1<br /><br /> Hi,<br /><br /> pgAdmin3 ver.1.10.0 rev.7945:7946<br /><br /> Bombs out with a
segmentationfault when trying to view 'Tools->Server<br /> Status'<br /><br /> BR,<br /><br /> - --<br /> Pedro
DoriaMeunier<br /> GSM: +351 96 17 20 188<br /> Skype: pdoriam<br /><br /> -----BEGIN PGP SIGNATURE-----<br /> Version:
GnuPGv1.4.7 (GNU/Linux)<br /> Comment: Using GnuPG with Fedora - <a href="http://enigmail.mozdev.org"
target="_blank">http://enigmail.mozdev.org</a><br/><br />
iD8DBQFKTkGU2FH5GXCfxAsRAqbeAJwPEk1d0VRLxfghnZcZZFuB/njIzACfUPJ+<br/> iL/A/UlqWwr+U9YWZVUI5qE=<br /> =te/J<br />
-----ENDPGP SIGNATURE-----<br /><font color="#888888"><br /><br /> --<br /> Sent via pgadmin-support mailing list (<a
href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></font></blockquote></div><br /> 

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

I have no idea. Would this be part of the postgres server or part of PgAdmin?<br /><br /><div class="gmail_quote">On
Tue,Jul 7, 2009 at 4:02 PM, Guillaume Lelarge <span dir="ltr"><<a
href="mailto:guillaume@lelarge.info">guillaume@lelarge.info</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Le vendredi 3 juillet
2009à 20:29:50, Michael Shapiro a écrit :<br /> > It failed for me as well:<br /> > ERROR: could not access file
"$libdir/admin81":No such file or directory"<br /> ><br /> > However, it did not crash PgAdmin and the server
Statuswindow stayed up<br /> > and show records in the Activity portion<br /> ><br /> > I am running pgAdmin3
ver.1.10.0(Jun 29 2009, rev.7942:7943M) under<br /> > windows XP<br /> ><br /><br /> Do you have the adminpack
installed?<br/><font color="#888888"><br /><br /> --<br /> Guillaume.<br />  <a href="http://www.postgresqlfr.org"
target="_blank">http://www.postgresqlfr.org</a><br/>  <a href="http://dalibo.com"
target="_blank">http://dalibo.com</a><br/></font></blockquote></div><br /> 

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.orghttp://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
returns 1

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.orghttp://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.orghttp://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   

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:


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

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.orghttp://dalibo.com

No, I don't. I think they figure this isn't worth their time to investigate ....<br /><br /><div class="gmail_quote">On
Mon,Jul 13, 2009 at 10:15 AM, Guillaume Lelarge <span dir="ltr"><<a
href="mailto:guillaume@lelarge.info">guillaume@lelarge.info</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Le mercredi 8 juillet
2009à 22:59:27, Michael Shapiro a écrit :<br /> > I don't think this is really a PgAdmin problem. PgAdmin is running
the<br/> > postgres function pg_logdir_ls()<br /> > which is defined (on my server) as:<br /> ><br /> >
CREATEOR REPLACE FUNCTION pg_logdir_ls()<br /> >   RETURNS SETOF record AS<br /> > '$libdir/admin81',
'pg_logdir_ls'<br/> >   LANGUAGE 'c' VOLATILE STRICT;<br /> ><br /> > So there is some interaction between the
Cfunction and the system<br /> > involving $libdir/admin81.<br /> > Since I don't understand where this function
camefrom (if it isn't part of<br /> > the server), or why it is looking for admin81<br /> > I will ask the admin
ofthe server to look into this ...<br /> ><br /><br /> Do you have some news from the admin?<br /><br /> Thanks.<br
/><fontcolor="#888888"><br /><br /> --<br /> Guillaume.<br />  <a href="http://www.postgresqlfr.org"
target="_blank">http://www.postgresqlfr.org</a><br/>  <a href="http://dalibo.com"
target="_blank">http://dalibo.com</a><br/></font></blockquote></div><br />