Postgrex error ERROR 42601 when starting Oban.Met

Special Sections Oban
, ,
1

Hello everyone, Im getting this error when configuring Oban on my phoenix App, Pls I need your expertise on this
Im using Oban 2.19

3

The error is coming from oban_met, the oban version shouldn’t matter here.

[error] GenServer {Oban.Registry, {Oban, Oban.Met.Reporter}} terminating ** (Postgrex.Error) ERROR 42601 (syntax_error) syntax error at or near “false”

Which version of Postgres are you using? It looks like creating the estimate function is failing, most likely due to an incompatible Postgres version.

You can try creating it manually (Oban.Met — Oban Met v1.0.3), or disable it entirely by setting auto_migrate: false for the reporter without running the migration at all.

4

Thanks sorentwo, I really appreciate. I was able to resolved the issue by changing my engine from Oban.Engines.Lite to Oban.Engines.Basic
in my configuration settings…

The one tha was throwing error

 config :restaurant_api, Oban,
  repo: RestaurantApi.Repo,
  engine: Oban.Engines.Lite,
  plugins: [
    Oban.Plugins.Pruner,
    # Oban.Plugins.Cron
  ],
  queues: [
    default: 10,
    mailers: 20
  ]

The one that is working.

 config :restaurant_api, Oban,
  repo: RestaurantApi.Repo,
  engine: Oban.Engines.Basic,
  plugins: [
    Oban.Plugins.Pruner,
    # Oban.Plugins.Cron
  ],
  queues: [
    default: 10,
    mailers: 20
  ]