#416 SQL storage fails to load while database not available
Reporter
kapeel.sable
Owner
MattJ
Created
Updated
Stars
★★ (2)
Tags
Milestone-0.10
Status-Fixed
Type-Defect
Priority-Medium
kapeel.sable
on
*What steps will reproduce the problem?*
1. Set config to use sql for storage (I also have mod_auth_sql for authentication)
2. Delay startup of MySQL server on boot.
3. Reboot.
*What is the expected output? What do you see instead?*
Prosody should retry connection to MySQL if it fails initially.
*What version of the product are you using? On what operating system?*
0.9.1 under Ubuntu 14.01
*Please provide any additional information below.*
Discussed this on IRC. Adding `require("socket").sleep(20);` to config solved the issue for me.
MattJ
on
Hi, thanks for the report and sorry for the delay in processing it. This is a problem I've been looking at solving in our new SQL code in 0.10. I've modified the title because it affects both MySQL and PostgreSQL too.
Changes
owner MattJ
tags Milestone-0.10 Status-Accepted
title SQL storage fails to load while database not available
Zash
on
mod_storage_sql2 in 0.10 should deal with this situation now and attempt to connect when needed.
Also see #417 and #268
*What steps will reproduce the problem?* 1. Set config to use sql for storage (I also have mod_auth_sql for authentication) 2. Delay startup of MySQL server on boot. 3. Reboot. *What is the expected output? What do you see instead?* Prosody should retry connection to MySQL if it fails initially. *What version of the product are you using? On what operating system?* 0.9.1 under Ubuntu 14.01 *Please provide any additional information below.* Discussed this on IRC. Adding `require("socket").sleep(20);` to config solved the issue for me.
Hi, thanks for the report and sorry for the delay in processing it. This is a problem I've been looking at solving in our new SQL code in 0.10. I've modified the title because it affects both MySQL and PostgreSQL too.
Changesmod_storage_sql2 in 0.10 should deal with this situation now and attempt to connect when needed. Also see #417 and #268
Changes