MIME-Version: 1.0
References: 
 <CAGHENJ6W98kvtOOsOeqQjZ1RWfZxeXEq_n6Ebp8n-+HVsVQ2jA@mail.gmail.com>
In-Reply-To: 
 <CAGHENJ6W98kvtOOsOeqQjZ1RWfZxeXEq_n6Ebp8n-+HVsVQ2jA@mail.gmail.com>
From: Erwin Brandstetter <brsaweda@gmail.com>
Date: Wed, 8 Jan 2020 17:10:52 +0100
Message-ID: 
 <CAGHENJ75MM5+rPLXgq1OUxj7wNFYC1MG753gboTP57Qi=VhSZA@mail.gmail.com>
Subject: Re: pgadmin3 1.22.2-6 broken
To: pgsql-pkg-debian@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000fbfd08059ba32375"
Precedence: bulk

--000000000000fbfd08059ba32375
Content-Type: text/plain; charset="UTF-8"

The downgrade to 1.22.2-4 fixed it for me for now:

sudo apt-get install pgadmin3=1.22.2-4 pgadmin3-data=1.22.2-4
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer
required:
  libwxgtk3.0-gtk3-0v5 python3-flask-htmlmin python3-htmlmin
Use 'sudo apt autoremove' to remove them.
The following packages will be DOWNGRADED:
  pgadmin3 pgadmin3-data
0 upgraded, 0 newly installed, 2 downgraded, 0 to remove and 0 not upgraded.
Need to get 5.065 kB of archives.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://at.archive.ubuntu.com/ubuntu bionic/universe amd64 pgadmin3
amd64 1.22.2-4 [3.187 kB]
Get:2 http://at.archive.ubuntu.com/ubuntu bionic/universe amd64
pgadmin3-data all 1.22.2-4 [1.878 kB]
Fetched 5.065 kB in 2s (2.519 kB/s)
dpkg: warning: downgrading pgadmin3 from 1.22.2-6.pgdg18.04+1 to 1.22.2-4
(Reading database ... 176239 files and directories currently installed.)
Preparing to unpack .../pgadmin3_1.22.2-4_amd64.deb ...
Unpacking pgadmin3 (1.22.2-4) over (1.22.2-6.pgdg18.04+1) ...
dpkg: warning: downgrading pgadmin3-data from 1.22.2-6.pgdg18.04+1 to
1.22.2-4
Preparing to unpack .../pgadmin3-data_1.22.2-4_all.deb ...
Unpacking pgadmin3-data (1.22.2-4) over (1.22.2-6.pgdg18.04+1) ...
Setting up pgadmin3-data (1.22.2-4) ...
Setting up pgadmin3 (1.22.2-4) ...
Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ...
Processing triggers for mime-support (3.60ubuntu1) ...
Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...

Regards
Erwin

On Wed, Jan 8, 2020 at 4:39 PM Erwin Brandstetter <brsaweda@gmail.com>
wrote:

> I am running Ubuntu bionic with the additional repository:
>
> deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
>
> pgadmin3 was updated to version 1.22.2-6.pgdg18.04+1 when I ran updates
> today. Now I cannot open the essential SQL editor any more. I see a
> black-and-white wireframe for a second or two, then the program terminates.
> The program is now useless for me.
>
> The log file for pgAdmin 3 ends with:
>
> ...
> QUERY  : 16:32:19: Scalar query (:5432): SELECT version();
> QUERY  : 16:32:19: Query result: PostgreSQL 11.6 (Ubuntu
> 11.6-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
> 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit
> QUERY  : 16:32:19: Set query (:5432): SET DateStyle=ISO;
> SET client_min_messages=notice;
> SET bytea_output=escape;
> SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
>   FROM pg_database WHERE oid = 16385
> SCRIPT : 16:32:19: Application created
>
>
> /var/log/syslog seems revealing:
>
> Jan  8 16:32:19 A-N-W-030 pgadmin3[4674]: The window 0x56464b1d84d0
> already has a drawing context. You cannot call
> gdk_window_begin_draw_frame() without calling gdk_window_end_draw_frame()
> first.
> Jan  8 16:32:19 A-N-W-030 kernel: [ 3812.954406] pgadmin3[4674]: segfault
> at 4 ip 00007f40917a21a0 sp 00007ffcb697bc58 error 4 in
> libcairo.so.2.11510.0[7f4091782000+118000]
> Jan  8 16:32:19 A-N-W-030 pgadmin3[4674]:
> gdk_drawing_context_get_cairo_context: assertion 'GDK_IS_DRAWING_CONTEXT
> (context)' failed
>
>
> Any way to fix? Or get the previous version? I tried:
>
> sudo apt-get install pgadmin3=1.22.2-5
>
> But only get the error:
> > E: Version '1.22.2-5' for 'pgadmin3' was not found
>
>
> Regards
> Erwin
>

--000000000000fbfd08059ba32375
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><br></div><div>The downgrade to 1.22.2-4 fixed it for=
 me for now:</div><div><br></div><div>sudo apt-get install pgadmin3=3D1.22.=
2-4 pgadmin3-data=3D1.22.2-4</div>Reading package lists... Done<br>Building=
 dependency tree =C2=A0 =C2=A0 =C2=A0 <br>Reading state information... Done=
<br>The following packages were automatically installed and are no longer r=
equired:<br>=C2=A0 libwxgtk3.0-gtk3-0v5 python3-flask-htmlmin python3-htmlm=
in<br>Use &#39;sudo apt autoremove&#39; to remove them.<br>The following pa=
ckages will be DOWNGRADED:<br>=C2=A0 pgadmin3 pgadmin3-data<br>0 upgraded, =
0 newly installed, 2 downgraded, 0 to remove and 0 not upgraded.<br>Need to=
 get 5.065 kB of archives.<br>After this operation, 0 B of additional disk =
space will be used.<br>Do you want to continue? [Y/n] Y<br>Get:1 <a href=3D=
"http://at.archive.ubuntu.com/ubuntu">http://at.archive.ubuntu.com/ubuntu</=
a> bionic/universe amd64 pgadmin3 amd64 1.22.2-4 [3.187 kB]<br>Get:2 <a hre=
f=3D"http://at.archive.ubuntu.com/ubuntu">http://at.archive.ubuntu.com/ubun=
tu</a> bionic/universe amd64 pgadmin3-data all 1.22.2-4 [1.878 kB]<br>Fetch=
ed 5.065 kB in 2s (2.519 kB/s) =C2=A0 =C2=A0 =C2=A0 =C2=A0<br>dpkg: warning=
: downgrading pgadmin3 from 1.22.2-6.pgdg18.04+1 to 1.22.2-4<br>(Reading da=
tabase ... 176239 files and directories currently installed.)<br>Preparing =
to unpack .../pgadmin3_1.22.2-4_amd64.deb ...<br>Unpacking pgadmin3 (1.22.2=
-4) over (1.22.2-6.pgdg18.04+1) ...<br>dpkg: warning: downgrading pgadmin3-=
data from 1.22.2-6.pgdg18.04+1 to 1.22.2-4<br>Preparing to unpack .../pgadm=
in3-data_1.22.2-4_all.deb ...<br>Unpacking pgadmin3-data (1.22.2-4) over (1=
.22.2-6.pgdg18.04+1) ...<br>Setting up pgadmin3-data (1.22.2-4) ...<br>Sett=
ing up pgadmin3 (1.22.2-4) ...<br>Processing triggers for gnome-menus (3.13=
.3-11ubuntu1.1) ...<br>Processing triggers for mime-support (3.60ubuntu1) .=
..<br>Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ..=
.<br><div>Processing triggers for man-db (2.8.3-2ubuntu0.1) ...</div><div><=
br></div><div>Regards</div><div>Erwin<br></div></div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Jan 8, 2020 at 4:39 =
PM Erwin Brandstetter &lt;<a href=3D"mailto:brsaweda@gmail.com">brsaweda@gm=
ail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><div>I am running Ubuntu bionic with the additional=
 repository:</div><div><br></div><div>deb <a href=3D"http://apt.postgresql.=
org/pub/repos/apt/" target=3D"_blank">http://apt.postgresql.org/pub/repos/a=
pt/</a> bionic-pgdg main</div><div><br></div><div>pgadmin3 was updated to v=
ersion 1.22.2-6.pgdg18.04+1 when I ran updates today. Now I cannot open the=
 essential SQL editor any more. I see a black-and-white wireframe for a sec=
ond or two, then the program terminates. The program is now useless for me.=
</div><div><br></div><div>The log file for pgAdmin 3 ends with:<br></div><d=
iv><br></div><div>...<br></div><div>QUERY =C2=A0: 16:32:19: Scalar query (:=
5432): SELECT version();<br>QUERY =C2=A0: 16:32:19: Query result: PostgreSQ=
L 11.6 (Ubuntu 11.6-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc =
(Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit<br>QUERY =C2=A0: 16:32:19: Se=
t query (:5432): SET DateStyle=3DISO;<br>SET client_min_messages=3Dnotice;<=
br>SET bytea_output=3Descape;<br>SELECT oid, pg_encoding_to_char(encoding) =
AS encoding, datlastsysoid<br>=C2=A0 FROM pg_database WHERE oid =3D 16385<b=
r>SCRIPT : 16:32:19: Application created<br></div><div><br></div><div><br><=
/div><div>/var/log/syslog seems revealing:<br></div><div><br></div><div>Jan=
 =C2=A08 16:32:19 A-N-W-030 pgadmin3[4674]: The window 0x56464b1d84d0 alrea=
dy has a drawing context. You cannot call gdk_window_begin_draw_frame() wit=
hout calling gdk_window_end_draw_frame() first.<br>Jan =C2=A08 16:32:19 A-N=
-W-030 kernel: [ 3812.954406] pgadmin3[4674]: segfault at 4 ip 00007f40917a=
21a0 sp 00007ffcb697bc58 error 4 in libcairo.so.2.11510.0[7f4091782000+1180=
00]<br>Jan =C2=A08 16:32:19 A-N-W-030 pgadmin3[4674]: gdk_drawing_context_g=
et_cairo_context: assertion &#39;GDK_IS_DRAWING_CONTEXT (context)&#39; fail=
ed</div><div><br></div><div><br></div><div>Any way to fix? Or get the previ=
ous version? I tried:<br></div><div><br></div><div>sudo apt-get install pga=
dmin3=3D1.22.2-5</div><div><br></div><div>But only get the error:<br></div>=
<div>&gt; E: Version &#39;1.22.2-5&#39; for &#39;pgadmin3&#39; was not foun=
d</div><div><br></div><div><br></div><div>Regards</div><div>Erwin<br></div>=
</div>
</blockquote></div>

--000000000000fbfd08059ba32375--