osmo-nitb hangs with large hlr.sqlite3 file

This is merely a historical archive of years 2008-2021, before the migration to mailman3.

A maintained and still updated list archive can be found at https://lists.osmocom.org/hyperkitty/list/OpenBSC@lists.osmocom.org/.

F Abdu osmobsc11 at gmail.com
Mon Jun 22 10:35:49 UTC 2015


Dear Experts,

Hello, I am running a gsm system with followings:

OpenBSC version: 0.13.0.319-30e0e

LCR version 1.14

astersik version 1.8.10.1

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.

May I get some light to solve the issue form the experts like you all?

With regards.

[ Content from the openbsc.cfg file is as following:

!

! OpenBSC configuration saved from vty

!   !

password foo

!

line vty

 no login

!

e1_input

 e1_line 0 driver ipa

network

 network country code XXX

 mobile network code XX

 short name Test

 long name Test

 auth policy closed

location updating reject cause 13

 encryption a5 0

 neci 1

 rrlp mode none

  mm info 0

 handover 0

 handover window rxlev averaging 10

 handover window rxqual averaging 1

 handover window rxlev neighbor averaging 10

 handover power budget interval 6

 handover power budget hysteresis 3

 handover maximum distance 9999

 timer t3101 10

 timer t3103 0

 timer t3105 0

 timer t3107 0

 timer t3109 4

 timer t3111 1

 timer t3113 60

 timer t3115 0

 timer t3117 0

 timer t3119 0

 timer t3141 0

 bts 0

  type sysmobts

  band GSMXXX

  cell_identity X

  location_area_code X

  training_sequence_code 7

  base_station_id_code 63

  ms max power 30

  cell reselection hysteresis 4

  rxlev access min 0

periodic location update 100

  channel allocator ascending

  rach tx integer 9

  rach max transmission 7

  ip.access unit_id XXXX 0

  oml ip.access stream_id 255 line 0

  gprs mode none

  trx 0

   rf_locked 0

   arfcn XXX

   nominal power 23

   max_power_red XX

   rsl e1 tei 0

    timeslot 0

     phys_chan_config CCCH+SDCCH4

    timeslot 1

     phys_chan_config SDCCH8

    timeslot 2

     phys_chan_config TCH/F

    timeslot 3

     phys_chan_config TCH/F

    timeslot 4

     phys_chan_config TCH/F

    timeslot 5

     phys_chan_config TCH/F

    timeslot 6

     phys_chan_config TCH/F

    timeslot 7

     phys_chan_config TCH/F
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osmocom.org/pipermail/openbsc/attachments/20150622/5fc79d9a/attachment.htm>


More information about the OpenBSC mailing list