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.
[EMAIL PROTECTED]:~ # psql -d 2009lsmb -h localhost -U ledgersmb -f /home/david/sl.sql -L
1logfile -o 1output > 1stdout 2> 1stderr
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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"
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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...
[EMAIL PROTECTED]:~ # psql -d 2009lsmb -h localhost -U ledgersmb -f
/home/david/sl.sql -L 1logfile -o 1output > 1stdout 2> 1stderr
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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"
[EMAIL PROTECTED]:~ # 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
[EMAIL PROTECTED]:~ # 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...
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
