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"><<a href="mailto:razvancrainea@opensips.org">razvancrainea@opensips.org</a>></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"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></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"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></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:
                              <accX_flags> value: <#026><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
                              <accX_flags##026> (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:
                              <accX_db> value: <(><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"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></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'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"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></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't properly
                                                serialized. What I'm
                                                trying to find out is
                                                why this happens, that's
                                                why I will need some
                                                extra debug as I can't
                                                figure out the problem
                                                there. So please apply
                                                this last patch and try
                                                again. It should be
                                                applied after the
                                                previous patch I've sent
                                                you, so you won'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:
                                                    <accX_flags>
                                                    value: <#026></tt><br>
                                                  <br>
                                                </div>
                                                and
                                                <div><br>
                                                  <br>
                                                  <tt>DBG:dialog:write_pair:
                                                    Dumping var name:
                                                    <accX_db>
                                                    value: <(></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:
                                                        <accX_flags>
                                                        value:
                                                        <#026><br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Serialized
                                                        string
                                                        <accX_flags##026>
                                                        (16)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Dumping var
                                                        name:
                                                        <accX_db>
                                                        value: <(><br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Serialized
                                                        string
                                                        <accX_db#(>
                                                        (263)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Dumping var
                                                        name:
                                                        <accX_leg>
                                                        value: <><br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Serialized
                                                        string
                                                        <accX_leg#>
                                                        (14)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Dumping var
                                                        name:
                                                        <accX_core>
                                                        value:
                                                        <#006><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
                                                        <accX_core##006>
                                                        (165)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Dumping var
                                                        name:
                                                        <accX_created>
                                                        value:
                                                        <<95>+ÃN><br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Serialized
                                                        string
                                                        <accX_created#<95>+ÃN>
                                                        (22)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_dialog_vars:
                                                        var string is
                                                        <accX_flags##026>(480)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Dumping var
                                                        name:
                                                        <carrierChannels>
                                                        value:
                                                        <1002><br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Serialized
                                                        string
                                                        <carrierChannels#1002|>
                                                        (21)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Dumping var
                                                        name:
                                                        <carrierChannels>
                                                        value:
                                                        <1003><br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Serialized
                                                        string
                                                        <carrierChannels#1003|>
                                                        (21)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Dumping var
                                                        name:
                                                        <carrierChannels>
                                                        value:
                                                        <1007><br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_pair:
                                                        Serialized
                                                        string
                                                        <carrierChannels#1007|>
                                                        (21)<br>
                                                        Dec  6 20:20:13
                                                        dev
                                                        /usr/local/sbin/opensips[15700]:
                                                        DBG:dialog:write_dialog_profiles:
                                                        profile string
                                                        is
<carrierChannels#1002|carrierChannels#1003|carrierChannels#1007|>(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"><<a href="mailto:razvancrainea@opensips.org" target="_blank">razvancrainea@opensips.org</a>></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'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>