mysql-proxy session问题
Auth: Jin
Date: 20140328
问题:
基于openx 的广告系统,将数据从单点,迁移到mmm集群,使用proxy访问
报错如下
MDB2 Error: Array _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE MDB2_STATEMENT_mysql_231aaea2d6a8cace7c73797d81dc6ea8 USING @0] [Native code: 1243] [Native message: Unknown prepared statement handler (MDB2_STATEMENT_mysql_231aaea2d6a8cace7c73797d81dc6ea8) given to EXECUTE]
: Could not execute statement]
/data/httpd/htdocs/ad/var/debug.log:[Last
executed query: EXECUTE MDB2_STATEMENT_mysql_a0846690c52c0e64d42b7421fcd3e983
USING @0]
/data/httpd/htdocs/ad/var/debug.log:[Native message: Unknown
prepared statement handler
(MDB2_STATEMENT_mysql_a0846690c52c0e64d42b7421fcd3e983) given to
EXECUTE]
/data/httpd/htdocs/ad/var/debug.log:Mar 28 04:29:16 +0000 OX [
error] PEAR :: MDB2 Error: Array : _doQuery: [Error message: Could not execute
statement]
1、配置指向原来的单点正常
2、配置指向mmm的master正常
3.·判断为通过proxy 产生问题
最开始根据报错提示以为是权限问题,全部权限添加确认一次,还一样
根据报错里面那么串字符,感觉是session
/data/httpd/htdocs/ad/lib/pear/MDB2.ph
问题:session之能保持到一个ip,无法穿插
解决:指向writer的vip
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。