DBI 1.609-ithread default trace level set to 0x0/15 (pid 4772) at DBI.pm line 273 via dbdissue.pl line 13
install_method DBI::db::get_info    , flags 0x2a00,
    usage: min 2, max 2, '$info_type'
install_method DBI::db::take_imp_data, flags 0x10000,
    usage: min 1, max 1, ''
install_method DBI::db::disconnect  , flags 0x10c00,
    usage: min 1, max 1, ''
install_method DBI::db::selectrow_array, flags 0x2000,
    usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::tables      , flags 0x2200,
    usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ]'
install_method DBI::db::quote_identifier, flags 0x0430,
    usage: min 2, max 6, '$name [, ...] [, \%attr ]'
install_method DBI::db::clone       ,
    usage: min 1, max 2, '[\%attr]'
install_method DBI::db::quote       , flags 0x0430,
    usage: min 2, max 3, '$string [, $data_type ]'
install_method DBI::db::type_info   , flags 0x2200,
    usage: min 1, max 2, '$data_type'
install_method DBI::db::statistics_info, flags 0xaa00,
    usage: min 6, max 7, '$catalog, $schema, $table, $unique_only, $quick, [, \%attr ]'
install_method DBI::db::selectrow_arrayref, flags 0x2000,
    usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::begin_work  , flags 0x0400,
    usage: min 1, max 2, '[ \%attr ]'
install_method DBI::db::last_insert_id, flags 0x2800,
    usage: min 5, max 6, '$catalog, $schema, $table_name, $field_name [, \%attr ]'
install_method DBI::db::foreign_key_info, flags 0xaa00,
    usage: min 7, max 8, '$pk_catalog, $pk_schema, $pk_table, $fk_catalog, $fk_schema, $fk_table [, \%attr ]'
install_method DBI::db::primary_key , flags 0x2200,
    usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
install_method DBI::db::commit      , flags 0x0c80,
    usage: min 1, max 1, ''
install_method DBI::db::ping        , flags 0x0404,
    usage: min 1, max 1, ''
install_method DBI::db::selectall_arrayref, flags 0x2000,
    usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::type_info_all, flags 0x2a00,
    usage: min 1, max 1, ''
install_method DBI::db::do          , flags 0x3200,
    usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::selectcol_arrayref, flags 0x2000,
    usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::prepare_cached, flags 0xa200,
    usage: min 2, max 4, '$statement [, \%attr [, $if_active ] ]'
install_method DBI::db::rows        , flags 0x0004
install_method DBI::db::rollback    , flags 0x0c80,
    usage: min 1, max 1, ''
install_method DBI::db::column_info , flags 0xaa00,
    usage: min 5, max 6, '$catalog, $schema, $table, $column [, \%attr ]'
install_method DBI::db::table_info  , flags 0xaa00,
    usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ]'
install_method DBI::db::primary_key_info, flags 0xaa00,
    usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
install_method DBI::db::prepare     , flags 0xa200,
    usage: min 2, max 3, '$statement [, \%attr]'
install_method DBI::db::preparse    
install_method DBI::db::connected   , flags 0x0004,
    usage: min 1, max 0, ''
install_method DBI::db::data_sources, flags 0x0200,
    usage: min 1, max 2, '[\%attr]'
install_method DBI::db::selectall_hashref, flags 0x2000,
    usage: min 3, max 0, '$statement, $keyfield [, \%attr [, @bind_params ] ]'
install_method DBI::db::selectrow_hashref, flags 0x2000,
    usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::dr::default_user,
    usage: min 3, max 4, '$user, $pass [, \%attr]'
install_method DBI::dr::data_sources, flags 0x0800,
    usage: min 1, max 2, '[\%attr]'
install_method DBI::dr::dbixs_revision, flags 0x0004
install_method DBI::dr::disconnect_all, flags 0x0800,
    usage: min 1, max 1, ''
install_method DBI::dr::connect_cached, flags 0x8000, H 3,
    usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]'
install_method DBI::dr::connect     , flags 0x8000, H 3,
    usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]'
install_method DBI::st::more_results,
    usage: min 1, max 1, ''
install_method DBI::st::blob_read   ,
    usage: min 4, max 5, '$field, $offset, $len [, \$buf [, $bufoffset]]'
install_method DBI::st::fetchall_hashref,
    usage: min 2, max 2, '$key_field'
install_method DBI::st::bind_param_inout_array,
    usage: min 4, max 5, '$parameter, \@var, $maxlen, [, \%attr]'
install_method DBI::st::finish      ,
    usage: min 1, max 1, ''
install_method DBI::st::rows        , flags 0x0004
install_method DBI::st::execute_for_fetch, flags 0x5040,
    usage: min 2, max 3, '$fetch_sub [, $tuple_status]'
install_method DBI::st::fetchrow_hashref
install_method DBI::st::_get_fbav   
install_method DBI::st::_set_fbav   , T 6
install_method DBI::st::fetchrow    
install_method DBI::st::fetch       
install_method DBI::st::execute_array, flags 0x5040,
    usage: min 2, max 0, '\%attribs [, @args]'
install_method DBI::st::dump_results,
    usage: min 1, max 5, '$maxfieldlen, $linesep, $fieldsep, $filehandle'
install_method DBI::st::bind_param_array,
    usage: min 3, max 4, '$parameter, $var [, \%attr]'
install_method DBI::st::fetchrow_array
install_method DBI::st::execute     , flags 0x1040,
    usage: min 1, max 0, '[@args]'
install_method DBI::st::bind_col    ,
    usage: min 3, max 4, '$column, \$var [, \%attr]'
install_method DBI::st::fetchall_arrayref,
    usage: min 1, max 3, '[ $slice [, $max_rows]]'
install_method DBI::st::fetchrow_arrayref
install_method DBI::st::bind_param_inout,
    usage: min 4, max 5, '$parameter, \$var, $maxlen, [, \%attr]'
install_method DBI::st::bind_columns,
    usage: min 2, max 0, '\$var1 [, \$var2, ...]'
install_method DBI::st::cancel      , flags 0x0800,
    usage: min 1, max 1, ''
install_method DBI::st::blob_copy_to_file,
    usage: min 3, max 3, '$field, $filename_or_handleref'
install_method DBI::st::bind_param  ,
    usage: min 3, max 4, '$parameter, $var [, \%attr]'
install_method DBI::common::parse_trace_flag, flags 0x0404, T 8,
    usage: min 2, max 2, '$name'
install_method DBI::common::errstr  , flags 0x0004
install_method DBI::common::trace_msg, flags 0x0004, T 8,
    usage: min 2, max 3, '$message_text [, $min_level ]'
install_method DBI::common::err     , flags 0x0004
install_method DBI::common::CLEAR   , flags 0x0004
install_method DBI::common::state   , flags 0x0004
install_method DBI::common::_not_impl
install_method DBI::common::NEXTKEY , flags 0x0004
install_method DBI::common::trace   , flags 0x0004,
    usage: min 1, max 3, '[$trace_level, [$filename]]'
install_method DBI::common::debug   , flags 0x0004,
    usage: min 1, max 2, '[$debug_level]'
install_method DBI::common::parse_trace_flags, flags 0x0404, T 8,
    usage: min 2, max 2, '$flags'
install_method DBI::common::private_attribute_info
install_method DBI::common::swap_inner_handle,
    usage: min 2, max 3, '$h [, $allow_reparent ]'
install_method DBI::common::EXISTS  , flags 0x0004
install_method DBI::common::visit_child_handles, flags 0x0404, T 4,
    usage: min 2, max 3, '$coderef [, $info ]'
install_method DBI::common::FETCH   , flags 0x0404
install_method DBI::common::FIRSTKEY, flags 0x0004
install_method DBI::common::set_err , flags 0x0010,
    usage: min 3, max 6, '$err, $errmsg [, $state, $method, $rv]'
install_method DBI::common::DESTROY , flags 0x10004
install_method DBI::common::dump_handle, flags 0x0004,
    usage: min 1, max 3, '[$message [, $level]]'
install_method DBI::common::FETCH_many, flags 0x0404
install_method DBI::common::can     , flags 0x0100
install_method DBI::common::STORE   , flags 0x041c
install_method DBI::common::private_data, flags 0x0004,
    usage: min 1, max 1, ''
install_method DBI::common::func    , flags 0x0006
Unicode login6
dbname=Octopus, uid='', pwd=xxxxx
    SQLDriverConnect 'Octopus', '''', 'xxxx'
    SQLDriverConnectW failed:
    SQLConnect ''Octopus'', ''''
Turning autocommit on
DRIVER_ODBC_VER = 03.52
DRIVER_NAME = SQLSRV32.DLL
DRIVER_VERSION = 03.85.1132
MAX_COLUMN_NAME_LEN = 128
DBD::ODBC is unicode built : YES
Deferring Binding
SQL_DBMS_NAME = Microsoft SQL Server
SQLMoreResults supported: 1
SQLDescribeParam supported: 1
SQLDescribeParam supported: 1
    DBI::db=HASH(0x20affa4) trace level set to 0x7fffff00/15 (DBI @ 0x6000000/0) in DBI 1.609-ithread (pid 4772)
    !! info: '' CLEARED by call to prepare method
    -> prepare for DBD::ODBC::db (DBI::db=HASH(0x20a3424)~0x20affa4 '  select top 1 st_id from st_name
  where st_specificity = 'acc'
  and st_parent_id = (
    select top 1 st_id from st_name
    where st_specificity = 'taxon'
    and st_name = ?
  )
') thr#233c0c
    New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x20affa4), id=undef)
    dbih_setup_handle(DBI::st=HASH(0x20a3694)=>DBI::st=HASH(0x23aefc), DBD::ODBC::st, 202476c, Null!)
    dbih_make_com(DBI::db=HASH(0x20affa4), 1e31ed4, DBD::ODBC::st, 224, 0) thr#233c0c
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), Err, DBI::db=HASH(0x20affa4)) SCALAR(0x202468c) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), State, DBI::db=HASH(0x20affa4)) SCALAR(0x202470c) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), Errstr, DBI::db=HASH(0x20affa4)) SCALAR(0x20246cc) (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), TraceLevel, DBI::db=HASH(0x20affa4)) 2147483647 (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), FetchHashKeyName, DBI::db=HASH(0x20affa4)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), HandleSetErr, DBI::db=HASH(0x20affa4)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), HandleError, DBI::db=HASH(0x20affa4)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), ReadOnly, DBI::db=HASH(0x20affa4)) undef (not defined)
    dbih_setup_attrib(DBI::st=HASH(0x23aefc), Profile, DBI::db=HASH(0x20affa4)) undef (not defined)
    initializing sth query timeout to -1
    ignore named placeholders = 0
    creating new parameter key 1
    dbd_preparse scanned 1 distinct placeholders
    SQLPrepare   select top 1 st_id from st_name
  where st_specificity = 'acc'
  and st_parent_id = (
    select top 1 st_id from st_name
    where st_specificity = 'taxon'
    and st_name = ?
  )

    Processing non-utf8 sql in unicode mode
    SQLPrepare = 0
    <- prepare= DBI::st=HASH(0x20a3694) at dbdissue.pl line 123
    -> selectcol_arrayref in DBD::_::db for DBD::ODBC::db (DBI::db=HASH(0x20a3424)~0x20affa4 DBI::st=HASH(0x20a3694) undef 'Legionella pneumophila') thr#233c0c
    >> execute     DISPATCH (DBI::st=HASH(0x20a3694) rc1/3 @2 g0 ima1041 pid#4772) at C:/Perl/site/lib/DBI.pm line 1647 via  at dbdissue.pl line 126
    -> execute for DBD::ODBC::st (DBI::st=HASH(0x20a3694)~0x23aefc 'Legionella pneumophila') thr#233c0c
+dbd_bind_ph(202478c, name=1, value='Legionella pneumophila', attribs=, sql_type=0(unknown), is_inout=0, maxlen=0
    +get_param_type(202478c,1)
      SQLDescribeParam failed reverting to default SQL bind type -9
07009 [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
42000 [Microsoft][ODBC SQL Server Driver]Syntax error or access violation
      get_param_type: modified value type to SQL_C_WCHAR
    -get_param_type
-dbd_bind_ph=1
+dbd_st_execute(202478c)
    dbd_st_finish(202478c)
    outparams = 0
    +rebind_param 1 ''Legionella pneumophila'' (size svCUR=22/SvLEN=24/max=0) svtype 5, value type:-8 sql type:-9
    +get_param_type(202478c,1)
      SQLDescribeParam already run and returned rc=-1
      get_param_type: modified value type to SQL_C_WCHAR
    -get_param_type
      Need to modify phs->sv in place: old length = 22
      Need to modify phs->sv in place: new length = 44
      bind 1 'L' value_len=44 maxlen=46 null=0)
      bind 1 value_type:-8 UNICODE VARCHAR cs=44 dd=0 bl=44
    SQLBindParameter: idx=1: param_type=1, name=1, value_type=-8, SQL_Type=-9, column_size=44, d_digits=0, value_ptr=20b4d24, buffer_length=44, cbValue=44, param_size=0
    -rebind_param
    SQLExecute/SQLExecDirect(2121da0)=0
    SQLRowCount=0 (rows=-1)
    dbd_describe done_desc=0
    dbd_describe SQLNumResultCols=0 (columns=1)
   DescribeCol column = 1, name = s, namelen = 5, type = INTEGER(4), precision/column size = 10, scale = 0, nullable = 0
     display size = 11
     column length = 4
     now using col 1: type = INTEGER (4), len = 5, display size = 12, prec = 10, scale = 0
    Bind 1: type = CHAR(1), buf=20b413c, buflen=12
    have 1 fields
-dbd_st_execute(202478c)=-1
    <- execute= -1 at C:/Perl/site/lib/DBI.pm line 1647 via  at dbdissue.pl line 126
    >> bind_col    DISPATCH (DBI::st=HASH(0x20a3694) rc1/3 @3 g0 ima1 pid#4772) at C:/Perl/site/lib/DBI.pm line 1652 via  at dbdissue.pl line 126
    -> bind_col in DBD::_::st for DBD::ODBC::st (DBI::st=HASH(0x20a3694)~0x23aefc 1 SCALAR(0x20a36e4)) thr#233c0c
    dbih_setup_fbav alloc for 1 fields
    dbih_setup_fbav now 1 fields
    dbih_sth_bind_col 1 => SCALAR(0x20a36e4) Null!
    <- bind_col= 1 at C:/Perl/site/lib/DBI.pm line 1652 via  at dbdissue.pl line 126
    >> fetch       DISPATCH (DBI::st=HASH(0x20a3694) rc1/3 @1 g0 ima0 pid#4772) at C:/Perl/site/lib/DBI.pm line 1659 via  at dbdissue.pl line 126
    -> fetch for DBD::ODBC::st (DBI::st=HASH(0x20a3694)~0x23aefc) thr#233c0c
    SQLFetch rc 0
    fetch num_fields=1
    fetch col#1 s datalen=3 displ=12
    <- fetch= [ '274' ] row1 at C:/Perl/site/lib/DBI.pm line 1659 via  at dbdissue.pl line 126
    >> fetch       DISPATCH (DBI::st=HASH(0x20a3694) rc1/3 @1 g0 ima0 pid#4772) at C:/Perl/site/lib/DBI.pm line 1659 via  at dbdissue.pl line 126
    -> fetch for DBD::ODBC::st (DBI::st=HASH(0x20a3694)~0x23aefc) thr#233c0c
    SQLFetch rc 100
    Getting more results: 100
    No more results -- outparams = 0
    dbd_st_finish(202478c)
    dbd_st_finish closed query:
    <- fetch= undef row1 at C:/Perl/site/lib/DBI.pm line 1659 via  at dbdissue.pl line 126
    <- selectcol_arrayref= [ '274' ] at dbdissue.pl line 126
    -> errstr in DBD::_::common for DBD::ODBC::db (DBI::db=HASH(0x20a3424)~0x20affa4) thr#233c0c
    <- errstr= ( undef ) [1 items] at dbdissue.pl line 128
    -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x23aefc)~INNER) thr#233c0c
   SQLFreeStmt=0.
    <- DESTROY= undef
    -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x20affa4)~INNER) thr#233c0c
SQLDisconnect=0
    DBD::ODBC Disconnected!
    <- DESTROY= undef