turbot / steampipe-plugin-alicloud

Use SQL to instantly query Alibaba Cloud resources across regions and accounts. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/alicloud
Apache License 2.0
11 stars 4 forks source link

Alicloud OSS Bucket Query Timeout Error: RPC Deadline Exceeded on select * from alicloud_oss_bucket Command #415

Open Priyanka-Chatterjee-2000 opened 2 months ago

Priyanka-Chatterjee-2000 commented 2 months ago

Describe the bug A clear and concise description of what the bug is. Whenever I am querying I am getting error:

select * from alicloud_oss_bucket

Error: rpc error: code = DeadlineExceeded desc = alicloud: exceeded allowed timeout (SQLSTATE HV000)

+------+-----+----------+---------------+---------------+-----------------+------------+-----+------------------------+-----------------+---------+--------+----------+------+-------+------+--------+------------+--------------------+--------+------+
| name | arn | location | creation_date | storage_class | redundancy_type | versioning | acl | server_side_encryption | lifecycle_rules | logging | policy | tags_src | tags | title | akas | region | account_id | sp_connection_name | sp_ctx | _ctx |
+------+-----+----------+---------------+---------------+-----------------+------------+-----+------------------------+-----------------+---------+--------+----------+------+-------+------+--------+------------+--------------------+--------+------+
+------+-----+----------+---------------+---------------+-----------------+------------+-----+------------------------+-----------------+---------+--------+----------+------+-------+------+--------+------------+--------------------+--------+------+

My alicloud.spc

connection "alicloud" {
  plugin = "alicloud"
  access_key = "LTAI5................."
  secret_key = "4tQiPK0rO0u............."
}

Whereas with the same config file I am able to query other resources like:

select * from alicloud_ecs_instance
+-------------------------+------------------------+--------------------------------------------------------------------------+-------------------+---------------------------+---------+-------------+----------------+---------------------------+---------------------+--->
| name                    | instance_id            | arn                                                                      | instance_type     | vpc_id                    | status  | description | billing_method | creation_time             | deletion_protection | in>
+-------------------------+------------------------+--------------------------------------------------------------------------+-------------------+---------------------------+---------+-------------+----------------+---------------------------+---------------------+--->
| launch-advisor-20240503 | i-bp10l632wjduvdh5r89l | arn:acs:ecs:cn-hangzhou:88888888888:instance/i-bp10l632wjduvdh5r89l | ecs.t5-lc2m1.nano | vpc-bp1o12th66wgwq0rghcxn | Running | <null>      | PostPaid       | 2024-05-03T12:48:00+05:30 | false               | vp>
+-------------------------+------------------------+--------------------------------------------------------------------------+-------------------+---------------------------+---------+-------------+----------------+---------------------------+---------------------+--->

On adding regions = ["us-east-1"] to my alicloud.spc am not getting the error:

select * from alicloud_oss_bucket
+------------------+--------------------------------+----------------+---------------------------+---------------+-----------------+------------+---------+----------------------------------------------------------------+-----------------+------------------------------->
| name             | arn                            | location       | creation_date             | storage_class | redundancy_type | versioning | acl     | server_side_encryption                                         | lifecycle_rules | logging                       >
+------------------+--------------------------------+----------------+---------------------------+---------------+-----------------+------------+---------+----------------------------------------------------------------+-----------------+------------------------------->
| powerpipe-bucket | arn:acs:oss:::powerpipe-bucket | oss-cn-beijing | 2024-03-01T02:07:11+05:30 | Standard      | ZRS             |            | private | {"KMSDataEncryption":"","KMSMasterKeyID":"","SSEAlgorithm":""} | <null>          | {"TargetBucket":"powerpipe-buc>
+------------------+--------------------------------+----------------+---------------------------+---------------+-----------------+------------+---------+----------------------------------------------------------------+-----------------+------------------------------->

Example: v0.3.0

Plugin version (steampipe plugin list) Example: v0.5.0

To reproduce Steps to reproduce the behavior (please include relevant code and/or commands).

Expected behavior A clear and concise description of what you expected to happen.

Additional context Add any other context about the problem here.

github-actions[bot] commented 1 week ago

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.