How to close connection when listening to BinLog and clear listening thread from mysql process list

[Woody88]

Hi:

How would one go about closing the MySQL connection when listening to binglog events? It seems like the thread hangs when I execute MySQL.close conn. One approach that seems to be partially working is sending an empty packet to the MySQLConn input stream using Streams.unRead. However, when I run Show full processlist in MySQL, I can still see the listening thread in the process list. I have been tackling this for a week now, and I am completely lost.

Thanks in advance.

Woodson D.

[winterland1989]

Do you call MySQL.close conn from another Haskell thread? Normally you would use bracket pattern to get a connection, so instead of closing a connection you should simply kill the listening thread and let the listening thread handle the connection closing.