Re: [SR-Users] db_mongodb get columns error
Hi, Sorry not to have answered before, I just did a restart and there was no error. We don't restart often so I can't tell you how often this issue appears but I will keep an eye on it. It may be a bug in the insert or update code in db_mongodb that misses the caller_sock column but I'm not sure. Is it possible a dialog is inserted without caller_sock field? Or, is it possible $unset is used somewhere for the caller_sock? Mickael From: Daniel-Constantin Mierla [mailto:mico...@gmail.com] Sent: Thursday, May 07, 2015 10:23 AM To: Kamailio (SER) - Users Mailing List; Mickael Marrache Subject: Re: [SR-Users] db_mongodb get columns error Hello, On 27/04/15 23:46, Daniel-Constantin Mierla wrote: Hello, On 22/04/15 14:00, Mickael Marrache wrote: Hi, After restarting Kamailio, I got the following errors during the startup: kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:381]: db_mongodb_get_columns(): field [caller_sock] not found in result iterator kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:739]: db_mongodb_store_result(): failed to set the columns kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:918]: db_mongodb_query(): failed to store result kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:927]: db_mongodb_query(): failed to do the query kamailio[12614]: ERROR: dialog [dlg_db_handler.c:257]: select_entire_dialog_table(): Error while querying database What may be causing the issue? I should always have a caller_sock in every dialog document. the error is thrown when the caller_sock field is not found in the b/json document returned by mongodb. Do you get the error every time you restart? Any update on this? As I am spending some time with testing for 4.3, I would like to close this issue if there is something to fix. Cheers, Daniel -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] db_mongodb get columns error
Hello, On 27/04/15 23:46, Daniel-Constantin Mierla wrote: Hello, On 22/04/15 14:00, Mickael Marrache wrote: Hi, After restarting Kamailio, I got the following errors during the startup: kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:381]: db_mongodb_get_columns(): field [caller_sock] not found in result iterator kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:739]: db_mongodb_store_result(): failed to set the columns kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:918]: db_mongodb_query(): failed to store result kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:927]: db_mongodb_query(): failed to do the query kamailio[12614]: ERROR: dialog [dlg_db_handler.c:257]: select_entire_dialog_table(): Error while querying database What may be causing the issue? I should always have a caller_sock in every dialog document. the error is thrown when the caller_sock field is not found in the b/json document returned by mongodb. Do you get the error every time you restart? Any update on this? As I am spending some time with testing for 4.3, I would like to close this issue if there is something to fix. Cheers, Daniel -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] db_mongodb get columns error
Hello, On 07/05/15 09:29, Mickael Marrache wrote: Hi, Sorry not to have answered before, I just did a restart and there was no error. We don't restart often so I can't tell you how often this issue appears but I will keep an eye on it. It may be a bug in the insert or update code in db_mongodb that misses the caller_sock column but I'm not sure. Is it possible a dialog is inserted without caller_sock field? Or, is it possible $unset is used somewhere for the caller_sock? iirc, the socket for both caller and callee should be set when the dialog is inserted. Cheers, Daniel Mickael *From:*Daniel-Constantin Mierla [mailto:mico...@gmail.com] *Sent:* Thursday, May 07, 2015 10:23 AM *To:* Kamailio (SER) - Users Mailing List; Mickael Marrache *Subject:* Re: [SR-Users] db_mongodb get columns error Hello, On 27/04/15 23:46, Daniel-Constantin Mierla wrote: Hello, On 22/04/15 14:00, Mickael Marrache wrote: Hi, After restarting Kamailio, I got the following errors during the startup: kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:381]: db_mongodb_get_columns(): field [caller_sock] not found in result iterator kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:739]: db_mongodb_store_result(): failed to set the columns kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:918]: db_mongodb_query(): failed to store result kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:927]: db_mongodb_query(): failed to do the query kamailio[12614]: ERROR: dialog [dlg_db_handler.c:257]: select_entire_dialog_table(): Error while querying database What may be causing the issue? I should always have a caller_sock in every dialog document. the error is thrown when the caller_sock field is not found in the b/json document returned by mongodb. Do you get the error every time you restart? Any update on this? As I am spending some time with testing for 4.3, I would like to close this issue if there is something to fix. Cheers, Daniel -- Daniel-Constantin Mierla http://twitter.com/#!/miconda http://twitter.com/#%21/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] db_mongodb get columns error
Hello, On 22/04/15 14:00, Mickael Marrache wrote: Hi, After restarting Kamailio, I got the following errors during the startup: kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:381]: db_mongodb_get_columns(): field [caller_sock] not found in result iterator kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:739]: db_mongodb_store_result(): failed to set the columns kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:918]: db_mongodb_query(): failed to store result kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:927]: db_mongodb_query(): failed to do the query kamailio[12614]: ERROR: dialog [dlg_db_handler.c:257]: select_entire_dialog_table(): Error while querying database What may be causing the issue? I should always have a caller_sock in every dialog document. the error is thrown when the caller_sock field is not found in the b/json document returned by mongodb. Do you get the error every time you restart? Cheers, Daniel -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] db_mongodb get columns error
Hi, After restarting Kamailio, I got the following errors during the startup: kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:381]: db_mongodb_get_columns(): field [caller_sock] not found in result iterator kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:739]: db_mongodb_store_result(): failed to set the columns kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:918]: db_mongodb_query(): failed to store result kamailio[12614]: ERROR: db_mongodb [mongodb_dbase.c:927]: db_mongodb_query(): failed to do the query kamailio[12614]: ERROR: dialog [dlg_db_handler.c:257]: select_entire_dialog_table(): Error while querying database What may be causing the issue? I should always have a caller_sock in every dialog document. Thanks, Mickael ___ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users