Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 692A3E6C6 for ; Sat, 9 Feb 2013 01:50:23 +0000 (UTC) Received: (qmail 72127 invoked by uid 500); 9 Feb 2013 01:50:20 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 72075 invoked by uid 500); 9 Feb 2013 01:50:20 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 72067 invoked by uid 99); 9 Feb 2013 01:50:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Feb 2013 01:50:20 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lsshiu@gmail.com designates 209.85.219.51 as permitted sender) Received: from [209.85.219.51] (HELO mail-oa0-f51.google.com) (209.85.219.51) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Feb 2013 01:50:13 +0000 Received: by mail-oa0-f51.google.com with SMTP id h2so4709796oag.10 for ; Fri, 08 Feb 2013 17:49:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=XuKjmIjLuvGsM51Wj85sVmOvyOQrES+R1CVE87+DHPQ=; b=EDnHQ43ebZJFqr8KgLaWLalOiLyCCq35jvzYGrKESyPkvsKywxZ1gsE+ox8KGuULiW 58bcxENCE0kdo6xSCxSKJRFezGhVa4jIb7wkxUNiWoEL5lqzBQsQGfqufV6qKV+M+tw+ XmdLj0JJtrOv0oYDIOYCrsjBHSADCMVJTpC2Iis5NkY1ghuBmwazzOlTRTGNaK8DGIJx ZT60Q52mxkgjzS+SqVJImC0TuhEzbHQOETkmWdwyUBB4DjS8h19DRwmFysUtkEoZc6zW UI+D6tChxYVk35wuS/C85a0X0UwuxEJEm81FPv5pxztWkZ2oRG3zahtIP9OAIh46UhUn mHwA== MIME-Version: 1.0 X-Received: by 10.60.32.50 with SMTP id f18mr5913516oei.8.1360374592336; Fri, 08 Feb 2013 17:49:52 -0800 (PST) Received: by 10.76.21.231 with HTTP; Fri, 8 Feb 2013 17:49:52 -0800 (PST) In-Reply-To: References: <1E9AE4FE-E3A2-49D3-8A26-7520656C6ACC@gmail.com> Date: Sat, 9 Feb 2013 09:49:52 +0800 Message-ID: Subject: Re: HBase insert slow From: =?Big5?B?rn2++rKx?= To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=e89a8fb1f82056717904d540e41c X-Virus-Checked: Checked by ClamAV on apache.org --e89a8fb1f82056717904d540e41c Content-Type: text/plain; charset=Big5 Content-Transfer-Encoding: quoted-printable Actually I tried in two different environments with the same configuration except cluster A is the production env with more than 30 nodes and Cluster B is testing environment with 6 nodes. Performance is ok in testing environment but it's relative bad in production environment (4 times slower). Cluster A has more than 10000 regions and more than 30TB of data already in HBase but Cluster B is an empty one. It seems that the data size already put in HBase will impact the put performance. That's why I did some test and turn on DEBUG to see what actually slow down the insert performance. With 2 log files comparison, the Cluster A's issue is as my previous post. 2013/2/9 Mohammad Tariq > Could you please show your hbase-site.xml? Also, try the basic tweaks lik= e > usign putlist instead of put, turning wal off(if it is fine with you) etc= . > > Warm Regards, > Tariq > https://mtariq.jux.com/ > cloudfront.blogspot.com > > > On Fri, Feb 8, 2013 at 10:08 PM, Mesika, Asaf > wrote: > > > What's the rate you're getting (MB/sec or lines/sec)? > > What's your cluster setup? > > > > On Feb 8, 2013, at 6:23 PM, =AE}=BE=FA=B2=B1 wrote: > > > > > Hi, > > > I recently suffered HBase insert slow issue (read from mysql, > process > > > and then insert into HBase). The partial DEBUG log as below. It looks > > that > > > most of the time were spent near "Cached location" and "Got ping > response > > > for sessionid". Is there any way to improve the performance ? Thanks > > > I tried HTable and HTablePool, both showed the similiar result. > > > > > > [13/02/08 08:59:07:106][][DEBUG]Call: next 2 > > > [13/02/08 08:59:11:619][][DEBUG]Cached location for > > > TABLE2_IDX01,,1355799947553.1a08e9f6c702b56d3dc839b83ce86124. is > > > 10.39.128.126:60020 > > > ... > > > ... > > > [13/02/08 08:59:16:180][][DEBUG]Call: next 2 > > > [13/02/08 08:59:19:298][][DEBUG]Got ping response for sessionid: > > > 0x13c4449defa5228 after 0ms > > > > > > > > > Detail Log as below > > > > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > > > > > [13/02/08 08:58:25:863][][INFO]Initiating client connection, > > > connectString=3DSERVER1:2181 sessionTimeout=3D180000 watcher=3Dhconne= ction > > > [13/02/08 08:58:25:866][][DEBUG]zookeeper.disableAutoWatchReset is > false > > > [13/02/08 08:58:25:907][][INFO]Opening socket connection to server > > SERVER1/ > > > 10.39.128.115:2181 > > > [13/02/08 08:58:25:910][][INFO]Socket connection established to > SERVER1/ > > > 10.39.128.115:2181, initiating session > > > [13/02/08 08:58:25:912][][DEBUG]Session establishment request sent on > > > SERVER1/10.39.128.115:2181 > > > [13/02/08 08:58:25:917][][INFO]Session establishment complete on serv= er > > > SERVER1/10.39.128.115:2181, sessionid =3D 0x13c4449defa5228, negotiat= ed > > > timeout =3D 40000 > > > > > > [13/02/08 08:58:30:581][][DEBUG]Lookedup root region location, > > > > > > connection=3Dorg.apache.hadoop.hbase.client.HConnectionManager$HConnectio= nImplementation@1df2964 > > ; > > > hsa=3D10.39.128.152:60020 > > > [13/02/08 08:58:30:664][][DEBUG]The ping interval is60000ms. > > > [13/02/08 08:58:30:729][][DEBUG]Connecting to > > > 10.39.128.152/10.39.128.152:60020 > > > [13/02/08 08:58:30:757][][DEBUG]IPC Client (47) connection to > > > 10.39.128.152/10.39.128.152:60020 from an unknown user sending #0 > > > [13/02/08 08:58:30:827][][DEBUG]IPC Client (47) connection to > > > 10.39.128.152/10.39.128.152:60020 from an unknown user: starting, > having > > > connections 1 > > > [13/02/08 08:58:30:836][][DEBUG]IPC Client (47) connection to > > > 10.39.128.152/10.39.128.152:60020 from an unknown user got value #0 > > > [13/02/08 08:58:30:837][][DEBUG]Call: getProtocolVersion 117 > > > [13/02/08 08:58:30:838][][DEBUG]IPC Client (47) connection to > > > 10.39.128.152/10.39.128.152:60020 from an unknown user sending #1 > > > [13/02/08 08:58:30:846][][DEBUG]IPC Client (47) connection to > > > 10.39.128.152/10.39.128.152:60020 from an unknown user got value #1 > > > [13/02/08 08:58:30:848][][DEBUG]Call: getClosestRowBefore 10 > > > [13/02/08 08:58:35:396][][DEBUG]Cached location for > .META.,,1.1028785192 > > is > > > 10.39.128.158:60020 > > > [13/02/08 08:58:35:398][][DEBUG]Connecting to > > > 10.39.128.158/10.39.128.158:60020 > > > [13/02/08 08:58:35:399][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #2 > > > [13/02/08 08:58:35:399][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user: starting, > having > > > connections 2 > > > [13/02/08 08:58:35:401][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #2 > > > [13/02/08 08:58:35:401][][DEBUG]Call: getProtocolVersion 3 > > > [13/02/08 08:58:35:417][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #3 > > > [13/02/08 08:58:35:420][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #3 > > > [13/02/08 08:58:35:420][][DEBUG]Call: getClosestRowBefore 3 > > > [13/02/08 08:58:35:422][][DEBUG]Scanning .META. starting at > > > row=3DTABLE1,,00000000000000 for max=3D10 rows > > > [13/02/08 08:58:35:423][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #4 > > > [13/02/08 08:58:35:425][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #4 > > > [13/02/08 08:58:35:425][][DEBUG]Call: openScanner 2 > > > [13/02/08 08:58:35:426][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #5 > > > [13/02/08 08:58:35:428][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #5 > > > [13/02/08 08:58:35:429][][DEBUG]Call: next 3 > > > [13/02/08 08:58:39:298][][DEBUG]Got ping response for sessionid: > > > 0x13c4449defa5228 after 1ms > > > [13/02/08 08:58:39:944][][DEBUG]Cached location for > > > TABLE1,,1355799993197.a450d2725873a369896e123b57d30394. is > > > 10.39.128.157:60020 > > > [13/02/08 08:58:39:945][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #6 > > > [13/02/08 08:58:39:947][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #6 > > > [13/02/08 08:58:39:947][][DEBUG]Call: close 2 > > > [13/02/08 08:58:39:948][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:58:39:948][][INFO]|||TABLE1 table connectted||| > > > > > > [13/02/08 08:58:39:950][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #7 > > > [13/02/08 08:58:39:952][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #7 > > > [13/02/08 08:58:39:952][][DEBUG]Call: getClosestRowBefore 2 > > > [13/02/08 08:58:39:952][][DEBUG]Scanning .META. starting at > > > row=3DTABLE1_IDX01,,00000000000000 for max=3D10 rows > > > [13/02/08 08:58:39:953][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #8 > > > [13/02/08 08:58:39:954][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #8 > > > [13/02/08 08:58:39:955][][DEBUG]Call: openScanner 2 > > > [13/02/08 08:58:39:955][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #9 > > > [13/02/08 08:58:39:958][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #9 > > > [13/02/08 08:58:39:959][][DEBUG]Call: next 4 > > > [13/02/08 08:58:40:842][][DEBUG]IPC Client (47) connection to > > > 10.39.128.152/10.39.128.152:60020 from an unknown user: closed > > > [13/02/08 08:58:40:842][][DEBUG]IPC Client (47) connection to > > > 10.39.128.152/10.39.128.152:60020 from an unknown user: stopped, > > remaining > > > connections 1 > > > [13/02/08 08:58:44:473][][DEBUG]Cached location for > > > TABLE1_IDX01,,1355800019797.8e17ef64357c7161ee3f18bc270d7080. is > > > 10.39.128.154:60020 > > > [13/02/08 08:58:44:474][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #10 > > > [13/02/08 08:58:44:477][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #10 > > > [13/02/08 08:58:44:477][][DEBUG]Call: close 3 > > > [13/02/08 08:58:44:477][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:58:44:478][][INFO]|||TABLE1_IDX01 table connectted||| > > > > > > [13/02/08 08:58:44:478][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #11 > > > [13/02/08 08:58:44:481][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #11 > > > [13/02/08 08:58:44:482][][DEBUG]Call: getClosestRowBefore 4 > > > [13/02/08 08:58:44:483][][DEBUG]Scanning .META. starting at > > > row=3DTABLE1_IDX02,,00000000000000 for max=3D10 rows > > > [13/02/08 08:58:44:483][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #12 > > > [13/02/08 08:58:44:485][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #12 > > > [13/02/08 08:58:44:485][][DEBUG]Call: openScanner 2 > > > [13/02/08 08:58:44:486][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #13 > > > [13/02/08 08:58:44:488][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #13 > > > [13/02/08 08:58:44:488][][DEBUG]Call: next 2 > > > [13/02/08 08:58:48:990][][DEBUG]Cached location for > > > TABLE1_IDX02,,1355800053647.aead27ec424ab5f51a357b84911e0083. is > > > 10.39.128.158:60020 > > > [13/02/08 08:58:48:991][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #14 > > > [13/02/08 08:58:48:993][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #14 > > > [13/02/08 08:58:48:994][][DEBUG]Call: close 3 > > > [13/02/08 08:58:48:994][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:58:48:994][][INFO]|||TABLE1_IDX02 table connectted||| > > > > > > [13/02/08 08:58:48:995][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #15 > > > [13/02/08 08:58:48:997][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #15 > > > [13/02/08 08:58:48:998][][DEBUG]Call: getClosestRowBefore 3 > > > [13/02/08 08:58:48:999][][DEBUG]Scanning .META. starting at > > > row=3DTABLE1_ETL01,,00000000000000 for max=3D10 rows > > > [13/02/08 08:58:48:999][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #16 > > > [13/02/08 08:58:49:001][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #16 > > > [13/02/08 08:58:49:002][][DEBUG]Call: openScanner 3 > > > [13/02/08 08:58:49:002][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #17 > > > [13/02/08 08:58:49:004][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #17 > > > [13/02/08 08:58:49:004][][DEBUG]Call: next 2 > > > [13/02/08 08:58:52:630][][DEBUG]Got ping response for sessionid: > > > 0x13c4449defa5228 after 0ms > > > [13/02/08 08:58:53:519][][DEBUG]Cached location for > > > TABLE1_ETL01,,1355800075109.cda29c57df059ae43aea28d9db2bc804. is > > > 10.39.128.181:60020 > > > [13/02/08 08:58:53:520][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #18 > > > [13/02/08 08:58:53:524][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #18 > > > [13/02/08 08:58:53:524][][DEBUG]Call: close 4 > > > [13/02/08 08:58:53:525][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:58:53:525][][INFO]|||TABLE1_ETL01 table connectted||| > > > > > > [13/02/08 08:58:53:526][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #19 > > > [13/02/08 08:58:53:528][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #19 > > > [13/02/08 08:58:53:528][][DEBUG]Call: getClosestRowBefore 2 > > > [13/02/08 08:58:53:529][][DEBUG]Scanning .META. starting at > > > row=3DTABLE2,,00000000000000 for max=3D10 rows > > > [13/02/08 08:58:53:529][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #20 > > > [13/02/08 08:58:53:531][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #20 > > > [13/02/08 08:58:53:531][][DEBUG]Call: openScanner 2 > > > [13/02/08 08:58:53:531][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #21 > > > [13/02/08 08:58:53:533][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #21 > > > [13/02/08 08:58:53:533][][DEBUG]Call: next 2 > > > [13/02/08 08:58:58:046][][DEBUG]Cached location for > > > TABLE2,,1358205765301.c39f34efaf160e4a880433a29e581965. is > > > 10.39.128.155:60020 > > > [13/02/08 08:59:02:549][][DEBUG]Cached location for > > > > > > TABLE2,PNV430.06~|0885.120~|EECRDJ~|T7~|2013010612525660~|,1359580390186.= 7e17ffb2d989b7394f3ef73ece99e7ea. > > > is 10.39.128.158:60020 > > > [13/02/08 08:59:03:529][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user: closed > > > [13/02/08 08:59:03:529][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user: stopped, > > remaining > > > connections 0 > > > [13/02/08 08:59:05:965][][DEBUG]Got ping response for sessionid: > > > 0x13c4449defa5228 after 0ms > > > [13/02/08 08:59:07:067][][DEBUG]Cached location for > > > > > > TABLE2,PNX540.08~|2545.060~|EECRDJ~|T3~|2013011117012443~|,1359580390186.= 17f558f32541fd86d6ab7a96540215e4. > > > is 10.39.128.158:60020 > > > [13/02/08 08:59:07:068][][DEBUG]Connecting to > > > 10.39.128.158/10.39.128.158:60020 > > > [13/02/08 08:59:07:070][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #22 > > > [13/02/08 08:59:07:076][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user: starting, > having > > > connections 1 > > > [13/02/08 08:59:07:077][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #22 > > > [13/02/08 08:59:07:078][][DEBUG]Call: close 10 > > > [13/02/08 08:59:07:078][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:59:07:083][][INFO]|||TABLE2 table connectted||| > > > > > > [13/02/08 08:59:07:098][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #23 > > > [13/02/08 08:59:07:101][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #23 > > > [13/02/08 08:59:07:101][][DEBUG]Call: getClosestRowBefore 3 > > > [13/02/08 08:59:07:101][][DEBUG]Scanning .META. starting at > > > row=3DTABLE2_IDX01,,00000000000000 for max=3D10 rows > > > [13/02/08 08:59:07:102][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #24 > > > [13/02/08 08:59:07:103][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #24 > > > [13/02/08 08:59:07:104][][DEBUG]Call: openScanner 2 > > > [13/02/08 08:59:07:104][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #25 > > > [13/02/08 08:59:07:105][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #25 > > > [13/02/08 08:59:07:106][][DEBUG]Call: next 2 > > > [13/02/08 08:59:11:619][][DEBUG]Cached location for > > > TABLE2_IDX01,,1355799947553.1a08e9f6c702b56d3dc839b83ce86124. is > > > 10.39.128.126:60020 > > > [13/02/08 08:59:11:622][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #26 > > > [13/02/08 08:59:11:624][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #26 > > > [13/02/08 08:59:11:625][][DEBUG]Call: close 3 > > > [13/02/08 08:59:11:625][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:59:11:626][][INFO]|||TABLE2_IDX01 table connectted||| > > > > > > [13/02/08 08:59:11:627][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #27 > > > [13/02/08 08:59:11:629][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #27 > > > [13/02/08 08:59:11:629][][DEBUG]Call: getClosestRowBefore 2 > > > [13/02/08 08:59:11:630][][DEBUG]Scanning .META. starting at > > > row=3DTABLE2_ETL01,,00000000000000 for max=3D10 rows > > > [13/02/08 08:59:11:630][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #28 > > > [13/02/08 08:59:11:632][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #28 > > > [13/02/08 08:59:11:633][][DEBUG]Call: openScanner 2 > > > [13/02/08 08:59:11:633][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #29 > > > [13/02/08 08:59:11:635][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #29 > > > [13/02/08 08:59:11:635][][DEBUG]Call: next 2 > > > [13/02/08 08:59:16:147][][DEBUG]Cached location for > > > TABLE2_ETL01,,1355799966042.7811665d93bf6fe3ab301dc31f1804b9. is > > > 10.39.128.157:60020 > > > [13/02/08 08:59:16:148][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #30 > > > [13/02/08 08:59:16:150][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #30 > > > [13/02/08 08:59:16:151][][DEBUG]Call: close 3 > > > [13/02/08 08:59:16:151][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:59:16:171][][INFO]|||TABLE2_ETL01 table connectted||| > > > > > > [13/02/08 08:59:16:172][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #31 > > > [13/02/08 08:59:16:174][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #31 > > > [13/02/08 08:59:16:174][][DEBUG]Call: getClosestRowBefore 2 > > > [13/02/08 08:59:16:175][][DEBUG]Scanning .META. starting at > > > row=3DTABLE3_LOG,,00000000000000 for max=3D10 rows > > > [13/02/08 08:59:16:175][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #32 > > > [13/02/08 08:59:16:177][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #32 > > > [13/02/08 08:59:16:177][][DEBUG]Call: openScanner 2 > > > [13/02/08 08:59:16:178][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #33 > > > [13/02/08 08:59:16:180][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #33 > > > [13/02/08 08:59:16:180][][DEBUG]Call: next 2 > > > [13/02/08 08:59:19:298][][DEBUG]Got ping response for sessionid: > > > 0x13c4449defa5228 after 0ms > > > [13/02/08 08:59:20:696][][DEBUG]Cached location for > > > TABLE3_LOG,,1355800084011.0a1003305c755e8d1c6c0b98f9a56214. is > > > 10.39.128.128:60020 > > > [13/02/08 08:59:20:697][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user sending #34 > > > [13/02/08 08:59:20:699][][DEBUG]IPC Client (47) connection to > > > 10.39.128.158/10.39.128.158:60020 from an unknown user got value #34 > > > [13/02/08 08:59:20:699][][DEBUG]Call: close 2 > > > [13/02/08 08:59:20:700][][DEBUG]The connection to > > > hconnection-0x13c4449defa5228 has been closed. > > > [13/02/08 08:59:20:700][][INFO]|||TABLE3_LOG table connectted||| > > > > > > [13/02/08 08:59:20:730][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:20:874][][DEBUG]incremented pending_acquires: 1 > > > [13/02/08 08:59:20:874][][DEBUG]Starting acquisition series. > Incremented > > > pending_acquires [1], attempts_remaining: 10 > > > [13/02/08 > > > > > > 08:59:20:875][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@24c414 > > > [13/02/08 08:59:20:875][][DEBUG]incremented pending_acquires: 2 > > > [13/02/08 08:59:20:876][][DEBUG]Starting acquisition series. > Incremented > > > pending_acquires [2], attempts_remaining: 10 > > > [13/02/08 > > > > > > 08:59:20:876][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1c4ff2= c > > > [13/02/08 08:59:20:877][][DEBUG]incremented pending_acquires: 3 > > > [13/02/08 08:59:20:877][][DEBUG]Starting acquisition series. > Incremented > > > pending_acquires [3], attempts_remaining: 10 > > > [13/02/08 > > > > > > 08:59:20:878][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4ca6b6 > > > [13/02/08 > > > > > > 08:59:20:879][][DEBUG]com.mchange.v2.resourcepool.BasicResourcePool@552a2= bconfig > > : > > > [start -> 3; min -> 3; max -> 2; inc -> 3; num_acq_attempts -> 10; > > > acq_attempt_delay -> 1000; check_idle_resources_delay -> 10000; > > > mox_resource_age -> 0; max_idle_time -> 0; excess_max_idle_time -> 0; > > > destroy_unreturned_resc_time -> 0; expiration_enforcement_delay -> 0; > > > break_on_acquisition_failure -> false; debug_store_checkout_exception= s > -> > > > false] > > > [13/02/08 08:59:20:880][][DEBUG]acquire test -- pool size: 0; > > > target_pool_size: 3; desired target? 1 > > > [13/02/08 08:59:20:880][][DEBUG]awaitAvailable(): [unknown] > > > [13/02/08 08:59:20:881][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 0, > > unused: > > > 0, excluded: 0] > > > [13/02/08 08:59:21:442][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:443][][DEBUG]com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1= PooledConnectionResourcePoolManager@166c114.acquireResource > > () > > > returning. > > > [13/02/08 08:59:21:444][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 1, > > unused: > > > 1, excluded: 0] > > > [13/02/08 08:59:21:445][][DEBUG]decremented pending_acquires: 2 > > > [13/02/08 08:59:21:445][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 1, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:468][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:477][][DEBUG]Acquisition series terminated > > successfully. > > > Decremented pending_acquires [2], attempts_remaining: 10 > > > [13/02/08 08:59:21:443][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:478][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:480][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@490342 > > > [13/02/08 08:59:21:480][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 1, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:481][][INFO]|||Start data pumping for context > > ID:122592 > > > in threadID: 0||| > > > > > > [13/02/08 08:59:21:482][][DEBUG]acquire test -- pool size: 1; > > > target_pool_size: 3; desired target? 2 > > > [13/02/08 08:59:21:482][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:483][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 1, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 > > > > > > 08:59:21:483][][DEBUG]com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1= PooledConnectionResourcePoolManager@166c114.acquireResource > > () > > > returning. > > > [13/02/08 08:59:21:484][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 1, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:484][][DEBUG]decremented pending_acquires: 1 > > > [13/02/08 08:59:21:485][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:487][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:487][][DEBUG]Acquisition series terminated > > successfully. > > > Decremented pending_acquires [1], attempts_remaining: 10 > > > [13/02/08 08:59:21:484][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:488][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:489][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1de0c09 > > > [13/02/08 08:59:21:490][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:490][][DEBUG]Executing SQL query [SELECT > > m.MESContextID, > > > m.TechnologyName, m.StageName, m.RouteName, m.ProductName, > > m.OperationName, > > > m.Aux1, m.Aux2, m.LotName, m.WaferName FROM pcb.contexthistory c, > > > pcb.mesassociation a, pcb.mescontexthistory m WHERE c.ContextID =3D > > > a.ContextID AND a.MESContextID =3D m.MESContextID AND c.Context= ID =3D > > > 122592 AND c.EquipmentID =3D 'TSI2' ] > > > [13/02/08 08:59:21:491][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:491][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:492][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:492][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:492][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:494][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:494][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:495][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@6c5356 > > > [13/02/08 08:59:21:495][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:496][][DEBUG]Executing SQL query [SELECT i.Label, > > > t.Value, i.IndicatorID FROM pcb.treateddatahistory t, pcb.indicator = i > > > WHERE t.IndicatorID =3D i.IndicatorID AND t.ContextID =3D 122592 = AND > > > i.StrategyID =3D '40E4231013817AA7-61C3A408' ] > > > [13/02/08 08:59:21:497][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:497][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:497][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:497][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:498][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:498][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:544][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:545][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:545][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1b83048 > > > [13/02/08 08:59:21:546][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:547][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28707] > > > [13/02/08 08:59:21:547][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:548][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:548][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:548][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:549][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:549][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:551][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:551][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:552][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@9bc984 > > > [13/02/08 08:59:21:552][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:553][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > 'Max(CH_A > > > Recipe Loop Number)'] > > > [13/02/08 08:59:21:553][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:553][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:554][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:554][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:554][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:555][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:556][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:557][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:557][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1429cb2 > > > [13/02/08 08:59:21:558][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:558][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28708] > > > [13/02/08 08:59:21:558][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:559][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:559][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:560][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:560][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:560][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:561][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:561][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:561][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1257687 > > > [13/02/08 08:59:21:562][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:562][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > 'Max(CH_A > > > Recipe Loop Number)-(1)'] > > > [13/02/08 08:59:21:563][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:563][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:563][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:563][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:564][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:564][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:564][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:564][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:565][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1e8fa70 > > > [13/02/08 08:59:21:565][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:566][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28709] > > > [13/02/08 08:59:21:566][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:567][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:567][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:573][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:573][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:574][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:575][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:575][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:575][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@58213c > > > [13/02/08 08:59:21:576][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:576][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:AI_17 UV lamp1-1 Gen power)'] > > > [13/02/08 08:59:21:576][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:577][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:577][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:577][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:578][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:578][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:579][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:579][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:580][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@63f09e > > > [13/02/08 08:59:21:580][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:581][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28710] > > > [13/02/08 08:59:21:581][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:581][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:581][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:582][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:582][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:582][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:583][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:584][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:584][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1c19919 > > > [13/02/08 08:59:21:584][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:585][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:AI_18 UV lamp1-2 Gen power)'] > > > [13/02/08 08:59:21:585][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:585][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:585][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:586][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:586][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:587][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:587][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:588][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:588][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1e2a069 > > > [13/02/08 08:59:21:588][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:589][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28711] > > > [13/02/08 08:59:21:589][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:589][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:589][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:590][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:591][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:591][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:591][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:592][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:592][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@2a2cc > > > [13/02/08 08:59:21:592][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:593][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:AO_3 UV lamp1-1 setpoint)'] > > > [13/02/08 08:59:21:593][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:593][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:594][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:594][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:594][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:595][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:595][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:596][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:596][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@c4afc4 > > > [13/02/08 08:59:21:597][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:597][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28712] > > > [13/02/08 08:59:21:597][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:599][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:599][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:599][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:600][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:600][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:601][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:601][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:601][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1e2c841 > > > [13/02/08 08:59:21:602][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:602][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:AO_6 UV lamp1-2 setpoint)'] > > > [13/02/08 08:59:21:603][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:603][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:603][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:603][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:604][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:604][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:605][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:605][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:605][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@b83be0 > > > [13/02/08 08:59:21:605][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:606][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28713] > > > [13/02/08 08:59:21:606][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:606][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:606][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:607][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:607][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:607][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:608][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:608][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:609][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@ffc3eb > > > [13/02/08 08:59:21:609][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:609][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:AO_8 blower speed)'] > > > [13/02/08 08:59:21:610][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:610][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:610][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:611][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:611][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:611][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:612][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:612][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:613][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1e9f5cc > > > [13/02/08 08:59:21:613][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:613][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28714] > > > [13/02/08 08:59:21:614][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:614][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:614][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:615][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:615][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:615][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:616][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:616][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:617][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@a166bd > > > [13/02/08 08:59:21:617][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:617][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:Current Heater Lift condition)'] > > > [13/02/08 08:59:21:618][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:618][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:618][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:619][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:619][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:619][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:620][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:621][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:622][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@d1b72d > > > [13/02/08 08:59:21:622][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:622][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28715] > > > [13/02/08 08:59:21:622][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:622][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:623][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:623][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:624][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:624][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:625][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:625][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:625][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1db0da1 > > > [13/02/08 08:59:21:626][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:626][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:Currentdistanceinmilsfromshowerhead)'] > > > [13/02/08 08:59:21:626][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:627][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:627][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:627][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:628][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:628][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:629][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:629][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:629][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@e5ace9 > > > [13/02/08 08:59:21:630][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:630][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28716] > > > [13/02/08 08:59:21:630][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:631][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:631][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:631][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:632][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:632][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:633][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:633][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:634][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1b7edd3 > > > [13/02/08 08:59:21:634][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:634][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:Endpoint Voltage (AT/OpticalEndpoint))'] > > > [13/02/08 08:59:21:635][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:635][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:635][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:636][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:636][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:636][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:638][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:638][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:638][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@dafa2c > > > [13/02/08 08:59:21:638][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:639][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28717] > > > [13/02/08 08:59:21:639][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:639][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:639][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:640][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:640][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:641][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:641][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:642][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:642][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@d2b918 > > > [13/02/08 08:59:21:642][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:644][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:Heater Temp. Setpoint)'] > > > [13/02/08 08:59:21:645][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:645][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:645][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:645][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:646][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:646][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:647][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:647][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:647][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@1b493c6 > > > [13/02/08 08:59:21:647][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:647][][DEBUG]Executing SQL query [SELECT > l.AlarmLevel, > > > l.Label, l.Value FROM pcb.limits l WHERE l.IndicatorID =3D 28718] > > > [13/02/08 08:59:21:648][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:648][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:648][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:648][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:649][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:649][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:651][][DEBUG]Returning JDBC Connection to DataSour= ce > > > [13/02/08 08:59:21:652][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 > > > > > > 08:59:21:653][][DEBUG]com.mchange.v2.async.ThreadPoolAsynchronousRunner@6= b62d1 > > : > > > Adding task to queue -- > > > > > > com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTa= sk@8ef177 > > > [13/02/08 08:59:21:653][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:653][][DEBUG]Executing SQL query [SELECT > t.AlarmLevel > > > FROM `apchistory` t where t.contextid =3D '122592' and t.label =3D > > > 'Max(CH_A1:HF/Impedance-I offset)'] > > > [13/02/08 08:59:21:653][][DEBUG]Fetching JDBC Connection from > DataSource > > > [13/02/08 08:59:21:654][][DEBUG]acquire test -- pool is already maxed > > out. > > > [managed: 2; max: 2] > > > [13/02/08 08:59:21:654][][DEBUG]awaitAvailable(): > > > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > > [13/02/08 08:59:21:654][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > [13/02/08 08:59:21:655][][DEBUG]checkinAll(): > > > com.mchange.v2.c3p0.stmt.DoubleMaxStatementCache stats -- total size: > 0; > > > checked out: 0; num connections: 0; num keys: 0 > > > [13/02/08 08:59:21:655][][DEBUG]trace > > > com.mchange.v2.resourcepool.BasicResourcePool@552a2b [managed: 2, > > unused: > > > 0, excluded: 0] (e.g. > com.mchange.v2.c3p0.impl.NewPooledConnection@b31a7c > > ) > > > > > --e89a8fb1f82056717904d540e41c--