Re: [AOLSERVER] Oracle driver update and SF question
I have tested your code updates Majid and they work splendidly! On Sep 4, 10:54 am, Dossy Shiobara do...@panoptic.com wrote: I have committed Majid's code to GitHub that he has sent to me and have tagged it version 1.1. You can download the tarball for it using this URL: http://github.com/aolserver/nsmemcache/tarball/1.1 On 9/3/10 5:03 PM, Majid Khan wrote: Yes just remove what's there because there are multiple/redundant copies of the same file so its very confusing which file is the correct version of memcache and about the history, ever since I have imported no one added any patch so there is nothing that we will lose. The code I have sent you is the improved bug free version of nsmemcache which I have never commit to CVS (my bad) nor its documented. Sep I would want you to please do your test against the one which Dossy will commit. Dossy I haven't prepared any test case, I shall prepare the one and will let you know. -- Dossy Shiobara | do...@panoptic.com |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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Am I understanding you correctly in that your proposed patch is no longer needed? On 9/5/10 7:25 PM, Sep Ng wrote: I have tested your code updates Majid and they work splendidly! On Sep 4, 10:54 am, Dossy Shiobara do...@panoptic.com wrote: I have committed Majid's code to GitHub that he has sent to me and have tagged it version 1.1. You can download the tarball for it using this URL: http://github.com/aolserver/nsmemcache/tarball/1.1 -- Dossy Shiobara | do...@panoptic.com | 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Hi Dossy, Is it possible to remove the one which you just added on github because it's not the clean version which I wanted to add at the time when I ported for aolserver and also I have fixed a type casting bug in the code later on. So I wanted to import a clean and a stable version of nsmemcache to github. I am not sure whether I would be able to import to github but if you want I can give you a tar ball of nsmecache and you can import that one. Regards, On Fri, Sep 3, 2010 at 1:25 AM, Dossy Shiobara do...@panoptic.com wrote: Got it. Imported: http://github.com/aolserver/nsmemcache On 9/2/10 3:11 PM, Jade Rubick wrote: If you can import the nsmemcached module, we'll commit Sep's fix for larger sized messages. -- Dossy Shiobara | do...@panoptic.com | 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
On Fri, Sep 03, 2010 at 06:01:17PM +0400, Majid Khan wrote: So I wanted to import a clean and a stable version of nsmemcache to github. Um, hopefully Dossy is importing the entire CVS history to github, not a single snapshot of the code. (I know there are CVS-to-git conversion tools, so I assume github offers this.) -- Andrew Piskorski a...@piskorski.com http://www.piskorski.com/ -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Is it necessary to remove what's there (and lose the change history) or just commit your changes? Send me what you have and I can commit it, or you can fork and send a pull request through GitHub. Are your changes documented? How can they be tested? Will they conflict with Sep's BUFSIZE patch? Majid Khan majidkha...@gmail.com wrote: Hi Dossy, Is it possible to remove the one which you just added on github because it's not the clean version which I wanted to add at the time when I ported for aolserver and also I have fixed a type casting bug in the code later on. So I wanted to import a clean and a stable version of nsmemcache to github. I am not sure whether I would be able to import to github but if you want I can give you a tar ball of nsmecache and you can import that one. -- Dossy Shiobara -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Yes just remove what's there because there are multiple/redundant copies of the same file so its very confusing which file is the correct version of memcache and about the history, ever since I have imported no one added any patch so there is nothing that we will lose. The code I have sent you is the improved bug free version of nsmemcache which I have never commit to CVS (my bad) nor its documented. Sep I would want you to please do your test against the one which Dossy will commit. Dossy I haven't prepared any test case, I shall prepare the one and will let you know. Regards, Majid. On Fri, Sep 3, 2010 at 7:11 PM, Dossy Shiobara do...@panoptic.com wrote: Is it necessary to remove what's there (and lose the change history) or just commit your changes? Send me what you have and I can commit it, or you can fork and send a pull request through GitHub. Are your changes documented? How can they be tested? Will they conflict with Sep's BUFSIZE patch? Majid Khan majidkha...@gmail.com wrote: Hi Dossy, Is it possible to remove the one which you just added on github because it's not the clean version which I wanted to add at the time when I ported for aolserver and also I have fixed a type casting bug in the code later on. So I wanted to import a clean and a stable version of nsmemcache to github. I am not sure whether I would be able to import to github but if you want I can give you a tar ball of nsmecache and you can import that one. -- Dossy Shiobara -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Majid, I will be more than happy to do it. I just probably need to figure how and where to git pull. I don't think I have an account however. Regards. On Sep 4, 5:03 am, Majid Khan majidkha...@gmail.com wrote: Yes just remove what's there because there are multiple/redundant copies of the same file so its very confusing which file is the correct version of memcache and about the history, ever since I have imported no one added any patch so there is nothing that we will lose. The code I have sent you is the improved bug free version of nsmemcache which I have never commit to CVS (my bad) nor its documented. Sep I would want you to please do your test against the one which Dossy will commit. Dossy I haven't prepared any test case, I shall prepare the one and will let you know. Regards, Majid. On Fri, Sep 3, 2010 at 7:11 PM, Dossy Shiobara do...@panoptic.com wrote: Is it necessary to remove what's there (and lose the change history) or just commit your changes? Send me what you have and I can commit it, or you can fork and send a pull request through GitHub. Are your changes documented? How can they be tested? Will they conflict with Sep's BUFSIZE patch? Majid Khan majidkha...@gmail.com wrote: Hi Dossy, Is it possible to remove the one which you just added on github because it's not the clean version which I wanted to add at the time when I ported for aolserver and also I have fixed a type casting bug in the code later on. So I wanted to import a clean and a stable version of nsmemcache to github. I am not sure whether I would be able to import to github but if you want I can give you a tar ball of nsmecache and you can import that one. -- Dossy Shiobara -- AOLserver -http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
I think the best way to do this is to fork the project, then replace it with his code, then commit his diff, and then do a pull request to Dossy. That preserves the history, and allows us to see what Majid's changes are. Jade *Jade Rubick* | Director of Development | TRUiST 2201 Wisconsin Ave NW, Suite 250 | Washington, DC 20007 | www.truist.com | +1 202 903 2564 P Please consider the environment before printing The information contained in this email/document is confidential and may be legally privileged. Access to this email/document by anyone other than the intended recipient(s) is unauthorized. If you are not an intended recipient, any disclosure, copying, distribution, or any action taken or omitted to be taken in reliance to it, is prohibited. On Fri, Sep 3, 2010 at 3:24 PM, Sep Ng thejackschm...@gmail.com wrote: Majid, I will be more than happy to do it. I just probably need to figure how and where to git pull. I don't think I have an account however. Regards. On Sep 4, 5:03 am, Majid Khan majidkha...@gmail.com wrote: Yes just remove what's there because there are multiple/redundant copies of the same file so its very confusing which file is the correct version of memcache and about the history, ever since I have imported no one added any patch so there is nothing that we will lose. The code I have sent you is the improved bug free version of nsmemcache which I have never commit to CVS (my bad) nor its documented. Sep I would want you to please do your test against the one which Dossy will commit. Dossy I haven't prepared any test case, I shall prepare the one and will let you know. Regards, Majid. On Fri, Sep 3, 2010 at 7:11 PM, Dossy Shiobara do...@panoptic.com wrote: Is it necessary to remove what's there (and lose the change history) or just commit your changes? Send me what you have and I can commit it, or you can fork and send a pull request through GitHub. Are your changes documented? How can they be tested? Will they conflict with Sep's BUFSIZE patch? Majid Khan majidkha...@gmail.com wrote: Hi Dossy, Is it possible to remove the one which you just added on github because it's not the clean version which I wanted to add at the time when I ported for aolserver and also I have fixed a type casting bug in the code later on. So I wanted to import a clean and a stable version of nsmemcache to github. I am not sure whether I would be able to import to github but if you want I can give you a tar ball of nsmecache and you can import that one. -- Dossy Shiobara -- AOLserver -http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
I have committed Majid's code to GitHub that he has sent to me and have tagged it version 1.1. You can download the tarball for it using this URL: http://github.com/aolserver/nsmemcache/tarball/1.1 On 9/3/10 5:03 PM, Majid Khan wrote: Yes just remove what's there because there are multiple/redundant copies of the same file so its very confusing which file is the correct version of memcache and about the history, ever since I have imported no one added any patch so there is nothing that we will lose. The code I have sent you is the improved bug free version of nsmemcache which I have never commit to CVS (my bad) nor its documented. Sep I would want you to please do your test against the one which Dossy will commit. Dossy I haven't prepared any test case, I shall prepare the one and will let you know. -- Dossy Shiobara | do...@panoptic.com | 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Hi Dossy: If you can import the nsmemcached module, we'll commit Sep's fix for larger sized messages. Jade *Jade Rubick* | Director of Development | TRUiST 2201 Wisconsin Ave NW, Suite 250 | Washington, DC 20007 | www.truist.com | +1 202 903 2564 P Please consider the environment before printing The information contained in this email/document is confidential and may be legally privileged. Access to this email/document by anyone other than the intended recipient(s) is unauthorized. If you are not an intended recipient, any disclosure, copying, distribution, or any action taken or omitted to be taken in reliance to it, is prohibited. On Wed, Sep 1, 2010 at 6:50 PM, Dossy Shiobara do...@panoptic.com wrote: FYI, I've imported the nsoracle module into github: http://github.com/aolserver/nsoracle I'll be slowly importing more and more modules as time goes on. If anyone desires a particular module imported sooner rather than later, speak up and I'll try to get to it first. -- Dossy On 8/25/10 6:03 PM, Dossy Shiobara wrote: Andrew, Thanks for committing the nsoracle fix! Glad to see you're still working with it. I did start moving the core source to GitHub, but didn't get around to moving the modules. I do intend to move them and, by coincidence, will be doing work directly on AOLserver starting in September, so I'll definitely do it then. Thanks for asking, though. -- Dossy Shiobara | do...@panoptic.com | 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Got it. Imported: http://github.com/aolserver/nsmemcache On 9/2/10 3:11 PM, Jade Rubick wrote: If you can import the nsmemcached module, we'll commit Sep's fix for larger sized messages. -- Dossy Shiobara | do...@panoptic.com | 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
FYI, I've imported the nsoracle module into github: http://github.com/aolserver/nsoracle I'll be slowly importing more and more modules as time goes on. If anyone desires a particular module imported sooner rather than later, speak up and I'll try to get to it first. -- Dossy On 8/25/10 6:03 PM, Dossy Shiobara wrote: Andrew, Thanks for committing the nsoracle fix! Glad to see you're still working with it. I did start moving the core source to GitHub, but didn't get around to moving the modules. I do intend to move them and, by coincidence, will be doing work directly on AOLserver starting in September, so I'll definitely do it then. Thanks for asking, though. -- Dossy Shiobara | do...@panoptic.com | 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Hi Andrew, It seems that the changes you did improved the stability of aolserver. I will observe more of this, but the patch is looking good. On Aug 27, 6:13 am, Sep Ng thejackschm...@gmail.com wrote: Thanks for letting me know, Andrew. I will try to get around to testing the latest code base from CVS. I remember that the crashes happen way too often so I'm confident that if the crash was not already fixed, it's going to happen again. On Aug 27, 12:41 am, Andrew Steets ste...@gmail.com wrote: There was an uniititialized int * being passed into OCI in the code that handles 'ns_ora exec_plsql'. 2.7 is nearly 6 years old now. If you can post the backtrace of a crash w/ the most recent nsoracle from CVS I'm happy to take a look at it. Are you able to reliably reproduce the crash? -Andrew On Wed, Aug 25, 2010 at 6:15 PM, Sep Ng thejackschm...@gmail.com wrote: Hi, Can I ask what nature of the crash this fixes? I remember trying nsoracle 2.8 fork and it was extremely unstable and had to rollback to 2.7. Is this on the CVS tree now? Thanks! On Aug 26, 4:56 am, Andrew Steets ste...@gmail.com wrote: Hello, I just checked in a patch for the Oracle driver that fixes a crash bug we were seeing on some of our servers. Anyone running a relatively recent (last two years) version of the Oracle driver may want to switch. I saw some e-mail a while ago about switching to GitHub, but I don't see any of the modules on GitHub. I have some other nsoracle patches (eg. log warning and query text for queries running X seconds) that would probably be better suited to a private fork or branch. Any plans to migrate the modules to GitHub? -Andrew -- AOLserver -http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
There was an uniititialized int * being passed into OCI in the code that handles 'ns_ora exec_plsql'. 2.7 is nearly 6 years old now. If you can post the backtrace of a crash w/ the most recent nsoracle from CVS I'm happy to take a look at it. Are you able to reliably reproduce the crash? -Andrew On Wed, Aug 25, 2010 at 6:15 PM, Sep Ng thejackschm...@gmail.com wrote: Hi, Can I ask what nature of the crash this fixes? I remember trying nsoracle 2.8 fork and it was extremely unstable and had to rollback to 2.7. Is this on the CVS tree now? Thanks! On Aug 26, 4:56 am, Andrew Steets ste...@gmail.com wrote: Hello, I just checked in a patch for the Oracle driver that fixes a crash bug we were seeing on some of our servers. Anyone running a relatively recent (last two years) version of the Oracle driver may want to switch. I saw some e-mail a while ago about switching to GitHub, but I don't see any of the modules on GitHub. I have some other nsoracle patches (eg. log warning and query text for queries running X seconds) that would probably be better suited to a private fork or branch. Any plans to migrate the modules to GitHub? -Andrew -- AOLserver -http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Thanks for letting me know, Andrew. I will try to get around to testing the latest code base from CVS. I remember that the crashes happen way too often so I'm confident that if the crash was not already fixed, it's going to happen again. On Aug 27, 12:41 am, Andrew Steets ste...@gmail.com wrote: There was an uniititialized int * being passed into OCI in the code that handles 'ns_ora exec_plsql'. 2.7 is nearly 6 years old now. If you can post the backtrace of a crash w/ the most recent nsoracle from CVS I'm happy to take a look at it. Are you able to reliably reproduce the crash? -Andrew On Wed, Aug 25, 2010 at 6:15 PM, Sep Ng thejackschm...@gmail.com wrote: Hi, Can I ask what nature of the crash this fixes? I remember trying nsoracle 2.8 fork and it was extremely unstable and had to rollback to 2.7. Is this on the CVS tree now? Thanks! On Aug 26, 4:56 am, Andrew Steets ste...@gmail.com wrote: Hello, I just checked in a patch for the Oracle driver that fixes a crash bug we were seeing on some of our servers. Anyone running a relatively recent (last two years) version of the Oracle driver may want to switch. I saw some e-mail a while ago about switching to GitHub, but I don't see any of the modules on GitHub. I have some other nsoracle patches (eg. log warning and query text for queries running X seconds) that would probably be better suited to a private fork or branch. Any plans to migrate the modules to GitHub? -Andrew -- AOLserver -http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Andrew, Thanks for committing the nsoracle fix! Glad to see you're still working with it. I did start moving the core source to GitHub, but didn't get around to moving the modules. I do intend to move them and, by coincidence, will be doing work directly on AOLserver starting in September, so I'll definitely do it then. Thanks for asking, though. On 8/25/10 4:56 PM, Andrew Steets wrote: I just checked in a patch for the Oracle driver that fixes a crash bug we were seeing on some of our servers. Anyone running a relatively recent (last two years) version of the Oracle driver may want to switch. I saw some e-mail a while ago about switching to GitHub, but I don't see any of the modules on GitHub. I have some other nsoracle patches (eg. log warning and query text for queries running X seconds) that would probably be better suited to a private fork or branch. Any plans to migrate the modules to GitHub? -- Dossy Shiobara | do...@panoptic.com | 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle driver update and SF question
Hi, Can I ask what nature of the crash this fixes? I remember trying nsoracle 2.8 fork and it was extremely unstable and had to rollback to 2.7. Is this on the CVS tree now? Thanks! On Aug 26, 4:56 am, Andrew Steets ste...@gmail.com wrote: Hello, I just checked in a patch for the Oracle driver that fixes a crash bug we were seeing on some of our servers. Anyone running a relatively recent (last two years) version of the Oracle driver may want to switch. I saw some e-mail a while ago about switching to GitHub, but I don't see any of the modules on GitHub. I have some other nsoracle patches (eg. log warning and query text for queries running X seconds) that would probably be better suited to a private fork or branch. Any plans to migrate the modules to GitHub? -Andrew -- AOLserver -http://www.aolserver.com/ To Remove yourself from this list, simply send an email to lists...@listserv.aol.com 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 lists...@listserv.aol.com with the body of SIGNOFF AOLSERVER in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] Oracle Driver
I have a copy of aD 3.3a13, so I can pull that copy out too. Jeff and I will just have to do a heuristic analysis of all the versions. I'm going to unpack them all into one area and start study them. Your info below will help. If anyone else has this kind of historical knowledge, post it here. thanks, /s. On Mon, 30 Sep 2002 00:59:53 -0400, Andrew Piskorski [EMAIL PROTECTED] said: On Mon, Sep 30, 2002 at 02:01:55AM +, Scott Goodwin wrote: I now have Oracle Driver 2.3 and 2.5. Scott, that doesn't sound right. The latest Oracle driver released by aD was 2.6, and I think that's what OpenACS uses. Do you have the version that aD shipped with their AOLserver 3.3+ad13 release? That was their last release of the Oracle driver. However, it's README file was out of date and did still mention release 2.4 in the text. It's ora8.c has: /* $Id: ora8.c,v 1.59 2001/06/11 20:11:14 mayoff Exp $ */ I can send you copy of aolserver-src-v33+ad13.tar.gz if you don't have it, or should be able to grab it from here: http://eveander.com/arsdigita/acs-repository/aolserver-src But I suspect you may already have it, and it's just version number confusion going on... -- Andrew Piskorski [EMAIL PROTECTED] http://www.piskorski.com -- Scott Goodwin [EMAIL PROTECTED] http://scottg.net
Re: [AOLSERVER] Oracle Driver
Cool -- I just copied you on a response to Jeremy about his version -- he did a lot of reformatting of the code mostly, but did add one command. He suggested we leave his version out of the import, but add the new command he created in manually. Also, if we can get all the way back to 1.6, let's go 1.6 - aD 2.6. I still want to unpack and confirm the versions and ordering, unless you've already done that and are confident you've sorted it out. /s. On Mon, 30 Sep 2002 08:22:26 -0400, Jeff Davis [EMAIL PROTECTED] said: I have oracle 2.3, 2.4, 2.5 and 2.6 all as released from aD. I checked and the copy of 2.6 at Eve's site and the OpenACS tarball are the same. I also have the version from Jeremy Collins which he called 2.6 and was based on the aD v2.5 but there are a lot of cosmetic changes and it is hard to figure out what should be folded in to the next version. The diff from aD 2.5 - aD 2.6 is very small and easy to add to Jeremy's version but I am not sure how well his version has been tested. There is also a later version than the 2.6 release which Rob Mayoff had (which hopefully Rob or Andrew will send to me shortly which was ora8.c v 1.60 in the aD CVS). Also, there was a change that I never put into the released version since it was never clear to me what the right answer was (cf http://ccm.redhat.com/bboard-archive/webdb/000d9f.html ) I think what we should do is put up the 2.3 - 2.6 sequence, then try to pull in anything else that might have been fixed elsewhere and make that 2.7beta. --Jeff -- Scott Goodwin [EMAIL PROTECTED] http://scottg.net
Re: [AOLSERVER] Oracle Driver
On Mon, Sep 30, 2002 at 02:01:55AM +, Scott Goodwin wrote: I now have Oracle Driver 2.3 and 2.5. Scott, that doesn't sound right. The latest Oracle driver released by aD was 2.6, and I think that's what OpenACS uses. Do you have the version that aD shipped with their AOLserver 3.3+ad13 release? That was their last release of the Oracle driver. However, it's README file was out of date and did still mention release 2.4 in the text. It's ora8.c has: /* $Id: ora8.c,v 1.59 2001/06/11 20:11:14 mayoff Exp $ */ I can send you copy of aolserver-src-v33+ad13.tar.gz if you don't have it, or should be able to grab it from here: http://eveander.com/arsdigita/acs-repository/aolserver-src But I suspect you may already have it, and it's just version number confusion going on... -- Andrew Piskorski [EMAIL PROTECTED] http://www.piskorski.com
Re: [AOLSERVER] Oracle driver problem (solved)
It turns out the code to put the clob into the datebase was incorrect
The call was
db_dml update_trans {
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
} -clobs [list $xml]
but should be
db_dml update_trans {
update bv_transactions
set transaction = empty_clob()
where transaction_id = :transaction_id
returning transaction into :1
} -clobs [list $xml]
however it's interesting that the incorrect code kills the database instance.
It's also interesting that the first code works until the XML document becomes
larger than 64k
Barry Books wrote:
Hello,
I'm working on an Oracle driver problem and I'm curious if anyone else has
seen it. I'm running the win32 version 2.4 driver with Oracle 8.1.6 on NT
(client and server)
The problem is if I try and update a column with a clob greater that 64k I
get
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable xml
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable transaction_id
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable 1
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4543:unknown:
bind variable 1 is a lob
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:2763:unknown:
entry
[07/May/2001:16:16:29][610.601][-conn0-] Error: SQL():
H:\src\aD\root\oracle-driver\ora8.c:4601:unk
nown: error in `OCIStmtExecute ()': ORA-01480: trailing null missing from
STR bind value
SQL:
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
At first I thought I had not set LobBufferSize but the logs contain:
[07/May/2001:16:02:07][610.218][-main-] Notice: modload: loading
'd:/acs/aol32/bin/ora8.dll'
[07/May/2001:16:02:07][610.218][-main-] Notice: ora8 driver LobBufferSize =
50
[07/May/2001:16:02:07][610.218][-main-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:920:unknown: e
ntry (hdriver 00417640, config_path ns/db/driver/ora8)
[07/May/2001:16:02:07][610.218][-main-] Notice: Loaded ArsDigita Oracle
Driver version 2.4, built on
16:05:38/Nov 14 2000
The config section:
ns_section ns/db/driver/ora8
ns_param Debug true
ns_param LobBufferSize 50
All of this would not be so bad but when this happens the Oracle instance
quits without even putting anything in the event log
The dml statement is:
db_dml update_trans {
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
} -clobs [list $xml]
Has anyone else seen this?
Thanks
Barry
Re: [AOLSERVER] Oracle driver problem
You are one of the few I ever heard that is using AOLServer+Oracle on Win32.
I posted so many messages asking who knows how to make it work. I still
don't know how to make it work. Where did you get your Win32 AOLServer and
Oracle driver with what version? I am running a WinNT4.0 and a couple of
people helped me some what without any success.
Good luck.
Ling Wang
From: Barry Books [EMAIL PROTECTED]
Reply-To: AOLserver Discussion [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [AOLSERVER] Oracle driver problem
Date: Mon, 7 May 2001 16:54:22 -0500
Hello,
I'm working on an Oracle driver problem and I'm curious if anyone else has
seen it. I'm running the win32 version 2.4 driver with Oracle 8.1.6 on NT
(client and server)
The problem is if I try and update a column with a clob greater that 64k I
get
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable xml
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable transaction_id
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
ns_ora clob_dml: binding variable 1
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4543:unknown:
bind variable 1 is a lob
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:2763:unknown:
entry
[07/May/2001:16:16:29][610.601][-conn0-] Error: SQL():
H:\src\aD\root\oracle-driver\ora8.c:4601:unk
nown: error in `OCIStmtExecute ()': ORA-01480: trailing null missing from
STR bind value
SQL:
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
At first I thought I had not set LobBufferSize but the logs contain:
[07/May/2001:16:02:07][610.218][-main-] Notice: modload: loading
'd:/acs/aol32/bin/ora8.dll'
[07/May/2001:16:02:07][610.218][-main-] Notice: ora8 driver LobBufferSize =
50
[07/May/2001:16:02:07][610.218][-main-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:920:unknown: e
ntry (hdriver 00417640, config_path ns/db/driver/ora8)
[07/May/2001:16:02:07][610.218][-main-] Notice: Loaded ArsDigita Oracle
Driver version 2.4, built on
16:05:38/Nov 14 2000
The config section:
ns_section ns/db/driver/ora8
ns_param Debug true
ns_param LobBufferSize 50
All of this would not be so bad but when this happens the Oracle instance
quits without even putting anything in the event log
The dml statement is:
db_dml update_trans {
update bv_transactions
set transaction = :xml
where transaction_id = :transaction_id
returning transaction into :1
} -clobs [list $xml]
Has anyone else seen this?
Thanks
Barry
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
