Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 47328 invoked from network); 30 May 2007 17:52:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 May 2007 17:52:26 -0000 Received: (qmail 27875 invoked by uid 500); 30 May 2007 17:52:28 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 27848 invoked by uid 500); 30 May 2007 17:52:28 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 27832 invoked by uid 99); 30 May 2007 17:52:28 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 May 2007 10:52:28 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [68.142.198.202] (HELO smtp103.sbc.mail.mud.yahoo.com) (68.142.198.202) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 30 May 2007 10:52:21 -0700 Received: (qmail 79427 invoked from network); 30 May 2007 17:51:58 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:Message-ID:Date:From:Reply-To:User-Agent:X-Accept-Language:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=p4uKcXls3wAM9GiBVCAmZcoKUHpXap3aZXAYkigvtiA5adn9bDbEnmf5jOXXge63FYFDz/2b2MlvEHx4qYskvNwHoXIURim+HXfEJWrpie2HT0tBx24DfAofx+zMmS5YxoMfapVpXioUMvOazYxzaM4bUcq7an1HpOkF0qqDApE= ; Received: from unknown (HELO ?192.168.0.187?) (mikem_app@sbcglobal.net@71.131.215.135 with plain) by smtp103.sbc.mail.mud.yahoo.com with SMTP; 30 May 2007 17:51:57 -0000 X-YMail-OSG: tDpsLSsVM1nYFNe75d8fe_hySPHl3HyNONhsRtR2nvYq64bEnxrG2YcniGEzZ5jvDTFKsKbpODCqK9.kglUKRIeBzr2OMYkhNU.O55xkbPVV5FNTwEdR.JI0i98y9A-- Message-ID: <465DB9B4.4030909@sbcglobal.net> Date: Wed, 30 May 2007 10:51:48 -0700 From: Mike Matrigali Reply-To: mikem_app@sbcglobal.net User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: Embedded thread taking 100% cpu References: <619FD34741327C47AC7FBA8DBADBF5E0E194C8@ffex01.fnfr.com> In-Reply-To: <619FD34741327C47AC7FBA8DBADBF5E0E194C8@ffex01.fnfr.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org is the included derby.log from when you are going to sit for hours without doing anything? If so it looks like there is an uncommitted transaction that is holding locks. In end of derby.log there is: 2007-05-23 16:08:22.222 GMT Thread[Thread-2,6,main] (XID = 1879), (SESSIONID = 0 ), (DATABASE = /home/abovill/ws/runtime-New_configuration-b2/.capture), (DRDAID = null), Committing 2007-05-23 16:08:22.222 GMT Thread[Thread-2,6,main] (XID = 1880), (SESSIONID = 0 ), (DATABASE = /home/abovill/ws/runtime-New_configuration-b2/.capture), (DRDAID = null), Executing prepared statement: SELECT COUNT(orderIndex) FROM sessions WH ERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End pr epared statement with 2 parameters begin parameter #1: 0 :end parameter begin pa rameter #2: 1177228800000 :end parameter It looks like transaction 1880 never commits and may be interfering with the background thread which is loping waiting to get access to locks that 1880 is holding. I do not think it is correct that derby eats 100% cpu in this case, but would like to verify if the problem is lock related so that we can post a workaround. Is it possible in your test case to not leave a uncommitted transaction? Adam Bovill wrote: > Hello, > > > > I am still experiencing these problems. As an experiment, I removed all > control over the Autocommit, so it is always set to true and there are > not extra calls to commit and/or roll back. This did not stop the derby > thread from taking 100% of the cpu. > > > > I have included the derby.log and queries.txt files. The queries.txt > file is just the log file, with only the query statement lines and some > of the repetitive information removed (and Execute Prepared Statement > changed to EPS). I have also included the schema that I�m using. > > > > Basically, the program runs those commands over and over and over > again. At some point the derby thread starts to spin. > > > > Thanks, > > Adam > > > > > > ------------------------------------------------------------------------ > > *From:* Francois Orsini [mailto:francois.orsini@gmail.com] > *Sent:* Friday, May 18, 2007 7:49 PM > *To:* Derby Discussion > *Subject:* Re: Embedded thread taking 100% cpu > > > > > > On 5/18/07, *Adam Bovill* > > wrote: > > Well, I cannot attest to forever, but they have been running at 100% for > the last 8 hours. It happens after repeating these steps for 2-4 hours. > > > Is there a way to trace all of the actual commands that are sent to the > db? I can also provide my schema if that helps. These are two separate > tables, with no foreign keys. > > > Yes, use can set the derby.language.logStatementText property for that: > http://db.apache.org/derby/docs/dev/tuning/tuning-single.html#rtunproper43517 > > > > Thanks, > Adam > > -----Original Message----- > From: Mike Matrigali [mailto:mikem_app@sbcglobal.net > ] > Sent: Friday, May 18, 2007 3:29 PM > To: Derby Discussion > Subject: Re: Embedded thread taking 100% cpu > > are you saying that if you stop your loop and do nothing then you > see the cpu spinning at 100% "forever". > > The stack traces are what I would expect, and they may spin for > 100% cpu for a short time depending on size of table and cache size > as they may require no I/O. Anytime you delete all rows from a page > as it seems your step 4 does, then work is queued to be activated when > that transaction commits. At step 5 the work is processed, it > basically > reclaims the space freed by the committed deletes and makes it available > for future inserts into the table. > > Adam Bovill wrote: >> Hello, >> >> I seem to be having a problem with my embedded derby >> "derby.rawStoreDeamon" thread where it takes up 100% of my CPU. >> Everything else is still responsive, but this thread seems to be > looping >> through the following stack traces. Also, as soon as I make any >> additional action on the Database, it returns to normal, so it seems >> that I have done something to get it into a strange state. >> >> The following stack traces were taken by halting that thread multiple >> times, they are not in any order. >> >> So this happens after repeating the following multiple times: >> >> >> >> 1. Add items to two tables. (3 items into one, 15 into the other) >> >> 2. Set autocommit = false >> >> 3. force commit >> >> 4. attempt to delete all the items (and they are successfully deleted) >> >> 5. force commit >> >> 6. set autocommit = true >> >> >> >> I set the autocommit to false so that I can roll back the changes if > the >> delete fails. >> >> >> >> It seems to just sit there and spin doing nothing. Have I done >> something wrong with my commit logic? >> >> >> >> Thanks, >> >> Adam >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> LockControl.addLock(LockSet, Object, Object) line: not >> available >> >> LockSet.lockObject(Object, Lockable, Object, int, Latch) >> line: not available >> >> SinglePool.lockAnObject (Object, Object, Lockable, Object, >> int, Latch) line: not available >> >> SinglePool.lockObject(Object, Object, Lockable, Object, > int) >> line: not available >> >> ContainerLocking3.lockContainer(Transaction, >> ContainerHandle, boolean, boolean) line: not available >> >> BaseContainerHandle.useContainer(boolean, boolean) line: > not >> available >> >> BaseDataFileFactory.openContainer(RawTransaction, >> ContainerKey, LockingPolicy, int, boolean) line: not available >> >> BaseDataFileFactory.openContainer(RawTransaction, >> ContainerKey, LockingPolicy, int) line: not available >> >> InternalXact(Xact).openContainer(ContainerKey, >> LockingPolicy, int) line: not available >> >> OpenHeap(OpenConglomerate).init(ContainerHandle, >> Conglomerate, int[], TransactionManager, Transaction, boolean, int, > int, >> LockingPolicy, DynamicCompiledOpenConglomInfo) line: not available >> >> Heap.open(TransactionManager, Transaction, boolean, int, >> int, LockingPolicy, StaticCompiledOpenConglomInfo, >> DynamicCompiledOpenConglomInfo) line: not available >> >> RAMTransaction.openConglomerate(Conglomerate, boolean, > int, >> int, int, StaticCompiledOpenConglomInfo, > DynamicCompiledOpenConglomInfo) >> line: not available >> >> RAMTransaction.openConglomerate(long, boolean, int, int, >> int) line: not available >> >> B2I.lockTable (TransactionManager, int, int, int) line: not > >> available >> >> BTreePostCommit.performWork(ContextManager) line: not >> available >> >> BasicDaemon.serviceClient (ServiceRecord) line: not >> available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run () line: not available >> >> >> >> >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> OpenHeap(OpenConglomerate).init(ContainerHandle, >> Conglomerate, int[], TransactionManager, Transaction, boolean, int, > int, >> LockingPolicy, DynamicCompiledOpenConglomInfo) line: not available >> >> Heap.open(TransactionManager, Transaction, boolean, int, >> int, LockingPolicy, StaticCompiledOpenConglomInfo, >> DynamicCompiledOpenConglomInfo) line: not available >> >> RAMTransaction.openConglomerate(Conglomerate, boolean, > int, >> int, int, StaticCompiledOpenConglomInfo, > DynamicCompiledOpenConglomInfo) >> line: not available >> >> RAMTransaction.openConglomerate(long, boolean, int, int, >> int) line: not available >> >> B2I.lockTable (TransactionManager, int, int, int) line: not > >> available >> >> BTreePostCommit.performWork(ContextManager) line: not >> available >> >> BasicDaemon.serviceClient (ServiceRecord) line: not >> available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run () line: not available >> >> >> >> >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> BaseContainerHandle.useContainer(boolean, boolean) line: > not >> available >> >> BaseDataFileFactory.openContainer(RawTransaction, >> ContainerKey, LockingPolicy, int, boolean) line: not available >> >> BaseDataFileFactory.openContainer (RawTransaction, >> ContainerKey, LockingPolicy, int) line: not available >> >> InternalXact(Xact).openContainer(ContainerKey, >> LockingPolicy, int) line: not available >> >> OpenHeap(OpenConglomerate).init(ContainerHandle, >> Conglomerate, int[], TransactionManager, Transaction, boolean, int, > int, >> LockingPolicy, DynamicCompiledOpenConglomInfo) line: not available >> >> Heap.open(TransactionManager, Transaction, boolean, int, >> int, LockingPolicy, StaticCompiledOpenConglomInfo, >> DynamicCompiledOpenConglomInfo) line: not available >> >> RAMTransaction.openConglomerate(Conglomerate, boolean, > int, >> int, int, StaticCompiledOpenConglomInfo, > DynamicCompiledOpenConglomInfo) >> line: not available >> >> RAMTransaction.openConglomerate(long, boolean, int, int, >> int) line: not available >> >> B2I.lockTable (TransactionManager, int, int, int) line: not > >> available >> >> BTreePostCommit.performWork(ContextManager) line: not >> available >> >> BasicDaemon.serviceClient (ServiceRecord) line: not >> available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run () line: not available >> >> >> >> >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> LinkedList.addBefore(E, Entry) line: not available >> >> LinkedList.add(E) line: not available >> >> LockControl.addWaiter(List, Lock, LockSet) line: not >> available >> >> LockControl.addLock (LockSet, Object, Object) line: not >> available >> >> LockSet.lockObject(Object, Lockable, Object, int, Latch) >> line: not available >> >> SinglePool.lockAnObject(Object, Object, Lockable, Object, >> int, Latch) line: not available >> >> SinglePool.lockObject(Object, Object, Lockable, Object, > int) >> line: not available >> >> ContainerLocking3.lockContainer(Transaction, >> ContainerHandle, boolean, boolean) line: not available >> >> BaseContainerHandle.useContainer(boolean, boolean) line: > not >> available >> >> BaseDataFileFactory.openContainer (RawTransaction, >> ContainerKey, LockingPolicy, int, boolean) line: not available >> >> BaseDataFileFactory.openContainer(RawTransaction, >> ContainerKey, LockingPolicy, int) line: not available >> >> InternalXact(Xact).openContainer(ContainerKey, >> LockingPolicy, int) line: not available >> >> OpenHeap(OpenConglomerate).init(ContainerHandle, >> Conglomerate, int[], TransactionManager, Transaction, boolean, int, > int, >> LockingPolicy, DynamicCompiledOpenConglomInfo) line: not available >> >> Heap.open(TransactionManager, Transaction, boolean, int, >> int, LockingPolicy, StaticCompiledOpenConglomInfo, >> DynamicCompiledOpenConglomInfo) line: not available >> >> RAMTransaction.openConglomerate(Conglomerate, boolean, > int, >> int, int, StaticCompiledOpenConglomInfo, > DynamicCompiledOpenConglomInfo) >> line: not available >> >> RAMTransaction.openConglomerate(long, boolean, int, int, >> int) line: not available >> >> B2I.lockTable(TransactionManager, int, int, int) line: not > >> available >> >> BTreePostCommit.performWork(ContextManager) line: not >> available >> >> BasicDaemon.serviceClient(ServiceRecord) line: not >> available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run() line: not available >> >> >> >> >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> Thread.setPriority0(int) line: not available [native > method] >> >> Thread.setPriority (int) line: not available >> >> FileMonitor(BaseMonitor).setThreadPriority(int) line: not >> available >> >> FileMonitor.run() line: not available >> >> > AccessController.doPrivileged (PrivilegedExceptionAction) >> line: not available [native method] >> >> FileMonitor.setThreadPriority(int) line: not >> available >> >> BasicDaemon.yield() line: not available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run() line: not available >> >> >> >> >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> TransactionTable.add(Xact, boolean) line: not available > >> >> XactFactory.add (Xact, boolean) line: not available >> >> XactFactory.pushTransactionContext(ContextManager, String, > >> Xact, boolean, RawStoreFactory, boolean) line: not available > >> >> XactFactory.startInternalTransaction(RawStoreFactory, >> ContextManager) line: not available >> >> RawStore.startInternalTransaction(ContextManager) line: > not >> available >> >> RAMTransaction.getInternalTransaction() line: not >> available >> >> BTreePostCommit.performWork(ContextManager) line: not >> available >> >> BasicDaemon.serviceClient (ServiceRecord) line: not >> available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run () line: not available >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> BaseContainerHandle.useContainer(boolean, boolean) line: > not >> available >> >> BaseDataFileFactory.openContainer(RawTransaction, >> ContainerKey, LockingPolicy, int, boolean) line: not available >> >> BaseDataFileFactory.openContainer(RawTransaction, >> ContainerKey, LockingPolicy, int) line: not available >> >> InternalXact(Xact).openContainer(ContainerKey, >> LockingPolicy, int) line: not available >> >> OpenHeap(OpenConglomerate).init(ContainerHandle, >> Conglomerate, int[], TransactionManager, Transaction, boolean, int, > int, >> LockingPolicy, DynamicCompiledOpenConglomInfo) line: not available >> >> Heap.open(TransactionManager, Transaction, boolean, int, >> int, LockingPolicy, StaticCompiledOpenConglomInfo, >> DynamicCompiledOpenConglomInfo) line: not available >> >> RAMTransaction.openConglomerate(Conglomerate, boolean, > int, >> int, int, StaticCompiledOpenConglomInfo, > DynamicCompiledOpenConglomInfo) >> line: not available >> >> RAMTransaction.openConglomerate(long, boolean, int, int, >> int) line: not available >> >> B2I.lockTable (TransactionManager, int, int, int) line: not > >> available >> >> BTreePostCommit.performWork(ContextManager) line: not >> available >> >> BasicDaemon.serviceClient (ServiceRecord) line: not >> available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run () line: not available >> >> >> >> >> >> >> >> >> >> Thread [derby.rawStoreDaemon] (Suspended) >> >> LinkedList.remove(Entry) line: not available > >> >> LinkedList.remove(Object) line: not available >> >> LockControl.removeWaiter(List, Object, LockSet) line: not >> available >> >> LockControl.giveUpWait (Object, LockSet) line: not >> available >> >> LockSet.lockObject(Object, Lockable, Object, int, Latch) >> line: not available >> >> SinglePool.lockAnObject(Object, Object, Lockable, Object, >> int, Latch) line: not available >> >> SinglePool.lockObject(Object, Object, Lockable, Object, > int) >> line: not available >> >> ContainerLocking3.lockContainer(Transaction, >> ContainerHandle, boolean, boolean) line: not available >> >> BaseContainerHandle.useContainer(boolean, boolean) line: > not >> available >> >> BaseDataFileFactory.openContainer (RawTransaction, >> ContainerKey, LockingPolicy, int, boolean) line: not available >> >> BaseDataFileFactory.openContainer(RawTransaction, >> ContainerKey, LockingPolicy, int) line: not available >> >> InternalXact(Xact).openContainer(ContainerKey, >> LockingPolicy, int) line: not available >> >> OpenHeap(OpenConglomerate).init(ContainerHandle, >> Conglomerate, int[], TransactionManager, Transaction, boolean, int, > int, >> LockingPolicy, DynamicCompiledOpenConglomInfo) line: not available >> >> Heap.open(TransactionManager, Transaction, boolean, int, >> int, LockingPolicy, StaticCompiledOpenConglomInfo, >> DynamicCompiledOpenConglomInfo) line: not available >> >> RAMTransaction.openConglomerate(Conglomerate, boolean, > int, >> int, int, StaticCompiledOpenConglomInfo, > DynamicCompiledOpenConglomInfo) >> line: not available >> >> RAMTransaction.openConglomerate(long, boolean, int, int, >> int) line: not available >> >> B2I.lockTable(TransactionManager, int, int, int) line: not > >> available >> >> BTreePostCommit.performWork(ContextManager) line: not >> available >> >> BasicDaemon.serviceClient(ServiceRecord) line: not >> available >> >> BasicDaemon.work(boolean) line: not available >> >> BasicDaemon.run() line: not available >> >> Thread.run() line: not available >> > > > > > ------------------------------------------------------------------------ > > 2007-05-23 16:07:29.525 GMT (XID = 1699), EPS: SELECT schemaversion FROM infoTable :End prepared statement > 2007-05-23 16:07:29.677 GMT (XID = 1702), EPS: UPDATE sessions SET complete = 2 WHERE complete = 0 :End prepared statement > 2007-05-23 16:07:31.725 GMT (XID = 1703), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:31.743 GMT (XID = 1706), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:31.782 GMT (XID = 1707), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:32.096 GMT (XID = 1708), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:32.115 GMT (XID = 1709), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179820800000 :end parameter begin parameter #2: 1179907200000 :end parameter > 2007-05-23 16:07:32.166 GMT (XID = 1710), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179820800000 :end parameter begin parameter #2: 1179907200000 :end parameter > 2007-05-23 16:07:32.282 GMT (XID = 1711), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179734400000 :end parameter begin parameter #2: 1179820800000 :end parameter > 2007-05-23 16:07:32.287 GMT (XID = 1712), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179734400000 :end parameter begin parameter #2: 1179820800000 :end parameter > 2007-05-23 16:07:32.296 GMT (XID = 1713), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179648000000 :end parameter begin parameter #2: 1179734400000 :end parameter > 2007-05-23 16:07:32.302 GMT (XID = 1714), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179648000000 :end parameter begin parameter #2: 1179734400000 :end parameter > 2007-05-23 16:07:32.310 GMT (XID = 1715), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179043200000 :end parameter begin parameter #2: 1179648000000 :end parameter > 2007-05-23 16:07:32.315 GMT (XID = 1716), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179043200000 :end parameter begin parameter #2: 1179648000000 :end parameter > 2007-05-23 16:07:32.324 GMT (XID = 1717), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1178438400000 :end parameter begin parameter #2: 1179043200000 :end parameter > 2007-05-23 16:07:32.330 GMT (XID = 1718), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1178438400000 :end parameter begin parameter #2: 1179043200000 :end parameter > 2007-05-23 16:07:32.338 GMT (XID = 1719), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1177833600000 :end parameter begin parameter #2: 1178438400000 :end parameter > 2007-05-23 16:07:32.344 GMT (XID = 1720), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1177833600000 :end parameter begin parameter #2: 1178438400000 :end parameter > 2007-05-23 16:07:32.862 GMT (XID = 1721), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1177228800000 :end parameter begin parameter #2: 1177833600000 :end parameter > 2007-05-23 16:07:32.869 GMT (XID = 1722), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1177228800000 :end parameter begin parameter #2: 1177833600000 :end parameter > 2007-05-23 16:07:32.881 GMT (XID = 1723), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1177228800000 :end parameter > 2007-05-23 16:07:32.925 GMT (XID = 1724), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1177228800000 :end parameter > 2007-05-23 16:07:35.279 GMT (XID = 1725), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:39.285 GMT (XID = 1727), EPS: SELECT MAX(orderIndex) FROM sessions :End prepared statement > 2007-05-23 16:07:39.336 GMT (XID = 1728), EPS: INSERT INTO sessions(sid, orderIndex, start, application, profile, type, complete, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 10 parameters begin parameter #1: s12 :end parameter begin parameter #2: 9 :end parameter begin parameter #3: 1179936458913 :end parameter begin parameter #4: com.fnfr.svt.applications.tclsh :end parameter begin parameter #5: project://project/session_profiles/recent/tclsh.ffsp :end parameter begin parameter #6: :end parameter begin parameter #7: 0 :end parameter begin parameter #8: tclsh.ffsp :end parameter begin parameter #9: CLOB(732) :end parameter begin parameter #10: 1464 :end parameter > 2007-05-23 16:07:39.745 GMT (XID = 1732), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:07:39.874 GMT (XID = 1732), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:39.884 GMT (XID = 1734), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:39.890 GMT (XID = 1735), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:39.934 GMT (XID = 1737), EPS: SELECT MIN(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:39.985 GMT (XID = 1739), EPS: SELECT id, sid, start, endTime, type, complete, application, profile, description FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.orderIndex = ? :End prepared statement with 3 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter begin parameter #3: 9 :end parameter > 2007-05-23 16:07:40.282 GMT (XID = 1741), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s12.1 :end parameter begin parameter #2: 26 :end parameter begin parameter #3: 1 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936460239 :end parameter begin parameter #7: 0 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 1 :end parameter begin parameter #10: open :end parameter begin parameter #11: tcl shell :end parameter begin parameter #12: CLOB(423) :end parameter begin parameter #13: 846 :end parameter > 2007-05-23 16:07:40.291 GMT (XID = 1744), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:07:40.320 GMT (XID = 1744), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:07:40.390 GMT (XID = 1747), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 1 :end parameter > 2007-05-23 16:07:43.810 GMT (XID = 1748), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s12.2 :end parameter begin parameter #2: 26 :end parameter begin parameter #3: 2 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936463798 :end parameter begin parameter #7: 1179936463798 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: set i 500 :end parameter begin parameter #12: CLOB(432) :end parameter begin parameter #13: 864 :end parameter > 2007-05-23 16:07:43.814 GMT (XID = 1750), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:07:43.866 GMT (XID = 1750), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 124 :end parameter > 2007-05-23 16:07:43.914 GMT (XID = 1753), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936463798 :end parameter begin parameter #3: 1179936463805 :end parameter begin parameter #4: 2 :end parameter begin parameter #5: 0.0070 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: set i 500 :end parameter begin parameter #9: CLOB(1034) :end parameter begin parameter #10: 2068 :end parameter begin parameter #11: 124 :end parameter > 2007-05-23 16:07:43.926 GMT (XID = 1754), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:07:43.934 GMT (XID = 1755), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 2 :end parameter > 2007-05-23 16:07:43.970 GMT (XID = 1756), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 2 :end parameter > 2007-05-23 16:07:46.328 GMT (XID = 1757), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s12.3 :end parameter begin parameter #2: 26 :end parameter begin parameter #3: 3 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936466324 :end parameter begin parameter #7: 1179936466324 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: set fj 59 :end parameter begin parameter #12: CLOB(432) :end parameter begin parameter #13: 864 :end parameter > 2007-05-23 16:07:46.337 GMT (XID = 1759), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:07:46.340 GMT (XID = 1759), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 125 :end parameter > 2007-05-23 16:07:46.353 GMT (XID = 1760), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936466324 :end parameter begin parameter #3: 1179936466332 :end parameter begin parameter #4: 3 :end parameter begin parameter #5: 0.0080 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: set fj 59 :end parameter begin parameter #9: CLOB(1032) :end parameter begin parameter #10: 2064 :end parameter begin parameter #11: 125 :end parameter > 2007-05-23 16:07:46.362 GMT (XID = 1761), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:07:46.373 GMT (XID = 1762), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 3 :end parameter > 2007-05-23 16:07:46.406 GMT (XID = 1763), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 3 :end parameter > 2007-05-23 16:07:53.663 GMT (XID = 1764), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s12.4 :end parameter begin parameter #2: 26 :end parameter begin parameter #3: 4 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936473660 :end parameter begin parameter #7: 1179936473660 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: puts $i$fj :end parameter begin parameter #12: CLOB(433) :end parameter begin parameter #13: 866 :end parameter > 2007-05-23 16:07:53.674 GMT (XID = 1766), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:07:53.695 GMT (XID = 1766), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 126 :end parameter > 2007-05-23 16:07:53.710 GMT (XID = 1767), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936473660 :end parameter begin parameter #3: 1179936473674 :end parameter begin parameter #4: 4 :end parameter begin parameter #5: 0.014 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: puts $i$fj :end parameter begin parameter #9: CLOB(1038) :end parameter begin parameter #10: 2076 :end parameter begin parameter #11: 126 :end parameter > 2007-05-23 16:07:53.721 GMT (XID = 1768), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:07:53.728 GMT (XID = 1769), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 4 :end parameter > 2007-05-23 16:07:53.765 GMT (XID = 1770), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 4 :end parameter > 2007-05-23 16:07:59.369 GMT (XID = 1771), EPS: SELECT MAX(orderIndex) FROM sessions :End prepared statement > 2007-05-23 16:07:59.379 GMT (XID = 1772), EPS: INSERT INTO sessions(sid, orderIndex, start, application, profile, type, complete, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 10 parameters begin parameter #1: s13 :end parameter begin parameter #2: 10 :end parameter begin parameter #3: 1179936479361 :end parameter begin parameter #4: com.fnfr.svt.applications.telnet :end parameter begin parameter #5: project://project/session_profiles/recent/telnet_dutlinux.ffsp :end parameter begin parameter #6: :end parameter begin parameter #7: 0 :end parameter begin parameter #8: telnet_dutlinux.ffsp :end parameter begin parameter #9: CLOB(1927) :end parameter begin parameter #10: 3854 :end parameter > 2007-05-23 16:07:59.416 GMT (XID = 1774), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:07:59.424 GMT (XID = 1774), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s13.1 :end parameter begin parameter #2: 27 :end parameter begin parameter #3: 1 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936479421 :end parameter begin parameter #7: 0 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 1 :end parameter begin parameter #10: open :end parameter begin parameter #11: telnet to dutlinux:23 :end parameter begin parameter #12: CLOB(619) :end parameter begin parameter #13: 1238 :end parameter > 2007-05-23 16:07:59.440 GMT (XID = 1776), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:07:59.454 GMT (XID = 1776), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:59.460 GMT (XID = 1777), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:59.473 GMT (XID = 1778), EPS: SELECT MIN(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:07:59.478 GMT (XID = 1779), EPS: SELECT id, sid, start, endTime, type, complete, application, profile, description FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.orderIndex = ? :End prepared statement with 3 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter begin parameter #3: 10 :end parameter > 2007-05-23 16:07:59.519 GMT (XID = 1780), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:07:59.530 GMT (XID = 1781), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 1 :end parameter > 2007-05-23 16:08:00.834 GMT (XID = 1782), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s13.2 :end parameter begin parameter #2: 27 :end parameter begin parameter #3: 2 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936480822 :end parameter begin parameter #7: 1179936480822 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: fanfare :end parameter begin parameter #12: CLOB(430) :end parameter begin parameter #13: 860 :end parameter > 2007-05-23 16:08:00.838 GMT (XID = 1784), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:00.842 GMT (XID = 1784), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:00.854 GMT (XID = 1785), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 2 :end parameter > 2007-05-23 16:08:00.863 GMT (XID = 1786), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 128 :end parameter > 2007-05-23 16:08:00.900 GMT (XID = 1787), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936480822 :end parameter begin parameter #3: 1179936480858 :end parameter begin parameter #4: 2 :end parameter begin parameter #5: 0.036 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: fanfare :end parameter begin parameter #9: CLOB(685) :end parameter begin parameter #10: 1370 :end parameter begin parameter #11: 128 :end parameter > 2007-05-23 16:08:00.943 GMT (XID = 1788), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 2 :end parameter > 2007-05-23 16:08:02.431 GMT (XID = 1789), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s13.3 :end parameter begin parameter #2: 27 :end parameter begin parameter #3: 3 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936481929 :end parameter begin parameter #7: 1179936481929 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: ******** :end parameter begin parameter #12: CLOB(449) :end parameter begin parameter #13: 898 :end parameter > 2007-05-23 16:08:02.434 GMT (XID = 1791), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:02.437 GMT (XID = 1791), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 129 :end parameter > 2007-05-23 16:08:02.450 GMT (XID = 1792), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936481929 :end parameter begin parameter #3: 1179936482047 :end parameter begin parameter #4: 3 :end parameter begin parameter #5: 0.118 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: ******** :end parameter begin parameter #9: CLOB(774) :end parameter begin parameter #10: 1548 :end parameter begin parameter #11: 129 :end parameter > 2007-05-23 16:08:02.458 GMT (XID = 1793), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:02.469 GMT (XID = 1794), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 3 :end parameter > 2007-05-23 16:08:02.505 GMT (XID = 1795), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 3 :end parameter > 2007-05-23 16:08:04.867 GMT (XID = 1796), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s13.4 :end parameter begin parameter #2: 27 :end parameter begin parameter #3: 4 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936484862 :end parameter begin parameter #7: 1179936484862 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: uptime :end parameter begin parameter #12: CLOB(429) :end parameter begin parameter #13: 858 :end parameter > 2007-05-23 16:08:04.879 GMT (XID = 1798), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:04.883 GMT (XID = 1798), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:04.916 GMT (XID = 1799), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 4 :end parameter > 2007-05-23 16:08:04.972 GMT (XID = 1800), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 130 :end parameter > 2007-05-23 16:08:04.982 GMT (XID = 1801), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936484862 :end parameter begin parameter #3: 1179936484965 :end parameter begin parameter #4: 4 :end parameter begin parameter #5: 0.103 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: uptime :end parameter begin parameter #9: CLOB(792) :end parameter begin parameter #10: 1584 :end parameter begin parameter #11: 130 :end parameter > 2007-05-23 16:08:04.997 GMT (XID = 1802), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 4 :end parameter > 2007-05-23 16:08:06.606 GMT (XID = 1803), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s13.5 :end parameter begin parameter #2: 27 :end parameter begin parameter #3: 5 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936486590 :end parameter begin parameter #7: 1179936486590 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: uname -a :end parameter begin parameter #12: CLOB(431) :end parameter begin parameter #13: 862 :end parameter > 2007-05-23 16:08:06.610 GMT (XID = 1805), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:06.614 GMT (XID = 1805), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:06.640 GMT (XID = 1806), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 5 :end parameter > 2007-05-23 16:08:06.652 GMT (XID = 1807), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 131 :end parameter > 2007-05-23 16:08:06.670 GMT (XID = 1808), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936486590 :end parameter begin parameter #3: 1179936486636 :end parameter begin parameter #4: 5 :end parameter begin parameter #5: 0.046 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: uname -a :end parameter begin parameter #9: CLOB(819) :end parameter begin parameter #10: 1638 :end parameter begin parameter #11: 131 :end parameter > 2007-05-23 16:08:06.737 GMT (XID = 1809), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 5 :end parameter > 2007-05-23 16:08:08.075 GMT (XID = 1810), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s13.6 :end parameter begin parameter #2: 27 :end parameter begin parameter #3: 6 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936488071 :end parameter begin parameter #7: 1179936488071 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: ******** :end parameter begin parameter #12: CLOB(449) :end parameter begin parameter #13: 898 :end parameter > 2007-05-23 16:08:08.079 GMT (XID = 1812), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:08.089 GMT (XID = 1812), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 132 :end parameter > 2007-05-23 16:08:08.101 GMT (XID = 1813), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936488071 :end parameter begin parameter #3: 1179936488075 :end parameter begin parameter #4: 6 :end parameter begin parameter #5: 0.0040 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: exit :end parameter begin parameter #9: CLOB(732) :end parameter begin parameter #10: 1464 :end parameter begin parameter #11: 132 :end parameter > 2007-05-23 16:08:08.124 GMT (XID = 1814), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s13.7 :end parameter begin parameter #2: 27 :end parameter begin parameter #3: 7 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936488076 :end parameter begin parameter #7: 0 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 1 :end parameter begin parameter #10: close :end parameter begin parameter #11: telnet to dutlinux:23 :end parameter begin parameter #12: CLOB(352) :end parameter begin parameter #13: 704 :end parameter > 2007-05-23 16:08:08.131 GMT (XID = 1816), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:08.136 GMT (XID = 1816), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:08.165 GMT (XID = 1818), EPS: UPDATE sessions SET endTime = ?, complete = ? WHERE id = 27 :End prepared statement with 2 parameters begin parameter #1: 1179936488086 :end parameter begin parameter #2: 1 :end parameter > 2007-05-23 16:08:08.186 GMT (XID = 1819), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 6 :end parameter > 2007-05-23 16:08:08.224 GMT (XID = 1820), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 7 :end parameter > 2007-05-23 16:08:08.297 GMT (XID = 1821), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 6 :end parameter > 2007-05-23 16:08:08.327 GMT (XID = 1822), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:08.332 GMT (XID = 1823), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 27 :end parameter begin parameter #2: 2 :end parameter > 2007-05-23 16:08:13.589 GMT (XID = 1824), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s12.5 :end parameter begin parameter #2: 26 :end parameter begin parameter #3: 5 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936493586 :end parameter begin parameter #7: 1179936493586 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 0 :end parameter begin parameter #10: command :end parameter begin parameter #11: exit :end parameter begin parameter #12: CLOB(427) :end parameter begin parameter #13: 854 :end parameter > 2007-05-23 16:08:13.599 GMT (XID = 1826), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:13.602 GMT (XID = 1826), EPS: SELECT items.id, items.type, items.details FROM items WHERE items.id = ? :End prepared statement with 1 parameters begin parameter #1: 134 :end parameter > 2007-05-23 16:08:13.613 GMT (XID = 1827), EPS: UPDATE items SET context = ?, start = ?, endTime = ?, orderIndex = ?, duration = ?, complete = ?, actionType = ?, description = ?, details = ?, size = ? WHERE id = ? :End prepared statement with 11 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1179936493586 :end parameter begin parameter #3: 1179936493594 :end parameter begin parameter #4: 5 :end parameter begin parameter #5: 0.0080 :end parameter begin parameter #6: 1 :end parameter begin parameter #7: command :end parameter begin parameter #8: exit :end parameter begin parameter #9: CLOB(884) :end parameter begin parameter #10: 1768 :end parameter begin parameter #11: 134 :end parameter > 2007-05-23 16:08:13.619 GMT (XID = 1828), EPS: INSERT INTO items(aid, sessionID, orderIndex, type, context, start, endTime, duration, complete, actionType, description, details, size) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) :End prepared statement with 13 parameters begin parameter #1: s12.6 :end parameter begin parameter #2: 26 :end parameter begin parameter #3: 6 :end parameter begin parameter #4: 1 :end parameter begin parameter #5: 0 :end parameter begin parameter #6: 1179936493595 :end parameter begin parameter #7: 0 :end parameter begin parameter #8: 0.0 :end parameter begin parameter #9: 1 :end parameter begin parameter #10: close :end parameter begin parameter #11: tcl shell :end parameter begin parameter #12: CLOB(340) :end parameter begin parameter #13: 680 :end parameter > 2007-05-23 16:08:13.623 GMT (XID = 1830), EPS: VALUES IDENTITY_VAL_LOCAL() :End prepared statement > 2007-05-23 16:08:13.645 GMT (XID = 1830), EPS: UPDATE sessions SET endTime = ?, complete = ? WHERE id = 26 :End prepared statement with 2 parameters begin parameter #1: 1179936493595 :end parameter begin parameter #2: 1 :end parameter > 2007-05-23 16:08:13.653 GMT (XID = 1832), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:08:13.665 GMT (XID = 1833), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 5 :end parameter > 2007-05-23 16:08:13.680 GMT (XID = 1834), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 6 :end parameter > 2007-05-23 16:08:13.720 GMT (XID = 1835), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 5 :end parameter > 2007-05-23 16:08:13.753 GMT (XID = 1836), EPS: SELECT COUNT(id) FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:08:13.772 GMT (XID = 1837), EPS: SELECT items.id, items.aid, items.start, items.actionType, items.description, items.duration, items.type, items.complete, sessions.application FROM items, sessions WHERE items.sessionID = ? AND items.orderIndex = ? AND items.sessionID = sessions.id :End prepared statement with 2 parameters begin parameter #1: 26 :end parameter begin parameter #2: 1 :end parameter > 2007-05-23 16:08:18.318 GMT (XID = 1838), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:08:21.998 GMT (XID = 1845), EPS: SELECT id, sid, start, orderIndex, complete FROM sessions WHERE start >= ? AND start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:08:22.001 GMT (XID = 1846), EPS: SELECT id, sid, start, orderIndex, complete FROM sessions WHERE sid = ? AND start = ? :End prepared statement with 2 parameters begin parameter #1: s12 :end parameter begin parameter #2: 1179936458913 :end parameter > 2007-05-23 16:08:22.003 GMT (XID = 1846), EPS: DELETE FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:08:22.018 GMT (XID = 1846), EPS: DELETE FROM sessions WHERE id = ? :End prepared statement with 1 parameters begin parameter #1: 26 :end parameter > 2007-05-23 16:08:22.030 GMT (XID = 1846), EPS: UPDATE sessions SET orderIndex = orderIndex - 1 WHERE orderIndex > ? :End prepared statement with 1 parameters begin parameter #1: 9 :end parameter > 2007-05-23 16:08:22.037 GMT (XID = 1846), EPS: SELECT id, sid, start, orderIndex, complete FROM sessions WHERE sid = ? AND start = ? :End prepared statement with 2 parameters begin parameter #1: s13 :end parameter begin parameter #2: 1179936479361 :end parameter > 2007-05-23 16:08:22.038 GMT (XID = 1846), EPS: DELETE FROM items WHERE sessionID = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:22.061 GMT (XID = 1846), EPS: DELETE FROM sessions WHERE id = ? :End prepared statement with 1 parameters begin parameter #1: 27 :end parameter > 2007-05-23 16:08:22.066 GMT (XID = 1846), EPS: UPDATE sessions SET orderIndex = orderIndex - 1 WHERE orderIndex > ? :End prepared statement with 1 parameters begin parameter #1: 9 :end parameter > 2007-05-23 16:08:22.081 GMT (XID = 1852), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:08:22.086 GMT (XID = 1853), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:08:22.093 GMT (XID = 1854), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:08:22.098 GMT (XID = 1855), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:08:22.102 GMT (XID = 1856), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179907200000 :end parameter begin parameter #2: 1179993600000 :end parameter > 2007-05-23 16:08:22.106 GMT (XID = 1857), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179820800000 :end parameter begin parameter #2: 1179907200000 :end parameter > 2007-05-23 16:08:22.113 GMT (XID = 1858), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179820800000 :end parameter begin parameter #2: 1179907200000 :end parameter > 2007-05-23 16:08:22.122 GMT (XID = 1859), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179820800000 :end parameter begin parameter #2: 1179907200000 :end parameter > 2007-05-23 16:08:22.140 GMT (XID = 1860), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179734400000 :end parameter begin parameter #2: 1179820800000 :end parameter > 2007-05-23 16:08:22.144 GMT (XID = 1861), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179734400000 :end parameter begin parameter #2: 1179820800000 :end parameter > 2007-05-23 16:08:22.148 GMT (XID = 1862), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179734400000 :end parameter begin parameter #2: 1179820800000 :end parameter > 2007-05-23 16:08:22.152 GMT (XID = 1863), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179648000000 :end parameter begin parameter #2: 1179734400000 :end parameter > 2007-05-23 16:08:22.156 GMT (XID = 1864), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179648000000 :end parameter begin parameter #2: 1179734400000 :end parameter > 2007-05-23 16:08:22.160 GMT (XID = 1865), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179648000000 :end parameter begin parameter #2: 1179734400000 :end parameter > 2007-05-23 16:08:22.163 GMT (XID = 1866), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1179043200000 :end parameter begin parameter #2: 1179648000000 :end parameter > 2007-05-23 16:08:22.168 GMT (XID = 1867), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179043200000 :end parameter begin parameter #2: 1179648000000 :end parameter > 2007-05-23 16:08:22.172 GMT (XID = 1868), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1179043200000 :end parameter begin parameter #2: 1179648000000 :end parameter > 2007-05-23 16:08:22.175 GMT (XID = 1869), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1178438400000 :end parameter begin parameter #2: 1179043200000 :end parameter > 2007-05-23 16:08:22.179 GMT (XID = 1870), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1178438400000 :end parameter begin parameter #2: 1179043200000 :end parameter > 2007-05-23 16:08:22.183 GMT (XID = 1871), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1178438400000 :end parameter begin parameter #2: 1179043200000 :end parameter > 2007-05-23 16:08:22.186 GMT (XID = 1872), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1177833600000 :end parameter begin parameter #2: 1178438400000 :end parameter > 2007-05-23 16:08:22.190 GMT (XID = 1873), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1177833600000 :end parameter begin parameter #2: 1178438400000 :end parameter > 2007-05-23 16:08:22.197 GMT (XID = 1874), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1177833600000 :end parameter begin parameter #2: 1178438400000 :end parameter > 2007-05-23 16:08:22.201 GMT (XID = 1875), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 1177228800000 :end parameter begin parameter #2: 1177833600000 :end parameter > 2007-05-23 16:08:22.205 GMT (XID = 1876), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1177228800000 :end parameter begin parameter #2: 1177833600000 :end parameter > 2007-05-23 16:08:22.211 GMT (XID = 1877), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 1177228800000 :end parameter begin parameter #2: 1177833600000 :end parameter > 2007-05-23 16:08:22.214 GMT (XID = 1878), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? :End prepared statement with 2 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1177228800000 :end parameter > 2007-05-23 16:08:22.218 GMT (XID = 1879), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1177228800000 :end parameter > 2007-05-23 16:08:22.222 GMT (XID = 1880), EPS: SELECT COUNT(orderIndex) FROM sessions WHERE sessions.start >= ? AND sessions.start < ? AND sessions.type = '' :End prepared statement with 2 parameters begin parameter #1: 0 :end parameter begin parameter #2: 1177228800000 :end parameter