FreeTDS Development Group

[Dominic Pigot - <pigotdom AT mle.co.uk>]

Hello, I have been using freeTDS on sparc Solaris 2.6 for over 6 months
and it works very well (excellent work).
I am using it to connect to both a sybase and SQL Server database in the
same script, and 90% of the time everything works okay. But every now
and again the following error is displayed with the  sybase query :

Invalid packet header 0
Unknown marker: 0!!

The version of software is from the May current file and perl connect
statements are :

#### Sybase Server version 10....
BEGIN   {
        $ENV{SYBASE} = "/usr/local/gnu/freetds";
        $ENV{LD_LIBRARY_PATH} =
"/usr/local/gnu/freetds/lib:$ENV{LD_LIBRARY_PATH}";
        $ENV{TDSVER} = "42";
        }
$dbh = DBI->connect("DBI:Sybase:server=data2",data2,data2)
        or die "Couldn't connect to database: " . DBI->errstr;

$dbh->do("use dacs_main");

##### SQL Server version 7 ####
BEGIN   {
        $ENV{SYBASE} = "/usr/local/gnu/freetds";
        $ENV{LD_LIBRARY_PATH} =
"/usr/local/gnu/freetds/lib:$ENV{LD_LIBRARY_PATH}";
        $ENV{TDSVER} = "42";
        }
$mdmdbh = DBI->connect("DBI:Sybase:server=data1",data1,data1)
        or die "Couldn't connect to database: " . DBI->errstr;


However when I look in the sybase logs the following info is
produced........


00:2000/06/06 12:58:00.90 kernel  ************************************
00:2000/06/06 12:58:00.90 kernel  SQL causing error :
00:2000/06/06 12:58:00.91 kernel  curdb = 5 pstat = 0x10000 lasterror =
4017
00:2000/06/06 12:58:00.91 kernel  preverror = 0 transtate = 1
00:2000/06/06 12:58:00.91 kernel  curcmd = 193 program = entdom.pl
00:2000/06/06 12:58:00.93 kernel  pc: 0x319bb0
pcstkwalk+0x78(0xd3cc1368, 0xd3cc0d64, 0x270f, 0x2, 0xfffffff8)
00:2000/06/06 12:58:00.93 kernel  pc: 0x319920
ucstkgentrace+0x78(0x26a0012, 0x2, 0x270f, 0x0, 0x0)
00:2000/06/06 12:58:00.93 kernel  pc: 0x2fc834 ucbacktrace+0x94(0x0,
0x1, 0x0, 0xd3f50634, 0x0)
00:2000/06/06 12:58:00.93 kernel  pc: 0x4a274
terminate_process+0x3ec(0x2400, 0x2e400, 0x3800, 0x0, 0xd3f79ae4)
00:2000/06/06 12:58:00.93 kernel  pc: 0x30bc60 kisignal+0x88(0xb,
0xd3cc1c20, 0xd3cc1968, 0x0, 0x0)
00:2000/06/06 12:58:00.93 kernel  pc: 0xef5b88ec _fini+0xef2617bc(0xb,
0xd3cc1c20, 0xd3cc1968, 0x1, 0x0)
00:2000/06/06 12:58:00.93 kernel  pc: 0x2332a4 login+0x163c(0x0, 0x0,
0x0, 0x353132, 0x0)
00:2000/06/06 12:58:00.93 kernel  end of stack trace, spid 10, kpid
40501266, suid 4
00:2000/06/06 13:10:01.60 kernel  current process (0x275001a) infected
with 11
00:2000/06/06 13:10:01.60 kernel  Address 0x2332ac (login+0x1644),
siginfo (code, address) = (1, 0x20201efc)
00:2000/06/06 13:10:01.60 kernel  ************************************
00:2000/06/06 13:10:01.60 kernel  SQL causing error :
00:2000/06/06 13:10:01.60 kernel  curdb = 5 pstat = 0x10000 lasterror =
4017
00:2000/06/06 13:10:01.60 kernel  preverror = 0 transtate = 1
00:2000/06/06 13:10:01.60 kernel  curcmd = 193 program = entdom.pl
00:2000/06/06 13:10:01.60 kernel  pc: 0x319bb0
pcstkwalk+0x78(0xd3d0d368, 0xd3d0cd64, 0x270f, 0x2, 0xfffffff8)
00:2000/06/06 13:10:01.60 kernel  pc: 0x319920
ucstkgentrace+0x78(0x275001a, 0x2, 0x270f, 0x0, 0x0)
00:2000/06/06 13:10:01.60 kernel  pc: 0x2fc834 ucbacktrace+0x94(0x0,
0x1, 0x0, 0xd3f50634, 0x0)
00:2000/06/06 13:10:01.61 kernel  pc: 0x4a274
terminate_process+0x3ec(0x2400, 0x2e400, 0x3800, 0x0, 0xd3f79ae4)
00:2000/06/06 13:10:01.61 kernel  pc: 0x30bc60 kisignal+0x88(0xb,
0xd3d0dc20, 0xd3d0d968, 0x0, 0x0)
00:2000/06/06 13:10:01.61 kernel  pc: 0xef5b88ec _fini+0xef2617bc(0xb,
0xd3d0dc20, 0xd3d0d968, 0x1, 0x0)
00:2000/06/06 13:10:01.61 kernel  pc: 0x2332a4 login+0x163c(0x0, 0x0,
0x0, 0x353132, 0x0)
00:2000/06/06 13:10:01.61 kernel  end of stack trace, spid 10, kpid
41222170, suid 4
00:2000/06/06 14:06:36.68 kernel  current process (0x28b0033) infected
with 11
00:2000/06/06 14:06:36.68 kernel  Address 0x2332ac (login+0x1644),
siginfo (code, address) = (1, 0x20201efc)
00:2000/06/06 14:06:36.68 kernel  ************************************
00:2000/06/06 14:06:36.68 kernel  SQL causing error :
00:2000/06/06 14:06:36.68 kernel  curdb = 5 pstat = 0x10000 lasterror =
4017
00:2000/06/06 14:06:36.68 kernel  preverror = 0 transtate = 1
00:2000/06/06 14:06:36.68 kernel  curcmd = 193 program = entdom.pl
00:2000/06/06 14:06:36.69 kernel  pc: 0x319bb0
pcstkwalk+0x78(0xd3dfab68, 0xd3dfa564, 0x270f, 0x2, 0xfffffff8)
00:2000/06/06 14:06:36.69 kernel  pc: 0x319920
ucstkgentrace+0x78(0x28b0033, 0x2, 0x270f, 0x0, 0x0)
00:2000/06/06 14:06:36.69 kernel  pc: 0x2fc834 ucbacktrace+0x94(0x0,
0x1, 0x0, 0xd3f503fc, 0x0)
00:2000/06/06 14:06:36.69 kernel  pc: 0x4a274
terminate_process+0x3ec(0x2400, 0x2e400, 0x3800, 0x0, 0xd3f75ca0)
00:2000/06/06 14:06:36.69 kernel  pc: 0x30bc60 kisignal+0x88(0xb,
0xd3dfb420, 0xd3dfb168, 0x0, 0x0)
00:2000/06/06 14:06:36.69 kernel  pc: 0xef5b88ec _fini+0xef2617bc(0xb,
0xd3dfb420, 0xd3dfb168, 0x1, 0x0)
00:2000/06/06 14:06:36.69 kernel  pc: 0x2332a4 login+0x163c(0x0, 0x0,
0x0, 0x353132, 0x0)
00:2000/06/06 14:06:36.69 kernel  end of stack trace, spid 9, kpid
42663987, suid 4


Are there anymore diags I can turn on......

Many thanks in advance
Dominic