<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body 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 class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 10/22/2013 06:55 AM, Jeff Pyle wrote:
<blockquote
cite="mid:CACYJG3L4X5C6AgNMhEy38P-7wR0HGM7Bd2afojb8DLOYc4MaoA@mail.gmail.com"
type="cite">
<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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>