Re: [Openbts-discuss] Still error when rebuilding all

[Ralph A. S. d. <ra...@sc...>]

In the normal openbts.db file? Ah, I see, points to /var/run/ what is a link
to /run/. So easy to find when to know where to Iook for it, no need to look
at the code what I right now was doing :) 

 

I extended permissions to the folder; is this a good idea, or would I better
choose a place in the users home folder? Are the files OpenBTS places there
permanent files, or temp files that are deleted after usage? At the moment I
do not see any OpenBTS files there, but I do not have the hardware here, so
I can't run the system now.

 

Ralph.

 

From: mu...@gm... [mailto:mu...@gm...] On Behalf Of Kurtis
Heimerl
Sent: Tuesday, November 27, 2012 9:11 AM
To: Ralph A. Schmid, dk5ras
Cc: ope...@li...
Subject: Re: [Openbts-discuss] Still error when rebuilding all

 

Look in your configuration, it's specified there. 

On Tuesday, November 27, 2012, Ralph A. Schmid, dk5ras wrote:

Maybe a dumb question, but where is this transaction table, what is the
exact filename? gTransActionTable.DB? I can't find it.

 

Ralph.

 

From: mu...@gm...
<javascript:_e(%7b%7d,%20'cvml',%20'mu...@gm...');>
[mailto:mu...@gm...
<javascript:_e(%7b%7d,%20'cvml',%20'mu...@gm...');> ] On Behalf Of
Kurtis Heimerl
Sent: Tuesday, November 27, 2012 12:12 AM
To: Ralph A. Schmid
Cc: ope...@li...
<javascript:_e(%7b%7d,%20'cvml',%20'ope...@li...');
> 
Subject: Re: [Openbts-discuss] Still error when rebuilding all

 

Yeah, that's the problem. If it can't insert the transaction into the
transaction table, then it can't process it. 

 

Did you try the permissions stuff? Deleting the old table?

On Tuesday, November 27, 2012, Ralph A. Schmid wrote:

Hi,

when I delete all traces of openbts and yate and rebuilding it all from
latest
versions, BCCH comes up, mobile registers, welcome SMS arrives, but when
trying to call a number to start provisioning I get a "busy" on the phone,
and
the output below. Access rights look OK. Any ideas?

Ralph.

Log.Level WARNING

OpenBTS> config TRX.TxAttenOffset
TRX.TxAttenOffset 2

OpenBTS> config TRX.TxAttenOffset 0
TRX.TxAttenOffset is static; change takes effect on restart
changed TRX.TxAttenOffset to "0"

OpenBTS> sqlite3_prepare_v2 failed for "INSERT INTO TRANSACTION_TABLE
(ID,CREATED,CHANGED,TYPE,SUBSCRIBER,L3TI,CALLED,CALLING,GSMSTATE,SIPSTATE,SI
P_CALLID,SIP_PROXY)
VALUES  (1019897226,1353962491,     1353962491,
'MOC','IMSI232037004316718',      8,'555',  '',   'MOC-initiated',
'Null',
'204428586',      '127.0.0.1')": out of memory
sqlite3_prepare_v2 failed for "INSERT INTO TRANSACTION_TABLE
(ID,CREATED,CHANGED,TYPE,SUBSCRIBER,L3TI,CALLED,CALLING,GSMSTATE,SIPSTATE,SI
P_CALLID,SIP_PROXY)
VALUES  (1019897226,1353962491,     1353962491,
'MOC','IMSI232037004316718',      8,'555',  '',   'MOC-initiated',
'Null',
'204428586',      '127.0.0.1')": out of memory
sqlite3_prepare_v2 failed for "INSERT INTO TRANSACTION_TABLE
(ID,CREATED,CHANGED,TYPE,SUBSCRIBER,L3TI,CALLED,CALLING,GSMSTATE,SIPSTATE,SI
P_CALLID,SIP_PROXY)
VALUES  (1019897226,1353962491,     1353962491,
'MOC','IMSI232037004316718',      8,'555',  '',   'MOC-initiated',
'Null',
'204428586',      '127.0.0.1')": out of memory
ALERT 3052555072 TransactionTable.cpp:409:runQuery: transaction table access
failed after 3attempts. query:INSERT INTO TRANSACTION_TABLE
(ID,CREATED,CHANGED,TYPE,SUBSCRIBER,L3TI,CALLED,CALLING,GSMSTATE,SIPSTATE,SI
P_CALLID,SIP_PROXY)
VALUES  (1019897226,1353962491,     1353962491,
'MOC','IMSI232037004316718',      8,'555',  '',   'MOC-initiated',
'Null',
'204428586',      '127.0.0.1') error: out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET CHANNEL='C0T1
TCH/F' WHERE ID=1019897226": out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET CHANNEL='C0T1
TCH/F' WHERE ID=1019897226": out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET CHANNEL='C0T1
TCH/F' WHERE ID=1019897226": out of memory
ALERT 3052555072 TransactionTable.cpp:409:runQuery: transaction table access
failed after 3attempts. query:UPDATE TRANSACTION_TABLE SET CHANNEL='C0T1
TCH/F' WHERE ID=1019897226 error: out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET
SIPSTATE='Starting',CHANGED=1353962491 WHERE ID=1019897226": out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET
SIPSTATE='Starting',CHANGED=1353962491 WHERE ID=1019897226": out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET
SIPSTATE='Starting',CHANGED=1353962491 WHERE ID=1019897226": out of memory
ALERT 3052555072 TransactionTable.cpp:409:runQuery: transaction table access
failed after 3attempts. query:UPDATE TRANSACTION_TABLE SET
SIPSTATE='Starting',CHANGED=1353962491 WHERE ID=1019897226 error: out of
memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET GSMSTATE='MOC-
proceeding',CHANGED=1353962491 WHERE ID=1019897226": out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET GSMSTATE='MOC-
proceeding',CHANGED=1353962491 WHERE ID=1019897226": out of memory
sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET GSMSTATE='MOC-
proceeding',CHANGED=1353962491 WHERE ID=1019897226": out of memory
ALERT 3052555072 TransactionTable.cpp:409:runQuery: transaction table access
failed after 3attempts. query:UPDATE TRANSACTION_TABLE SET GSMSTATE='MOC-
proceeding',CHANGED=1353962491 WHERE ID=1019897226 error: out of memory
VBTS Route Provisioning received: call.route id: 0xb5ff3030.507827832
Traceback (most recent call last):
  File "/usr/local/share/yate/<