Re: [AOLSERVER] ns_ora in Aolserver 4.5 for Win32

2008-04-23 Thread Enrique Catalan
Hi,

We've tried the new nsoracle 2.8 beta version and it is still crashing.  The
error happens in different line but it seems to be the same issue, This time
I got:

 Notice: nsoracle.c:1365:unknown: error in `OCIStmtExecute ()':

The block at Line 1365 is:
if (oci_error_p
(lexpos(), dbh, OCIStmtExecute, query, oci_status)) {
Tcl_SetResult(interp, dbh-dsExceptionMsg.string,
  TCL_VOLATILE);
Ns_OracleFlush(dbh);
return TCL_ERROR;
}

Do you have any ideas why it is crashing?

Thanks a lot,
Enrique.

On Tue, Apr 22, 2008 at 3:16 PM, Enrique Catalan [EMAIL PROTECTED] wrote:

 Hi Dossy,

 Thanks for the link and indeed, that piece of code changed a lot with the
 new function free_fetch_buffers(connection);.

if (oci_error_p (lexpos (), dbh, OCIStmtExecute, query, oci_status))
 {
 Ns_OracleFlush(dbh);
 free_fetch_buffers(connection);
 return TCL_ERROR;
 }

 The version I'm using is the same as it is in
 http://www.friendlybits.com/en/inf_tec_en/win32openacs_en/ .   This is
 using nsoracle 2.7, afaik.  I have asked Maurizio if he could gently include
 the nsoracle 2.8 beta instead of the 2.7 and recompile the whole stuff
 together with this beta version..  Will let you know what happen at the end.

 Thanks again!
 Enrique.


 On Tue, Apr 22, 2008 at 1:27 PM, Dossy Shiobara [EMAIL PROTECTED]
 wrote:

  On 2008.04.22, Enrique Catalan [EMAIL PROTECTED] wrote:
   I found that my server is crashing when it is at line 3905 on the
   nsoracle.c.
 
  What version of nsoracle are you using?  The last tagged release, 2.8b1,
  may have known bugs.  CVS HEAD of nsoracle has a few changes:
 
 http://aolserver.com/sf/cvs/nsoracle/ChangeLog?view=markup
 
  I guess it's time to just tag nsoracle 2.9, maybe.
 
  Can you try building the CVS HEAD version of nsoracle and see if that
  resolves your crash bug?
 
  --
  Dossy Shiobara  | [EMAIL PROTECTED] | http://dossy.org/
  Panoptic Computer Network   | http://panoptic.com/
   He realized the fastest way to change is to laugh at your own
 folly -- then you can let go and quickly move on. (p. 70)
 
 
  --
  AOLserver - http://www.aolserver.com/
 
  To Remove yourself from this list, simply send an email to 
  [EMAIL PROTECTED] with the
  body of SIGNOFF AOLSERVER in the email message. You can leave the
  Subject: field of your email blank.
 




--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] 
with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: 
field of your email blank.


Re: [AOLSERVER] ns_ora in Aolserver 4.5 for Win32

2008-04-23 Thread Dossy Shiobara
On 2008.04.23, Enrique Catalan [EMAIL PROTECTED] wrote:
 Do you have any ideas why it is crashing?

Can you run AOLserver under gdb (there is a Cygwin-compiled Win32 binary
of gdb you can use, if you have Cygwin installed) and give us a
backtrace?  Otherwise, you can use the free WinDbg tool from Microsoft:

http://www.microsoft.com/whdc/devtools/debugging/default.mspx

If you're not familiar with gdb and/or WinDbg and need instructions on
how to elicit a backtrace, let me know and I'll try to write up some
docs.

-- 
Dossy Shiobara  | [EMAIL PROTECTED] | http://dossy.org/
Panoptic Computer Network   | http://panoptic.com/
  He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)


--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] 
with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: 
field of your email blank.


Re: [AOLSERVER] ns_ora in Aolserver 4.5 for Win32

2008-04-23 Thread Enrique Catalan
Hi Dossy,

Thanks for the quick feedback. I used gdb long time ago but only in pure
Linux, not cygwin.  I've never done this before on Windows so any doc/help
would be really appreciated, I'll install WinDbg because there is no Cygwin
on this machine and will try to get the backtrace.

Thanks again!
Enrique

On Wed, Apr 23, 2008 at 3:13 PM, Dossy Shiobara [EMAIL PROTECTED] wrote:

 On 2008.04.23, Enrique Catalan [EMAIL PROTECTED] wrote:
  Do you have any ideas why it is crashing?

 Can you run AOLserver under gdb (there is a Cygwin-compiled Win32 binary
 of gdb you can use, if you have Cygwin installed) and give us a
 backtrace?  Otherwise, you can use the free WinDbg tool from Microsoft:

http://www.microsoft.com/whdc/devtools/debugging/default.mspx

 If you're not familiar with gdb and/or WinDbg and need instructions on
 how to elicit a backtrace, let me know and I'll try to write up some
 docs.

 --
 Dossy Shiobara  | [EMAIL PROTECTED] | http://dossy.org/
 Panoptic Computer Network   | http://panoptic.com/
  He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)


 --
 AOLserver - http://www.aolserver.com/

 To Remove yourself from this list, simply send an email to 
 [EMAIL PROTECTED] with the
 body of SIGNOFF AOLSERVER in the email message. You can leave the
 Subject: field of your email blank.



--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] 
with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: 
field of your email blank.


Re: [AOLSERVER] ns_ora in Aolserver 4.5 for Win32

2008-04-22 Thread Dossy Shiobara
On 2008.04.22, Enrique Catalan [EMAIL PROTECTED] wrote:
 I found that my server is crashing when it is at line 3905 on the
 nsoracle.c.

What version of nsoracle are you using?  The last tagged release, 2.8b1,
may have known bugs.  CVS HEAD of nsoracle has a few changes:

http://aolserver.com/sf/cvs/nsoracle/ChangeLog?view=markup

I guess it's time to just tag nsoracle 2.9, maybe.

Can you try building the CVS HEAD version of nsoracle and see if that
resolves your crash bug?

-- 
Dossy Shiobara  | [EMAIL PROTECTED] | http://dossy.org/
Panoptic Computer Network   | http://panoptic.com/
  He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)


--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] 
with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: 
field of your email blank.


Re: [AOLSERVER] ns_ora in Aolserver 4.5 for Win32

2008-04-22 Thread Enrique Catalan
Hi Dossy,

Thanks for the link and indeed, that piece of code changed a lot with the
new function free_fetch_buffers(connection);.

   if (oci_error_p (lexpos (), dbh, OCIStmtExecute, query, oci_status)) {
Ns_OracleFlush(dbh);
free_fetch_buffers(connection);
return TCL_ERROR;
}

The version I'm using is the same as it is in
http://www.friendlybits.com/en/inf_tec_en/win32openacs_en/ .   This is using
nsoracle 2.7, afaik.  I have asked Maurizio if he could gently include the
nsoracle 2.8 beta instead of the 2.7 and recompile the whole stuff together
with this beta version..  Will let you know what happen at the end.

Thanks again!
Enrique.

On Tue, Apr 22, 2008 at 1:27 PM, Dossy Shiobara [EMAIL PROTECTED] wrote:

 On 2008.04.22, Enrique Catalan [EMAIL PROTECTED] wrote:
  I found that my server is crashing when it is at line 3905 on the
  nsoracle.c.

 What version of nsoracle are you using?  The last tagged release, 2.8b1,
 may have known bugs.  CVS HEAD of nsoracle has a few changes:

http://aolserver.com/sf/cvs/nsoracle/ChangeLog?view=markup

 I guess it's time to just tag nsoracle 2.9, maybe.

 Can you try building the CVS HEAD version of nsoracle and see if that
 resolves your crash bug?

 --
 Dossy Shiobara  | [EMAIL PROTECTED] | http://dossy.org/
 Panoptic Computer Network   | http://panoptic.com/
  He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on. (p. 70)


 --
 AOLserver - http://www.aolserver.com/

 To Remove yourself from this list, simply send an email to 
 [EMAIL PROTECTED] with the
 body of SIGNOFF AOLSERVER in the email message. You can leave the
 Subject: field of your email blank.



--
AOLserver - http://www.aolserver.com/

To Remove yourself from this list, simply send an email to [EMAIL PROTECTED] 
with the
body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: 
field of your email blank.