Ok, I will remove the backup configuration setting of cache. But about you said,
*In the case of in-memory cluster, simultaneous restart of all nodescould be a reason. Also, you could look for the log messages aboutchanging of cluster topology and errors.* For the above case, what do you suggest I should do? On Wed, Apr 26, 2023 at 4:23 PM Ilya Shishkov <shishkovi...@gmail.com> wrote: > > Is this maybe the case? This policy of K8s cause the loss of cache sql > tables? > > In the case of in-memory cluster, simultaneous restart of all nodes > could be a reason. Also, you could look for the log messages about > changing of cluster topology and errors. > > As I see from the attached picture, you start Ignite embedded into the > code, but it is unclear how you get the 'null' value for the ignite > variable. Also, for replicated cache you should not set backups > number, because all partitions of replicated cache are stored in each > node of the cluster. > > > ср, 26 апр. 2023 г. в 12:55, Abhishek Ubhe <abhishekubhe0...@gmail.com>: > > > > Hello, > > > > What is Ignite shell? Sqlline? - > Yes sqlline. > > > > It looks like all cluster nodes have failed or restarted. - > May be > because K8s pods are getting restarted as per container restart policy. > > > > Is this maybe the case? This policy of K8s cause the loss of cache sql > tables? > > > > > > How do you get "instance of Ignite"? -> > > > > > > > > > > On Wed, Apr 26, 2023 at 2:40 PM Ilya Shishkov <shishkovi...@gmail.com> > wrote: > >> > >> Hi, > >> > >> > >>> After some days, I was unable to see the created cache on the Ignite > shell which I have created and was able to see at first when node started > properly. > >> > >> > >> What is Ignite shell? Sqlline? > >> > >> > >>> Now I am getting a table not found exception from API request for > fetching using ignite sql query. > >> > >> > >> It looks like all cluster nodes have failed or restarted. > >> > >> > >>> I am getting a null instance of ignite. I assume that I am unable to > connect to the live instance running on that node. > >> > >> > >> How do you get "instance of Ignite"? > >> > >> Have you deployed the nodes as described in these instructions [1-3]? > >> > >> > https://ignite.apache.org/docs/latest/installation/kubernetes/amazon-eks-deployment.html > >> > https://ignite.apache.org/docs/latest/installation/kubernetes/azure-deployment.html > >> > https://ignite.apache.org/docs/latest/installation/kubernetes/gke-deployment.html > >> > >> > >> > >> ср, 26 апр. 2023 г. в 09:42, Abhishek Ubhe <abhishekubhe0...@gmail.com > >: > >>> > >>> Hello Stephen, > >>> > >>> I did try changes you suggested above and I did get output. Thanks for > that. > >>> > >>> But I am facing a different issue in meantime on my microservice which > have following setup : > >>> > >>> I have set up a kubernetes pod cluster where I have started 3 ignite > nodes and deployed k8s pods using -java commands. > >>> In that routine after node started, I created the above CacheTable on > the node and loaded data from hbase into the cache.table. > >>> After some days, I was unable to see the created cache on the Ignite > shell which I have created and was able to see at first when node started > properly. > >>> Now I am getting a table not found exception from API request for > fetching using ignite sql query. > >>> And also I tried to recreate the same cache using a regular java API > script and run on that K8s pod where ignite is running > >>> I am getting a null instance of ignite. I assume that I am unable to > connect to the live instance running on that node. > >>> > >>> Please help me with this issue and suggest any things I need to do and > test out. > >>> > >>> On Thu, Apr 20, 2023 at 1:52 PM Stephen Darlington < > stephen.darling...@gridgain.com> wrote: > >>>> > >>>> In sqlline, you can type “!tables” (no quotes) to list all the > tables. In general, the schema is the cache name and the table is the value > type name, so you would need to write "select * from > CACHE_NAME.HbaseTableType". > >>>> > >>>> On 20 Apr 2023, at 06:38, Abhishek Ubhe <abhishekubhe0...@gmail.com> > wrote: > >>>> > >>>> Hello, > >>>> > >>>> I am facing the issue as below : > >>>> > >>>> I have created an ignite cache SQL table through java API. > >>>> Data loaded from HBase in the table after creating it.(loading means > just fetched and inserted in ignite). > >>>> Now when I was trying to fetch data from the sql table I created I am > getting Failed to parse query and table not found exception. > >>>> For more confirmation I connected to the ignite shell and checked the > list of tables. I get the above created table in the list. I can see it > exactly created there by the same name. > >>>> But when I fire my query on the table I get Error of failing to parse > the query and Table not found. > >>>> > >>>> I did not understand the above scenario. Please help me with this > issue. Please check out the attached screenshot for reference. > >>>> > >>>> > >>>> -- > >>>> Regards, > >>>> Abhishek Ubhe > >>>> > >>>> <Screenshot from 2023-04-19 18-50-23.png> > >>>> > >>>> > >>> > >>> > >>> -- > >>> Regards, > >>> Abhishek Ubhe > >>> > > > > > > -- > > Regards, > > Abhishek Ubhe > > > -- *Regards,* *Abhishek Ubhe*
