[jira] [Created] (CASSANDRA-14250) ERROR 1815 (HY000) at line 28: Internal error: TimedOutException: Default TException.

["Silvio Amorim (JIRA)" <ji...@apache.org>]

Silvio Amorim created CASSANDRA-14250:
-----------------------------------------

             Summary: ERROR 1815 (HY000) at line 28: Internal error: TimedOutException: Default TException.
                 Key: CASSANDRA-14250
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14250
             Project: Cassandra
          Issue Type: Bug
          Components: CQL
         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 

 
            Reporter: Silvio Amorim
             Fix For: 3.11.3


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...);

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org