[
https://issues.apache.org/jira/browse/CASSANDRA-11806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15302334#comment-15302334
]
Paulo Motta commented on CASSANDRA-11806:
-----------------------------------------
hey [~dbranson], do you have any update on this?
It seems the system is not able to load the sstables due to the presence of a
dropped column {{makeyourcase.roles}} in the data that is not present on
{{system_schema.dropped_columns}} table of the fresh install, so the system is
not able to skip rows with the dropped columns in the sstables because it's not
present in the schema and it does not know that it's dropped.
On 2.1 the dropped table information is stored on
{{system.schema_columnfamilies}} table, and when you upgrade that information
is properly migrated to the {{system_schema.dropped_columns}} table. But in
your case, since you're re-creating the schema in a fresh node that info is
lost.
Can you try manually adding {{makeyourcase.roles}} to {{makeyourcase.roles}}
with a low {{dropped_time}} timestamp on {{system_schema.dropped_columns}} and
check if that fixes {{sstableloader}} and {{upgradesstables}}? You will
probably need to find out the [cql
type|https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cql_data_types_c.html]
to add in the {{type}} column of the {{system_schema.dropped_columns}} table.
If this doesn't fix it, you will probably need to provide more logging
information on the streaming ERROR show on the system.log of the destination
node (192.241.191.248).
> sstableloader fails with "Remote peer <ipaddr> failed stream session" on
> small table
> ------------------------------------------------------------------------------------
>
> Key: CASSANDRA-11806
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11806
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Linux ny2-proda-app01 3.13.0-86-generic #130-Ubuntu SMP
> Mon Apr 18 18:27:15 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
> Reporter: Don Branson
> Assignee: Paulo Motta
> Fix For: 3.5
>
> Attachments: roles_table.txt, roles_table_error.txt
>
>
> This error is with sstableloader loading a 2-column table with 20 rows. All
> other tables in the keyspace load clean. The database dump is from cassandra
> 2.1.9, the target is cassandra 3.5. 14 of the 20 rows load successfully.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
