Hi all,
I've set up a single node cluster using the docker image from the web
console.
I've set the correct property values in secret properties, and see that
Ignite has the table metadata that I've imported from MySQL in the queries
sidebar.
I understand that I need to have data pre-loaded in order to run SQL SELECT
queries - that makes sense. But I wanted to make sure the write-through
works, so I typed in an INSERT query. I got the following error:
[IgniteSQLException] Failed to execute DML statement [stmt=insert into
"ProductsCache".Products (id, company_id) VALUES (1234, 5258), params=null]
[CachePartialUpdateCheckedException] Failed to update keys (retry
update if possible).: [com.exposebox.model.ProductsKey [idHash=1025007579,
hash=-1839834713, id=1234, companyId=5258]]
[IgniteCheckedException] Failed to update keys.
[IgniteCheckedException] Runtime failure on search row:
org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89
[IgniteCheckedException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[CacheWriterException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[SQLException] Connections could not be acquired from the underlying
database!
[CannotAcquireResourceException] A ResourcePool could not acquire a
resource from its primary factory or source.
[SQLException] No suitable driver
[IgniteCheckedException] Runtime failure on search row:
org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89
[IgniteCheckedException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[CacheWriterException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[SQLException] Connections could not be acquired from the underlying
database!
[CannotAcquireResourceException] A ResourcePool could not acquire a
resource from its primary factory or source.
[SQLException] No suitable driver
[IgniteCheckedException] Failed to update keys.
[IgniteCheckedException] Runtime failure on search row:
org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89
[IgniteCheckedException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[CacheWriterException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[SQLException] Connections could not be acquired from the underlying
database!
[CannotAcquireResourceException] A ResourcePool could not acquire a
resource from its primary factory or source.
[SQLException] No suitable driver
[IgniteCheckedException] Runtime failure on search row:
org.apache.ignite.internal.processors.cache.tree.SearchRow@75771c89
[IgniteCheckedException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[CacheWriterException] Failed to write entry to database
[table=production_v2.products, entry=Entry
[key=com.exposebox.model.ProductsKey [idHash=1025007579, hash=-1839834713,
id=1234, companyId=5258], val=com.exposebox.model.Products
[idHash=494073819, hash=1]]]
[SQLException] Connections could not be acquired from the underlying
database!
[CannotAcquireResourceException] A ResourcePool could not acquire a
resource from its primary factory or source.
[SQLException] No suitable driver
As far as I can tell, it boils down to simply having the MySQL JDBC driver
not available. I've tried putting the JAR in the jdbc_drivers folder in the
docker folder - still doesn't work. I'll try adding it manually to the
pom.xml file, but I don't think that's how it's supposed to work.
Did anyone else manage to integrate MySQL automatically with Ignite via
web-console?
Thanks,
--
--
*Orel Weinstock*
Software Engineer
Email: [email protected] <[email protected]>
Website: www.exposebox.com
