Skip to content

job_db_uuid fails to insert into BigQuery #3944

@casassg

Description

@casassg

Describe the bug

With enable_bigquery_load, background job fails to insert due to bad schema:

DEFAULT 2025-04-14T21:07:09Z [resource.labels.instanceId: smallslurm-controller] Apr 14 21:07:09 smallslurm-controller load_bq.py[10026]: {'errors': [{'debugInfo': '',
DEFAULT 2025-04-14T21:07:09Z [resource.labels.instanceId: smallslurm-controller] Apr 14 21:07:09 smallslurm-controller load_bq.py[10026]: 'location': 'job_db_uuid',
DEFAULT 2025-04-14T21:07:09Z [resource.labels.instanceId: smallslurm-controller] Apr 14 21:07:09 smallslurm-controller load_bq.py[10026]: 'message': 'Cannot convert value to integer (bad value): '
DEFAULT 2025-04-14T21:07:09Z [resource.labels.instanceId: smallslurm-controller] Apr 14 21:07:09 smallslurm-controller load_bq.py[10026]: '9797115724809186304',
DEFAULT 2025-04-14T21:07:09Z [resource.labels.instanceId: smallslurm-controller] Apr 14 21:07:09 smallslurm-controller load_bq.py[10026]: 'reason': 'invalid'}],

Steps to reproduce

Steps to reproduce the behavior:

  1. Enable enable_bigquery_load: true
  2. Run a job
  3. Check controller logs to see above error.

Expected behavior

Rows inserted by job.

Actual behavior

No rows inserted.

Version (gcluster --version)

gcluster version v1.48.0

Output and logs

See above

Screenshots

Execution environment

  • OS: [macOS, ubuntu, ...]: MacOS
  • Shell (To find this, run ps -p $$): bash

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingfixed; not releasedissues that have been fixed on the develop branch but have not yet been part of a tagged release.

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions