Uploaded image for project: 'CUBRID APIs'
  1. CUBRID APIs
  2. APIS-632

[Perl] Cannot connect to the shard db in perl driver

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Perl 9.2.0.0001
    • Fix Version/s: Perl 9.2.0.0001
    • Component/s: Perl Driver
    • Labels:
    • Environment:
      • OS: Linux 64bit
      • CUBRID: 9.2.0.0115
      • Perl: v5.18.0
      • Driver: cubrid-perl 9.2.0.0001 (20130807)

      Description

      • Brief: We can not use perl driver to connect with shard db
      • CUBRID Shard Configuration: please see the attachments
      • Test Code {code}
        #!perl -w
        use DBI;
        use Test::More;
        use strict;

        my $dsn="dbi:cubrid:database=shard1;host=10.34.64.58;port=36057";
        my $dbh=DBI->connect($dsn, "dba", "",{ RaiseError => 0, PrintError => 0, AutoCommit => 1 });

        print($dbh->ping);{code}

      Expected Result

      1
      

      Actual Result

      0
      
      1. cubrid_broker.conf
        2 kB
        Ray Yin
      2. shard_connection.txt
        0.5 kB
        Ray Yin
      3. shard_key.txt
        0.2 kB
        Ray Yin

        Activity

        Hide
        cn15800 谢韦华[Bert] added a comment -

        In sharding environment, when driver call function cci_get_db_parameter(CCI_PARAM_MAX_STRING_LENGTH), an error will be thrown by cci:
        -20004:Cannot communicate with server[CAS INFO - 10.34.64.218:36069, 1, 31236].
        So when cci_get_db_parameter(CCI_PARAM_MAX_STRING_LENGTH) return failed, ignore it.

        Show
        cn15800 谢韦华[Bert] added a comment - In sharding environment, when driver call function cci_get_db_parameter(CCI_PARAM_MAX_STRING_LENGTH), an error will be thrown by cci: -20004:Cannot communicate with server [CAS INFO - 10.34.64.218:36069, 1, 31236] . So when cci_get_db_parameter(CCI_PARAM_MAX_STRING_LENGTH) return failed, ignore it.
        Hide
        ryin005 Ray Yin added a comment -
        • Test OS: Linux 64bit
        • CUBRID: 9.2.0.0128
        • Perl: 5.18.0
        • Driver: cubrid-perl 9.2.0.0001 (20130813)

        Test Result: Pass, the perl driver can connect with CUBRID shard db correctly

        Close the issue

        Show
        ryin005 Ray Yin added a comment - Test OS: Linux 64bit CUBRID: 9.2.0.0128 Perl: 5.18.0 Driver: cubrid-perl 9.2.0.0001 (20130813) Test Result: Pass, the perl driver can connect with CUBRID shard db correctly Close the issue

          People

          • Assignee:
            cn15800 谢韦华[Bert]
            Reporter:
            ryin005 Ray Yin
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: