Search Postgresql Archives

Out of Memory Error on Insert

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am getting an Out of Memory error in my server connection process
while running a large insert query.

Postgres version: "PostgreSQL 8.2.16 on i686-pc-mingw32, compiled by
GCC gcc.exe (GCC) 3.4.2 (mingw-special)"
OS: Windows 7 Professional (v.6.1, build 7601 service pack 1)
The OS is 64 bit but the postgres app is a 32-bit app and I run out of
memory and the server process crashes as soon as I hit 2 GB of memory.
 I assume that is because that is the limit for 32-bit apps.
My client connection is via JDBC in case that is important.

I am creating two temporary tables as follows:

create temporary table simple_group  (groupId int8 not null, elementId
int8 not null, primary key (groupId, elementId))

create temporary table temp_usergroup_acl_entry  (elementId int8 not
null, userGroupId int8 not null, grantFlags int8 not null, denyflags
int8 not null, primary key (elementId, userGroupId))

Table simple_group has about 584 rows.  It represents the membership
of devices (elementId) in a group (groupId).  The crash happens when I
run the query to populate temp_usergroup_acl_entry.  The query is
below followed by the memory map information.  As you can see there
are a lot of full joins.

My goal with the query is to combine the bit maps of access rights
(stored in 8 byte ints) for lists of devices in various groups.  The
groups might have overlapping memberships so that is why I am using
the outer joins and the bit-wise or operator to combine the
permissions of the bit masks.  I know what the values of the bit-masks
should be for each group from some queries that run before this query.
 However, the previous queries do not eat up much memory at all.

Is there something I can do to prevent the out of memory error?  Or
perhaps there is a way I can re-write the query to achieve the same
result?

Insert query:


insert into temp_usergroup_acl_entry(elementId,userGroupId,grantFlags,denyflags)
select coalesce(q0.elementId, q1.elementId) as elementId,
coalesce(q0.userGroupId, q1.userGroupId) as userGroupId,
(coalesce(q0.grantFlags, 0) | coalesce(q1.grantFlags, 0)) as grantFlags,
(coalesce(q0.denyflags, 0) | coalesce(q1.denyflags, 0)) as denyflags from
(select coalesce(q2.elementId, q3.elementId) as elementId,
coalesce(q2.userGroupId, q3.userGroupId) as userGroupId,
(coalesce(q2.grantFlags, 0) | coalesce(q3.grantFlags, 0)) as grantFlags,
(coalesce(q2.denyflags, 0) | coalesce(q3.denyflags, 0)) as denyflags from
(select coalesce(q4.elementId, q5.elementId) as elementId,
coalesce(q4.userGroupId, q5.userGroupId) as userGroupId,
(coalesce(q4.grantFlags, 0) | coalesce(q5.grantFlags, 0)) as grantFlags,
(coalesce(q4.denyflags, 0) | coalesce(q5.denyflags, 0)) as denyflags from
(select coalesce(q6.elementId, q7.elementId) as elementId,
coalesce(q6.userGroupId, q7.userGroupId) as userGroupId,
(coalesce(q6.grantFlags, 0) | coalesce(q7.grantFlags, 0)) as grantFlags,
(coalesce(q6.denyflags, 0) | coalesce(q7.denyflags, 0)) as denyflags from
(select coalesce(q8.elementId, q9.elementId) as elementId,
coalesce(q8.userGroupId, q9.userGroupId) as userGroupId,
(coalesce(q8.grantFlags, 0) | coalesce(q9.grantFlags, 0)) as grantFlags,
(coalesce(q8.denyflags, 0) | coalesce(q9.denyflags, 0)) as denyflags from
(select coalesce(q10.elementId, q11.elementId) as elementId,
coalesce(q10.userGroupId, q11.userGroupId) as userGroupId,
(coalesce(q10.grantFlags, 0) | coalesce(q11.grantFlags, 0)) as grantFlags,
(coalesce(q10.denyflags, 0) | coalesce(q11.denyflags, 0)) as denyflags from
(select coalesce(q12.elementId, q13.elementId) as elementId,
coalesce(q12.userGroupId, q13.userGroupId) as userGroupId,
(coalesce(q12.grantFlags, 0) | coalesce(q13.grantFlags, 0)) as grantFlags,
(coalesce(q12.denyflags, 0) | coalesce(q13.denyflags, 0)) as denyflags from
(select coalesce(q14.elementId, q15.elementId) as elementId,
coalesce(q14.userGroupId, q15.userGroupId) as userGroupId,
(coalesce(q14.grantFlags, 0) | coalesce(q15.grantFlags, 0)) as grantFlags,
(coalesce(q14.denyflags, 0) | coalesce(q15.denyflags, 0)) as denyflags from
(select coalesce(q16.elementId, q17.elementId) as elementId,
coalesce(q16.userGroupId, q17.userGroupId) as userGroupId,
(coalesce(q16.grantFlags, 0) | coalesce(q17.grantFlags, 0)) as grantFlags,
(coalesce(q16.denyflags, 0) | coalesce(q17.denyflags, 0)) as denyflags from
(select coalesce(q18.elementId, q19.elementId) as elementId,
coalesce(q18.userGroupId, q19.userGroupId) as userGroupId,
(coalesce(q18.grantFlags, 0) | coalesce(q19.grantFlags, 0)) as grantFlags,
(coalesce(q18.denyflags, 0) | coalesce(q19.denyflags, 0)) as denyflags from
(select coalesce(q20.elementId, q21.elementId) as elementId,
coalesce(q20.userGroupId, q21.userGroupId) as userGroupId,
(coalesce(q20.grantFlags, 0) | coalesce(q21.grantFlags, 0)) as grantFlags,
(coalesce(q20.denyflags, 0) | coalesce(q21.denyflags, 0)) as denyflags from
(select coalesce(q22.elementId, q23.elementId) as elementId,
coalesce(q22.userGroupId, q23.userGroupId) as userGroupId,
(coalesce(q22.grantFlags, 0) | coalesce(q23.grantFlags, 0)) as grantFlags,
(coalesce(q22.denyflags, 0) | coalesce(q23.denyflags, 0)) as denyflags from
(select coalesce(q24.elementId, q25.elementId) as elementId,
coalesce(q24.userGroupId, q25.userGroupId) as userGroupId,
(coalesce(q24.grantFlags, 0) | coalesce(q25.grantFlags, 0)) as grantFlags,
(coalesce(q24.denyflags, 0) | coalesce(q25.denyflags, 0)) as denyflags from
(select coalesce(q26.elementId, q27.elementId) as elementId,
coalesce(q26.userGroupId, q27.userGroupId) as userGroupId,
(coalesce(q26.grantFlags, 0) | coalesce(q27.grantFlags, 0)) as grantFlags,
(coalesce(q26.denyflags, 0) | coalesce(q27.denyflags, 0)) as denyflags from
(select coalesce(q28.elementId, q29.elementId) as elementId,
coalesce(q28.userGroupId, q29.userGroupId) as userGroupId,
(coalesce(q28.grantFlags, 0) | coalesce(q29.grantFlags, 0)) as grantFlags,
(coalesce(q28.denyflags, 0) | coalesce(q29.denyflags, 0)) as denyflags from
(select coalesce(q30.elementId, q31.elementId) as elementId,
coalesce(q30.userGroupId, q31.userGroupId) as userGroupId,
(coalesce(q30.grantFlags, 0) | coalesce(q31.grantFlags, 0)) as grantFlags,
(coalesce(q30.denyflags, 0) | coalesce(q31.denyflags, 0)) as denyflags from
(select coalesce(q32.elementId, q33.elementId) as elementId,
coalesce(q32.userGroupId, q33.userGroupId) as userGroupId,
(coalesce(q32.grantFlags, 0) | coalesce(q33.grantFlags, 0)) as grantFlags,
(coalesce(q32.denyflags, 0) | coalesce(q33.denyflags, 0)) as denyflags from
(select coalesce(q34.elementId, q35.elementId) as elementId,
coalesce(q34.userGroupId, q35.userGroupId) as userGroupId,
(coalesce(q34.grantFlags, 0) | coalesce(q35.grantFlags, 0)) as grantFlags,
(coalesce(q34.denyflags, 0) | coalesce(q35.denyflags, 0)) as denyflags from
(select coalesce(q36.elementId, q37.elementId) as elementId,
coalesce(q36.userGroupId, q37.userGroupId) as userGroupId,
(coalesce(q36.grantFlags, 0) | coalesce(q37.grantFlags, 0)) as grantFlags,
(coalesce(q36.denyflags, 0) | coalesce(q37.denyflags, 0)) as denyflags from
(select elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as
denyflags from simple_group where groupId=10968327)  as q36
full outer join
(select elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as
denyflags from simple_group where groupId=10957179) as q37
on (q36.elementId=q37.elementId))  as q34
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10957178)
as q35
on (q34.elementId=q35.elementId))  as q32
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10755693)
as q33
on (q32.elementId=q33.elementId))  as q30
full outer join (select elementId, 10979837 as userGroupId, 0 as
grantFlags, 3 as denyflags from simple_group where groupId=1811129) as
q31
on (q30.elementId=q31.elementId))  as q28
full outer join (select elementId, 10979837 as userGroupId, 0 as
grantFlags, 3 as denyflags from simple_group where groupId=1806563) as
q29
on (q28.elementId=q29.elementId))  as q26
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10957153)
as q27
on (q26.elementId=q27.elementId))  as q24
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10966144)
as q25
on (q24.elementId=q25.elementId))  as q22
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10755694)
as q23
on (q22.elementId=q23.elementId))  as q20
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10979064)
as q21
on (q20.elementId=q21.elementId))  as q18
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10755757)
as q19
on (q18.elementId=q19.elementId))  as q16
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=5865082) as
q17
on (q16.elementId=q17.elementId))  as q14
full outer join (select elementId, 10979837 as userGroupId, 1 as
grantFlags, 0 as denyflags from simple_group where groupId=10758145)
as q15
on (q14.elementId=q15.elementId))  as q12
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=1718259) as
q13
on (q12.elementId=q13.elementId))  as q10
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10755709)
as q11
on (q10.elementId=q11.elementId))  as q8
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=1718266) as
q9
on (q8.elementId=q9.elementId))  as q6
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=1718273) as
q7
on (q6.elementId=q7.elementId))  as q4
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10965166)
as q5
on (q4.elementId=q5.elementId))  as q2
full outer join (select elementId, 10979837 as userGroupId, 1 as
grantFlags, 0 as denyflags from simple_group where groupId=10979069)
as q3
on (q2.elementId=q3.elementId))  as q0
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=759234) as
q1
on (q0.elementId=q1.elementId)


Memory map info:


2011-10-17 23:38:37 NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "simple_group_pkey" for table "simple_group"

2011-10-17 23:38:38 NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "temp_usergroup_acl_entry_pkey" for table
"temp_usergroup_acl_entry"

TopMemoryContext: 204824 total in 9 blocks; 17664 free (79 chunks); 187160 used

unnamed prepared statement: 1237311488 total in 160 blocks; 8936 free
(2 chunks); 1237302552 used

Local Buffer Lookup Table: 8192 total in 1 blocks; 1776 free (0
chunks); 6416 used

SPI Plan: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used

SPI Plan: 3072 total in 2 blocks; 1024 free (0 chunks); 2048 used

Type information cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used

SPI Plan: 3072 total in 2 blocks; 1024 free (0 chunks); 2048 used

SPI Plan: 3072 total in 2 blocks; 960 free (0 chunks); 2112 used

SPI Plan: 3072 total in 2 blocks; 872 free (0 chunks); 2200 used

SPI Plan: 3072 total in 2 blocks; 1136 free (0 chunks); 1936 used

SPI Plan: 3072 total in 2 blocks; 864 free (0 chunks); 2208 used

RI query cache: 24576 total in 2 blocks; 14136 free (5 chunks); 10440 used

TopTransactionContext: 24576 total in 2 blocks; 14360 free (1 chunks);
10216 used

AfterTriggerEvents: 8192 total in 1 blocks; 8176 free (3 chunks); 16 used

S_2: 1024 total in 1 blocks; 752 free (0 chunks); 272 used

Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320 used

S_1: 1024 total in 1 blocks; 752 free (0 chunks); 272 used

Prepared Queries: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used

Record information cache: 8192 total in 1 blocks; 1800 free (0
chunks); 6392 used

MessageContext: 24600 total in 2 blocks; 8176 free (2 chunks); 16424 used

smgr relation table: 8192 total in 1 blocks; 1776 free (0 chunks); 6416 used

TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16 used

Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used

PortalMemory: 8192 total in 1 blocks; 8176 free (1 chunks); 16 used

Relcache by OID: 8192 total in 1 blocks; 2856 free (0 chunks); 5336 used

CacheMemoryContext: 659000 total in 19 blocks; 91008 free (2 chunks);
567992 used

temp_usergroup_acl_entry_pkey: 1024 total in 1 blocks; 328 free (0
chunks); 696 used

simple_group_pkey: 1024 total in 1 blocks; 328 free (0 chunks); 696 used

pg_constraint_contypid_index: 1024 total in 1 blocks; 352 free (0
chunks); 672 used

pg_constraint_conrelid_index: 1024 total in 1 blocks; 352 free (0
chunks); 672 used

pg_constraint_conname_nsp_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

pg_constraint_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_shdepend_depender_index: 1024 total in 1 blocks; 216 free (0
chunks); 808 used

pg_depend_depender_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used

pg_depend_reference_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used

pg_shdepend_reference_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

ar_rule_field_pkey: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

ar_rule_pkey: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

usergroup_arrule_pkey: 1024 total in 1 blocks; 288 free (0 chunks); 736 used

ar_ruletextfield_pkey: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

allusersgroup_pkey: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

vsusergroup_pkey: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

vsusergroup_name_key: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

ar_ruletemplate_pkey: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

ar_ruleconditionfield_pkey: 1024 total in 1 blocks; 392 free (0
chunks); 632 used

ar_rule_field_edit_pkey: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

ar_rule_edit_pkey: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

usergroupedit_arruleedit_pkey: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

vsusergroupedit_pkey: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

access_rights_sortorder_key: 1024 total in 1 blocks; 392 free (0
chunks); 632 used

access_rights_pkey: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

access_rights_name_key: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

bounded_groups_pkey: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

groups_pkey: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

groups_name_key: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

pg_index_indrelid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_type_typname_nsp_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used

pg_type_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

pg_statistic_relid_att_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

pg_auth_members_member_role_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used

pg_auth_members_role_member_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used

pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used

pg_proc_proname_args_nsp_index: 1024 total in 1 blocks; 256 free (0
chunks); 768 used

pg_proc_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 152 free (0
chunks); 872 used

pg_operator_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_opclass_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 216 free (0
chunks); 808 used

pg_namespace_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_namespace_nspname_index: 1024 total in 1 blocks; 352 free (0
chunks); 672 used

pg_language_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

pg_language_name_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

pg_inherits_relid_seqno_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used

pg_index_indexrelid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_authid_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_authid_rolname_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_database_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_conversion_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

pg_conversion_name_nsp_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used

pg_conversion_default_index: 1024 total in 1 blocks; 192 free (0
chunks); 832 used

pg_class_relname_nsp_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

pg_class_oid_index: 1024 total in 1 blocks; 352 free (0 chunks); 672 used

pg_cast_source_target_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 288 free (0
chunks); 736 used

pg_amproc_opc_proc_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used

pg_amop_opr_opc_index: 1024 total in 1 blocks; 288 free (0 chunks); 736 used

pg_amop_opc_strat_index: 1024 total in 1 blocks; 216 free (0 chunks); 808 used

pg_aggregate_fnoid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used

MdSmgr: 8192 total in 1 blocks; 6832 free (0 chunks); 1360 used

LOCALLOCK hash: 8192 total in 1 blocks; 1856 free (0 chunks); 6336 used

Timezones: 49432 total in 2 blocks; 5968 free (0 chunks); 43464 used

ErrorContext: 8192 total in 1 blocks; 8176 free (3 chunks); 16 used

2011-10-17 23:38:54 ERROR:  out of memory

2011-10-17 23:38:54 DETAIL:  Failed on request of size 28.

2011-10-17 23:38:54 STATEMENT:  insert into
temp_usergroup_acl_entry(elementId,userGroupId,grantFlags,denyflags)
select coalesce(q0.elementId, q1.elementId) as elementId,
coalesce(q0.userGroupId, q1.userGroupId) as userGroupId,
(coalesce(q0.grantFlags, 0) | coalesce(q1.grantFlags, 0)) as
grantFlags, (coalesce(q0.denyflags, 0) | coalesce(q1.denyflags, 0)) as
denyflags from (select coalesce(q2.elementId, q3.elementId) as
elementId, coalesce(q2.userGroupId, q3.userGroupId) as userGroupId,
(coalesce(q2.grantFlags, 0) | coalesce(q3.grantFlags, 0)) as
grantFlags, (coalesce(q2.denyflags, 0) | coalesce(q3.denyflags, 0)) as
denyflags from (select coalesce(q4.elementId, q5.elementId) as
elementId, coalesce(q4.userGroupId, q5.userGroupId) as userGroupId,
(coalesce(q4.grantFlags, 0) | coalesce(q5.grantFlags, 0)) as
grantFlags, (coalesce(q4.denyflags, 0) | coalesce(q5.denyflags, 0)) as
denyflags from (select coalesce(q6.elementId, q7.elementId) as
elementId, coalesce(q6.userGroupId, q7.userGroupId) as userGroupId,
(coalesce(q6.grantFlags, 0) | coalesce(q7.grantFlags, 0)) as
grantFlags, (coalesce(q6.denyflags, 0) | coalesce(q7.denyflags, 0)) as
denyflags from (select coalesce(q8.elementId, q9.elementId) as
elementId, coalesce(q8.userGroupId, q9.userGroupId) as userGroupId,
(coalesce(q8.grantFlags, 0) | coalesce(q9.grantFlags, 0)) as
grantFlags, (coalesce(q8.denyflags, 0) | coalesce(q9.denyflags, 0)) as
denyflags from (select coalesce(q10.elementId, q11.elementId) as
elementId, coalesce(q10.userGroupId, q11.userGroupId) as userGroupId,
(coalesce(q10.grantFlags, 0) | coalesce(q11.grantFlags, 0)) as
grantFlags, (coalesce(q10.denyflags, 0) | coalesce(q11.denyflags, 0))
as denyflags from (select coalesce(q12.elementId, q13.elementId) as
elementId, coalesce(q12.userGroupId, q13.userGroupId) as userGroupId,
(coalesce(q12.grantFlags, 0) | coalesce(q13.grantFlags, 0)) as
grantFlags, (coalesce(q12.denyflags, 0) | coalesce(q13.denyflags, 0))
as denyflags from (select coalesce(q14.elementId, q15.elementId) as
elementId, coalesce(q14.userGroupId, q15.userGroupId) as userGroupId,
(coalesce(q14.grantFlags, 0) | coalesce(q15.grantFlags, 0)) as
grantFlags, (coalesce(q14.denyflags, 0) | coalesce(q15.denyflags, 0))
as denyflags from (select coalesce(q16.elementId, q17.elementId) as
elementId, coalesce(q16.userGroupId, q17.userGroupId) as userGroupId,
(coalesce(q16.grantFlags, 0) | coalesce(q17.grantFlags, 0)) as
grantFlags, (coalesce(q16.denyflags, 0) | coalesce(q17.denyflags, 0))
as denyflags from (select coalesce(q18.elementId, q19.elementId) as
elementId, coalesce(q18.userGroupId, q19.userGroupId) as userGroupId,
(coalesce(q18.grantFlags, 0) | coalesce(q19.grantFlags, 0)) as
grantFlags, (coalesce(q18.denyflags, 0) | coalesce(q19.denyflags, 0))
as denyflags from (select coalesce(q20.elementId, q21.elementId) as
elementId, coalesce(q20.userGroupId, q21.userGroupId) as userGroupId,
(coalesce(q20.grantFlags, 0) | coalesce(q21.grantFlags, 0)) as
grantFlags, (coalesce(q20.denyflags, 0) | coalesce(q21.denyflags, 0))
as denyflags from (select coalesce(q22.elementId, q23.elementId) as
elementId, coalesce(q22.userGroupId, q23.userGroupId) as userGroupId,
(coalesce(q22.grantFlags, 0) | coalesce(q23.grantFlags, 0)) as
grantFlags, (coalesce(q22.denyflags, 0) | coalesce(q23.denyflags, 0))
as denyflags from (select coalesce(q24.elementId, q25.elementId) as
elementId, coalesce(q24.userGroupId, q25.userGroupId) as userGroupId,
(coalesce(q24.grantFlags, 0) | coalesce(q25.grantFlags, 0)) as
grantFlags, (coalesce(q24.denyflags, 0) | coalesce(q25.denyflags, 0))
as denyflags from (select coalesce(q26.elementId, q27.elementId) as
elementId, coalesce(q26.userGroupId, q27.userGroupId) as userGroupId,
(coalesce(q26.grantFlags, 0) | coalesce(q27.grantFlags, 0)) as
grantFlags, (coalesce(q26.denyflags, 0) | coalesce(q27.denyflags, 0))
as denyflags from (select coalesce(q28.elementId, q29.elementId) as
elementId, coalesce(q28.userGroupId, q29.userGroupId) as userGroupId,
(coalesce(q28.grantFlags, 0) | coalesce(q29.grantFlags, 0)) as
grantFlags, (coalesce(q28.denyflags, 0) | coalesce(q29.denyflags, 0))
as denyflags from (select coalesce(q30.elementId, q31.elementId) as
elementId, coalesce(q30.userGroupId, q31.userGroupId) as userGroupId,
(coalesce(q30.grantFlags, 0) | coalesce(q31.grantFlags, 0)) as
grantFlags, (coalesce(q30.denyflags, 0) | coalesce(q31.denyflags, 0))
as denyflags from (select coalesce(q32.elementId, q33.elementId) as
elementId, coalesce(q32.userGroupId, q33.userGroupId) as userGroupId,
(coalesce(q32.grantFlags, 0) | coalesce(q33.grantFlags, 0)) as
grantFlags, (coalesce(q32.denyflags, 0) | coalesce(q33.denyflags, 0))
as denyflags from (select coalesce(q34.elementId, q35.elementId) as
elementId, coalesce(q34.userGroupId, q35.userGroupId) as userGroupId,
(coalesce(q34.grantFlags, 0) | coalesce(q35.grantFlags, 0)) as
grantFlags, (coalesce(q34.denyflags, 0) | coalesce(q35.denyflags, 0))
as denyflags from (select coalesce(q36.elementId, q37.elementId) as
elementId, coalesce(q36.userGroupId, q37.userGroupId) as userGroupId,
(coalesce(q36.grantFlags, 0) | coalesce(q37.grantFlags, 0)) as
grantFlags, (coalesce(q36.denyflags, 0) | coalesce(q37.denyflags, 0))
as denyflags from (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10968327)
as q36 full outer join (select elementId, 10979837 as userGroupId, 3
as grantFlags, 0 as denyflags from simple_group where
groupId=10957179) as q37 on (q36.elementId=q37.elementId))  as q34
full outer join (select elementId, 10979837 as userGroupId, 3 as
grantFlags, 0 as denyflags from simple_group where groupId=10957178)
as q35 on (q34.elementId=q35.elementId))  as q32 full outer join
(select elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as
denyflags from simple_group where groupId=10755693) as q33 on
(q32.elementId=q33.elementId))  as q30 full outer join (select
elementId, 10979837 as userGroupId, 0 as grantFlags, 3 as denyflags
from simple_group where groupId=1811129) as q31 on
(q30.elementId=q31.elementId))  as q28 full outer join (select
elementId, 10979837 as userGroupId, 0 as grantFlags, 3 as denyflags
from simple_group where groupId=1806563) as q29 on
(q28.elementId=q29.elementId))  as q26 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=10957153) as q27 on
(q26.elementId=q27.elementId))  as q24 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=10966144) as q25 on
(q24.elementId=q25.elementId))  as q22 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=10755694) as q23 on
(q22.elementId=q23.elementId))  as q20 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=10979064) as q21 on
(q20.elementId=q21.elementId))  as q18 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=10755757) as q19 on
(q18.elementId=q19.elementId))  as q16 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=5865082) as q17 on
(q16.elementId=q17.elementId))  as q14 full outer join (select
elementId, 10979837 as userGroupId, 1 as grantFlags, 0 as denyflags
from simple_group where groupId=10758145) as q15 on
(q14.elementId=q15.elementId))  as q12 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=1718259) as q13 on
(q12.elementId=q13.elementId))  as q10 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=10755709) as q11 on
(q10.elementId=q11.elementId))  as q8 full outer join (select
elementId, 10979837 as userGroupId, 3 as grantFlags, 0 as denyflags
from simple_group where groupId=1718266) as q9 on
(q8.elementId=q9.elementId))  as q6 full outer join (select elementId,
10979837 as userGroupId, 3 as grantFlags, 0 as denyflags from
simple_group where groupId=1718273) as q7 on
(q6.elementId=q7.elementId))  as q4 full outer join (select elementId,
10979837 as userGroupId, 3 as grantFlags, 0 as denyflags from
simple_group where groupId=10965166) as q5 on
(q4.elementId=q5.elementId))  as q2 full outer join (select elementId,
10979837 as userGroupId, 1 as grantFlags, 0 as denyflags from
simple_group where groupId=10979069) as q3 on
(q2.elementId=q3.elementId))  as q0 full outer join (select elementId,
10979837 as userGroupId, 3 as grantFlags, 0 as denyflags from
simple_group where groupId=759234) as q1 on
(q0.elementId=q1.elementId)

2011-10-17 23:39:03 ERROR:  current transaction is aborted, commands
ignored until end of transaction block

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux