[OpenSIPS-Users] dbtext problem with dialog table initialization on Voyage Linux

[Jeff Pyle]

Hi Bogdan,

Perfect.  Strange that it continues to work on the "full" system with
'auto'.  I thought for sure it was something to do with the embedded Atom
box.

I'll start a new thread soon with the dialog restore problem.


- Jeff



On Tue, Oct 22, 2013 at 9:37 AM, Bogdan-Andrei Iancu <bogdan at opensips.org>wrote:

> **
> Hi Jeff,
>
> Indeed, the flag "auto" should not be there starting with 1.9 . It seems
> DB_TEXT spec file was not updated :(, but I took care of that now - GIT is
> up to date.
>
> So, let's move the next issue, when auto is removed :)
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>
>
> On 10/22/2013 06:55 AM, Jeff Pyle wrote:
>
>   Hello,
>
>  On 1.9 I'm seeing the following problem loading the dialog table from
> dbtext at startup:
>
>     DBG:db_text:dbt_load_file: request for table [dialog]
>    DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext]
>    DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog]
>    DBG:db_text:dbt_table_new: mtime is 1382412942
>    DBG:db_text:dbt_load_file: column[0] is BIGINT!
>    DBG:db_text:dbt_load_file: error at row=0 col=0 c=a
>    ERROR:db_text:dbt_query: table does not exist!
>    ERROR:dialog:select_entire_dialog_table: Error while querying database
>    ERROR:db_text:dbt_free_result: invalid parameter value
>    DBG:db_text:dbt_load_file: request for table [dialog]
>    DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext]
>    DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog]
>    DBG:db_text:dbt_table_new: mtime is 1382412942
>    DBG:db_text:dbt_load_file: column[0] is BIGINT!
>    DBG:db_text:dbt_load_file: error at row=0 col=0 c=a
>    ERROR:db_text:dbt_delete: failed to load table <dialog>!
>    ERROR:dialog:remove_all_dialogs_from_db: failed to delete database
> information
>    WARNING:dialog:init_dlg_db: failed to properly remove all the dialogs
> form DB
>
>
>  The contents of the dialog file are from the source tree file
> scripts/dbtext/opensips/dialog:
>
>    dlg_id(long,auto) callid(string) from_uri(string) from_tag(string)
> to_uri(string) to_tag(string) mangled_from_uri(string,null)
> mangled_to_uri(string,null) caller_cseq(string) callee_cseq(string)
> caller_ping_cseq(int) callee_ping_cseq(int) caller_route_set(string,null)
> callee_route_set(string,null) caller_contact(string) callee_contact(string)
> caller_sock(string) callee_sock(string) state(int) start_time(int)
> timeout(int) vars(string,null) profiles(string,null) script_flags(int)
> flags(int)
>
>
>  Above I see "error at row=0 col=0 c=a" which leads me to believe it
> doesn't like the 'auto' in the dlg_id declaration.  Indeed, if I remove the
> 'auto' flag it starts okay.  But dialogs saved to the table don't match if
> Opensips has been restarted during the dialog's life.  I don't know if this
> is related to the absence of the 'auto' flag.  One problem at a time.
>
>  This is on Voyage Linux 0.9 64-bit on an Intel Atom board.  Exactly the
> same Opensips .deb packages with exactly the same dbtext directory running
> on a "normal" Debian 7 system do not cause this error.  The only difference
> I am aware of is on the Voyage/Atom system the dbtext directory is in a
> ramdisk while on the Debian 7 system it's on a normal disk.
>
>  Any thought what might cause the 'auto' flag to throw an error in this
> environment?
>
>
>  - Jeff
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131022/82982e73/attachment-0001.htm>