Hi
I finally reproduce the problem with another system here's the setup
Solaris 8 (sparc dual cpu)
perl v5.6.1
DBI-1.21
DBD-ODBC-0.38
ISLIodbc ODBC (Open DataBase Connectivity) Driver Manager (sparc) 2.11,REV=1.0
RedPoint SnmpQL
This is the script use for the test
*******************************************************************************
#!/usr/local/bin/perl -w
use DBI;
use strict;
my $ip=$ARGV[0];
my $str=$ARGV[1];
my @tid=(4,5,12,13,14,16,18,23,28,30,32,34,35,36,38,40,41,42,43,44,45,46,48,49,
50,52,54,55,56,59,61,64,65,67,70,73,74,75,76,79,80,82,88,91,97,98,100,
101,105,109,118,186,208,241,260,286,293,295,309,315,355,437,447,453,
477,558,607,655,681,717,721,740,741,752,773);
my $CR=DBI->connect('dbi:ODBC:cr4.12','','');
$CR->do("use '$ip'.'$str'");
my $sth = $CR->prepare("SELECT modemRegSerNum,modemRegDuration, ".
"modemReceiveLevel,modemTransmitLevel,modemRcvr, ".
"modemLanStatus FROM modemRegEntry WHERE ".
"modemRegIndex = ? ");
foreach my $tid (@tid) {
$sth->execute(($tid));
#select (undef,undef,undef,0.18);
my (@result) = $sth->fetchrow();
if(@result) {
print("$tid @result\n");
}
else {
print("$tid offline\n");
}
}
$sth->finish();
$CR->disconnect();
exit(0);
*******************************************************************************
$ otest xxx.xxx.xxx.xxx xxx
4 26019205 52141288 -9 55 15 1
5 35639027 263683530 -3 35 15 1
otest: 16925 Bus Error(coredump)
$
*******************************************************************************
The only information I can add is when there is a sleep between the execute
and the fetch. there's no more coredump.
Note: DBI and DBD::ODBC are the latest version available
Thanks in advance for your help.
"Jeff Urlwin" <[EMAIL PROTECTED]> on 03/07/2002 12:50:02 AM
Pour : "Sylvain Bazinet" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc :
Objet : RE: problem with dual cpu
Sylvain,
Are you using threads anywhere?
It might help if you posted the script.
In theory, if you are not using threads, fork, etc, you shouldn't have a
problem, but that's in theory, of course. I don't have ISLIodbc nor the
RedPoint SnmpQL to test with. I do test on a multiprocessor linux and NT
machine, though.
Jeff
>
> Hi everybody,
>
> we are running an application which uses all of the
> packages listed
> below:
>
> Solaris 8 (sparc)
> perl v5.6.1
> DBI-1.201
> DBD-Oracle-1.12
> DBD-ODBC-0.32
> ISLIodbc ODBC (Open DataBase Connectivity) Driver Manager (sparc)
> 2.11,REV=1.0
> RedPoint SnmpQL
>
>
> Everything works fine when there is only one CPU in the
> machine. Recently
> we added a second
> CPU and the script which uses DBD-ODBC started to core dump (Bus
> Error and
> Segmentation Fault).
> The problem seems to be intermittent because it doesn't happen on each row
> during the fetch.
>
>
> $ modemreg mo-bg0
> 2002/02/28 05:30:02
> SRVGRP Up Cell Serial Etat TID Rx Tx REG TIME ARBOR NOM
> ------ -- -------- -------- ---- ---- ---- -- -----------
> --------- ----------------------
>
> MV1018 47 MV-JB0 26086492 ON* 291 -9 50 216:49:11
> MV1018 47 MV-JB0 35611686 ON* 1073 3 42 216:44:09
> MV1018 47 MV-JB0 35663087 ON 1117 2 33 216:43:18
> Segmentation Fault(coredump)
>
> $ modemreg mo-bg0
> 2002/02/28 05:36:02
> SRVGRP Up Cell Serial Etat TID Rx Tx REG TIME ARBOR NOM
> ------ -- -------- -------- ---- ---- ---- -- -----------
> --------- ----------------------
>
> MO3002 MO-BG0 26013370 OFF 564 -172:34:15
> Bus Error(coredump)
>
>
> Now the system is running with one cpu and everything is
> back to normal.
> I know version 0.36 of DBD-ODBC fixes a core dump problem but I
> don't know if
> it's gonna fix
> our dual processor issue.
>
> Thanks in advance for your help.
>
>
>
