pgadmin3 crashes when connecting to a Postgresql database

[Wolf Rogner]

Adding a connection to PgAdminIII works.

Connection reminds me that password is saved in clear text in a file -> OK
Try to get role properties of a db user

Brings up the assertion error:
An assertion failed!
/usr/include/wx-3.0/wx/datetime.h(1733): assert "IsValid()" failed in GetValue(): invalid wxDateTime

Twice continue and the window for the user properties appears.

Closing the error dialog -> terminates the program
Ignoring the error dialog -> crashes the program

NB: The user was created from command line or webmin.
Creating the user via PgAdminIII and changing its attributes works fine.

ProblemType: Bug
DistroRelease: Ubuntu 15.04
Package: pgadmin3 1.20.0~beta2-1
ProcVersionSignature: Ubuntu 3.19.0-26.27-generic 3.19.8-ckt4
Uname: Linux 3.19.0-26-generic x86_64
NonfreeKernelModules: nvidia wl
ApportVersion: 2.17.2-0ubuntu1.2
Architecture: amd64
CurrentDesktop: Unity
Date: Sun Aug 2 17:17:11 2015
InstallationDate: Installed on 2013-05-17 (806 days ago)
InstallationMedia: Ubuntu 13.04 "Raring Ringtail" - Release amd64+mac (20130424)
SourcePackage: pgadmin3
UpgradeStatus: Upgraded to vivid on 2015-04-25 (99 days ago)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[CuriousOrange (d-curiousorange)]

Same issue seen connecting from fully-patched Debian 8 + XFCE + pgadmin3 desktop connecting to freshly-installed & patched Debian 8 server running postgres, all packages from default Debian repositories. Postgres server was temporarily set to accept hostssl / all users / desktop ip/32 / trust for first login with pgadmin3 to set postgres' password.

pgAdmin version 1.20.0 Beta 2 (Oct 23 2014, rev: 827ba79)

Desktop & server:

# uname -a
Linux wiki 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt11-1+deb8u3 (2015-08-04) x86_64 GNU/Linux

Assertion message exactly matches Wolf's

[Maxim Baele (maxim-baele)]

Same issue on Ubuntu 15.04 with pgadmin3, but it seems to occur only when trying to edit (login) roles.
I can connect to databases just fine

[Fabio Chino (jun-chino)]

As reported by Maxim Baele, the version 1.22.0 from 16.04 does crash when trying to edit the properties of a role that does not have the expiration date set. I just confirmed it by setting the expiration date of one of the roles while keeping the others unset. All but the one with the expiration set crashes pgadmin3.

Given that, it is possible to workaround this by setting an expiration date to all users using psql and a command like:

   alter role postgres with valid until '9999-12-31';

I know that this is not the same as a role without expiration date set but it is working in practice.

I think that this new bug may be related to the fix of an annoying bug present on the pgadmin3 from 14.04 that always set the expiration date of users with no expiration to today.