Thread: Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

Hi there,
On opensuse 10.2 I installed postgresql and pgadmin from the distribution.
Postgresql 8.1.11
pgadmin3  1.6.3
Recently I found that pgadmin didn't work properly: It opened the connection 
to the server and to a particular database, I can see the data of the tables 
and views but when I tried to modify for example a view pgadmin shut 
completely. So I downloaded and installed the last version of pgadmin for my 
distribution but it's all the same. In order to be sure that there is no 
problem with the older configuration of pgadmin I moved the .pgadmin file so 
that pgadmin could create a new one. But with this pgadmin doesn't even 
connect to the server, the program shuts down directly. 
Starting pgadmin as a normal user in a console  I get the error message:
Speicherzugriffsfehler (Segmentation fault)
Doing the same as root I got the following messages:

*** glibc detected *** pgadmin3: munmap_chunk(): invalid pointer: 0x0906a270 
***
======= Backtrace: =========
/lib/libc.so.6[0xb73386e1]
/usr/lib/libglib-2.0.so.0(g_free+0x31)[0xb7775321]
pgadmin3[0x84fca0e]
pgadmin3[0x84fd09f]
pgadmin3[0x86868af]
pgadmin3[0x86175b6]
pgadmin3[0x861ab2b]
pgadmin3[0x861bde4]
pgadmin3[0x8690339]
pgadmin3[0x86175b6]
pgadmin3[0x861ab2b]
pgadmin3[0x861c0ac]
pgadmin3[0x80e3477]
pgadmin3[0x813f54e]
pgadmin3[0x8158a6b]
pgadmin3[0x82cc271]
pgadmin3[0x8187ca6]
pgadmin3[0x84a30bb]
pgadmin3[0x84a315e]
pgadmin3[0x84a4843]
pgadmin3[0x84a4801]
pgadmin3[0x8511790]
/usr/lib/libgobject-2.0.so.0(g_cclosure_marshal_VOID__VOID+0x49)[0xb7a49409]
/usr/lib/libgobject-2.0.so.0(g_closure_invoke+0x130)[0xb7a3c050]
/usr/lib/libgobject-2.0.so.0[0xb7a4c74f]
/usr/lib/libgobject-2.0.so.0(g_signal_emit_valist+0x8c7)[0xb7a4dc77]
/usr/lib/libgobject-2.0.so.0(g_signal_emit+0x29)[0xb7a4de39]
/usr/lib/libgtk-x11-2.0.so.0(gtk_widget_activate+0x58)[0xb7dc73d8]
/usr/lib/libgtk-x11-2.0.so.0(gtk_menu_shell_activate_item+0x14a)[0xb7cb12fa]
/usr/lib/libgtk-x11-2.0.so.0[0xb7cb2e98]
/usr/lib/libgtk-x11-2.0.so.0[0xb7caa098]
/usr/lib/libgtk-x11-2.0.so.0[0xb7ca410e]
/usr/lib/libgobject-2.0.so.0[0xb7a3a839]
/usr/lib/libgobject-2.0.so.0(g_closure_invoke+0x130)[0xb7a3c050]
/usr/lib/libgobject-2.0.so.0[0xb7a4cda5]
/usr/lib/libgobject-2.0.so.0(g_signal_emit_valist+0x68f)[0xb7a4da3f]
/usr/lib/libgobject-2.0.so.0(g_signal_emit+0x29)[0xb7a4de39]
/usr/lib/libgtk-x11-2.0.so.0[0xb7dc2868]
/usr/lib/libgtk-x11-2.0.so.0(gtk_propagate_event+0x14f)[0xb7c9d28f]
/usr/lib/libgtk-x11-2.0.so.0(gtk_main_do_event+0x307)[0xb7c9e4a7]
/usr/lib/libgdk-x11-2.0.so.0[0xb7b1d9da]
/usr/lib/libglib-2.0.so.0(g_main_context_dispatch+0x17c)[0xb776dc0c]
/usr/lib/libglib-2.0.so.0[0xb777103f]
/usr/lib/libglib-2.0.so.0(g_main_loop_run+0x1b7)[0xb77713f7]
/usr/lib/libgtk-x11-2.0.so.0(gtk_main+0xb4)[0xb7c9e904]
pgadmin3[0x864ddd0]
pgadmin3[0x852505d]
pgadmin3[0x846edbd]
pgadmin3[0x805e090]
/lib/libc.so.6(__libc_start_main+0xdc)[0xb72e9f9c]
pgadmin3[0x805de41]
======= Memory map: ========
08048000-08ad1000 r-xp 00000000 03:09 165940     /usr/bin/pgadmin3
08ad1000-08b37000 rw-p 00a88000 03:09 165940     /usr/bin/pgadmin3
08b37000-0917c000 rw-p 08b37000 00:00 0          [heap]
b33bd000-b33cf000 r-xp 00000000 03:06 8448       /lib/libnsl-2.5.so
b33cf000-b33d1000 rw-p 00011000 03:06 8448       /lib/libnsl-2.5.so
b33d1000-b33d3000 rw-p b33d1000 00:00 0
b33d3000-b33e3000 r-xp 00000000 03:06 8713       /lib/libbz2.so.1.0.0
b33e3000-b33e5000 rw-p 0000f000 03:06 8713       /lib/libbz2.so.1.0.0
b33e5000-b33e7000 r-xp 00000000 03:06 8471       /lib/libutil-2.5.so
b33e7000-b33e9000 rw-p 00001000 03:06 8471       /lib/libutil-2.5.so
b33e9000-b33f7000 r-xp 00000000 03:09 
93211      /usr/lib/libavahi-client.so.3.2.2
b33f7000-b33f9000 rw-p 0000d000 03:09 
93211      /usr/lib/libavahi-client.so.3.2.2
b33f9000-b3403000 r-xp 00000000 03:09 
162157     /usr/lib/libavahi-common.so.3.4.4
b3403000-b3405000 rw-p 00009000 03:09 
162157     /usr/lib/libavahi-common.so.3.4.4
b3405000-b3407000 r-xp 00000000 03:09 
60751      /usr/lib/libavahi-glib.so.1.0.1
b3407000-b3409000 rw-p 00001000 03:09 
60751      /usr/lib/libavahi-glib.so.1.0.1
b3409000-b343a000 r-xp 00000000 03:09 51206      /usr/lib/libdbus-1.so.3.2.0
b343a000-b343c000 rw-p 00030000 03:09 51206      /usr/lib/libdbus-1.so.3.2.0
b343c000-b3456000 r-xp 00000000 03:09 
54738      /usr/lib/libdbus-glib-1.so.2.1.0
b3456000-b3458000 rw-p 00019000 03:09 
54738      /usr/lib/libdbus-glib-1.so.2.1.0
b3458000-b358b000 r-xp 00000000 03:09 24442      /usr/lib/libxml2.so.2.6.30
b358b000-b358e000 r--p 00133000 03:09 24442      /usr/lib/libxml2.so.2.6.30
b358e000-b3591000 rw-p 00136000 03:09 24442      /usr/lib/libxml2.so.2.6.30
b3591000-b3592000 rw-p b3591000 00:00 0
b3592000-b35c3000 r-xp 00000000 03:09 
67708      /usr/lib/libcroco-0.6.so.3.0.1
b35c3000-b35c6000 rw-p 00030000 03:09 
67708      /usr/lib/libcroco-0.6.so.3.0.1
b35c6000-b35f3000 r-xp 00000000 03:09 76277      /usr/lib/libgsfAborted

I must confess that don't have any idea what this means. Therefore I would be 
very grateful for any hint about how to make pgadmin work.
Thanks in advance,
Michael

On Fri, Mar 7, 2008 at 11:14 AM, Michael Eschweiler
<Michael.Eschweiler@t-online.de> wrote:
> Hi there,
> On opensuse 10.2 I installed postgresql and pgadmin from the distribution.
> Postgresql 8.1.11
> pgadmin3  1.6.3
> Recently I found that pgadmin didn't work properly: It opened the connection
> to the server and to a particular database, I can see the data of the tables
> and views but when I tried to modify for example a view pgadmin shut
> completely. So I downloaded and installed the last version of pgadmin for my
> distribution but it's all the same. In order to be sure that there is no
> problem with the older configuration of pgadmin I moved the .pgadmin file so
> that pgadmin could create a new one. But with this pgadmin doesn't even
> connect to the server, the program shuts down directly.
> Starting pgadmin as a normal user in a console  I get the error message:
> Speicherzugriffsfehler (Segmentation fault)
> Doing the same as root I got the following messages:
>
> *** glibc detected *** pgadmin3: munmap_chunk(): invalid pointer: 0x0906a270

There were some changes made in GTK which are incompatible with builds
of pgAdmin against earlier versions. It sounds like you hit this bug
(which is currently known to affect Suse and Ubuntu). Try one of the
following to fix it:

- Run pgAdmin from the command line, with a command like:
G_SLICE=always-malloc pgadmin3 &

If that works, you can write a small shell script to do it, and point
your desktop shortcuts at that.

- Recompile pgAdmin.

-- 
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk

Hi Dave,
many thanks for quick answer!

> - Run pgAdmin from the command line, with a command like:
>  G_SLICE=always-malloc pgadmin3 &
This works fine 

> - Recompile pgAdmin.
That's what I tried, too. Sorry, forgot to mention it. I downloaded the 
source-rpm for my distribution and installed it. Controlling all the 
requirements mentioned in the INSTALL file I found installed
GTK 2.12.5
automake 1.9.6
autoconf 2.60
gcc 4.1.3

wxGTK 2.6.8
libxml2 2.6.30
libxslt  1.1.22
Postgresql 8.1.11
So I thought that all requirements were fullfilled and I tried to compile it 
with rpmbuild but unfortunately it stopped at the first step (suppose the 
configure-process). The error message was:

checking for C compiler default output file name... configure: error: C 
compiler cannot create executables
See `config.log' for more details.

Attached you find the config.log. Perhaps it helps to determine the problem...
Michael