Mnesia overloaded
Magnus Ahltorp
map@REDACTED
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
> <D4ADC896EC3F5948A9D3899986CEB9DE03C7864B@REDACTED
> >
> 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
appserver@REDACTED 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:
(adminwww@REDACTED)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,'adminwww@REDACTED',
{decision,
{tid,105072102,<2135.4587.0>},
presume_abort,
['incomingproxy@REDACTED',
'incomingproxy@REDACTED'],
['adminwww@REDACTED',
'appserver@REDACTED',
'pstnproxy@REDACTED',
'appserver@REDACTED']},
[],
[],
[],
[],
[{op,add_table_copy,
ram_copies,
'appserver@REDACTED',
[{name,call},
{type,set},
{ram_copies,
['appserver@REDACTED',
'appserver@REDACTED']},
{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},
'appserver@REDACTED'}},
{version,
{{6,0},
{'incomingproxy@REDACTED',
{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/
Mnesia.adminwww@REDACTED" is NOT used.
use fallback at restart = false
running db nodes =
['appserver@REDACTED','incomingproxy@REDACTED','pstnproxy@REDACTED','
appserver@REDACTED','incomingproxy@REDACTED','adminwww@REDACTED']
stopped db nodes = []
master node tables = []
remote = [call,forward,numbers,phone,regexproute,user]
ram_copies = [login,schema]
disc_copies = []
disc_only_copies = []
[{'adminwww@REDACTED',ram_copies}] = [login]
[{'adminwww@REDACTED',ram_copies},
{'appserver@REDACTED',ram_copies},
{'appserver@REDACTED',ram_copies},
{'incomingproxy@REDACTED',disc_copies},
{'incomingproxy@REDACTED',disc_copies},
{'pstnproxy@REDACTED',ram_copies}] = [schema]
[{'appserver@REDACTED',ram_copies},
{'appserver@REDACTED',ram_copies}] = [call]
[{'incomingproxy@REDACTED',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