# Transaction Groups - unknown, db connections broken

**URL:** <https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055>\
**Category:** Ignition\
**Created:** [March 19, 2013, 2:25pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055 "2013-03-19T14:25:38Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [March 19, 2013, 2:25pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055/1 "2013-03-19T14:25:38Z")

</div>

I had an odd one last night.  
Most of my transaction groups suddenly went into an unknown state, 2 of my DB connections broke and wouldn’t reconnect, and some of my OPC-UA servers dropped.

Vision stuff kept working just fine…

whole wack of these error msgs

```auto

2013-03-18 9:01:05 PM	GetEndpoints TCPClientChannel UAChannel	Uncaught throwable while processing chunk.
 	
java.util.concurrent.RejectedExecutionException: Task java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask@12df8ef rejected from java.util.concurrent.ScheduledThreadPoolExecutor@1323350[Terminated, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 59]
	at java.util.concurrent.ThreadPoolExecutor$AbortPolicy.rejectedExecution(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.reject(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor.delayedExecute(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor.schedule(Unknown Source)
	at com.inductiveautomation.xopc.client.stack.TCPClientChannel.scheduleRenew(TCPClientChannel.java:429)
	at com.inductiveautomation.xopc.client.stack.TCPClientChannel.receiveMessage(TCPClientChannel.java:621)
	at com.inductiveautomation.xopc.common.stack.UAChannel.processAsymmetricChunk(UAChannel.java:1340)
	at com.inductiveautomation.xopc.common.stack.UAChannel.processChunk(UAChannel.java:808)
	at com.inductiveautomation.xopc.common.stack.UAChannel.access$000(UAChannel.java:66)
	at com.inductiveautomation.xopc.common.stack.UAChannel$ProcessChunk.run(UAChannel.java:1623)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
```

Restarting Ignition cleared it, but I’d like to know the root cause.

---

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [March 19, 2013, 2:35pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055/2 "2013-03-19T14:35:37Z")

</div>

System Specs

Windows 2003 R2 SP2  
4GB Ram  
Java 7.17

Ignition 7.5.6

Also attached are the wrapper.log and logs.bin files.  
[logs.zip](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b926f3e34fc6b0f53369d6fce6c6b93fd983ff92.zip) (710 KB)

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 19, 2013, 3:17pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055/3 "2013-03-19T15:17:45Z")

</div>

Can you tell me the full version and build number of the UA module you have installed?

My guess is that you have 1.5.6 b520, which means you grabbed the botched release that accidentally got uploaded, which included a UA module cut from a development branch. It had a memory leak, which is probably what caused the problems you’re seeing.

If that’s the case, you can grab the correct UA module from the current downloads page.

---

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [March 19, 2013, 4:49pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055/4 "2013-03-19T16:49:42Z")

</div>

Kevin:

According to the version number I have 1.5.6(b517)

-Mike

---

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [March 19, 2013, 5:00pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055/5 "2013-03-19T17:00:25Z")

</div>

I grabbed the one from the website and updated it anyhow, Same version number in Ignition though.

Which brings up a minor point, I also grabbed the SQL bridge module as I noticed the site listed the latest as b252, but that installed as b249(which I had from the upgrade already)?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 19, 2013, 5:48pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055/6 "2013-03-19T17:48:08Z")

</div>

You’ve definitely got something weird going on. Your log is full of these messages:

```auto
 WARN [TCPServerChannel] [09:06:44,726]: Connection lost due to IOException.
```

This is the OPC-UA server indicating that a client TCP connection has closed (uncleanly). It’s happening ~15 seconds in your logs. If your regular “loopback” connection is connected and functioning, this would seem to indicate you’ve got some other UA client attempting to connect regularly and probably failing for whatever reason.

Are you handy with Wireshark?

---

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [March 19, 2013, 9:10pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-unknown-db-connections-broken/6055/7 "2013-03-19T21:10:07Z")

</div>

Kevin:

Yeah, Wireshark and I are buddies.

-Mike

edit:  
Cleared that error, It was a Kepware install on the Ignition box itself.
