https://pulumi.com logo
Join Slack
Powered by
This message was deleted.
# general
s
This message was deleted.
n
The problem seems to lie specifically with RoleGrants, and not on all machines; the same stack deployed on a different instance runs fine. I'm puzzled.
Checked with terraform, solved by using provider 0.58.0 (current version used by pulumi is 0.57.0, which crashes the same way with the same config from tf)
I tried changing .github/workflows/update-upstream-provider.yml to fix the error in https://github.com/pulumi/pulumi-snowflake/actions/runs/4328161830 but I get another error (gradle build)
Not familiar enough with this to make a useful PR 🙂
Latest release (0.18 pulls in the changes, thanks @ancient-policeman-24615 ) but now i get a different error, on all RoleGrants:
Copy code
~   ├─ snowflake:index:RoleGrants             AIRBYTE_ROLE                                                          refresh     1 error
 ~   ├─ snowflake:index:RoleGrants             BACKEND_DEV                                                           refresh     1 error
 ~   ├─ snowflake:index:RoleGrants             BACKEND_PROD                                                          refresh     1 error
 ~   ├─ snowflake:index:RoleGrants             DBT_ROLE                                                              update      [diff: ~users]
 ~   ├─ snowflake:index:RoleGrants             BACKEND_INT                                                           refresh     1 error
 ~   ├─ snowflake:index:RoleGrants             SYSADMIN                                                              refresh     1 error
 ~   ├─ snowflake:index:RoleGrants             FIVETRAN_ROLE                                                         refresh     1 error
 ~   ├─ snowflake:index:RoleGrants             ACCOUNTADMIN                                                          refresh     1 error
 ~   └─ snowflake:index:RoleGrants             ANALYST                                                               refresh     1 error


Diagnostics:
  snowflake:index:RoleGrants (SYSADMIN):
    error: Preview failed: refreshing urn:pulumi:prod::snowflake::snowflake:index/roleGrants:RoleGrants::SYSADMIN: 1 error occurred:
    	* unexpected number of ID parts (1), expected 6

  snowflake:index:RoleGrants (FIVETRAN_ROLE):
    error: Preview failed: refreshing urn:pulumi:prod::snowflake::snowflake:index/roleGrants:RoleGrants::FIVETRAN_ROLE: 1 error occurred:
    	* unexpected number of ID parts (1), expected 6

  snowflake:index:RoleGrants (ACCOUNTADMIN):
    error: Preview failed: refreshing urn:pulumi:prod::snowflake::snowflake:index/roleGrants:RoleGrants::ACCOUNTADMIN: 1 error occurred:
    	* unexpected number of ID parts (1), expected 6

  snowflake:index:RoleGrants (BACKEND_INT):
    error: Preview failed: refreshing urn:pulumi:prod::snowflake::snowflake:index/roleGrants:RoleGrants::BACKEND_INT: 1 error occurred:
    	* unexpected number of ID parts (1), expected 6

  pulumi:pulumi:Stack (snowflake-prod):
    error: preview failed
m
Yes! What is this??
n
you get the same @melodic-car-16900?
m
I did, yes
I upgraded my various pulumi deps
n
at least I feel less alone 😄
m
To fix another problem
At least we're in the same time frame
n
classic 😉
m
So, I only get mine when I add --refresh to my pulumi up
is that the same for you?
n
no, same for all operations. at this point my snowflake stack is stuck in time. can't move on.
m
And I'm only getting it on the various grants: Table / Procedure / Sequence
ah, nightmare.
Copy code
snowflake:index:TableGrant (snowflake_tesco_uk_table_product_location_history_read_grant):
    error: Preview failed: refreshing urn:pulumi:non-pro::mast-snowflake::snowflake:index/tableGrant:TableGrant::snowflake_tesco_uk_table_product_location_history_read_grant: 1 error occurred:
    	* unexpected number of ID parts (1), expected 7

  snowflake:index:ProcedureGrant (snowflake_tesco_uk_procedure_load_product_main_grant):
    error: Preview failed: refreshing urn:pulumi:non-pro::mast-snowflake::snowflake:index/procedureGrant:ProcedureGrant::snowflake_tesco_uk_procedure_load_product_main_grant: 1 error occurred:
    	* unexpected number of ID parts (1), expected 8

  snowflake:index:SequenceGrant (snowflake_tesco_uk_table_store_store_id_sequence_usage_grant):
    error: Preview failed: refreshing urn:pulumi:non-pro::mast-snowflake::snowflake:index/sequenceGrant:SequenceGrant::snowflake_tesco_uk_table_store_store_id_sequence_usage_grant: 1 error occurred:
    	* unexpected number of ID parts (1), expected 6

  pulumi:pulumi:Stack (mast-snowflake-non-pro):
    error: preview failed

  snowflake:index:ProcedureGrant (snowflake_tesco_uk_procedure_load_product_location_history_grant):
    error: Preview failed: refreshing urn:pulumi:non-pro::mast-snowflake::snowflake:index/procedureGrant:ProcedureGrant::snowflake_tesco_uk_procedure_load_product_location_history_grant: 1 error occurred:
    	* unexpected number of ID parts (1), expected 8
n
looks borked indeed
i wonder if downgrading 2 versions back would work, haven't tested it but I think there were other issues that prompted me to upgrade
m
Yeah I was about to ask
n
i'll give it a shot on monday, enough for this week. will report here if i get around to it before someone at @echoing-match-29901 fixes that bug
m
Alright, I'm going to persevere for a while, I'll let you know what my resolution is
n
thanks heaps
m
Downgrading to what I came from, 0.14.0 doesn't look like it's worked, which frankly fills me with dread - I figure I might end up commenting out the grants -> delete -> uncomment -> recreate
😱 1
idk
Oh wait, no, downgrading did work, I just had to run pulumi up without --refresh once, then rerunning with --refresh did work
let's try 0.16.0
Moving up to 0.16.0 was fine
0.16 -> 0.18 failed in the same way
am going to try 0.17
Copy code
snowflake:index:TableGrant (snowflake_tesco_uk_table_wsn_live_read_grant):
    error: Preview failed: error reading from server: EOF

  snowflake:index:Schema (snowflake_gelsons_source_schema):
    error: Preview failed: error reading from server: EOF

  snowflake:index:WarehouseGrant (snowflake_compute_warehouse_usage_grant):
    error: Preview failed: error reading from server: EOF

  snowflake:index:TableGrant (snowflake_tesco_uk_standard_table_product_select_grant):
    error: Preview failed: error reading from server: EOF

  snowflake:index:Table (snowflake_tesco_uk_table_store_store):
    error: Preview failed: error reading from server: EOF

  snowflake:index:Role (snowflake_role_write):
    error: Preview failed: error reading from server: EOF

  snowflake:index:SchemaGrant (snowflake_test_source_schema_grant):
    error: Preview failed: error reading from server: EOF

  snowflake:index:Procedure (snowflake_tesco_uk_procedure_load_product_main):
    error: Preview failed: error reading from server: EOF

  snowflake:index:SequenceGrant (snowflake_tesco_uk_table_product_main_id_sequence_usage_grant):
    error: Preview failed: error reading from server: EOF
Does something think that I'm DDOSing them or something?
Ok, 0.17.0 is failing is strange and unusual ways, I'm going to stick to 0.16.0 and call it a day
best of luck
n
no luck for me so far, now i get the same message even downgrading to 0.14!
the "unexpected number of ID parts (1), expected 6" one. All on RoleGrants
m
Do you get it when using pulumi up without --refresh>?
n
yes, makes no difference
m
That's upsetting
I feel for you
n
So. I simply deleted all the role grants with pulumi state delete --force and reran refresh and up, and everything works again -apparently- on 0.18. Case closed, i don't know, could be corruption of the state file when running under buggy 0.17? no idea, but problem gone.
m
--force
terrifies me. Luckily grants are something that can be nuked and recreated relatively easily I guess. Awesome, glad you sorted it out 👌
n
yes, the force shouldn't be used lightly 🙂
3 Views
Open in Slack
PreviousNext
Powered by