Re: Sequence number

2019-10-22 Thread jesse
Please see comments in line. On Tue, Oct 22, 2019, 3:40 PM Josh Elser wrote: > Are you saying that you didn't restart the Phoenix QueryServer after you > restored the Phoenix system tables? > We did not restart PQS after restoration of system tables. > And then, after running into issues, you

Re: Sequence number

2019-10-22 Thread Josh Elser
Are you saying that you didn't restart the Phoenix QueryServer after you restored the Phoenix system tables? And then, after running into issues, you restarted PQS and then it worked as expected? I can respect that we probably don't say this anywhere, but you should definitely be restarting

Re: Sequence number

2019-10-22 Thread jesse
It is properly restored, we double checked. We worked around the issue by restarting the query server. But it seems a bad bug. On Tue, Oct 22, 2019, 11:34 AM Thomas D'Silva wrote: > Are you sure SYSTEM.SEQUENCE was restored properly? What is the current > value of the sequence in the resto

Re: Sequence number

2019-10-22 Thread Thomas D'Silva
Are you sure SYSTEM.SEQUENCE was restored properly? What is the current value of the sequence in the restored table? On Fri, Oct 4, 2019 at 1:52 PM jesse wrote: > Let's say there is a running cluster A, with table:books and > system.sequence current value 5000, cache size 100, incremental is 1,

Sequence number

2019-10-04 Thread jesse
Let's say there is a running cluster A, with table:books and system.sequence current value 5000, cache size 100, incremental is 1, the latest book with sequence id:4800 Now the cluster A snapshot is backed up & restored into cluster b, system.sequence and books table are properly restored, when we