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

[Bill Moseley]

$VERSION =3D '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=3D'98',
2=3D'16', 3=3D'0', 4=3D'66275820', 5=3D'96', 6=3D'16', 7=3D'0'] at
/home/palladium/perl5/lib/perl5/i686-linux-thread-multi/Moose/Meta/Method/D=
elegation.pm

I'm not sure I understand that error.  Here's the dump of that array.  They
all looks like 7 elements to me, if that's what the error means.  Only
slightly odd thing I see is the "entry" column id is quoted.

$VAR1 =3D [
          [
            'entry',
            'start_page_index',
            'start_line',
            'start_pos',
            'end_page_index',
            'end_line',
            'end_pos'
          ],
          [
            '66275877',
            0,
            1,
            0,
            0,
            1,
            33
          ],
          [
            '66275878',
            0,
            1,
            35,
            0,
            1,
            78
          ],
          [
            '66275879',
            0,
            1,
            80,
            0,
            2,
            23
          ],
          [
            '66275880',
            0,
            2,
            25,
            0,
            2,
            68
          ],
          [
            '66275881',
            0,
            1,
            0,
            0,
            1,
            33
          ],
          [
            '66275882',
            0,
            1,
            0,
            0,
            1,
            33
          ]
        ];


-- =

Bill Moseley
moseley at hank.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20110309/8d4=
774eb/attachment.htm