Guest User!

You are not Sophos Staff.

This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upgrade to SFOS 18.0.5 MR5-Build586 (18.0.5.586) failed

Upgrade from SFOS 18.0.4 MR-4 to SFOS 18.0.5 MR5-Build586 (18.0.5.586) fails for me repeatedly due to a config migration failure. See a screenshot below. Is there a way to fix this issue? Its running on KVM on Ubuntu on an Intel PC. SFOS 18.0.4 MR-4 works great btw.



This thread was automatically locked due to age.
  • Hi,

    is this a home or business XG?

    ian

  • Check the /log/migration.log for a potential issue. 

  • Pasting the contents of the log below. Looks like the DB upgrade is failing.

    SFVH_SO01_SFOS 18.0.4 MR-4# cat /log/migration.log
    Sun Jan 31 07:11:11 UTC 2021 starting old version corporate db
    Starting conf database
    360 2021-01-31 07:11:11.888 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    360 2021-01-31 07:11:11.888 GMTLOG:  disabling statistics collector for lack of working socket
    362 2021-01-31 07:11:11.889 GMTLOG:  database system was shut down at 2021-01-31 07:10:49 GMT
    360 2021-01-31 07:11:11.904 GMTLOG:  database system is ready to accept connections
    2021-01-31 12:41:13.683777+05:30
    Sun Jan 31 07:11:13 UTC 2021 : Database started after 0 seconds
    DROP SCHEMA
    UPDATE 3
    Stopping database
    360 2021-01-31 07:11:16.492 GMTLOG:  received fast shutdown request
    360 2021-01-31 07:11:16.492 GMTLOG:  aborting any active transactions
    363 2021-01-31 07:11:16.493 GMTLOG:  shutting down
    363 2021-01-31 07:11:17.068 GMTLOG:  database system is shut down
    Sun Jan 31 12:41:17 IST 2021 : Database stopped after 1 seconds
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    410 2021-01-31 07:11:19.082 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    410 2021-01-31 07:11:19.082 GMTLOG:  disabling statistics collector for lack of working socket
    412 2021-01-31 07:11:19.083 GMTLOG:  database system was shut down at 2020-12-06 01:18:18 GMT
    410 2021-01-31 07:11:19.109 GMTLOG:  database system is ready to accept connections
    2021-01-31 07:11:21.041192+00
    Sun Jan 31 12:41:21 IST 2021 : Database started after 0 seconds
    DROP SCHEMA config CASCADE
    DROP SCHEMA
    DROP SCHEMA public CASCADE
    DROP SCHEMA
    DROP PROCEDURAL LANGUAGE plpgsql
    424 2021-01-31 07:11:22.878 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    424 2021-01-31 07:11:22.878 GMTHINT:  You can drop extension plpgsql instead.
    424 2021-01-31 07:11:22.878 GMTSTATEMENT:  DROP PROCEDURAL LANGUAGE plpgsql
    ERROR:  cannot drop language plpgsql because extension plpgsql requires it
    HINT:  You can drop extension plpgsql instead.
    CREATE SCHEMA public
    CREATE SCHEMA
    psql:/sdisk/oldpgconfdump.sql:18460: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:18460: WARNING:  column "receipientemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
     setval
    --------
        160
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
         64
    (1 row)
    
    413 2021-01-31 07:11:30.278 GMTLOG:  checkpoints are occurring too frequently (11 seconds apart)
    413 2021-01-31 07:11:30.278 GMTHINT:  Consider increasing the configuration parameter "checkpoint_segments".
    Stopping database
    410 2021-01-31 07:11:42.827 GMTLOG:  received fast shutdown request
    410 2021-01-31 07:11:42.827 GMTLOG:  aborting any active transactions
    413 2021-01-31 07:11:44.832 GMTLOG:  shutting down
    413 2021-01-31 07:11:45.300 GMTLOG:  database system is shut down
    Sun Jan 31 12:41:45 IST 2021 : Database stopped after 3 seconds
    old conf to new conf migrated with return value :: 0
    Sun Jan 31 12:41:46 IST 2021 starting migration log
    Starting conf database
    485 2021-01-31 07:11:46.386 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    485 2021-01-31 07:11:46.386 GMTLOG:  disabling statistics collector for lack of working socket
    487 2021-01-31 07:11:46.386 GMTLOG:  database system was shut down at 2021-01-31 07:11:45 GMT
    485 2021-01-31 07:11:46.399 GMTLOG:  database system is ready to accept connections
    2021-01-31 07:11:48.288303+00
    Sun Jan 31 12:41:48 IST 2021 : Database started after 0 seconds
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    UPDATE 1
    INSERT 0 1
    UPDATE 1
    nvram_get failed with -16
    Old version is 18.013 and currentversion is 18.031
    Database is upgrading to dbv18.014
    Check migration for version dbv18.014
    Applying migration for version dbv18.014
    Database is upgrading to dbv18.015
    Check migration for version dbv18.015
    Applying migration for version dbv18.015
     disable_sfm_invalid_ip_port
    -----------------------------
    
    (1 row)
    
     migrate_v17_5_mr15_tov18_0_mr4
    --------------------------------
    
    (1 row)
    
    Database is upgrading to dbv18.016
    Check migration for version dbv18.016
    Applying migration for version dbv18.016
    Database is upgrading to dbv18.030
    Check migration for version dbv18.030
    Applying migration for version dbv18.030
    Database is upgrading to dbv18.031
    Check migration for version dbv18.031
    Applying migration for version dbv18.031
     create_pguser
    ---------------
    
    (1 row)
    
     create_default_snat_rule
    --------------------------
    
    (1 row)
    
    UPDATE 1
    Stopping database
    485 2021-01-31 07:11:56.315 GMTLOG:  received fast shutdown request
    485 2021-01-31 07:11:56.315 GMTLOG:  aborting any active transactions
    488 2021-01-31 07:11:56.315 GMTLOG:  shutting down
    488 2021-01-31 07:11:57.003 GMTLOG:  database system is shut down
    Sun Jan 31 12:41:57 IST 2021 : Database stopped after 1 seconds
    applymigration.sh exited with 0
    Doing /conf/certificate/cacerts/
    WARNING: Skipping expired Certificate Thawte_Timestamping_CA.pem
    WARNING: Skipping expired Certificate Sigov_CA.pem
    Sun Jan 31 12:42:03 IST 2021: Before mountconf unmount
    Fri May 21 17:50:54 UTC 2021 starting old version corporate db
    Starting conf database
    364 2021-05-21 17:50:58.466 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    364 2021-05-21 17:50:58.466 GMTLOG:  disabling statistics collector for lack of working socket
    367 2021-05-21 17:50:58.467 GMTLOG:  database system shutdown was interrupted; last known up at 2021-05-21 17:49:46 GMT
    368 2021-05-21 17:50:58.467 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    370 2021-05-21 17:50:58.470 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    367 2021-05-21 17:50:58.854 GMTLOG:  database system was not properly shut down; automatic recovery in progress
    367 2021-05-21 17:50:59.078 GMTLOG:  redo starts at 0/5CBD0604
    367 2021-05-21 17:50:59.079 GMTLOG:  record with zero length at 0/5CBD0F94
    367 2021-05-21 17:50:59.079 GMTLOG:  redo done at 0/5CBD0F40
    367 2021-05-21 17:50:59.079 GMTLOG:  last completed transaction was at log time 2021-05-21 17:49:46.483763+00
    374 2021-05-21 17:50:59.481 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    364 2021-05-21 17:51:00.348 GMTLOG:  database system is ready to accept connections
    2021-05-21 23:21:00.552458+05:30
    Fri May 21 17:51:01 UTC 2021 : Database started after 3 seconds
    DROP SCHEMA
    UPDATE 3
    Stopping database
    364 2021-05-21 17:51:07.214 GMTLOG:  received fast shutdown request
    364 2021-05-21 17:51:07.214 GMTLOG:  aborting any active transactions
    377 2021-05-21 17:51:07.215 GMTLOG:  shutting down
    377 2021-05-21 17:51:10.885 GMTLOG:  database system is shut down
    Fri May 21 23:21:11 IST 2021 : Database stopped after 4 seconds
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    448 2021-05-21 17:51:16.479 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    448 2021-05-21 17:51:16.479 GMTLOG:  disabling statistics collector for lack of working socket
    450 2021-05-21 17:51:16.480 GMTLOG:  database system was shut down at 2021-04-23 12:19:24 GMT
    452 2021-05-21 17:51:16.899 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    454 2021-05-21 17:51:16.901 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    448 2021-05-21 17:51:16.956 GMTLOG:  database system is ready to accept connections
    2021-05-21 17:51:17.929362+00
    Fri May 21 23:21:18 IST 2021 : Database started after 2 seconds
    DROP SCHEMA config CASCADE
    DROP SCHEMA
    DROP SCHEMA public CASCADE
    DROP SCHEMA
    DROP PROCEDURAL LANGUAGE plpgsql
    470 2021-05-21 17:51:27.154 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    470 2021-05-21 17:51:27.154 GMTHINT:  You can drop extension plpgsql instead.
    470 2021-05-21 17:51:27.154 GMTSTATEMENT:  DROP PROCEDURAL LANGUAGE plpgsql
    ERROR:  cannot drop language plpgsql because extension plpgsql requires it
    HINT:  You can drop extension plpgsql instead.
    CREATE SCHEMA public
    CREATE SCHEMA
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "receipientemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
     setval
    --------
        160
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
         74
    (1 row)
    
    Stopping database
    448 2021-05-21 18:02:38.954 GMTLOG:  received fast shutdown request
    448 2021-05-21 18:02:38.954 GMTLOG:  aborting any active transactions
    Fri May 21 23:33:09 IST 2021 : Database stopped after 30 seconds
    old conf to new conf migrated with return value :: 0
    Fri May 21 23:33:09 IST 2021 starting migration log
    Starting conf database
    725 2021-05-21 18:03:16.695 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    727 2021-05-21 18:03:16.698 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    722 2021-05-21 18:03:16.829 GMTLOG:  could not bind IPv4 socket: Address already in use
    722 2021-05-21 18:03:16.829 GMTHINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
    722 2021-05-21 18:03:16.830 GMTFATAL:  could not create any TCP/IP sockets
    457 2021-05-21 18:03:16.833 GMTLOG:  shutting down
    731 2021-05-21 18:03:17.708 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    735 2021-05-21 18:03:18.718 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    739 2021-05-21 18:03:19.728 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    743 2021-05-21 18:03:20.738 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    747 2021-05-21 18:03:21.747 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    751 2021-05-21 18:03:22.757 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    755 2021-05-21 18:03:23.766 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    759 2021-05-21 18:03:24.776 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    763 2021-05-21 18:03:25.785 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    457 2021-05-21 18:03:26.351 GMTLOG:  database system is shut down
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    Fri May 21 23:33:47 IST 2021 : Database started after 30 seconds
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    nvram_get failed with -16
    Old version is 18.031 and currentversion is 18.034
    Database is upgrading to dbv18.032
    Check migration for version dbv18.032
    Applying migration for version dbv18.032
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    /bin/psql -1 -p 5432 -U pgroot -q  -d corporate -f /_conf//DB/dbv18.032/corporate.sql Failed
    /bin/sh /_conf//DB/dbv18.032/migration.sh Failed
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    Stopping database
    kill: you need to specify whom to kill
    Fri May 21 23:33:49 IST 2021 : Database stopped after 0 seconds
    applymigration.sh exited with 1
    Fri May 21 19:04:57 BST 2021: Before mountconf unmount
    Fri May 21 18:10:24 UTC 2021 starting old version corporate db
    Starting conf database
    345 2021-05-21 18:10:29.833 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    345 2021-05-21 18:10:29.833 GMTLOG:  disabling statistics collector for lack of working socket
    348 2021-05-21 18:10:29.834 GMTLOG:  database system shutdown was interrupted; last known up at 2021-05-21 17:49:46 GMT
    349 2021-05-21 18:10:29.834 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    351 2021-05-21 18:10:29.837 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    348 2021-05-21 18:10:30.367 GMTLOG:  database system was not properly shut down; automatic recovery in progress
    348 2021-05-21 18:10:30.771 GMTLOG:  redo starts at 0/5CBD0604
    348 2021-05-21 18:10:30.772 GMTLOG:  record with zero length at 0/5CBD0F94
    348 2021-05-21 18:10:30.772 GMTLOG:  redo done at 0/5CBD0F40
    348 2021-05-21 18:10:30.772 GMTLOG:  last completed transaction was at log time 2021-05-21 17:49:46.483763+00
    355 2021-05-21 18:10:30.848 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    359 2021-05-21 18:10:31.858 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    345 2021-05-21 18:10:32.759 GMTLOG:  database system is ready to accept connections
    2021-05-21 23:40:32.944473+05:30
    Fri May 21 18:10:33 UTC 2021 : Database started after 4 seconds
    DROP SCHEMA
    UPDATE 3
    Stopping database
    345 2021-05-21 18:10:39.527 GMTLOG:  received fast shutdown request
    345 2021-05-21 18:10:39.527 GMTLOG:  aborting any active transactions
    362 2021-05-21 18:10:39.528 GMTLOG:  shutting down
    362 2021-05-21 18:10:43.840 GMTLOG:  database system is shut down
    Fri May 21 23:40:44 IST 2021 : Database stopped after 5 seconds
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    439 2021-05-21 18:10:50.864 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    439 2021-05-21 18:10:50.864 GMTLOG:  disabling statistics collector for lack of working socket
    441 2021-05-21 18:10:50.865 GMTLOG:  database system was shut down at 2021-04-23 12:19:24 GMT
    443 2021-05-21 18:10:51.531 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    445 2021-05-21 18:10:51.534 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    439 2021-05-21 18:10:51.860 GMTLOG:  database system is ready to accept connections
    2021-05-21 18:10:52.562076+00
    Fri May 21 23:40:53 IST 2021 : Database started after 2 seconds
    DROP SCHEMA config CASCADE
    DROP SCHEMA
    DROP SCHEMA public CASCADE
    DROP SCHEMA
    DROP PROCEDURAL LANGUAGE plpgsql
    461 2021-05-21 18:11:09.185 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    461 2021-05-21 18:11:09.185 GMTHINT:  You can drop extension plpgsql instead.
    461 2021-05-21 18:11:09.185 GMTSTATEMENT:  DROP PROCEDURAL LANGUAGE plpgsql
    ERROR:  cannot drop language plpgsql because extension plpgsql requires it
    HINT:  You can drop extension plpgsql instead.
    CREATE SCHEMA public
    CREATE SCHEMA
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "receipientemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
     setval
    --------
        160
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
         74
    (1 row)
    
    Stopping database
    439 2021-05-21 18:25:54.140 GMTLOG:  received fast shutdown request
    439 2021-05-21 18:25:54.140 GMTLOG:  aborting any active transactions
    448 2021-05-21 18:25:55.523 GMTLOG:  shutting down
    Fri May 21 23:56:24 IST 2021 : Database stopped after 30 seconds
    old conf to new conf migrated with return value :: 0
    Fri May 21 23:56:25 IST 2021 starting migration log
    Starting conf database
    439 2021-05-21 18:26:32.209 GMTLOG:  lock file "postmaster.pid" contains wrong PID: 714 instead of 439
    439 2021-05-21 18:26:32.209 GMTLOG:  performing immediate shutdown because data directory lock file is invalid
    439 2021-05-21 18:26:32.209 GMTLOG:  received immediate shutdown request
    717 2021-05-21 18:26:32.209 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    714 2021-05-21 18:26:32.582 GMTLOG:  could not open file "postmaster.pid": No such file or directory
    714 2021-05-21 18:26:32.583 GMTLOG:  could not open file "postmaster.pid": No such file or directory
    714 2021-05-21 18:26:32.597 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    714 2021-05-21 18:26:32.597 GMTLOG:  disabling statistics collector for lack of working socket
    721 2021-05-21 18:26:32.598 GMTLOG:  database system shutdown was interrupted; last known up at 2021-05-21 18:25:55 GMT
    723 2021-05-21 18:26:33.221 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    721 2021-05-21 18:26:33.247 GMTLOG:  database system was not properly shut down; automatic recovery in progress
    721 2021-05-21 18:26:33.570 GMTLOG:  redo starts at 0/E1688DC
    721 2021-05-21 18:26:33.966 GMTLOG:  record with zero length at 0/E651CB8
    721 2021-05-21 18:26:33.966 GMTLOG:  redo done at 0/E651C64
    721 2021-05-21 18:26:33.966 GMTLOG:  last completed transaction was at log time 2021-05-21 18:25:51.42631+00
    727 2021-05-21 18:26:34.230 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    731 2021-05-21 18:26:35.240 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    735 2021-05-21 18:26:36.250 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    739 2021-05-21 18:26:37.259 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    743 2021-05-21 18:26:38.269 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    747 2021-05-21 18:26:39.278 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    751 2021-05-21 18:26:40.287 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    755 2021-05-21 18:26:41.297 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    759 2021-05-21 18:26:42.308 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    763 2021-05-21 18:26:43.317 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    767 2021-05-21 18:26:44.327 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    771 2021-05-21 18:26:45.337 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    775 2021-05-21 18:26:46.347 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    779 2021-05-21 18:26:47.356 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    783 2021-05-21 18:26:48.365 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    787 2021-05-21 18:26:49.375 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    714 2021-05-21 18:26:49.943 GMTLOG:  database system is ready to accept connections
    2021-05-21 18:26:50.424397+00
    Fri May 21 23:56:51 IST 2021 : Database started after 19 seconds
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    UPDATE 1
    INSERT 0 1
    UPDATE 1
    nvram_get failed with -16
    Old version is 18.031 and currentversion is 18.034
    Database is upgrading to dbv18.032
    Check migration for version dbv18.032
    Applying migration for version dbv18.032
     remove_duplicate_entry
    ------------------------
    
    (1 row)
    
    714 2021-05-21 18:27:47.050 GMTLOG:  could not open file "postmaster.pid": No such file or directory
    714 2021-05-21 18:27:47.050 GMTLOG:  performing immediate shutdown because data directory lock file is invalid
    714 2021-05-21 18:27:47.050 GMTLOG:  received immediate shutdown request
    psql: server closed the connection unexpectedly
    	This probably means the server terminated abnormally
    	before or while processing the request.
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    DBI connect('dbname=corporate;','nobody',...) failed: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"? at /_conf//DB/migratesecuredata.pl line 339.
    Secure password migration Failed
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    Stopping database
    kill: you need to specify whom to kill
    Fri May 21 23:57:49 IST 2021 : Database stopped after 0 seconds
    applymigration.sh exited with 1
    Fri May 21 22:39:19 UTC 2021 starting old version corporate db
    Starting conf database
    345 2021-05-21 22:39:27.657 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    345 2021-05-21 22:39:27.657 GMTLOG:  disabling statistics collector for lack of working socket
    348 2021-05-21 22:39:27.658 GMTLOG:  database system was shut down at 2021-05-21 22:35:11 GMT
    349 2021-05-21 22:39:27.658 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    351 2021-05-21 22:39:27.661 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    345 2021-05-21 22:39:28.332 GMTLOG:  database system is ready to accept connections
    2021-05-22 04:09:28.72502+05:30
    Fri May 21 22:39:29 UTC 2021 : Database started after 2 seconds
    DROP SCHEMA
    UPDATE 3
    Stopping database
    345 2021-05-21 22:39:38.179 GMTLOG:  received fast shutdown request
    345 2021-05-21 22:39:38.179 GMTLOG:  aborting any active transactions
    354 2021-05-21 22:39:38.180 GMTLOG:  shutting down
    354 2021-05-21 22:39:42.531 GMTLOG:  database system is shut down
    Sat May 22 04:09:43 IST 2021 : Database stopped after 5 seconds
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    432 2021-05-21 22:39:53.353 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    432 2021-05-21 22:39:53.353 GMTLOG:  disabling statistics collector for lack of working socket
    435 2021-05-21 22:39:53.353 GMTLOG:  database system was shut down at 2021-04-23 12:19:24 GMT
    436 2021-05-21 22:39:53.353 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    438 2021-05-21 22:39:53.356 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    432 2021-05-21 22:39:54.272 GMTLOG:  database system is ready to accept connections
    2021-05-21 22:39:54.383076+00
    Sat May 22 04:09:55 IST 2021 : Database started after 2 seconds
    DROP SCHEMA config CASCADE
    DROP SCHEMA
    DROP SCHEMA public CASCADE
    DROP SCHEMA
    DROP PROCEDURAL LANGUAGE plpgsql
    454 2021-05-21 22:40:10.922 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    454 2021-05-21 22:40:10.922 GMTHINT:  You can drop extension plpgsql instead.
    454 2021-05-21 22:40:10.922 GMTSTATEMENT:  DROP PROCEDURAL LANGUAGE plpgsql
    ERROR:  cannot drop language plpgsql because extension plpgsql requires it
    HINT:  You can drop extension plpgsql instead.
    CREATE SCHEMA public
    CREATE SCHEMA
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "receipientemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
     setval
    --------
        160
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
         74
    (1 row)
    
    Stopping database
    432 2021-05-21 22:50:47.095 GMTLOG:  received fast shutdown request
    432 2021-05-21 22:50:47.096 GMTLOG:  aborting any active transactions
    441 2021-05-21 22:50:49.599 GMTLOG:  shutting down
    Sat May 22 04:21:17 IST 2021 : Database stopped after 30 seconds
    old conf to new conf migrated with return value :: 0
    Sat May 22 04:21:18 IST 2021 starting migration log
    Starting conf database
    432 2021-05-21 22:51:24.234 GMTLOG:  lock file "postmaster.pid" contains wrong PID: 707 instead of 432
    432 2021-05-21 22:51:24.234 GMTLOG:  performing immediate shutdown because data directory lock file is invalid
    432 2021-05-21 22:51:24.234 GMTLOG:  received immediate shutdown request
    710 2021-05-21 22:51:24.234 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    707 2021-05-21 22:51:24.690 GMTLOG:  could not open file "postmaster.pid": No such file or directory
    707 2021-05-21 22:51:24.690 GMTLOG:  could not open file "postmaster.pid": No such file or directory
    707 2021-05-21 22:51:24.706 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    707 2021-05-21 22:51:24.706 GMTLOG:  disabling statistics collector for lack of working socket
    714 2021-05-21 22:51:24.707 GMTLOG:  database system shutdown was interrupted; last known up at 2021-05-21 22:50:49 GMT
    716 2021-05-21 22:51:25.245 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    714 2021-05-21 22:51:25.263 GMTLOG:  database system was not properly shut down; automatic recovery in progress
    714 2021-05-21 22:51:25.645 GMTLOG:  redo starts at 0/E144BE0
    714 2021-05-21 22:51:26.032 GMTLOG:  record with zero length at 0/E62DF08
    714 2021-05-21 22:51:26.032 GMTLOG:  redo done at 0/E62DEB4
    714 2021-05-21 22:51:26.032 GMTLOG:  last completed transaction was at log time 2021-05-21 22:50:42.601686+00
    720 2021-05-21 22:51:26.255 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    724 2021-05-21 22:51:27.264 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    728 2021-05-21 22:51:28.277 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    732 2021-05-21 22:51:29.288 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    736 2021-05-21 22:51:30.298 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    740 2021-05-21 22:51:31.310 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    744 2021-05-21 22:51:32.319 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    748 2021-05-21 22:51:33.329 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    752 2021-05-21 22:51:34.338 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    756 2021-05-21 22:51:35.347 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    760 2021-05-21 22:51:36.356 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    764 2021-05-21 22:51:37.367 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    768 2021-05-21 22:51:38.377 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    772 2021-05-21 22:51:39.386 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    776 2021-05-21 22:51:40.395 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    780 2021-05-21 22:51:41.407 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    784 2021-05-21 22:51:42.418 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    788 2021-05-21 22:51:43.428 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    707 2021-05-21 22:51:44.405 GMTLOG:  database system is ready to accept connections
    2021-05-21 22:51:44.478036+00
    Sat May 22 04:21:45 IST 2021 : Database started after 21 seconds
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    INSERT 0 0
    UPDATE 1
    INSERT 0 1
    UPDATE 1
    nvram_get failed with -16
    Old version is 18.031 and currentversion is 18.034
    Database is upgrading to dbv18.032
    Check migration for version dbv18.032
    Applying migration for version dbv18.032
     remove_duplicate_entry
    ------------------------
    
    (1 row)
    
    707 2021-05-21 22:52:38.480 GMTLOG:  could not open file "postmaster.pid": No such file or directory
    707 2021-05-21 22:52:38.480 GMTLOG:  performing immediate shutdown because data directory lock file is invalid
    707 2021-05-21 22:52:38.481 GMTLOG:  received immediate shutdown request
    psql: server closed the connection unexpectedly
    	This probably means the server terminated abnormally
    	before or while processing the request.
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    DBI connect('dbname=corporate;','nobody',...) failed: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"? at /_conf//DB/migratesecuredata.pl line 339.
    Secure password migration Failed
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    Stopping database
    kill: you need to specify whom to kill
    Sat May 22 04:22:40 IST 2021 : Database stopped after 0 seconds
    applymigration.sh exited with 1
    Fri May 21 23:53:39 BST 2021: Before mountconf unmount
    Sat May 22 07:55:05 UTC 2021 starting old version corporate db
    Starting conf database
    366 2021-05-22 07:55:08.665 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    366 2021-05-22 07:55:08.665 GMTLOG:  disabling statistics collector for lack of working socket
    368 2021-05-22 07:55:08.668 GMTLOG:  database system shutdown was interrupted; last known up at 2021-05-22 07:54:07 GMT
    370 2021-05-22 07:55:09.172 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    372 2021-05-22 07:55:09.175 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    368 2021-05-22 07:55:09.415 GMTLOG:  database system was not properly shut down; automatic recovery in progress
    368 2021-05-22 07:55:09.643 GMTLOG:  redo starts at 0/5CED1044
    368 2021-05-22 07:55:09.644 GMTLOG:  record with zero length at 0/5CED1114
    368 2021-05-22 07:55:09.644 GMTLOG:  redo done at 0/5CED10C0
    368 2021-05-22 07:55:09.644 GMTLOG:  last completed transaction was at log time 2021-05-22 07:53:46.09801+00
    376 2021-05-22 07:55:10.187 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    366 2021-05-22 07:55:10.942 GMTLOG:  database system is ready to accept connections
    2021-05-22 13:25:11.274291+05:30
    Sat May 22 07:55:12 UTC 2021 : Database started after 3 seconds
    DROP SCHEMA
    UPDATE 3
    Stopping database
    366 2021-05-22 07:55:17.207 GMTLOG:  received fast shutdown request
    366 2021-05-22 07:55:17.207 GMTLOG:  aborting any active transactions
    379 2021-05-22 07:55:17.207 GMTLOG:  shutting down
    379 2021-05-22 07:55:20.098 GMTLOG:  database system is shut down
    Sat May 22 13:25:20 IST 2021 : Database stopped after 3 seconds
    /sdisk/oldpgconfdump.sql is created
    Starting conf database
    442 2021-05-22 07:55:26.267 GMTLOG:  could not connect socket for statistics collector: Network is unreachable
    442 2021-05-22 07:55:26.267 GMTLOG:  disabling statistics collector for lack of working socket
    444 2021-05-22 07:55:26.268 GMTLOG:  database system was shut down at 2021-04-23 12:19:24 GMT
    446 2021-05-22 07:55:26.864 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    448 2021-05-22 07:55:26.867 GMTFATAL:  the database system is starting up
    psql: FATAL:  the database system is starting up
    442 2021-05-22 07:55:27.279 GMTLOG:  database system is ready to accept connections
    2021-05-22 07:55:27.897048+00
    Sat May 22 13:25:28 IST 2021 : Database started after 2 seconds
    DROP SCHEMA config CASCADE
    DROP SCHEMA
    DROP SCHEMA public CASCADE
    DROP SCHEMA
    DROP PROCEDURAL LANGUAGE plpgsql
    464 2021-05-22 07:55:39.665 GMTERROR:  cannot drop language plpgsql because extension plpgsql requires it
    464 2021-05-22 07:55:39.665 GMTHINT:  You can drop extension plpgsql instead.
    464 2021-05-22 07:55:39.665 GMTSTATEMENT:  DROP PROCEDURAL LANGUAGE plpgsql
    ERROR:  cannot drop language plpgsql because extension plpgsql requires it
    HINT:  You can drop extension plpgsql instead.
    CREATE SCHEMA public
    CREATE SCHEMA
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "senderemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
    psql:/sdisk/oldpgconfdump.sql:18600: WARNING:  column "receipientemail" has type "unknown"
    DETAIL:  Proceeding with relation creation anyway.
     setval
    --------
        160
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
          1
    (1 row)
    
     setval
    --------
         74
    (1 row)
    
    Stopping database
    442 2021-05-22 08:11:56.356 GMTLOG:  received fast shutdown request
    442 2021-05-22 08:11:56.356 GMTLOG:  aborting any active transactions
    Sat May 22 13:42:26 IST 2021 : Database stopped after 30 seconds
    old conf to new conf migrated with return value :: 0
    Sat May 22 13:42:29 IST 2021 starting migration log
    451 2021-05-22 08:12:32.645 GMTLOG:  shutting down
    Starting conf database
    721 2021-05-22 08:12:34.700 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    723 2021-05-22 08:12:34.703 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    718 2021-05-22 08:12:35.323 GMTLOG:  could not bind IPv4 socket: Address already in use
    718 2021-05-22 08:12:35.323 GMTHINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
    718 2021-05-22 08:12:35.323 GMTFATAL:  could not create any TCP/IP sockets
    727 2021-05-22 08:12:35.712 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    731 2021-05-22 08:12:36.721 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    735 2021-05-22 08:12:37.731 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    739 2021-05-22 08:12:38.741 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    743 2021-05-22 08:12:39.754 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    442 2021-05-22 08:12:40.763 GMTLOG:  could not open file "postmaster.pid": No such file or directory
    442 2021-05-22 08:12:40.763 GMTLOG:  performing immediate shutdown because data directory lock file is invalid
    442 2021-05-22 08:12:40.763 GMTLOG:  received immediate shutdown request
    747 2021-05-22 08:12:40.764 GMTFATAL:  the database system is shutting down
    psql: FATAL:  the database system is shutting down
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    Sat May 22 13:43:05 IST 2021 : Database started after 30 seconds
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    nvram_get failed with -16
    Old version is 18.031 and currentversion is 18.034
    Database is upgrading to dbv18.032
    Check migration for version dbv18.032
    Applying migration for version dbv18.032
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    /bin/psql -1 -p 5432 -U pgroot -q  -d corporate -f /_conf//DB/dbv18.032/corporate.sql Failed
    /bin/sh /_conf//DB/dbv18.032/migration.sh Failed
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    psql: could not connect to server: No such file or directory
    	Is the server running locally and accepting
    	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
    Stopping database
    kill: you need to specify whom to kill
    Sat May 22 13:43:09 IST 2021 : Database stopped after 0 seconds
    applymigration.sh exited with 1
    Sat May 22 09:14:16 BST 2021: Before mountconf unmount
    

  • Please send a screenshot of your Email Notification screen in Webadmin. 

  • Is this the page you're looking for?

  • Sorry, false lead. 

    I would assume, you need a case ID by SophosSupport to get into this issue. I am not seeing a clear issue for a migration stop. 

  • Hello ra2,

    Adding to what rfcat and Luca has mentioned, can you check the syslog.log for any entry as well as trying to connect a Serial Cable see if you get to see more of the message.

    And also please share the Case ID once you have it.

    Regards,