[CASSANDRA-12642] cqlsh NoHostsAvailable/AuthenticationFailure when sourcing a file with COPY commands

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.2.8, 3.0.10, 3.10
• Component/s: Legacy/Tools
• Labels: cqlsh
• Severity: Low
• Assignee: Stefania Alborghetti
• Reporter: Adam Holmberg

Authors

Stefania Alborghetti

Reviewers

Adam Holmberg

• Created: 14/Sep/16 21:29
• Updated: 16/Apr/19 09:30
• Resolved: 22/Sep/16 01:05

Description

In cqlsh, with authentication enabled, when sourcing a file with COPY commands in it:

test.cql:2:Error for (None, None): Failed to connect to all replicas ['127.0.0.1'] for (None, None), errors: ["NoHostAvailable - ('Unable to connect to any servers', {'127.0.0.1': AuthenticationFailed('Remote end requires authentication.',)})"] (permanently given up after 0 rows and 5 attempts)

cqlsh creates a new Shell without passing all pertinent arguments. When copyutil creates new cluster connections, they are not initialized correctly.

This is only for the source command. As a workaround, cqlsh -f <script> works, since it does not create a new Shell instance.

Repro:

ccm create -v 3.7 -n 1 test
ccm updateconf "authenticator: PasswordAuthenticator" "authorizer: CassandraAuthorizer"
ccm start

echo "copy system.local to 'something';" > test.cql

echo "source 'test.cql'" | ccm node1 cqlsh