Memory leak in FB 3.0 while doing reconnects with valid user/password
---------------------------------------------------------------------

                 Key: CORE-4683
                 URL: http://tracker.firebirdsql.org/browse/CORE-4683
             Project: Firebird Core
          Issue Type: Bug
            Reporter: Pavel Zotov
         Attachments: fb-memo-watch-while-reconnects.zip

FB:  WI-T3.0.0.31603 (both client & server)

OS: Windows XP SP3

Aux. utilities being used in this test:
1) psKill (from SysInternals package)
2) mtee (Stream Splitter, can be taken here: http://www.commandline.co.uk/mtee/ 
)

Main batch:
=========
@echo off
@cls
@rem makes infinite loop with CONNECT & DISCONNECT

setlocal enabledelayedexpansion enableextensions

set fbc=C:\1INSTALL\FB30SNAP
set host=localhost
set port=3333
set dbnm=oltp30

set err=connect.err
:m1
  echo select current_transaction from rdb$database;quit; | %fbc%\isql 
%host%/%port%:%dbnm% -nod -n 1>nul 2>>%err%
goto m1
exit


Batch for watching + logging memory:
==============

@echo off
setlocal enabledelayedexpansion enableextensions
cls

set log=memowatch.log
set intv=5

del %log% 2>nul
set /a intv=%intv%+1
pslist -m 2>nul | findstr /i /c:"name" | mtee /t /+ %log%
:m1
  pslist -m 2>nul | findstr /i /c:"firebird" | mtee /t /+ %log%
  ping -n %intv% 127.0.0.1>nul
goto m1

:end


Window-1: start watching batch
Window-2: start main batch.

After short time one may see in the log or on concole of window-1 that memory 
consumption grows for 'firebird' process.

See in attach:
1) memowatch.log
2) screenshot from PE

PS.

FB config:
========
DefaultDbCachePages = 64K
LockHashSlots = 22111
TempCacheLimit = 2147483647

RemoteServicePort = 3333

MaxUnflushedWrites = -1
MaxUnflushedWriteTime = -1

ExternalFileAccess = Restrict C:\1INSTALL\FBTEST
MaxUserTraceLogSize = 99999

FileSystemCacheThreshold = 65536K
AuthServer = Legacy_Auth,Srp
AuthClient = Legacy_Auth,Srp,Win_Sspi
WireCrypt = Disabled
UserManager = Legacy_UserManager

BugcheckAbort = 1

FB service ImagePath:
==================
C:\1INSTALL\FB30SNAP\firebird.exe -s FB30 -m


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to