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