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

2020-03-24 Thread dbutkovic
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 problem again
I will reopen post.

Best regards

Dren



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/


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

2020-03-23 Thread Evgenii Zhuravlev
Hi,

I'm running this reproducer and I don't see any issues. Do you use pyignite
from the same version? Can you please share the full log file, maybe we're
missing something?

Thanks,
Evgenii

пт, 20 мар. 2020 г. в 08:11, dbutkovic :

> 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 = ?,
> COL4 = ?,
> COL5 = ?,
> COL6 = ?,
> COL7 = ?,
> COL8 = ?,
> COL9 = ?,
> COL10= ?,
> COL11= ?,
> COL12= ?
> WHERE ID = ?
> '''
>
> regardless of this sintax error, insert on Ignite 2.8.0 is not ok.
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>


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

2020-03-20 Thread dbutkovic
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 = ?,
COL4 = ?,
COL5 = ?,
COL6 = ?,
COL7 = ?,
COL8 = ?,
COL9 = ?,
COL10= ?,
COL11= ?,
COL12= ?
WHERE ID = ? 
''' 

regardless of this sintax error, insert on Ignite 2.8.0 is not ok.




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/


Python - Ignite 2.8.0 - java.lang.NullPointerException

2020-03-20 Thread Dren Butković
Hi,

random string insert/update test fails from time to time.
Tested with python 3.6 , pyignite and Ignite 2.8.0
On Ignite 2.7.6 work fine.
All logs and examples and py code for test in attachment.

Best regards
Dren



[dbutkovic@incumbosstest06 python]$ python3.6 test_insert_update.py
Connected to 192.168.50.106:10800
cnushrffacaexsruvuvkcpukrmqlqmyksafgagejdcdmzvrqsqacmlxsqrrzhfprkliafsyoodvxgfgoarbxeguzuwrgubhhgjv
INSERT
Connected to 192.168.50.106:10800
uebrapqingtsvbacfsvqdgrzthqdjmzqpevfcdqfrcxrhtxicwzvvjrluexmclyxyfnxswrmpdxgbuqacjetfrtsmivkbpzmcqz
INSERT
Connected to 192.168.50.106:10800
nkkrsplvfvnpaxcgrgdeuqxhxgbfdfuxzwqprzlyzuwngctlzeqrnazinkogoaqcrahnulgapwnnjldafhiyedpyhtexhbfymhn
INSERT
Connected to 192.168.50.106:10800
btqdzyqnexuvdglmopoiedjvxsnpspcsutvbicxaolxfuomksmvjtkyitzyfzllzukcukypttjzqqwvczglpxrstvruwpouempn
INSERT
Connected to 192.168.50.106:10800
eaujimzxedqdvakrdgjgwfkbkwaqtuflveblqcdrjvcgjibokswjxctrqsfkzvypditebwzwpzoxxtlaefxixegobixnguriotj
INSERT
Connected to 192.168.50.106:10800
zwtujlpgubnxsympstgensowrgglslbiplwmktbhoynvthcuwgwozidrikubqbsdjcfopcjqephutewyvlxjkpwwaakqwhfygqu
INSERT
Connected to 192.168.50.106:10800
ahvgtavnwukpjwgnjhwvuujfhkqzczyjaktlychridnaegkaxeffyanaxwsbvzwwocmgpxzstdwotmjurgxaenrnignvmavknxs
INSERT
Connected to 192.168.50.106:10800
xfmgaogjveltcbkbwsrlxpkbbphgfmswtrlmsnajwwjersxmebznobzdhkkenvawadwecpmvtuioppshstmuzehjlhfthlzypfw
INSERT
Connected to 192.168.50.106:10800
repofvdfjuuggzpwehidzgqorwweckiymzshikctkpzlybtswuwnazvmpcjxygjvxlmtyivmhgofpbeyiezkmnfxybikidwoqag
INSERT
Connected to 192.168.50.106:10800
stwsykcntmtmopxlywhhhlyklrletofkafedrwjdrgmndfsoxlkehjnlcpegylbtcnuyazhszoupkmezsnfiqlfaivhfpgjbnsl
INSERT
Connected to 192.168.50.106:10800
gkkufqbtaefbqrosfxfnfvpiucgqmipccfatrtajohrbqktjwmsxcnpykshjxftgowvwkcukbgrbamndrscrqkawkpcrwbqxvvx
INSERT
Connected to 192.168.50.106:10800
vbxjukcezwmhpjcpxlvyknmwoyxwdnvjgnpyqquxlfzlcwkefebrhomwrdhivzctktlrckktbhdvyhexswemmckbzrygzfbzllp
INSERT
Connected to 192.168.50.106:10800
dvjkqcxovijkdaftrerlwtjoxjviklpdhfrhbqqopdegarlgojvpsenepkprsbdcaiuowkihcexgyvoorkjrmiicobrkkuwrmhb
INSERT
Connected to 192.168.50.106:10800
rgsxplyhgbjhbzgkvsytcefwfdsknfnuavtanoqyfupmendojvunmnnorvqseipxdnbrhspomokkmgskzlpvmkhxvlwnhylxcnc
INSERT
Connected to 192.168.50.106:10800
pteybympxpmfsvkrzxsksmkszjybijwtghazafelueceevyaogavrklwoonuzugeamqgquweooygveiujejxagyilmghwdhdvpv
Traceback (most recent call last):
  File "test_insert_update.py", line 48, in 
result_EXIST = ignite_client.sql(query_str='SELECT COUNT(*) FROM TEST WHERE 
ID = ?', query_args=[i])
  File "/usr/local/lib/python3.6/site-packages/pyignite/client.py", line 404, 
in sql
raise SQLError(result.message)
pyignite.exceptions.SQLError: Failed to execute SQL query. General error: 
"java.lang.NullPointerException" [5-197]



[dbutkovic@incumbosstest06 python]$ python3.6 test_insert_update.py
Connected to 192.168.50.106:10800
nwkibmrhhbdgkgnaymzeyfbmeifbivxkzsdfvriwvmdtkgisfmgecilqxflkkqzztpviouslxunwxnygihlijopysupfkblghus
INSERT
Connected to 192.168.50.106:10800
digaffeohkpwnrscfqozxyvumvvjtzouiracvrnicdawwqqvtnzpjmjnabaygefxrcmpughveybmsfcexkunqxgubspfjijparv
INSERT
Connected to 192.168.50.106:10800
fwxjatjrtwydyqelxfewsabzknfckdboyswymskjsljptcwuqcltxeyybsppvvvtfhvbpcnckmpcythzvtdonuzjlrrvapnycpr
INSERT
Connected to 192.168.50.106:10800
labicsolxbrzumtatjihufwiucnkgjdrhwdqlpcwqoppntgdmfpibnsdxgihejmhguzckyowqqsielzkrkazkfrvxymydrdzpdk
INSERT
Connected to 192.168.50.106:10800
shndfldkqpqnltncyiflwgvpimaesotpphjtugyvfwdverjwsvjleswdfrkvpjotrtooxalbdubtiredyihjkpfartnjlwqunkw
INSERT
Connected to 192.168.50.106:10800
gdtrdsrdplzbrcnaeekwcapeukjdxonnfmivtfrnpfhsqkpgyxykqqsfempnxxleivhadqnchuzpkpoabreczxlnrroeqodtfds
INSERT
Connected to 192.168.50.106:10800
zovdjlqqenqouhggingtmumoqjqrwnrtpgfpuvdqtacmobnzcjdudgwkkhjghgkyumdvzlikkirgkcxbvotnfirnozygvkqchsk
Traceback (most recent call last):
  File "test_insert_update.py", line 48, in 
result_EXIST = ignite_client.sql(query_str='SELECT COUNT(*) FROM TEST WHERE 
ID = ?', query_args=[i])
  File "/usr/local/lib/python3.6/site-packages/pyignite/client.py", line 404, 
in sql
raise SQLError(result.message)
pyignite.exceptions.SQLError: Failed to execute SQL query. General error: 
"java.lang.NullPointerException" [5-197]
[dbutkovic@incumbosstest06 python]$
[dbutkovic@incumbosstest06 python]$





[15:38:03,379][SEVERE][client-connector-#67%UMBOSS%][ClientListenerNioListener] 
Failed to process client request 
[req=o.a.i.i.processors.platform.client.cache.ClientCacheSqlFieldsQueryRequest@291c5f1]
class org.apache.ignite.IgniteException: Failed to execute SQL query. General 
error: "java.lang.NullPointerException" [5-197]
at 
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.lambda$executeSelect0$1(IgniteH2Indexing.java:1414)
at 
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iter(QueryCursorImpl.java:106)
at 
org.apache.ignite.internal.processors.cache