Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Chore: SLT failures with snowflake due to invalid auth tests #2168

Closed
scsmithr opened this issue Nov 27, 2023 · 2 comments
Closed

Chore: SLT failures with snowflake due to invalid auth tests #2168

scsmithr opened this issue Nov 27, 2023 · 2 comments
Labels
chore DX, infra etc that's not build or CI related

Comments

@scsmithr
Copy link
Member

Description

17:42:23.621 ERROR testing::slt::cli: Error while running test `sqllogictests_snowflake/external_database` error=test fail: statement failed: internal error: cannot execute simple query: db error: ERROR: External database validation failed: Snowflake Auth Error (390102): Your user account has been temporarily locked due to too many failed attempts. Try again after 15 minutes or contact your account administrator for assistance. For more information about this error, go to https://community.snowflake.com/s/error-your-user-login-has-been-locked.
[SQL] CREATE EXTERNAL DATABASE external_db
	FROM snowflake
	OPTIONS (
		account = 'hmpfscx-xo23956',
		username = '***',
		password = '***',
		database = 'glaredb_test',
		warehouse = 'compute_wh',
		role = 'accountadmin',
	);
at /home/runner/work/glaredb/glaredb/testdata/sqllogictests_snowflake/external_database.slt:3
@scsmithr scsmithr added the chore DX, infra etc that's not build or CI related label Nov 27, 2023
@tychoish
Copy link
Contributor

in earlier discussions we've thought that the problem here is that we see this when we're running too many instances of the tests at the same time, and that we should in some way serialize them (maybe there's an action's helper that could help this?) if nothing else we should split it out of the main integration block so we can see when it's the failure.

@tychoish
Copy link
Contributor

I believe that #2278 should have resolved this, if we see it again we can attempt other things.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
chore DX, infra etc that's not build or CI related
Projects
None yet
Development

No branches or pull requests

2 participants