<div dir="ltr"><div>Dear Experts,<br><br></div><div>Hello, I am running a gsm system with followings:<br><br>OpenBSC version: 0.13.0.319-30e0e<br><br>LCR version 1.14<br><br>astersik version 1.8.10.1<br><br></div><div>The system is sited is a busy area. The system works fine for few days but hangs once the hlr.sqlite3 file size reaches near 12 MB and that causes the osmo-nitb to take 99% of the cpu usage. I used "./osmo-nitb -m -P -C" to run the system. The hlr.sqlite3 file increases @2MB/Day. The 'Subscriber' table of the hlr.sqlite3 file adds a large number of IMSI with authorized=0. Tables like Counters, Eqipment and EquipmentWatch are filling up with lots of data. Now the only solution to this problem is to manually delete the data from the tables. <br><br></div><div>May I get some light to solve the issue form the experts like you all?<br><br></div><div>With regards. <br><br></div><div>[ Content from the openbsc.cfg file is as following:<br><br>
<p class="MsoNormal" style="line-height:normal"><a name="14e1a94456757ffb_OLE_LINK3">!</a></p>
<p class="MsoNormal" style="line-height:normal"><span>!
OpenBSC configuration saved from vty</span></p>
<p class="MsoNormal" style="line-height:normal"><span>!<span> </span>!</span></p>
<p class="MsoNormal" style="line-height:normal"><span>password
foo</span></p>
<p class="MsoNormal" style="line-height:normal"><span>!</span></p>
<p class="MsoNormal" style="line-height:normal"><span>line
vty</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>no login</span></p>
<p class="MsoNormal" style="line-height:normal"><span>!</span></p>
<p class="MsoNormal" style="line-height:normal"><span>e1_input</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>e1_line 0 driver ipa</span></p>
<p class="MsoNormal" style="line-height:normal"><span>network</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>network country code XXX<br></span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>mobile network code XX<br></span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>short name Test</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>long name Test</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>auth policy closed</span></p>
<p class="MsoNormal" style="line-height:normal"><span>location
updating reject cause 13</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>encryption a5 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>neci 1</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>rrlp mode none</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>mm info 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>handover 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>handover window rxlev averaging 10</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>handover window rxqual averaging 1</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>handover window rxlev neighbor averaging 10</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>handover power budget interval 6</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>handover power budget hysteresis 3</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>handover maximum distance 9999</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3101 10</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3103 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3105 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3107 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3109 4</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3111 1</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3113 60</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3115 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3117 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3119 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timer t3141 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>bts 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>type sysmobts</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>band GSMXXX</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>cell_identity X</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>location_area_code X</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>training_sequence_code 7</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>base_station_id_code 63</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>ms max power 30</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>cell reselection hysteresis 4</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>rxlev access min 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span>periodic
location update 100</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>channel allocator ascending</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>rach tx integer 9</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>rach max transmission 7</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>ip.access unit_id XXXX 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>oml ip.access stream_id 255 line 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>gprs mode none</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>trx 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>rf_locked 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>arfcn XXX</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>nominal power 23</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>max_power_red XX</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>rsl e1 tei 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 0</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config CCCH+SDCCH4</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 1</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config SDCCH8</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 2</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config TCH/F</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 3</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config TCH/F</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 4</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config TCH/F</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 5</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config TCH/F</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 6</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config TCH/F</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>timeslot 7</span></p>
<p class="MsoNormal" style="line-height:normal"><span><span> </span>phys_chan_config TCH/F</span></p>
<span></span>
<p class="MsoNormal" style="line-height:normal"> </p>
<br></div></div>