What does it mean "Dead Transaction"? How to avoid?

[erickroco9611]

Hi again...

I don´t know if this post would be better in DBA or Development, but I'm a developer so...

I was looking for some issues in my database with PROMON and I found that some Transactions has a flag as "DEAD".

The law (Progress) said:

"When the "Tran State" is DEAD it signifies the transaction is no longer active.

The transaction id is the one that existed previously when the transaction was active but no longer does.

Effectively, It means that the transaction table entry is now free and available for resuse by a new transaction.

This can often occur when record locks are acquired outside of a transaction."

Then... Should I take care about this!!???

How can I avoid this!!!?

Thanks in advance!

 

[TomBascom]

It indicates that, as a developer, you need to spend some quality time with the manuals, in online forums or with a programming mentor (or all of the above) learning about record, lock and transaction "scope" and how they interact.

 

[erickroco9611]

That´s what I'm doing!!! Thas is becouse I'm here!!!

Surely there would be someone else with this doubt! And I hope somebody had a clue about this!

But as I think: "Is more worthy do stupid questions (if you could think that) than be a stupid that no ask".

Thanks anyway!!! I respect you so much because you support this forum and its content!

 

[LarryD]

Tom wasn't indicating your question was "stupid"... just that the whole issue of scope (transaction, record, etc) and locking is more than can be learned on limited forums.

Manuals can give you a good grasp (read the Progress programmers manuals for one), but I still think the best book on explaning scope issues within Progress is John Campbell's "Making Good Progress" ( http://www.wss.com/publications/making_good_progress.html ).

You could also attend one of the training classes held by Progress, Bravepoint, and perhaps others (?).

OR... you could have someone like Tom or one of the other excellent Progress consultants come and give you some training!

 

[erickroco9611]

Ok!!! I got it!!!

So I think this kind of issue requires a deeper analysis. MAybe (as you said) of a specialist!

Altough it was a Software developed by myself , but it was growing so huge that possibly I lost some point.

I'll check the book that you recommend Larry!!!

Thanks!