One more thing.. this is Postgresql 8.3 I don't really have a choice.
david wrote: > 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... > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > 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 ------------------------------------------------------------------------- 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
