· 8 years ago · Mar 04, 2018, 10:22 AM
1(in /home/ryan/projects/trisano/distro)
2Installing the data warehouse
3CREATE DATABASE trisano_dw ENCODING='UTF8'
4CREATE DATABASE
5ALTER SCHEMA
6CREATE ROLE
7NOTICE: schema "trisano" does not exist
8ALTER ROLE
9CREATE SCHEMA
10ALTER SCHEMA
11psql:../bi/scripts/warehouse_init_to_run.sql:20: ERROR: language "plpgsql" already exists
12ALTER SCHEMA
13GRANT
14CREATE TABLE
15TRUNCATE TABLE
16INSERT 0 1
17CREATE TABLE
18INSERT 0 1
19CREATE FUNCTION
20CREATE FUNCTION
21Running the DW ETL script
22Temporarily quieting PostgreSQL
23ALTER ROLE
24Preparing for ETL process
25 prepare_etl
26-------------
27 t
28(1 row)
29
30Dumping database localhost:5432/trisano_development to localhost:5432/trisano_dw
31 Dropping bucardo schema in warehouse, if exists
32 Checking for bucardo schema in source
33psql: FATAL: password authentication failed for user "nedss"
34 Doing main dump
35pg_dump: [archiver (db)] connection to database "trisano_development" failed: FATAL: password authentication failed for user "nedss"
36Performing ETL data manipulation
37
38
39psql:../bi/scripts/dw.sql:177: ERROR: relation "people" does not exist
40psql:../bi/scripts/dw.sql:323: ERROR: current transaction is aborted, commands ignored until end of transaction block
41psql:../bi/scripts/dw.sql:452: ERROR: current transaction is aborted, commands ignored until end of transaction block
42psql:../bi/scripts/dw.sql:480: ERROR: current transaction is aborted, commands ignored until end of transaction block
43psql:../bi/scripts/dw.sql:508: ERROR: current transaction is aborted, commands ignored until end of transaction block
44psql:../bi/scripts/dw.sql:545: ERROR: current transaction is aborted, commands ignored until end of transaction block
45psql:../bi/scripts/dw.sql:587: ERROR: current transaction is aborted, commands ignored until end of transaction block
46psql:../bi/scripts/dw.sql:589: ERROR: current transaction is aborted, commands ignored until end of transaction block
47psql:../bi/scripts/dw.sql:602: ERROR: current transaction is aborted, commands ignored until end of transaction block
48psql:../bi/scripts/dw.sql:629: ERROR: current transaction is aborted, commands ignored until end of transaction block
49psql:../bi/scripts/dw.sql:657: ERROR: current transaction is aborted, commands ignored until end of transaction block
50psql:../bi/scripts/dw.sql:681: ERROR: current transaction is aborted, commands ignored until end of transaction block
51psql:../bi/scripts/dw.sql:704: ERROR: current transaction is aborted, commands ignored until end of transaction block
52psql:../bi/scripts/dw.sql:727: ERROR: current transaction is aborted, commands ignored until end of transaction block
53psql:../bi/scripts/dw.sql:751: ERROR: current transaction is aborted, commands ignored until end of transaction block
54psql:../bi/scripts/dw.sql:774: ERROR: current transaction is aborted, commands ignored until end of transaction block
55psql:../bi/scripts/dw.sql:789: ERROR: current transaction is aborted, commands ignored until end of transaction block
56psql:../bi/scripts/dw.sql:804: ERROR: current transaction is aborted, commands ignored until end of transaction block
57psql:../bi/scripts/dw.sql:819: ERROR: current transaction is aborted, commands ignored until end of transaction block
58psql:../bi/scripts/dw.sql:821: ERROR: current transaction is aborted, commands ignored until end of transaction block
59psql:../bi/scripts/dw.sql:822: ERROR: current transaction is aborted, commands ignored until end of transaction block
60Swapping schemas
61ERROR: Last ETL process was, apparently, not valid. Not swapping schemas. See table trisano.etl_success.
62Fixing PostgreSQL verbosity
63ALTER ROLE
64psql: FATAL: database "ryan" does not exist
65rake aborted!
66failed to create Pentaho repository
67
68(See full trace by running task with --trace)