Mnesia - tables ???

vipin vipin@REDACTED
Tue Sep 27 08:37:56 CEST 2005


Hello all !!!

I've created five database tables, it works fine as long as 'Erlang 
node' (where database is running) is up. When it goes down or i do quit
from the node and again restart the database server on the same node 
then i've lost all the data in the tables. What should i do to make
it persistent ?

when i execute mnesia:info() i found that my all tables are lying in RAM 
(as shown below).  If the problem is wandering around here,
then please tell me how to move these ram_copies to disc_copies ?
(I'm using Erlang-R10B-6.)

=============================================================
(database@REDACTED)5> mnesia:info().
---> Processes holding locks <---
---> Processes waiting for locks <---
---> Participant transactions <---
---> Coordinator transactions <---
---> Uncertain transactions <---
---> Active tables <---
client_profile : with 109      records occupying 2785     words of mem
client_buddylist: with 2        records occupying 341      words of mem
client_offlinemessages: with 0        records occupying 277      words 
of mem
client_reverse_buddylist: with 2        records occupying 341      words 
of mem
client_online  : with 97       records occupying 2837     words of mem
schema         : with 6        records occupying 951      words of mem
===> System info in version "4.2.2", debug level = none <===
opt_disc. Directory "/home/vipin/elbis/database/Mnesia.database@REDACTED" 
is used.
use fallback at restart = false
running db nodes   = [database@REDACTED]
stopped db nodes   = []
master node tables = []
remote             = []
ram_copies         = [client_buddylist,
                      client_offlinemessages,
                      client_online,
                      client_profile,
                      client_reverse_buddylist]
disc_copies        = [schema]
disc_only_copies   = []
[{database@REDACTED,disc_copies}] = [schema]
[{database@REDACTED,ram_copies}] = [client_online,
                                 client_reverse_buddylist,
                                 client_offlinemessages,
                                 client_buddylist,
                                 client_profile]
355 transactions committed, 0 aborted, 0 restarted, 0 logged to disc
0 held locks, 0 in queue; 0 local transactions, 0 remote
0 transactions waits for other nodes: []
ok
============================================================

Your suggestions would be welcome.

Cheers,
Vipin




More information about the erlang-questions mailing list