Re: sl => lsmb

[david <..hidden..>]

Chris Travers wrote:
> If you run the script, what is the first error that shows up?  The
> error you quoted simply means that the transaction has aborted and so
> statements from that connection are not being accepted.  The key
> question is why the transaction has aborted.
>
> Best Wishes,
> Chris Travers

Below is the error (sterr) from running the various upgrade scripts.
I've also attached a txt file of the same thing because it's probably easier to 
read.

Database 2009lsmb is a dataset created from the LSMB "create database" admin 
page, with defaults

sl.sql is output from SL's backup to file function.

There are errors in the sl.sql injection. This is strange because if i use that 
same file to create a new SQL-Ledger data set it works fine. I've never checked 
to see if there were errors being logged in SL.





..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f /home/david/sl.sql -L 
1logfile -o 1output > 1stdout 2> 1stderr
..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f 
/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql -L 2logfile -o 
2output > 2stdout 2> 2stderr
..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f 
/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql -L 3logfile -o 
3output > 3stdout 2> 3stderr
..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f 
/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql -L 4logfile -o 
4output > 4stdout 2> 4stderr
..hidden..:~ # cat 1stderr
psql:/home/david/sl.sql:62: ERROR:  relation "id" already exists
psql:/home/david/sl.sql:64: ERROR:  relation "invoiceid" already exists
psql:/home/david/sl.sql:66: ERROR:  relation "orderitemsid" already exists
psql:/home/david/sl.sql:68: ERROR:  relation "jcitemsid" already exists
psql:/home/david/sl.sql:49809: WARNING:  changing return type of function 
del_yearend from "opaque" to "trigger"
psql:/home/david/sl.sql:49811: WARNING:  changing return type of function 
del_department from "opaque" to "trigger"
psql:/home/david/sl.sql:49819: WARNING:  changing return type of function 
del_customer from "opaque" to "trigger"
psql:/home/david/sl.sql:49821: WARNING:  changing return type of function 
del_vendor from "opaque" to "trigger"
psql:/home/david/sl.sql:49823: WARNING:  changing return type of function 
del_exchangerate from "opaque" to "trigger"
psql:/home/david/sl.sql:49829: WARNING:  changing return type of function 
check_inventory from "opaque" to "trigger"
psql:/home/david/sl.sql:49831: WARNING:  changing return type of function 
check_department from "opaque" to "trigger"
psql:/home/david/sl.sql:49839: WARNING:  changing return type of function 
del_recurring from "opaque" to "trigger"
..hidden..:~ # cat 2stderr
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql:1: ERROR: 
relation "session_session_id_seq" already exists
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql:8: ERROR: 
relation "session" already exists
..hidden..:~ # cat 3stderr
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:2: NOTICE: 
ALTER TABLE / ADD PRIMARY KEY will create implicit index "chart_pkey" for table 
"chart"
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:13: NOTICE: 
ALTER TABLE / ADD PRIMARY KEY will create implicit index "acc_trans_pkey" for 
table "acc_trans"
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:106: ERROR: 
relation "transactions" already exists
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:108: ERROR: 
current transaction is aborted, commands ignored until end of transaction block
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:111: ERROR: 
current transaction is aborted, commands ignored until end of transaction block
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:114: ERROR: 
current transaction is aborted, commands ignored until end of transaction block
etc...

..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f /home/david/sl.sql -L 1logfile -o 1output > 1stdout 2> 1stderr
..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f /usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql -L 2logfile -o 2output > 2stdout 2> 2stderr
..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f /usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql -L 3logfile -o 3output > 3stdout 2> 3stderr
..hidden..:~ # psql -d 2009lsmb  -h localhost -U ledgersmb -f /usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql -L 4logfile -o 4output > 4stdout 2> 4stderr
..hidden..:~ # cat 1stderr
psql:/home/david/sl.sql:62: ERROR:  relation "id" already exists
psql:/home/david/sl.sql:64: ERROR:  relation "invoiceid" already exists
psql:/home/david/sl.sql:66: ERROR:  relation "orderitemsid" already exists
psql:/home/david/sl.sql:68: ERROR:  relation "jcitemsid" already exists
psql:/home/david/sl.sql:49809: WARNING:  changing return type of function del_yearend from "opaque" to "trigger"
psql:/home/david/sl.sql:49811: WARNING:  changing return type of function del_department from "opaque" to "trigger"
psql:/home/david/sl.sql:49819: WARNING:  changing return type of function del_customer from "opaque" to "trigger"
psql:/home/david/sl.sql:49821: WARNING:  changing return type of function del_vendor from "opaque" to "trigger"
psql:/home/david/sl.sql:49823: WARNING:  changing return type of function del_exchangerate from "opaque" to "trigger"
psql:/home/david/sl.sql:49829: WARNING:  changing return type of function check_inventory from "opaque" to "trigger"
psql:/home/david/sl.sql:49831: WARNING:  changing return type of function check_department from "opaque" to "trigger"
psql:/home/david/sl.sql:49839: WARNING:  changing return type of function del_recurring from "opaque" to "trigger"
..hidden..:~ # cat 2stderr 
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql:1: ERROR:  relation "session_session_id_seq" already exists
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql:8: ERROR:  relation "session" already exists
..hidden..:~ # cat 3stderr
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:2: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "chart_pkey" for table "chart"
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:13: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "acc_trans_pkey" for table "acc_trans"
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:106: ERROR:  relation "transactions" already exists
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:108: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:111: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/usr/local/ledgersmb/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql:114: ERROR:  current transaction is aborted, commands ignored until end of transaction block
etc... 
etc...