[Dbix-class] bind_param_array failed: Arrayref for parameter 1 has 6 elements but parameter 6 has 11

Peter Rabbitson rabbit+dbic at rabbit.us
Wed Mar 9 19:03:29 GMT 2011


Bill Moseley wrote:
> $VERSION = '0.08123';
> 
> I'm using populate like this:
> 
>                 try { $pos_marker_rs->populate( \@pos_marker_rows ); }
>                 catch { die "$_\n" . Dumper \@pos_marker_rows };
> 
> And it works mostly, but sometimes I get an error:
> 
> DBIx::Class::Storage::DBI::txn_do(): 
> DBIx::Class::Storage::DBI::insert_bulk():
> DBI Exception: DBD::Pg::st bind_param_array failed:
> Arrayref for parameter 1 has 6 elements but parameter 6 has 11 [for 
> Statement 
> "INSERT INTO pos_marker ( end_pos, end_line, end_page_index, entry, 
> start_pos, start_line, start_page_index)
> VALUES ( ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 1='98',
> 2='16', 3='0', 4='66275820', 5='96', 6='16', 7='0'] at
> /home/palladium/perl5/lib/perl5/i686-linux-thread-multi/Moose/Meta/Method/Delegation.pm
> 

That's DBD::Pg having problems with prepare_cached. This particular
issue is fixed in 2.15.0 (without a Changelog entry :(

Cheers



More information about the DBIx-Class mailing list