使用 mysql -h 127.0.01 -P 9306 登录后 select * from jobs_rt 没有问题，但执行 insert into 就出现 ERROR 2013 (HY000): Lost connection to MySQL server during query
修改 charset_type 没有用！
使用 php或python并用其自带mysql驱动执行如上操作效果一样
执行 SELECT num_id FROM jobs_rt WHERE MATCH('test'); 没问题，显示 Empty set (0.00 sec)
coreseek 版本 4.1 系统是 ubuntu 10.04
配置：
index jobs_rt
{
type = rt
path = /var/data/jobs_rt
docinfo = extern
mlock = 0
morphology = none
min_word_len = 1
html_strip = 0
charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux环境下设置，/符号结尾
charset_type = zh_cn.utf-8
rt_field = title
rt_field = company
rt_field = province
rt_field = city
rt_field = content
rt_attr_uint = num_id
rt_attr_string = oid
#RT实时索引内存设置
rt_mem_limit = 128M
}
#searchd服务定义
searchd
{
workers = threads
listen = 9312
listen = 9306:mysql41
read_timeout = 15
max_children = 30
max_matches = 1000
seamless_rotate = 0
preopen_indexes = 10
unlink_old = 1
pid_file = /var/log/searchd_rtindex.pid #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
log = /var/log/searchd_rtindex.log #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
query_log = /var/log/query_rtindex.log #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
binlog_path = /var/log/rtindex/ #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
binlog_flush = 2
binlog_max_log_size = 128M
}
日志：
[Sat Nov 12 17:35:08.377 2011] [11053] Child process 11054 has been forked
[Sat Nov 12 17:35:08.379 2011] [11054] listening on all interfaces, port=9312
[Sat Nov 12 17:35:08.379 2011] [11054] listening on all interfaces, port=9306
[Sat Nov 12 17:35:08.381 2011] [11054] accepting connections
------- FATAL: CRASH DUMP -------
[Sat Nov 12 17:36:38.607 2011] [11054]
--- crashed SphinxQL request dump ---
insert into jobs_rt (id, title, company, province, city, content, num_id, oid) VALUES
(1, 'a', 'b', 'c', 'd', 'e', 1, 'abcdefeg')
--- request dump end ---
Sphinx 2.0.2-dev (r2922)
-------------- backtrace begins here ---------------
Program compiled with gcc 4.4.5
Host OS is Linux AY110804115305a 2.6.35-22-server #35-Ubuntu SMP Sat Oct 16 22:02:33 UTC 2010 x86_64 GNU/Linux
Stack bottom = 0x7f7b3af89e7f, thread stack size = 0x14000
begin of manual backtrace:
Something wrong with thread stack, backtrace may be incorrect (fp=7f7b3af89e7f)
Stack looks OK, attempting backtrace.
0
Something wrong in frame pointers, backtrace failed (fp=2b3200)
begin of system backtrace:
begin of system symbols:
searchd(_Z12sphBacktraceib+0x25e)[0x59509e]
searchd(_ZN16SphCrashLogger_c11HandleCrashEi+0x180)[0x464fd0]
/lib/libpthread.so.0(+0xfb40)[0x7f7b3a054b40]
/lib/libc.so.6(__strcasecmp+0x24)[0x7f7b390fa924]
searchd(_ZNK10CSphSchema13GetFieldIndexEPKc+0xdc)[0x4b975c]
searchd(_Z17HandleMysqlInsertRK9SqlStmt_tR17NetOutputBuffer_chbb+0x1fa4)[0x484524]
searchd(_Z17HandleClientMySQLiPKcP9ThdDesc_t+0xd11)[0x49e431]
searchd(_Z13HandlerThreadPv+0xf9)[0x4a1509]
searchd(_Z20sphThreadProcWrapperPv+0x1f)[0x59d38f]
/lib/libpthread.so.0(+0x7971)[0x7f7b3a04c971]
/lib/libc.so.6(clone+0x6d)[0x7f7b3915a92d]
-------------- backtrace ends here ---------------
--- 1 active threads ---
thd 0, proto sphinxql, state query, command replace
------- CRASH DUMP END -------
[Sat Nov 12 17:36:39.134 2011] [11053] Child process 11054 has been finished by CRASH_EXIT (exit code 2), will be restarted
[Sat Nov 12 17:36:39.135 2011] [11053] Child process 11062 has been forked
[Sat Nov 12 17:36:39.137 2011] [11062] listening on all interfaces, port=9312
[Sat Nov 12 17:36:39.137 2011] [11062] listening on all interfaces, port=9306
[Sat Nov 12 17:36:39.139 2011] [11062] binlog: replaying log /var/log/rtindex/binlog.001
[Sat Nov 12 17:36:39.139 2011] [11062] binlog: replay stats: 0 rows in 0 commits; 0 updates; 0 indexes
[Sat Nov 12 17:36:39.139 2011] [11062] binlog: finished replaying /var/log/rtindex/binlog.001; 0.0 MB in 0.000 sec
[Sat Nov 12 17:36:39.139 2011] [11062] binlog: finished replaying total 1 in 0.000 sec
[Sat Nov 12 17:36:39.140 2011] [11062] accepting connections |
