n8n-io/n8n · error · TypeORMError

Supplied index was not found in table

Error message

Supplied index ${indexOrName} was not found in table ${table.name}

What it means

dropIndex() resolves the index by name (or object) against the cached table; if none matches it throws TypeORMError. The index you are trying to drop does not exist in the table definition TypeORM has loaded.

Solutions

1. Resolve the actual index name from the live schema via getTable().indices before dropping.
2. Make the drop idempotent — check existence first.
3. Re-fetch the table via getTable() if metadata may be stale.

Example fix

// before
await queryRunner.dropIndex('user', 'IDX_user_email');

// after
const table = await queryRunner.getTable('user');
if (table?.indices.some((i) => i.name === 'IDX_user_email')) {
  await queryRunner.dropIndex(table!, 'IDX_user_email');
}

const table = await queryRunner.getTable('user');
if (table?.indices.some((i) => i.name === 'IDX_user_email')) {
  await queryRunner.dropIndex(table!, 'IDX_user_email');
}

const indexExists = async (qr: QueryRunner, tableName: string, name: string): Promise<boolean> =>
  Boolean((await qr.getTable(tableName))?.indices.some((i) => i.name === name));

When it happens

Trigger: Calling dropIndex(table, 'indexName') where 'indexName' is not present in table.indices of the cached table.

Common situations: Re-running a migration that already dropped it, a typo in the index name, a prior migration removed it, or stale cached metadata.

Related errors

• Column " " was not found in table
• Column " " was not found in table
• Column " " was not found in the " " table.
• Supplied check constraint was not found in table
• Supplied foreign key was not found in table

AI-assisted analysis of n8n-io/n8n@5ac6606e81 (2026-08-12). Data as JSON: /api/errors/f0257c6b42c99cea. Report an issue: GitHub.

Appendix: source

Thrown at packages/@n8n/typeorm/src/driver/sqlite-abstract/AbstractSqliteQueryRunner.ts:1019

	 * Creates a new indices
	 */
	async createIndices(tableOrName: Table | string, indices: TableIndex[]): Promise<void> {
		const promises = indices.map((index) => this.createIndex(tableOrName, index));
		await Promise.all(promises);
	}

	/**
	 * Drops an index from the table.
	 */
	async dropIndex(tableOrName: Table | string, indexOrName: TableIndex | string): Promise<void> {
		const table = InstanceChecker.isTable(tableOrName)
			? tableOrName
			: await this.getCachedTable(tableOrName);
		const index = InstanceChecker.isTableIndex(indexOrName)
			? indexOrName
			: table.indices.find((i) => i.name === indexOrName);
		if (!index)
			throw new TypeORMError(`Supplied index ${indexOrName} was not found in table ${table.name}`);

		// old index may be passed without name. In this case we generate index name manually.
		if (!index.name) index.name = this.generateIndexName(table, index);

		const up = this.dropIndexSql(index);
		const down = this.createIndexSql(table, index);
		await this.executeQueries(up, down);
		table.removeIndex(index);
	}

	/**
	 * Drops an indices from the table.
	 */
	async dropIndices(tableOrName: Table | string, indices: TableIndex[]): Promise<void> {
		const promises = indices.map((index) => this.dropIndex(tableOrName, index));
		await Promise.all(promises);
	}

View on GitHub (pinned to 5ac6606e81)