Error when running plugin

shemreader commented 5 months ago

Hi I am trying to use confluence and i am getting the following error. steampipe query "select * from confluence_content;" Error: rpc error: code = Internal desc = hydrate function listContent failed with panic runtime error: invalid memory address or nil pointer dereference (SQLSTATE HV000) +----+-------+-----------+--------+------+----------------+------+ | id | title | space_key | status | type | version_number | _ctx | +----+-------+-----------+--------+------+----------------+------+ +----+-------+-----------+--------+------+----------------+------+ any ideas why ? Thanks

ellisvalentiner commented 5 months ago

I'm not sure why you're getting that error but I can look at this next week.

Do you have any other logs you can share?

e-gineer commented 5 months ago

@shemreader Do you get more information in ~/.steampipe/logs if you try doing

export STEAMPIPE_LOG_LEVEL=debug

and then rerunning?

shemreader commented 5 months ago

hi

This is the pluginlog 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Plugin execute table name: grafana_dashboard quals: NONE (1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Executing for 1 connection: grafanatest 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Setting max concurrent connections to 25 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Plugin execute connection grafanatest 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: executeForConnection callId: 1718259544279, connectionCallId: grafanatest-1718259544279, connection: grafanatest table: grafana_dashboard cols: 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Setting free memory interval to 100 rows 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: cacheEnabled, trying cache get (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryCache Get - indexBucketKey index__grafanatest_grafana_dashboard, quals: grafanatest-1718259544279 (NONE) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryCache getCachedQueryResult - table grafana_dashboard, connectionName grafanatest (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: index bucket key: index__grafanatest_grafana_dashboard ttlSeconds 300 limit: -1 (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: getCachedQueryResult found no index bucket for table grafana_dashboard (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: getCachedQueryResult returned CACHE MISS - checking for pending transfers (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: startSet table: grafana_dashboard (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: queryCacheGet returned CACHE MISS (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: calling fetchItems, table: grafana_dashboard, matrixItem: [], limit: -1 (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryData streamRows (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: setRequestSubscriber readRowsAsync publisher grafanatest-1718259544279 (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: initialiseRateLimiters for query data 0xc014798000 (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: getHydrateCallRateLimiter (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: resolveRateLimiterScopeValues (grafanatest-1718259544279) 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: HydrateCall tags map[function_name:listDashboard] 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Table tags map[table:grafana_dashboard] 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryData rateLimiterScopeValues map[connection:grafanatest] 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: merged scope values map[connection:grafanatest function_name:listDashboard table:grafana_dashboard] 2024-06-13 06:19:04.636 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: resolvedRateLimiterConfig: no rate limiters (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [ERROR] steampipe-plugin-grafana.plugin: [ERROR] 1718259544279: grafana_dashboard.listDashboard: query_error="Get @./api/search?type=dash-db\": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2" 2024-06-13 06:19:04.640 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: doList callHydrateWithRetries (grafanatest-1718259544279) returned err Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 2024-06-13 06:19:04.640 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: QueryData StreamError Get **@.**/api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: rowData chan returned nil - wait for rows to complete (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: buildRowsAsync goroutine returning (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryData streamRows DONE (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: streamRows execution has failed: grafanatest-1718259544279

calling queryCache.AbortSet (grafanatest: Get @./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2) 2024-06-13 06:19:04.640 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: QueryCache AbortSet - aborting request with error grafanatest: Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 (1 subscriber) (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryCache AbortSet pendingItemComplete (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryCache AbortSet - deleting 0 pages from the cache (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: QueryCache AbortSet done (grafanatest-1718259544279) 2024-06-13 06:19:04.640 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: queryData.streamRows returned error: grafanatest: Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 2024-06-13 06:19:04.640 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: executeForConnection COMPLETE callId: 1718259544279, connectionCallId: grafanatest-1718259544279, connection: grafanatest table: grafana_dashboard cols: 2024-06-13 06:19:04.641 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: executeForConnection grafanatest returned error grafanatest: Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2, writing to CHAN 2024-06-13 06:19:04.641 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: output wg complete - send nil response (1718259544279) 2024-06-13 06:19:04.641 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: error channel received grafanatest: Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 2024-06-13 06:19:04.641 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: empty row on output channel - we are done 2024-06-13 06:19:04.641 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: return without streaming nil row as this is GRPC stream 2024-06-13 06:19:04.641 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Plugin execute table: grafana_dashboard closing error chan and output chan (1718259544279) 2024-06-13 06:19:04.641 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: Plugin execute complete (1718259544279) 2024-06-13 06:19:04.641 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: readRowsAsync stream context was cancelled - publisher grafanatest-1718259544279 (grafanatest-1718259544279) 2024-06-13 06:19:04.641 UTC [INFO] steampipe-plugin-grafana.plugin: [INFO] 1718259544279: setRequestSubscriber readRowsAsync goroutine returning - doneChan CLOSED - publisher grafanatest-1718259544279 (grafanatest-1718259544279) 2024-06-13 06:19:04.644 UTC [WARN] steampipe-plugin-grafana.plugin: [WARN] 1718259544279: readAndStreamAsync failed to read previous rows from cache: grafanatest: Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 publisher grafanatest-1718259544279 (grafanatest-1718259544279) **@.***@data-prod-tf-shemer-definity-poc-1:~/.steampipe/logs$

this is the database log 2024-06-13 06:19:04.631 UTC [INFO] hub: RemoteHub.LoadConnectionConfig 2024-06-13 06:19:04.631 UTC [INFO] hub: ensureDefaultConfigFile 2024-06-13 06:19:04.631 UTC [INFO] hub: loadConfig is loading connection config 2024-06-13 06:19:04.632 UTC [INFO] hub: loadConfig calling initializePlugins 2024-06-13 06:19:04.632 UTC [INFO] hub: goFdwBeginForeignScan, connection 'grafanatest', table 'grafana_dashboard', explain: false 2024-06-13 06:19:04.633 UTC [INFO] hub: goFdwBeginForeignScan, canPushdownAllSortFields true 2024-06-13 06:19:04.633 UTC [INFO] hub: goFdwBeginForeignScan, table 'grafana_dashboard', sortOrder: [] 2024-06-13 06:19:04.633 UTC [INFO] hub: RemoteHub startScanForConnection 'grafanatest' limit -1 2024-06-13 06:19:04.634 UTC [INFO] hub: buildConnectionLimitMap, table: 'grafana_dashboard', 1 connection, limit: -1 2024-06-13 06:19:04.634 UTC [INFO] hub: -------- 2024-06-13 06:19:04.634 UTC [INFO] hub: no quals 2024-06-13 06:19:04.634 UTC [INFO] hub: -------- 2024-06-13 06:19:04.634 UTC [INFO] hub: goFdwIterateForeignScan calling pluginHub.StartScan, table 'grafana_dashboard' Current timestamp: 771574745000000 (0xc000568c40) 2024-06-13 06:19:04.634 UTC [INFO] hub: hubBase StartScan 2024-06-13 06:19:04.634 UTC [INFO] hub: build executeConnectionData map: hub: 0xc000552230, i.connectionLimitMap: map[grafanatest:-1] 2024-06-13 06:19:04.634 UTC [INFO] hub: build executeConnectionData map returning table:"grafana_dashboard" query_context:{} connection:"grafanatest" call_id:"1718259544279" trace_context:{value:"{}"} executeConnectionData:{key:"grafanatest" value:{cache_enabled:true cache_ttl:300}} 2024-06-13 06:19:04.634 UTC [INFO] hub: StartScan for table: grafana_dashboard, cache enabled: false, iterator 0xc000568c40, 0 quals (1718259544279) 2024-06-13 06:19:04.641 UTC [WARN] hub: stream receive error rpc error: code = Unknown desc = grafanatest: Get @./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 (0xc000568c40) 2024-06-13 06:19:04.641 UTC [INFO] hub: goFdwIterateForeignScan Next returned error: rpc error: code = Unknown desc = grafanatest: Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 (0xc000568c40) 2024-06-13 06:19:04.641 UTC [24464] ERROR: rpc error: code = Unknown desc = grafanatest: Get **@./api/search?type=dash-db": tls: failed to verify certificate: x509: certificate is valid for . playticorp.com, playticorp.com, not datainfra-prod-grafana-01.va2 2024-06-13 06:19:04.641 UTC [24464] STATEMENT: select count() from grafanatest.grafana_dashboard; 2024-06-13 06:19:04.641 UTC [INFO] hub: goFdwAbortCallback 2024-06-13 06:19:04.641 UTC [INFO] hub: AddScanMetadata for iterator 0xc000568c40 query timestamp 771574745000000 (grafanatest) 2024-06-13 06:19:04.641 UTC [INFO] hub: removeStaleScanMetadata for current query timestamp 771574745000000 2024-06-13 06:19:04.641 UTC [INFO] hub: REMOVING timestamp 771574678000000 2024-06-13 06:19:54.722 UTC [24435] LOG: disconnection: session time: 0:02:00.000 user=root database=steampipe host=127.0.0.1 port=11282 @.@data-prod-tf-shemer-definity-poc-1:~/.steampipe/logs$

On Tue, Jun 11, 2024 at 7:02 PM Nathan Wallace @.***> wrote:

@shemreader https://github.com/shemreader Do you get more information in ~/.steampipe/logs if you try doing

export STEAMPIPE_LOG_LEVEL=debug

and then rerunning?

— Reply to this email directly, view it on GitHub https://github.com/ellisvalentiner/steampipe-plugin-confluence/issues/57#issuecomment-2161120490, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHW564VML2EB7WHIE5YM2UTZG4NQRAVCNFSM6AAAAABJDYYOOGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNRRGEZDANBZGA . You are receiving this because you were mentioned.Message ID: @.*** com>

ellisvalentiner commented 5 months ago

The logs appear to be exclusively about the grafana plugin, not this one.

I can't reproduce, so closing for now. Happy to reopen if there is more info.

ellisvalentiner / steampipe-plugin-confluence

Error when running plugin #57