Hello:
This is really strange.
I am testing Sequoia from code that uses jpox (www.jpox.org).
When I tell the jpox to create a simple schema, I get
this warning in my full cluster log:
23:05:14,612 WARN backend.DatabaseBackend.cbsweb1 Unable to
find table `deleteme1168578314462` in database schema, scheduling
query DROP TABLE `DELETEME1168578314462` in conflicting queue.
As you can see, the SQL being passed to Sequioa is in uppercase
letters, why would Sequoia be looking for the same table name
in lowercase letters?
I enabled the distributed request log and everything is uppercase
as I expected:
23:05:14,536 cbsweb W 562949953421325 0 CREATE TABLE
`DELETEME1168578314462`
(
`UNUSED` INTEGER NOT NULL
) ENGINE=INNODB
23:05:14,612 cbsweb W 562949953421326 0 DROP TABLE
`DELETEME1168578314462`
23:05:14,900 cbsweb W 562949953421327 562949953421327 CREATE TABLE
`PRODUCT`
(
`SKU` VARCHAR(255) BINARY NOT NULL,
PRIMARY KEY (`SKU`)
) ENGINE=INNODB
23:05:15,066 cbsweb Commit transaction 562949953421327
It also looks like the transaction commited. I checked the backend
database and there is a PRODUCT table and no DELETEME table.
When I ask jpox to delete the schema, I get this in the cluster log:
23:10:50,773 WARN backend.DatabaseBackend.cbsweb1 Unable to find table
`deleteme1168578650627` in database schema, scheduling query
DROP TABLE `DELETEME1168578650627` in conflicting queue.
23:10:51,179 WARN backend.DatabaseBackend.cbsweb1 Unable to find table
`product` in database schema, scheduling query DROP TABLE `PRODUCT`
in conflicting queue.
Looking at the distributed request log, I see:
23:10:50,698 cbsweb W 562949953421328 0 CREATE TABLE `DELETEME1168578650627`
(
`UNUSED` INTEGER NOT NULL
) ENGINE=INNODB
23:10:50,773 cbsweb W 562949953421329 0 DROP TABLE `DELETEME1168578650627`
23:10:51,178 cbsweb W 562949953421330 562949953421330 DROP TABLE `PRODUCT`
23:10:51,250 cbsweb Commit transaction 562949953421330
Again, it looks like the transaction committed, when I check the backend
database, the product table is no longer there.
This is much more than a problem of getting incorrect warnings.
If I run a test application, it runs just fine for some time, but after
a while, I begin to get errors that there is not product table.
Any ideas?
Thanks,
Neil
--
Neil Aggarwal, (214)986-3533, www.JAMMConsulting.com
FREE! Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
