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

[Jeff Pyle]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131021/5673cded/attachment.htm>