Lock Table Full Error !!!

[Yashpal Singh]

Hi Gud Mrng/Evng ,

To process a large file upto 4.5 GB with 100K HL7 messages , each message with around 270 segments, I am parsing the stream , and also have use TRANSACTION to process all the message. But some where in the middle I got a System error "Lock Table Full".I did some research on it and found the "Maximum Per-Process Memory(KB)" is set to 262144, which is default I believe. I am just wondering of increasing the size. Will it affect the performance or any other impact on the system ?? Or is there any other way around to achieve the functionality.

Any help will be really appreciated !!!

Thanks-

Yash

[OldMster]

No, process memory is not the lock table.   Somewhere in your code, a lock is being set for each message, and is not being released.  If you are trying to use 1 transaction to process all 100k HL7 messages, that is bad practice.  Each message should be a transaction.  Transactions are not meant to be 100k items in one transaction.

Mark

[Anil Mathew]

Yash

The lock table full, usually happens if you have a huge transaction processing like insert of update with TStart and TCommit.  Look at the code as well. You can find which process is locking from Home]> [Locks].

 

You can increase the locksize allocation by editing.

Home]> [Configuration]> [Advanced Memory Settings]  

Locksiz

Anill

--
--
Caché, Ensemble, DeepSee

---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 11507P (20150421) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

[Dmitry Maslennikov]

locksiz - Maximum size of shared memory for locks.
Size (in bytes) of memory allocated for locks. The system rounds up the value to the next multiple of 64 kilobytes. The default is 1179648 bytes. 
http://docs.intersystems.com/cache20151/csp/docbook/DocBook.UI.Page.cls?KEY=RCPF_locksiz

вт, 21 апр 2015 г., 7:41, Anil Mathew <Anil....@fiestasystems.com>: