> 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 >
