Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-14250

ERROR 1815 (HY000) at line 28: Internal error: TimedOutException: Default TException.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Not A Bug
    • Fix Version/s: 3.11.3
    • Component/s: Legacy/CQL
    • Labels:
      None
    • Environment:

      VMware Linux server CentOs 6

      [cqlsh 5.0.1 | Cassandra 3.11.1 | CQL spec 3.4.4 | Native protocol v4]

      Server version: 10.0.33-MariaDB MariaDB Server 

       

    • Severity:
      Normal

      Description

      Hello,

      Good day,

       

      Please I need your support for solve this problem and I thank you for all the help you can give.

      I'm facing a very strange problem with cassandradb.

      I installed cassandra version 3.11.1 on a virtual machine with linux CentOS, where I had already converted a mysql database to MariaDb (Server version: 10.0.33-MariaDB MariaDB Server).

       

      In MariaDB I created the following table:

       

      CREATE TABLE `tbl_paciente_crm_anexo` (

        `id` int (11) NOT NULL PRIMARY KEY,

        `id_crm` int (11) DEFAULT NULL,

        `patient_id` int (11) DEFAULT NULL,

        `int_organization` int (11) NOT NULL DEFAULT '0',

        `id_pasta_pai` int (11) DEFAULT '0',

        `file` longblob,

        `file_file` longblob,

        `subtitle` varchar (255) DEFAULT NULL,

        `key words` text,

        `filename` varchar (100) DEFAULT NULL,

        `filename` varchar (20) DEFAULT NULL,

        `char_type` char (1) DEFAULT NULL,

        blob data_foto,

        `date_inclusion` blob,

        `data_alteracao` blob,

        `data_ult_access` blob,

        `log_user` varchar (10) DEFAULT NULL,

        `sign` char (1) DEFAULT NULL,

        `login_id` int (11) DEFAULT NULL,

        `xml` blob,

        `hash_xml` varchar (64) DEFAULT NULL,

        `hash_verif` varchar (64) DEFAULT NULL,

        `status_assinatura` varchar (2) DEFAULT NULL

      ) ENGINE = CASSANDRA thrift_host = `localhost` keyspace =` md_paciente` column_family = `cf_crm_anexo`;

       

       

      I'm trying to load 147Gb of data into this table, and there are 2 blob fields in this table .

       

      • During the loading, and after inserting several records, I receive the following error:

       

      [root@srvmeddbh01 dbbkp]# mysql -p -u root –pxxxxxxxxxx     medicina_intramed<anexo_30276_40275.sql

      ERROR 1815 (HY000) at line 28: Internal error: TimedOutException: Default TException.

      [root@srvmeddbh01 dbbkp]#

       

      Script with insert command and blob field converted to hex:

       

      INSERT INTO `tbl_paciente_crm_anexo` (`id`, `assinar`, `data_alteracao` , `arquivo` , `arquivo_imagem`, `data_foto`, `data_inclusao`, `data_ult_acesso`, `hash_verif`, `

      hash_xml`, `id_assinatura`, `id_crm`, `id_organizacao`, `id_paciente`, `id_pasta_pai`, `legenda`, `log_usuario`, `nome_arquivo`, `palavras_chaves`, `status_assinatura`,

      `tamanhoarquivo`, `tipo_arquivo`, `xml` ) VALUES (30276,' ',' ',x'FFD8FFE000104A46494600010100004800480000FFE1004C4578696600004D4D002A000000080002011200030000000100010

      000876900040000000100000026000000000002A002000400000001000001E0A0030004000000010000028000000000FFED003850686F746F73686F7020332E30003842494D04040000000000003842494D04250

      00000000010D41D8CD98F00B204E9800998ECF8427EFFC0001108028001E00301220002110...);

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              silvioamorim Silvio Amorim
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: