Re: Problems installing on PostgreSQL 9.1 after upgrading to 1.3.14

[Chris Travers <..hidden..>]

On Thu, Apr 5, 2012 at 1:43 PM, Mikkel Høgh <..hidden..> wrote:
> When I try to install a new database after upgrading, I now get errors. I had it working earlier with 1.3.11, so it's a bit curious:
>
> Apr  5 22:37:12 limelight postgres[86551]: [2-1] FATAL:  database "ledgertest" does not exist

This is expected if you are trying to create a new db.

> Apr  5 22:37:23 limelight postgres[86562]: [2-1] ERROR:  language "plpgsql" already exists
> Apr  5 22:37:23 limelight postgres[86562]: [2-2] STATEMENT:  CREATE LANGUAGE PLPGSQL;

This is expected on PostgreSQL 9.x  Once we remove 8.x support we will
remove the create language statement.

> Apr  5 22:37:52 limelight postgres[86601]: [2-1] ERROR:  type in_recon_fx does not exist
> Apr  5 22:37:52 limelight postgres[86601]: [2-2] STATEMENT:  CREATE OR REPLACE FUNCTION reconciliation__new_report_id
> Apr  5 22:37:52 limelight postgres[86601]: [2-3]        (in_chart_id int, in_total numeric, in_end_date date, in_recon_fx) returns INT as $$
> Apr  5 22:37:52 limelight postgres[86601]: [2-4]
> Apr  5 22:37:52 limelight postgres[86601]: [2-5]            INSERT INTO cr_report(chart_id, their_total, end_date, recon_fx)
> Apr  5 22:37:52 limelight postgres[86601]: [2-6]            values ($1, $2, $3, $4);
> Apr  5 22:37:52 limelight postgres[86601]: [2-7]            SELECT currval('cr_report_id_seq')::int;
> Apr  5 22:37:52 limelight postgres[86601]: [2-8]
> Apr  5 22:37:52 limelight postgres[86601]: [2-9]        $$ language 'sql';
> Apr  5 22:37:52 limelight postgres[86601]: [3-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block

Is there something else missing in the mean time?  You shouldn't get a
transaction aborted error in a new script without a preceding error
from the same script.

Also I note that the reconciliation function is in a separate script
than the other two errors.  I don';t know what's causing that one
script to fail.

Best Wishes.
Chris Travers
>
> And then pages and pages of errors, since it does not stop trying after the first failure.
>
> Any clues?
> ------------------------------------------------------------------------------
> Better than sec? Nothing is better than sec when it comes to
> monitoring Big Data applications. Try Boundary one-second
> resolution app monitoring today. Free.
> http://p.sf.net/sfu/Boundary-dev2dev
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel