Mailing-List: contact user-help@manifoldcf.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@manifoldcf.apache.org
MIME-Version: 1.0
Date: Thu, 2 Jun 2016 10:52:12 +0900
Message-ID: <CAHpHujnqoEKGMigSeG7OvzRCKvrvtDiSDxcPzQ_+r2_ZCjsWvg@mail.gmail.com>
Subject: SQLException "value too long for type character varying(64)" while
 deleting documents
From: Tomoko Uchida <tomoko.uchida.1111@gmail.com>
To: user@manifoldcf.apache.org
Content-Type: text/plain; charset=UTF-8
archived-at: Thu, 02 Jun 2016 01:52:17 -0000

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