On Thu, Apr 5, 2012 at 1:43 PM, Mikkel Høgh <[email protected]> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
