Hi all. I'm new to chainlink and postgres. I'm getting this error when I start the node
sudo docker run -p 6688:6688 -v chainlink:/chainlink -it --env-file=.env smartcontract/chainlink:0.9.4 local n ... [FATAL] Unable to initialize ORM: pq: syntax error at or near "INCLUDE" error running migrations github.com/smartcontractkit/chainlink/core/store/migrations.MigrateTo /chainlink/core/store/migrations/migrate.go:436 github.com/smartcontractkit/chainlink/core/store/migrations.Migrate /chainlink/core/store/migrations/migrate.go:410
Another error when I switch to latest version
sudo docker run -p 6688:6688 -v chainlink:/chainlink -it --env-file=.env smartcontract/chainlink:latest local n ... [ERROR] unable to lock ORM: postgres advisory locking strategy failed on .Lock, timeout set to 500ms: sql: connection is already closed, lock ID: 1027321974924625846: can't acquire advisory lock logger/default.go:139 stacktrace=github.com/smartcontractkit/chainlink/core/logger.Error
This is my .env
ROOT=/chainlink LOG_LEVEL=debug ETH_CHAIN_ID=1 MIN_OUTGOING_CONFIRMATIONS=2 LINK_CONTRACT_ADDRESS=0x514910771af9ca656af840dff83e8264ecf986ca SECURE_COOKIES=false GAS_UPDATER_ENABLED=true ALLOW_ORIGINS=* ETH_URL=wss://mainnet.infura.io/ws/v3/123456789abcdef0 DATABASE_URL=postgresql://justin:firstname.lastname@example.org:5434/chainlinketh?sslmode=disable ETH_DISABLED=true
can i please be directed to where i could get some assistance with chain link node questions? I'm 4 days old at this.
currently my node is trying to complete jobs that are pending outgoing confirmations. I happened to delete jobs from node Gui and deleted the contracts. Trying to figure out how to complete them using a different contract address with information i am getting from kovan.etherscan and terminal used for node.