From: Ralph A. S. d. <ra...@sc...> - 2012-11-27 08:03:21
|
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... [mailto:mu...@gm...] On Behalf Of Kurtis Heimerl Sent: Tuesday, November 27, 2012 12:12 AM To: Ralph A. Schmid Cc: 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/scripts/VBTS_Call_Provisioning.py", line 337, in <module> vbts = Provisioner (to_be_handled) File "/usr/local/share/yate/scripts/VBTS_Call_Provisioning.py", line 66, in __init__ self.minnum = int(self.ym.smqueue_get("SC.Register.Digits.Min")) File "/usr/local/lib/python2.7/dist-packages/libvbts/Messenger.py", line 132, in smqueue_get raise e Exception: Field SC.Register.Digits.Min not found <WARN> ExtMod 'VBTS_Call_Provisioning.py' did not handle call message <ExtModule:WARN> Never got anything valid from terminated 'VBTS_Call_Provisioning.py' '' sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Proceeding',CHANGED=1353962491 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Proceeding',CHANGED=1353962491 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='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 SIPSTATE='Proceeding',CHANGED=1353962491 WHERE ID=1019897226 error: out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Busy',CHANGED=1353962491 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Busy',CHANGED=1353962491 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Busy',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='Busy',CHANGED=1353962491 WHERE ID=1019897226 error: out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET GSMSTATE='null',CHANGED=1353962491 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET GSMSTATE='null',CHANGED=1353962491 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET GSMSTATE='null',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='null',CHANGED=1353962491 WHERE ID=1019897226 error: out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='MODCanceling',CHANGED=1353962492 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='MODCanceling',CHANGED=1353962492 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='MODCanceling',CHANGED=1353962492 WHERE ID=1019897226": out of memory ALERT 3052555072 TransactionTable.cpp:409:runQuery: transaction table access failed after 3attempts. query:UPDATE TRANSACTION_TABLE SET SIPSTATE='MODCanceling',CHANGED=1353962492 WHERE ID=1019897226 error: out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Canceled',CHANGED=1353962492 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Canceled',CHANGED=1353962492 WHERE ID=1019897226": out of memory sqlite3_prepare_v2 failed for "UPDATE TRANSACTION_TABLE SET SIPSTATE='Canceled',CHANGED=1353962492 WHERE ID=1019897226": out of memory ALERT 3052555072 TransactionTable.cpp:409:runQuery: transaction table access failed after 3attempts. query:UPDATE TRANSACTION_TABLE SET SIPSTATE='Canceled',CHANGED=1353962492 WHERE ID=1019897226 error: out of memory ID=2011947393": out of memory command not found OpenBTS> ALERT 3053587264 Transact ---------------------------------------------------------------------------- -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Openbts-discuss mailing list Ope...@li... <javascript:;> https://lists.sourceforge.net/lists/listinfo/openbts-discuss |