Please Help Me...

From: Rafiqul Haque <rafiq(dot)ced(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Please Help Me...
Date: 2014-02-26 08:48:30
Message-ID: CAM0ednMx0zCtgxhAgtSZPyj9oaKnA2oGk3ctQxBFNhohumGBiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am confronting this error (I pasted below). It gives a hint to increase
"You might need to increase max_locks_per_transaction" which I did but get
the same error .... please please suggest me something to get rid of this
error.. I would really be grateful..

My script create 13000 empty tables. Each table contains 130 attributes...

My server has 8 GB RAM 64 bit processor, running windows 7 OS

Best regards,
Rafiq

********************************* *Error*
***********************************************************************************************************************

WARNING: out of shared memory
CONTEXT: SQL statement "CREATE TABLE table3691 (cust_id
integer,archiveexpiration date,archivedatetime timestamp,archivepurge
date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount
TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime
timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost
integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state
integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time
timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible
integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration
integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice
integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged
integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn
integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport
integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb
text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent
integer,groupkey text,isbillable text,retrievedbyclient
text,billing_summary text,parentprocessid text,processid text,rcv_date_time
timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed
integer,forwardcancelled integer,forwarderror
integer,forwardvalidationopending integer,needvalid integer,preferredvalid
text,sendtype text,srcfilename text,al_templateinstance
integer,al_templateinstancepostcover integer,al_numpage
integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid
text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields
integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation
integer,docid text,department text,flowid text,satid text,lbserver
text,dist_file integer,writablewhencomplete integer,donotpurge
integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split
integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber
integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment
integer,toto text,supplementaryrule text,iscclose
integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE
statement
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
CONTEXT: SQL statement "CREATE TABLE table3691 (cust_id
integer,archiveexpiration date,archivedatetime timestamp,archivepurge
date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount
TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime
timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost
integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state
integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time
timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible
integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration
integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice
integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged
integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn
integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport
integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb
text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent
integer,groupkey text,isbillable text,retrievedbyclient
text,billing_summary text,parentprocessid text,processid text,rcv_date_time
timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed
integer,forwardcancelled integer,forwarderror
integer,forwardvalidationopending integer,needvalid integer,preferredvalid
text,sendtype text,srcfilename text,al_templateinstance
integer,al_templateinstancepostcover integer,al_numpage
integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid
text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields
integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation
integer,docid text,department text,flowid text,satid text,lbserver
text,dist_file integer,writablewhencomplete integer,donotpurge
integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split
integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber
integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment
integer,toto text,supplementaryrule text,iscclose
integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE
statement
********** Error **********

ERROR: out of shared memory
SQL state: 53200
Hint: You might need to increase max_locks_per_transaction.
Context: SQL statement "CREATE TABLE table3691 (cust_id
integer,archiveexpiration date,archivedatetime timestamp,archivepurge
date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount
TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime
timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost
integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state
integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time
timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible
integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration
integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice
integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged
integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn
integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport
integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb
text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent
integer,groupkey text,isbillable text,retrievedbyclient
text,billing_summary text,parentprocessid text,processid text,rcv_date_time
timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed
integer,forwardcancelled integer,forwarderror
integer,forwardvalidationopending integer,needvalid integer,preferredvalid
text,sendtype text,srcfilename text,al_templateinstance
integer,al_templateinstancepostcover integer,al_numpage
integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid
text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields
integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation
integer,docid text,department text,flowid text,satid text,lbserver
text,dist_file integer,writablewhencomplete integer,donotpurge
integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split
integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber
integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment
integer,toto text,supplementaryrule text,iscclose
integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE
statement

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Lawrence Barwick 2014-02-26 08:57:57 Re: Please Help Me...
Previous Message Murthy Nunna 2014-02-26 05:33:07 Re: PITR