Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Updating the application: manual section without content #160

Open
neteler opened this issue Sep 21, 2020 · 3 comments
Open

Updating the application: manual section without content #160

neteler opened this issue Sep 21, 2020 · 3 comments

Comments

@neteler
Copy link

neteler commented Sep 21, 2020

We are currently trying to update from GNOS 3.6 to 3.8. Unfortunately the DB then "disappears", i.e. data do not show up in 3.8.

Looking at the documentation:

"Updating the application"

... does not have any content.

Please document how to do upgrading (or add pointers to existing documentation elsewhere). Thanks!
@pvgenuchten
Copy link

Markus, interesting these pages are blank...
Update of database is usually automatic at restart
My guess is that the database connection is lost.
Can you check the tomcat log for errors related to database connectivity

@neteler
Copy link
Author

neteler commented Sep 23, 2020

Paul, here the log:

docker-compose up
Creating network "geonetwork_upgrade_default" with the default driver
Creating geonetwork_upgrade_postgres_1 ... done
Creating geonetwork_upgrade_geonetwork_1 ... done
Attaching to geonetwork_upgrade_postgres_1, geonetwork_upgrade_geonetwork_1
postgres_1    | 
postgres_1    | PostgreSQL Database directory appears to contain a database; Skipping initialization
postgres_1    | 
postgres_1    | 2020-09-22 07:56:19.146 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
postgres_1    | 2020-09-22 07:56:19.147 UTC [1] LOG:  listening on IPv6 address "::", port 5432
postgres_1    | 2020-09-22 07:56:19.150 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1    | 2020-09-22 07:56:19.179 UTC [24] LOG:  database system was interrupted; last known up at 2020-09-22 06:23:43 UTC
postgres_1    | 2020-09-22 07:56:19.423 UTC [24] LOG:  database system was not properly shut down; automatic recovery in progress
postgres_1    | 2020-09-22 07:56:19.425 UTC [24] LOG:  redo starts at 0/2B28ED0
postgres_1    | 2020-09-22 07:56:19.425 UTC [24] LOG:  invalid record length at 0/2B28FB0: wanted 24, got 0
postgres_1    | 2020-09-22 07:56:19.425 UTC [24] LOG:  redo done at 0/2B28F78
postgres_1    | 2020-09-22 07:56:19.438 UTC [1] LOG:  database system is ready to accept connections
geonetwork_1  | db host: postgres
geonetwork_1  | db port: 5432
geonetwork_1  | Database 'geonetwork' exists; skipping createdb
geonetwork_1  | 22-Sep-2020 07:56:22.245 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/8.5.58
geonetwork_1  | 22-Sep-2020 07:56:22.259 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Sep 10 2020 21:45:33 UTC
geonetwork_1  | 22-Sep-2020 07:56:22.260 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 8.5.58.0
geonetwork_1  | 22-Sep-2020 07:56:22.261 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
geonetwork_1  | 22-Sep-2020 07:56:22.261 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            4.15.0-52-generic
geonetwork_1  | 22-Sep-2020 07:56:22.262 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
geonetwork_1  | 22-Sep-2020 07:56:22.262 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/local/openjdk-8/jre
geonetwork_1  | 22-Sep-2020 07:56:22.263 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_265-b01
geonetwork_1  | 22-Sep-2020 07:56:22.263 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
geonetwork_1  | 22-Sep-2020 07:56:22.268 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat
geonetwork_1  | 22-Sep-2020 07:56:22.269 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat
geonetwork_1  | 22-Sep-2020 07:56:22.270 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat/conf/logging.properties
geonetwork_1  | 22-Sep-2020 07:56:22.270 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
geonetwork_1  | 22-Sep-2020 07:56:22.271 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.egd=file:/dev/./urandom
geonetwork_1  | 22-Sep-2020 07:56:22.271 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
geonetwork_1  | 22-Sep-2020 07:56:22.271 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512m
geonetwork_1  | 22-Sep-2020 07:56:22.272 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx2024m
geonetwork_1  | 22-Sep-2020 07:56:22.272 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:NewSize=512m
geonetwork_1  | 22-Sep-2020 07:56:22.272 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxNewSize=1024m
geonetwork_1  | 22-Sep-2020 07:56:22.273 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseConcMarkSweepGC
geonetwork_1  | 22-Sep-2020 07:56:22.273 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
geonetwork_1  | 22-Sep-2020 07:56:22.273 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
geonetwork_1  | 22-Sep-2020 07:56:22.273 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
geonetwork_1  | 22-Sep-2020 07:56:22.274 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dgeonetwork.dir=/var/lib/geonetwork_data
geonetwork_1  | 22-Sep-2020 07:56:22.274 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
geonetwork_1  | 22-Sep-2020 07:56:22.274 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat
geonetwork_1  | 22-Sep-2020 07:56:22.274 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat
geonetwork_1  | 22-Sep-2020 07:56:22.275 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat/temp
geonetwork_1  | 22-Sep-2020 07:56:22.275 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.25] using APR version [1.6.5].
geonetwork_1  | 22-Sep-2020 07:56:22.275 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
geonetwork_1  | 22-Sep-2020 07:56:22.275 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
geonetwork_1  | 22-Sep-2020 07:56:22.295 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.1d  10 Sep 2019]
geonetwork_1  | 22-Sep-2020 07:56:22.530 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
geonetwork_1  | 22-Sep-2020 07:56:22.567 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
geonetwork_1  | 22-Sep-2020 07:56:22.608 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1366 ms
geonetwork_1  | 22-Sep-2020 07:56:22.665 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
geonetwork_1  | 22-Sep-2020 07:56:22.666 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.58
geonetwork_1  | 22-Sep-2020 07:56:22.704 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/usr/local/tomcat/webapps/geonetwork]
geonetwork_1  | 22-Sep-2020 07:56:38.099 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log No Spring WebApplicationInitializer types detected on classpath
postgres_1    | 2020-09-22 07:56:51.300 UTC [65] ERROR:  constraint "uk_fwi9l3n3vcxonf7c3x1ntdivx" of relation "links" does not exist
postgres_1    | 2020-09-22 07:56:51.300 UTC [65] STATEMENT:  alter table Links drop constraint UK_fwi9l3n3vcxonf7c3x1ntdivx
postgres_1    | 2020-09-22 07:56:51.308 UTC [65] ERROR:  constraint "uk_itccbjhvevxbh1g4axknj8n24" of relation "metadatadraft" does not exist
postgres_1    | 2020-09-22 07:56:51.308 UTC [65] STATEMENT:  alter table MetadataDraft drop constraint UK_itccbjhvevxbh1g4axknj8n24
postgres_1    | 2020-09-22 07:56:51.310 UTC [65] ERROR:  constraint "uk_fuc1tr6xyyrbjrxg0feavofb2" of relation "metadatadraft" does not exist
postgres_1    | 2020-09-22 07:56:51.310 UTC [65] STATEMENT:  alter table MetadataDraft drop constraint UK_fuc1tr6xyyrbjrxg0feavofb2
geonetwork_1  | 22-Sep-2020 07:57:08.162 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log jolokia-agent: Using policy access restrictor classpath:/jolokia-access.xml
geonetwork_1  | 22-Sep-2020 07:57:18.752 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log Initializing Spring FrameworkServlet 'spring'
geonetwork_1  | 22-Sep-2020 07:57:25.356 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/usr/local/tomcat/webapps/geonetwork] has finished in [62,652] ms
geonetwork_1  | 22-Sep-2020 07:57:25.371 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
geonetwork_1  | 22-Sep-2020 07:57:25.458 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 62849 ms

@neteler
Copy link
Author

neteler commented Sep 29, 2020

Do you have any hints how to proceed here?

@neteler neteler changed the title Updating the application: not described Updating the application: manual section without content Sep 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@pvgenuchten @neteler