Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

DBI/DBD causes SEGV on an execute

3 posts in ,  Internet Open Client Last posting was on 1999-12-14 16:42:46.0Z
Anatole Sagal Posted on 1999-12-14 07:59:53.0Z
Message-ID: <3855F8F9.8E3DD735@sunnysite.net>
Date: Tue, 14 Dec 1999 01:59:53 -0600
From: Anatole Sagal <anatole@sunnysite.net>
X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.9-19mdksmp i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: DBI/DBD causes SEGV on an execute
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.internet,sybase.public.connectivity.open_client
Lines: 21
NNTP-Posting-Host: 208.41.57.130
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:390 sybase.public.connectivity.open_client:2542
Article PK: 119879

Hello !


I am trying to use DBI/DBD::Sybase on a RH Linux 6.0 to connect to
MS SQL server.
Perl gets a segmentaion fault on an INSERT execute.
The insert works (i.e. the server DB gets updated) and then this
happens:
---------------------------------------

main::(addsa.pl:28): $sth->execute;

DB<1> s
>> execute DISPATCH (DBI::st=HASH(0x83559b8) rc1/1 @1 g0
a825c4e0) at addsa.pl line 28.
-> execute for DBD::Sybase::st (DBI::st=HASH(0x83559b8)~0x8356a74)
syb_st_execute() -> ct_command() OK
syb_st_execute() -> ct_send() OK
DBI::st::execute(/usr/lib/perl5/5.00503/Carp.pm:97):
97: return @_ if ref $_[0];
----------------------------------------
at this point @_ = SEGV

Anyone saw this before ?

Thanks again,

Anatole


Michael Peppler Posted on 1999-12-14 15:23:07.0Z
Message-ID: <385660DB.1B34D8AC@peppler.org>
Date: Tue, 14 Dec 1999 07:23:07 -0800
From: Michael Peppler <mpeppler@peppler.org>
Organization: Data Migrations, Inc
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: DBI/DBD causes SEGV on an execute
References: <3855F8F9.8E3DD735@sunnysite.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.internet,sybase.public.connectivity.open_client
Lines: 34
NNTP-Posting-Host: gw.peppler.org 206.55.243.57
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:389 sybase.public.connectivity.open_client:2541
Article PK: 119875


Anatole Sagal wrote:
>
> Hello !
>
> I am trying to use DBI/DBD::Sybase on a RH Linux 6.0 to connect to
> MS SQL server.
> Perl gets a segmentaion fault on an INSERT execute.
> The insert works (i.e. the server DB gets updated) and then this
> happens:
> ---------------------------------------
>
> main::(addsa.pl:28): $sth->execute;
>
> DB<1> s
> >> execute DISPATCH (DBI::st=HASH(0x83559b8) rc1/1 @1 g0
> a825c4e0) at addsa.pl line 28.
> -> execute for DBD::Sybase::st (DBI::st=HASH(0x83559b8)~0x8356a74)
> syb_st_execute() -> ct_command() OK
> syb_st_execute() -> ct_send() OK
> DBI::st::execute(/usr/lib/perl5/5.00503/Carp.pm:97):
> 97: return @_ if ref $_[0];
> ----------------------------------------
> at this point @_ = SEGV
>
> Anyone saw this before ?

Nope.

We need more details. Are you using Sybase's OpenClient, or freetds?
Which version of DBD::Sybase and perl are you using?
What are the environment variables set to?
What does the addsa.pl script look like (or at least the section that
fails)

Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler@peppler.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com


Anatole Sagal Posted on 1999-12-14 16:42:46.0Z
Message-ID: <38567386.4315900E@sunnysite.net>
Date: Tue, 14 Dec 1999 10:42:46 -0600
From: Anatole Sagal <anatole@sunnysite.net>
X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.9-19mdksmp i686)
X-Accept-Language: en
MIME-Version: 1.0
CC: mpeppler@peppler.org
Subject: Re: DBI/DBD causes SEGV on an execute
References: <3855F8F9.8E3DD735@sunnysite.net> <385660DB.1B34D8AC@peppler.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.internet,sybase.public.connectivity.open_client
Lines: 59
NNTP-Posting-Host: 208.41.57.130
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:388 sybase.public.connectivity.open_client:2540
Article PK: 119880

Hi Michael !

Thanks for helping once again !

Here is what I have:

Michael Peppler wrote:

> Nope.
>
> We need more details. Are you using Sybase's OpenClient, or freetds?

Name : sybase-openclient Relocations: /opt/sybase-11.9.2
Version : 11.1.1 Vendor: Sybase, Inc


>
> Which version of DBD::Sybase and perl are you using?

This is perl, version 5.005_03 built for i386-linux
DBD-Sybase-0.21
DBI.pm' => '1.13 from /usr/lib/perl5/site_perl/5.005/i386-linux/DBI.pm'

>

LD_LIBRARY_PATH=:/usr/local/src/opt/sybase-11.9.2/lib
SYBASE=/usr/local/src/opt/sybase-11.9.2

>
> What does the addsa.pl script look like (or at least the section that
> fails)
>

my $sql = "insert into employee (employee_id, screen_name,
employee_password, name_first, name_last) ";
$sql .= "values ('NEXT1', '".$login."', '".$emp_passwd."',
'".$first_name."', '".$last_name."') ";
my $sth = $dbh->prepare($sql);
$sth->execute;

Open client supports DB lib and CT lib calls, does it ?
I tried to use DBD-FreeTDS-0.02 (which I compiled with 4.9 )and that just
hangs (after the insert),
SELECTS work fine though.

Thanks again,
Anatole

>
> Michael
> --
> Michael Peppler -||- Data Migrations Inc.
> mpeppler@peppler.org -||- http://www.mbay.net/~mpeppler
> Int. Sybase User Group -||- http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list@isug.com

Anatole Sagal wrote:
>
> Hello !
>
> I am trying to use DBI/DBD::Sybase on a RH Linux 6.0 to connect to
> MS SQL server.
> Perl gets a segmentaion fault on an INSERT execute.
> The insert works (i.e. the server DB gets updated) and then this
> happens:
> ---------------------------------------
>
> main::(addsa.pl:28): $sth->execute;
>
> DB<1> s
> >> execute DISPATCH (DBI::st=HASH(0x83559b8) rc1/1 @1 g0
> a825c4e0) at addsa.pl line 28.
> -> execute for DBD::Sybase::st (DBI::st=HASH(0x83559b8)~0x8356a74)
> syb_st_execute() -> ct_command() OK
> syb_st_execute() -> ct_send() OK
> DBI::st::execute(/usr/lib/perl5/5.00503/Carp.pm:97):
> 97: return @_ if ref $_[0];
> ----------------------------------------
> at this point @_ = SEGV
>
> Anyone saw this before ?