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...
------------------------------------------------------------------------
-------------------------------------------------------------------------
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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users