Comments (4)
e-gineer
commented on September 28, 2024
I'm seeing the same error, but it's limited to that specific repository. The query works well for other repos. I believe there must be a specific issue in the results which is triggering the escape parsing error.
from steampipe-plugin-github.
judell
commented on September 28, 2024
Perhaps related, I'm seeing another error that seems specific to that repo.
select count(*) from github_release where repository_full_name = 'turbot/steampipe';
ERROR: rpc error: code = Unknown desc = failed to populate column 'published_at': rpc error: code = Internal desc = transform convertTimestamp failed with panic runtime error: invalid memory address or nil pointer dereference
select count(*) from github_release where repository_full_name = 'turbot/steampipe-plugin-github'
count
1
from steampipe-plugin-github.
LalitLab
commented on September 28, 2024
The below query was failing for the commit 76ffc09
select
sha,
author_login,
author_date, message
from
github_commit
where
repository_full_name = 'turbot/steampipe' and sha = '76ffc09a340612b2831efcbf3a8488b2f6360104';It failed specifically while parsing commit field to jsonb.
{Name: "commit", Type: proto.ColumnType_JSON, Description: "Commit details."},
2021-09-30 11:20:14.467 GMT [86758] ERROR: invalid input syntax for type json
2021-09-30 11:20:14.467 GMT [86758] DETAIL: Escape sequence "\'" is invalid.
2021-09-30 11:20:14.467 GMT [86758] CONTEXT: JSON data, line 1: ...pe-postgre-fdw to v0.2.2 - fix JSON data with '\'...
{
"sha": "76ffc09a340612b2831efcbf3a8488b2f6360104",
"node_id": "MDY6Q29tbWl0MzMwNDA1MTg0Ojc2ZmZjMDlhMzQwNjEyYjI4MzFlZmNiZjNhODQ4OGIyZjYzNjAxMDQ=",
"url": "https://api.github.com/repos/turbot/steampipe/git/commits/76ffc09a340612b2831efcbf3a8488b2f6360104",
"html_url": "https://github.com/turbot/steampipe/commit/76ffc09a340612b2831efcbf3a8488b2f6360104",
"author": {
"name": "kai",
"email": "[email protected]",
"date": "2021-09-08T14:10:22Z"
},
"committer": {
"name": "kai",
"email": "[email protected]",
"date": "2021-09-08T14:10:22Z"
},
"tree": {
"sha": "d38ec7a3e6fc07129743aae158596cc0acb72796",
"url": "https://api.github.com/repos/turbot/steampipe/git/trees/d38ec7a3e6fc07129743aae158596cc0acb72796"
},
"message": "Update steampipe-postgre-fdw to v0.2.2 - fix JSON data with '\\u0000' resulting in Postgres error \"unsupported Unicode escape sequence\".",
"parents": [
{
"sha": "199206089d1a1cff81c34c49bb4d1faa3cc85e41",
"url": "https://api.github.com/repos/turbot/steampipe/git/commits/199206089d1a1cff81c34c49bb4d1faa3cc85e41",
"html_url": "https://github.com/turbot/steampipe/commit/199206089d1a1cff81c34c49bb4d1faa3cc85e41"
}
],
"verification": {
"verified": false,
"reason": "unsigned",
"signature": null,
"payload": null
}
}from steampipe-plugin-github.
e-gineer
commented on September 28, 2024
Fixed in Steampipe v0.8.5
https://github.com/turbot/steampipe/blob/main/CHANGELOG.md#v085-2021-10-07
from steampipe-plugin-github.
Related Issues (20)
- Update documentation with instructions on using fine-grained access tokens HOT 8
- Add `created_at` list key column and potentially others in `github_actions_repository_workflow_run` table HOT 3
- Include triggering_actor in GitHub Workflow Runs HOT 8
- Querying workflow runs does not return all results HOT 14
- Update plugin to use DefaultRetryConfig
- Remove `temp_clone_token` column from all repo tables.
- YAML unmarshal error in `github_workflow.pipeline` column HOT 6
- GitHub v3 API fields cause error in `github_search_repository` table HOT 1
- A way to query for assignee on Pull Requests HOT 1
- 502 Bad Gateway with repos with large amount of PRs HOT 2
- Strange behavior: "Variable $includeAllowUpdateBranch is used by anonymous query" HOT 1
- failed to populate column 'interaction_ability' HOT 3
- Variable definition error in github_branch table
- Table github_workflow fails with error when we pass all repositories HOT 6
- Using a Github App token with Steampipe doesn't work HOT 7
- Table github_search_user fails with error `Error: Variable $includeUserAnyPinnableItems is used by anonymous query but not declared`
- rate-limit makes the plugin unusable HOT 49
- Join between github_repository_dependabot_alert and github_search_pull_request results in error HOT 3
- Table github_workflow: failed to populate column 'pipeline': EOF (SQLSTATE HV000) HOT 4
- Add table github_outside_collaborators HOT 15
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from steampipe-plugin-github.