manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tomoko Uchida <tomoko.uchida.1...@gmail.com>
Subject Re: SQLException "value too long for type character varying(64)" while deleting documents
Date Sat, 04 Jun 2016 04:08:40 GMT
Hi, any suggestions or comments on that?
I need your support.

Regards,
Tomoko

2016-06-02 10:52 GMT+09:00 Tomoko Uchida <tomoko.uchida.1111@gmail.com>:
> Hello,
> I encountered an SQLException when I deleted a job with many output connections.
>
> ERROR 2016-06-02 09:41:49,492 (Document delete thread '9') - Document
> delete thread aborting and restarting due to database connection
> reset: Database exception: SQLException doing query (22001): ERROR:
> value too long for type character varying(64)
>
>
> I've found that the error occurred because of ManifoldCF trying to
> insert long string (more than 64 characters) to 'activitytype' column
> of 'repohistory' table while deleting documents associated with the
> job.
>
> For a trial, I altered 'activitytype' column type to 'text' by this
> sentence, and restarted ManifoldCF.
> alter table repohistory alter column activitytype TYPE text;
> Then the deletion histories was successfully added and the job seemed
> to be safely deleted.
>
> Inserted 'activitytype' values are like this:
> document deletion (outputA)  (outputB)  (outputC) (outputD) (outputE) ...
>
> For application requirements, I cannot limit the number of output
> connectors (to shorten history records.)
>
> Is that OK? Or there are good solutions for that.
>
> Thank you,
> Tomoko

Mime
View raw message