Re: Problem with writeBehind Apache Ignite 2.8.1

[manueltg89]

Ok, I will be aware to the new changes.

Thank you very much!



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

Re: Problem with writeBehind Apache Ignite 2.8.1

[Ilya Kasnacheev]

Hello!

I think there is indeed a problem with Cache Store here:
https://issues.apache.org/jira/browse/IGNITE-13167

I hope it will get fixed, until it isn't I recommend switching that cache
to ATOMIC mode, this will help sidestep the issue.

Regards,
-- 
Ilya Kasnacheev


пт, 19 июн. 2020 г. в 16:22, manueltg89 :

> You need to have MySQL Server with schema "bugdb.sql" imported, config your
> mysql database in "secret.properties", run "ServerNodeCodeStartup" and
> execute PHP file with inserts to Apache Ignite.
>
> Sorry, there was a problem to attach PHP file. I've attached also PHP file
> now.
>
> bug.php 
>
>
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Problem with writeBehind Apache Ignite 2.8.1

[manueltg89]

You need to have MySQL Server with schema "bugdb.sql" imported, config your
mysql database in "secret.properties", run "ServerNodeCodeStartup" and
execute PHP file with inserts to Apache Ignite. 

Sorry, there was a problem to attach PHP file. I've attached also PHP file
now.

bug.php   
 





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

Re: Problem with writeBehind Apache Ignite 2.8.1

[Ilya Kasnacheev]

Hello!

What do I need to run to observe the problem? I run ServerNodeCodeStartup
but it runs OK.

If there should be any images in your message, they're not there.

Regards,
-- 
Ilya Kasnacheev


пт, 19 июн. 2020 г. в 11:12, manueltg89 :

> Hi. I attach example project. I explain a bit more. Details:
>
> - MySQL Server with max connections form example: 151
> - Insert with PHP PDO from PHP 7.2:
>
>
>
> It seems that Apache Ignite with writeBehind enabled open one connection by
> insert and keeps open every connection over time, this  bug-project.rar
> 
>
> that MySQL Server throws "Too many connections" error.
>
> In attached file you have "bugdb.sql" file with database schema for MySQL.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Problem with writeBehind Apache Ignite 2.8.1

[manueltg89]

Hi. I attach example project. I explain a bit more. Details:

- MySQL Server with max connections form example: 151
- Insert with PHP PDO from PHP 7.2: 



It seems that Apache Ignite with writeBehind enabled open one connection by
insert and keeps open every connection over time, this  bug-project.rar
  
that MySQL Server throws "Too many connections" error.

In attached file you have "bugdb.sql" file with database schema for MySQL.



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

Re: Problem with writeBehind Apache Ignite 2.8.1

[akorensh]

Hi,
  This shouldn't be happening. Please attach  a reproducer and I'll take a
look.
   Describe the steps you take to reproduce scenario. Include version #'s
for all affected components.
Thanks, Alex




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

Problem with writeBehind Apache Ignite 2.8.1

[manueltg89]

Hello, I use Apache Ignite with MariaDB (RDBMS Integration), all works
properly except "writeBehind", if I activate "writeBehind" and I insert for
example 200 instances with PHP PDO I receive a exception on console of
Ignite, the exception is the following: 

jun 17, 2020 4:03:45 PM org.apache.ignite.logger.java.JavaLogger error
GRAVE: Failed to execute SQL query [reqId=0, req=OdbcQueryExecuteRequest
[schema=PUBLIC, sqlQry=INSERT INTO scrapy_brand(id, name, keyname) VALUES
(brandId(), ?, ?), autoCommit=true, timeout=0, args=Object[] [manuela4939,
manuela4939]]]
class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed
to execute DML statement [stmt=INSERT INTO scrapy_brand(id, name, keyname)
VALUES (brandId(), ?, ?), params=[manuela4939, manuela4939]]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeDml(IgniteH2Indexing.java:1247)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1144)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$3.applyx(GridQueryProcessor.java:2406)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$3.applyx(GridQueryProcessor.java:2402)
at
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2919)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.lambda$querySqlFields$1(GridQueryProcessor.java:2422)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuerySafe(GridQueryProcessor.java:2460)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2396)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2323)
at
org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.executeQuery(OdbcRequestHandler.java:403)
at
org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.doHandle(OdbcRequestHandler.java:233)
at
org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.handle(OdbcRequestHandler.java:196)
at
org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:195)
at
org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:49)
at
org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
at
org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
at
org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120)
at
org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: class
org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException:
Transaction has been rolled back:
a186692c271--0c27-0020--0001
at
org.apache.ignite.internal.processors.cache.GridCacheAdapter.syncOp(GridCacheAdapter.java:4365)
at
org.apache.ignite.internal.processors.cache.GridCacheAdapter.put0(GridCacheAdapter.java:2599)
at
org.apache.ignite.internal.processors.cache.GridCacheAdapter.put(GridCacheAdapter.java:2580)
at
org.apache.ignite.internal.processors.cache.GridCacheAdapter.putIfAbsent(GridCacheAdapter.java:3007)
at
org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.dmlDoInsert(DmlUtils.java:197)
at
org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.processSelectResult(DmlUtils.java:168)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdateNonTransactional(IgniteH2Indexing.java:2920)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdate(IgniteH2Indexing.java:2774)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeUpdateDistributed(IgniteH2Indexing.java:2704)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeDml(IgniteH2Indexing.java:1218)
... 22 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load
object [table=scrapybd.scrapy_brand, key=12689]
at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.loadFromStore(GridCacheStoreManagerAdapter.java:335)
at
org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.load