[
https://issues.apache.org/jira/browse/CASSANDRA-14250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16414615#comment-16414615
]
Nate McCall commented on CASSANDRA-14250:
-----------------------------------------
This seems like more of a system load issue to me. The fact that you were able
to get far enough to generate a {{TimedOutException}} implies that everything
more or less "worked."
You might be better served by looking into throttling options available to
mariadb's bulk load or increasing the amount of hardware (and not using a VM).
I'm going to mark this as closed/won't fix given this is out of scope from the
project's perspective. It might be worth opening a thread on the user mailing
list asking if anyone else has tuned mariadb's bulk load for this.
> 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: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
