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

[Bogdan-Andrei Iancu]

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 Developer
http://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 list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131022/8cc1ea4a/attachment-0001.htm>