Unfortunately,

i can't help you but i hope your strong work to reproduce the error
can help us too. Because we have the same problem and i posted it to
the newsgroup some times. But as you mentionend it's very difficult
for the developers to find the error if you can't describe it in
greater details.

Therefore thanks and i hope the fb-developer team will check out what
happens so fast as possible

Gerhard

--- In firebird-support@yahoogroups.com, "kimon_the_athenian2"
<kimon_the_athenian2@y...> wrote:

> Hi!
>
> I've wittnessed the same thing that kokok_kokok told about:

seemingly

> random FB 1.5 crashes on Windows (I haven't experienced the crash

on

> Win2000, though, only XP on Pro, and only while browsing in
> IBConsole, last time it happened while browsing StoredProc
> dependencies). No specific error messages, only illegal access and
> error report dialog.
>
> Aivar
>
> --- In firebird-support@yahoogroups.com, "kokok_kokok"
> <kokok_kokok@y...> wrote:
> > Problem:
> > ------------
> > A simple program can shutdown the Firebird server placed in a
> remote
> > PC.
> >
> > I have put several messages in this forum about this problem
> without
> > results, probably because this problem is hard to reproduce. Now,

I

> > have isolated it and in this example, the problem always arises.
> > The thing is that some combination of `selects' shutdown the FB
> > server, showing `Lost Connection' message, and of course, all FB
> > clients lose their connections, in remote and local mode.
> >
> > I have noted that if you modify the view FEMALE, the problem is
> > minimized but it is even latent. Also, the "cast" operator in the
> > view can mimize the frequency of the problem in an important way,
> but
> > it is only question of time. In few words: I have no idea about

the

> > reason.
> >
> >
> > Environment:
> > ----------
> > Firebird version 1.5
> > IBObjects 4.2 Ie
> > Builder C++6
> > OS: This problem appear in Windows XP Professional, XP Home and
> > Windows 2000. I do not know in W98.
> > Hardware: Several computers
> >
> > It happens in remote connections via TCP/IP and also in local

mode.

> >
> > Example:
> > -----------
> > I have upload the source, binaries and database example at:
> > http://www.fut.es/~xmarquez/LostConnection.zip
> >
> >
> > Steps to reproduce the problem:
> > -------------------------------------
> >
> > 1-Enter the database parameters (try in local mode and remote

mode)

> > 2-Click `Connect'
> > 3-Click `Test'
> > 4-Click `Test'
> > 5-Click `Test'
> >
> > Only at the third click in `Test' button, the lost connection
> message
> > appear.
> >
> > ---------
> >
> > Another way to reproduce it is:
> >
> > 1-Delete the query "select * from female" from the CPP code
> > 2-Compile and Execute
> > 3-Click `Connect' and `Test'
> > 4-Now, from IBConsole or any SQL client, execute "select * from
> > female" stantement
> > 5-Return to the program and click "Test" several times. The FB
> server
> > will be shutdown. Note that if you do not execute "select * from
> > female", everything works ok.
> >
> >
> > -----
> > firebird.log file:
> >
> > NETVISTA (Client) Fri May 28 13:27:34 2004
> > C:\Archivos de programa\Firebird\Firebird_1_5
> > \bin\fbserver.exe: terminated abnormally (4294967295)
> > ------------
> >
> > CPP code:
> > -----------
> >
> > void __fastcall TForm1::btnTestClick(TObject *Sender)
> > {
> > try
> > {
> > cdsTest->FetchParams();
> > cdsTest->Params->ParamByName("hType")->Value =0;
> > cdsTest->Params->ParamByName("Codi")->AsString ="372";
> > cdsTest->Open();
> >
> > qryTest2->SQL->Text="select * from female";
> > qryTest2->Open();
> > }
> > __finally
> > {
> > cdsTest->Close();
> > qryTest2->Close();
> > }
> > }
> > //----------------------------------------------------------------

--

> --
> > -------
> >
> > void __fastcall TForm1::btnButtonClick(TObject *Sender)
> > {
> > dbMainDatabase->Protocol=cbLocal->Checked? cpLocal: cpTCP_IP;
> > dbMainDatabase->Server=edServer->Text;
> > dbMainDatabase->Path=edDatabase->Text;
> >
> > dbMainDatabase->Connected=true;
> > ShowMessage("Connection OK");
> > }
> > //----------------------------------------------------------------

--

> --
> > -------
> >
> >
> > DFM file:
> >
> > object Form1: TForm1
> > Left = 323
> > Top = 174
> > Width = 327
> > Height = 204
> > Caption = 'v'
> > Color = clBtnFace
> > Font.Charset = DEFAULT_CHARSET
> > Font.Color = clWindowText
> > Font.Height = -11
> > Font.Name = 'MS Sans Serif'
> > Font.Style = []
> > OldCreateOrder = False
> > PixelsPerInch = 96
> > TextHeight = 13
> > object Label1: TLabel
> > Left = 24
> > Top = 64
> > Width = 31
> > Height = 13
> > Caption = 'Server'
> > end
> > object Label2: TLabel
> > Left = 24
> > Top = 96
> > Width = 46
> > Height = 13
> > Caption = 'Database'
> > end
> > object btnTest: TButton
> > Left = 168
> > Top = 136
> > Width = 75
> > Height = 25
> > Caption = 'Test'
> > TabOrder = 0
> > OnClick = btnTestClick
> > end
> > object btnButton: TButton
> > Left = 80
> > Top = 136
> > Width = 75
> > Height = 25
> > Caption = 'Connect'
> > TabOrder = 1
> > OnClick = btnButtonClick
> > end
> > object edServer: TEdit
> > Left = 88
> > Top = 56
> > Width = 217
> > Height = 21
> > TabOrder = 2
> > Text = 'localhost'
> > end
> > object edDatabase: TEdit
> > Left = 88
> > Top = 88
> > Width = 217
> > Height = 21
> > TabOrder = 3
> > Text = 'test.fdb'
> > end
> > object cbLocal: TCheckBox
> > Left = 88
> > Top = 32
> > Width = 137
> > Height = 17
> > Caption = 'Protocol cpLocal'
> > Checked = True
> > State = cbChecked
> > TabOrder = 4
> > end
> > object qryPrvHerd: TIBOQuery
> > Params = <
> > item
> > DataType = ftSmallint
> > Name = 'HTYPE'
> > ParamType = ptInput
> > end
> > item
> > DataType = ftString
> > Name = 'CODI'
> > ParamType = ptInput
> > end>
> > DatabaseName = 'test.fdb'
> > IB_Connection = dbMainDatabase
> > RecordCountAccurate = False
> > RequestLive = True
> > SQL.Strings = (
> > 'SELECT * FROM HERD WHERE HTYPE=:HTYPE AND CODI=:CODI')
> > FieldOptions = []
> > Left = 72
> > Top = 65534
> > end
> > object prvHerd: TDataSetProvider
> > DataSet = qryPrvHerd
> > Constraints = True
> > Left = 104
> > end
> > object cdsTest: TClientDataSet
> > Aggregates = <>
> > Params = <>
> > ProviderName = 'prvHerd'
> > Left = 136
> > Top = 65528
> > end
> > object qryTest2: TIBOQuery
> > Params = <
> > item
> > DataType = ftSmallint
> > Name = 'HTYPE'
> > ParamType = ptInput
> > end
> > item
> > DataType = ftString
> > Name = 'CODI'
> > ParamType = ptInput
> > end>
> > DatabaseName = 'test.fdb'
> > IB_Connection = dbMainDatabase
> > RecordCountAccurate = False
> > RequestLive = True
> > SQL.Strings = (
> > 'SELECT * FROM HERD WHERE HTYPE=:HTYPE AND CODI=:CODI')
> > FieldOptions = []
> > Left = 40
> > Top = 65534
> > end
> > object dbMainDatabase: TIBODatabase
> > SQLDialect = 3
> > Params.Strings = (
> > 'PAGE SIZE=4096'
> > 'PATH=test.fdb'
> > 'SQL DIALECT=3'
> > 'USER NAME=SYSDBA')
> > AutoCommit = False
> > Left = 8
> > SavedPassword = '.JuMbLe.01.432B0639073E0E4B49'
> > end
> > end