Please Help Me...

Поиск
Список
Период
Сортировка
От Rafiqul Haque
Тема Please Help Me...
Дата
Msg-id CAM0ednMx0zCtgxhAgtSZPyj9oaKnA2oGk3ctQxBFNhohumGBiA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Please Help Me...  (Ian Lawrence Barwick <barwick@gmail.com>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Murthy Nunna
Дата:
Сообщение: Re: PITR
Следующее
От: Ian Lawrence Barwick
Дата:
Сообщение: Re: Please Help Me...