This still has to do with the problems in the ml_dir table. That afternoon
when I tried to fix it, too many rows were deleted and I sent you a
message shortly after that asking you to check if all of the five
entries were there.
----------------------------------------------------------------------------
6. If you are observing that CLX continously erases mail and
batch files at startup, you probably have duplicate entries in
the ml_dir table. This is due to an error in the mk_th script.
If you have this effect, use the command
$ psql clx_db -c "select d_name,d_flag,d_last,oid from ml_dir"
to check. Normally, you should see something like this:
d_name |d_flag|d_last | oid
--------+------+----------------------------+-------
batch | 0|Fri Apr 03 06:02:58 1998 GMT| 939680
info | 3| | 941600
bulletin| 0|Fri Mar 27 20:11:19 1998 GMT| 958624
mail | 1|Mon Apr 13 10:24:08 1998 GMT| 940992
iclb | 1|Mon Apr 13 15:19:11 1998 GMT| 940384
(5 rows)
If there are several instances of batch, mail, iclb or
bulletin, however, you have this problem.
d_name |d_flag|d_last | oid
--------+------+----------------------------+-------
batch | 0| |1870304
batch | 0|Fri Apr 03 06:02:58 1998 GMT| 939680
...
To fix, remove the versions with a higher oid, like this
$ psql clx_db -c "delete from ml_dir where oid=1870304"
mk_th has been fixed in the mean time but if you repair the
problem manually, there will be no more trouble.
----------------------------------------------------------------------------
Please be sure that there are five of them. Sorry for the confusion.
Basically there is not a problem except that during previous
update sessions, duplicate entries crept into the database and
they spoiled it. But it should be OK now.
I appreciate you sending mail to the reflector directly. Other people
will gain from this and when they observe a problem, they will
probably know too. We can continue doing this until the volume
gets too high.
73 Ben
--
[] clx - PacketCluster Software for Linux
[] c/o Bernhard ("Ben") Buettner, DL6RAI
[] Internet: fydbqe@internetghana.com
[] Packet: DL6RAI @ DB0AAB.#BAY.DEU.EU