Attachment: fb-memo-watch-while-reconnects.zip [ 12672 ]

description: 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

=>

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

OS: Windows XP SP3

Aux. utilities being used in this test:
1) psList (from SysInternals package - shows list of running processes)
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

PPS.
Seems that NO such problem when change to SuperClassic - it's only in SuperServer.

assignee: Vlad Khorsun [ hvlad ]