I installed Carbonio CE 24.9.1 on Ubuntu 22 by Automation script from docs.zextras.com. Everything is ok but the chat and video meeting not work, anyone know where I can check log or related check, pls show me. Thank you very much.
Hello QuangSang,
Got the same problem here. After few searches on all logs on my system, i found some on /var/log/syslog:
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.099 [error] gen_server 'wpool_pool-mongoose_wpool$rdbms$global$default-5' terminated with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.099323+00:00 level=error reason="{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}" pid=<0.3225.0> at=gen_server:error_info/8:1391 client_info="{<0.3881.0>,{<0.3881.0>,[{gen,do_call,4,[{file,\"gen.erl\"},{line,259}]},{gen_server,call,3,[{file,\"gen_server.erl\"},{line,415}]},{mongoose_rdbms,execute_successfully,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,271}]},{mod_muc_light_db_rdbms,get_aff_users,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light_db_rdbms.erl\"},{line,551}]},{timer,tc,4,[{file,\"timer.erl\"},{line,312}]},{mongoose_backend,call_tracked,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_backend.erl\"},{line,97}]},{mod_muc_light,acc_room_affiliations,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light.erl\"},{line,543}]},{gen_hook,apply_hook_function,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/gen_hook.erl\"},{line,251}]}]}}" last_message="{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831294}" state={state,<0.3226.0>,#{},30,5000} log= name=wpool_pool-mongoose_wpool$rdbms$global$default-5 label={gen_server,terminate}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.101 [error] CRASH REPORT Process 'wpool_pool-mongoose_wpool$rdbms$global$default-5' with 0 neighbours crashed with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.101453+00:00 level=error pid=<0.3225.0> at=proc_lib:crash_report/4:584 report="[[{initial_call,{wpool_process,init,['Argument__1']}},{pid,<0.3225.0>},{registered_name,'wpool_pool-mongoose_wpool$rdbms$global$default-5'},{error_info,{error,{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{ancestors,['wpool_pool-mongoose_wpool$rdbms$global$default-process-sup','mongoose_wpool$rdbms$global$default',mongoose_wpool_rdbms_sup,mongoose_wpool_sup,ejabberd_sup,<0.292.0>]},{message_queue_len,1},{messages,[{'EXIT',<0.3226.0>,normal}]},{links,[<0.3214.0>]},{dictionary,[{wpool_task,{undefined,1731341290,{call,{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831294}}}}]},{trap_exit,true},{status,running},{heap_size,6772},{stack_size,28},{reductions,46514}],[]]" label={proc_lib,crash}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.104 [error] Supervisor 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-5' started with wpool_process:start_link('wpool_pool-mongoose_wpool$rdbms$global$default-5', mongoose_rdbms, #{driver => pgsql,port => 20000,host => "127.78.0.10",password => "10b2ef0a46aa89cecc5946877714...",...}, [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3225.0> exit with reason no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894 in context child_terminated
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.103081+00:00 level=error pid=<0.3214.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,child_terminated},{reason,{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{offender,[{pid,<0.3225.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-5'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-5',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,child_terminated}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.103590+00:00 level=error what=hook_failed reason="{{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]},{gen_server,call,['wpool_pool-mongoose_wpool$rdbms$global$default-5',{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831294},60000]}}" pid=<0.3881.0> at=gen_hook:error_running_hook/5:254 from_jid=1d55f392-0b0d-4bed-bac9-46a4f442838e@carbonio/1731-341284-544685-72d479454012092a to_jid=ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio stacktrace="gen_server:call/3:419 mongoose_rdbms:execute_successfully/4:271 mod_muc_light_db_rdbms:get_aff_users/2:551 timer:tc/4:312 mongoose_backend:call_tracked/4:97 mod_muc_light:acc_room_affiliations/3:543 gen_hook:apply_hook_function/3:251 gen_hook:run_hook/4:237" text="Error running hook" acc_timestamp=2024-11-11T16:08:10.070268+00:00 origin_pid=<0.3848.0> key="{acc_room_affiliations,<<\"carbonio\">>}" params_room="{jid,<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>,<<>>}" handler="{hook_handler,50,fun mod_muc_light:acc_room_affiliations/3,#{host_type => <<\"carbonio\">>,hook_name => acc_room_affiliations,hook_tag => <<\"carbonio\">>}}" packet="<iq id='898f5d5e-858c-48f9-822a-2030129e6b74:sendIQ' to='ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio' type='set' xmlns='jabber:client'><query queryid='history' xmlns='urn:xmpp:mam:2'><x type='submit' xmlns='jabber:x:data'><field type='hidden' var='FORM_TYPE'><value>urn:xmpp:mam:2</value></field><field var='start'><value>2024-11-11T17:02:07.128+01:00</value></field><field var='end'><value>2024-11-11T17:08:09.840+01:00</value></field></x><set xmlns='http://jabber.org/protocol/rsm'><max>50</max><before/></set></query></iq>"
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.108 [error] gen_server 'wpool_pool-mongoose_wpool$rdbms$global$default-8' terminated with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.107925+00:00 level=error reason="{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}" pid=<0.3231.0> at=gen_server:error_info/8:1391 client_info="{<0.3881.0>,{<0.3881.0>,[{gen,do_call,4,[{file,\"gen.erl\"},{line,259}]},{gen_server,call,3,[{file,\"gen_server.erl\"},{line,415}]},{mongoose_rdbms,execute_successfully,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,271}]},{mod_muc_light_db_rdbms,get_aff_users,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light_db_rdbms.erl\"},{line,551}]},{timer,tc,4,[{file,\"timer.erl\"},{line,312}]},{mongoose_backend,call_tracked,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_backend.erl\"},{line,97}]},{mod_muc_light,acc_room_affiliations,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/muc_light/mod_muc_light.erl\"},{line,543}]},{gen_hook,apply_hook_function,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/gen_hook.erl\"},{line,251}]}]}}" last_message="{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831284}" state={state,<0.3232.0>,#{},30,5000} log= name=wpool_pool-mongoose_wpool$rdbms$global$default-8 label={gen_server,terminate}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.109 [error] CRASH REPORT Process 'wpool_pool-mongoose_wpool$rdbms$global$default-8' with 0 neighbours crashed with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.109717+00:00 level=error pid=<0.3231.0> at=proc_lib:crash_report/4:584 report="[[{initial_call,{wpool_process,init,['Argument__1']}},{pid,<0.3231.0>},{registered_name,'wpool_pool-mongoose_wpool$rdbms$global$default-8'},{error_info,{error,{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{ancestors,['wpool_pool-mongoose_wpool$rdbms$global$default-process-sup','mongoose_wpool$rdbms$global$default',mongoose_wpool_rdbms_sup,mongoose_wpool_sup,ejabberd_sup,<0.292.0>]},{message_queue_len,1},{messages,[{'EXIT',<0.3232.0>,normal}]},{links,[<0.3214.0>]},{dictionary,[{wpool_task,{undefined,1731341290,{call,{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831284}}}}]},{trap_exit,true},{status,running},{heap_size,6772},{stack_size,28},{reductions,46326}],[]]" label={proc_lib,crash}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.110976+00:00 level=error what=hook_failed reason="{{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]},{gen_server,call,['wpool_pool-mongoose_wpool$rdbms$global$default-8',{sql_cmd,{sql_execute,muc_light_select_affs_by_us,[<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>]},-576457831284},60000]}}" pid=<0.3881.0> at=gen_hook:error_running_hook/5:254 from_jid=1d55f392-0b0d-4bed-bac9-46a4f442838e@carbonio/1731-341284-544685-72d479454012092a to_jid=ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio stacktrace="gen_server:call/3:419 mongoose_rdbms:execute_successfully/4:271 mod_muc_light_db_rdbms:get_aff_users/2:551 timer:tc/4:312 mongoose_backend:call_tracked/4:97 mod_muc_light:acc_room_affiliations/3:543 gen_hook:apply_hook_function/3:251 gen_hook:run_hook/4:237" text="Error running hook" acc_timestamp=2024-11-11T16:08:10.070268+00:00 origin_pid=<0.3848.0> key="{acc_room_affiliations,<<\"carbonio\">>}" params_room="{jid,<<\"ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4\">>,<<\"muclight.carbonio\">>,<<>>}" handler="{hook_handler,50,fun mod_muc_light:acc_room_affiliations/3,#{host_type => <<\"carbonio\">>,hook_name => acc_room_affiliations,hook_tag => <<\"carbonio\">>}}" packet="<iq id='898f5d5e-858c-48f9-822a-2030129e6b74:sendIQ' to='ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio' type='set' xmlns='jabber:client'><query queryid='history' xmlns='urn:xmpp:mam:2'><x type='submit' xmlns='jabber:x:data'><field type='hidden' var='FORM_TYPE'><value>urn:xmpp:mam:2</value></field><field var='start'><value>2024-11-11T17:02:07.128+01:00</value></field><field var='end'><value>2024-11-11T17:08:09.840+01:00</value></field></x><set xmlns='http://jabber.org/protocol/rsm'><max>50</max><before/></set></query></iq>"
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.112387+00:00 level=warning what=action_not_allowed reason="Not allowed to enter the room." pid=<0.3881.0> at=mod_mam_muc:room_process_mam_iq/5:236 from_jid=1d55f392-0b0d-4bed-bac9-46a4f442838e@carbonio/1731-341284-544685-72d479454012092a to_jid=ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio acc_timestamp=2024-11-11T16:08:10.070268+00:00 origin_pid=<0.3848.0> can_access_room=false action=mam_set_message_form packet="<iq id='898f5d5e-858c-48f9-822a-2030129e6b74:sendIQ' to='ac0e347d-c83d-4e0e-a1b5-0bf959cbc8b4@muclight.carbonio' type='set' xmlns='jabber:client'><query queryid='history' xmlns='urn:xmpp:mam:2'><x type='submit' xmlns='jabber:x:data'><field type='hidden' var='FORM_TYPE'><value>urn:xmpp:mam:2</value></field><field var='start'><value>2024-11-11T17:02:07.128+01:00</value></field><field var='end'><value>2024-11-11T17:08:09.840+01:00</value></field></x><set xmlns='http://jabber.org/protocol/rsm'><max>50</max><before/></set></query></iq>"
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.134 [error] Supervisor 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-8' started with wpool_process:start_link('wpool_pool-mongoose_wpool$rdbms$global$default-8', mongoose_rdbms, #{driver => pgsql,port => 20000,host => "127.78.0.10",password => "10b2ef0a46aa89cecc5946877714...",...}, [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3231.0> exit with reason no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"muc_light_rooms\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"46">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894 in context child_terminated
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.134229+00:00 level=error pid=<0.3214.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,child_terminated},{reason,{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"muc_light_rooms\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"46\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{offender,[{pid,<0.3231.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-8'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-8',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,child_terminated}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.134949+00:00 level=error pid=<0.3214.0> at=supervisor:restart/2:813 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,shutdown},{reason,reached_max_restart_intensity},{offender,[{pid,<0.3231.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-8'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-8',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,shutdown}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: when=2024-11-11T16:08:10.137376+00:00 level=error pid=<0.492.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'mongoose_wpool$rdbms$global$default'}},{errorContext,child_terminated},{reason,shutdown},{offender,[{pid,<0.3214.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'},{mfargs,{wpool_process_sup,start_link,['mongoose_wpool$rdbms$global$default','wpool_pool-mongoose_wpool$rdbms$global$default-process-sup',[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"10b2ef0a46aa89cecc594687771435de\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,infinity},{child_type,supervisor}]}]" label={supervisor,child_terminated}
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.135 [error] Supervisor 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-8' started with wpool_process:start_link('wpool_pool-mongoose_wpool$rdbms$global$default-8', mongoose_rdbms, #{driver => pgsql,port => 20000,host => "127.78.0.10",password => "10b2ef0a46aa89cecc5946877714...",...}, [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3231.0> exit with reason reached_max_restart_intensity in context shutdown
Nov 11 16:08:10 sd-131028 mongooseimctl[7471]: 16:08:10.137 [error] Supervisor 'mongoose_wpool$rdbms$global$default' had child 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup' started with wpool_process_sup:start_link('mongoose_wpool$rdbms$global$default', 'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup', [{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},...]) at <0.3214.0> exit with reason shutdown in context child_terminated
Could you please share the output of following commands:
root@mail:~# curl -s -v http://127.78.0.4:10000/health | jq
and
root@mail:~# systemctl list-units carbonio*
And restart services as per following order:
root@mail:~# systemctl restart carbonio-tasks root@mail:~# systemctl restart carbonio-message-broker root@mail:~# systemctl restart carbonio-message-dispatcher root@mail:~# systemctl restart carbonio-ws-collaboration root@mail:~# systemctl restart carbonio-videoserver
And later check the status of these services if needed.
Regards,
Sharif
root@carbonio:~# curl -s -v http://127.78.0.4:10000/health | jq
* Trying 127.78.0.4:10000...
* Connected to 127.78.0.4 (127.78.0.4) port 10000 (#0)
> GET /health HTTP/1.1
> Host: 127.78.0.4:10000
> User-Agent: curl/7.81.0
> Accept: */*
>
* Mark bundle as not supporting multiuse
< HTTP/1.1 200 OK
< Server: Jetty(12.0.8)
< Date: Tue, 12 Nov 2024 07:18:19 GMT
< Content-Type: application/json
< Content-Length: 403
<
{ [403 bytes data]
* Connection #0 to host 127.78.0.4 left intact
{
"isLive": true,
"status": "ok",
"dependencies": [
{
"name": "database",
"isHealthy": true
},
{
"name": "authentication_service",
"isHealthy": true
},
{
"name": "profiling_service",
"isHealthy": true
},
{
"name": "xmpp_server",
"isHealthy": true
},
{
"name": "event_dispatcher",
"isHealthy": true
},
{
"name": "storage_service",
"isHealthy": true
},
{
"name": "previewer_service",
"isHealthy": true
},
{
"name": "videoserver_service",
"isHealthy": true
}
]
}
-----------------------
root@carbonio:~# systemctl list-units carbonio*
UNIT LOAD ACTIVE SUB DESCRIPTION
carbonio-clamav-sidecar.service loaded active running Carbonio clamav sidecar proxy
carbonio-clamav-signature-provider-sidecar.service loaded active running NGINX Carbonio ClamAV signature provider sidecar
carbonio-docs-connector-db-sidecar.service loaded active running Carbonio Docs Connector database sidecar
carbonio-docs-connector-sidecar.service loaded active running Carbonio docs connector sidecar proxy
carbonio-docs-connector.service loaded active running Carbonio docs connector daemon
carbonio-docs-editor-sidecar.service loaded active running Carbonio Docs server sidecar proxy
carbonio-docs-editor.service loaded active running Carbonio Docs Server
carbonio-files-db-sidecar.service loaded active running Carbonio Files database sidecar
carbonio-files-sidecar.service loaded active running Carbonio Files sidecar proxy
carbonio-files.service loaded active running Carbonio Files daemon
carbonio-mailbox-admin-sidecar.service loaded active running Carbonio Mailbox Admin proxy sidecar
carbonio-mailbox-db-sidecar.service loaded active running Carbonio Mailbox database sidecar
carbonio-mailbox-nslookup-sidecar.service loaded active running Carbonio Mailbox NSLookup proxy sidecar
carbonio-mailbox-sidecar.service loaded active running Mailbox carbonio proxy sidecar
carbonio-message-broker-sidecar.service loaded active running Carbonio message broker sidecar proxy
carbonio-message-broker.service loaded active running Carbonio message broker daemon
carbonio-message-dispatcher-auth-sidecar.service loaded active running Carbonio Message Dispatcher auth sidecar proxy
carbonio-message-dispatcher-auth.service loaded active running Carbonio Message Dispatcher auth daemon
carbonio-message-dispatcher-db-sidecar.service loaded active running Carbonio Message Dispatcher database sidecar
carbonio-message-dispatcher-http-sidecar.service loaded active running Carbonio Message Dispatcher HTTP sidecar proxy
carbonio-message-dispatcher-xmpp-sidecar.service loaded active running Carbonio Message Dispatcher XMPP sidecar proxy
carbonio-message-dispatcher.service loaded active running Carbonio Message Dispatcher daemon
carbonio-mta-sidecar.service loaded active running Carbonio mta sidecar proxy
carbonio-preview-sidecar.service loaded active running Carbonio Preview sidecar proxy
carbonio-preview.service loaded active running Carbonio Preview daemon
carbonio-prometheus-consul-exporter.service loaded active running Carbonio Prometheus Consul exporter
carbonio-prometheus-mysqld-exporter.service loaded active running Carbonio Prometheus MySQL exporter
carbonio-prometheus-nginx-exporter.service loaded active running Carbonio Prometheus NGINX exporter
carbonio-prometheus-node-exporter.service loaded active running Carbonio Prometheus Node Exporter
carbonio-prometheus-openldap-exporter.service loaded active running Carbonio Prometheus OpenLDAP exporter
carbonio-proxy-sidecar.service loaded active running NGINX carbonio proxy sidecar
carbonio-storages-sidecar.service loaded active running Storages-CE sidecar proxy
carbonio-storages.service loaded active running Carbonio Storages-CE daemon
carbonio-tasks-db-sidecar.service loaded active running Carbonio Tasks database sidecar
carbonio-tasks-sidecar.service loaded active running Carbonio Tasks sidecar proxy
carbonio-tasks.service loaded active running Carbonio Tasks daemon
carbonio-user-management-sidecar.service loaded active running Carbonio User Management sidecar proxy
carbonio-user-management.service loaded active running Carbonio User Management daemon
carbonio-videoserver-sidecar.service loaded active running Carbonio Videoserver sidecar proxy
carbonio-videoserver.service loaded active running Zextras Videoserver
carbonio-ws-collaboration-db-sidecar.service loaded active running Carbonio Workstream Collaboration database sidecar
carbonio-ws-collaboration-sidecar.service loaded active running Carbonio Workstream Collaboration sidecar proxy
carbonio-ws-collaboration.service loaded active running Carbonio Workstream Collaboration daemon
carbonio.service loaded active exited LSB: Carbonio Services
LOAD = Reflects whether the unit definition was properly loaded.
ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
SUB = The low-level unit activation state, values depend on unit type.
44 loaded units listed. Pass --all to see loaded but inactive units, too.
To show all installed unit files use 'systemctl list-unit-files'.
-----------------------
root@carbonio:~# systemctl restart carbonio-tasks
root@carbonio:~# systemctl status carbonio-tasks
● carbonio-tasks.service - Carbonio Tasks daemon
Loaded: loaded (/lib/systemd/system/carbonio-tasks.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-tasks.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:20:10 HKT; 8s ago
Main PID: 889676 (carbonio-tasks)
Tasks: 35 (limit: 19057)
Memory: 193.2M
CPU: 5.768s
CGroup: /system.slice/carbonio-tasks.service
├─889676 /bin/bash /usr/bin/carbonio-tasks
└─889677 /opt/zextras/common/bin/java -Djava.net.preferIPv4Stack=true -Xms1024m -Xmx2048m -DTASKS_LOG_LEVEL=warn -jar /usr/share/carbonio/carbonio-tasks.jar
Nov 12 15:20:10 carbonio.arestos.net systemd[1]: Started Carbonio Tasks daemon.
Nov 12 15:20:11 carbonio.arestos.net carbonio-tasks[889677]: 15:20:11.367 [main] WARN c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-max-pool-size from consul
Nov 12 15:20:11 carbonio.arestos.net carbonio-tasks[889677]: 15:20:11.375 [main] WARN c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-min-idle-connections from consul
Nov 12 15:20:12 carbonio.arestos.net carbonio-tasks[889677]: 15:20:12.120 [main] WARN o.jboss.resteasy.resteasy_jaxrs.i18n - RESTEASY002160: Provider instance org.jboss.resteasy.plugins.provid>
root@carbonio:~# systemctl restart carbonio-message-broker
root@carbonio:~# systemctl status carbonio-message-broker
● carbonio-message-broker.service - Carbonio message broker daemon
Loaded: loaded (/lib/systemd/system/carbonio-message-broker.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-message-broker.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:21:05 HKT; 7s ago
Main PID: 890198 (beam.smp)
Tasks: 32 (limit: 19057)
Memory: 143.5M
CPU: 6.602s
CGroup: /system.slice/carbonio-message-broker.service
├─890198 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/beam.smp -W w -MBas ageffcbf -MHas ageffcbf -MBlmbcs 512 -MHlmbcs 512 -MMmcs 30 -pc unicode -P 1048576 -t 5000000 -stbt db>
├─890210 erl_child_setup 32768
├─890231 sh -s disksup
├─890233 /opt/zextras/common/lib/erlang/lib/os_mon-2.9.1/priv/bin/memsup
├─890234 /opt/zextras/common/lib/erlang/lib/os_mon-2.9.1/priv/bin/cpu_sup
├─890242 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/inet_gethost 4
├─890243 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/inet_gethost 4
├─890254 /opt/zextras/common/lib/erlang/erts-14.2.5.2/bin/epmd -daemon
└─890286 /bin/sh -s rabbit_disk_monitor
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.448153+08:00 [info] <0.664.0> started TCP listener on 127.78.0.18:10000
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: completed with 5 plugins.
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> Server startup complete; 5 plugins started.
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_peer_discovery_consul
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_peer_discovery_common
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_management
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_management_agent
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.547683+08:00 [info] <0.518.0> * rabbitmq_web_dispatch
Nov 12 15:21:05 carbonio.arestos.net systemd[1]: Started Carbonio message broker daemon.
Nov 12 15:21:05 carbonio.arestos.net rabbitmq-server[890198]: 2024-11-12 15:21:05.597353+08:00 [info] <0.9.0> Time to start RabbitMQ: 6864 ms
root@carbonio:~# systemctl restart carbonio-ws-collaboration
root@carbonio:~# systemctl status carbonio-ws-collaboration
● carbonio-ws-collaboration.service - Carbonio Workstream Collaboration daemon
Loaded: loaded (/lib/systemd/system/carbonio-ws-collaboration.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-ws-collaboration.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:21:31 HKT; 6s ago
Docs: https://docs.zextras.com/
Main PID: 890400 (carbonio-ws-col)
Tasks: 59 (limit: 19057)
Memory: 1.1G
CPU: 9.334s
CGroup: /system.slice/carbonio-ws-collaboration.service
├─890400 /bin/bash /usr/bin/carbonio-ws-collaboration
└─890404 /opt/zextras/common/bin/java -Djava.net.preferIPv4Stack=true -Xms1024m -Xmx2048m -XX:+UseZGC -jar /usr/share/carbonio/carbonio-ws-collaboration.jar
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.587 INFO o.j.r.plugins.validation.i18n : RESTEASY008550: Unable to find CDI supporting ValidatorFac>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.734 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.738 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.747 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.755 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.757 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.758 INFO o.j.r.plugins.guice.i18n : RESTEASY011020: registering factory for com.zextras.carbon>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.775 INFO .e.j.e.s.ServletContextHandler : Started oeje10s.ServletContextHandler@3cb6e0ee{ROOT,/,b=nu>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.782 INFO o.e.j.s.AbstractConnector : Started ServerConnector@78d5654b{HTTP/1.1, (http/1.1)}{127>
Nov 12 15:21:36 carbonio.arestos.net carbonio-ws-collaboration[890404]: 12-11-2024 15:21:36.784 INFO o.eclipse.jetty.server.Server : Started oejs.Server@590d6c76{STARTING}[12.0.8,sto=0] @5154>
root@carbonio:~# systemctl restart carbonio-videoserver
root@carbonio:~# systemctl status carbonio-videoserver
● carbonio-videoserver.service - Zextras Videoserver
Loaded: loaded (/lib/systemd/system/carbonio-videoserver.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/carbonio-videoserver.service.d
└─override.conf
Active: active (running) since Tue 2024-11-12 15:21:50 HKT; 7s ago
Main PID: 890811 (janus)
Tasks: 48
Memory: 5.3M
CPU: 44ms
CGroup: /system.slice/carbonio-videoserver.service
└─890811 /opt/zextras/common/bin/janus
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: Loading transport plugin 'libjanus_websockets.so'...
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: [WARN] libwebsockets has been built without IPv6 support, will bind to IPv4 only
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: libwebsockets logging: 0
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: Websockets server started (port 8188)...
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: JANUS WebSockets transport plugin initialized!
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: Loading transport plugin 'libjanus_rabbitmq.so'...
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: WebSockets thread started
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: RabbitMQ SSL support disabled
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: [WARN] RabbitMQ support disabled for both Janus and Admin API, giving up
Nov 12 15:21:50 carbonio.arestos.net janus[890811]: [WARN] The 'janus.transport.rabbitmq' plugin could not be initialized
Everything is ok but still not working
@nicolas-blanc yes, my syslog has same issue
Nov 12 15:37:35 carbonio mongooseimctl[5067]: when=2024-11-12T07:37:35.880012+00:00 level=error reason="{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"inbox\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"91\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}" pid=<0.82225.0> at=gen_server:error_info/8:1391 client_info="{<0.82242.0>,{<0.82242.0>,[{gen,do_call,4,[{file,\"gen.erl\"},{line,259}]},{gen_server,call,3,[{file,\"gen_server.erl\"},{line,415}]},{mongoose_rdbms,execute_successfully,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,271}]},{mod_inbox_rdbms,get_inbox,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/inbox/mod_inbox_rdbms.erl\"},{line,118}]},{timer,tc,4,[{file,\"timer.erl\"},{line,312}]},{mongoose_backend,call_tracked,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_backend.erl\"},{line,97}]},{mod_inbox,process_iq,5,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/inbox/mod_inbox.erl\"},{line,206}]},{mongoose_iq_handler,execute_handler,5,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/mongoose_iq_handler.erl\"},{line,105}]}]}}" last_message="{sql_cmd,{sql_execute,inbox_lookup_desc_no_bin,[<<\"10dbe6d6-984d-4578-9be5-d9218fa2b4c1\">>,<<\"carbonio\">>]},-576372244073}" state={state,<0.82226.0>,#{},30,5000} log= name=wpool_pool-mongoose_wpool$rdbms$global$default-2 label={gen_server,terminate}
Nov 12 15:37:35 carbonio mongooseimctl[5067]: when=2024-11-12T07:37:35.881460+00:00 level=error pid=<0.82225.0> at=proc_lib:crash_report/4:584 report="[[{initial_call,{wpool_process,init,['Argument__1']}},{pid,<0.82225.0>},{registered_name,'wpool_pool-mongoose_wpool$rdbms$global$default-2'},{error_info,{error,{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"inbox\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"91\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{ancestors,['wpool_pool-mongoose_wpool$rdbms$global$default-process-sup','mongoose_wpool$rdbms$global$default',mongoose_wpool_rdbms_sup,mongoose_wpool_sup,ejabberd_sup,<0.285.0>]},{message_queue_len,1},{messages,[{'EXIT',<0.82226.0>,normal}]},{links,[<0.28444.0>]},{dictionary,[{wpool_task,{undefined,1731397055,{call,{sql_cmd,{sql_execute,inbox_lookup_desc_no_bin,[<<\"10dbe6d6-984d-4578-9be5-d9218fa2b4c1\">>,<<\"carbonio\">>]},-576372244073}}}}]},{trap_exit,true},{status,running},{heap_size,10958},{stack_size,28},{reductions,42739}],[]]" label={proc_lib,crash}
Nov 12 15:37:35 carbonio mongooseimctl[5067]: when=2024-11-12T07:37:35.882259+00:00 level=error pid=<0.28444.0> at=supervisor:do_restart/3:744 report="[{supervisor,{local,'wpool_pool-mongoose_wpool$rdbms$global$default-process-sup'}},{errorContext,child_terminated},{reason,{{badmatch,{error,{error,error,<<\"42P01\">>,undefined_table,<<\"relation \\\"inbox\\\" does not exist\">>,[{file,<<\"parse_relation.c\">>},{line,<<\"1449\">>},{position,<<\"91\">>},{routine,<<\"parserOpenTable\">>},{severity,<<\"ERROR\">>}]}}},[{mongoose_rdbms,prepare_statement,2,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,894}]},{mongoose_rdbms,sql_execute,4,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,865}]},{mongoose_rdbms,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/src/rdbms/mongoose_rdbms.erl\"},{line,677}]},{wpool_process,handle_call,3,[{file,\"/tmp/package/src/MongooseIM-6.2.1/_build/default/lib/worker_pool/src/wpool_process.erl\"},{line,225}]},{gen_server,try_handle_call,4,[{file,\"gen_server.erl\"},{line,1131}]},{gen_server,handle_msg,6,[{file,\"gen_server.erl\"},{line,1160}]},{proc_lib,init_p_do_apply,3,[{file,\"proc_lib.erl\"},{line,241}]}]}},{offender,[{pid,<0.82225.0>},{id,'wpool_pool-mongoose_wpool$rdbms$global$default-2'},{mfargs,{wpool_process,start_link,['wpool_pool-mongoose_wpool$rdbms$global$default-2',mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"25dfce98fe3233a0d751c26da5011d6d\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000},[{queue_manager,'wpool_pool-mongoose_wpool$rdbms$global$default-queue-manager'},{time_checker,'wpool_pool-mongoose_wpool$rdbms$global$default-time-checker'},{max_overrun_warnings,infinity},{overrun_handler,{error_logger,warning_report}},{overrun_warning,infinity},{pool_sup_shutdown,infinity},{queue_type,fifo},{worker,{mongoose_rdbms,#{driver => pgsql,port => 20000,host => \"127.78.0.10\",password => \"25dfce98fe3233a0d751c26da5011d6d\",username => \"carbonio-message-dispatcher-db\",database => \"carbonio-message-dispatcher-db\",keepalive_interval => 30,max_start_interval => 30,query_timeout => 5000}}},{worker_opt,[]},{workers,10}]]}},{restart_type,permanent},{significant,false},{shutdown,5000},{child_type,worker}]}]" label={supervisor,child_terminated}
Nov 12 15:37:35 carbonio mongooseimctl[5067]: 15:37:35.880 [error] gen_server 'wpool_pool-mongoose_wpool$rdbms$global$default-2' terminated with reason: no match of right hand value {error,{error,error,<<"42P01">>,undefined_table,<<"relation \"inbox\" does not exist">>,[{file,<<"parse_relation.c">>},{line,<<"1449">>},{position,<<"91">>},{routine,<<"parserOpenTable">>},{severity,<<"ERROR">>}]}} in mongoose_rdbms:prepare_statement/2 line 894
Hi Sharif,
After a hard battle with the logs, and digging into your documentations, i found a thread between you and Anahuac (Upgradation From Carbonio CE 23.11.0 to 23.12.0 Workstream Collaboration – Install & Setup – Zextras Forum). Where Anahuac said :
carbonio-message-dispatcher-migration This one is the tricky one. If it fails you must wait like 5 minutes and try again. There is something running in background that takes that time to be done and allow it to run successfully. So, insist running it till it works: PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000
So, i did as explained (replaced $DB_ADM_PWD by the passwd i got from first installation). And try each 5 minutes for 20 minutes until it succeed. After that, everything worked fine !
@quang-sang, before launching the command i did a sudo -i
Have a nice day !
Hi,
Glad to know that you fixed it.
Thanks for your insight and feedback.
Have a good day 😊
Regards,
Sharif