Hello Sequoia People!
After some tracing I now got an idea what goes wrong with PHPMyAdmin
debian 4:2.9.0.3
and Sequoia.
The error: After login into phpmyadmin the following error pops up:
**
|#2000 - Unable to clone the parsing of an unknown request
Corresponding Log of sequoia:
ctrl1:~# 01:20:32,144 WARN controller.RequestManager.myDB Exception
while executing distributed read stored procedure (Unable to clone the
parsing of an unknown request).
java.lang.RuntimeException: Unable to clone the parsing of an unknown
request
at
org.continuent.sequoia.controller.requests.UnknownWriteRequest.cloneParsing(UnknownWriteRequest.java:190)
at
org.continuent.sequoia.controller.cache.parsing.ParsingCache.getParsingFromCacheAndParseIfMissing(ParsingCache.java:198)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:371)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:810)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1464)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecute.executeScheduledRequest(DistributedStatementExecute.java:88)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99)
01:20:32,149 WARN controller.virtualdatabase.myDB Distributed request
SET collation_connection = 'utf8_unicode... did not remove itself from
the total order queue
01:20:32,216 WARN controller.RequestManager.myDB Request 3 failed on
controller Member(address=/10.2.0.16:51375, uid=10.2.0.16:51375)
(java.sql.SQLException: Unable to clone the parsing of an unknown request)
01:20:32,228 WARN controller.RequestManager.myDB Request SET
collation_connection = 'utf8_unicode... failed (Unable to clone the
parsing of an unknown request)
01:20:32,228 WARN controller.virtualdatabase.myDB Stored procedure 3
failed (Unable to clone the parsing of an unknown request)
|
Trace of an phpmyadmin session directly to a DB-backend bypassing sequoia:
1656 Connect [EMAIL PROTECTED] on
1656 Query SELECT VERSION()
1656 Query SET NAMES utf8
1656 Query SET collation_connection =
'utf8_unicode_ci'
After replaying this SQL-trace from python (same error) I tried it from
to sequoia console with interesting results:
dbc:sequoia://localhost/myDB (user) > ctrl1:/usr/local/lib/sequoia#
./bin/console.sh
Launching the Sequoia controller console
Initializing Controller module...
Initializing VirtualDatabase Administration module...
Initializing SQL Console module...
Sequoia driver (Sequoia core v3.0-beta1) successfully loaded.
localhost:1090 > sql client jdbc:sequoia://localhost/myDB
Login > user
Password >
jdbc:sequoia://localhost/myDB (user) > SET NAMES utf8
Affected rows: 0
Query executed in 1 s 216 ms .
jdbc:sequoia://localhost/myDB (user) > SET NAMES utf8
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unable to clone the parsing of an unknown request)
After switching the connection to utf8 coding using the "SET NAMES utf8"
sequoia runs into trouble.
Another interesting case:
jdbc:sequoia://localhost/myDB (user) > SET collation_connection =
'utf8_unicode_ci'
Affected rows: 0
Query executed in 0 s 16 ms .
jdbc:sequoia://localhost/myDB (user) > SET collation_connection =
'utf8_unicode_ci'
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unable to clone the parsing of an unknown request)
jdbc:sequoia://localhost/myDB (user) > SET collation_connection =
"utf8_unicode_ci"
Affected rows: 0
Query executed in 0 s 158 ms .
jdbc:sequoia://localhost/myDB (user) > SET collation_connection =
"utf8_unicode_ci"
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unable to clone the parsing of an unknown request)
jdbc:sequoia://localhost/myDB (user) > SET collation_connection =
'utf8_unicode_ci'
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Unable to clone the parsing of an unknown request)
Mysql is changed into utf8 mode. Quoting with singe Quote no longer
works. With double quoting it works. And then finish.
Conclusions:
* Sequoia is not capable to know the change of the charset since this is
higly DB-spezific.
* So if the charset is changed during a DB-session sequoia will fail.
Anyone an idea to workaround this problem?
Best regards
Volker
--
====================================================
inqbus it-consulting +49 ( 341 ) 5643800
Dr. Volker Jaenisch http://www.inqbus.de
Herloßsohnstr. 12 0 4 1 5 5 Leipzig
N O T - F Ä L L E +49 ( 170 ) 3113748
====================================================
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
