ERROR Primary key missing on table: hangfire.lock when using migration to new PostgreSQL

[patsevanton]

Hello, I using Hangfire and try migrate to new PostgreSQL (Using Skytools or Londiste) get this error:

su postgres -c "londiste3 /etc/skytools/londiste-master.ini add-table --all"
2017-10-26 15:34:07,996 4722 INFO Table added: hangfire.counter
2017-10-26 15:34:08,015 4722 INFO Table added: hangfire.hash
2017-10-26 15:34:08,030 4722 INFO Table added: hangfire.job
2017-10-26 15:34:08,039 4722 INFO Table added: hangfire.jobparameter
2017-10-26 15:34:08,048 4722 INFO Table added: hangfire.jobqueue
2017-10-26 15:34:08,056 4722 INFO Table added: hangfire.list
2017-10-26 15:34:08,062 4722 ERROR Primary key missing on table: hangfire.lock

Can i added Primary key to table: hangfire.lock?

[burningice2866]

What storage provider are you using?

[patsevanton]

Hangfire.PostgreSql 1.4.8.1

[burningice2866]

Try posting your issue here then https://github.com/frankhommers/Hangfire.PostgreSql, you should have a better chance of help going directly to the author.

[FarshanAhamed]

Hi @patsevanton, did you manage to add the primary key to the lock table? I have a similar scenario where I'm trying to migrate postgres database on Google Cloud SQL.