Re: [Cs-studio-users] ArchiveEngine: Write Error

[Kasemir, K. <kas...@or...>]

There are two different errors in the log.

One is about CAJ UnsupportedOperationException.
That one shouldn't matter.
We've added support for the DBE_PROPERTY event to the CSS code, but CAJ
doesn't understand it except for the latest version.
So in the snapshot of the sources that you have, it complains but should
still "work".

The other error is a problem:
For better MySQL optimizations, we've started to mark RDB connections as
"read only" whenever possible.
Then Lana from the ITER project, where they are using PostGres, noted the
very problem you see:
Postgres doesn't like it when connections are changed to/from readonly at
certain times.
In principle, Lana went through and updated all sources to also work with
Postgres again.
If you still see these problems with the latest source snapshot from the
source force "cs-studio-3.1" repository or from

https://ics-web.sns.ornl.gov/css/updates/apps
(look for 3.1.0a binaries & sources)


then obviously we haven't really made it work with Postgres again.

Thanks,
Kay

On 6/29/12 06:05 , "Martin Konrad" <ko...@ik...> wrote:

>Hi Kay,
>I ran into some sort of a problem when I updated the ArchiveEngine from
>3.0 to the 3.1 branch. The database is still the same, I only replaced
>the ArchivEngine directory. When I start the Archive Engine it connects
>to the PVs and the RDB successfully and reads the list of channels
>correctly but according to the PostgreSQL log file it never tries to
>INSERT data (although the right username "archivewriter" is used). The
>Archive Engine web frontend says "Write State = Write Error" but it
>doesn't say why. How can I find out what's going wrong here? There are
>some exceptions (see attached log file) but I'm still not sure if they
>are the cause or a result of this problem.
>
>Any help is appreciated
>
>Martin
>
>-- 
>Dipl. Phys. Martin Konrad
>Technische Universität Darmstadt
>Institut für Kernphysik
>Schlossgartenstr. 9
>64289 Darmstadt
>Tel.: +49-6151-16-5121
>Fax: +49-6151-16-4321
>
>