[Postgres-xl-bugs] Server status/sessions problem

asvany asvany at gmail.com
Thu Apr 30 10:23:28 PDT 2015


thanks for the fast reply!

I can't imagine how can communicate the PgAdmin with the datanodes
bacause I just entered the coordinator host:port for it.



On 04/30/2015 10:51 AM, Koichi Suzuki wrote:
> I'm afraid PgAdmin III issued transactions directly to datanodes,
> which can cause global inconsistency and not allowed in XL/XC at
> present.
>
> At your risk, xc_maintenance_mode could help.
>
> Regards;
> ---
> Koichi Suzuki
>
>
> 2015-04-30 1:42 GMT+09:00 asvany <asvany at gmail.com>:
>> Hello
>>
>> I use an 6-node large pgxl cluster.
>> I install the postgres-xl-v9.2-src.tar.gz first and I can use the system for
>> analytic tasks.
>>
>> I think it is a revolutionary software!
>>
>> I can administer and show the system with phppgadmin, and I am writing and
>> running the queries with pgAdmin3.
>>
>> unfortunately I experienced some bug and anomalies and I install again from
>> the current git sources.
>>
>> the whole database works more stable and predictable, but I can't administer
>> the sessions anymore.
>>
>> when I try to login with phppgadmin I just get an error message:
>>
>>
>> SQL error:
>>
>> ERROR:  Could not begin transaction on data node.
>>
>> In statement:
>>
>> SELECT pdb.datname AS datname, pr.rolname AS datowner,
>> pg_encoding_to_char(encoding) AS datencoding, (SELECT description FROM
>> pg_catalog.pg_shdescription pd WHERE pdb.oid=pd.objoid AND
>> pd.classoid='pg_database'::regclass) AS datcomment, (SELECT spcname FROM
>> pg_catalog.pg_tablespace pt WHERE pt.oid=pdb.dattablespace) AS tablespace,
>> CASE WHEN pg_catalog.has_database_privilege(current_user, pdb.oid,
>> 'CONNECT') THEN pg_catalog.pg_database_size(pdb.oid) ELSE -1 -- set this
>> magic value, which we will convert to no access later END as dbsize,
>> pdb.datcollate, pdb.datctype FROM pg_catalog.pg_database pdb LEFT JOIN
>> pg_catalog.pg_roles pr ON (pdb.datdba = pr.oid) WHERE true AND NOT
>> pdb.datistemplate ORDER BY pdb.datname
>>
>> when I try pgAdmin3->Tools->Server Status I got the message:
>>
>> ERROR:  column "usename" does not exist at character 26
>> STATEMENT:  select pid "SESSION_ID", usename "USER", upper(state) "STATUS",
>> waiting "WAITING", application_name "MODULE", client_addr "IP_ADDRESS",
>> client_hostname "HOST", client_port "PORT", backend_start "SESSION_START",
>> query_start "QUERY_START", state_change "STATE_CHANGE", query "QUERY" from
>> pg_stat_activity
>> ERROR:  column "datname" does not exist at character 40
>> STATEMENT:  SELECT p.pid AS pid, application_name, datname, usename,
>>         CASE WHEN client_port=-1 THEN 'local pipe' WHEN
>> length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE
>> textin(inet_out(client_addr))||':'||client_port END AS client,
>>         date_trunc('second', backend_start) AS backend_start, CASE WHEN
>> state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS
>> query_start,
>>         date_trunc('second', xact_start) AS xact_start, state,
>> date_trunc('second', state_change) AS state_change, (SELECT min(l1.pid) FROM
>> pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2
>> WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT
>> transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS
>> blockedby,
>>         query AS query,
>>         CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE
>> query_start < now() - '10 seconds'::interval END AS slowquery
>>         FROM pg_stat_activity p ORDER BY 1 ASC
>>
>> when I try use DBNavigator plugin for inteliJ idea I got the message:
>>
>> ERROR:  column "usename" does not exist at character 26
>> STATEMENT:  select pid "SESSION_ID", usename "USER", upper(state) "STATUS",
>> waiting "WAITING", application_name "MODULE", client_addr "IP_ADDRESS",
>> client_hostname "HOST", client_port "PORT", backend_start "SESSION_START",
>> query_start "QUERY_START", state_change "STATE_CHANGE", query "QUERY" from
>> pg_stat_activity
>>
>> I made lot of research with google without any solution.
>> I tried re-init the DB with pgxc_ctl / init all command without any change.
>>
>> could I try something?
>> Thanks
>> As
>>
>>
>>
>> ------------------------------------------------------------------------------
>> One dashboard for servers and applications across Physical-Virtual-Cloud
>> Widest out-of-the-box monitoring support with 50+ applications
>> Performance metrics, stats and reports that give you Actionable Insights
>> Deep dive visibility with transaction tracing using APM Insight.
>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> _______________________________________________
>> Postgres-xl-bugs mailing list
>> Postgres-xl-bugs at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-bugs
>>





More information about the postgres-xl-bugs mailing list