For some reason, at times our application throws up an error
reading
something like,
"Exception in dbxpint.dll ...."

Can anyone throw any light on it?


Regards,

Anand S. Kashelkar
Senior Programmer
MicroWorld Software Services Pvt. Ltd.
Mumbai

----- Original Message -----
From: <firebird-support@yahoogroups.com>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, October 26, 2003 07:36 PM
Subject: [firebird-support] Digest Number 1820


------------------------ Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com


------------------------------------------------------------------------

There are 5 messages in this issue.

Topics in this digest:

1. Re: Index question
From: Aage Johansen <aagjohan@...>
2. profiling a (fairly large) SQL application
From: "Peppe Polpo" <octopushole@...>
3. Re: Firebird 1.5 segfault
From: "Fred Polizo Jr." <fpsys2002@...>
4. Re: How do you use XNET?
From: Olivier Mascia <om@...>
5. Event-ID 251
From: "swestner" <s@...>


________________________________________________________________________
________________________________________________________________________

Message: 1
Date: Sat, 25 Oct 2003 17:45:31 +0200
From: Aage Johansen <aagjohan@...>
Subject: Re: Index question

On Fri, 24 Oct 2003 21:05:23 +0000 (UTC), Yves Glodt wrote:

>> > we are trying to enhance performance of an application we
>> > resell. ...

> ...
> and then:
>
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 9, 145123, xxxxx);
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 10, 145123, xxxxx);
> repeat 20 times...
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 9, 145124, xxxxx);
> INSERT INTO WT_CPT_VAL VALUES (31, 500, 10, 145124, xxxxx);
> repeat 20 times...
> etc
>


If you're doing it exactly like this you may be burdened by a
'prepare' for
each INSERT.


--
Aage J.



________________________________________________________________________
________________________________________________________________________

Message: 2
Date: Sun, 26 Oct 2003 08:59:06 -0000
From: "Peppe Polpo" <octopushole@...>
Subject: profiling a (fairly large) SQL application

I began writing a few SPs and in the end I got a full-fledged
application written in SQL.

The user sends 3 parameters to the FB database and - after many
minutes - gets the processed data.

(From this experience I understood a litle better what's the use
of 3-
tiers applications, but this is a different matter).

Now here am I: a fairly large application written in SQL, that,
after
a time consuming debugging, works - or apparently works :) - the
way
it should.

The last remaining step is to profile the application, as the
answer
time is rather slow.

I devised the following idea:

1. get the system time at the beginning of every SP
2. get the system time at the end of every SP
3. calculate the difference and store the SP name and the
elapsed
time in a profile table

In the end, the profile table can give:
1. the SPs that are called most
2. the SPs that steal most of the time

hopefully both kinds can be rewritten so to be faster.

The task is not easy, as the number of SPs is large and there
can be
several exit points in a SP to handle.

If you have better ideas, I have big ears.

Best regards

Peppe Polpo



________________________________________________________________________
________________________________________________________________________

Message: 3
Date: Sun, 26 Oct 2003 01:01:41 -0800
From: "Fred Polizo Jr." <fpsys2002@...>
Subject: Re: Firebird 1.5 segfault

Brad Pepers wrote:
> So the question is whether the problem is with Qt redefining
operator
delete[]
> in some bad way or is it with Firebird.

I just had a few minutes free to test this. So, this isn't an
in-depth
analysis, but I think I have another explanation for you
segfault...

I installed FirebirdCS-1.5.0.3780-RC6.i686.rpm on a system
running
RH8+updates and was able to reproduce your segfault. I did,
however, get a
different stack trace (below). This may be because I recently
installed gdb
6.0 on this system to get some debugger fixes. In my case, the
segfault is
coming from the -lstdc++ library delete operator, which makes
more sense:

#0 0x4098ff54 in free () from /lib/libc.so.6
#1 0x40561853 in operator delete(void*) (ptr=0x8000000)
at ../../../../libstdc++-v3/libsupc++/del_op.cc:39
#2 0x4056187f in operator delete[](void*) (ptr=0x8000000)
at ../../../../libstdc++-v3/libsupc++/del_opv.cc:36
#3 0x407ce649 in ParsedPath::~ParsedPath() () from
/usr/lib/libfbembed.so.1
#4 0x407d2258 in DirectoryList::IsPathInList(Firebird::PathName
const&) ()
from /usr/lib/libfbembed.so.1
#5 0x407179fe in ISC_lookup_entrypoint () from
/usr/lib/libfbembed.so.1
#6 0x40717681 in ISC_lookup_entrypoint () from
/usr/lib/libfbembed.so.1
#7 0x406a8d2e in isc_unwind_request () from
/usr/lib/libfbembed.so.1
#8 0x4069f407 in isc_attach_database () from
/usr/lib/libfbembed.so.1
#9 0x4076f261 in PREPARSE_execute () from
/usr/lib/libfbembed.so.1
#10 0x406a3303 in isc_dsql_exec_immed2_m () from
/usr/lib/libfbembed.so.1
#11 0x406a3025 in isc_dsql_exec_immed2 () from
/usr/lib/libfbembed.so.1
#12 0x406a2de3 in isc_dsql_execute_immediate () from
/usr/lib/libfbembed.so.1
#13 0x0804867c in main (argc=2, argv=0xbffff484) at
fb_test.cpp:15

The real "conflict" appears to be with the -lstdc++ library
which also
defines global delete and delete[] operators (see "P.S." below
for details).
I replaced -lqt-mt with -lstdc++ in your link command and it
produces a
runtime segfault as well:
g++ -g -O0 -o fb_test fb_test.o -lstdc++ -lgds

So, whichever library gets linked into your application first
defines the
delete operators -- the order of libraries given to the linker
is important.
So, as you already know, link with -lgds as the first library in
your link
command and you shouldn't see segfaults.

I Gotta run... hope this helps,
---Fred P.

P.S. I used 'nm' to dump the external symbols from the the two
libraries.
Here you can see that each library defines global delete
operators:

$ nm -g -C -D
/usr/lib/gcc-lib/i386-redhat-linux/3.2/libstdc++.so | grep
'operator delete'
00089e20 T operator delete[](void*)
00089e50 T operator delete[](void*, std::nothrow_t const&)
00089dc0 T operator delete(void*)
00089df0 T operator delete(void*, std::nothrow_t const&)

$ nm -g -C -D /usr/lib/libgds.so | grep 'operator delete'
0016d4d0 T operator delete[](void*)
0016d480 T operator delete(void*)
00099570 W pool_alloc<(short)4>::operator delete(void*)
0011df60 W pool_alloc_rpt<char, (short)17>::operator
delete(void*)
000845e0 W pool_alloc_rpt<char, (short)22>::operator
delete(void*)
0011dfa0 W pool_alloc_rpt<char, (short)6>::operator
delete(void*)






________________________________________________________________________
________________________________________________________________________

Message: 4
Date: Sun, 26 Oct 2003 10:02:18 +0100
From: Olivier Mascia <om@...>
Subject: Re: How do you use XNET?

Hello,

On Sat, 25 Oct 2003 15:53:10 +0400,
Dmitry Yemanov wrote:

DY> In fact, it's already implemented in v2.0 ;-)

And works very fine !

--
Best Regards,
Olivier Mascia





________________________________________________________________________
________________________________________________________________________

Message: 5
Date: Sun, 26 Oct 2003 12:24:24 -0000
From: "swestner" <s@...>
Subject: Event-ID 251

Hello,

I use Windows 2000 Server SP 4 with Firebird 1.5 RC 6. Every
time I
start my Server I get an entry in the
application-event-protocoll:

Die Beschreibung der Ereigniskennung (251) in (FirebirdGuardian)
wurde nicht gefunden. Der lokale Computer verf�gt nicht �ber die
zum
Anzeigen der Meldungen von einem Remotecomputer erforderlichen
Registrierungsinformationen oder DLL-Meldungsdateien.
Ereignisinformationen: Server Started: Guardian starting:
d:\Programme\Firebird\bin\fbserver.exe�z.

Translated into english:
The description of the event-id (251) in (FirebirdGuardin) was
not
found. The local computer does not have the necessary registry
informations to display messages from a remote computer or DLL-
messages-files.

Could somebody help me how to get rid of these entry?

Thanks

Stefan Westner



________________________________________________________________________
________________________________________________________________________



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/




__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/