Version 1.20.0 Beta (Aug 10 2015, rev: REL-1_18_0_116-gd491
Running Ubuntu 15.10 64-bit
Installed pgAdmin via Ubuntu Software Center
Steps to recreate:
pgAdmin will force close when:
1. Open pgAdmin
2. Right click on any of the items in the Object browser
3. Do anything
* Select an option from the menu
* Try to navigate off the menu
* Press 'escape'
Additional Info (possibly related/unrelated)
[cid:04b94eb1-76b7-4100-b7a5-c09dc469ce30]
If I click "Stop" pgAdmin will force close, if I click continue pgAdmin stays
open.
Steps to recreate:
1. Open pgAdmin
2. Press the drop down button beside the "Execute last plugin button"
[cid:04388aa0-26d6-40b8-aeff-73451efe465d]
3. Error message above is displayed
INFO : 10:27:42: Displaying properties for Server localhost:5432
STATUS : 10:27:42: Retrieving details on server localhost...
STATUS : 10:27:42: Retrieving details on server localhost... (0.00 secs)
INFO : 10:27:46: Attempting to create a connection object...
INFO : 10:27:46: Using password file /home/jason.churcher/.pgpass
STATUS : 10:27:46: Connecting to database...
INFO : 10:27:46: Opening connection with connection string: host='localhost' dbname='postgres' user='postgres' port=5432 application_name='pgAdmin III - Browser'
QUERY : 10:27:46: Scalar query (localhost:5432): SELECT version();
QUERY : 10:27:46: Query result: PostgreSQL 9.4.7 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 5.2.1-22ubuntu2) 5.2.1 20151010, 64-bit
QUERY : 10:27:46: Set query (localhost: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 datname='postgres'
INFO : 10:27:46: Setting client_encoding to 'UNICODE'
QUERY : 10:27:46: Set query (localhost:5432): SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc, CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused
FROM pg_user WHERE usename=current_user
QUERY : 10:27:46: Set query (localhost:5432): SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user;
STATUS : 10:27:46: Connecting to database... (0.02 secs)
STATUS : 10:27:46: Restoring previous environment...
INFO : 10:27:46: pgServer object initialised as required.
INFO : 10:27:46: Adding child object to server localhost:5432
QUERY : 10:27:46: Set query (localhost:5432): SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
current_setting('default_tablespace') AS default_tablespace,
descr.description
, db.datconnlimit as connectionlimit, db.datcollate as collate, db.datctype as ctype,
(SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=db.oid) AS labels,
(SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=db.oid) AS providers FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
LEFT OUTER JOIN pg_shdescription descr ON (db.oid=descr.objoid AND descr.classoid='pg_database'::regclass)
ORDER BY datname
QUERY : 10:27:46: Set query (localhost:5432): SELECT ts.oid, spcname, pg_catalog.pg_tablespace_location(ts.oid) AS spclocation, spcoptions, pg_get_userbyid(spcowner) as spcuser, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=ts.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=ts.oid) AS providers FROM pg_tablespace ts
ORDER BY spcname
QUERY : 10:27:46: Scalar query (localhost:5432): SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace
WHERE relname='pga_job' AND nspname='pgagent'
INFO : 10:27:46: Query returned no tuples
QUERY : 10:27:46: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT')
QUERY : 10:27:46: Query result: t
QUERY : 10:27:46: Set query (localhost:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description,
(SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels,
(SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE NOT rolcanlogin ORDER BY rolname
QUERY : 10:27:46: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT')
QUERY : 10:27:46: Query result: t
QUERY : 10:27:46: Set query (localhost:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description,
(SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels,
(SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE rolcanlogin ORDER BY rolname
QUERY : 10:27:46: Set query (localhost:5432): SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts')
STATUS : 10:27:46: Restoring previous environment... (0.01 secs)
QUERY : 10:27:46: Set query (localhost:5432): SELECT proname, pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2
FROM pg_proc
JOIN pg_namespace n ON n.oid=pronamespace
WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf', 'pgstattuple', 'pgstatindex')
AND nspname IN ('pg_catalog', 'public')
QUERY : 10:27:46: Scalar query (localhost:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclass AND attname = 'proargdefaults'
QUERY : 10:27:46: Query result: 1
pgAdmin-backtrace-201605171047
Description: pgAdmin-backtrace-201605171047
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
