Всё уже перетрёс. Не понимаю, что ему надо
Обновился с 5.2 на 7, и вот такая вот беда.
Код:
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)
При поиске по примечаниям
Вложение:
Снимок экрана от 2017-02-13 03-03-18.png [ 18.48 КБ | Просмотров: 3833 ]
База/сервер/подключение - всё в UTF8. Поле и значение тоже.
Код:
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)
Проблема точно не в TokuDB, так как InnoDB я тоже пробовал.
Код:
Информация о версии:
Клиент: вер. 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