02-13/04:54:47 ERROR [http-bio-0.0.0.0-80-exec-1] CommonExecutor - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_bin,NONE) for operation 'like'
java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_bin,NONE) for operation 'like'
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
   at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1274)
   at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:780)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
   at bitel.billing.server.contract.action.ActionFindContractByMemo.doAction(ActionFindContractByMemo.java:28)
   at bitel.billing.server.Executer.doModule(SourceFile:600)
   at bitel.billing.server.Executer$1.run(SourceFile:199)
   at java.security.AccessController.doPrivileged(Native Method)
   at javax.security.auth.Subject.doAs(Subject.java:422)
   at bitel.billing.server.Executer.doPost(SourceFile:193)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
   at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   at java.lang.Thread.run(Thread.java:745)

MariaDB [bgbilling]> SHOW CREATE TABLE contract_comment \G;
*************************** 1. row ***************************
       Table: contract_comment
Create Table: CREATE TABLE `contract_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `visibled` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`),
  KEY `cid` (`cid`)
) ENGINE=TokuDB AUTO_INCREMENT=337 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci `COMPRESSION`=tokudb_lzma
1 row in set (0.00 sec)

Информация о версии:

  Клиент: вер. 7.0.866 / 17.01.2017 18:43:42
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_112
  Сервер: вер. 7.0.1186 / 03.02.2017 20:13:34
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_121

  bill: вер. 7.0.111 / 09.12.2016 13:27:55
  card: вер. 7.0.40 / 22.08.2016 16:40:03
  dba: вер. 7.0.167 / 08.04.2016 17:40:39
  enaza: вер. 7.0.63 / 10.06.2016 16:59:19
  inet: вер. 7.0.723 / 03.02.2017 20:13:46
  mps: вер. 7.0.207 / 03.02.2017 20:14:10
  npay: вер. 7.0.204 / 01.02.2017 19:44:28
  payonline: вер. 7.0.76 / 08.01.2017 19:08:27
  phone: вер. 7.0.284 / 20.01.2017 17:45:38
  rentsoft: вер. 7.0.66 / 24.11.2016 20:07:12
  reports: вер. 7.0.227 / 08.01.2017 19:18:36
  rscm: вер. 7.0.183 / 10.11.2016 16:31:29
  ru.bitel.bgbilling.plugins.cladr: вер. 7.0.123 / 08.04.2016 17:40:39
  ru.bitel.bgbilling.plugins.crm: вер. 7.0.198 / 07.11.2016 18:45:32
  ru.bitel.bgbilling.plugins.helpdesk: вер. 7.0.195 / 02.12.2016 16:03:52
  trayinfo: вер. 7.0.175 / 10.06.2016 17:00:23
  tv: вер. 7.0.239 / 30.11.2016 18:20:31
  voiceip: вер. 7.0.190 / 02.12.2016 16:07:44

Окружение:

  Клиент:
    os: Linux amd64, 4.9.7-201.fc25.x86_64
    java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_112
    jre home: /usr/lib/jvm/java-1.8.0-oracle-1.8.0.112.x86_64/jre
    memory (use/total/max): 43M/121M/455M
    default tz: 13.02.2017 05:09 YAKT +0900 (Asia/Chita)
    user tz: 13.02.2017 03:09 NOVT +0700 (Asia/Novosibirsk)
    locale: ru_RU
  Сервер:
    os: Linux amd64, 3.10.0-514.el7.x86_64
    java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_121
    jre home: /usr/java/jdk1.8.0_121/jre
    default tz: 13.02.2017 05:09 YAKT +0900 (Asia/Chita)
    memory (use/total/max): 94M/195M/455M
    db time: master: 13.02.2017 05:09 +09
    db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_unicode_ci)
    locale: ru_RU
    uptime: Started: 13.02.2017 04:53:09 Uptime: 0 d 00:16:39

MariaDB [bgbilling]> SHOW VARIABLES LIKE 'collation%';
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_unicode_ci |
| collation_database   | utf8_unicode_ci |
| collation_server     | utf8_unicode_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

MariaDB [bgbilling]> show create database bgbilling;
+-----------+--------------------------------------------------------------------------------------------+
| Database  | Create Database                                                                            |
+-----------+--------------------------------------------------------------------------------------------+
| bgbilling | CREATE DATABASE `bgbilling` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */ |
+-----------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)