Mailing-List: contact user-help@manifoldcf.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@manifoldcf.apache.org
Received-SPF: pass (athena.apache.org: domain of daddywri@gmail.com designates
 209.85.128.177 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <51126252.1030506@usit.uio.no>
References: <51025DC7.8000702@usit.uio.no>
	<CALUFAGCvz-jXZMqZTv-5s0SbmtAOnTcGsfb5vQKsoJiSBnNnJg@mail.gmail.com>
	<510BAACB.5050201@usit.uio.no>
	<510BAEA9.70300@usit.uio.no>
	<CALUFAGAU4Wc+QqQ2xy96jJSJx_ZfcC0MXqiKqysr-TsJFy1i4A@mail.gmail.com>
	<CALUFAGAfPrQQW-gJE5fwUncuWE4T9rfUGz8miS2oVxTfU8r4yA@mail.gmail.com>
	<5110FD4A.6040006@usit.uio.no>
	<CALUFAGDXhda2Aob8if=Q3mEAaqcXK09SYq9TD_5Dprsd+fGKQg@mail.gmail.com>
	<51122706.2040709@usit.uio.no>
	<CALUFAGBjNRK=uBMs_6y=+4MUw8Dc+=5zAeQ_UVRB4Q9C9fi_TA@mail.gmail.com>
	<511244E4.4020102@usit.uio.no>
	<51124947.7080309@usit.uio.no>
	<CALUFAGDtENwFxk613NSzSGV=dorwuXaEc064rNZxOpr2vKnogQ@mail.gmail.com>
	<511251AE.3050805@usit.uio.no>
	<CALUFAGC6+KFO-+rFt06oqdQ6FNGbvCHET0CRFDB62Sik6dbvDw@mail.gmail.com>
	<511255A6.4070908@usit.uio.no>
	<CALUFAGDSwcNmb9PXNVwe11fRGQLxVwfNVz+FZfYgKUZQv4YJFA@mail.gmail.com>
	<51126252.1030506@usit.uio.no>
Date: Wed, 6 Feb 2013 09:24:58 -0500
Message-ID: 
 <CALUFAGCO+CoyJqD19F7wsB_zzvdFvKeZnNTaAvSPW6SpkEnd0A@mail.gmail.com>
Subject: Re: max_pred_locks_per_transaction
From: Karl Wright <daddywri@gmail.com>
To: user@manifoldcf.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

The jobsforcedparam table is a crawler core database table that was
added as part of CONNECTORS-552.  It should be created or added as
part of the crawleragent register command.  If this command is
failing, you will need to determine why.

FWIW, schema creation has been working fine here, and all tests that
exercise the schema have been passing fine as well.

Karl


On Wed, Feb 6, 2013 at 9:01 AM, Erlend Gar=E5sen <e.f.garasen@usit.uio.no> =
wrote:
> On 06.02.13 14.14, Karl Wright wrote:
>>
>> The database instance create logic should do nothing if the instance
>> already exists. In fact, that is how it is coded throughout.  The
>> expected deployment model is to execute all the operations you would
>> normally do, in the same order, including connector registration,
>> every time you update the ManifoldCF software.  If you want to skip
>> the database instance creation, you can't use initialize.bat it is
>> true, but you can do everything that it would be doing through the use
>> of individual ManifoldCF commands, e.g.:
>>
>> org.apache.manifoldcf.agents.Initialize
>> org.apache.manifoldcf.agents.RegisterAgent
>> etc.
>
>
> Yes, and this is actually a part of our deployment steps since we cannot =
use
> initialize.sh. One of these commands failed, so I just emptied the databa=
se
> manually.
>
> The problem now is that I'm still getting the error while I'm trying to v=
iew
> my jobs. Same error:
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database
> exception: SQLException doing query (42P01): ERROR: relation
> "jobforcedparams" does not exist
>
> This is what I ran after I emptied my database:
>
> 1. org.apache.manifoldcf.agents.Install
>
> 2. org.apache.manifoldcf.agents.Register
> org.apache.manifoldcf.crawler.system.CrawlerAgent
>
> 3. org.apache.manifoldcf.crawler.Register
> org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector
> WebCrawler
>
> 4. org.apache.manifoldcf.agents.RegisterOutput
> org.apache.manifoldcf.agents.output.solr.SolrConnector SolrConnector
>
> Should I have performed org.apache.manifoldcf.agents.Initialize as well? =
I
> have never ran that command class before, probably bevause it tries to
> create the database?
>
> Is jobforcedparams something related to connection tracking?
>
> Erlend
>
>
> --
> Erlend Gar=E5sen
> Center for Information Technology Services
> University of Oslo
> P.O. Box 1086 Blindern, N-0317 OSLO, Norway
> Ph: (+47) 22840193, Fax: (+47) 22852970, Mobile: (+47) 91380968, VIP: 310=
50