[Dbix-class] connection failed error after multiple updates

[Alan Humphrey]

All -

I'm running an program that updates multiple rows in one or more tables.
The target database is MSSQL.  DBIC version is .08010.

The program hums along nicely doing many selects and many updates.  After
about 50 updates it falls over with the following errors (obtained with
DBIC_TRACE on).

Any ideas what's going on?  Suggestions for what I can be looking at?

Thanks!

- Alan

DBI
connect('server=seattleaudubon;database=seattleaudubondb','SASAdmin',...)
failed: (no error string) at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage/DBI.pm line 839
Use of uninitialized value in concatenation (.) or string at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage/DBI.pm line 856.
DBI Connection failed:  at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Schema.pm line 954
 
DBIx::Class::Schema::throw_exception('BirdWeb::BirdWebSchema=HASH(0x83b8e54)
', 'DBI Connection failed: ') called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage.pm line 122
 
DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::Sybase=HAS
H(0x842118c)', 'DBI Connection failed: ') called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage/DBI.pm line 856
 
DBIx::Class::Storage::DBI::_connect('DBIx::Class::Storage::DBI::Sybase=HASH(
0x842118c)', 'DBI:Sybase:server=seattleaudubon;database=seattleaudubondb',
'xxxxx', 'xxxx') called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage/DBI.pm line 769
 
DBIx::Class::Storage::DBI::_populate_dbh('DBIx::Class::Storage::DBI::Sybase=
HASH(0x842118c)') called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage/DBI.pm line 611
 
DBIx::Class::Storage::DBI::dbh_do('DBIx::Class::Storage::DBI::Sybase=HASH(0x
842118c)', 'CODE(0x8a2e54c)', 'update', 'ARRAY(0x8cf72dc)',
'DBIx::Class::ResultSource::Table=HASH(0x885757c)', 'undef',
'HASH(0x825b3bc)', 'HASH(0x8cf7b58)') called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage/DBI.pm line 1013
 
DBIx::Class::Storage::DBI::_execute('DBIx::Class::Storage::DBI::Sybase=HASH(
0x842118c)', 'update', 'ARRAY(0x8cf72dc)',
'DBIx::Class::ResultSource::Table=HASH(0x885757c)', 'undef',
'HASH(0x825b3bc)', 'HASH(0x8cf7b58)') called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Storage/DBI.pm line 1085
 
DBIx::Class::Storage::DBI::update('DBIx::Class::Storage::DBI::Sybase=HASH(0x
842118c)', 'DBIx::Class::ResultSource::Table=HASH(0x885757c)',
'HASH(0x825b3bc)', 'HASH(0x8cf7b58)') called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Row.pm line 298
 
DBIx::Class::Row::update('BirdWeb::BirdWebSchema::Surveys=HASH(0x8cf7c90)')
called at
/usr/pkg/lib/perl5/site_perl/5.8.0/DBIx/Class/Relationship/CascadeActions.pm
line 30
 
DBIx::Class::Relationship::CascadeActions::update('BirdWeb::BirdWebSchema::S
urveys=HASH(0x8cf7c90)') called at remove_new.pl line 35