Skip site navigation (1) Skip section navigation (2)

Fwd: Fwd: Lots of nan's

From: Lynn(dot)Tilby(at)asu(dot)edu
To: pgsql-novice(at)postgresql(dot)org
Cc: ltilby(at)asu(dot)edu
Subject: Fwd: Fwd: Lots of nan's
Date: 2004-02-09 23:42:26
Message-ID: 1076370145.40281ae201524@webmail.asu.edu (view raw or flat)
Thread:
Lists: pgsql-novice
I was wondering if someone could give me a status or
a response on this?  Is it something that is unsolvable,
just on the list, or a new flavor of a current problem, or
is it just being worked on and no one has found a solution?
Is there anything I can or should be doing to solve this,
or is this a postgres internals issue?

Thanks again in advance for your help!  I have been on your
side of the e-mails before and I understand this stuff takes a
lot of time from people who are very busy to begin with.
Just drop me a note and let me know where this stands and what
I can do.

Best Regards,
Lynn

----- Forwarded message from Lynn(dot)Tilby(at)asu(dot)edu -----
Date: Mon, 02 Feb 2004 15:23:09 -0700 (MST)
From: Lynn(dot)Tilby(at)asu(dot)edu
Reply-To: Lynn(dot)Tilby(at)asu(dot)edu
Subject: Fwd: Lots of nan's
To: pgsql-novice(at)postgresql(dot)org

I copeid myself on this forward and never received it so
I am sending it again....

It has been over a week and I have not seen this posted.
I was just wondering if this got lost or something...

Thanks for your help!
Lynn

----- Forwarded message from Lynn(dot)Tilby(at)asu(dot)edu -----
Date: Thu, 22 Jan 2004 21:56:57 -0700 (MST)
From: Lynn(dot)Tilby(at)asu(dot)edu
Reply-To: Lynn(dot)Tilby(at)asu(dot)edu
Subject: Lots of nan's
To: pgsql-novice(at)postgresql(dot)org

I am getting nan's all over the place...

I am running RH9 with the 2.4.20-27.9 #1 kernel, and Postgres 7.3

I have a debug macro as follows:

#define DBG_SQL(strng) if(DEBUG > 0) \
{ \
  fprintf(DBG_OUT,"\n******DBG_SQL: %s\n",strng); \
  fprintf(DBG_OUT,"sqlcaid                = %s\n", sqlca.sqlcaid); \
  fprintf(DBG_OUT,"sqlabc                 = %f\n", sqlca.sqlabc); \
  fprintf(DBG_OUT,"sqlcode                = %f\n", sqlca.sqlcode); \
  fprintf(DBG_OUT,"sqlca.sqlerrm.sqlerrml = %d\n", sqlca.sqlerrm.sqlerrml); \
  fprintf(DBG_OUT,"sqlca.sqlerrm.sqlerrmc = %s\n", sqlca.sqlerrm.sqlerrmc); \
  fprintf(DBG_OUT,"sqlerrp                = %s\n", sqlca.sqlerrp); \
  fprintf(DBG_OUT,"sqlerrd                = %f\n", sqlca.sqlerrd); \
  fprintf(DBG_OUT,"sqlext                 = %s\n", sqlca.sqlext); \
} \
 
I get the following output when turning on debugging, not all of the time, but
only occasionally:

******DBG_SQL: after CONNECT TO pma
sqlcaid                = SQLCA   
sqlabc                 = nan
sqlcode                = nan
sqlca.sqlerrm.sqlerrml = 0
sqlca.sqlerrm.sqlerrmc =
sqlerrp                = NOT SET
sqlerrd                = nan
sqlext                 =

******DBG_SQL: after WHENEVER sqlerror sqlprint
sqlcaid                = SQLCA   
sqlabc                 = nan
sqlcode                = nan
sqlca.sqlerrm.sqlerrml = 0
sqlca.sqlerrm.sqlerrmc =
sqlerrp                = NOT SET
sqlerrd                = nan
sqlext                 =

******DBG_SQL: after CREATE TABLE stck_rnkg_tmp
sqlcaid                = SQLCA   
sqlabc                 = nan
sqlcode                = nan
sqlca.sqlerrm.sqlerrml = 0
sqlca.sqlerrm.sqlerrmc =
sqlerrp                = NOT SET
sqlerrd                = nan
sqlext                 =
.
.
.
.

PLEASE NOTE! I have searched for the string 'nan' in all tables, data and code
and have not been able to find it.  I have also searched the .c output
from ecpg and not found anything.  Nan stands for not a number.

Further down in the code I get the following error:

sql error 'ERROR:  Attribute "nan" not found' in line 1235.

Line 1235 in the code is simply C code not SQL, and is C code for 20+ lines
both above and below line 1235.  I have also looked at the .c output from 
ecpg but have not found anything remotely connected.

Further down in the code when printing out further debugging info I get this:

tot_sl_prce = nan
t_expr_c_date_num = 20031017
t_by_date_num = 731490
tc_exp_date_num = 20031017
tc_exp_date_dys = 731506
t_sl_comm = 0.000000
tot_crnt_prce = 0.000000
tot_sl_prce = nan
tot_by_prce = nan
t_prft_los = nan
t_pct_prft_los = nan

Still more variables take on the value of nan.  Then a little further I get
this:

sqlcaid                = SQLCA   
sqlabc                 = 0.000000
sqlcode                = 0.000000
sqlca.sqlerrm.sqlerrml = 49
sqlca.sqlerrm.sqlerrmc = 'ERROR:  Attribute "nan" not found' in line 1235.
sqlerrp                = NOT SET
sqlerrd                = 0.000000
sqlext                 =



In doing searches on the Pgsql site I found that 'attribute' is a historical
term for column heading; but since I don't have any columns of the name nan
I can't see where 'nan' cannot be found.  I found nothing on the pgsql site
for nan, but, In searching google for nan+postgres I got about 1180 hits; but,
none of the ones I looked at were current so I don't know if this problem has
been fixed yet.

The really interesting thing is when I let this prog run it consistently 
crashes RedHat and I have to do a hardware reset to reboot.

How do I solve this problem?

Thanks for your help!!!!
Lynn


----- End forwarded message -----

----- End forwarded message -----

Responses

pgsql-novice by date

Next:From: Michal HolečkaDate: 2004-02-10 01:03:52
Subject: function that returns dynamicly created table
Previous:From: Tom AnsleyDate: 2004-02-09 21:28:33
Subject: unsubscribe pgsql-novice

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group