influxdata/influxdb · error · Error

specified column (name: ) does not exist in the table…

Error message

specified column (name: {column_name}) does not exist in the table definition

What it means

Error::ColumnDoesNotExistByName is thrown when a last cache operation references a column by name that is not present in the table's schema. Last cache configuration (key columns, value columns) must reference columns that exist in the table definition, and the library validates column names against the schema before building the cache. The offending name is reported via the column_name field.

Solutions

Verify the column name against the table schema (case-sensitive) and fix the typo
Fetch the current table schema and validate all configured column names before creating/updating the cache
If the column was renamed or dropped, update the cache configuration to the new schema
Ensure schema migrations run before cache creation so referenced columns exist

Example fix

// before
let cfg = LastCacheConfiguration::new(vec!["tags_user_id".into()], &schema)?; // typo
// after
let col = "user_id";
schema
    .column(col)
    .ok_or_else(|| format!("column {col} not in table schema"))?;
let cfg = LastCacheConfiguration::new(vec![col.into()], &schema)?;

Defensive patterns

Strategy: validation

Validate before calling

// validate all configured columns against the table schema first
for col in &cache_columns {
    schema
        .column(col)
        .ok_or_else(|| format!("column '{col}' does not exist in table '{}' schema", table_name))?;
}

Try / catch

match provider.create_last_cache(db, table, cfg) {
    Err(Error::ColumnDoesNotExistByName { column_name }) => {
        eprintln!("fix column name '{column_name}' in cache config");
    }
    r => r?,
}

Prevention

Generate cache column lists from the live schema instead of hardcoding names
Run schema migrations before cache provisioning
Match column names case-exactly and lint cache configs against schema in CI

When it happens

Trigger: Calling create_last_cache or cache update APIs with a key_column_names or value_columns entry that doesn't exist in the table; SQL CREATE Last CACHE naming a misspelled or renamed column; referencing a column before the schema was updated to include it.

Common situations: Typos or case-mismatch in column names; schema changed (column dropped/renamed) while cache config was not updated; provisioning scripts written against a different schema version; columns added later than the cache creation.

Understand the failure class

Background: Schema validation failed / invalid input schema: payload rejected because its shape doesn't match the expected schema — this error's family across 28 libraries.

Related errors

AI-assisted analysis of influxdata/influxdb@06200ef96b (2026-09-19). Data as JSON: /api/errors/1aae8a79175b44d4. Report an issue: GitHub.

Appendix: source

Thrown at influxdb3_cache/src/last_cache/mod.rs:22

mod cache;
pub use cache::CreateLastCacheArgs;
mod metrics;
mod provider;
pub use provider::{LastCacheProvider, background_catalog_update};
mod table_function;
use schema::InfluxColumnType;
pub use table_function::{LAST_CACHE_UDTF_NAME, LastCacheFunction};

#[derive(Debug, thiserror::Error)]
pub enum Error {
    #[error("invalid cache size")]
    InvalidCacheSize,
    #[error(
        "last cache already exists for database and table, but it was configured differently: {reason}"
    )]
    CacheAlreadyExists { reason: String },
    #[error("specified column (name: {column_name}) does not exist in the table definition")]
    ColumnDoesNotExistByName { column_name: String },
    #[error("specified column (id: {column_id}) does not exist in the table definition")]
    ColumnDoesNotExistById { column_id: ColumnId },
    #[error("specified key column (id: {column_id}) does not exist in the table schema")]
    KeyColumnDoesNotExist { column_id: ColumnId },
    #[error("specified key column (name: {column_name}) does not exist in the table schema")]
    KeyColumnDoesNotExistByName { column_name: String },
    #[error("key column must be string, int, uint, or bool types, got: {column_type}")]
    InvalidKeyColumn { column_type: InfluxColumnType },
    #[error("specified value column ({column_id}) does not exist in the table schema")]
    ValueColumnDoesNotExist { column_id: ColumnId },
    #[error("requested last cache does not exist")]
    CacheDoesNotExist,
}

impl Error {
    fn cache_already_exists(reason: impl Into<String>) -> Self {
        Self::CacheAlreadyExists {

View on GitHub (pinned to 06200ef96b)