Mnesia overloaded

Magnus Ahltorp <>
Thu Jul 20 21:14:38 CEST 2006


> I don't know about the "just hangs" part, but I believe that they are
> (mostly) harmless.  Quoting Ulf Wiger from Message-ID
> < 
> >
> on Tue, 9 May 2006 21:35:16 +0200:

The system continues to work, so the only thing that "hangs" is the  
command line, the command never completes.

I tried the command again, now with another table (call) to  
 I have now waited about 3 hours, and it still  
hasn't completed. My tables are quite small, and not very many writes  
are made, only a few per minute.

Some info from my system, command still running:

()23> mnesia:info().
---> Processes holding locks <---
Lock: {{schema,'______WHOLETABLE_____'},write,{tid, 
105072102,<2135.4587.0>}}
---> Processes waiting for locks <---
---> Participant transactions <---
Tid: 105072102 (owned by <2135.4587.0>)
with participant objects {commit,'',
                                  {decision,
                                      {tid,105072102,<2135.4587.0>},
                                      presume_abort,
                                      ['',
                                       ''],
                                      ['',
                                       '',
                                       '',
                                       '']},
                                  [],
                                  [],
                                  [],
                                  [],
                                  [{op,add_table_copy,
                                       ram_copies,
                                       '',
                                       [{name,call},
                                        {type,set},
                                        {ram_copies,
                                            ['',
                                             '']},
                                        {disc_copies,[]},
                                        {disc_only_copies,[]},
                                        {load_order,0},
                                        {access_mode,read_write},
                                        {index,[]},
                                        {snmp,[]},
                                        {local_content,false},
                                        {record_name,call},
                                        {attributes, 
[callid,type,headers,data]},
                                        {user_properties,[]},
                                        {frag_properties,[]},
                                        {cookie,
                                            {{1055,341655,841578},
                                             ''}},
                                        {version,
                                            {{6,0},
                                             {'',
                                                  
{1153,411051,528844}}}}]}]}
---> Coordinator transactions <---
---> Uncertain transactions <---
---> Active tables <---
schema         : with 8        records occupying 1249     words of mem
login          : with 3        records occupying 538      words of mem
===> System info in version "4.1.4", debug level = none <===
opt_disc. Directory "/nobackup/home/sipvxl/sip/ 
" is NOT used.
use fallback at restart = false
running db nodes   =  
['','','',' 
','','']
stopped db nodes   = []
master node tables = []
remote             = [call,forward,numbers,phone,regexproute,user]
ram_copies         = [login,schema]
disc_copies        = []
disc_only_copies   = []
[{'',ram_copies}] = [login]
[{'',ram_copies},
{'',ram_copies},
{'',ram_copies},
{'',disc_copies},
{'',disc_copies},
{'',ram_copies}] = [schema]
[{'',ram_copies},
{'',ram_copies}] = [call]
[{'',disc_copies}] = [regexproute,
                                                    forward,
                                                    numbers,
                                                    user,
                                                    phone]
209 transactions committed, 0 aborted, 3 restarted, 0 logged to disc
1 held locks, 0 in queue; 0 local transactions, 1 remote
0 transactions waits for other nodes: []
ok

ls -l Mnesia.incomingproxy\@computer1
-rw-r--r--    1 sipvxl   default       233 Jul 20 17:56 DECISION_TAB.LOG
-rw-r--r--    1 sipvxl   default    393369 Jul 20 21:04 LATEST.LOG
-rw-r--r--    1 sipvxl   default      1605 Jul 17 09:35 forward.DCD
-rw-r--r--    1 sipvxl   default       280 Dec 11  2003 forward.DCD.bak
-rw-r--r--    1 root     bin           678 Mar 30  2004  
forward.DCD.bak.040330
-rw-r--r--    1 sipvxl   default       105 Dec 15  2003 forward.DCD.bak2
-rw-r--r--    1 sipvxl   default       192 Jul 18 09:14 forward.DCL
-rw-r--r--    1 sipvxl   default       163 Dec 15  2003 forward.DCL.bak
-rw-r--r--    1 sipvxl   default      3911 Jun  9 15:41 numbers.DCD
-rw-r--r--    1 sipvxl   default       453 Jul 14 14:50 numbers.DCL
-rw-r--r--    1 sipvxl   default      8669 Jul 20 17:56 phone.DCD
-rw-r--r--    1 sipvxl   default      6805 Dec 15  2003 phone.DCD.bak
-rw-r--r--    1 sipvxl   default       225 Mar 22 20:44 regexproute.DCD
-rw-r--r--    1 sipvxl   default     14453 Jul 20 17:54 schema.DAT
-rw-r--r--    1 sipvxl   default     11921 Jun 29 13:20 user.DCD
-rw-r--r--    1 sipvxl   default      1683 Jul 19 00:02 user.DCL

ls -l Mnesia.incomingproxy\@computer2
-rw-------  1 yxa yxa   171 Jul 18 17:20 DECISION_TAB.LOG
-rw-------  1 yxa yxa  3559 Jul 20 17:57 LATEST.LOG
-rw-------  1 yxa yxa 13928 Jul 20 17:54 schema.DAT




More information about the erlang-questions mailing list