Menu ▾ ▴

#1388 Upgrade from 1.4 to master fails with ERROR: must be owner of function defaults_get_defaultcurrency

1.5
closed-duplicate
nobody
None
1.4
5
2015-10-24
2015-07-05
John Locke
No

Testing out new Docker images, wanting to see Erik's work on 1.5, but cannot get a working database! Already-known issue installing a new database, and prepare-company-database.pl not yet updated. But upgrade from 1.4 is supposed to work.

Using the new Docker images, this fails.

Steps to reproduce

With Docker (>= 1.7) installed and working on your system:

  • docker run --name mypostgres -e POSTGRES_PASSWORD=testpsql -d postgres

  • docker run --link mypostgres:postgres -p 5000:5000 -ti --rm ledgersmb/ledgersmb

  • Visit http://localhost:5000/setup.pl in your browser, log in with user "postgres" password "testpsql" database "test"

  • Create database, login, etc.

So far so good! Working LSMB.

Now try upgrading:

  • kill the LedgerSMB container (Ctrl-C in terminal, or docker stop <container name="">)</container>
  • Delete the container (docker rm <container name=""> -- use docker ps -a to find container name if necessary)</container>

  • docker run --link mypostgres:postgres -p 5000:5000 -ti --rm ledgersmb/ledgersmb:dev-master

  • Visit http://localhost:5000/setup.pl, log in with user "postgres" password "testpsql" database "test"

  • Click button to upgrade database

Result:

Error!

psql:sql/modules/Settings.sql:20: ERROR: must be owner of function defaults_get_defaultcurrency at /usr/local/lib/perl5/site_perl/5.22.0/PGObject/Util/DBAdmin.pm line 246.
PGObject::Util::DBAdmin::run_file(LedgerSMB::Database=HASH(0x6a95d10), "file", "sql/modules/Settings.sql", "log_stdout", "/tmp/ledgersmb/dblog_2015-07-05T192406_18_stdout", "log_stderr", "/tmp/ledgersmb/dblog_2015-07-05T192406_18_stderr") called at LedgerSMB/Database.pm line 358 LedgerSMB::Database::load_modules(LedgerSMB::Database=HASH(0x6a95d10), "LOADORDER", HASH(0x834ea48)) called at LedgerSMB/Database.pm line 425 LedgerSMB::Database::upgrade_modules(LedgerSMB::Database=HASH(0x6a95d10), "LOADORDER", "1.4.999") called at LedgerSMB/Scripts/setup.pm line 1122 LedgerSMB::Scripts::setup::rebuild_modules(LedgerSMB=HASH(0x695fc00)) called at lsmb-request.pl line 145 LedgerSMB::Handler::try {...} () called at /usr/local/lib/perl5/site_perl/5.22.0/Try/Tiny.pm line 81 eval {...} called at /usr/local/lib/perl5/site_perl/5.22.0/Try/Tiny.pm line 72 Try::Tiny::try(CODE(0x69645c8), Try::Tiny::Catch=REF(0x7c031a0)) called at lsmb-request.pl line 157 LedgerSMB::Handler::call_script("setup.pl", LedgerSMB=HASH(0x695fc00), LedgerSMB::Locale::en=HASH(0x69645b0)) called at lsmb-request.pl line 185 require lsmb-request.pl called at LedgerSMB/PSGI.pm line 76 LedgerSMB::PSGI::_run_new("setup.pl") called at LedgerSMB/PSGI.pm line 41 LedgerSMB::PSGI::ANON() called at /usr/share/perl5/CGI/Emulate/PSGI.pm line 29 CGI::Emulate::PSGI::ANON(HASH(0x7bff928)) called at /usr/local/lib/perl5/site_perl/5.22.0/Plack/Middleware/Static.pm line 18 Plack::Middleware::Static::call(Plack::Middleware::Static=HASH(0x7c48268), HASH(0x7bff928)) called at /usr/local/lib/perl5/site_perl/5.22.0/Plack/Component.pm line 50 Plack::Component::ANON(HASH(0x7bff928)) called at /usr/local/lib/perl5/site_perl/5.22.0/Plack/Util.pm line 145 eval {...} called at /usr/local/lib/perl5/site_perl/5.22.0/Plack/Util.pm line 145 Plack::Util::run_app(CODE(0x7c481d8), HASH(0x7bff928)) called at /usr/share/perl5/Starman/Server.pm line 281 Starman::Server::process_request(Starman::Server=HASH(0x1ceb290), Net::Server::Proto::TCP=GLOB(0x7cadde0)) called at /usr/share/perl5/Net/Server.pm line 74 Net::Server::run_client_connection(Starman::Server=HASH(0x1ceb290)) called at /usr/share/perl5/Net/Server/PreFork.pm line 229 eval {...} called at /usr/share/perl5/Net/Server/PreFork.pm line 229 Net::Server::PreFork::run_child(Starman::Server=HASH(0x1ceb290)) called at /usr/share/perl5/Net/Server/PreFork.pm line 187 Net::Server::PreFork::run_n_children(Starman::Server=HASH(0x1ceb290), 5) called at /usr/share/perl5/Net/Server/PreFork.pm line 111 Net::Server::PreFork::loop(Starman::Server=HASH(0x1ceb290)) called at /usr/share/perl5/Net/Server.pm line 60 Net::Server::run(Starman::Server=HASH(0x1ceb290), "port", ARRAY(0x20aabf8), "host", "*", "proto", "tcp", "serialize", "none", ...) called at /usr/share/perl5/Starman/Server.pm line 89 Starman::Server::run(Starman::Server=HASH(0x1ceb290), CODE(0x1ceb1e8), HASH(0x1a8dbe0)) called at /usr/share/perl5/Plack/Handler/Starman.pm line 18 Plack::Handler::Starman::run(Plack::Handler::Starman=HASH(0x1ceb1d0), CODE(0x1ceb1e8)) called at /usr/local/lib/perl5/site_perl/5.22.0/Plack/Loader/Delayed.pm line 20 Plack::Loader::Delayed::run(Plack::Loader::Delayed=HASH(0x1ca02a0), Plack::Handler::Starman=HASH(0x1ceb1d0)) called at /usr/local/lib/perl5/site_perl/5.22.0/Plack/Runner.pm line 277 Plack::Runner::run(Plack::Runner=HASH(0x1c0aaa8)) called at /usr/bin/starman line 38

dbversion: 1.4.999, company: test

Discussion

  • Chris Travers

    Chris Travers - 2015-10-24

    Movign o github for better tracking

     

  • Chris Travers

    Chris Travers - 2015-10-24
    • status: open --> closed-duplicate
     
MongoDB Logo MongoDB