Thanks! My confluence username is jagrutsharma. -- Jagrut
On Sat, Jun 23, 2018 at 4:29 PM, Bryan Bende <bbe...@gmail.com> wrote: > Sure, that would be good. I think you may need permissions to edit the wiki > page, but if you let us know your confluence account we can get you added. > I’m not at a computer right now, but can take care of it tomorrow if no one > else gets to it first. > > Thanks, > > Bryan > > On Sat, Jun 23, 2018 at 6:56 PM Jagrut Sharma <jagrutsha...@gmail.com> > wrote: > > > Thanks Bryan. Your explanation makes sense. Would it be ok if I add a > short > > section to this guide > > https://cwiki.apache.org/confluence/display/NIFIREG/Migration+Guidance > > with > > steps to switch 0.2.0 (H2) to 0.2.0 (PostgreSQL)? > > > > Thanks. > > -- > > Jagrut > > > > On Sat, Jun 23, 2018 at 2:52 PM, Bryan Bende <bbe...@gmail.com> wrote: > > > > > Hello, > > > > > > This is actually expected behavior... > > > > > > The migration is only setup to migrate the database from 0.1.0 which > was > > > named nifi-registry.mv.db. > > > > > > If you have an H2 DB named nifi-registry-primary.mv.db this is the name > > of > > > the new H2 DB in 0.2.0, so it’s not looking for this because the idea > was > > > you’d migrate to Postgres when you did the upgrade to 0.2.0 before you > > ever > > > had this file. Since you didn’t migrate to Postgres on the upgrade, it > > > migrated to a new H2 DB. > > > > > > It is nice to know that you can do it later on by renaming the file, > and > > > maybe we can add that to the migration notes wiki or admin guide. > > > > > > Thanks, > > > > > > Bryan > > > > > > On Sat, Jun 23, 2018 at 5:02 PM Kevin Doran <kdo...@apache.org> wrote: > > > > > > > Hi Jagrut, > > > > > > > > I think this is configurable. How did you configure you > > > > nifi-registry.properties file? > > > > > > > > Thanks, > > > > Kevin > > > > > > > > ________________________________ > > > > From: Jagrut Sharma <jagrutsha...@gmail.com> > > > > Sent: Saturday, June 23, 2018 2:43:33 PM > > > > To: dev@nifi.apache.org > > > > Subject: Registry H2 to PostgreSQL migration > > > > > > > > Hi - I performed migration from H2 to PostgreSQL, and ran into a > > > potential > > > > bug. > > > > > > > > After switching the database config, registry started up fine. But > the > > > > tables were all empty. On digging a bit deeper, I found that the > > default > > > H2 > > > > database file is named nifi-registry-primary.mv.db. The migration > code > > is > > > > looking for a file named nifi-registry.mv.db and hence unable to find > > it. > > > > The log reports 'Did not find legacy database file...' > > > > > > > > To verify this, I renamed existing H2 file to nifi-registry.mv.db. > Upon > > > > startup, the file was detected and migration happened properly. > > > > > > > > I can file a JIRA, but just wanted to make sure I was not missing any > > > > config step. > > > > > > > > Thanks. > > > > -- > > > > Jagrut > > > > > > > -- > > > Sent from Gmail Mobile > > > > > > > > > > > -- > > Jagrut > > > -- > Sent from Gmail Mobile > -- Jagrut
