TACTIC Open Source
I am using python api to add datas to tactic but have some errors - Printable Version

+- TACTIC Open Source (http://forum.southpawtech.com)
+-- Forum: TACTIC Open Source (http://forum.southpawtech.com/forumdisplay.php?fid=3)
+--- Forum: TACTIC Discussion (http://forum.southpawtech.com/forumdisplay.php?fid=4)
+--- Thread: I am using python api to add datas to tactic but have some errors (/showthread.php?tid=42)



I am using python api to add datas to tactic but have some errors - EricTsuei - 12-05-2019

I am using python api to add datas to tactic but have some errors
I added lots of datas,  about 5000+ datas.
So give me this error, need to increase max_locks_per_transaction.
so, where can I do this ?



xmlrpclib.Fault: <Fault 1: 'out of shared memory\nHINT:  You might need to increase max_locks_per_transaction.\n'>


RE: I am using python api to add datas to tactic but have some errors - Celton McGrath - 12-05-2019

Hi Eric,

In the Postgres configuration file, usually found at /var/lib/pgsql/data/postgresql.conf, there is a line for max_locks_per_transaction.

You can change this line, and restart the Postgres service.

Well it's possible that you are in fact pushing the limits of data management, we rarely see this error while working with large amounts of data ourselves.

I am wondering what API methods you are using, and how you are using them. There might be a more efficient way to do the same task.

Best,

Celton


RE: I am using python api to add datas to tactic but have some errors - EricTsuei - 12-06-2019

We are developing an editor to batch manage tactic datas. we are using python and javascript API to get and set data.


RE: I am using python api to add datas to tactic but have some errors - listy - 12-06-2019

(12-06-2019, 11:23 AM)EricTsuei Wrote: We are developing an editor to batch manage tactic datas. we are using python and javascript API to get and set data.
You can post here part of code, or full stack trace, without it no one can repeat or fix this.