Attachment 73451 Details for Bug 53333 – HSQLDB server output for a test with LO

HSQLDB server output for a test with LO

serveroutputlibreofficetest.txt (text/plain), 19.28 KB, created by Fred Toussi on 2013-01-22 14:36:50 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Fred Toussi

Created: 2013-01-22 14:36:50 UTC

Size: 19.28 KB

patch

obsolete

>---------------- Test with LO 3.6.4.3 and HSQLDB 2.3.0 (prerelease)
>---------------- HSQLDB Server database and the LibreOffice database were created in a previous session, then both closed
>---------------- In this session, the server is started, the LibreOffice database is opened, 
>---------------- the TEST TABLE (1000 rows) is double clicked and viewed, the table view window is closed, the LO database is closed
>---------------- full server console output during the session, with added comments
>---------------- shows excessive calls to IS_READONLY_DATABSE()
>---------------- shows some unnecessary SQLPREPARE calls
>---------------- shows one SQLPREPARE that is never closed
>---------------- shows many SQLEXECUTE with the result set never closed
>[Server@1e51060]: [Thread[HSQLDB Server @1e51060,5,main]]: Opening database: [file:/hsql/testcache/test]
>[Server@1e51060]: Database [index=0, id=0, db=file:/hsql/testcache/test, alias=] opened sucessfully in 2657 ms.
>[Server@1e51060]: [Thread[HSQLDB Server @1e51060,5,main]]: openDatabases() exiting
>[Server@1e51060]: Startup sequence completed in 2672 ms.
>[Server@1e51060]: 2013-01-22 00:51:12.830 HSQLDB server 2.3.0 is online on port 9001
>[Server@1e51060]: To close normally, connect and execute SHUTDOWN SQL
>[Server@1e51060]: From command line, use [Ctrl]+[C] to abort abruptly
>[Server@1e51060]: [Thread[main,5,main]]: start() exiting
>[Server@1e51060]: [Thread[HSQLDB Server @1e51060,5,main]]: handleConnection(Socket[addr=/127.0.0.1,port=4187,localport=9001]) entered
>[Server@1e51060]: [Thread[HSQLDB Server @1e51060,5,main]]: handleConnection() exited
>[Server@1e51060]: [Thread[HSQLDB Connection @4a6cbf,5,HSQLDB Connections @1e51060]]: 0:Trying to connect user 'sa' to DB ()
>[Server@1e51060]: [Thread[HSQLDB Connection @4a6cbf,5,HSQLDB Connections @1e51060]]: 0:Connected user 'sa'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLETYPES
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TRUE AND TABLE_NAME LIKE '%'
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TRUE AND TABLE_NAME LIKE '%' AND TABLE_TYPE IN ('VIEW')
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST' AND COLUMN_NAME LIKE '%'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'ZIP'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'ZIP' AND COLUMN_NAME LIKE '%'
>[Server@1e51060]: 0:SELECT * FROM "PUBLIC"."PUBLIC"."TEST" WHERE 0 = 1
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_PRIMARYKEYS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_CROSSREFERENCE WHERE TRUE AND FKTABLE_CAT = 'PUBLIC' AND FKTABLE_SCHEM = 'PUBLIC' AND FKTABLE_NAME = 'TEST' ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, KEY_SEQ
>[Server@1e51060]: 0:SQLCLI:SQLPREPARE SELECT * FROM "PUBLIC"."PUBLIC"."TEST" WHERE ( 0 = 1 )
>[Server@1e51060]: 0:SQLCLI:SQLFREESTMT:1
>[Server@1e51060]: 0:SQLCLI:SQLPREPARE SELECT * FROM "PUBLIC"."PUBLIC"."TEST" WHERE ( 0 = 1 )
>[Server@1e51060]: 0:SQLCLI:SQLFREESTMT:2
>[Server@1e51060]: 0:SQLCLI:SQLPREPARE SELECT * FROM "PUBLIC"."PUBLIC"."TEST" WHERE ( 0 = 1 )
>[Server@1e51060]: 0:SQLCLI:SQLFREESTMT:3
>[Server@1e51060]: 0:SQLCLI:SQLPREPARE SELECT * FROM "PUBLIC"."PUBLIC"."TEST"
>---------------- last SQLPREPARE has statement id 4 which is never uses and never closed
>[Server@1e51060]: 0:SQLCLI:SQLPREPARE SELECT * FROM "PUBLIC"."PUBLIC"."TEST"
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:5
>---------------- last SQLPREPARE has statement id 5 which is used to generate the result set with SQLEXECUTE 5
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:CALL USER()
>[Server@1e51060]: 0:CALL USER()
>[Server@1e51060]: 0:SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM,TABLE_NAME, COLUMN_NAME, GRANTOR, GRANTEE, PRIVILEGE_TYPE PRIVILEGE, IS_GRANTABLE FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES WHERE TRUE  AND TABLE_CATALOG = 'PUBLIC' AND TABLE_SCHEMA = 'PUBLIC' AND TABLE_NAME = 'TEST' AND COLUMN_NAME LIKE '%'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VERSIONCOLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VERSIONCOLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VERSIONCOLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VERSIONCOLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VERSIONCOLUMNS WHERE TRUE AND TABLE_CAT = 'PUBLIC' AND TABLE_SCHEM = 'PUBLIC' AND TABLE_NAME = 'TEST'
>[Server@1e51060]: 0:SQLCLI:SQLPREPARE SELECT * FROM "PUBLIC"."PUBLIC"."TEST" WHERE ( 1 = ? AND "PUBLIC"."PUBLIC"."TEST"."ID" = ? OR 1 = ? AND "PUBLIC"."PUBLIC"."TEST"."ID" IS NULL )
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>---------------- after last SQLEXECUTE 6 (the single row select) the result set is not closed (not released)
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:CALL IS_READONLY_DATABASE()
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>[Server@1e51060]: 0:SQLCLI:SQLEXECUTE:6
>---------------- SQLEXECUTE 6 (single row select ) is performed nearly 300 times for a table that contains 1000 rows and the result sets are not closed (not released)
>[Server@1e51060]: 0:SQLCLI:SQLFREESTMT:6
>---------------- the prepared statement for the single row select is closed
>[Server@1e51060]: 0:HQLCLI:CLOSE_RESULT:RESULT_ID 138
>---------------- the result for SQLEXECUTE 5 (the main select) is closed
>[Server@1e51060]: 0:SQLCLI:SQLFREESTMT:5
>-------------------------- the prepared statement for the main select is closed
>[Server@1e51060]: 0:SQLCLI:SQLDISCONNECT

Actions: View

Attachments on bug 53333: 73451