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
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 |