<div dir="ltr"><div><div dir="ltr"><div>Hello,</div><div><br></div><div>On 1.9 I'm seeing the following problem loading the dialog table from dbtext at startup:</div><div><br></div></div></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div><div><div><div>DBG:db_text:dbt_load_file: request for table [dialog]</div></div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext]</div></div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog]</div>
</div></div></div><div><div><div><div>DBG:db_text:dbt_table_new: mtime is 1382412942</div></div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: column[0] is BIGINT!</div></div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: error at row=0 col=0 c=a</div>
</div></div></div><div><div><div><div>ERROR:db_text:dbt_query: table does not exist!</div></div></div></div><div><div><div><div>ERROR:dialog:select_entire_dialog_table: Error while querying database</div></div></div></div>
<div><div><div><div>ERROR:db_text:dbt_free_result: invalid parameter value</div></div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: request for table [dialog]</div></div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext]</div>
</div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog]</div></div></div></div><div><div><div><div>DBG:db_text:dbt_table_new: mtime is 1382412942</div></div></div></div>
<div><div><div><div>DBG:db_text:dbt_load_file: column[0] is BIGINT!</div></div></div></div><div><div><div><div>DBG:db_text:dbt_load_file: error at row=0 col=0 c=a</div></div></div></div><div><div><div><div>ERROR:db_text:dbt_delete: failed to load table <dialog>!</div>
</div></div></div><div><div><div><div>ERROR:dialog:remove_all_dialogs_from_db: failed to delete database information</div></div></div></div><div><div><div><div>WARNING:dialog:init_dlg_db: failed to properly remove all the dialogs form DB</div>
</div></div></div></blockquote><div><div dir="ltr"><div><br></div><div>The contents of the dialog file are from the source tree file scripts/dbtext/opensips/dialog:</div><div><br></div></div></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div><div dir="ltr"><div>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)</div>
</div></div></blockquote><div><div dir="ltr"><div><br></div><div>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.</div>
<div><br></div><div>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. </div>
<div><br></div><div>Any thought what might cause the 'auto' flag to throw an error in this environment?</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div></div></div>
</div>