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

[Bogdan-Andrei Iancu]

Hi Jeff,

Maybe a different version? - the change was done with 1.9 version.
Previously, the dlg_int was int and auto incremented by DB. Starting
with 1.9 the dlg_int is computed and filled in by OpenSIPS as DB long.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 10/22/2013 05:47 PM, Jeff Pyle wrote:
> Hi Bogdan,
>
> 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.
>
> I'll start a new thread soon with the dialog restore problem.
>
>
> - Jeff
>
>
>
> On Tue, Oct 22, 2013 at 9:37 AM, Bogdan-Andrei Iancu
> <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>
>     Hi Jeff,
>
>     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.
>
>     So, let's move the next issue, when auto is removed :)
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>     OpenSIPS Founder and Developer
>     http://www.opensips-solutions.com
>
>
>     On 10/22/2013 06:55 AM, Jeff Pyle wrote:
>>     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
>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131022/1a1455d8/attachment.htm>