che.org; alexey.scherbak...@gmail.com
> *Subject:* RE: Transactional Reader Writer Locks
>
>
>
> Hi,
>
> I need to understand when we mean LOCK, is this lock is acquired on entire
> Cache or on record we are trying to update .
> Please clarify .
>
>
>
> Regards,
>
> G
e
> transaction logic must protect against it. <=*”
>
>
>
> How would a tx logic look like that protects against partial transaction
> state in optimistic serializable mode?
>
>
>
> Jay
>
>
>
>
>
> *From:* Alexei Scherbakov
> *Sent:* Thursday, 16 De
ievable if there are multiple ways
> to implicitly acquire but none to release locks.
>
>
>
> Are we out of luck here or
>
> - did we miss something?
>
> - are there workarounds you know of?
>
> - are there plans to implement transactional re-entrant locks in future
> releases?
>
>
>
> Jay
>
>
>
>
>
--
Best regards,
Alexei Scherbakov
t; Thread 2: Commit *Optimistic exception is thrown here since current value
>> of key1 is not val1 anymore*
>>
>> When optimistic transactions are used, a user is expected to have a retry
>> logic. Alternatively, a pessimistic repeatable_read transaction can be used
>> (one should remember that in pessimistic mode locks are acquired on first
>> key access and released only on transaction commit).
>>
>> Hope this helps,
>> --AG
>>
>
--
Best regards,
Alexei Scherbakov
a-binary-object-to-two-caches-fails-with-FULL-SYNC-write-mode-configured-for-the-replicated-ce-tp6343p6366.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
t; at
>
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.put(GridDhtAtomicCache.java:452)
> at
>
> org.apache.ignite.internal.processors.cache.GridCacheAdapter.put(GridCacheAdapter.java:2180)
> at
>
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.put(IgniteCacheProxy.java:1165)
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Adding-a-binary-object-to-two-caches-fails-with-FULL-SYNC-write-mode-configured-for-the-replicated-ce-tp6343.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
elects-on-partitioned-caches-tp6344.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
nabble.com/Store-by-reference-tp6341.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
l
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
E = ?3)
>
> AND ((OBJID = ?1)
>
> AND (FIELDNUM = ?2))], [SELECT
>
> __C0 AS GUID
>
> FROM PUBLIC.__T0
>
> /* "com.huawei.soa.ignite.model.IgniteMetaIndex_Cache"."merge_scan"
> */]]
>
> ---
>
> r
html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
t map/reduce queries?
>
> Thanks,
>Cristi
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Count-distinct-not-working-tp6144.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
Thanks
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Handling-external-updates-to-persistence-store-tp6143.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
quot; explain select guid from IgniteMetaIndex where objid=?
> and fieldnum=? and stringvalue=? ";
>
> …
>
> fieldQry.setArgs( "a1162", 7 ,"18835473249");
>
>
>
> hope you can help me.
>
>
>
>
>
> Best regards,
>
> Kevin
>
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Error-while-loading-data-into-cache-with-BinaryObject-as-key-field-tp6014p6105.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
//apache-ignite-users.70518.x6.nabble.com/Iterating-through-a-BinaryObject-cache-fails-tp6038p6061.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
che-ignite-users.70518.x6.nabble.com/Error-while-loading-data-into-cache-with-BinaryObject-as-key-field-tp6014p6062.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
he elements of the cache is failing.
>
> What am I missing?
>
> Thanks
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Iterating-through-a-BinaryObject-cache-fails-tp6038.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
xt:
> http://apache-ignite-users.70518.x6.nabble.com/SQL-Query-on-REST-APIs-tp4815p5985.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Error-while-loading-data-into-cache-with-BinaryObject-as-key-field-tp6014p6019.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
cumentation on it.
>
> Thanks,
> Binti
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Ignite-work-directory-usage-tp5936.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
t; this.oId = oId;
>
> }
>
>
>
> public String getGid()
>
> {
>
> return gId;
>
> }
>
>
>
> public void setGuid(String gId)
>
> {
>
> this.gId = gId;
>
> }
>
>
>
> public int getFNum()
>
> {
>
> return fNum;
>
> }
>
>
>
> public void setFNum(int fNum)
>
> {
>
> this.fNum = fNum;
>
> }
>
>
>
> public String getMsg()
>
> {
>
> return msg;
>
> }
>
>
>
> public void setMsg(String msg)
>
> {
>
> this.msg = msg;
>
> }
>
>
>
> public BigDecimal getNum()
>
> {
>
> return num;
>
> }
>
>
>
> public void setNum(BigDecimal num)
>
> {
>
> this.num = num;
>
> }
>
>
>
> public Date getDate()
>
> {
>
> return date;
>
> }
>
>
>
> public void setDate(Date date)
>
> {
>
> this.date = date;
>
> }
>
>
>
> }
>
>
>
>
>
>
>
>
>
--
Best regards,
Alexei Scherbakov
Hi, Francesco.
Please properly subscribe to the user mailing list so community members can
see your questions
as soon as possible and provide answers on them quicker. All you need to do
is send an email to user-subscr...@ignite.apache.orgî and follow simple
instructions in the reply.
How many ent
gt; > of the second process by about 10 seconds, the second process will
> > almost never achieve any kind of consistent cache. This just does not
> > make any sense with a cache that is replicated ?!?
> >
> > Kristian
> >
> >
> > 2016-06-21 9:28 GMT+02:
manually copy ignite-examples.jar to
> the tomcat lib folder.
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/schema-import-example-ClassNotFoundException-org-apache-ignite-schema-H2DataSourceFactory-tp5629p5741.html
> Sent from the
Hi,
Please properly subscribe to the user list. All you need to do is send an
email to ì
user-subscr...@ignite.apache.orgî and follow simple instructions in the
reply.
Unfortunately, DDL is not currently supported by Ignite, but may appear in
next releases.
Probably someone on dev list knows mor
operation.
>
> Thanks,
>
> Mrinal
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Multiple-column-filtering-and-sorting-in-Apache-Ignite-tp5783p5788.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
; http://apache-ignite-users.70518.x6.nabble.com/Multiple-column-filtering-and-sorting-in-Apache-Ignite-tp5783.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
t; the cache?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/SqlQuery-and-removing-evict-items-from-the-cache-tp5754.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
rect? And H2 is not used for
> ScanQuery, as it is not SqlQuery, correct?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Behind-cache-ScanQuery-tp5753.html
> Sent from the Apache Ignite Users mailing list archive at Nabble
t;
> What is supposed to be the best approach to implement that.
>
>
> Thanks,
> Paolo
>
>
> On Wed, Jun 15, 2016 at 6:13 PM, Alexei Scherbakov <
> alexey.scherbak...@gmail.com> wrote:
>
>> Your understanding is correct.
>>
>> How many nodes do yo
Hi,
You should not rely on cache.size method for checking data consistency.
cache.size skips keys which is not currently loaded by read-through
behavior.
2016-06-18 15:14 GMT+03:00 Kristian Rosenvold :
> 2016-06-18 13:02 GMT+02:00 Alexei Scherbakov >:
> > You should be safe calli
rtial replication. How can I make loadCache
> happen during getOrCreateCache to ensure atomic startup/loading of the
> cache ?
>
> Kristian
>
--
Best regards,
Alexei Scherbakov
http://apache-ignite-users.70518.x6.nabble.com/schema-import-example-ClassNotFoundException-org-apache-ignite-schema-H2DataSourceFactory-tp5629p5705.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
u enable Classloading properly?
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/schema-import-example-ClassNotFoundException-org-apache-ignite-schema-H2DataSourceFactory-tp5629.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
n. Si usted ha recibido este mensaje
> por error, por favor notifique inmediatamente al 1(809) 330-4184 o envíe
> un correo electrónico a nuestra dirección: eduardo...@bontix.com
> al remitente y borre este mensaje y sus anexos. Como
> correos electrónicos pueden ser alterado, Bontix no se hace responsable de
> los mensajes que se han modificado, cambiado o falsificados. Gracias
>
>
--
Best regards,
Alexei Scherbakov
e/ignite/examples/JavaIgniteSimpleApp.java
>>
>>
>>
>> Cheers, p
>>
>>
>> On Wed, Jun 15, 2016 at 5:00 PM, Alexei Scherbakov <
>> alexey.scherbak...@gmail.com> wrote:
>>
>>> I don't think it's OK.
>>>
>>
ache/ignite/examples/JavaIgniteSimpleApp.java
>
>
>
> Cheers, p
>
>
> On Wed, Jun 15, 2016 at 5:00 PM, Alexei Scherbakov <
> alexey.scherbak...@gmail.com> wrote:
>
>> I don't think it's OK.
>>
>> Which Ingite's version do you use?
>&g
m/y0EM7qXU>). Is this normal? and
> in any case is there a way to avoid it?
>
>
> Cheers,
> Paolo
>
>
>
> On Wed, Jun 15, 2016 at 1:25 PM, Alexei Scherbakov <
> alexey.scherbak...@gmail.com> wrote:
>
>> Hi,
>>
>> To automatically start Ig
e are not ignite daemons to which connect to. Also
> inspecting the Spark worker log I'm unable to find any message produced by
> Ignite. I'm expecting instead to find the log messages produced by the
> ignite daemon startup.
>
>
> Any idea what's wrong?
>
>
> Cheers,
> Paolo
>
>
--
Best regards,
Alexei Scherbakov
out)
>
> Unfortunately it is no way.
> How can i get igniteCache data with timeout?
>
> Best Wishes.
> Thanks.
>
--
Best regards,
Alexei Scherbakov
; Thanks.
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Simulating-Graph-Dependencies-With-Ignite-tp5282p5572.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
; http://apache-ignite-users.70518.x6.nabble.com/Simulating-Graph-Dependencies-With-Ignite-tp5282p5538.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ME + "\".Table t ");
>
>
> Thanks,
> Rupinder Virk
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Select-count-returns-incorrect-records-for-distributed-cache-tp5546.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
-07 15:21 GMT+03:00 M Singh :
> Yes Alexie, I should have mentioned that (my bad).
>
>
> On Tuesday, June 7, 2016 5:17 AM, Alexei Scherbakov <
> alexey.scherbak...@gmail.com> wrote:
>
>
> Hi,
>
> Do you mean Ignite's Event delivery described here [1] ?
&g
27;s previous
> queue ?
> 4. If #3 is true, then during the time slow client is disconnected, is
> it's queue still gathering events while the client is trying to reconnect ?
>
> Thanks
>
--
Best regards,
Alexei Scherbakov
o do the puts.
>
> The other way round, makes the application 80% slower?
>
> Why is this so?
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Ignite-faster-with-startup-order-tp5459.html
> Sent from the Apache Ignit
vide your inputs on the affinity code?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Simulating-Graph-Dependencies-With-Ignite-tp5282p5478.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
;
>
>
> How should I fix this? Is there a callback I can implement when a node
> leaves a cluster that I can use to create a new JWT token and attach to it?
>
>
>
> Any guidance would be appreciated.
>
>
>
> --
>
> anand
>
--
Best regards,
Alexei Scherbakov
ve-To-IN-clause-tp5448p5473.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
native for the problem described above?
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Running-an-infinite-job-use-case-inside-or-alternatives-tp5430.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
p4726p5398.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
gt; at
>
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.bindObject(IgniteH2Indexing.java:502)
> ... 45 more
>
> What could be missing?
>
> Thanks.
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Self-Join-Query-As-An-Alternative-To-IN-clause-tp5448.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ollowed-by-error-tp4726p5368.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ys before executing the custom code.
>
> Thanks.
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Simulating-Graph-Dependencies-With-Ignite-tp5282p5378.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ted, and may be unlawful.If you have received this
> communication in error,please
> immediately notify the sender by return e-mail, and delete the original
> message and all copies from
> your system. Thank you.
>
> -------
>
--
Best regards,
Alexei Scherbakov
y let me know your suggestions.
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Simulating-Graph-Dependencies-With-Ignite-tp5282p5369.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ork well in my environment.
>
> What do you think ?
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/listening-for-events-on-transactions-tp5346p5357.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
AND ((ACTIVITY0.KERNEL_ID IS NULL)
> AND (ACTIVITY0.REALIZATION_ID IS NULL)))
> AND ((ACTIVITYHISTORYUSERACCOUNT0.USERACCOUNT_ID = 600301)
> OR ((ACTIVITYUSERACCOUNTROLE0.USERACCOUNTROLE_ID IN(1, 3))
> AND ((ACTIVITY0.REMOVEFROMWORKLIST = 0)
> OR (ACTIVITYHISTORYUSERACCOUNT0.USERACCOUNT_ID IS NULL/
>
> Hmm so yeah looks like we are seeing strange numbers in the explain, even
> though the starting data and queries are the same.
>
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5355.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
hey were the
> correct way to listen for transaction.commits.
>
> Continuous queries appear to offer event capability, but it isn't clear how
> they work with transactions.
>
> Thanks for the clarifications/help on how to do transaction listeners.
>
>
>
>
> --
>
70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5338.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
nage the cache?How can I backed
> up data to other topology node?Where can I find an example?
>
>
> Thanks
>
> 2016-05-30 22:28 GMT+08:00 Alexei Scherbakov >:
>
>> Hi,
>>
>> 1. You can destroy cache (IgniteCache.destroy) and recreate it
>> dynamically
try your work around.
>
> Many thanks for your replies, it is really helpful.
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Affinity-Key-Mapping-tp5212p5327.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
U.warn(log, "Custom H2 serialization is already configured, will
> override.");
>
> Utils.serializer = h2Serializer();
> Is there any way to solve it? I am looking forward to your replay.Thank
> you.
--
Best regards,
Alexei Scherbakov
p5321.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
nal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:501)
> at
>
> org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:184)
> at
>
> org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1065)
> at
>
> org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:572)
> ... 11 more
> /
>
> Not sure you need to spend time in this though, for me the UNION path is
> not
> feasible anyhow but in case you like to go deeper on these errors in terms
> of the product I'll be happy to run additional tests.
>
> br
> jan
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5311.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
en update all
> the Ignite config and restart all the Ignite Server.
>
>
> I don't know why I must kill all the Ignite client so I can restart the
> Ignite server correctly.
>
>
>
>
>
>
>
>
>
--
Best regards,
Alexei Scherbakov
/>
>
>
>
>
>
>
>
>
>
> class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi">
>
>
>
>
>
> class="org.apache.ignite.spi.discovery.tcp.ipfinder.vm.TcpDiscoveryVmIpFinder">
>
>
>
>
> 10.0.1.2:47500..47509
>
> 10.0.1.3:47500..47509
>
>
>
>
>
>
>
>
>
> --
> scsi
>
--
Best regards,
Alexei Scherbakov
How much time does it take to iterate all results for that query ?
My test shows it take about 9 seconds to fully iterate result set on warmed
up cache.
Is this OK for you?
Considering initial complex query optimization, as I already told it should
be split to 3 sub-queries to avoid OR conditions
ache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
fficiently?
>
> 3. How can I take the advantage of co-located processing with Ignite?
> Assuming that the subsequent table to be updated is on the same node as the
> previous it would be a good optimization to ship the update query on that
> node.
>
> Thank you,
> Amit.
Of course you can store result of recalculation in the temp variable if
it's needed for next recalculation.
2016-05-27 18:34 GMT+03:00 Alexei Scherbakov :
> Hi,
>
> You can store cell dependencies as Ignite's data grid of
>
> IgniteCache cells = ...
>
> where re
ata.
>
> I would appreciate to get inputs on this.
>
> Thanks,
> Amit
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Simulating-Graph-Dependencies-With-Ignite-tp5282.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ines the fields ... and not the indexes we add from
> annotations - is this potentially clashing?
>
> best regards
> jan
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5281.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
in the H2 console that
> the indexes are there as expected?
>
> br
> jan
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5279.html
> Sent from the Apac
mizedMarshaller purely from
> performance standpoints
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/MArshaller-question-tp5273.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
Y_ID = ACTIVITYUSERACCOUNTROLE0.ACTIVITY_ID/
>
> So looks like the LEFT OUTER is the culprit, or at least one of them.
>
> br
> jan
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5267.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ssage in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5240.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ng GC pauses.
[1] https://apacheignite.readme.io/docs/jvm-and-system-tuning
2016-05-26 19:40 GMT+03:00 Tomek W :
> Ok, I will try it. However, Why OFF_HEAP_TIERED ? It seem to be not fast
> as ON HEAP
>
> 2016-05-26 18:32 GMT+02:00 Alexei Scherbakov >:
>
>> We are
this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Connect-H2-Console-to-a-running-cluster-tp5242.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
comes to JDBC client, I did show fragment of code in previous post.
>
> 2016-05-26 16:15 GMT+02:00 Alexei Scherbakov >:
>
>> I see long pauses in your GC log (> 3 seconds)
>> This means your app have high pressure on the heap.
>> It's hard to tell wh
Ok,
> i am going to add new machines to ignite cluster. Firstly, please look at
> my gc file log - previous message.
>
> 2016-05-26 13:39 GMT+02:00 Alexei Scherbakov >:
>
>> Hi,
>>
>> The initial question was about setSqlOnheapRowCacheSize and I think
>>
in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5194.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
^-- Disable grid events (remove 'includeEventTypes' from
> configuration)
> [01:03:02] ^-- Enable ATOMIC mode if not using transactions (set
> 'atomicityMode' to ATOMIC)
> [01:03:02] ^-- Enable write-behind to persistent store (set
> 'writeBehindEnabled' to t
> What code do you mean ? JDBC client ?
>
> 2016-05-25 10:25 GMT+02:00 Alexei Scherbakov >:
>
>> What's the batch size for postgresql ?
>> What's the size of one entry ?
>> Could you provide the test code for both postgres and Ignite (just the
>> qu
rialized BinaryObject format, as its a lot core compact.
>
> Thanks again.
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Working-Directly-with-Binary-objects-tp5131p5152.html
> Sent from the Apache Ignite Users mailing lis
s?
> 3000 000
>
> | Do the both queries involve network I/O ?
> No, I have only local one server (for testing purpose).
>
>
> 2016-05-25 9:59 GMT+02:00 Alexei Scherbakov
> :
>
>> SELECT * is not really a good test query.
>> It's result can be affected n
ient. In ignite and postgresql I have single
> index on column A.
>
> Ignite: SELECT * FROM table WHERE A > 1345 takes 6s.
> Postgres: SELECT * FROM table WHERE A > 1345 takes 4s.
>
> As you can see, postgres is still bettter than Ignite. I show you
> significant fra
>
> class="org.apache.ignite.configuration.CacheConfiguration">
>
>
>
>
>
>
>
>
> 2016-05-24 15:22 GMT+02:00 Alexei Scherbakov >:
>
creased it.
> How to measure it ? Why client requires so much memory ?
>
> 2016-05-24 14:28 GMT+02:00 Alexei Scherbakov >:
>
>> Just use this:
>>
>> -server -Xms10G -Xmx10G -XX:+UseParNewGC -XX:+UseConcMarkSweepGC
>> -XX:+UseTLAB -XX:NewSize=128m -XX:MaxNewSiz
it to me.
[1] https://apacheignite.readme.io/docs/sql-queries#using-h2-debug-console
2016-05-23 16:36 GMT+03:00 Alexei Scherbakov :
> Hi,
>
> In current state of SQL engine where is a very high probability for
> necessity of query modification for efficient use with Ignite.
> I
).
> Now client also requires ~4GB data. Why ? After all, it doesn't keep
> data, only run hot loading.
>
>
>
>
>
> 2016-05-24 13:44 GMT+02:00 Alexei Scherbakov >:
>
>> Try to start with some larger number, if default value is too low for
>> you.
&g
s.70518.x6.nabble.com/Working-Directly-with-Binary-objects-tp5131.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
about 10 GB. (My ram is 16GB).
> Can you help me adjust configuration for this aim ?
> It is very important for me.
> Aim: Extremely fast sql quries.
>
>
> 2016-05-23 18:13 GMT+02:00 Alexei Scherbakov >:
>
>> Hi,
>>
>> Generally speaking, settings setSqlOn
dexes-setSqlOnheapRowCacheSize-how-does-it-improve-efficiency-tp5070p5092.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ce-issue-with-SQL-query-followed-by-error-tp4726p4993.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
the cache data?
> According to "initialized ", "used", "committed" or "maximum"?
> 2. Why memory used looks same in different replications?
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Problem-about-cache-data-size-tp5016.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
ary.BinaryMarshaller.unmarshal(BinaryMarshaller.java:112)
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.deserialize(IgniteH2Indexing.java:1491)
> at org.h2.util.Utils.deserialize(Utils.java:392)
>
> If value > 182 is taken out of the query, it runs fine.
>
> Ignite does not appear to know how to deserialize an "Object" field correctly
> to perform a comparison in SQL.
> What is the recommended Ignite way to store Object types like this and be
> able to compare/query them
> in Ignite SQL ? I do not know ahead of time if something will be a Long or
> Integer or String, etc.
>
> Thank you,
>
>
--
Best regards,
Alexei Scherbakov
ObjectQuery.java
Description: Binary data
ParamsComparator.java
Description: Binary data
ot;);
> gIdx.setFieldNames(gFields, true);/
>
>
> Could it be that the field aliases I use are causing this? Or something
> else
> I am missing?
>
> tx
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p4846.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
--
Best regards,
Alexei Scherbakov
1 - 100 of 130 matches
Mail list logo