RE: DBI Error: END failed--call queue aborted.

[email protected] (John Scoles)
Newsgroups perl.dbi.users
Message-ID <[email protected]>
Ok that cleans it up a little for me.
 
Funny according to the OIC trace you are connecting
 
 see below
 

> To: [email protected]
> From: [email protected]
> Subject: Re: DBI Error: END failed--call queue aborted.
> Date: Wed, 17 Nov 2010 07:50:30 -0800
> 
> On Nov 13, 10:19 am, [email protected] (John Scoles) wrote:
> > You DBD::ORacle is way out of data for you DBI try updating to DBD::Oracle
> > 1.26 ans see what happens
> >
> > cheers
> 
> The error remains the same :( Thanks for all your help. Not sure what
> else I can do here.
> 
> -bash-3.00$ cat test.db.pl
> use strict;
> use DBI;
> my $dbh = DBI->connect( 'dbi:Oracle:<DELETED>',
> '<DELETED>',
> '<DELETED>',
> {dbd_verbose => 15}
> ) || die "Database connection not made:
> $DBI::errstr";
> $dbh->disconnect;
> print "Done. :)\n";
> 
> -bash-3.00$ perl -w test.db.pl
> Environment variables:
> MANPATH=/opt/SUNWspro/man
> TERM=xterm
> SHELL=/usr/bin/bash
> SSH_CLIENT=172.28.2.66 3369 22
> OLDPWD=/export/home/webdev/.cpan
> SSH_TTY=/dev/pts/4
> USER=webdev
> LD_LIBRARY_PATH=/opt/instantclient10_1
> TNS_ADMIN=/opt/instantclient10_1
> MAIL=/var/mail//webdev
> PATH=/usr/bin:/opt/SUNWspro/bin:/opt/instantclient10_1:/usr/
> ccs/bin
> PWD=/export/home/webdev
> JAVA_HOME=/usr/java
> TZ=US/Eastern
> SHLVL=1
> HOME=/export/home/webdev
> LOGNAME=webdev
> SSH_CONNECTION=172.28.2.66 3369 172.28.1.40 22
> ORACLE_HOME=/opt/instantclient10_1
> _=/usr/bin/perl
> OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
> OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
> OCIEnvNlsEnvCreate(1b56bc,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS
> OCIHandleAlloc(2500a0,1b56c0,OCI_HTYPE_ERROR,0,0)=SUCCESS
> OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78090,0,31,267a28)=SUCCESS
> OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78092,0,262,267a28)=SUCCESS
> charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII
> (csid: utf8=871 al32utf8=873)
 
The above set up you server context

> OCIHandleAlloc(2500a0,1b56c4,OCI_HTYPE_SERVER,0,0)=SUCCESS
> OCIHandleAlloc(2500a0,1b56c8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
> OCIServerAttach(267fb4, 267a28, "AHST90", 6, mode=DEFAULT, 0)=SUCCESS
> OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX,267fb4,0,Attr=OCI_ATTR_SERVER,267a28)=SUCCESS
> OCIHandleAlloc(2500a0,1b56cc,OCI_HTYPE_SESSION,0,0)=SUCCESS
 
The above sets up all your handles

> OCIAttrSet(270ca8,OCI_HTYPE_SESSION,1a6380,3,Attr=OCI_ATTR_USERNAME,267a28)=SUCCESS
> OCIAttrSet(270ca8,OCI_HTYPE_SESSION,1a6390,5,Attr=OCI_ATTR_PASSWORD,267a28)=SUCCESS
> OCISessionBegin(2679b4,267a28,270ca8,1,mode=DEFAULT 0)=SUCCESS
> OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX, 270ca8,0,Attr=OCI_ATTR_SESSION,267a28)=SUCCESS
 
The above users your PW and UN and creates a session and it connects
 
 
The rest below is what happens when you disconnects 
> OCISessionEnd(2679b4,267a28,270ca8,mode=DEFAULT 0)=SUCCESS
> OCIServerDetach(267fb4,267a28,mode=DEFAULT,0)=SUCCESS
> Done. :)
> OCIHandleFree(270ca8,OCI_HTYPE_SESSION)=SUCCESS
> OCIHandleFree(2679b4,OCI_HTYPE_SVCCTX)=SUCCESS
> OCIHandleFree(267fb4,OCI_HTYPE_SERVER)=SUCCESS
> OCIHandleFree(267a28,OCI_HTYPE_ERROR)=SUCCESS
 
You are now our of OCI/DBD/Oracle

> Out of memory!
 
So this Out of memory error happens after you have left 
Can you run a query with your connection handle??
 

> Callback called exit.
> END failed--call queue aborted.
> 
> --
> i5mast
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.