Search the Community
Showing results for tags 'mysql'.
-
Hi, I`m Byungwook Choi. I am using PSCM(Version PlasticSCM-5.0.44.570) and DB(Mysql 5.5.39). I will now proceed with the PSCM Upgrade(Version PlasticSCM-6.0.16.1765) Is there anything I need to consider to proceed with the PSCM Upgrade? ( something like Mysql Version, ...) I Would appreciate your kind attention. The information below is server information * Spec mysql Version = 14.14 Distrib 5.5.39, for Win64 (X86) OS = Windows Server 2008 R2 Standard Ram = 16GB Thanks, Byungwook Choi
-
If you ever face the following error: --------------------------- Error --------------------------- There has been an unexpected error "Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.". For more information check the server log. --------------------------- OK --------------------------- is because MySQL is not liking the default Plastic isolation level. You can change it by adding the following entry in your "db.conf" server config file: <IsolationLevel>RepeatableRead</IsolationLevel> "RepeteableRead" is OK, no issues are reported so far using it, this is the first one you will want to try if you face the error described above. If it doesn't work... contact us!