Re: EPOCH seconds in future!

Hi Ilya, thnx for replay, I think that Ignite CURRENT_TIMESTAMP() is NOT TIMESTAMP WITH TIME ZONE. Below it test with inserting CURRENT_TIMESTAMP in two tables, one with data type TIMESTAMP and second with TIMESTAMP WITH TIME ZONE. First of all, in Ignite documentation I can't find that CURRENT

Re: EPOCH seconds in future!

Hi Ilya, thanks a lot for the reply, it is surprising that EPOCH is not always the same regardless of the timezone. I did a test on two Ignite instances, one on a host with timezone 'Europe / Zagreb' and the other on UTC. The EPOCH obtained in bash is the same on both hosts and the EPOCH obtai

EPOCH seconds in future!

Hi, Ignite function EXTRACT (EPOCH from CURRENT_TIMESTAMP(3)) return seconds in future!!! Current date and time on UNIX host, I am in Zagreb/Croatia CEST GMT+2 [root@incumbossdev01 ~]# date Fri Apr 17 10:51:10 CEST 2020 Connected to: Apache Ignite (version 2.7.6#20190911-sha1:21f7ca41) Drive

EPOCH to timestamp

Hi, is there a function with which timestamp can be obtained from epoch. example select EXTRACT (EPOCH from CURRENT_TIMESTAMP(3)); +--+ | EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(3)) | +--+ | 1587113983.052

Re: Python - Ignite 2.8.0 - java.lang.NullPointerException

Hi Evgenii, yesterday and in several previous days i was doing some testing on Ignite 2.8.0. Yesterday i did a fresh install (rm $ IGNITE_HOME/work) on test instance and now on a freshly started instance I can't reproduce the problem. For now, we can close the case, if I succeed to reproduce the pr

RE: Re: Ignite 2.8.0. Heap mem issue

Hi, in attachment is code for heap mem issue simulation. Ignite_2.zip # create cache TEST and insert random data into cache TEST test_insert_in_cache.py # read data from cache TEST and inset/update data in table TEST_TABL

Re: Python - Ignite 2.8.0 - java.lang.NullPointerException

I have one small error in py code, please remove last "," from UPDATE statement in test_insert_update.py SQL_UPDATE =''' UPDATE TEST SET COL1 = ?, COL2 = ?, COL3 = ?,

Re: Ignite 2.8.0. Heap mem issue

Hi Alex, i did another test and collected all the logs, GC logs, Heap mem dump, fiew screenshots. All files are in zip file. File is to big for upload, please download from Jumbo mail link. https://jumboiskon.tportal.hr/download/eeab9848-2494-4ab7-a2cb-88766db0fafa Thanks, Dren -- Sent from

Re: Ignite 2.8.0. Heap mem issue

Hi Evgeny, I can share pseudo code, not all developed code and python modules. Syslog messages are inseted into cache via Flume. Python daemons process messages ( read from CACHE ) and make insert/update/delete in fiew Ignite tables via SQL. Number of syslog messages and python code is same on pr

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

I think that username must be in single quote without \ igniteClient.query(new SqlFieldsQuery(" ALTER USER 'ignite' WITH PASSWORD 'password' ")); -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: HOW TO CHANGE IGNITE JAVA THIN CLIENT PASSWORD

try with ALTER USER 'ignite' WITH PASSWORD 'test' -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite 2.8.0. Heap mem issue

Hello, I recently installed Ignite 2.8.0 on one node for test pourpose and noticed Heap mem issue that I didn't have on 2.7.6. The Ignite configuration of dataStorageConfiguration / DataRegionConfiguration is identical. In production I have two nodes (2.7.6) and for test purpose (2.8.0) only one n