[
https://issues.apache.org/jira/browse/CASSANDRA-14250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nate McCall resolved CASSANDRA-14250.
-------------------------------------
Resolution: Not A Bug
> 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
> Priority: Major
> 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: [email protected]
For additional commands, e-mail: [email protected]
