Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

What does this interbase.log entry mean?

80 views
Skip to first unread message

Michael Danninger

unread,
Apr 25, 2007, 4:48:36 PM4/25/07
to
CLUSTER1 (Server) Wed Apr 25 17:56:55 2007

Floating-point invalid operand.
An indeterminate error occurred during a
floating-point operation.
This exception will cause the InterBase server
to terminate abnormally.

This is IB2007 on a 4GB ram 2*Xeon dualcore machine with Windows 2003
Enterprise Server.
Is there something i can do to avoid errors like this? Any hints why this
happens?


Thanks, Michael

More of this interbase.log:

CLUSTER1 (Server) Wed Apr 25 17:42:37 2007
INET/inet_error: read errno = 10054 client host = CLUSTER2 connection name
= cluster1 user name = LABOR server port number = 0

CLUSTER1 (Server) Wed Apr 25 17:56:55 2007

Floating-point invalid operand.
An indeterminate error occurred during a
floating-point operation.
This exception will cause the InterBase server
to terminate abnormally.

CLUSTER1 (Client) Wed Apr 25 17:56:55 2007
C:\Programme\Borland\InterBase\bin\ibserver.exe: terminated abnormally (-1)


CLUSTER1 (Server) Wed Apr 25 17:56:57 2007
SERVER/set_process_affinity: hyper-threading ProcessAffinityMask is 3

CLUSTER1 (Server) Wed Apr 25 17:56:57 2007
SERVER/set_process_affinity: setting ProcessAffinityMask to 3

CLUSTER1 (Server) Wed Apr 25 17:56:57 2007
Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000,
SWEEP_YIELD_TIME to 1 ms, and MAX_THREADS to 1000000
SQL_COMPILER_RECURSION to 2000


CLUSTER1 (Client) Wed Apr 25 17:56:58 2007
Guardian starting: C:\Programme\Borland\InterBase\bin\ibserver.exe


Bill Todd

unread,
Apr 25, 2007, 9:26:28 PM4/25/07
to
Are you using any user define functions (UDFs)?

--
Bill Todd (TeamB)

Michael Danninger

unread,
Apr 26, 2007, 12:29:10 AM4/26/07
to
> Are you using any user define functions (UDFs)?

Yes, i am. But i am using them with ib 6020 since some years without any
problems, so i did not think they could cause this one. Do they have to be
defined different to work with IB2007?

Michael


Craig Stuntz [TeamB]

unread,
Apr 26, 2007, 9:38:22 AM4/26/07
to
Michael Danninger wrote:

> Yes, i am. But i am using them with ib 6020 since some years without
> any problems, so i did not think they could cause this one.

Sure they can. IB 7+ is *much* more aggressively multithreaded.
Particularly on a SMP or hyper-threading processor, you're practically
guaranteed to see any concurrency bugs your UDFs might have, whereas in
6.x and earlier you could often get away with it.

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Want to help make Delphi and InterBase better? Use QC!
http://qc.borland.com -- Vote for important issues

Bill Todd

unread,
Apr 26, 2007, 10:02:23 AM4/26/07
to
Michael Danninger wrote:

> Do they have to be defined different to work with IB2007?

IB 7 and later are multi-threaded and multi-threading will be used a
lot on multi-processor hardware. That means that you can expect any UDF
that is not thread safe to suddenly fail.

--
Bill Todd (TeamB)

Michael Danninger

unread,
Apr 26, 2007, 12:12:22 PM4/26/07
to
> IB 7 and later are multi-threaded and multi-threading will be used a
> lot on multi-processor hardware. That means that you can expect any UDF
> that is not thread safe to suddenly fail.

I am using FreeUDFLib and added one function, which we use a lot in stored
procedures. I thought FreeUDFLib is thread safe (using makeresultstring to
return a string). The function i defined worked without any problems with
IB6020 and IB7 for years, and with IB2007 for 2 months. Should i rewrite it?
What would be a good starting point?

Thanks, Michael


Bill Todd

unread,
Apr 26, 2007, 1:43:02 PM4/26/07
to
Lots of people use FreeUDFLib so I would guess that any problems in it
have been found and fixed. What changed two months ago when IB2007
started exhibiting the problem?

--
Bill Todd (TeamB)

Michael Danninger

unread,
Apr 26, 2007, 4:38:07 PM4/26/07
to
> Lots of people use FreeUDFLib so I would guess that any problems in it
> have been found and fixed. What changed two months ago when IB2007
> started exhibiting the problem?

IB2007 did not start to exhibit the problem two months ago, it worked fine
for two months, (since project start). The error happened once until now
(yesterday), without any configuration changes i know. In the FreeUDFLib
source comments i can see the last changes Mar. 10, 1998. Is there a newer
version?

Michael


Bill Todd

unread,
Apr 26, 2007, 7:31:59 PM4/26/07
to
Michael Danninger wrote:

> Is there a newer version?

Sorry, I have no idea.

--
Bill Todd (TeamB)

Tom W

unread,
Apr 27, 2007, 12:30:28 AM4/27/07
to
Michael,

I VERY HIGHLY recommend the FreeAdhocUDF, it is the next generation of
FreeUDFLib. I works on Windows and Linux, InterBase and Firebird. It is
an OUTSTANDING piece of work.

Get it here => ftp://ftp.adhoc-data.de/FreeAdhocUDF/

Tom

Michael Danninger

unread,
Apr 27, 2007, 10:14:10 AM4/27/07
to
> I VERY HIGHLY recommend the FreeAdhocUDF, it is the next generation of
> FreeUDFLib. I works on Windows and Linux, InterBase and Firebird. It is
> an OUTSTANDING piece of work.
>
> Get it here => ftp://ftp.adhoc-data.de/FreeAdhocUDF/
>
> Tom

Thanks for the hint! I will have a look at it,

Michael


0 new messages