<div dir="ltr">Hi Bogdan,<div><br></div><div>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.</div><div>
<br></div><div>I'll start a new thread soon with the dialog restore problem.</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Tue, Oct 22, 2013 at 9:37 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div text="#000000" bgcolor="#ffffff">
Hi Jeff,<br>
<br>
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.<br>
<br>
So, let's move the next issue, when auto is removed :)<br>
<br>
Regards,<br>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre><div><div class="h5">
<br>
On 10/22/2013 06:55 AM, Jeff Pyle wrote:
</div></div><blockquote type="cite"><div><div class="h5">
<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:0pt 0pt 0pt 40px;border:medium 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:0pt 0pt 0pt 40px;border:medium 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>
</div></div><pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
</blockquote></div><br></div></div>