[ejabberd] I think I really messed up my mnesia database

Wijnand Wiersma wijnand at videre.net
Thu Jul 23 23:17:46 MSD 2009


Hi All,

I made a mess of my ejabberd server by using the webinterface to set  
the table type to disk_only for config.
The ejabberd server started to fall apart and now it won't start  
anymore.

This is also the perfect day to find out my backups are not usable so  
I can't rely on those either :-(

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,sasl_safe_sup}
              started: [{pid,<0.50.0>},
                        {name,alarm_handler},
                        {mfa,{alarm_handler,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,2000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,sasl_safe_sup}
              started: [{pid,<0.51.0>},
                        {name,overload},
                        {mfa,{overload,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,2000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,sasl_sup}
              started: [{pid,<0.49.0>},
                        {name,sasl_safe_sup},
                        {mfa,
                            {supervisor,start_link,
                                [{local,sasl_safe_sup},sasl,safe]}},
                        {restart_type,permanent},
                        {shutdown,infinity},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,sasl_sup}
              started: [{pid,<0.52.0>},
                        {name,release_handler},
                        {mfa,{release_handler,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,2000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
          application: sasl
           started_at: ejabberd at server1

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,kernel_safe_sup}
              started: [{pid,<0.56.0>},
                        {name,dets_sup},
                        {mfa,{dets_sup,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,1000},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,kernel_safe_sup}
              started: [{pid,<0.57.0>},
                        {name,dets},
                        {mfa,{dets_server,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,2000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_sup}
              started: [{pid,<0.65.0>},
                        {name,mnesia_event},
                        {mfa,{mnesia_sup,start_event,[]}},
                        {restart_type,permanent},
                        {shutdown,30000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.67.0>},
                        {name,mnesia_monitor},
                        {mfa,{mnesia_monitor,start,[]}},
                        {restart_type,permanent},
                        {shutdown,3000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.68.0>},
                        {name,mnesia_subscr},
                        {mfa,{mnesia_subscr,start,[]}},
                        {restart_type,permanent},
                        {shutdown,3000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.69.0>},
                        {name,mnesia_locker},
                        {mfa,{mnesia_locker,start,[]}},
                        {restart_type,permanent},
                        {shutdown,3000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.70.0>},
                        {name,mnesia_recover},
                        {mfa,{mnesia_recover,start,[]}},
                        {restart_type,permanent},
                        {shutdown,180000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,kernel_safe_sup}
              started: [{pid,<0.75.0>},
                        {name,disk_log_sup},
                        {mfa,{disk_log_sup,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,1000},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,kernel_safe_sup}
              started: [{pid,<0.76.0>},
                        {name,disk_log_server},
                        {mfa,{disk_log_server,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,2000},
                        {child_type,worker}]
dets: file "/var/db/ejabberd/ejabberd/config.DAT" not properly closed,  
repairing ...

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,kernel_safe_sup}
              started: [{pid,<0.94.0>},
                        {name,timer_server},
                        {mfa,{timer,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,1000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.71.0>},
                        {name,mnesia_tm},
                        {mfa,{mnesia_tm,start,[]}},
                        {restart_type,permanent},
                        {shutdown,30000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.95.0>},
                        {name,mnesia_checkpoint_sup},
                        {mfa,{mnesia_checkpoint_sup,start,[]}},
                        {restart_type,permanent},
                        {shutdown,infinity},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.96.0>},
                        {name,mnesia_snmp_sup},
                        {mfa,{mnesia_snmp_sup,start,[]}},
                        {restart_type,permanent},
                        {shutdown,infinity},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.97.0>},
                        {name,mnesia_controller},
                        {mfa,{mnesia_controller,start,[]}},
                        {restart_type,permanent},
                        {shutdown,3000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_kernel_sup}
              started: [{pid,<0.98.0>},
                        {name,mnesia_late_loader},
                        {mfa,{mnesia_late_loader,start,[]}},
                        {restart_type,permanent},
                        {shutdown,3000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
           supervisor: {local,mnesia_sup}
              started: [{pid,<0.66.0>},
                        {name,mnesia_kernel_sup},
                        {mfa,{mnesia_kernel_sup,start,[]}},
                        {restart_type,permanent},
                        {shutdown,infinity},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:12 ===
          application: mnesia
           started_at: ejabberd at server1

=PROGRESS REPORT==== 23-Jul-2009::21:11:14 ===
           supervisor: {local,crypto_sup}
              started: [{pid,<0.210.0>},
                        {name,crypto_server},
                        {mfa,{crypto_server,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,2000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:14 ===
          application: crypto
           started_at: ejabberd at server1

=PROGRESS REPORT==== 23-Jul-2009::21:11:14 ===
           supervisor: {local,ssl_sup}
              started: [{pid,<0.216.0>},
                        {name,ssl_broker_sup},
                        {mfa,{ssl_broker_sup,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,2000},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:14 ===
           supervisor: {local,ssl_sup}
              started: [{pid,<0.217.0>},
                        {name,ssl_manager},
                        {mfa,{ssl_manager,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,4000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:14 ===
           supervisor: {local,ssl_sup}
              started: [{pid,<0.218.0>},
                        {name,ssl_connection},
                        {mfa,{ssl_connection_sup,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,4000},
                        {child_type,supervisor}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:14 ===
          application: ssl
           started_at: ejabberd at server1

=PROGRESS REPORT==== 23-Jul-2009::21:11:14 ===
           supervisor: {local,stringprep_sup}
              started: [{pid,<0.220.0>},
                        {name,stringprep},
                        {mfa,{stringprep,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,brutal_kill},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:15 ===
           supervisor: {local,ejabberd_sup}
              started: [{pid,<0.255.0>},
                        {name,ejabberd_hooks},
                        {mfa,{ejabberd_hooks,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,brutal_kill},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:15 ===
           supervisor: {local,kernel_safe_sup}
              started: [{pid,<0.257.0>},
                        {name,pg2},
                        {mfa,{pg2,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,1000},
                        {child_type,worker}]

=PROGRESS REPORT==== 23-Jul-2009::21:11:15 ===
           supervisor: {local,ejabberd_sup}
              started: [{pid,<0.256.0>},
                        {name,ejabberd_node_groups},
                        {mfa,{ejabberd_node_groups,start_link,[]}},
                        {restart_type,permanent},
                        {shutdown,brutal_kill},
                        {child_type,worker}]

=CRASH REPORT==== 23-Jul-2009::21:11:15 ===
   crasher:
     pid: <0.258.0>
     registered_name: ejabberd_system_monitor
     exception exit: {badarg,[{ets,lookup,[config,hosts]},
                              {ejabberd_config,get_global_option,1},
                              {ejabberd_system_monitor,init,1},
                              {gen_server,init_it,6},
                              {proc_lib,init_p,5}]}
       in function  gen_server:init_it/6
     initial call: gen:init_it(gen_server,<0.254.0>,<0.254.0>,
                               {local,ejabberd_system_monitor},
                               ejabberd_system_monitor,[],[])
     ancestors: [ejabberd_sup,<0.39.0>]
     messages: []
     links: [<0.254.0>]
     dictionary: []
     trap_exit: false
     status: running
     heap_size: 377
     stack_size: 23
     reductions: 111
   neighbours:

=SUPERVISOR REPORT==== 23-Jul-2009::21:11:15 ===
      Supervisor: {local,ejabberd_sup}
      Context:    start_error
      Reason:     {badarg,[{ets,lookup,[config,hosts]},
                           {ejabberd_config,get_global_option,1},
                           {ejabberd_system_monitor,init,1},
                           {gen_server,init_it,6},
                           {proc_lib,init_p,5}]}
      Offender:   [{pid,undefined},
                   {name,ejabberd_system_monitor},
                   {mfa,{ejabberd_system_monitor,start_link,[]}},
                   {restart_type,permanent},
                   {shutdown,brutal_kill},
                   {child_type,worker}]


=CRASH REPORT==== 23-Jul-2009::21:11:15 ===
   crasher:
     pid: <0.38.0>
     registered_name: []
     exception exit: {bad_return,
                         {{ejabberd_app,start,[normal,[]]},
                          {'EXIT',
                              {badarg,
                                  [{ets,lookup,[config,hosts]},
                                   {ejabberd_config,get_global_option, 
1},
                                   {ejabberd_rdbms,start_hosts,0},
                                   {ejabberd_app,start,2},
                                   {application_master,start_it_old, 
4}]}}}}
       in function  application_master:init/4
     initial call: application_master:init(<0.5.0>,<0.37.0>,
                                           {appl_data,ejabberd,
                                            [ejabberd,ejabberd_sup,
                                              
ejabberd_auth,ejabberd_router,
                                             ejabberd_sm,ejabberd_s2s,
                                              
ejabberd_local,ejabberd_listeners,
                                             ejabberd_iq_sup,
                                             ejabberd_service_sup,
                                             ejabberd_s2s_out_sup,
                                             ejabberd_s2s_in_sup,
                                             ejabberd_c2s_sup,
                                             ejabberd_mod_roster,
                                             ejabberd_mod_echo,
                                             ejabberd_mod_pubsub,
                                              
ejabberd_mod_irc,ejabberd_mod_muc,
                                              
ejabberd_offline,random_generator],
                                            undefined,
                                            {ejabberd_app,[]},
                                            [acl,adhoc,configure,
                                             cyrsasl_anonymous,cyrsasl,
                                              
cyrsasl_digest,cyrsasl_plain,
                                              
ejabberd_admin,ejabberd_app,
                                             ejabberd_auth_anonymous,
                                             ejabberd_auth,
                                             ejabberd_auth_external,
                                             ejabberd_auth_internal,
                                             ejabberd_auth_ldap,
                                             ejabberd_auth_odbc,
                                             ejabberd_auth_pam,ejabberd,
                                              
ejabberd_c2s,ejabberd_c2s_config,
                                              
ejabberd_config,ejabberd_ctl,
                                             ejabberd_frontend_socket,
                                              
ejabberd_hooks,ejabberd_http,
                                             ejabberd_http_bind,
                                             ejabberd_http_poll,
                                              
ejabberd_listener,ejabberd_local,
                                             ejabberd_logger_h,
                                             ejabberd_loglevel,
                                             ejabberd_node_groups,
                                              
ejabberd_rdbms,ejabberd_receiver,
                                              
ejabberd_router,ejabberd_s2s,
                                              
ejabberd_s2s_in,ejabberd_s2s_out,
                                              
ejabberd_service,ejabberd_sm,
                                              
ejabberd_socket,ejabberd_sup,
                                             ejabberd_system_monitor,
                                              
ejabberd_tmp_sup,ejabberd_update,
                                              
ejabberd_web_admin,ejabberd_web,
                                              
ejabberd_zlib,ejd2odbc,eldap,
                                             eldap_filter,eldap_pool,
                                              
eldap_utils,'ELDAPv3',extauth,
                                             gen_iq_handler,gen_mod,
                                             gen_pubsub_node,
                                              
gen_pubsub_nodetree,iconv,idna,
                                             jd2ejd,jlib,mod_adhoc,
                                             mod_announce,mod_caps,
                                              
mod_configure2,mod_configure,
                                              
mod_disco,mod_echo,mod_http_bind,
                                              
mod_http_fileserver,mod_irc,
                                              
mod_irc_connection,mod_last,
                                              
mod_last_odbc,mod_muc,mod_muc_log,
                                             mod_muc_room,mod_offline,
                                              
mod_offline_odbc,mod_privacy,
                                              
mod_privacy_odbc,mod_private,
                                              
mod_private_odbc,mod_proxy65,
                                             mod_proxy65_lib,
                                             mod_proxy65_service,
                                              
mod_proxy65_sm,mod_proxy65_stream,
                                             mod_pubsub,mod_register,
                                             mod_roster,mod_roster_odbc,
                                              
mod_service_log,mod_shared_roster,
                                              
mod_stats,mod_time,mod_vcard,
                                              
mod_vcard_ldap,mod_vcard_odbc,
                                              
mod_version,node_buddy,node_club,
                                             node_default,node_dispatch,
                                              
node_pep,node_private,node_public,
                                              
nodetree_default,nodetree_virtual,
                                             p1_fsm,p1_mnesia,
                                              
ram_file_io_server,randoms,sha,
                                              
shaper,stringprep,stringprep_sup,
                                              
tls,translate,xml,xml_stream,
                                             'XmppAddr'],
                                            [],infinity,infinity},
                                           normal)
     ancestors: [<0.37.0>]
     messages: [{'EXIT',<0.39.0>,normal}]
     links: [<0.37.0>,<0.5.0>]
     dictionary: []
     trap_exit: true
     status: running
     heap_size: 987
     stack_size: 23
     reductions: 117
   neighbours:

=INFO REPORT==== 23-Jul-2009::21:11:15 ===
     application: ejabberd
     exited: {bad_return,
                 {{ejabberd_app,start,[normal,[]]},
                  {'EXIT',
                      {badarg,
                          [{ets,lookup,[config,hosts]},
                           {ejabberd_config,get_global_option,1},
                           {ejabberd_rdbms,start_hosts,0},
                           {ejabberd_app,start,2},
                           {application_master,start_it_old,4}]}}}}
     type: temporary

Anyone with a good suggestion on how to fix?

Kind regards,
Wijnand


More information about the ejabberd mailing list