I'll look over the second message you sent and check the database again, I'm
pretty sure that the five tables are there.
Thanks
mg
-----Original Message-----
From: CLX-User DL6RAI <huwx.bkeofm@roskapostia.tunk.net>
To: zta@datawest.net <terhi.victor@logonet.com>
Date: Sunday, April 26, 1998 3:17 PM
Subject: Re: CLX Start Script
>Max,
>
>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: upgsmf.olcmz@omnicell.com
>[] Packet: DL6RAI @ DB0AAB.#BAY.DEU.EU
>