Upon starting our system server, the tables which are having partitions upon them(Range paritioning in postgres) are getting locked(in a way that SELECT query is still fetching output from them) but there are some ALTER statements which are getting stuck and not getting performed. There is a process running on our server instance at any given time. Upon restarting this process from the console is getting the lock removed from those partitioned tables.
Also, various libraries are used for this process among which mainly are for regexp matching, load configuration attributes, load currencies from the database, load GL codes, load reference types, get database table information, load entities.
Any help or suggestions would be appreciated.
Thanks, Rohit
