[MDEV-15598] Internal error: TimedOutException: Default TException Created: 2018-03-19  Updated: 2018-05-16  Resolved: 2018-05-16

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update, Storage Engine - Cassandra
Affects Version/s: 10.1.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Silvio Amorim Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Linux CentOs 6 - Mysql 5.5, MariaDB 10.1.1 e
[Cassandra 3.11.1 | CQL spec 3.4.4 | Native protocol v4, cqlsh 5.0.1.]



 Description   

HI
Good day,

I'm copying a table with 10000 of lines, containing a field that is blob, containing images, .pdf, and other files from Mysql 5.5 to a MariaDB 10.0.34 database, whose table is in Cassandra, and is accessed via "Cassandra storage engine ".
With great difficulty, I was able to insert a good part of the records of this table into Cassandra.
However, I am getting the following error messages when trying to count the records, or even just display the key field.

MariaDB [medicina_intramed]> select id from tbl_paciente_crm_anexo;
ERROR 1815 (HY000): Internal error: TimedOutException: Default TException.

MariaDB [medicina_intramed]> select count(id) from tbl_paciente_crm_anexo;
ERROR 1815 (HY000): Internal error: UnavailableException: Default TException.
MariaDB [medicina_intramed]>

When I search in Cassandra, accessing the same table, I get the following message:

cqlsh:md_paciente> select count(id) from cf_crm_anexo;
OperationTimedOut: errors=

{'127.0.0.1': 'Client request timeout. See Session.execute[_async](timeout)'}

, last_host=127.0.0.1
cqlsh:md_paciente>

Although the table has many blob fields, the critical field is the "file" field.
I have a lot of experience with relational databases, but I'm starting in the NOSQL environment.
And this is the my first project using Cassandra.
May be the a problem with parameters, but I was try many options without soluction.
I will have many apreciation by your support.

Best regards,



 Comments   
Comment by Elena Stepanova [ 2018-04-02 ]

What is "MariaDB 10.1.1 e" that you've mentioned in the Environment field and Affects version/s, and how does it correlate with migrating data from Mysql 5.5 to a MariaDB 10.0.34?
What exactly does it mean, "I'm copying a table"? In can be done in various ways, what does it imply in your case?

Most importantly, please indicate what exactly you consider to be a bug here. If there is no bug and you just need help/support, please ask for it in public forums and specialized resources, the bug tracking system is not the right place for it.

Comment by Sergei Golubchik [ 2018-05-16 ]

No feedback, so closing

Generated at Thu Feb 08 08:22:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.