Re: [cobalt-users] swatch & internal server error problem

[Albert Csaba <maka_cs@xxxxxxxxx>]

--- kajan <kajan@xxxxxxxxxxxxxx> wrote:
> 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.

I've tried to eliminate the server internal error that
way, but I have a error at the line
"pg_dump cobalt > cobalt.dump"

----
$ pg_dump cobalt > cobalt.dump
SQL query to dump the contents of Table 'quota' did
not execute.  Explanation from backend: 'ERROR: 
cannot find attribute 1 of relation quota
'.
The query was: 'COPY "quota" TO stdout;
'.
----


__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com