Sure, no problem! I see the source.


2013/8/26 IBO Support List <supportlist@...>

> **
>
>
> I have just posted some additional information gathering to the tip of my
> development repository.
>
> Could you do the following please?
>
> Update to the latest in my SVN repository.
> Turn on mgClientTrace in MonitorGroups for your TIB_Monitor.
> Regenerate this SQL trace again with the new information.
>
> Thanks!
>
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf
> Of DanyM
> Sent: Monday, August 26, 2013 2:23 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Re: IBO 5.2.0.7 and strange error on connect to the server
>
> In another post in this thread you asked for a Monitor dump. This is what i
> get on that machine:
>
> /*---
> CONNECT DATABASE '192.168.100.15:D:\Data\firstlane\shia.fdb'
> user_name = 'SYSDBA'
> password = '********' (redacted)
> DB_HANDLE = 1
>
> SECONDS = 0,016
> ----*/
> /*---
> START TRANSACTION
> DB HANDLE COUNT 1
> DB HANDLE 1 = 1
> TPB VERSION 3
> read
> TR_HANDLE = 2
>
> SECONDS = 0,031
> ----*/
> /*---
> DATABASE INFO
> DB_HANDLE = 1
> ----*/
> /*---
> EXECUTE IMMEDIATE 2
> DB_HANDLE = 1
> TR_HANDLE = 2
> Dialect = 3
>
> SELECT D.RDB$CHARACTER_SET_NAME FROM RDB$DATABASE D
>
> PARAMS = [ ]
> FIELDS = [ Version 1 SQLd 1 SQLn 1 BasePtr: 0017F474
> [CHARSET] = 'WIN1252
> ' (128 bytes) < TEXT SubType: 0 Len: 128 Scale: 0 Ind/SQL Data Offsets:
> 0/-142 > ]
> ----*/
> /*---
> COMMIT
> TR_HANDLE = 2
>
> SECONDS = 0,015
> ----*/
> /*---
> DISCONNECT DATABASE
> DB_HANDLE = 1
> ----*/
> /*---
> CONNECT DATABASE '192.168.100.15:D:\Data\firstlane\shia.fdb'
> user_name = 'SYSDBA'
> password = '********' (redacted)
> lc_ctype = 'WIN1252'
> DB_HANDLE = 3
> ----*/
> /*---
> DATABASE INFO
> DB_HANDLE = 3
>
> SECONDS = 0,016
> ----*/
> /*---
> INTERPRET BUFFER = unknown ISC error 0
> MSG_LEN = 19
> ----*/
> /*---
> INTERPRET BUFFER =
> MSG_LEN = 0
> ----*/
> /*---
> INTERPRET BUFFER = unknown ISC error 0
> MSG_LEN = 19
> ----*/
> /*---
> INTERPRET BUFFER =
> MSG_LEN = 0
> ----*/
> /*---
> INTERPRET BUFFER = unknown ISC error 0
> MSG_LEN = 19
> ----*/
> /*---
> INTERPRET BUFFER =
> MSG_LEN = 0
> ----*/
>
> This indicates that our affected machines are having problems issuing two
> connection in rapid sequence. Odd...
>
> HTH,
>
> /D
>
> --- In IBObjects@yahoogroups.com, "DanyM" <danymarmur@...> wrote:
> >
> >
> >
> > Ops! Mee too!
> >
> > Same scenario: A client windows small business server 2008. Affects the
> IB_FTS Util and my FTS indexing service on that machine. Tried to fiddle
> with the connection parameters to no avail (localhost/127.0.0.1/DNS Name)
> alias or path. No go.
> >
> > The Util is 32-bit and the service is 64-bit. Same diagnose.
> >
> > I can not restart the server from here, but i'll ask the on-site people
> to
> do it when possible.
> >
> > Oh, and i too accessed the clients using Terminal Sever.
> >
> > Regards,
> >
> > /Dany
> >
> >
> >
> > --- In IBObjects@yahoogroups.com, Markus Ostenried <macnoz@> wrote:
> > >
> > > Just had the same problem in an Amazon Windows Server 2012 instance.
> > > Restarting the instance fixed it for now.
> > >
> > >
> > > On Fri, Aug 2, 2013 at 1:10 AM, garethm <gareth@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi,
> > > >
> > > > I have also had sporadic issues with this problem in our internal
> testing.
> > > >
> > > > Here are our observations:
> > > > - We are currently using IBO-5.2.0 Build 6.
> > > > - It can happen when connecting to a Firebird server using TCP and
> > > > when using Firebird in embedded mode.
> > > > - Once this happens, the only way to get applications that use
> > > > IBObjects to connect to databases again appears to be to restart the
> computer.
> > > > Neither restarting the application nor reinstalling the
> > > > application make any difference.
> > > > - Once this happens, our applications cannot connect to local or
> > > > remote databases and both network and embedded Firebird connection
> > > > attempts throw the same "ISC ERROR CODE: 335544648 unknown ISC error
> code 0" exceptions.
> > > > - FlameRobin running on the computer experiencing the issues can
> > > > connect to both local and remote databases without issue.
> > > > - Our application running on other computers can connect to the
> > > > Firebird server running on an affected machine without issue.
> > > > - In one case, this happened after the user logged in to their
> > > > computer via remote desktop, and we aren't sure about the other
> cases.
> > > >
> > > > Any advice on resolving this issue would be appreciated.
> > > >
> > > > Regards,
> > > > Gareth Marshall
> > > >
> > > >
> > > > --- In IBObjects@yahoogroups.com, Marcin Bury <marcin.bury@> wrote:
> > > > >
> > > > > Hello
> > > > >
> > > > > I have recently upgraded IBO library to 5.2.0.7 (the latest
> version).
> > > > > Everything works great except one customer environment. There is
> > > > > MS Terminal Server where application compiled with latest IBO
> > > > > returns following exception after connecting to the Firebird
> > > > > server
> > > > [2.5.1.26266] :
> > > > >
> > > > > ISC ERROR CODE:335544648
> > > > >
> > > > > ISC ERROR MESSAGE:
> > > > > unknown ISC error 0
> > > > >
> > > > > I did some searching and found that this error code represents
> > > > > following
> > > > > error:
> > > > >
> > > > > 335544648 conn_lost Connection lost to pipe server
> > > > >
> > > > > I haven't noticed any similar behavior elsewhere.
> > > > >
> > > > > Below is attached call stack from EurekaLog.
> > > > > Maybe someone will be able to suggest something how to find the
> > > > > cause of the exception...
> > > > >
> > > > > Thanks
> > > > > Marcin
> > > > >
> > > > >
> > > > > |
> > > > > |----------------------------------------------------------|
> > > > > |7FFFFFFE|04
> > > > > |7FFFFFFE||00000000|0090D224|ZT_ML_115.exe|0050D224|IB_Session
> > > > > |TIB_SessionBase|HandleException |1599[106] |
> > > > > |00000040|04 |0012EB20|00719A46|ZT_ML_115.exe|00319A46|EInject
> > > > > | |GetExceptionStackInfoHook |364[9] |
> > > > > |00000040|03
> > > > > |0012EB44|004492D8|ZT_ML_115.exe|000492D8|System.SysUtils|Except
> > > > > |0012EB44|004492D8|ion
> > > > > |RaisingException | |
> > > > > |00000040|04
> > > > > |00000040||0012FC9C|00968303|ZT_ML_115.exe|00568303|IB_Component
> > > > > |00000040|s
> > > > > |TIB_Transaction|API_Start |20100[115] |
> > > > > |00000040|04
> > > > > |00000040||0012FD5C|0096651E|ZT_ML_115.exe|0056651E|IB_Component
> > > > > |00000040|s
> > > > > |TIB_Transaction|SysStart |19021[11] |
> > > > > |00000040|04
> > > > > |00000040||0012FD68|0096773E|ZT_ML_115.exe|0056773E|IB_Component
> > > > > |00000040|s
> > > > > |TIB_Transaction|SetStarted |19652[4] |
> > > > > |00000040|04 |0012FD78|0092EC39|ZT_ML_115.exe|0052EC39|IB_Schema
> > > > > | |GetOldParameterOrder |2163[14] |
> > > > > |00000040|04
> > > > > |00000040||0012FDFC|00960742|ZT_ML_115.exe|00560742|IB_Component
> > > > > |00000040|s
> > > > > |TIB_Connection |SysAfterConnect |16677[38] |
> > > > > |00000040|04
> > > > > |00000040||0012FE60|009601BA|ZT_ML_115.exe|005601BA|IB_Component
> > > > > |00000040|s
> > > > > |TIB_Connection |SysLogin |16491[23] |
> > > > > |00000040|04
> > > > > |00000040||0012FE78|009600A7|ZT_ML_115.exe|005600A7|IB_Component
> > > > > |00000040|s
> > > > > |TIB_Connection |SysConnect |16454[14] |
> > > > > |00000040|04
> > > > > |00000040||0012FE88|0095CCED|ZT_ML_115.exe|0055CCED|IB_Component
> > > > > |00000040|s
> > > > > |TIB_Connection |Connect |15426[7] |
> > > > > |00000040|04 |0012FEA0|00F4102C|ZT_ML_115.exe|00B4102C|DM
> > > > > |T_DM |Set_DB_Connection |453[8] |
> > > > > |00000040|04 |0012FEC8|00F3F7A3|ZT_ML_115.exe|00B3F7A3|DM
> > > > > |T_DM |DataModuleCreate |142[14] |
> > > > > |00000040|03
> > > > > |0012FEF4|004E946F|ZT_ML_115.exe|000E946F|System.Classes
> > > > > |0012FEF4|004E946F||TDataModule
> > > > > |DoCreate | |
> > > > > |00000040|03
> > > > > |0012FF18|004E931C|ZT_ML_115.exe|000E931C|System.Classes
> > > > > |0012FF18|004E931C||TDataModule
> > > > > |AfterConstruction | |
> > > > > |00000040|03
> > > > > |0012FF40|004E92FA|ZT_ML_115.exe|000E92FA|System.Classes
> > > > > |0012FF40|004E92FA||TDataModule
> > > > > |Create | |
> > > > > |00000040|03 |0012FF74|007095E6|ZT_ML_115.exe|003095E6|Vcl.Forms
> > > > > |TApplication |CreateForm | |
> > > > > |00000040|04 |0012FFAC|014C8281|ZT_ML_115.exe|010C8281|ZT_ML
> > > > > | |Initialization |92[5] |
> > > > > |00000040|03 |0012FFC4|7C82F23B|kernel32.dll |0002F23B|kernel32
> > > > > | |(possible ProcessIdToSessionId+521)| |
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
> ------------------------------------
>
> __________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>

--
Analista-Programador
#FollowMe: @felipearon <http://twitter.com/felipearon> (
http://felipearon.net)


[Non-text portions of this message have been removed]