Hello guys, i've been trying to deploy my directus api on production(bare metal), i executed npx directus bootstrap and then npx snapshot apply. The bootstrap command worked successfully; creating the base directus tables. But the apply snapshot is getting a timeout error. Since the bootstrap command did work it's not a db connection issue. Can someone help?
#Applying Snapshot Timeout
rose canopy
rose canopy
"err": { "type": "RequestError", "message": "SELECT c.TABLE_NAME as table_name, c.COLUMN_NAME as column_name, c.COLUMN_DEFAULT as default_value, c.IS_NULLABLE as is_nullable, c.DATA_TYPE as data_type, c.CHARACTER_MAXIMUM_LENGTH as max_length, pk.PK_SET as column_key, COLUMNPROPERTY(OBJECT_ID(c.TABLE_SCHEMA + '.' + c.TABLE_NAME), c.COLUMN_NAME, 'IsIdentity') as is_identity, COLUMNPROPERTY(OBJECT_ID(c.TABLE_SCHEMA + '.' + c.TABLE_NAME), c.COLUMN_NAME, 'IsComputed') as is_generated FROM [SPPA_DB].INFORMATION_SCHEMA.COLUMNS as c LEFT JOIN ( SELECT PK_SET = CASE WHEN CONSTRAINT_NAME LIKE '%pk%' THEN 'PRIMARY' ELSE NULL END, TABLE_NAME, CONSTRAINT_CATALOG, COLUMN_NAME, COUNT(*) OVER (PARTITION BY CONSTRAINT_NAME) as PK_COUNT FROM [SPPA_DB].INFORMATION_SCHEMA.KEY_COLUMN_USAGE ) as pk ON [c].[TABLE_NAME] = [pk].[TABLE_NAME] AND [c].[TABLE_CATALOG] = [pk].[CONSTRAINT_CATALOG] AND [c].[COLUMN_NAME] = [pk].[COLUMN_NAME] AND [pk].[PK_SET] = 'PRIMARY' AND [pk].[PK_COUNT] = 1 INNER JOIN [SPPA_DB].INFORMATION_SCHEMA.TABLES as t ON [c].[TABLE_NAME] = [t].[TABLE_NAME] AND [c].[TABLE_CATALOG] = [t].[TABLE_CATALOG] AND [t].TABLE_TYPE = 'BASE TABLE'- Timeout: Request failed to complete in 15000ms", "code": "ETIMEOUT", "name": "RequestError" },