Better error logging when db sync fails

stack-auth · N2D4 · Feb 16, 2026 · Feb 2, 2026 · Feb 2, 2026 · Feb 2, 2026
commit 836eb6588f0d816eaaf8c1a9114dc2624435cd41
diff --git a/apps/e2e/tests/backend/endpoints/api/v1/external-db-sync-advanced.test.ts b/apps/e2e/tests/backend/endpoints/api/v1/external-db-sync-advanced.test.ts
@@ -37,8 +37,9 @@ async function waitForClickhouseUser(email: string, expectedDisplayName: string)
   const intervalMs = 2_000;
   const start = performance.now();
 
+  let response;
   while (performance.now() - start < timeoutMs) {
-    const response = await runQueryForCurrentProject({
+    response = await runQueryForCurrentProject({
       query: "SELECT primary_email, display_name FROM users WHERE primary_email = {email:String}",
       params: { email },
     });
@@ -51,7 +52,7 @@ async function waitForClickhouseUser(email: string, expectedDisplayName: string)
     await wait(intervalMs);
   }
 
-  throw new StackAssertionError(`Timed out waiting for ClickHouse user ${email} to sync.`);
+  throw new StackAssertionError(`Timed out waiting for ClickHouse user ${email} to sync.`, { response });
 }
 
 describe.sequential('External DB Sync - Advanced Tests', () => {

diff --git a/apps/e2e/tests/backend/endpoints/api/v1/external-db-sync-basics.test.ts b/apps/e2e/tests/backend/endpoints/api/v1/external-db-sync-basics.test.ts
@@ -30,8 +30,9 @@ async function waitForClickhouseUser(email: string, expectedDisplayName: string)
   const intervalMs = 2_000;
   const start = performance.now();
 
+  let response;
   while (performance.now() - start < timeoutMs) {
-    const response = await runQueryForCurrentProject({
+    response = await runQueryForCurrentProject({
       query: "SELECT primary_email, display_name FROM users WHERE primary_email = {email:String}",
       params: {
         email,
@@ -44,16 +45,20 @@ async function waitForClickhouseUser(email: string, expectedDisplayName: string)
     await wait(intervalMs);
   }
 
-  throw new StackAssertionError(`Timed out waiting for ClickHouse user ${email} to sync.`);
+  throw new StackAssertionError(`Timed out waiting for ClickHouse user ${email} to sync.`, { response });
 }
 
 async function waitForClickhouseUserDeletion(email: string) {
+  // ensure we definitely have project keys that don't expire (unlike an admin access token)
+  await InternalApiKey.createAndSetProjectKeys();
+
   const timeoutMs = 180_000;
   const intervalMs = 2_000;
   const start = performance.now();
 
+  let response;
   while (performance.now() - start < timeoutMs) {
-    const response = await runQueryForCurrentProject({
+    response = await runQueryForCurrentProject({
       query: "SELECT primary_email FROM users WHERE primary_email = {email:String}",
       params: {
         email,
@@ -68,7 +73,7 @@ async function waitForClickhouseUserDeletion(email: string) {
     await wait(intervalMs);
   }
 
-  throw new StackAssertionError(`Timed out waiting for ClickHouse user ${email} to be deleted.`);
+  throw new StackAssertionError(`Timed out waiting for ClickHouse user ${email} to be deleted.`, { response });
 }
 
 // Run tests sequentially to avoid concurrency issues with shared backend state