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-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org