You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by David Gallagher <dg...@CleverDevices.com> on 2020/02/06 14:15:32 UTC
Loss of state on QueryDatabaseTable during upgrade
Hi - I'm upgrading flows from 1.8.0 to 1.11.1. Everything is working nicely, but it looks like I may have lost the State values of my QueryDatabaseTable processors (I'm using a Maximum ID). I've looked in the state file (\state\local\snapshot) and the value is there, but it's not showing in the UI when I right-click the processor and choose 'View State'. Is this expected? If so, is there a way that I can insert state values for the processors? Otherwise I would have to re-extract everything.
Thanks,
Dave
RE: Loss of state on QueryDatabaseTable during upgrade
Posted by David Gallagher <dg...@CleverDevices.com>.
Bryan / Pierre - problem was definitely on my end. Can confirm that state is preserved during upgrade. Thanks for your help!
-----Original Message-----
From: David Gallagher <dg...@CleverDevices.com>
Sent: Thursday, February 6, 2020 11:44 AM
To: users@nifi.apache.org; Bryan Bende <bb...@gmail.com>
Subject: RE: Loss of state on QueryDatabaseTable during upgrade
Actually this is probably on me - In the config file I specified the path to state as ..\..\state, not ..\state. I'll be able to test again in a little while and see.
-----Original Message-----
From: David Gallagher <dg...@CleverDevices.com>
Sent: Thursday, February 6, 2020 10:07 AM
To: users@nifi.apache.org; Bryan Bende <bb...@gmail.com>
Subject: RE: Loss of state on QueryDatabaseTable during upgrade
@Bryan Bende yes
-----Original Message-----
From: Bryan Bende <bb...@gmail.com>
Sent: Thursday, February 6, 2020 10:05 AM
To: users@nifi.apache.org
Subject: Re: Loss of state on QueryDatabaseTable during upgrade
You copied the same exact flow.xml.gz from 1.8.0 to 1.11.1 ?
On Thu, Feb 6, 2020 at 9:52 AM David Gallagher <dg...@cleverdevices.com> wrote:
>
> Hi Pierre – single node. I updated state-management.xml to point to the state folder.
>
>
>
> Thanks,
>
>
>
> Dave
>
>
>
> From: Pierre Villard <pi...@gmail.com>
> Sent: Thursday, February 6, 2020 9:35 AM
> To: users@nifi.apache.org
> Subject: Re: Loss of state on QueryDatabaseTable during upgrade
>
>
>
> Hi David,
>
>
>
> How did you perform the upgrade? Do you have a cluster with external ZK, a cluster with embedded ZK, or a single node?
>
>
>
> Thanks,
>
> Pierre
>
>
>
> Le jeu. 6 févr. 2020 à 09:15, David Gallagher <dg...@cleverdevices.com> a écrit :
>
> Hi – I’m upgrading flows from 1.8.0 to 1.11.1. Everything is working nicely, but it looks like I may have lost the State values of my QueryDatabaseTable processors (I’m using a Maximum ID). I’ve looked in the state file (\state\local\snapshot) and the value is there, but it’s not showing in the UI when I right-click the processor and choose ‘View State’. Is this expected? If so, is there a way that I can insert state values for the processors? Otherwise I would have to re-extract everything.
>
>
>
> Thanks,
>
>
>
> Dave
RE: Loss of state on QueryDatabaseTable during upgrade
Posted by David Gallagher <dg...@CleverDevices.com>.
Actually this is probably on me - In the config file I specified the path to state as ..\..\state, not ..\state. I'll be able to test again in a little while and see.
-----Original Message-----
From: David Gallagher <dg...@CleverDevices.com>
Sent: Thursday, February 6, 2020 10:07 AM
To: users@nifi.apache.org; Bryan Bende <bb...@gmail.com>
Subject: RE: Loss of state on QueryDatabaseTable during upgrade
@Bryan Bende yes
-----Original Message-----
From: Bryan Bende <bb...@gmail.com>
Sent: Thursday, February 6, 2020 10:05 AM
To: users@nifi.apache.org
Subject: Re: Loss of state on QueryDatabaseTable during upgrade
You copied the same exact flow.xml.gz from 1.8.0 to 1.11.1 ?
On Thu, Feb 6, 2020 at 9:52 AM David Gallagher <dg...@cleverdevices.com> wrote:
>
> Hi Pierre – single node. I updated state-management.xml to point to the state folder.
>
>
>
> Thanks,
>
>
>
> Dave
>
>
>
> From: Pierre Villard <pi...@gmail.com>
> Sent: Thursday, February 6, 2020 9:35 AM
> To: users@nifi.apache.org
> Subject: Re: Loss of state on QueryDatabaseTable during upgrade
>
>
>
> Hi David,
>
>
>
> How did you perform the upgrade? Do you have a cluster with external ZK, a cluster with embedded ZK, or a single node?
>
>
>
> Thanks,
>
> Pierre
>
>
>
> Le jeu. 6 févr. 2020 à 09:15, David Gallagher <dg...@cleverdevices.com> a écrit :
>
> Hi – I’m upgrading flows from 1.8.0 to 1.11.1. Everything is working nicely, but it looks like I may have lost the State values of my QueryDatabaseTable processors (I’m using a Maximum ID). I’ve looked in the state file (\state\local\snapshot) and the value is there, but it’s not showing in the UI when I right-click the processor and choose ‘View State’. Is this expected? If so, is there a way that I can insert state values for the processors? Otherwise I would have to re-extract everything.
>
>
>
> Thanks,
>
>
>
> Dave
RE: Loss of state on QueryDatabaseTable during upgrade
Posted by David Gallagher <dg...@CleverDevices.com>.
@Bryan Bende yes
-----Original Message-----
From: Bryan Bende <bb...@gmail.com>
Sent: Thursday, February 6, 2020 10:05 AM
To: users@nifi.apache.org
Subject: Re: Loss of state on QueryDatabaseTable during upgrade
You copied the same exact flow.xml.gz from 1.8.0 to 1.11.1 ?
On Thu, Feb 6, 2020 at 9:52 AM David Gallagher <dg...@cleverdevices.com> wrote:
>
> Hi Pierre – single node. I updated state-management.xml to point to the state folder.
>
>
>
> Thanks,
>
>
>
> Dave
>
>
>
> From: Pierre Villard <pi...@gmail.com>
> Sent: Thursday, February 6, 2020 9:35 AM
> To: users@nifi.apache.org
> Subject: Re: Loss of state on QueryDatabaseTable during upgrade
>
>
>
> Hi David,
>
>
>
> How did you perform the upgrade? Do you have a cluster with external ZK, a cluster with embedded ZK, or a single node?
>
>
>
> Thanks,
>
> Pierre
>
>
>
> Le jeu. 6 févr. 2020 à 09:15, David Gallagher <dg...@cleverdevices.com> a écrit :
>
> Hi – I’m upgrading flows from 1.8.0 to 1.11.1. Everything is working nicely, but it looks like I may have lost the State values of my QueryDatabaseTable processors (I’m using a Maximum ID). I’ve looked in the state file (\state\local\snapshot) and the value is there, but it’s not showing in the UI when I right-click the processor and choose ‘View State’. Is this expected? If so, is there a way that I can insert state values for the processors? Otherwise I would have to re-extract everything.
>
>
>
> Thanks,
>
>
>
> Dave
Re: Loss of state on QueryDatabaseTable during upgrade
Posted by Bryan Bende <bb...@gmail.com>.
You copied the same exact flow.xml.gz from 1.8.0 to 1.11.1 ?
On Thu, Feb 6, 2020 at 9:52 AM David Gallagher
<dg...@cleverdevices.com> wrote:
>
> Hi Pierre – single node. I updated state-management.xml to point to the state folder.
>
>
>
> Thanks,
>
>
>
> Dave
>
>
>
> From: Pierre Villard <pi...@gmail.com>
> Sent: Thursday, February 6, 2020 9:35 AM
> To: users@nifi.apache.org
> Subject: Re: Loss of state on QueryDatabaseTable during upgrade
>
>
>
> Hi David,
>
>
>
> How did you perform the upgrade? Do you have a cluster with external ZK, a cluster with embedded ZK, or a single node?
>
>
>
> Thanks,
>
> Pierre
>
>
>
> Le jeu. 6 févr. 2020 à 09:15, David Gallagher <dg...@cleverdevices.com> a écrit :
>
> Hi – I’m upgrading flows from 1.8.0 to 1.11.1. Everything is working nicely, but it looks like I may have lost the State values of my QueryDatabaseTable processors (I’m using a Maximum ID). I’ve looked in the state file (\state\local\snapshot) and the value is there, but it’s not showing in the UI when I right-click the processor and choose ‘View State’. Is this expected? If so, is there a way that I can insert state values for the processors? Otherwise I would have to re-extract everything.
>
>
>
> Thanks,
>
>
>
> Dave
RE: Loss of state on QueryDatabaseTable during upgrade
Posted by David Gallagher <dg...@CleverDevices.com>.
Hi Pierre – single node. I updated state-management.xml to point to the state folder.
Thanks,
Dave
From: Pierre Villard <pi...@gmail.com>
Sent: Thursday, February 6, 2020 9:35 AM
To: users@nifi.apache.org
Subject: Re: Loss of state on QueryDatabaseTable during upgrade
Hi David,
How did you perform the upgrade? Do you have a cluster with external ZK, a cluster with embedded ZK, or a single node?
Thanks,
Pierre
Le jeu. 6 févr. 2020 à 09:15, David Gallagher <dg...@cleverdevices.com>> a écrit :
Hi – I’m upgrading flows from 1.8.0 to 1.11.1. Everything is working nicely, but it looks like I may have lost the State values of my QueryDatabaseTable processors (I’m using a Maximum ID). I’ve looked in the state file (\state\local\snapshot) and the value is there, but it’s not showing in the UI when I right-click the processor and choose ‘View State’. Is this expected? If so, is there a way that I can insert state values for the processors? Otherwise I would have to re-extract everything.
Thanks,
Dave
Re: Loss of state on QueryDatabaseTable during upgrade
Posted by Pierre Villard <pi...@gmail.com>.
Hi David,
How did you perform the upgrade? Do you have a cluster with external ZK, a
cluster with embedded ZK, or a single node?
Thanks,
Pierre
Le jeu. 6 févr. 2020 à 09:15, David Gallagher <dg...@cleverdevices.com>
a écrit :
> Hi – I’m upgrading flows from 1.8.0 to 1.11.1. Everything is working
> nicely, but it looks like I may have lost the State values of my
> QueryDatabaseTable processors (I’m using a Maximum ID). I’ve looked in the
> state file (\state\local\snapshot) and the value is there, but it’s not
> showing in the UI when I right-click the processor and choose ‘View State’.
> Is this expected? If so, is there a way that I can insert state values for
> the processors? Otherwise I would have to re-extract everything.
>
>
>
> Thanks,
>
>
>
> Dave
>