[cobalt-users] swatch & internal server error problem

["kajan" <kajan@xxxxxxxxxxxxxx>]

Hi all,

I have the following problem.

When I type swatch, I get the following error message:

[root@mail1 scripts]# swatch
SQL INSERT command failed
query = INSERT INTO quota (type, total, used, name, percent, free, modify)
VALUES ('quota', '12000.00', '349.58', 'users', '2.91', '11650.42',
datetime('now'::abstime));
ERROR: ERROR:  cannot find attribute 1 of relation quota

BEGIN command failed
ERROR:
Segmentation fault (core dumped)"


Or when pick on the "active monitor " & "disk usage", I get "internal server
error" message.

I had this problem in one server & it crashed with kernel panic message.
Now it is happening in another server.

The following solution is given in the sun-cobalt online
support:(ref: 010829-000026)

"Telnet to the box as admin
Type:
su -
cd /home/pgsql
su postgres
edit pg_hba.conf
change "local cobalt crypt" to "local all trust"
Type:
pg_dump cobalt > cobalt.dump
edit cobalt.dump
find "create_table for quota" and hash out that section, (comment it out)
save and close
Type:
destroydb cobalt
createdb cobalt
psql cobalt < cobalt.dump
edit pg_hba.conf
change "local all trust" back to "local cobalt crypt"
exit back to root by typing exit
Type:
swatch

The Internal Server error should be gone after that."

But some people in the mailing list say this method also has some
problem.

Pl. let me know  if anybody used the above-mentioned method to solve the
same problem.
(I have stopped the swatch as it using lots of cpu resources.)

Thanks  & Regards

Kajan