Обсуждение: Please Help Me...
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
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
2014-02-26 17:48 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>: > 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 What is your server's shared_buffers setting? And which version of PostgreSQL are you using? I.e. output of these statements: SHOW shared_buffers; SELECT version(); Regards Ian Barwick
2014-02-26 19:39 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>: > Hi, > > Thanks very much for prompt response. I executed the commands you suggested. Please don't forget to CC the original mailing list, because more people will be able to help you. > Shared buffer is 128MB (I did know that, I thought it is taking all my GB > automatically !!!!) > > The version is 9.3.2 128MB is the default setting for shared_buffers and is very low. You'll need to adjust that and some other settings (especially work_mem and maintenance_work_mem) appropriately for your system. See e.g.: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server Regards Ian Barwick > Cheers, > > > On Wed, Feb 26, 2014 at 9:57 AM, Ian Lawrence Barwick <barwick@gmail.com> > wrote: >> >> 2014-02-26 17:48 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>: >> > 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 >> >> What is your server's shared_buffers setting? And which version of >> PostgreSQL >> are you using? I.e. output of these statements: >> >> SHOW shared_buffers; >> SELECT version(); >> >> Regards >> >> Ian Barwick > >
2014-02-26 20:35 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>: > Thanks a lot Ian.. I figured out that as well... I am trying to figure out > how many tables my server can create … Why not try for a billion? http://www.pgcon.org/2013/schedule/events/595.en.html ;) Regards Ian Barwick > > On Wed, Feb 26, 2014 at 12:20 PM, Ian Lawrence Barwick <barwick@gmail.com> > wrote: >> >> 2014-02-26 19:39 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>: >> > Hi, >> > >> > Thanks very much for prompt response. I executed the commands you >> > suggested. >> >> Please don't forget to CC the original mailing list, because more people >> will >> be able to help you. >> >> > Shared buffer is 128MB (I did know that, I thought it is taking all my >> > GB >> > automatically !!!!) >> > >> > The version is 9.3.2 >> >> 128MB is the default setting for shared_buffers and is very low. >> You'll need to adjust >> that and some other settings (especially work_mem and >> maintenance_work_mem) >> appropriately for your system. See e.g.: >> >> http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server >> >> Regards >> >> Ian Barwick >> >> >> >> > Cheers, >> > >> > >> > On Wed, Feb 26, 2014 at 9:57 AM, Ian Lawrence Barwick >> > <barwick@gmail.com> >> > wrote: >> >> >> >> 2014-02-26 17:48 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>: >> >> > 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 >> >> >> >> What is your server's shared_buffers setting? And which version of >> >> PostgreSQL >> >> are you using? I.e. output of these statements: >> >> >> >> SHOW shared_buffers; >> >> SELECT version(); >> >> >> >> Regards >> >> >> >> Ian Barwick >> > >> > > >