Re: empty "current statement" in system sessions
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <1371025795.23977.140661242922289.0C67D419@webmail.messagingengine.com> |
There is no straightforward way of knowing if it is not reported. Suppose the session has executed SELECT * FROM A TABLE and finished. It is not executing anything therefore there is no statement text. It must be committed before the backup can proceed. It could be safe to reset that session if you are not changing the session settings. Version 2.3.0 avoids this situation when a session has performed selects from information schema tables, which happens when JDBCDatabaseMetaData is used. Fred On Wed, Jun 12, 2013, at 9:00, Łukasz L. wrote: Hi, Checking SYSTEM_SESSIONS table I have backup job waiting for another session which has empty CURRENT STATEMENT COLUMN. How can I know what is it? See attachment. Lukasz Inline images 1 ----------------------------------------------------------------------- ------- This SF.net email is sponsored by Windows: Build for Windows Store. [1]http://p.sf.net/sfu/windows-dev2dev _______________________________________________ Hsqldb-user mailing list [2][email protected] [3]https://lists.sourceforge.net/lists/listinfo/hsqldb-user Email had 1 attachment: * active sessions2.png 34k (image/png) References 1. http://p.sf.net/sfu/windows-dev2dev 2. mailto:[email protected] 3. https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user