<div dir="ltr"><div>mysql> desc version;<br>+---------------+------------------+------+-----+---------+-------+<br>| Field         | Type             | Null | Key | Default | Extra |<br>+---------------+------------------+------+-----+---------+-------+<br>| table_name    | varchar(32)      | NO   | PRI | NULL    |       |<br>| table_version | int(10) unsigned | NO   |     | 0       |       |<br>+---------------+------------------+------+-----+---------+-------+<br>2 rows in set (0.00 sec)<br>mysql> select count(*) from version;<br>+----------+<br>| count(*) |<br>+----------+<br>|       26 |<br>+----------+<br>1 row in set (0.00 sec)<br><br>mysql> select * from version;<br>+-----------------+---------------+<br>| table_name      | table_version |<br>+-----------------+---------------+<br>| acc             |             4 |<br>| acc_cdrs        |             1 |<br>| address         |             6 |<br>| aliases         |             6 |<br>| dbaliases       |             1 |<br>| dialog          |             7 |<br>| dialog_vars     |             1 |<br>| dialplan        |             1 |<br>| dispatcher      |             4 |<br>| domain          |             2 |<br>| domain_attrs    |             1 |<br>| grp             |             2 |<br>| lcr_gw          |             3 |<br>| lcr_rule        |             2 |<br>| lcr_rule_target |             1 |<br>| location        |             6 |<br>| location_attrs  |             1 |<br>| missed_calls    |             3 |<br>| pdt             |             1 |<br>| re_grp          |             1 |<br>| silo            |             7 |<br>| speed_dial      |             2 |<br>| subscriber      |             6 |<br>| trusted         |             5 |<br>| uri             |             1 |<br>| usr_preferences |             2 |<br>+-----------------+---------------+<br>26 rows in set (0.01 sec)<br>mysql> select count(*) from dispatcher;<br>+----------+<br>| count(*) |<br>+----------+<br>|        1 |<br>+----------+<br>1 row in set (0.01 sec)<br><br><br> # ----- dispatcher params -----<br> modparam("dispatcher", "db_url", DBURL)<br><br></div>I try local & remote db at the same time, all do not work.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2014-10-21 6:47 GMT+08:00 Gonzalo Gasca <span dir="ltr"><<a href="mailto:gascagonzalo@gmail.com" target="_blank">gascagonzalo@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Hi Shuntongzhang,<br><br></div>As Daniel mentioned we can see the error during<b> pkg_malloc</b><br>db_res.c: db_new_result(112) (db_res.c#L112)<br><br><a href="https://github.com/kamailio/kamailio/blob/fcdf5f9cfff634ebfa736d7084d5e5483a36355b/lib/srdb1/db_res.c#L112" target="_blank">https://github.com/kamailio/kamailio/blob/fcdf5f9cfff634ebfa736d7084d5e5483a36355b/lib/srdb1/db_res.c#L112</a><br><br></div>As I mentioned before can you provide the results of the query for version table and dispatcher table. Seems to be an issue storing the results<span class=""><br><br>        __FUNCTION__ = "db_mysql_store_result"<br>#7  0x00007ffff5fd3516
 in db_do_query_internal (_h=0x7ffff6cb4e78, _k=0x7fffffffdf70, _op=0x0,
 _v=0x7fffffffdf40, _c=0x7fffffffdf60, _n=1, _nc=1, _o=0x0, <br>    
_r=0x7fffffffdf38, val2str=0x7ffff6a39374 <db_mysql_val2str>, 
submit_query=0x7ffff6a2825c <db_mysql_submit_query>, <br>    store_result=0x7ffff6a2998c <db_mysql_store_result>, _l=0) at db_query.c:137<br>   <span style="color:rgb(255,0,0)"><b>     tmp = 32767</b></span><br>        off = 63<br>        ret = 23<br><br></span></div>a) Can you provide the results for:<br><div><div><span class=""><p>mysql -h localhost -P 3306 -u root -p</p><p>mysql> use kamailiodb; <Use your kamailio Db name here></p><p>mysql>desc version;</p>







<p>mysql> select count(*) from version; </p>mysql> select * from version;<br><br></span>mysql> select count(*) from dispatcher;<br><br></div><div>This will help us to see how many entries in dispatcher table.<br><br></div><div>b) Can you provide dispatcher config for kamailio.cfg ?<br></div><div>c) Is the SQL db server local or in a remote server?<span class="HOEnZb"><font color="#888888"><br><br></font></span></div><span class="HOEnZb"><font color="#888888"><div>/G<br></div><div><div><br></div></div></font></span></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 20, 2014 at 8:01 AM, 张顺通 <span dir="ltr"><<a href="mailto:shuntongzhang@gmail.com" target="_blank">shuntongzhang@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I install a rehl 5.7 by myself, kamailio 4.1.6 can run correctly. but it can not run on out company's server which is also rehl 5.7. How to find the problem.I have no idea.<br>anyone can help?<br>thks<br></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2014-10-20 19:39 GMT+08:00 张顺通 <span dir="ltr"><<a href="mailto:shuntongzhang@gmail.com" target="_blank">shuntongzhang@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">db_new_result->pkg_malloc(qm_malloc)->qm_find_free, func qm_find_free return 0, can not find mem when i close memdbg.<br></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2014-10-20 18:57 GMT+08:00 张顺通 <span dir="ltr"><<a href="mailto:shuntongzhang@gmail.com" target="_blank">shuntongzhang@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>rhel5 <br>$cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c<br>     24  Intel(R) Xeon(R) CPU E5-2430 0 @ 2.20GHz<br></div>rhel6<br>cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c<br>     16  Intel(R) Xeon(R) CPU           E5620  @ 2.40GHz<br><br></div>not Embedded
    device, normal server.<br><br><br></div>gdb <br><br>(gdb) f 2<span><br>#2  0x0000000000615b74 in qm_debug_frag (qm=0x7ffff6c55010, f=0x7ffff6cdcf08) at mem/q_malloc.c:161<br></span>161                     abort();<br>(gdb) p *f<br>$1 = {size = 7831720, u = {nxt_free = 0x7ffff6c893f8, is_free = 140737333728248}, file = 0x7ffff6a4c93d "db_mysql: km_my_con.c", <br>  func = 0x758307 "fragm. from qm_malloc", line = 62, check = <a href="tel:4042322160" value="+14042322160" target="_blank">4042322160</a>}<br><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2014-10-20 18:30 GMT+08:00 Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    physical machine is the same? Is it standard OS installation, or
    some customizations (e.g. custom kernel modules, etc.)? Embedded
    device? What CPU?<span><font color="#888888"><br>
    <br>
    Daniel</font></span><div><div><br>
    <br>
    <div>On 20/10/14 12:24, 张顺通 wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">os is rhel.<br>
        rhel6 is ok, rhel5 can not start.<br>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">2014-10-20 18:11 GMT+08:00
          Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000"> What are the
              differences between the server that works and the one that
              doesn't? I mean hardware and operating system details?<br>
              <br>
              Checking quickly the source code and comparing with logs,
              it doesn't reveal any problem -- it is about allocation of
              the next fragment, which was not used at all before, after
              the one allocated previously. The only reason I can think
              of it right now is corrupted memory or faulty OS.<span><font color="#888888"><br>
                </font></span>
              <div><span><font color="#888888"><br>
                    Daniel</font></span>
                <div>
                  <div><br>
                    <br>
                    On 20/10/14 11:56, 张顺通 wrote:<br>
                  </div>
                </div>
              </div>
              <div>
                <div>
                  <blockquote type="cite">
                    <div dir="ltr">
                      <div>4.2 have the same problem.<br>
                      </div>
                      at begin i use 4.1, i think this is a bug in 4.1; 
                      then i use 4.2 to check to see if the problem is
                      solved. problems still in.<br>
                      <div>
                        <div><br>
                          see ka_4_2_0.log <br>
                          <div>​<br>
                            <div class="gmail_chip gmail_drive_chip" style="width:396px;min-height:18px;max-height:18px;background-color:#f5f5f5;padding:5px;color:#222;font-family:arial;font-style:normal;font-weight:bold;font-size:13px;border:1px solid #ddd;line-height:1"><a href="https://docs.google.com/file/d/0B5x1TDtoeVvAckdMbDRmT3E3UjA/edit?usp=drive_web" style="display:inline-block;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;text-decoration:none;padding:1px 0px;border:medium none;width:100%" target="_blank"><img style="vertical-align:bottom;border:none" src="https://ssl.gstatic.com/docs/doclist/images/icon_10_generic_list.png"> <span dir="ltr" style="color:#15c;text-decoration:none;vertical-align:bottom">ka_4_2_0.log</span></a></div>
                            ​<br>
                          </div>
                        </div>
                      </div>
                    </div>
                    <div class="gmail_extra"><br>
                      <div class="gmail_quote">2014-10-20 17:48
                        GMT+08:00 张顺通 <span dir="ltr"><<a href="mailto:shuntongzhang@gmail.com" target="_blank">shuntongzhang@gmail.com</a>></span>:<br>
                        <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                          <div dir="ltr">
                            <div>ka.log is genrate by kamailio 4.1.6.<br>
                            </div>
                          </div>
                          <div>
                            <div>
                              <div class="gmail_extra"><br>
                                <div class="gmail_quote">2014-10-20
                                  17:44 GMT+08:00 Daniel-Constantin
                                  Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br>
                                  <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Are you
                                    using 4.1 or 4.2?<br>
                                    <br>
                                    Because the subject mentioned 4.2
                                    but the version of kamailio is 4.1<br>
                                    <span><font color="#888888"><br>
                                        Daniel<br>
                                      </font></span><span><br>
                                      On 20/10/14 11:39, 张顺通 wrote:<br>
                                      > -M 12 can not help. all
                                      config is same.<br>
                                      ><br>
                                      > see ka.log in attachment,
                                      kamailio version is 4.1.6<br>
                                      ><br>
                                      > version: kamailio 4.1.6
                                      (x86_64/linux) 010d57<br>
                                      ><br>
                                      > flags: STATS: Off, USE_TCP,
                                      USE_TLS, TLS_HOOKS, USE_RAW_SOCKS,<br>
                                      > DISABLE_NAGLE, USE_MCAST,
                                      DNS_IP_HACK, SHM_MEM, SHM_MMAP,
                                      PKG_MALLOC,<br>
                                      > DBG_QM_MALLOC, USE_FUTEX,
                                      FAST_LOCK-ADAPTIVE_WAIT,
                                      USE_DNS_CACHE,<br>
                                      > USE_DNS_FAILOVER, USE_NAPTR,
                                      USE_DST_BLACKLIST, HAVE_RESOLV_RES<br>
                                      ><br>
                                      > ADAPTIVE_WAIT_LOOPS=1024,
                                      MAX_RECV_BUFFER_SIZE 262144,
                                      MAX_LISTEN 16,<br>
                                      > MAX_URI_SIZE 1024, BUF_SIZE
                                      65535, DEFAULT PKG_SIZE 4MB<br>
                                      ><br>
                                      > poll method support: poll,
                                      epoll_lt, epoll_et, sigio_rt,
                                      select.<br>
                                      ><br>
                                      > id: 010d57<br>
                                      ><br>
                                      > compiled on 16:48:03 Oct 20
                                      2014 with gcc 4.1.2<br>
                                      ><br>
                                      ><br>
                                      <br>
                                    </span>
                                    <div>
                                      <div>--<br>
                                        Daniel-Constantin Mierla<br>
                                        <a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a>
                                        - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a><br>
                                        <br>
                                      </div>
                                    </div>
                                  </blockquote>
                                </div>
                                <br>
                              </div>
                            </div>
                          </div>
                        </blockquote>
                      </div>
                      <br>
                    </div>
                  </blockquote>
                  <br>
                  <pre cols="72">-- 
Daniel-Constantin Mierla
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
                </div>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
    <pre cols="72">-- 
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
  </div></div></div>

</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>