Skip to content
This repository has been archived by the owner on Nov 21, 2024. It is now read-only.

Lost connection to MySQL after unexpected server restart. #9

Open
fk0 opened this issue Aug 10, 2012 · 2 comments
Open

Lost connection to MySQL after unexpected server restart. #9

fk0 opened this issue Aug 10, 2012 · 2 comments

Comments

@fk0
Copy link

fk0 commented Aug 10, 2012

I can't get module to work after restarting DB server, just don't see messages are logged there. Module restart via web GUI does not seem to work either. Also tried ejabberdctl update and it didn't help.
I suppose start/stop module behavior is not correct.

How can I make sure it will be working after restart? Does the module track the status of DB and reconnects properly after table is checked?

@fk0
Copy link
Author

fk0 commented Aug 10, 2012

Here's what erlang.log shows
=CRASH REPORT==== 10-Aug-2012::14:07:51 ===
crasher:
initial call: mod_log_chat_mysql5:init/1
pid: <0.1724.0>
registered_name: []
exception exit: pool_already_exists
in function gen_server:init_it/6
ancestors: [ejabberd_sup,<0.37.0>]
messages: []
links: [<0.250.0>]
dictionary: []
trap_exit: false
status: running
heap_size: 610
stack_size: 24
reductions: 1203
neighbours:

@fk0
Copy link
Author

fk0 commented Aug 10, 2012

fixed the issue manually by invoking:

  1. ejabberdctl debug
  2. emysql:remove_pool(mod_log_chat_mysql5_db).

I think this issue happens due to missing handling of hanged up pool which couldn't be re-used at the module start.

@mweibel mweibel closed this as completed Feb 29, 2016
@mweibel mweibel reopened this Feb 29, 2016
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants