question

sunil281984 avatar image
sunil281984 asked Erick Ramirez answered

cqlsh copy Error for (None, -9139454686588217222): AttributeError - 'NoneType' object has no attribute 'replace'

cqlsh:rtogateway> copy alarmsettings to '/home/perfbhi/alarmsettings-2022-07-01.csv';
Using 7 child processes

Starting copy of rtogateway.alarmsettings with columns [clientid, alarmsettingsid, alarmname, anyorall, assignedwells, bestpractices, categoryid, classification, color, description, externalurlid, gapthresholdunit, gapthresholdvalue, indextype, notficationschemaname, notificationschemaid, offsetactivity, offsetduration, priorityid, priorityname, rigactivities, rigactivitygroups, status, templateid, unitsystem].
Error for (None, -9139454686588217222): AttributeError - 'NoneType' object has no attribute 'replace' (will try again later attempt 1 of 5)
Error for (2206406995372183073, 2270404463232884347): AttributeError - 'NoneType' object has no attribute 'replace' (will try again later attempt 1 of 5)
Error for (2206406995372183073, 2270404463232884347): AttributeError - 'NoneType' object has no attribute 'replace' (will try again later attempt 2 of 5)
Error for (2206406995372183073, 2270404463232884347): AttributeError - 'NoneType' object has no attribute 'replace' (will try again later attempt 3 of 5)
Error for (2127032115259239741, 2165892782764007501): AttributeError - 'NoneType' object has no attribute 'replace' (will try again later attempt 1 of 5)
Error for (2127032115259239741, 2165892782764007501): AttributeError - 'NoneType' object has no attribute 'replace' (will try again later attempt 2 of 5)
Error for (2127032115259239741, 2165892782764007501): AttributeError - 'NoneType' object has no attribute 'replace' (will try again later attempt 3 of 5)
Processed: 0 rows; Rate: 0 rows/s; Avg. rate: 0 rows/s
0 rows exported to 1 files in 4.733 seconds.
cqlsh
1 comment
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

steve.lacerda avatar image steve.lacerda ♦ commented ·
What version and flavor of Cassandra? It seems like there may be an issue with the table schema metadata.
0 Likes 0 ·

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

As I previously advised you, you need to help us help you by providing actionable information when you ask questions.

You need to:

  1. provide a description of the problem
  2. describe what you've already tried
  3. show some code/examples

In point (3) above, I'm specifically talking about providing an example that replicates the problem which include:

  • sample table schema
  • minimal example CSV
  • full COPY TO command you ran

Without this information, it really is impossible to help you. Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.