Hi Team,

using the gazer script we are not able to take the content backup like before , i mean older versions of looker, keep on getting "execution expired" error. :: Connection Failed. it was not the same case before upgrade. Script used : gzr space ls 1 --host='xxxxxx.cloud.looker.com' --port='443' --client-id=xxxxxx --client-secret=xxxxx gzr space ls 1 --host='xxxxxx.cloud.looker.com' --port='443' --client-id=xxxxxx --client-secret=xxxxxx gzr space ls 1 --host='xxxxxx.cloud.looker.com' --port='443' --client-id=xxxxxx --client-secret=xxxxx gzr space ls 2 --host='xxxxxx.cloud.looker.com' --port='443' --client-id=xxxxx --client-secret=xxxxx gzr space ls 2 --host='xxxxxx.cloud.looker.com' --port='443' --client-id=xxxxxx --client-secret=xxxxxx gzr space ls 2 --host='xxxxxx.cloud.looker.com' --port='443' --client-id=xxxxxx --client-secret=xxxxxx

Thanks

(base) SIVANARAYANA.TAMALAMPUDI@sivanarpudismbp ContentBackupOct012021 % gzr space export 1 --host='xxxxxxxxx.cloud.looker.com' --port='443' --client-id='xxxxxx' --client-secret='xxxxxx'

The color_collection(bdo) is not found The color_collection(bdo) is not found The color_collection(bdo) is not found The color_collection(306fbe33-6921-4f0a-858c-5a679bc1bf08) is not found The color_collection(306fbe33-6921-4f0a-858c-5a679bc1bf08) is not found The color_collection(306fbe33-6921-4f0a-858c-5a679bc1bf08) is not found The color_collection(306fbe33-6921-4f0a-858c-5a679bc1bf08) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found The color_collection(592616d0-58e4-4968-9030-928ef38b7b50) is not found Traceback (most recent call last): 51: from /usr/local/bin/gzr:23:in <main>' 50: from /usr/local/bin/gzr:23:inload' 49: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/exe/gzr:36:in <top (required)>' 48: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/base.rb:466:instart' 47: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:in dispatch' 46: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:ininvoke_command' 45: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:in run' 44: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:238:inblock in subcommand' 43: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:115:in invoke' 42: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:indispatch' 41: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' 40: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:inrun' 39: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space.rb:80:in export' 38: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:49:inexecute' 37: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/session.rb:207:in with_session' 36: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:81:inblock in execute' 35: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in process_space' 34: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:ineach' 33: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:in block in process_space' 32: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:inprocess_space' 31: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in each' 30: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:inblock in process_space' 29: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:in process_space' 28: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:ineach' 27: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:110:in block in process_space' 26: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/dashboard.rb:29:inquery_dashboard' 25: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:106:in method_missing' 24: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:139:ininvoke_remote' 23: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:96:in get' 22: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:304:inrequest' 21: from /Library/Ruby/Gems/2.6.0/gems/sawyer-0.8.2/lib/sawyer/agent.rb:94:in call' 20: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:138:inget' 19: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:387:in run_request' 18: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/rack_builder.rb:143:inbuild_response' 17: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/response.rb:8:in call' 16: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:38:incall' 15: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:92:in with_net_http_connection' 14: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:43:inblock in call' 13: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:85:in perform_request' 12: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1228:inget' 11: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1470:in request' 10: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:920:instart' 9: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1472:in block in request' 8: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1479:inrequest' 7: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:in transport_request' 6: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:incatch' 5: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1509:in block in transport_request' 4: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:29:inread_new' 3: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:40:in read_status_line' 2: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:201:inreadline' 1: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:191:in readuntil' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:217:inrbuf_fill': Net::ReadTimeout with #<TCPSocket:(closed)> (Net::ReadTimeout) 51: from /usr/local/bin/gzr:23:in <main>' 50: from /usr/local/bin/gzr:23:inload' 49: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/exe/gzr:36:in <top (required)>' 48: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/base.rb:466:instart' 47: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:in dispatch' 46: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:ininvoke_command' 45: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:in run' 44: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:238:inblock in subcommand' 43: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:115:in invoke' 42: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:indispatch' 41: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' 40: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:inrun' 39: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space.rb:80:in export' 38: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:49:inexecute' 37: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/session.rb:207:in with_session' 36: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:81:inblock in execute' 35: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in process_space' 34: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:ineach' 33: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:in block in process_space' 32: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:inprocess_space' 31: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in each' 30: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:inblock in process_space' 29: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:in process_space' 28: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:ineach' 27: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:110:in block in process_space' 26: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/dashboard.rb:29:inquery_dashboard' 25: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:106:in method_missing' 24: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:139:ininvoke_remote' 23: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:96:in get' 22: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:304:inrequest' 21: from /Library/Ruby/Gems/2.6.0/gems/sawyer-0.8.2/lib/sawyer/agent.rb:94:in call' 20: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:138:inget' 19: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:387:in run_request' 18: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/rack_builder.rb:143:inbuild_response' 17: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/response.rb:8:in call' 16: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:38:incall' 15: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:92:in with_net_http_connection' 14: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:43:inblock in call' 13: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:85:in perform_request' 12: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1228:inget' 11: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1470:in request' 10: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:920:instart' 9: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1472:in block in request' 8: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1479:inrequest' 7: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:in transport_request' 6: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:incatch' 5: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1509:in block in transport_request' 4: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:29:inread_new' 3: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:40:in read_status_line' 2: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:201:inreadline' 1: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:191:in readuntil' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:217:inrbuf_fill': Net::ReadTimeout with #<TCPSocket:(closed)> (Faraday::TimeoutError)

The issue is that we use Gazer to backup our company's spaces (Shared & Personal/Users) to a Git Repository.

We are using a cloud Looker server and every time we use the "gzr space export" command we receive a timeout error. The timeout error is thrown inconsistently; sometimes it occurs seconds after issuing the command, and sometimes it takes an hour before throwing the timeout error.

We've tried many workarounds such as:

Increasing the timeout amount.
Increasing the timeout to a ridiculous amount 70k+.
Splitting the export space job into smaller sections (using the individual child space ids instead of the parent id 1 or 2).
Updating ruby & packages dependencies to use the latest.
Having several people run the command using different combinations of package versions.

Nothing seems to work, we run into the same error every time.

@drstrangelooker @ajcrutch Could you please assist us in a workaround for this issue? It is very critical.

[ ] Maybe assist us with a customized API request call that functions just as the "gzr space export" command. (Could you provide which Looker API calls are being used?)
[ ] Or any workarounds to eliminate the issue.

USAGE: "gzr space export" to convert each space and it's folder structure into json files. Then we push to Git, this is done once a day for spaces 1 & 2, in order to create a backup source. --> This is done through a TeamCity build

EXAMPLE OF ERROR:

` /usr/lib/ruby/2.5.0/net/http.rb:939:in `rescue in block in connect': Failed to open TCP connection to companystaging.cloud.looker.com:443 (getaddrinfo: Name or service not known) (Faraday::ConnectionFailed) from /usr/lib/ruby/2.5.0/net/http.rb:936:in `block in connect' from /usr/lib/ruby/2.5.0/timeout.rb:93:in `block in timeout' from /usr/lib/ruby/2.5.0/timeout.rb:103:in `timeout' from /usr/lib/ruby/2.5.0/net/http.rb:935:in `connect' from /usr/lib/ruby/2.5.0/net/http.rb:920:in `do_start' from /usr/lib/ruby/2.5.0/net/http.rb:909:in `start' from /usr/lib/ruby/2.5.0/net/http.rb:1458:in `request' from /usr/lib/ruby/2.5.0/net/http.rb:1216:in `get' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/adapter/net_http.rb:86:in `perform_request' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/adapter/net_http.rb:44:in `block in call' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/adapter/net_http.rb:93:in `with_net_http_connection' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/adapter/net_http.rb:39:in `call' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/response.rb:8:in `call' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/rack_builder.rb:143:in `build_response' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/connection.rb:387:in `run_request' from /var/lib/gems/2.5.0/gems/faraday-0.17.4/lib/faraday/connection.rb:138:in `get' from /var/lib/gems/2.5.0/gems/sawyer-0.8.2/lib/sawyer/agent.rb:94:in `call' from /var/lib/gems/2.5.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:304:in `request' from /var/lib/gems/2.5.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:96:in `get' from /var/lib/gems/2.5.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:139:in `invoke_remote' from /var/lib/gems/2.5.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:106:in `method_missing' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/modules/dashboard.rb:29:in `query_dashboard' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:110:in `block in process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:in `each' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:in `process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:in `block in process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in `each' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in `process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:in `block in process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in `each' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in `process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:in `block in process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in `each' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in `process_space' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:81:in `block in execute' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/modules/session.rb:207:in `with_session' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:49:in `execute' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/lib/gzr/commands/space.rb:80:in `export' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor/command.rb:27:in `run' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in `invoke_command' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor.rb:387:in `dispatch' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor/invocation.rb:115:in `invoke' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor.rb:238:in `block in subcommand' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor/command.rb:27:in `run' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in `invoke_command' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor.rb:387:in `dispatch' from /var/lib/gems/2.5.0/gems/thor-0.20.3/lib/thor/base.rb:466:in `start' from /var/lib/gems/2.5.0/gems/gazer-0.2.44/exe/gzr:36:in `' from /usr/local/bin/gzr:23:in `load' from /usr/local/bin/gzr:23:in `

' Process exited with code 1`

https://github.com/looker-open-source/gzr/issues/84#issuecomment-942782970

Hi @KGoodacre , just to clarify, are you and @tamalampudi working for the same company and thus addressing the same core problem? It looks like the first error message is a timeout, whereas the one you posted suggests a DNS issue (getaddrinfo: Name or service not known). Were these run on the same version of Looker and Gazer? From the same client machine?

Can you please clarify which exact Looker version you were successfully using previously, and which one you are using now? "21.xx" is a rather broad range for us.

In any case, given the various solutions you tried already it does seem like a networking problem. To start, please double check your API host url as per the documentation here. This value might have changed recently if your Looker instance was migrated to new hosting infrastructure. Our chat support team can help you verify the correct API host URL as well.

Once we have that settled, let's take Gazer out of the equation and attempt some simple API calls from the command line using curl. This doc is a good reference. So the first command would look something like:

curl -i https://<your-api-host-and-port>/alive

Then we can try a login with the same client_id and client_secret used for Gazer:

curl -i  -d "client_id=xxxxxx&client_secret=xxxxxx"  https://<your-api-host-and-port>/login

If those commands fail then we'll know the issue is with networking or the API host url. If they succeed then we'll know it is something in Gazer. Please let me know how it goes!

Hi Victor,

Greetings!!

Kenyian and I work for the same company, and we are discussing on the same issue.

As informed before, there is no issue for the same script when we use 7.20 looker version, when we upgraded to 21.xx then only issue started intermittently then when we keep on upgrading the 21.xx to latest we keep on getting the timeout error what Kenyian mention in it.

As you suggested I tried the curl command its working as expected, I can be able to connect without issues

Example :

curl -d "client_id=xxxxxxxxxx&client_secret=xxxxxxxxxx" https://xpologisticsprod.cloud.looker.com:443/api/3.1/login

[signature_955909060] SIVANARAYANA REDDY TAMALAMPUDI Less-Than-Truckload Lead System Admin, Business Intelligence

XPOLogistics 2211 Old Earhart Road Ann Arbor, MI 48105, USA O: +1 734-757-1426 M: +1 734-210-9286 PTO: None.

From: Victor Poiesz @.> Date: Wednesday, October 13, 2021 at 8:10 PM To: looker-open-source/gzr @.> Cc: Sivanarayana Tamalampudi @.>, Mention @.> Subject: Re: [looker-open-source/gzr] Not able to take the content backup using gazer script when we upgraded looker to 21.xx.xx Version (#97) [Warning: External sender, “Report Phish” for suspicious emails]

Hi @KGoodacrehttps://urldefense.com/v3/__https:/github.com/KGoodacre__;!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFselnGSaA$ , just to clarify, are you and @tamalampudihttps://urldefense.com/v3/__https:/github.com/tamalampudi__;!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFtwIzjAfA$ working for the same company and thus addressing the same core problem? It looks like the first error message is a timeout, whereas the one you posted suggests a DNS issue (getaddrinfo: Name or service not known). Were these run on the same version of Looker and Gazer? From the same client machine?

Can you please clarify which exact Looker version you were successfully using previously, and which one you are using now? "21.xx" is a rather broad range for us.

In any case, given the various solutions you tried already it does seem like a networking problem. To start, please double check your API host url as per the documentation herehttps://urldefense.com/v3/__https:/docs.looker.com/admin-options/platform/api__;!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFtc1EuENw$. This value might have changed recently if your Looker instance was migrated to new hosting infrastructure. Our chat support team can help you verify the correct API host URL as well.

Once we have that settled, let's take Gazer out of the equation and attempt some simple API calls from the command line using curl. This dochttps://urldefense.com/v3/__https:/github.com/looker/looker-sdk-ruby/blob/master/authentication.md__;!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFu_XtUNBw$ is a good reference. So the first command would look something like:

curl -i https:///alivehttps://urldefense.com/v3/__https:/*3Cyour-api-host-and-port*3E/alive__;JSU!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFtNFHKTjQ$

Then we can try a login with the same client_id and client_secret used for Gazer:

curl -i -d "client_id=xxxxxx&client_secret=xxxxxx" https:///loginhttps://urldefense.com/v3/__https:/*3Cyour-api-host-and-port*3E/login__;JSU!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFtZSUuREw$

If those commands fail then we'll know the issue is with networking or the API host url. If they succeed then we'll know it is something in Gazer. Please let me know how it goes!

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/looker-open-source/gzr/issues/97*issuecomment-942812307__;Iw!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFsSVfLaAQ$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AJXKASYAH7Y7PZYP57CSC73UGYNXPANCNFSM5FMHQKKQ__;!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFvFROZpqg$. Triage notifications on the go with GitHub Mobile for iOShttps://urldefense.com/v3/__https:/apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675__;!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFs7DXJHig$ or Androidhttps://urldefense.com/v3/__https:/play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign*3Dnotification-email*26utm_medium*3Demail*26utm_source*3Dgithub__;JSUlJSU!!Lw3mCg!VjMgGR_AuhGR8OqmAmlsG8tfyZmlfeNr_8Kpts0QulRjtM0MejV6iXROwHN8vAgjnFtWJR-n0Q$.

[Do not open attachments or click links unless you can verify the sender. Click “Report Phishing” if the email looks suspicious.]

When i try to take the shared content backup through below command i am getting error: gzr space export 1 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxxxxx' --client-secret='xxxxxxxx'

error:

The color_collection(bdo) is not found The color_collection(bdo) is not found The color_collection(bdo) is not found Traceback (most recent call last): 63: from /usr/local/bin/gzr:23:in <main>' 62: from /usr/local/bin/gzr:23:inload' 61: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/exe/gzr:36:in <top (required)>' 60: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/base.rb:466:instart' 59: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:in dispatch' 58: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:ininvoke_command' 57: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:in run' 56: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:238:inblock in subcommand' 55: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:115:in invoke' 54: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:indispatch' 53: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' 52: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:inrun' 51: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space.rb:80:in export' 50: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:49:inexecute' 49: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/session.rb:207:in with_session' 48: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:81:inblock in execute' 47: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in process_space' 46: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:ineach' 45: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:in block in process_space' 44: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:inprocess_space' 43: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:in each' 42: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:111:inblock in process_space' 41: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:111:in each_index' 40: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:113:inblock (2 levels) in process_space' 39: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:in find_vis_config_reference' 38: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:ineach' 37: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:in block in find_vis_config_reference' 36: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:infind_vis_config_reference' 35: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:in each' 34: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:inblock in find_vis_config_reference' 33: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:171:in find_vis_config_reference' 32: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:114:inblock (3 levels) in process_space' 31: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:in find_color_palette_reference' 30: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:ineach' 29: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:in block in find_color_palette_reference' 28: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:infind_color_palette_reference' 27: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:in each' 26: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:inblock in find_color_palette_reference' 25: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:189:in find_color_palette_reference' 24: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:115:inblock (4 levels) in process_space' 23: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:215:in rewrite_color_palette!' 22: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:156:incolor_collection' 21: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:106:in method_missing' 20: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:139:ininvoke_remote' 19: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:96:in get' 18: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:304:inrequest' 17: from /Library/Ruby/Gems/2.6.0/gems/sawyer-0.8.2/lib/sawyer/agent.rb:94:in call' 16: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:138:inget' 15: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:387:in run_request' 14: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/rack_builder.rb:143:inbuild_response' 13: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/response.rb:8:in call' 12: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:38:incall' 11: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:92:in with_net_http_connection' 10: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:43:inblock in call' 9: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:85:in perform_request' 8: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1228:inget' 7: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1470:in request' 6: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:919:instart' 5: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:930:in do_start' 4: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:945:inconnect' 3: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/timeout.rb:103:in timeout' 2: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:947:inblock in connect' 1: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:947:in open' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:947:ininitialize': execution expired (Net::OpenTimeout) 63: from /usr/local/bin/gzr:23:in <main>' 62: from /usr/local/bin/gzr:23:inload' 61: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/exe/gzr:36:in <top (required)>' 60: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/base.rb:466:instart' 59: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:in dispatch' 58: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:ininvoke_command' 57: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:in run' 56: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:238:inblock in subcommand' 55: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:115:in invoke' 54: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:indispatch' 53: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' 52: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:inrun' 51: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space.rb:80:in export' 50: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:49:inexecute' 49: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/session.rb:207:in with_session' 48: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:81:inblock in execute' 47: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:in process_space' 46: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:137:ineach' 45: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:138:in block in process_space' 44: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:inprocess_space' 43: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:109:in each' 42: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:111:inblock in process_space' 41: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:111:in each_index' 40: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:113:inblock (2 levels) in process_space' 39: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:in find_vis_config_reference' 38: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:ineach' 37: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:in block in find_vis_config_reference' 36: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:infind_vis_config_reference' 35: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:in each' 34: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:173:inblock in find_vis_config_reference' 33: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:171:in find_vis_config_reference' 32: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:114:inblock (3 levels) in process_space' 31: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:in find_color_palette_reference' 30: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:ineach' 29: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:in block in find_color_palette_reference' 28: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:infind_color_palette_reference' 27: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:in each' 26: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:191:inblock in find_color_palette_reference' 25: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:189:in find_color_palette_reference' 24: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:115:inblock (4 levels) in process_space' 23: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:215:in rewrite_color_palette!' 22: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/command.rb:156:incolor_collection' 21: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:106:in method_missing' 20: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:139:ininvoke_remote' 19: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:96:in get' 18: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:304:inrequest' 17: from /Library/Ruby/Gems/2.6.0/gems/sawyer-0.8.2/lib/sawyer/agent.rb:94:in call' 16: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:138:inget' 15: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:387:in run_request' 14: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/rack_builder.rb:143:inbuild_response' 13: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/response.rb:8:in call' 12: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:38:incall' 11: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:92:in with_net_http_connection' 10: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:43:inblock in call' 9: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:85:in perform_request' 8: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1228:inget' 7: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1470:in request' 6: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:919:instart' 5: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:930:in do_start' 4: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:945:inconnect' 3: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/timeout.rb:103:in timeout' 2: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:947:inblock in connect' 1: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:947:in open' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:947:ininitialize': execution expired (Faraday::ConnectionFailed)

Hi @tamalampudi , allow me to introduce @tkofford-bytecode who will be assisting with maintenance of this project going forward. He works with Looker's consulting partner Bytecode.

Todd will attempt to reproduce the issue and may have further questions / suggestions for you. Thanks!

Hi @tamalampudi,

The error that is always referenced in your stack trace multiple times is: The color_collection(bdo) is not found

I know that @vpoiesz asked you to try "curl" commands to call the API directly to determine if the problem you are seeing is a network issue or not and that the "login" API call you executed was successful. That's a good thing, but could you try making a few more API calls as follows?

Do the login (again) to get an access_token (the token can be used over and over for API calls until it expires) curl -i -d "client_id=xxxxxx&client_secret=xxxxxx" https://<your-api-host-and-port>/login
Make a call to the "ColorCollection" API to return all color collections existing in the instance curl -i -H "Authorization: token xxxxxxxxxx" https://<your-api-host-and-port>/api/3.1/color_collections
Determine if there's a color collection with id = "bdo" as in the stack trace & if so use another "ColorCollection" API call to retrieve it by its id (i.e., "bdo"). If it doesn't exist, then we can further troubleshoot from there. curl -i -H "Authorization: token xxxxxxxxxx" https://<your-api-host-and-port>/api/3.1/color_collections/bdo
Please post results back to this thread.

Hopefully, this sequence of API calls will give us more clues into the specific issue you are experiencing.

--Todd

Hi Todd,

Please find the required details: (base) SIVANARAYANA.TAMALAMPUDI@SivanarpudisMBP ~ % curl -i -d "client_id=xxxxxxxx&client_secret=xxxxxxxx" https://xpologisticsprod.cloud.looker.com:443/api/3.1/login HTTP/1.1 200 OK Date: Thu, 11 Nov 2021 21:29:43 GMT Content-Type: application/json Content-Length: 99 Connection: keep-alive Vary: Accept-Encoding, Origin X-B3-TraceId: 618d8b475360dbfcda58a25e0ff8c1f1 X-B3-SpanId: da58a25e0ff8c1f1 X-B3-ParentSpanId: da58a25e0ff8c1f1 X-B3-Sampled: 0 X-Content-Type-Options: nosniff Strict-Transport-Security: max-age=15724800; includeSubDomains

{"access_token":"xxxxxxxxxxxxxxxxxx","token_type":"Bearer","expires_in":3599}%

========================================================================================

(base) SIVANARAYANA.TAMALAMPUDI@SivanarpudisMBP ~ % curl -i -H "Authorization: token xxxxxxxxxxxxxxxxxxxx" https://xpologisticsprod.cloud.looker.com:443/api/3.1/color_collections

HTTP/1.1 200 OK Date: Thu, 11 Nov 2021 21:30:05 GMT Content-Type: application/json Content-Length: 35457 Connection: keep-alive Vary: Accept-Encoding Vary: Accept-Encoding, Origin X-B3-TraceId: 618d8b5db8e3f7c1c0c1e7c370827437 X-B3-SpanId: c0c1e7c370827437 X-B3-ParentSpanId: c0c1e7c370827437 X-B3-Sampled: 0 X-Content-Type-Options: nosniff Strict-Transport-Security: max-age=15724800; includeSubDomains

========================================================================================

(base) SIVANARAYANA.TAMALAMPUDI@SivanarpudisMBP ~ % curl -i -H "Authorization: token xxxxxxxxxxxxxxxx" https://xpologisticsprod.cloud.looker.com:443/api/3.1/color_collections/bdo HTTP/1.1 404 Not Found Date: Thu, 11 Nov 2021 21:30:18 GMT Content-Type: / Connection: close

<!DOCTYPE html>

Looker Not Found (404)

Looker is unavailable.

If you typed in a URL, double-check the spelling.

This may also be due to a temporary condition such as an outage, scheduled maintenance or upgrade.

If this message persists or you have any concerns,
contact us from help.looker.com and we'll respond promptly.

@tamalampudi I didn't really see anything out of the ordinary with the output you provided from the API calls, other than some of the color collections had null labels, which I don't "think" is an issue.

Can you try to run the gazer command again, but specify the "--debug" flag?

I have executed the below commands :

1)gzr space export 1 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxx' --client-secret='xxxxxx' --debug --> No issues been identified, i can able to take the shared [export 1] backup completely without any issues, strange thing the same command used to give timeout error before many times.

2)gzr space export 2 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxx' --client-secret='xxxxxx' --debug --> when i execute this command for personal spaces backup i am getting the below error after few seconds:

===================================================================== (base) SIVANARAYANA.TAMALAMPUDI@SivanarpudisMBP prodbackup-11122021 % gzr space export 2 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxx' --client-secret='xxxxxxx' --debug options: {"debug"=>true, "host"=>"xpologisticsprod.cloud.looker.com", "port"=>"443", "ssl"=>true, "verify_ssl"=>true, "timeout"=>60, "force"=>false, "client_id"=>"xxxxxx", "client_secret"=>"4kYwsxHshm9dnvKg5tRYXqyf", "dir"=>"."} API 3.1 available? true connecting to ["api_endpoint=>https://xpologisticsprod.cloud.looker.com:443/api/3.1", "connection_options=>{:ssl=>{:verify=>true, :verify_mode=>3}, :request=>{:timeout=>60}}", "user_agent=>Gazer 0.2.44", "client_id=>xxxxxxx", "client_secret=>*****"] check for connectivity: true verify authentication: true performing color_palette_lookup! on { "id": "xpo-corp-success", "label": "XPO Corp Success", "categoricalPalettes": [ { "id": "xpo-corp-success-categorical-0", "label": null, "type": "Categorical", "colors": [ "#4CAF50" ] } ], "sequentialPalettes": [ { "id": "xpo-corp-success-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] } ], "divergingPalettes": [ { "id": "xpo-corp-success-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] } got palettes [ { "id": "xpo-corp-success-categorical-0", "label": null, "type": "Categorical", "colors": [ "#4CAF50" ] }, { "id": "xpo-corp-success-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] }, { "id": "xpo-corp-success-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] Default colors { "id": "xpo-corp-success", "label": "XPO Corp Success", "categoricalPalettes": [ { "id": "xpo-corp-success-categorical-0", "label": null, "type": "Categorical", "colors": [ "#4CAF50" ] } ], "sequentialPalettes": [ { "id": "xpo-corp-success-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] } ], "divergingPalettes": [ { "id": "xpo-corp-success-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ], "palettes": [ { "id": "xpo-corp-success-categorical-0", "label": null, "type": "Categorical", "colors": [ "#4CAF50" ] }, { "id": "xpo-corp-success-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] }, { "id": "xpo-corp-success-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] } looking up color collection by id xpo-corporate-qualitative-1 performing color_palette_lookup! on { "id": "xpo-corporate-qualitative-1", "label": "XPO Corp Qualitative 1", "categoricalPalettes": [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] } ], "sequentialPalettes": [ { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] } ], "divergingPalettes": [ { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] } got palettes [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] }, { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] }, { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] got color collection { "id": "xpo-corporate-qualitative-1", "label": "XPO Corp Qualitative 1", "categoricalPalettes": [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] } ], "sequentialPalettes": [ { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] } ], "divergingPalettes": [ { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ], "palettes": [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] }, { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] }, { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] }

--Removed content for readability--

looking up color collection by id xpo-corporate-qualitative-1 performing color_palette_lookup! on { "id": "xpo-corporate-qualitative-1", "label": "XPO Corp Qualitative 1", "categoricalPalettes": [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] } ], "sequentialPalettes": [ { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] } ], "divergingPalettes": [ { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] } got palettes [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] }, { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] }, { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] got color collection { "id": "xpo-corporate-qualitative-1", "label": "XPO Corp Qualitative 1", "categoricalPalettes": [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] } ], "sequentialPalettes": [ { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] } ], "divergingPalettes": [ { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ], "palettes": [ { "id": "xpo-corporate-qualitative-1-categorical-0", "label": null, "type": "Categorical", "colors": [ "#CC0000", "#000000", "#43494D", "#858585", "#DDDDDD" ] }, { "id": "xpo-corporate-qualitative-1-sequential-0", "label": null, "type": "Sequential", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#43494D", "offset": 100 } ] }, { "id": "xpo-corporate-qualitative-1-diverging-0", "label": null, "type": "Diverging", "stops": [ { "color": "#ffffff", "offset": 0 }, { "color": "#3EB0D5", "offset": 100 } ] } ] } logout Traceback (most recent call last): 43: from /usr/local/bin/gzr:23:in <main>' 42: from /usr/local/bin/gzr:23:inload' 41: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/exe/gzr:36:in <top (required)>' 40: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/base.rb:466:instart' 39: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:in dispatch' 38: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:ininvoke_command' 37: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:in run' 36: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:238:inblock in subcommand' 35: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:115:in invoke' 34: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:indispatch' 33: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' 32: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:inrun' 31: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space.rb:80:in export' 30: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:49:inexecute' 29: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/session.rb:207:in with_session' 28: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:81:inblock in execute' 27: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:136:in process_space' 26: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/space.rb:135:inquery_space_children' 25: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:106:in method_missing' 24: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:139:ininvoke_remote' 23: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:96:in get' 22: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:304:inrequest' 21: from /Library/Ruby/Gems/2.6.0/gems/sawyer-0.8.2/lib/sawyer/agent.rb:94:in call' 20: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:138:inget' 19: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:387:in run_request' 18: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/rack_builder.rb:143:inbuild_response' 17: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/response.rb:8:in call' 16: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:38:incall' 15: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:92:in with_net_http_connection' 14: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:43:inblock in call' 13: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:85:in perform_request' 12: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1228:inget' 11: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1470:in request' 10: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:920:instart' 9: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1472:in block in request' 8: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1479:inrequest' 7: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:in transport_request' 6: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:incatch' 5: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1509:in block in transport_request' 4: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:29:inread_new' 3: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:40:in read_status_line' 2: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:201:inreadline' 1: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:191:in readuntil' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:217:inrbuf_fill': Net::ReadTimeout with #<TCPSocket:(closed)> (Net::ReadTimeout) 43: from /usr/local/bin/gzr:23:in <main>' 42: from /usr/local/bin/gzr:23:inload' 41: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/exe/gzr:36:in <top (required)>' 40: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/base.rb:466:instart' 39: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:in dispatch' 38: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:ininvoke_command' 37: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:in run' 36: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:238:inblock in subcommand' 35: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:115:in invoke' 34: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:indispatch' 33: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' 32: from /Library/Ruby/Gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:inrun' 31: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space.rb:80:in export' 30: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:49:inexecute' 29: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/session.rb:207:in with_session' 28: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:81:inblock in execute' 27: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/commands/space/export.rb:136:in process_space' 26: from /Library/Ruby/Gems/2.6.0/gems/gazer-0.2.44/lib/gzr/modules/space.rb:135:inquery_space_children' 25: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:106:in method_missing' 24: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client/dynamic.rb:139:ininvoke_remote' 23: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:96:in get' 22: from /Library/Ruby/Gems/2.6.0/gems/looker-sdk-0.0.7/lib/looker-sdk/client.rb:304:inrequest' 21: from /Library/Ruby/Gems/2.6.0/gems/sawyer-0.8.2/lib/sawyer/agent.rb:94:in call' 20: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:138:inget' 19: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/connection.rb:387:in run_request' 18: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/rack_builder.rb:143:inbuild_response' 17: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/response.rb:8:in call' 16: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:38:incall' 15: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:92:in with_net_http_connection' 14: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:43:inblock in call' 13: from /Library/Ruby/Gems/2.6.0/gems/faraday-0.17.3/lib/faraday/adapter/net_http.rb:85:in perform_request' 12: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1228:inget' 11: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1470:in request' 10: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:920:instart' 9: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1472:in block in request' 8: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1479:inrequest' 7: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:in transport_request' 6: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1506:incatch' 5: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http.rb:1509:in block in transport_request' 4: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:29:inread_new' 3: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/http/response.rb:40:in read_status_line' 2: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:201:inreadline' 1: from /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:191:in readuntil' /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/lib/ruby/2.6.0/net/protocol.rb:217:inrbuf_fill': Net::ReadTimeout with #<TCPSocket:(closed)> (Faraday::TimeoutError) (base) SIVANARAYANA.TAMALAMPUDI@SivanarpudisMBP prodbackup-11122021 %

@tamalampudi it looks like the call is failing now on querying the space (id = 2) children. Gazer calls process_space() recursively for all the children of the given parent space. Can you please try to call the following API call directly?

Make a call to get an authorization token curl -i -d "client_id=xxxxxx&client_secret=xxxxxx" https://<your-api-host-and-port>/login
Make a call to get all the child spaces for parent space id = 2 curl -i -H "Authorization: token xxxxxxxxxx" https://<your-api-host-and-port>/api/3.1/spaces/2/children

Please find the attached file for log: logfile.txt

@tamalampudi, thanks for providing the file output, much easier to read!

It appears that there are more than 4300 child spaces under space (id = 2). I'm guessing the timeout issue is related to volume, so I'd like to try some things that @KGoodacre stated were already tried in a prior post, but would like to try again if possible:

Increase the gzr timeout to something big like 10 minutes (600 seconds). This is the quickest/easiest one to try gzr space export 2 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxx' --client-secret='xxxxxx' --timeout=600--debug
Split up the export parent space (id =2) & instead run a gzr export space command for the parent and children spaces individually. This is something you'll need to change in your backup process

Todd,

1) As you suggested we increased the timeout and tested still we see the issue most of the times. 2)we already implemented the spilt up process also still same issue . do you thing gazer is not able to handle the huge data, i mean if data increased. we already gone through all the roots like network admin, infrastructure admin, team city admin from where we are executing scripts etc... but all confirmed there is no change and all good, offcouse it was good before never saw any error. seems while data is getting increased then only issue started, seems gazer not able to handle the huge data. Please let us know your inputs further...

@tamalampudi, one other thing that you can try is the "persistent" flag. I have mixed feelings if it will help, but it's worth a try if you have time. Otherwise, we'll likely need to find a way to reproduce your issue in one of our environments: gzr space export 2 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxx' --client-secret='xxxxxx' --timeout=300 --persistent --debug

@tkofford-bytecode Do you have any suggestions for alternative solutions to "backing up" Looker spaces?

i am getting the below error: (base) SIVANARAYANA.TAMALAMPUDI@sivanarpudismbp prodbackup-11122021 % gzr space export 2 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxxxxx' --client-secret='xxxxxxxx' --timeout=300 --persistent --debug ERROR: "gzr space export" was called with arguments ["2", "--persistent"] Usage: "gzr space export SPACE_ID" (base) SIVANARAYANA.TAMALAMPUDI@sivanarpudismbp prodbackup-11122021 %

@tamalampudi the "persistent" flag is available in the latest version of gazer. Please make sure you are running the latest version of gazer which is v0.2.47: gzr --version If you are not using that version, please update and run the version command again: gem update gazer Once you have the latest version installed, please try to run the command you specified above again (i.e., the one that includes the "persistent" flag). In local testing, I've seen the persistent flag really help network performance a lot, so I think it's still worth trying.

This issue has been marked as "Stale" since there has been no activity for over 2 weeks. It will be closed due to a lack of activity in 7 days.

Closed due to inactivity.

@ghost Which curl call would I make to export an entire space and it’s child contents as well? The Spaces call is being deprecated by Looker.

@tamalampudi, thanks for providing the file output, much easier to read!

It appears that there are more than 4300 child spaces under space (id = 2). I'm guessing the timeout issue is related to volume, so I'd like to try some things that @KGoodacre stated were already tried in a prior post, but would like to try again if possible:

Increase the gzr timeout to something big like 10 minutes (600 seconds). This is the quickest/easiest one to try gzr space export 2 --host='xpologisticsprod.cloud.looker.com' --port='443' --client-id='xxxxxx' --client-secret='xxxxxx' --timeout=600--debug

Split up the export parent space (id =2) & instead run a gzr export space command for the parent and children spaces individually. This is something you'll need to change in your backup process

@ghost We’ve tried this as well and we still run into the timeout issue. I was thinking that we could just use a curl to export and take gazer out of the equation. Would this be possible? If so which Looker API calls would we need to combine in order to replicate the Gazer’s “export” call? I think the root issue is the data size since Gazer is being used to backup an Enterprise’s data. No matter how much we increase the timeout flag; it still fails with a faraday TCP connection error. We split the personal and shared space and tried backing up the child spaces but we still run into the same faraday error. I also tried using the persistent flag and to no avail, the error is still thrown.

Hi @KGoodacre,

The Looker API has renamed "space" to "folder", but in Gazer we are keeping the "space" command for now (and will eventually add "folder" as an alias). If you are having trouble with it please update to the latest version; we did make a fix recently to force calls to the API 3.1 endpoints.

Regarding the timeout errors, I think we have some other work in progress that will help your use case. Here's some background:

There's no good single curl command to fetch a dashboard as json. That's basically why Gazer exists, since it needs to encapsulate all the logic to deal with Looker's existing endpoints, which were meant to drive our web UI code rather than provide a nice user-friendly export format.
There is already an endpoint to Get LookML of a UDD which outputs a YAML string defining the dashboard. This is a more "fully hydrated" serialization format that includes the query definitions, layout, filters, etc. In fact it's the same format that we use for defining dashboards in the LookML project. So it would be a good way to "back up" dashboards. Except..
The workflow for re-importing a LookML Dashboard is currently very onerous. You have to put it into the git project, then call the operation to export it as a UDD again.
So, we are building a new set of endpoints that will make it easier to create/overwrite a UDD from the LookML export. You can take the output of "Get LookML of a UDD" then pass it right back in to Looker to create a UDD. (You'll be able to provide the folder_id too)
The output of "Get LookML of a UDD" will start including the preferred_slug parameter, and we'll use that for the create/overwrite operations. So if you are migrating content from a staging instance to a production instance, Looker can automatically match up the objects using the slug as a UUID.

Our hope is that this new workflow can remove the need for Gazer in most use cases. We have another project called looker_deployer where we will start using these endpoints for high-level content import/export commands. That project is built with Python so customers tend to have an easier time managing/customizing it.

I can't guarantee this will necessarily handle your scale right at the outset. You'll also have to manage the transition from json formatted backups to yaml. However I think this will put us in a much better position to iterate going forward, since it eliminates the complexity of the Gazer logic and Ruby dependencies. If you can hold out a little while longer, we should have the new endpoints in preview mode in the next release or two.

Please let me know how that sounds to you!

looker-open-source / gzr

Not able to take the content backup using gazer script when we upgraded looker to 21.xx.xx Version #97

error:

Looker is unavailable.

If you typed in a URL, double-check the spelling.

This may also be due to a temporary condition such as an outage, scheduled maintenance or upgrade.

If this message persists or you have any concerns,
contact us from help.looker.com and we'll respond promptly.

looker-open-source / gzr

Not able to take the content backup using gazer script when we upgraded looker to 21.xx.xx Version #97

error:

Looker is unavailable.

If you typed in a URL, double-check the spelling.

This may also be due to a temporary condition such as an outage, scheduled maintenance or upgrade.

If this message persists or you have any concerns, contact us from help.looker.com and we'll respond promptly.

If this message persists or you have any concerns,
contact us from help.looker.com and we'll respond promptly.