Hi Razwan,<br>This is the pastebin of logs after shutdown:<br><a href="http://pastebin.com/tvmrSqwB">http://pastebin.com/tvmrSqwB</a><br><br>This is the pastebin of logs after start which is huge:<br><a href="http://pastebin.com/C6K4Jt5y">http://pastebin.com/C6K4Jt5y</a><br>
<br>--- Jayesh<br><br><br><div class="gmail_quote">On Wed, Dec 7, 2011 at 5:46 PM, Razvan Crainea <span dir="ltr">&lt;<a href="mailto:razvancrainea@opensips.org">razvancrainea@opensips.org</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    Hi, Jayesh!<br>
    <br>
    I need the logs after opensips restarts. The result might also be
    pretty large.<div class="im"><br>
    <br>
    Regards,<br>
    <pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
    <br></div><div><div class="h5">
    On 12/07/2011 02:14 PM, Jayesh Nambiar wrote:
    <blockquote type="cite">Hi Razwan,<br>
      I have applied the patch and made it working. Do you still only
      need the logs after opensips shutdown or also the logs after
      opensips restarts.<br>
      <br>
      --- Jayesh<br>
      <br>
      <div class="gmail_quote">On Wed, Dec 7, 2011 at 4:35 PM, Razvan
        Crainea <span dir="ltr">&lt;<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>&gt;</span>
        wrote:<br>
        <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
          <div bgcolor="#FFFFFF" text="#000000"> Hi, Jayesh!<br>
            <br>
            It seems like the problem appears while parsing the string
            got from the database, so after opensips is restarted. The
            patch attached should give us more information about the
            error.
            <div><br>
              <br>
              Regards,<br>
              <pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
              <br>
            </div>
            <div>
              <div> On 12/07/2011 12:37 PM, Jayesh Nambiar
                wrote:
                <blockquote type="cite">This is the string what I see
                  when I query the dialog table for vars:<br>
                  <br>
                  accX_flags#   |accX_db#(  2 1<br>
                   1000000001 1002<br>
                                   12013386166<br>
                   919833171405 0 203.153.53.158 203.153.53.136 0 17 0 2
                  IP India - Mobile 919 9198 2 1 2 4 0.0150 0.0130 0
                  0.0000 0.0226 1.0000 6 1 6 1 1 2 2 2<br>
                   Aal Izz Well<br>
                   Aal Izz Well 1 3 1.2.3.4|accX_leg#    |accX_core#
                  INVITE/
                  100eb870-9e3599cb-13c4-50029-3b71-60de50d0-3b71\#
                  97.208.30.751120+1+31850054+b8c0a68/
                  100f7670-9e3599cb-13c4-50029-3b71-3c625412-3b71 200 O
                  Ã¡=ÃN    |accX_created#Ã=ÃN    |<br>
                  <br>
                  --- Jayesh<br>
                  <br>
                  <div class="gmail_quote">On Wed, Dec 7, 2011 at 4:00
                    PM, Razvan Crainea <span dir="ltr">&lt;<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>&gt;</span>
                    wrote:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div bgcolor="#FFFFFF" text="#000000"> Hi, Jayesh!<br>
                        <br>
                        And what is the string in the database? You can
                        see it in the database after you kill opensips
                        with the following command:<br>
                        <br>
                        <tt>select vars from dialog;</tt>
                        <div><br>
                          <br>
                          Regards,<br>
                          <pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
                          <br>
                        </div>
                        <div>
                          <div> On 12/07/2011 12:24 PM, Jayesh Nambiar
                            wrote:
                            <blockquote type="cite">Hi Razvan,<br>
                              Applied the patch and re-tested it. Here
                              the logs that you are interested in
                              specifically:<br>
                              <br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: Dumping var name:
                              &lt;accX_flags&gt; value: &lt;#026&gt;<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: compare char 22 - 0
                              - 11<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: compare char 0 - 1
                              - 12<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: compare char 0 - 2
                              - 13<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: compare char 0 - 3
                              - 14<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: Serialized string
                              &lt;accX_flags##026&gt; (16)<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 0) char: a hex: 61<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 1) char: c hex: 63<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 2) char: c hex: 63<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 3) char: X hex: 58<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 4) char: _ hex: 5F<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 5) char: f hex: 66<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 6) char: l hex: 6C<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 7) char: a hex: 61<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 8) char: g hex: 67<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 9) char: s hex: 73<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 10) char: # hex: 23<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 11) char: #026 hex:
                              16<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 12) char: #000 hex:
                              00<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 13) char: #000 hex:
                              00<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 14) char: #000 hex:
                              00<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: 15) char: | hex: 7C<br>
                              Dec  7 15:50:33 dev
                              /usr/local/sbin/opensips[8011]:
                              DBG:dialog:write_pair: Dumping var name:
                              &lt;accX_db&gt; value: &lt;(&gt;<br>
                              <br>
                              Apart from this, I have pasted everything
                              in syslog after opensips shutdown in the
                              paste-bin here:<br>
                              <a href="http://pastebin.com/gx0ZxFLb" target="_blank">http://pastebin.com/gx0ZxFLb</a><br>
                              <br>
                              Let me know if there is anything more to
                              test.<br>
                              <br>
                              --- Jayesh<br>
                              <br>
                              <div class="gmail_quote">On Wed, Dec 7,
                                2011 at 3:36 PM, Razvan Crainea <span dir="ltr">&lt;<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>&gt;</span>
                                wrote:<br>
                                <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                  <div bgcolor="#FFFFFF" text="#000000">
                                    Sorr, I forgot to attach it. Here it
                                    is.
                                    <div><br>
                                      <br>
                                      Regards,<br>
                                      <pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
                                      <br>
                                    </div>
                                    <div>
                                      <div> On 12/07/2011 11:59 AM,
                                        Jayesh Nambiar wrote:
                                        <blockquote type="cite">Hi
                                          Razvan,<br>
                                          I don&#39;t see the patch attached
                                          !!<br>
                                          <br>
                                          --- Jayesh<br>
                                          <br>
                                          <div class="gmail_quote">On
                                            Wed, Dec 7, 2011 at 2:57 PM,
                                            Razvan Crainea <span dir="ltr">&lt;<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>&gt;</span>
                                            wrote:<br>
                                            <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                              <div bgcolor="#FFFFFF" text="#000000"> Hi,
                                                Jayesh !<br>
                                                <br>
                                                The root of the problem
                                                is the accX_flags dialog
                                                variable isn&#39;t properly
                                                serialized. What I&#39;m
                                                trying to find out is
                                                why this happens, that&#39;s
                                                why I will need some
                                                extra debug as I can&#39;t
                                                figure out the problem
                                                there. So please apply
                                                this last patch and try
                                                again. It should be
                                                applied after the
                                                previous patch I&#39;ve sent
                                                you, so you won&#39;t need
                                                another fresh checkout.<br>
                                                This time there will be
                                                a lot of dumped info in
                                                the log, so I would
                                                really appreciate if you
                                                could send them over
                                                pastebin. The only part
                                                that I will be
                                                interested in is between
                                                these lines:
                                                <div><br>
                                                  <br>
                                                  <tt>DBG:dialog:write_pair:
                                                    Dumping var name:
                                                    &lt;accX_flags&gt;
                                                    value: &lt;#026&gt;</tt><br>
                                                  <br>
                                                </div>
                                                and
                                                <div><br>
                                                  <br>
                                                  <tt>DBG:dialog:write_pair:
                                                    Dumping var name:
                                                    &lt;accX_db&gt;
                                                    value: &lt;(&gt;</tt><br>
                                                  <br>
                                                </div>
                                                Thank you very much for
                                                testing! <br>
                                                <div> Regards,<br>
                                                  <pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
                                                  <br>
                                                </div>
                                                <div>
                                                  <div> On 12/06/2011
                                                    07:57 PM, Jayesh
                                                    Nambiar wrote:
                                                    <blockquote type="cite">Hi
                                                      Razvan,<br>
                                                      I just did a fresh
                                                      download from <a href="http://opensips.org/pub/opensips/latest/src/" target="_blank">http://opensips.org/pub/opensips/latest/src/</a>.
                                                      I did apply the
                                                      patch successfully
                                                      and I still have
                                                      the problem of CDR
                                                      not being recorded
                                                      after restart.
                                                      Here is the syslog
                                                      pasted after
                                                      opensips was being
                                                      shut down:<br>
                                                      <br>
                                                      Dec  6 20:20:13
                                                      dev
                                                      /usr/local/sbin/opensips[
                                                      <div>15700]:
                                                        DBG:dialog:dialog_update_db:
                                                        inserting new
                                                        dialog
                                                        0x7f3d323bd5f8<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;accX_flags&gt;
                                                        value:
                                                        &lt;#026&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;accX_flags##026&gt;
                                                        (16)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;accX_db&gt;
                                                        value: &lt;(&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;accX_db#(&gt;
                                                        (263)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;accX_leg&gt;
                                                        value: &lt;&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;accX_leg#&gt;
                                                        (14)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;accX_core&gt;
                                                        value:
                                                        &lt;#006&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        escaping char 53<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;accX_core##006&gt;
                                                        (165)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;accX_created&gt;
                                                        value:
                                                        &lt;&lt;95&gt;+ÃN&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;accX_created#&lt;95&gt;+ÃN&gt;
                                                        (22)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_dialog_vars:

                                                        var string is
                                                        &lt;accX_flags##026&gt;(480)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;carrierChannels&gt;
                                                        value:
                                                        &lt;1002&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;carrierChannels#1002|&gt;
                                                        (21)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;carrierChannels&gt;
                                                        value:
                                                        &lt;1003&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;carrierChannels#1003|&gt;
                                                        (21)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Dumping var
                                                        name:
                                                        &lt;carrierChannels&gt;
                                                        value:
                                                        &lt;1007&gt;<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:

                                                        Serialized
                                                        string
                                                        &lt;carrierChannels#1007|&gt;
                                                        (21)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_dialog_profiles:


                                                        profile string
                                                        is
&lt;carrierChannels#1002|carrierChannels#1003|carrierChannels#1007|&gt;(63)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:db_mysql:has_stmt_ctx:

                                                        ctx found for
                                                        dialog<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:db_mysql:db_mysql_do_prepared_query:


                                                        conn=0x810858
                                                        (tail=8454488)
                                                        MC=0x8101b8<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:db_mysql:db_mysql_do_prepared_query:


                                                        set values for
                                                        the statement
                                                        run<br>
                                                        <br>
                                                        I hope this will
                                                        help you figure
                                                        out something
                                                        more relevant.
                                                        <div>
                                                          <div> <img src="http://images/cleardot.gif"></div>
                                                        </div>
                                                        <span><font color="#888888"><br>
                                                          <br>
                                                          --- Jayesh</font></span>
                                                        <div>
                                                          <div><br>
                                                          <br>
                                                          <div class="gmail_quote">On

                                                          Tue, Dec 6,
                                                          2011 at 7:56
                                                          PM, Razvan
                                                          Crainea <span dir="ltr">&lt;<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>&gt;</span>
                                                          wrote:<br>
                                                          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                                          <div bgcolor="#FFFFFF">
                                                          Hi, Jayesh!<br>
                                                          <br>
                                                          Can you post
                                                          your
                                                          dlg_db_handler.c
                                                          file on
                                                          pastebin? I
                                                          think you are
                                                          using an old
                                                          version of the
                                                          dialog module,
                                                          and that&#39;s why
                                                          you have this
                                                          problem.
                                                          <div><br>
                                                          <br>
                                                          Regards,<br>
                                                          <pre cols="72">--
Răzvan Crainea
OpenSIPS Developer</pre>
                                                          </div>
                                                          </div>
                                                          </blockquote>
                                                          </div>
                                                          </div>
                                                        </div>
                                                      </div>
                                                    </blockquote>
                                                  </div>
                                                </div>
                                              </div>
                                            </blockquote>
                                          </div>
                                          <br>
                                        </blockquote>
                                      </div>
                                    </div>
                                  </div>
                                </blockquote>
                              </div>
                              <br>
                            </blockquote>
                          </div>
                        </div>
                      </div>
                    </blockquote>
                  </div>
                  <br>
                </blockquote>
              </div>
            </div>
          </div>
        </blockquote>
      </div>
      <br>
    </blockquote>
  </div></div></div>

</blockquote></div><br>