#416 SQL storage fails to load while database not available

Reporter kapeel.sable
Owner MattJ
Stars ★★ (2)
  • Type-Defect
  • Status-Fixed
  • Priority-Medium
  • Milestone-0.10
  1. 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.

  2. 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.

    • owner MattJ
    • tags Milestone-0.10 Status-Accepted
    • title SQL storage fails to load while database not available
  3. 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

    • tag Status-Fixed

New comment

Not published. Used for spam prevention and optional update notifications.