2019-09-02 21:24:07 CRITICAL gm.logging [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmLog2.py::__setup_logging() #312): -------- start of logging ------------------------------ 2019-09-02 21:24:07 INFO gm.logging [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmLog2.py::__setup_logging() #313): log file is 2019-09-02 21:24:07 INFO gm.logging [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmLog2.py::__setup_logging() #314): log level is [DEBUG] 2019-09-02 21:24:07 INFO gm.logging [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmLog2.py::__setup_logging() #315): log file encoding is 2019-09-02 21:24:07 INFO gm.logging [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmLog2.py::__setup_logging() #316): initial python.str -> python.unicode encoding is 2019-09-02 21:24:07 DEBUG gm.logging [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmLog2.py::__setup_logging() #317): log file .write() patched from original to patched 2019-09-02 21:24:07 INFO gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::() #62): mx.DateTime version: 3.2.9 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::() #53): psycopg2 version: 2.7.4 (dt dec mx pq3 ext lo64) 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::() #54): PostgreSQL via DB-API module "": API level 2.0, thread safety 2, parameter style "pyformat" 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::() #81): assuming default client encoding of [UTF8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #132): unmodified startup locale settings (should be [C]) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #134): current locale settings: 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #135): locale.getlocale(): (None, None) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_NUMERIC): (None, None) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_MESSAGES): (None, None) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_MONETARY): (None, None) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_COLLATE): (None, None) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_CTYPE): (None, None) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_TIME): (None, None) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_NUMERIC): C) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_MESSAGES): C) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_MONETARY): C) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_COLLATE): C) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_CTYPE): C) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_ALL): C) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_TIME): C) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #143): locale.getdefaultlocale() - default (user) locale: ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #147): encoding sanity check (also check "locale.nl_langinfo(CODESET)" below): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #152): sys.getdefaultencoding(): [ascii] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #153): locale.getpreferredencoding(): [ANSI_X3.4-1968] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #154): locale.getlocale()[1]: [None] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #155): sys.getfilesystemencoding(): [UTF-8] 2019-09-02 21:24:07 WARNING gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #162): encoding suggested by locale (ANSI_X3.4-1968) does not match encoding currently set in locale (None) 2019-09-02 21:24:07 WARNING gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #163): this might lead to encoding errors 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #168): module CAN handle encoding [ANSI_X3.4-1968] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #168): module CAN handle encoding [ascii] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #168): module CAN handle encoding [UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #171): on Linux you can determine a likely candidate for the encoding by running "locale charmap" 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #173): locale related environment variables (${LANG} is typically used): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #178): ${LANGUAGE} not set 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #178): ${LC_ALL} not set 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #178): ${LC_CTYPE} not set 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #176): ${LANG}=de_DE.UTF-8 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #180): database of locale conventions: 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(mon_decimal_point): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(int_frac_digits): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(p_sep_by_space): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(frac_digits): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(thousands_sep): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(n_sign_posn): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(decimal_point): . 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(int_curr_symbol): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(n_cs_precedes): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(p_sign_posn): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(mon_thousands_sep): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(negative_sign): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(currency_symbol): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(n_sep_by_space): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(mon_grouping): [] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(p_cs_precedes): 127 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(positive_sign): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #184): locale.localeconv(grouping): [] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(D_FMT): %m/%d/%y 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(D_T_FMT): %a %b %e %H:%M:%S %Y 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(YESEXPR): ^[yY] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(ALT_DIGITS): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(T_FMT_AMPM): %I:%M:%S %p 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(RADIXCHAR): . 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(ERA_D_FMT): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(T_FMT): %H:%M:%S 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(NOEXPR): ^[nN] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(CRNCYSTR): - 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(ERA): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(CODESET): ANSI_X3.4-1968 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(THOUSEP): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #199): locale.nl_langinfo(ERA_D_T_FMT): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::get_encoding() #474): *actual* encoding of locale is None, using encoding *recommended* by locale 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #208): gmI18N.get_encoding(): ANSI_X3.4-1968 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::activate_locale() #259): activating user-default locale with returns: [de_DE.UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #132): locale settings after activating user-default locale 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #134): current locale settings: 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #135): locale.getlocale(): ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_NUMERIC): ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_MESSAGES): ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_MONETARY): ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_COLLATE): ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_CTYPE): ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #137): locale.getlocale(LC_TIME): ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_NUMERIC): de_DE.UTF-8) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_MESSAGES): de_DE.UTF-8) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_MONETARY): de_DE.UTF-8) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_COLLATE): de_DE.UTF-8) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_CTYPE): de_DE.UTF-8) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_ALL): de_DE.UTF-8) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #140): (locale.setlocale(LC_TIME): de_DE.UTF-8) 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #143): locale.getdefaultlocale() - default (user) locale: ('de_DE', 'UTF-8') 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #147): encoding sanity check (also check "locale.nl_langinfo(CODESET)" below): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #152): sys.getdefaultencoding(): [ascii] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #153): locale.getpreferredencoding(): [UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #154): locale.getlocale()[1]: [UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #155): sys.getfilesystemencoding(): [UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #168): module CAN handle encoding [UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #168): module CAN handle encoding [UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #168): module CAN handle encoding [ascii] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #168): module CAN handle encoding [UTF-8] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #171): on Linux you can determine a likely candidate for the encoding by running "locale charmap" 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #173): locale related environment variables (${LANG} is typically used): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #178): ${LANGUAGE} not set 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #178): ${LC_ALL} not set 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #178): ${LC_CTYPE} not set 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #176): ${LANG}=de_DE.UTF-8 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #180): database of locale conventions: 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(mon_decimal_point): , 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(int_frac_digits): 2 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(p_sep_by_space): 1 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(frac_digits): 2 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(thousands_sep): . 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(n_sign_posn): 1 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(decimal_point): , 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(int_curr_symbol): EUR 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(n_cs_precedes): 0 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(p_sign_posn): 1 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(mon_thousands_sep): . 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(negative_sign): - 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #189): locale.localeconv(currency_symbol): € 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(n_sep_by_space): 1 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(mon_grouping): [3, 3, 0] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(p_cs_precedes): 0 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(positive_sign): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #187): locale.localeconv(grouping): [3, 3, 0] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(D_FMT): %d.%m.%Y 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(D_T_FMT): %a %d %b %Y %T %Z 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(YESEXPR): ^[+1jJyY] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(ALT_DIGITS): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(T_FMT_AMPM): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(RADIXCHAR): , 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(ERA_D_FMT): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(T_FMT): %T 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(NOEXPR): ^[-0nN] 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #204): locale.nl_langinfo(CRNCYSTR): +€ 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(ERA): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(CODESET): UTF-8 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(THOUSEP): . 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #202): locale.nl_langinfo(ERA_D_T_FMT): 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__log_locale_settings() #208): gmI18N.get_encoding(): UTF-8 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__split_locale_into_levels() #104): splitting canonical locale [de_DE] into levels 2019-09-02 21:24:07 DEBUG gm.i18n [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmI18N.py::__split_locale_into_levels() #113): system locale levels: {'country': 'de_DE', 'full': 'de_DE', 'language': 'de'} 2019-09-02 21:24:07 INFO gm.logging [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmLog2.py::set_string_encoding() #244): setting python.str -> python.unicode encoding to (locale.getlocale) 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::() #1843): startup 2019-09-02 21:24:07 INFO gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::add_cli() #511): adding command line arguments 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::add_cli() #512): raw command line is: 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::add_cli() #513): ['./bootstrap_gm_db_system.py', '--log-file=./fixup_db-v22.log', '--conf-file=fixup_db-v22.conf', '--'] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #392): option [--quiet] not in group [cli] in source [cli] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [cli::--conf-file] found in source [cli] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::main() #1781): initial config file: fixup_db-v22.conf 2019-09-02 21:24:07 INFO gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::add_file_source() #449): file source "file": fixup_db-v22.conf (utf8) 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::parse_INI_stream() #276): parsing INI-style data stream [<_io.TextIOWrapper name='fixup_db-v22.conf' encoding='utf8'>] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #392): option [config files] not in group [installation] in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::main() #1797): single-shot config file 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::handle_cfg() #1730): config file: fixup_db-v22.conf 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::become_pg_demon_user() #1685): running as user [root] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::log_auth_environment() #621): standard .pgpass (/root/.pgpass) exists 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::log_auth_environment() #626): $PGPASSFILE not set 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::become_pg_demon_user() #1705): switching to UNIX user [postgres] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::log_auth_environment() #623): standard .pgpass (/root/.pgpass) not found 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::log_auth_environment() #626): $PGPASSFILE not set 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [installation::interactive] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [installation::keep temp files] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [installation::bundles] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [bundle v22-fixups::database alias] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::name] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::server alias] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [server local host::name] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [installation::description] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [installation::bundles] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::bootstrap() #1456): bootstrapping bundle [v22-fixups] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [bundle v22-fixups::database alias] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__init__() #548): bootstrapping database [gnumed_v22] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::override name by] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__init__() #557): environment variable [GM_CORE_DB] is not set, using database name from config file 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::name] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__init__() #574): bootstrapping database [gnumed_v22] alias "gnumed_v22" 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::server alias] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::template database] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__init__() #333): bootstrapping server [local host] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [server local host::super user alias] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [user postgres::name] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #392): option [password] not in group [user postgres] in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__init__() #318): password not defined, assuming connect via IDENT/TRUST 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #370): connecting to server template database 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [server local host::template database] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [server local host::name] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #386): environment variable [GM_DB_PORT] is not set, using database port from config file 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [server local host::port] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::connect() #282): trying DB connection to template1 on localhost as postgres 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2150): established database connection "root@template.server", backend PID: 2052 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2166): PostgreSQL version (numeric): 9.6 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2169): database size: 7183 kB 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): allow_system_table_mods: off (set from: [configuration file] // sess RESET will set to: [off]// /etc/postgresql/9.6/main/postgresql.conf @ 564) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): application_name: root@template.server (set from: [client] // sess RESET will set to: [root@template.server]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): archive_command: rsync -a %p address@hidden:/var/lib/barman/praxis/incoming/%f (set from: [configuration file] // sess RESET will set to: [rsync -a %p address@hidden:/var/lib/barman/praxis/incoming/%f]// /etc/postgresql/9.6/main/postgresql.conf @ 184) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): archive_mode: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 182) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): archive_timeout: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): array_nulls: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): authentication_timeout: 60 s (set from: [default] // sess RESET will set to: [60]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_analyze_scale_factor: 0.1 (set from: [default] // sess RESET will set to: [0.1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_analyze_threshold: 50 (set from: [default] // sess RESET will set to: [50]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_freeze_max_age: 200000000 (set from: [default] // sess RESET will set to: [200000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_max_workers: 3 (set from: [default] // sess RESET will set to: [3]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_multixact_freeze_max_age: 400000000 (set from: [default] // sess RESET will set to: [400000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_naptime: 60 s (set from: [default] // sess RESET will set to: [60]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_cost_delay: 20 ms (set from: [default] // sess RESET will set to: [20]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_cost_limit: -1 (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_scale_factor: 0.2 (set from: [default] // sess RESET will set to: [0.2]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_threshold: 50 (set from: [default] // sess RESET will set to: [50]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_work_mem: -1 kB (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): backend_flush_after: 0 8kB (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): backslash_quote: safe_encoding (set from: [default] // sess RESET will set to: [safe_encoding]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_delay: 200 ms (set from: [default] // sess RESET will set to: [200]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_flush_after: 64 8kB (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_lru_maxpages: 100 (set from: [default] // sess RESET will set to: [100]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_lru_multiplier: 2 (set from: [default] // sess RESET will set to: [2]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): block_size: 8192 (set from: [default] // sess RESET will set to: [8192]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bonjour: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bonjour_name: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bytea_output: hex (set from: [default] // sess RESET will set to: [hex]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): check_function_bodies: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_completion_target: 0.5 (set from: [default] // sess RESET will set to: [0.5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_flush_after: 32 8kB (set from: [default] // sess RESET will set to: [32]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_timeout: 300 s (set from: [default] // sess RESET will set to: [300]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_warning: 30 s (set from: [default] // sess RESET will set to: [30]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): client_encoding: UTF8 (set from: [client] // sess RESET will set to: [UTF8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): client_min_messages: notice (set from: [default] // sess RESET will set to: [notice]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cluster_name: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): commit_delay: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): commit_siblings: 5 (set from: [default] // sess RESET will set to: [5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): config_file: /etc/postgresql/9.6/main/postgresql.conf (set from: [override] // sess RESET will set to: [/etc/postgresql/9.6/main/postgresql.conf]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): constraint_exclusion: partition (set from: [default] // sess RESET will set to: [partition]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cpu_index_tuple_cost: 0.005 (set from: [default] // sess RESET will set to: [0.005]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cpu_operator_cost: 0.0025 (set from: [default] // sess RESET will set to: [0.0025]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cpu_tuple_cost: 0.01 (set from: [default] // sess RESET will set to: [0.01]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cursor_tuple_fraction: 0.1 (set from: [default] // sess RESET will set to: [0.1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): data_checksums: off (set from: [override] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): data_directory: /var/lib/postgresql/9.6/main (set from: [override] // sess RESET will set to: [/var/lib/postgresql/9.6/main]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): data_sync_retry: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): DateStyle: ISO, DMY (set from: [configuration file] // sess RESET will set to: [ISO, DMY]// /etc/postgresql/9.6/main/postgresql.conf @ 481) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): db_user_namespace: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): deadlock_timeout: 1000 ms (set from: [default] // sess RESET will set to: [1000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_assertions: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_pretty_print: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_print_parse: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_print_plan: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_print_rewritten: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_statistics_target: 100 (set from: [default] // sess RESET will set to: [100]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_tablespace: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_text_search_config: pg_catalog.german (set from: [configuration file] // sess RESET will set to: [pg_catalog.german]// /etc/postgresql/9.6/main/postgresql.conf @ 503) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_transaction_deferrable: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_transaction_isolation: read committed (set from: [default] // sess RESET will set to: [read committed]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_transaction_read_only: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_with_oids: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): dynamic_library_path: $libdir (set from: [default] // sess RESET will set to: [$libdir]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): dynamic_shared_memory_type: posix (set from: [configuration file] // sess RESET will set to: [posix]// /etc/postgresql/9.6/main/postgresql.conf @ 560) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): effective_cache_size: 524288 8kB (set from: [default] // sess RESET will set to: [524288]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): effective_io_concurrency: 1 (set from: [default] // sess RESET will set to: [1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_bitmapscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_hashagg: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_hashjoin: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_indexonlyscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_indexscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_material: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_mergejoin: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_nestloop: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_seqscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_sort: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_tidscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): escape_string_warning: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): event_source: PostgreSQL (set from: [default] // sess RESET will set to: [PostgreSQL]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): exit_on_error: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): external_pid_file: /var/run/postgresql/9.6-main.pid (set from: [configuration file] // sess RESET will set to: [/var/run/postgresql/9.6-main.pid]// /etc/postgresql/9.6/main/postgresql.conf @ 49) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): extra_float_digits: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): force_parallel_mode: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): from_collapse_limit: 8 (set from: [default] // sess RESET will set to: [8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): fsync: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): full_page_writes: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 165) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_effort: 5 (set from: [default] // sess RESET will set to: [5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_generations: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_pool_size: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_seed: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_selection_bias: 2 (set from: [default] // sess RESET will set to: [2]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_threshold: 12 (set from: [default] // sess RESET will set to: [12]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): gin_fuzzy_search_limit: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): gin_pending_list_limit: 4096 kB (set from: [default] // sess RESET will set to: [4096]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): hba_file: /etc/postgresql/9.6/main/pg_hba.conf (set from: [override] // sess RESET will set to: [/etc/postgresql/9.6/main/pg_hba.conf]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): hot_standby: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): hot_standby_feedback: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): huge_pages: try (set from: [default] // sess RESET will set to: [try]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ident_file: /etc/postgresql/9.6/main/pg_ident.conf (set from: [override] // sess RESET will set to: [/etc/postgresql/9.6/main/pg_ident.conf]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): idle_in_transaction_session_timeout: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ignore_checksum_failure: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ignore_system_indexes: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): integer_datetimes: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): IntervalStyle: postgres (set from: [default] // sess RESET will set to: [postgres]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): join_collapse_limit: 8 (set from: [default] // sess RESET will set to: [8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): krb_caseins_users: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): krb_server_keyfile: FILE:/etc/postgresql-common/krb5.keytab (set from: [default] // sess RESET will set to: [FILE:/etc/postgresql-common/krb5.keytab]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_collate: de_DE.UTF-8 (set from: [override] // sess RESET will set to: [de_DE.UTF-8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_ctype: de_DE.UTF-8 (set from: [override] // sess RESET will set to: [de_DE.UTF-8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_messages: de_DE.UTF-8 (set from: [configuration file] // sess RESET will set to: [de_DE.UTF-8]// /etc/postgresql/9.6/main/postgresql.conf @ 496) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_monetary: de_DE.UTF-8 (set from: [configuration file] // sess RESET will set to: [de_DE.UTF-8]// /etc/postgresql/9.6/main/postgresql.conf @ 498) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_numeric: de_DE.UTF-8 (set from: [configuration file] // sess RESET will set to: [de_DE.UTF-8]// /etc/postgresql/9.6/main/postgresql.conf @ 499) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_time: de_DE.UTF-8 (set from: [configuration file] // sess RESET will set to: [de_DE.UTF-8]// /etc/postgresql/9.6/main/postgresql.conf @ 500) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): listen_addresses: * (set from: [configuration file] // sess RESET will set to: [*]// /etc/postgresql/9.6/main/postgresql.conf @ 59) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lo_compat_privileges: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): local_preload_libraries: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lock_timeout: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_autovacuum_min_duration: -1 ms (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_checkpoints: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 372) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_connections: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 373) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_destination: stderr (set from: [default] // sess RESET will set to: [stderr]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_directory: pg_log (set from: [default] // sess RESET will set to: [pg_log]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_disconnections: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 374) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_duration: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_error_verbosity: verbose (set from: [configuration file] // sess RESET will set to: [verbose]// /etc/postgresql/9.6/main/postgresql.conf @ 376) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_executor_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_file_mode: 0600 (set from: [default] // sess RESET will set to: [384]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_filename: postgresql-%Y-%m-%d_%H%M%S.log (set from: [default] // sess RESET will set to: [postgresql-%Y-%m-%d_%H%M%S.log]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_hostname: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_line_prefix: %t (set from: [configuration file] // sess RESET will set to: [%t ]// /etc/postgresql/9.6/main/postgresql.conf @ 378) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_lock_waits: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 398) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_min_duration_statement: 1000 ms (set from: [configuration file] // sess RESET will set to: [1000]// /etc/postgresql/9.6/main/postgresql.conf @ 360) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_min_error_statement: error (set from: [default] // sess RESET will set to: [error]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_min_messages: info (set from: [configuration file] // sess RESET will set to: [info]// /etc/postgresql/9.6/main/postgresql.conf @ 332) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_parser_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_planner_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_replication_commands: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_rotation_age: 1440 min (set from: [default] // sess RESET will set to: [1440]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_rotation_size: 10240 kB (set from: [default] // sess RESET will set to: [10240]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_statement: none (set from: [default] // sess RESET will set to: [none]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_statement_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_temp_files: 0 kB (set from: [configuration file] // sess RESET will set to: [0]// /etc/postgresql/9.6/main/postgresql.conf @ 400) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_timezone: GMT (set from: [default] // sess RESET will set to: [GMT]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_truncate_on_rotation: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): logging_collector: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): maintenance_work_mem: 65536 kB (set from: [default] // sess RESET will set to: [65536]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_connections: 100 (set from: [configuration file] // sess RESET will set to: [100]// /etc/postgresql/9.6/main/postgresql.conf @ 64) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_files_per_process: 1000 (set from: [default] // sess RESET will set to: [1000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_function_args: 100 (set from: [default] // sess RESET will set to: [100]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_identifier_length: 63 (set from: [default] // sess RESET will set to: [63]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_index_keys: 32 (set from: [default] // sess RESET will set to: [32]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_locks_per_transaction: 64 (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_parallel_workers_per_gather: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_pred_locks_per_transaction: 64 (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_prepared_transactions: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_replication_slots: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_stack_depth: 2048 kB (set from: [environment variable] // sess RESET will set to: [2048]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_standby_archive_delay: 30000 ms (set from: [default] // sess RESET will set to: [30000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_standby_streaming_delay: 30000 ms (set from: [default] // sess RESET will set to: [30000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_wal_senders: 5 (set from: [configuration file] // sess RESET will set to: [5]// /etc/postgresql/9.6/main/postgresql.conf @ 197) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_wal_size: 64 16MB (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_worker_processes: 8 (set from: [default] // sess RESET will set to: [8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): min_parallel_relation_size: 1024 8kB (set from: [default] // sess RESET will set to: [1024]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): min_wal_size: 5 16MB (set from: [default] // sess RESET will set to: [5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): old_snapshot_threshold: -1 min (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): operator_precedence_warning: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): parallel_setup_cost: 1000 (set from: [default] // sess RESET will set to: [1000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): parallel_tuple_cost: 0.1 (set from: [default] // sess RESET will set to: [0.1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): password_encryption: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): port: 5432 (set from: [configuration file] // sess RESET will set to: [5432]// /etc/postgresql/9.6/main/postgresql.conf @ 63) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): post_auth_delay: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): pre_auth_delay: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): quote_all_identifiers: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): random_page_cost: 4 (set from: [default] // sess RESET will set to: [4]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): replacement_sort_tuples: 150000 (set from: [default] // sess RESET will set to: [150000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): restart_after_crash: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): row_security: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): search_path: "$user", public (set from: [default] // sess RESET will set to: ["$user", public]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): segment_size: 131072 8kB (set from: [default] // sess RESET will set to: [131072]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): seq_page_cost: 1 (set from: [default] // sess RESET will set to: [1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): server_encoding: UTF8 (set from: [override] // sess RESET will set to: [UTF8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): server_version: 9.6.15 (set from: [default] // sess RESET will set to: [9.6.15]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): server_version_num: 90615 (set from: [default] // sess RESET will set to: [90615]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): session_preload_libraries: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): session_replication_role: origin (set from: [default] // sess RESET will set to: [origin]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): shared_buffers: 3072 8kB (set from: [configuration file] // sess RESET will set to: [3072]// /etc/postgresql/9.6/main/postgresql.conf @ 110) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): shared_preload_libraries: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): sql_inheritance: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 81) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_ca_file: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_cert_file: /etc/ssl/certs/ssl-cert-snakeoil.pem (set from: [configuration file] // sess RESET will set to: [/etc/ssl/certs/ssl-cert-snakeoil.pem]// /etc/postgresql/9.6/main/postgresql.conf @ 558) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_ciphers: HIGH:MEDIUM:+3DES:!aNULL (set from: [default] // sess RESET will set to: [HIGH:MEDIUM:+3DES:!aNULL]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_crl_file: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_ecdh_curve: prime256v1 (set from: [default] // sess RESET will set to: [prime256v1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_key_file: /etc/ssl/private/ssl-cert-snakeoil.key (set from: [configuration file] // sess RESET will set to: [/etc/ssl/private/ssl-cert-snakeoil.key]// /etc/postgresql/9.6/main/postgresql.conf @ 559) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_prefer_server_ciphers: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): standard_conforming_strings: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): statement_timeout: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): stats_temp_directory: pg_stat_tmp (set from: [default] // sess RESET will set to: [pg_stat_tmp]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): superuser_reserved_connections: 3 (set from: [default] // sess RESET will set to: [3]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): synchronize_seqscans: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): synchronous_commit: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): synchronous_standby_names: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_facility: local0 (set from: [default] // sess RESET will set to: [local0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_ident: postgres (set from: [default] // sess RESET will set to: [postgres]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_sequence_numbers: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_split_messages: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): tcp_keepalives_count: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): tcp_keepalives_idle: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): tcp_keepalives_interval: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): temp_buffers: 1024 8kB (set from: [default] // sess RESET will set to: [1024]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): temp_file_limit: -1 kB (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): temp_tablespaces: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): TimeZone: GMT (set from: [default] // sess RESET will set to: [GMT]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): timezone_abbreviations: Default (set from: [default] // sess RESET will set to: [Default]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): trace_notify: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): trace_recovery_messages: log (set from: [default] // sess RESET will set to: [log]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): trace_sort: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_activities: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_activity_query_size: 1024 (set from: [default] // sess RESET will set to: [1024]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_commit_timestamp: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 565) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_counts: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_functions: none (set from: [default] // sess RESET will set to: [none]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_io_timing: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transaction_deferrable: off (set from: [override] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transaction_isolation: read committed (set from: [override] // sess RESET will set to: [default]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transaction_read_only: off (set from: [override] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transform_null_equals: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): unix_socket_directories: /var/run/postgresql (set from: [configuration file] // sess RESET will set to: [/var/run/postgresql]// /etc/postgresql/9.6/main/postgresql.conf @ 69) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): unix_socket_group: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): unix_socket_permissions: 0777 (set from: [default] // sess RESET will set to: [511]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): update_process_title: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_delay: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_limit: 200 (set from: [default] // sess RESET will set to: [200]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_page_dirty: 20 (set from: [default] // sess RESET will set to: [20]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_page_hit: 1 (set from: [default] // sess RESET will set to: [1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_page_miss: 10 (set from: [default] // sess RESET will set to: [10]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_defer_cleanup_age: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_freeze_min_age: 50000000 (set from: [default] // sess RESET will set to: [50000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_freeze_table_age: 150000000 (set from: [default] // sess RESET will set to: [150000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_multixact_freeze_min_age: 5000000 (set from: [default] // sess RESET will set to: [5000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_multixact_freeze_table_age: 150000000 (set from: [default] // sess RESET will set to: [150000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_block_size: 8192 (set from: [default] // sess RESET will set to: [8192]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_buffers: 96 8kB (set from: [override] // sess RESET will set to: [96]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_compression: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_keep_segments: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_level: replica (set from: [configuration file] // sess RESET will set to: [replica]// /etc/postgresql/9.6/main/postgresql.conf @ 154) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_log_hints: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_receiver_status_interval: 10 s (set from: [default] // sess RESET will set to: [10]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_receiver_timeout: 60000 ms (set from: [default] // sess RESET will set to: [60000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_retrieve_retry_interval: 5000 ms (set from: [default] // sess RESET will set to: [5000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_segment_size: 2048 8kB (set from: [default] // sess RESET will set to: [2048]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_sender_timeout: 60000 ms (set from: [default] // sess RESET will set to: [60000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_sync_method: fdatasync (set from: [default] // sess RESET will set to: [fdatasync]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_writer_delay: 200 ms (set from: [default] // sess RESET will set to: [200]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_writer_flush_after: 128 8kB (set from: [default] // sess RESET will set to: [128]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): work_mem: 4096 kB (set from: [default] // sess RESET will set to: [4096]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): xmlbinary: base64 (set from: [default] // sess RESET will set to: [base64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): xmloption: content (set from: [default] // sess RESET will set to: [content]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): zero_damaged_pages: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pgstattuple,1.4,"show tuple-level statistics") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (uuid-ossp,1.1,"generate universally unique identifiers (UUIDs)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (file_fdw,1.0,"foreign-data wrapper for flat file access") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (intarray,1.2,"functions, operators, and index support for 1-D arrays of integers") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (btree_gin,1.0,"support for indexing common datatypes in GIN") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (timetravel,1.0,"functions for implementing time travel") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (dict_xsyn,1.0,"text search dictionary template for extended synonym processing") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (btree_gist,1.2,"support for indexing common datatypes in GiST") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (dblink,1.2,"connect to other PostgreSQL databases from within a database") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tablefunc,1.0,"functions that manipulate whole tables, including crosstab") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_trgm,1.3,"text similarity measurement and index searching based on trigrams") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pgrowlocks,1.2,"show row-level locking information") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (xml2,1.1,"XPath querying and XSLT") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tcn,1.0,"Triggered change notifications") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (refint,1.0,"functions for implementing referential integrity (obsolete)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (earthdistance,1.1,"calculate great-circle distances on the surface of the Earth") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (ltree,1.1,"data type for hierarchical tree-like structures") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (adminpack,1.1,"administrative functions for PostgreSQL") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_prewarm,1.1,"prewarm relation data") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_visibility,1.1,"examine the visibility map (VM) and page-level visibility info") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (bloom,1.0,"bloom access method - signature file based index") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (isn,1.1,"data types for international product numbering standards") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (hstore,1.4,"data type for storing sets of (key, value) pairs") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pgcrypto,1.3,"cryptographic functions") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_freespacemap,1.1,"examine the free space map (FSM)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pageinspect,1.5,"inspect the contents of database pages at a low level") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (postgres_fdw,1.0,"foreign-data wrapper for remote PostgreSQL servers") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (fuzzystrmatch,1.1,"determine similarities and distance between strings") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_stat_statements,1.4,"track execution statistics of all SQL statements executed") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tsearch2,1.0,"compatibility package for pre-8.3 text search functions") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (chkpass,1.0,"data type for auto-encrypted passwords") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (sslinfo,1.2,"information about SSL certificates") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (plpgsql,1.0,"PL/pgSQL procedural language") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (autoinc,1.0,"functions for autoincrementing fields") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (dict_int,1.0,"text search dictionary template for integers") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (intagg,1.1,"integer aggregator and enumerator (obsolete)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_buffercache,1.2,"examine the shared buffer cache") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tsm_system_rows,1.0,"TABLESAMPLE method which accepts number of rows as a limit") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (unaccent,1.1,"text search dictionary that removes accents") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (seg,1.1,"data type for representing line segments or floating-point intervals") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tsm_system_time,1.0,"TABLESAMPLE method which accepts time in milliseconds as a limit") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (citext,1.3,"data type for case-insensitive character strings") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (lo,1.1,"Large Object maintenance") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (cube,1.2,"data type for multidimensional cubes") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (insert_username,1.0,"functions for tracking who changed a table") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (moddatetime,1.0,"functions for tracking last modification time") 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #125): mx.DateTime.now(): [2019-09-02 21:24:07,30] 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #126): datetime.now() : [2019-09-02 21:24:07.296544] 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #127): time.localtime() : [time.struct_time(tm_year=2019, tm_mon=9, tm_mday=2, tm_hour=21, tm_min=24, tm_sec=7, tm_wday=0, tm_yday=245, tm_isdst=1)] 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #128): time.gmtime() : [time.struct_time(tm_year=2019, tm_mon=9, tm_mday=2, tm_hour=19, tm_min=24, tm_sec=7, tm_wday=0, tm_yday=245, tm_isdst=0)] 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #133): $TZ not defined 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #135): time.daylight: [1] (whether or not DST is locally used at all) 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #136): time.timezone: [-3600] seconds 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #137): time.altzone : [-7200] seconds 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #138): time.tzname : [CET / CEST] (non-DST / DST) 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #139): mx.DateTime.now().gmtoffset(): [02:00:00,00] 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #152): DST currently in effect: [True] 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #161): DST currently in effect: using UTC offset of [7200] seconds instead of [3600] seconds 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #167): UTC offset is positive, assuming EAST of Greenwich (clock is "ahead") 2019-09-02 21:24:07 DEBUG gm.datetime [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmDateTime.py::init() #175): ISO timezone: [02:00:00,00] (taken from mx.DateTime.now().gmtoffset()) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__detect_client_timezone() #437): trying to detect timezone from system 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__expand_timezone() #417): [CEST] maps to [posix/Poland] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__detect_client_timezone() #454): candidates: [u'CEST', u'posix/Poland'] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__validate_timezone() #362): validating time zone [CEST] 2019-09-02 21:24:07 WARNING gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__validate_timezone() #383): time zone [CEST] is not settable 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__validate_timezone() #362): validating time zone [posix/Poland] 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__validate_timezone() #372): time zone [posix/Poland] is settable 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__validate_timezone() #378): time zone [posix/Poland] is usable 2019-09-02 21:24:07 INFO gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::__detect_client_timezone() #471): client system time zone detected as equivalent to [posix/Poland] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2185): autocommit is desired to be: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2254): client time zone [posix/Poland] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): type: 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): identity: 140445986973328 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): backend PID: 2052 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): protocol version: 3 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): encoding: UTF8 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): isolation level (psyco): 3 (ISOLATION_LEVEL_SERIALIZABLE) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): readonly: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): autocommit: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): closed: 0 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): connection status: 1 (STATUS_READY) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): transaction status: 0 (TRANSACTION_STATUS_IDLE) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): deferrable: None 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): async: 0 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): executing async op: False 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::connect() #293): successfully connected 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #410): template database LC_CTYPE is [de_DE.UTF-8] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #435): successfully connected to template database [template1] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__bootstrap_db_users() #441): bootstrapping database users and groups 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [GnuMed defaults::groups] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::db_group_exists() #240): group [gnumed_v22] exists 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [GnuMed defaults::database owner alias] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [user GNUmed owner::name] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::user_exists() #225): user [gm-dbo] exists 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [user GNUmed owner::name] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__init__() #351): done bootstrapping server [local host] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::connect() #282): trying DB connection to template1 on localhost as postgres 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2150): established database connection "address@hidden", backend PID: 2053 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2185): autocommit is desired to be: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2254): client time zone [posix/Poland] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): type: 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): identity: 140445986975248 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): backend PID: 2053 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): protocol version: 3 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): encoding: UTF8 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): isolation level (psyco): 3 (ISOLATION_LEVEL_SERIALIZABLE) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): readonly: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): autocommit: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): closed: 0 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): connection status: 1 (STATUS_READY) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): transaction status: 0 (TRANSACTION_STATUS_IDLE) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): deferrable: None 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): async: 0 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): executing async op: False 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::connect() #293): successfully connected 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #392): option [template version] not in group [database gnumed_v22] in source [file] 2019-09-02 21:24:07 WARNING gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__create_db() #814): cannot check template database identity hash, no version specified 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__db_exists() #802): Database [gnumed_v22] exists. 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::drop target database] found in source [file] 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #394): option [database gnumed_v22::use existing target database] found in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__create_db() #850): using existing database [gnumed_v22] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::connect() #282): trying DB connection to gnumed_v22 on localhost as postgres 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2150): established database connection "postgres@gnumed_vX", backend PID: 2054 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_raw_connection() #2185): autocommit is desired to be: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2254): client time zone [posix/Poland] 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): type: 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): identity: 140445986972368 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): backend PID: 2054 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): protocol version: 3 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): encoding: UTF8 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): isolation level (psyco): 3 (ISOLATION_LEVEL_SERIALIZABLE) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): readonly: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): autocommit: False 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): closed: 0 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): connection status: 1 (STATUS_READY) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): transaction status: 0 (TRANSACTION_STATUS_IDLE) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): deferrable: None 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): async: 0 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::get_connection() #2265): executing async op: False 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::connect() #293): successfully connected 2019-09-02 21:24:07 ERROR gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__connect_superuser_to_db() #756): PostgreSQL version < 9.5 does not support OR cannot be set at runtime Traceback (most recent call last): File "./bootstrap_gm_db_system.py", line 754, in __connect_superuser_to_db curs.execute("alter database %s set track_commit_timestamp to on" % self.name) File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 144, in execute return super(DictCursor, self).execute(query, vars) OperationalError: parameter "track_commit_timestamp" cannot be changed without restarting the server 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): allow_system_table_mods: off (set from: [configuration file] // sess RESET will set to: [off]// /etc/postgresql/9.6/main/postgresql.conf @ 564) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): application_name: postgres@gnumed_vX (set from: [client] // sess RESET will set to: [postgres@gnumed_vX]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): archive_command: rsync -a %p address@hidden:/var/lib/barman/praxis/incoming/%f (set from: [configuration file] // sess RESET will set to: [rsync -a %p address@hidden:/var/lib/barman/praxis/incoming/%f]// /etc/postgresql/9.6/main/postgresql.conf @ 184) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): archive_mode: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 182) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): archive_timeout: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): array_nulls: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): authentication_timeout: 60 s (set from: [default] // sess RESET will set to: [60]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_analyze_scale_factor: 0.1 (set from: [default] // sess RESET will set to: [0.1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_analyze_threshold: 50 (set from: [default] // sess RESET will set to: [50]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_freeze_max_age: 200000000 (set from: [default] // sess RESET will set to: [200000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_max_workers: 3 (set from: [default] // sess RESET will set to: [3]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_multixact_freeze_max_age: 400000000 (set from: [default] // sess RESET will set to: [400000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_naptime: 60 s (set from: [default] // sess RESET will set to: [60]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_cost_delay: 20 ms (set from: [default] // sess RESET will set to: [20]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_cost_limit: -1 (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_scale_factor: 0.2 (set from: [default] // sess RESET will set to: [0.2]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_vacuum_threshold: 50 (set from: [default] // sess RESET will set to: [50]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): autovacuum_work_mem: -1 kB (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): backend_flush_after: 0 8kB (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): backslash_quote: safe_encoding (set from: [default] // sess RESET will set to: [safe_encoding]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_delay: 200 ms (set from: [default] // sess RESET will set to: [200]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_flush_after: 64 8kB (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_lru_maxpages: 100 (set from: [default] // sess RESET will set to: [100]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bgwriter_lru_multiplier: 2 (set from: [default] // sess RESET will set to: [2]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): block_size: 8192 (set from: [default] // sess RESET will set to: [8192]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bonjour: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bonjour_name: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): bytea_output: hex (set from: [default] // sess RESET will set to: [hex]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): check_function_bodies: on (set from: [database] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_completion_target: 0.5 (set from: [default] // sess RESET will set to: [0.5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_flush_after: 32 8kB (set from: [default] // sess RESET will set to: [32]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_timeout: 300 s (set from: [default] // sess RESET will set to: [300]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): checkpoint_warning: 30 s (set from: [default] // sess RESET will set to: [30]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): client_encoding: UTF8 (set from: [client] // sess RESET will set to: [UTF8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): client_min_messages: notice (set from: [default] // sess RESET will set to: [notice]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cluster_name: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): commit_delay: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): commit_siblings: 5 (set from: [default] // sess RESET will set to: [5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): config_file: /etc/postgresql/9.6/main/postgresql.conf (set from: [override] // sess RESET will set to: [/etc/postgresql/9.6/main/postgresql.conf]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): constraint_exclusion: partition (set from: [default] // sess RESET will set to: [partition]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cpu_index_tuple_cost: 0.005 (set from: [default] // sess RESET will set to: [0.005]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cpu_operator_cost: 0.0025 (set from: [default] // sess RESET will set to: [0.0025]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cpu_tuple_cost: 0.01 (set from: [default] // sess RESET will set to: [0.01]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): cursor_tuple_fraction: 0.1 (set from: [default] // sess RESET will set to: [0.1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): data_checksums: off (set from: [override] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): data_directory: /var/lib/postgresql/9.6/main (set from: [override] // sess RESET will set to: [/var/lib/postgresql/9.6/main]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): data_sync_retry: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): DateStyle: ISO, DMY (set from: [configuration file] // sess RESET will set to: [ISO, DMY]// /etc/postgresql/9.6/main/postgresql.conf @ 481) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): db_user_namespace: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): deadlock_timeout: 1000 ms (set from: [default] // sess RESET will set to: [1000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_assertions: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_pretty_print: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_print_parse: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_print_plan: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): debug_print_rewritten: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_statistics_target: 100 (set from: [default] // sess RESET will set to: [100]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_tablespace: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_text_search_config: pg_catalog.german (set from: [configuration file] // sess RESET will set to: [pg_catalog.german]// /etc/postgresql/9.6/main/postgresql.conf @ 503) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_transaction_deferrable: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_transaction_isolation: read committed (set from: [default] // sess RESET will set to: [read committed]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_transaction_read_only: off (set from: [session] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): default_with_oids: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): dynamic_library_path: $libdir (set from: [default] // sess RESET will set to: [$libdir]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): dynamic_shared_memory_type: posix (set from: [configuration file] // sess RESET will set to: [posix]// /etc/postgresql/9.6/main/postgresql.conf @ 560) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): effective_cache_size: 524288 8kB (set from: [default] // sess RESET will set to: [524288]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): effective_io_concurrency: 1 (set from: [default] // sess RESET will set to: [1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_bitmapscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_hashagg: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_hashjoin: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_indexonlyscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_indexscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_material: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_mergejoin: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_nestloop: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_seqscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_sort: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): enable_tidscan: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): escape_string_warning: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): event_source: PostgreSQL (set from: [default] // sess RESET will set to: [PostgreSQL]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): exit_on_error: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): external_pid_file: /var/run/postgresql/9.6-main.pid (set from: [configuration file] // sess RESET will set to: [/var/run/postgresql/9.6-main.pid]// /etc/postgresql/9.6/main/postgresql.conf @ 49) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): extra_float_digits: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): force_parallel_mode: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): from_collapse_limit: 8 (set from: [default] // sess RESET will set to: [8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): fsync: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): full_page_writes: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 165) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_effort: 5 (set from: [default] // sess RESET will set to: [5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_generations: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_pool_size: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_seed: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_selection_bias: 2 (set from: [default] // sess RESET will set to: [2]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): geqo_threshold: 12 (set from: [default] // sess RESET will set to: [12]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): gin_fuzzy_search_limit: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): gin_pending_list_limit: 4096 kB (set from: [default] // sess RESET will set to: [4096]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): hba_file: /etc/postgresql/9.6/main/pg_hba.conf (set from: [override] // sess RESET will set to: [/etc/postgresql/9.6/main/pg_hba.conf]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): hot_standby: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): hot_standby_feedback: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): huge_pages: try (set from: [default] // sess RESET will set to: [try]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ident_file: /etc/postgresql/9.6/main/pg_ident.conf (set from: [override] // sess RESET will set to: [/etc/postgresql/9.6/main/pg_ident.conf]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): idle_in_transaction_session_timeout: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ignore_checksum_failure: off (set from: [database] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ignore_system_indexes: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): integer_datetimes: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): IntervalStyle: postgres (set from: [default] // sess RESET will set to: [postgres]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): join_collapse_limit: 8 (set from: [default] // sess RESET will set to: [8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): krb_caseins_users: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): krb_server_keyfile: FILE:/etc/postgresql-common/krb5.keytab (set from: [default] // sess RESET will set to: [FILE:/etc/postgresql-common/krb5.keytab]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_collate: de_DE.UTF-8 (set from: [override] // sess RESET will set to: [de_DE.UTF-8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_ctype: de_DE.UTF-8 (set from: [override] // sess RESET will set to: [de_DE.UTF-8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_messages: C (set from: [session] // sess RESET will set to: [C]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_monetary: de_DE.UTF-8 (set from: [configuration file] // sess RESET will set to: [de_DE.UTF-8]// /etc/postgresql/9.6/main/postgresql.conf @ 498) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_numeric: de_DE.UTF-8 (set from: [configuration file] // sess RESET will set to: [de_DE.UTF-8]// /etc/postgresql/9.6/main/postgresql.conf @ 499) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lc_time: de_DE.UTF-8 (set from: [configuration file] // sess RESET will set to: [de_DE.UTF-8]// /etc/postgresql/9.6/main/postgresql.conf @ 500) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): listen_addresses: * (set from: [configuration file] // sess RESET will set to: [*]// /etc/postgresql/9.6/main/postgresql.conf @ 59) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lo_compat_privileges: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): local_preload_libraries: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): lock_timeout: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_autovacuum_min_duration: -1 ms (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_checkpoints: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 372) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_connections: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 373) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_destination: stderr (set from: [default] // sess RESET will set to: [stderr]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_directory: pg_log (set from: [default] // sess RESET will set to: [pg_log]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_disconnections: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 374) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_duration: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_error_verbosity: verbose (set from: [configuration file] // sess RESET will set to: [verbose]// /etc/postgresql/9.6/main/postgresql.conf @ 376) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_executor_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_file_mode: 0600 (set from: [default] // sess RESET will set to: [384]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_filename: postgresql-%Y-%m-%d_%H%M%S.log (set from: [default] // sess RESET will set to: [postgresql-%Y-%m-%d_%H%M%S.log]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_hostname: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_line_prefix: %t (set from: [configuration file] // sess RESET will set to: [%t ]// /etc/postgresql/9.6/main/postgresql.conf @ 378) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_lock_waits: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 398) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_min_duration_statement: 1000 ms (set from: [configuration file] // sess RESET will set to: [1000]// /etc/postgresql/9.6/main/postgresql.conf @ 360) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_min_error_statement: error (set from: [default] // sess RESET will set to: [error]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_min_messages: info (set from: [configuration file] // sess RESET will set to: [info]// /etc/postgresql/9.6/main/postgresql.conf @ 332) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_parser_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_planner_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_replication_commands: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_rotation_age: 1440 min (set from: [default] // sess RESET will set to: [1440]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_rotation_size: 10240 kB (set from: [default] // sess RESET will set to: [10240]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_statement: none (set from: [default] // sess RESET will set to: [none]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_statement_stats: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_temp_files: 0 kB (set from: [configuration file] // sess RESET will set to: [0]// /etc/postgresql/9.6/main/postgresql.conf @ 400) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_timezone: GMT (set from: [default] // sess RESET will set to: [GMT]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): log_truncate_on_rotation: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): logging_collector: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): maintenance_work_mem: 65536 kB (set from: [default] // sess RESET will set to: [65536]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_connections: 100 (set from: [configuration file] // sess RESET will set to: [100]// /etc/postgresql/9.6/main/postgresql.conf @ 64) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_files_per_process: 1000 (set from: [default] // sess RESET will set to: [1000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_function_args: 100 (set from: [default] // sess RESET will set to: [100]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_identifier_length: 63 (set from: [default] // sess RESET will set to: [63]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_index_keys: 32 (set from: [default] // sess RESET will set to: [32]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_locks_per_transaction: 64 (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_parallel_workers_per_gather: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_pred_locks_per_transaction: 64 (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_prepared_transactions: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_replication_slots: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_stack_depth: 2048 kB (set from: [environment variable] // sess RESET will set to: [2048]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_standby_archive_delay: 30000 ms (set from: [default] // sess RESET will set to: [30000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_standby_streaming_delay: 30000 ms (set from: [default] // sess RESET will set to: [30000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_wal_senders: 5 (set from: [configuration file] // sess RESET will set to: [5]// /etc/postgresql/9.6/main/postgresql.conf @ 197) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_wal_size: 64 16MB (set from: [default] // sess RESET will set to: [64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): max_worker_processes: 8 (set from: [default] // sess RESET will set to: [8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): min_parallel_relation_size: 1024 8kB (set from: [default] // sess RESET will set to: [1024]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): min_wal_size: 5 16MB (set from: [default] // sess RESET will set to: [5]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): old_snapshot_threshold: -1 min (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): operator_precedence_warning: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): parallel_setup_cost: 1000 (set from: [default] // sess RESET will set to: [1000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): parallel_tuple_cost: 0.1 (set from: [default] // sess RESET will set to: [0.1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): password_encryption: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): port: 5432 (set from: [configuration file] // sess RESET will set to: [5432]// /etc/postgresql/9.6/main/postgresql.conf @ 63) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): post_auth_delay: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): pre_auth_delay: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): quote_all_identifiers: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): random_page_cost: 4 (set from: [default] // sess RESET will set to: [4]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): replacement_sort_tuples: 150000 (set from: [default] // sess RESET will set to: [150000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): restart_after_crash: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): row_security: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): search_path: "$user", public (set from: [default] // sess RESET will set to: ["$user", public]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): segment_size: 131072 8kB (set from: [default] // sess RESET will set to: [131072]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): seq_page_cost: 1 (set from: [default] // sess RESET will set to: [1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): server_encoding: UTF8 (set from: [override] // sess RESET will set to: [UTF8]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): server_version: 9.6.15 (set from: [default] // sess RESET will set to: [9.6.15]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): server_version_num: 90615 (set from: [default] // sess RESET will set to: [90615]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): session_preload_libraries: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): session_replication_role: origin (set from: [default] // sess RESET will set to: [origin]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): shared_buffers: 3072 8kB (set from: [configuration file] // sess RESET will set to: [3072]// /etc/postgresql/9.6/main/postgresql.conf @ 110) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): shared_preload_libraries: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): sql_inheritance: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 81) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_ca_file: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_cert_file: /etc/ssl/certs/ssl-cert-snakeoil.pem (set from: [configuration file] // sess RESET will set to: [/etc/ssl/certs/ssl-cert-snakeoil.pem]// /etc/postgresql/9.6/main/postgresql.conf @ 558) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_ciphers: HIGH:MEDIUM:+3DES:!aNULL (set from: [default] // sess RESET will set to: [HIGH:MEDIUM:+3DES:!aNULL]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_crl_file: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_ecdh_curve: prime256v1 (set from: [default] // sess RESET will set to: [prime256v1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_key_file: /etc/ssl/private/ssl-cert-snakeoil.key (set from: [configuration file] // sess RESET will set to: [/etc/ssl/private/ssl-cert-snakeoil.key]// /etc/postgresql/9.6/main/postgresql.conf @ 559) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): ssl_prefer_server_ciphers: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): standard_conforming_strings: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): statement_timeout: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): stats_temp_directory: pg_stat_tmp (set from: [default] // sess RESET will set to: [pg_stat_tmp]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): superuser_reserved_connections: 3 (set from: [default] // sess RESET will set to: [3]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): synchronize_seqscans: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): synchronous_commit: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): synchronous_standby_names: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_facility: local0 (set from: [default] // sess RESET will set to: [local0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_ident: postgres (set from: [default] // sess RESET will set to: [postgres]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_sequence_numbers: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): syslog_split_messages: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): tcp_keepalives_count: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): tcp_keepalives_idle: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): tcp_keepalives_interval: 0 s (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): temp_buffers: 1024 8kB (set from: [default] // sess RESET will set to: [1024]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): temp_file_limit: -1 kB (set from: [default] // sess RESET will set to: [-1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): temp_tablespaces: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): TimeZone: posix/Poland (set from: [session] // sess RESET will set to: [GMT]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): timezone_abbreviations: Default (set from: [default] // sess RESET will set to: [Default]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): trace_notify: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): trace_recovery_messages: log (set from: [default] // sess RESET will set to: [log]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): trace_sort: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_activities: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_activity_query_size: 1024 (set from: [default] // sess RESET will set to: [1024]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_commit_timestamp: on (set from: [configuration file] // sess RESET will set to: [on]// /etc/postgresql/9.6/main/postgresql.conf @ 565) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_counts: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_functions: none (set from: [default] // sess RESET will set to: [none]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): track_io_timing: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transaction_deferrable: off (set from: [override] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transaction_isolation: serializable (set from: [session] // sess RESET will set to: [default]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transaction_read_only: off (set from: [session] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): transform_null_equals: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): unix_socket_directories: /var/run/postgresql (set from: [configuration file] // sess RESET will set to: [/var/run/postgresql]// /etc/postgresql/9.6/main/postgresql.conf @ 69) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): unix_socket_group: (set from: [default] // sess RESET will set to: []) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): unix_socket_permissions: 0777 (set from: [default] // sess RESET will set to: [511]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): update_process_title: on (set from: [default] // sess RESET will set to: [on]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_delay: 0 ms (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_limit: 200 (set from: [default] // sess RESET will set to: [200]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_page_dirty: 20 (set from: [default] // sess RESET will set to: [20]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_page_hit: 1 (set from: [default] // sess RESET will set to: [1]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_cost_page_miss: 10 (set from: [default] // sess RESET will set to: [10]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_defer_cleanup_age: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_freeze_min_age: 50000000 (set from: [default] // sess RESET will set to: [50000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_freeze_table_age: 150000000 (set from: [default] // sess RESET will set to: [150000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_multixact_freeze_min_age: 5000000 (set from: [default] // sess RESET will set to: [5000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): vacuum_multixact_freeze_table_age: 150000000 (set from: [default] // sess RESET will set to: [150000000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_block_size: 8192 (set from: [default] // sess RESET will set to: [8192]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_buffers: 96 8kB (set from: [override] // sess RESET will set to: [96]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_compression: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_keep_segments: 0 (set from: [default] // sess RESET will set to: [0]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_level: replica (set from: [configuration file] // sess RESET will set to: [replica]// /etc/postgresql/9.6/main/postgresql.conf @ 154) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_log_hints: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_receiver_status_interval: 10 s (set from: [default] // sess RESET will set to: [10]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_receiver_timeout: 60000 ms (set from: [default] // sess RESET will set to: [60000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_retrieve_retry_interval: 5000 ms (set from: [default] // sess RESET will set to: [5000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_segment_size: 2048 8kB (set from: [default] // sess RESET will set to: [2048]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_sender_timeout: 60000 ms (set from: [default] // sess RESET will set to: [60000]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_sync_method: fdatasync (set from: [default] // sess RESET will set to: [fdatasync]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_writer_delay: 200 ms (set from: [default] // sess RESET will set to: [200]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): wal_writer_flush_after: 128 8kB (set from: [default] // sess RESET will set to: [128]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): work_mem: 4096 kB (set from: [default] // sess RESET will set to: [4096]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): xmlbinary: base64 (set from: [default] // sess RESET will set to: [base64]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): xmloption: content (set from: [default] // sess RESET will set to: [content]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2466): zero_damaged_pages: off (set from: [default] // sess RESET will set to: [off]) 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pgstattuple,1.4,"show tuple-level statistics") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (uuid-ossp,1.1,"generate universally unique identifiers (UUIDs)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (file_fdw,1.0,"foreign-data wrapper for flat file access") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (intarray,1.2,"functions, operators, and index support for 1-D arrays of integers") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (btree_gin,1.0,"support for indexing common datatypes in GIN") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (timetravel,1.0,"functions for implementing time travel") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (dict_xsyn,1.0,"text search dictionary template for extended synonym processing") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (btree_gist,1.2,"support for indexing common datatypes in GiST") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (dblink,1.2,"connect to other PostgreSQL databases from within a database") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tablefunc,1.0,"functions that manipulate whole tables, including crosstab") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_trgm,1.3,"text similarity measurement and index searching based on trigrams") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pgrowlocks,1.2,"show row-level locking information") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (xml2,1.1,"XPath querying and XSLT") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tcn,1.0,"Triggered change notifications") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (refint,1.0,"functions for implementing referential integrity (obsolete)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (earthdistance,1.1,"calculate great-circle distances on the surface of the Earth") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (ltree,1.1,"data type for hierarchical tree-like structures") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (adminpack,1.1,"administrative functions for PostgreSQL") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_prewarm,1.1,"prewarm relation data") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_visibility,1.1,"examine the visibility map (VM) and page-level visibility info") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (bloom,1.0,"bloom access method - signature file based index") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (isn,1.1,"data types for international product numbering standards") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (hstore,1.4,"data type for storing sets of (key, value) pairs") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pgcrypto,1.3,"cryptographic functions") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_freespacemap,1.1,"examine the free space map (FSM)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pageinspect,1.5,"inspect the contents of database pages at a low level") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (postgres_fdw,1.0,"foreign-data wrapper for remote PostgreSQL servers") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (fuzzystrmatch,1.1,"determine similarities and distance between strings") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_stat_statements,1.4,"track execution statistics of all SQL statements executed") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tsearch2,1.0,"compatibility package for pre-8.3 text search functions") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (chkpass,1.0,"data type for auto-encrypted passwords") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (sslinfo,1.2,"information about SSL certificates") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (plpgsql,1.0,"PL/pgSQL procedural language") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (autoinc,1.0,"functions for autoincrementing fields") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (dict_int,1.0,"text search dictionary template for integers") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (intagg,1.1,"integer aggregator and enumerator (obsolete)") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (pg_buffercache,1.2,"examine the shared buffer cache") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tsm_system_rows,1.0,"TABLESAMPLE method which accepts number of rows as a limit") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (unaccent,1.1,"text search dictionary that removes accents") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (seg,1.1,"data type for representing line segments or floating-point intervals") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (tsm_system_time,1.0,"TABLESAMPLE method which accepts time in milliseconds as a limit") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (citext,1.3,"data type for case-insensitive character strings") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (lo,1.1,"Large Object maintenance") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (cube,1.2,"data type for multidimensional cubes") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (insert_username,1.0,"functions for tracking who changed a table") 2019-09-02 21:24:07 DEBUG gm.db [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmPG2.py::_log_PG_settings() #2479): PG extension: (moddatetime,1.0,"functions for tracking last modification time") 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__bootstrap() #633): creating database-specific authentication group role 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::db_group_exists() #240): group [gnumed_v22] exists 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::db_group_exists() #240): group [gnumed_v22] exists 2019-09-02 21:24:07 DEBUG gm.cfg [140446077142464 MainThread] (/var/lib/gnumed/Gnumed/pycommon/gmCfg2.py::get() #392): option [reindex] not in group [database gnumed_v22] in source [file] 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::reindex_all() #1156): REINDEXing cloned target database so upgrade does not fail in case of a broken index 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::reindex_all() #1157): this may potentially take "quite a long time" depending on how much data there is in the database 2019-09-02 21:24:07 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::reindex_all() #1158): you may want to monitor the PostgreSQL log for signs of progress 2019-09-02 21:24:34 ERROR gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::reindex_all() #1168): >>>[REINDEX (VERBOSE) DATABASE gnumed_v22]<<< failed Traceback (most recent call last): File "./bootstrap_gm_db_system.py", line 1166, in reindex_all curs_outer.execute(cmd) File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 144, in execute return super(DictCursor, self).execute(query, vars) IntegrityError: could not create unique index "access_log_pkey" DETAIL: Key (pk)=(67314) is duplicated. 2019-09-02 21:24:34 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::reindex_all() #1170): attempting REINDEXing without VERBOSE 2019-09-02 21:25:02 ERROR gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::reindex_all() #1176): >>>[REINDEX DATABASE gnumed_v22]<<< failed Traceback (most recent call last): File "./bootstrap_gm_db_system.py", line 1174, in reindex_all curs_inner.execute(cmd) File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 144, in execute return super(DictCursor, self).execute(query, vars) IntegrityError: could not create unique index "access_log_pkey" DETAIL: Key (pk)=(67314) is duplicated. 2019-09-02 21:25:02 ERROR gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::__bootstrap() #652): cannot REINDEX cloned target database 2019-09-02 21:25:02 ERROR gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::bootstrap() #1467): Cannot bootstrap bundle [v22-fixups]. Traceback (most recent call last): File "./bootstrap_gm_db_system.py", line 1465, in bootstrap database(aDB_alias = database_alias) File "./bootstrap_gm_db_system.py", line 597, in __init__ raise ConstructorError, "database.__init__(): Cannot bootstrap database." ConstructorError: database.__init__(): Cannot bootstrap database. 2019-09-02 21:25:02 ERROR gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::exit_with_msg() #1654): Cannot bootstrap bundles. 2019-09-02 21:25:02 INFO gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::exit_with_msg() #1655): shutdown 2019-09-02 21:25:02 WARNING gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::() #1853): open connection detected: database.__connect_superuser_to_db 2019-09-02 21:25:02 WARNING gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::() #1854): 2019-09-02 21:25:02 WARNING gm.bootstrapper [140446077142464 MainThread] (./bootstrap_gm_db_system.py::() #1855): closing connection