# instead of 
my $array_ref = $select->fetchall_arrayref();
# try
my $array_ref = $select->fetchall_arrayref;