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 [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
