search

DeNA / HandlerSocket-Plugin-for-MySQL

HandlerSocket is a NoSQL plugin for MySQL, working as a daemon inside the mysqld process, to accept tcp connections, and execute requests from clients. HandlerSocket does not support SQL queries; instead it supports simple CRUD operations on tables.
Other
1.13k stars 150 forks source link

read: eof #74

Closed nijikon closed 8 years ago

nijikon commented 12 years ago

On write connection after couple of minutes i keep getting read: eof, after I reconnect the insert goes without any problems. Any ideas why this could happen?

ahiguti commented 12 years ago

I guess it's because of a timeout. An open connection is closed by server if no data is passed for a while (handlersocket_timeout seconds).

nijikon commented 12 years ago

I thought of that, changed from 600 to 3600 but the issue still remains. Any other suggestions?

ahiguti commented 12 years ago

I have no idea. Is it easy to reproduce? How can I reproduce the issue?

nijikon commented 12 years ago

I'm parsing a 270mb xml file with libxml-ruby SaxParser. In each callback I use read and write hs. I have 3 connection established, one for read, and two for write (insert/update). After parsing something about 650k rows, when I try to insert record, then the read: eof for write connection occurs. Unfortunately I can't send You the xml file.

So what's the best way we can debug this?

dungdv commented 11 years ago

Hi all, i have the same problem.

Does anyone know how to solve it?