Synthetic Jobs Do Not Run After Registering on Linux-Based Private Synthetic Agent

Issue:

Registration on Linux-based Private Synthetic Agent v21.5.0 is complete. However, after creating jobs in the Controller, the jobs do not run.

The Heimdall pod logs show the following exception:

org.springframework.data.r2dbc.BadSqlGrammarException: executeMany; bad SQL grammar [INSERT
 INTO heimdall.measurement (measurement_id, schedule_id, location_id, 
browser_type, account, job_type, last_updated, measurement_status, 
duration_secs, measurement_details) VALUES ($1, $2, $3, $4, $5, $6, $7, 
$8, $9, $10)]; nested exception is io.r2dbc.postgresql.ExceptionFactory$PostgresqlBadGrammarException: [22001] value too long for type character varying(50)
TEXT

Resolution:

Log in to the Postgres database pod and modify the location_id column size:

  1. Run this command to log in to the database:

    kubectl exec -it service/postgres --namespace measurement -- psql --username synthuser
    CODE

  2. Run this command to modify the location_id column:

    ALTER TABLE heimdall.measurement ALTER COLUMN location_id TYPE character varying(256);
    CODE