ebnerjoh

Members
  • Posts

    159
  • Joined

  • Last visited

Everything posted by ebnerjoh

  1. Yes, I have. Also the one with "rollback".
  2. Anyone an idea how I could try to recover the DB?
  3. I guess for stopping the container before upgrading is too late. The question is how I can recover the broken DB now.
  4. I am starting to hate MariaDB on Unraid (or I am just an idiot)... Now after every MariaDB somehow my Databases are not working anymore. Upraded today to the latest version: 220130 08:31:57 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2022-01-30 8:31:57 0 [Note] /usr/bin/mariadbd (mysqld 10.5.13-MariaDB-log) starting as process 30017 ... 2022-01-30 8:31:57 0 [Note] InnoDB: Uses event mutexes 2022-01-30 8:31:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-01-30 8:31:57 0 [Note] InnoDB: Number of pools: 1 2022-01-30 8:31:57 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-01-30 8:31:57 0 [Note] InnoDB: Using Linux native AIO 2022-01-30 8:31:57 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2022-01-30 8:31:57 0 [Note] InnoDB: Completed initialization of buffer pool 2022-01-30 8:31:57 0 [Note] InnoDB: Transaction 17363023 was in the XA prepared state. 2022-01-30 8:31:57 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2022-01-30 8:31:57 0 [Note] InnoDB: Trx id counter is 17363024 2022-01-30 8:31:57 0 [Note] InnoDB: 128 rollback segments are active. 2022-01-30 8:31:57 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2022-01-30 8:31:57 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2022-01-30 8:31:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-01-30 8:31:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-01-30 8:31:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-01-30 8:31:57 0 [Note] InnoDB: 10.5.13 started; log sequence number 29677261474; transaction id 17363025 2022-01-30 8:31:57 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-01-30 8:31:57 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2022-01-30 8:31:57 0 [Note] InnoDB: Starting recovery for XA transactions... 2022-01-30 8:31:57 0 [Note] InnoDB: Transaction 17363023 in prepared state after recovery 2022-01-30 8:31:57 0 [Note] InnoDB: Transaction contains changes to 2 rows 2022-01-30 8:31:57 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2022-01-30 8:31:57 0 [Note] Found 1 prepared transaction(s) in InnoDB 2022-01-30 8:31:57 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 2022-01-30 8:31:57 0 [ERROR] Aborting 220130 08:31:58 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  5. Hello, When using this docker in the past I was able to use the forge installer. But this is gone now? I also found this, not sure if this is related... https://github.com/hexparrot/mineos-node/issues/402
  6. Hello, I wanted to update my minecraft world to the latest forge version (currently running on 1.16) and now I noticed that forge isnt visible on the mineos docker anymore at all. does anyone know why? Br, Johannes
  7. Hello, I am running bitwarden (and now vaultwarden) since long time now with 2 accounts. Now I wanted to add a third account, but I cannot. First I tried to activate via the Admin-Portal. It said "send invitation" but nothing came to the users email account. Then I deleted the account again and tried to register the user via the Login Page. Although I have deleted the Account on the Admin-Page, I am getting "user exists"....
  8. Hi, After upgrading a docker I noticed an issue and I tried to downgrade again. So I opened the template in Unraid and added the command ":" with the version behind and applied. An Error message was shown and now the docker entry is missing. So I can also not change back to ":latest".
  9. Then I opened a cmd-line to the docker and exexuted: root@92ecc8717197:/# mysqld --user=root --tc-heuristic-recover rollback 2021-10-29 11:32:32 0 [Note] mysqld (mysqld 10.5.12-MariaDB-log) starting as process 5366 ... 2021-10-29 11:32:32 0 [Note] InnoDB: Uses event mutexes 2021-10-29 11:32:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-10-29 11:32:32 0 [Note] InnoDB: Number of pools: 1 2021-10-29 11:32:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2021-10-29 11:32:32 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts) 2021-10-29 11:32:32 0 [Note] InnoDB: Using Linux native AIO 2021-10-29 11:32:32 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2021-10-29 11:32:32 0 [Note] InnoDB: Completed initialization of buffer pool 2021-10-29 11:32:32 0 [Note] InnoDB: 128 rollback segments are active. 2021-10-29 11:32:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-10-29 11:32:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-10-29 11:32:32 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-10-29 11:32:32 0 [Note] InnoDB: 10.5.12 started; log sequence number 35028; transaction id 8 2021-10-29 11:32:32 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-10-29 11:32:32 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2021-10-29 11:32:32 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-10-29 11:32:32 0 [Note] Heuristic crash recovery mode 2021-10-29 11:32:32 0 [Note] Please restart mysqld without --tc-heuristic-recover 2021-10-29 11:32:32 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") 2021-10-29 11:32:32 0 [Note] InnoDB: Buffer pool(s) load completed at 211029 11:32:32 2021-10-29 11:32:32 0 [ERROR] Can't init tc log 2021-10-29 11:32:32 0 [ERROR] Aborting
  10. Unfortunatley nothing helped for me. I have completely removed MariaDB-Docker and reinstalled. A fresh installation is working. But when I copy/paste "databases"-Directory, then its failing again. UMASK must be a 3-digit mode with an additional leading 0 to indicate octal. The first digit will be corrected to 6, the others may be 0, 2, 4, or 6. UMASK corrected from 022 to 0640 ... 211029 11:27:36 mysqld_safe Logging to '/config/databases/92ecc8717197.err'. 211029 11:27:36 mysqld_safe Starting mariadbd daemon with databases from /config/databases 211029 11:29:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2021-10-29 11:29:59 0 [Note] /usr/bin/mariadbd (mysqld 10.5.12-MariaDB-log) starting as process 4723 ... 2021-10-29 11:29:59 0 [Note] InnoDB: Uses event mutexes 2021-10-29 11:29:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-10-29 11:29:59 0 [Note] InnoDB: Number of pools: 1 2021-10-29 11:29:59 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2021-10-29 11:29:59 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts) 2021-10-29 11:29:59 0 [Note] InnoDB: Using Linux native AIO 2021-10-29 11:29:59 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2021-10-29 11:29:59 0 [Note] InnoDB: Completed initialization of buffer pool 2021-10-29 11:29:59 0 [Note] InnoDB: Transaction 209762720 was in the XA prepared state. 2021-10-29 11:29:59 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2021-10-29 11:29:59 0 [Note] InnoDB: Trx id counter is 209762721 2021-10-29 11:29:59 0 [Note] InnoDB: 128 rollback segments are active. 2021-10-29 11:29:59 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2021-10-29 11:29:59 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2021-10-29 11:29:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-10-29 11:29:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-10-29 11:29:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-10-29 11:29:59 0 [Note] InnoDB: 10.5.12 started; log sequence number 402194885721; transaction id 209762722 2021-10-29 11:29:59 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-10-29 11:29:59 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2021-10-29 11:29:59 0 [Note] InnoDB: Buffer pool(s) load completed at 211029 11:29:59 2021-10-29 11:29:59 0 [Note] InnoDB: Starting recovery for XA transactions... 2021-10-29 11:29:59 0 [Note] InnoDB: Transaction 209762720 in prepared state after recovery 2021-10-29 11:29:59 0 [Note] InnoDB: Transaction contains changes to 4 rows 2021-10-29 11:29:59 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2021-10-29 11:29:59 0 [Note] Found 1 prepared transaction(s) in InnoDB 2021-10-29 11:29:59 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 2021-10-29 11:29:59 0 [ERROR] Aborting 211029 11:29:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  11. Hi, Today I updated the MariaDB Docker and now it is not starting anymore. the err-log shows the following: 2021-10-23 17:53:53 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 2021-10-23 17:53:53 0 [ERROR] Aborting any ideas? Br, Johannes
  12. Hi, I am running Home Assistant as Docker on my UnRaid Installation via Letsencrypt Reverse Proxy to expose it to the internet. I would also have two VPN Solutions configured: 1) OpenVPN as Docker on Unraid 2) L2TP on my Unifi USG Firewall So basically I could deactivate the Reverse Proxy for HomeAssistant but this has one big disadvantage: My parents are also using Home Assistant access from their iPhones. Either I get "On-Demand VPN" working on iOS, but as far as I can say now I would need a MAC to configure the Profiles (and I do not own a MAC) or I keep Reverse Proxy enabled for Home Assistant or someone has another great idea for me. Br, Johannes
  13. Ok, fixed it. I just added the docker again with the same appdata directory. I think I had a typo on the extra arguments, as I have added this via the iPhone...
  14. Hi, I have a big issue. I have a "Node Red" Docker running, but because of an issue with an plugin it stops from time to time. Until I get this fixed, I wanted that the Docker starts automatically, when it crashes and I found an thread where they mentioned to add the EXTRA_PArameter "--restart unless-stopped". I have done this and applied the changes. It failed and now I cannot see the Docker in the Docker List anymore...
  15. Hi, I have the same issue for several dockers since about 1 week now.
  16. Hi, Since some days Unraid shows me many Docker for Upgrading but if I perform an upgrade it shows "TOTAL DATA PULLED: 0 B" Br, Johannes
  17. Hi, I have setup notifications via the notifications center. Now I have a special question: I want to monitor one docker which is configured for auto startup. Can I somehow send a notification, if this docker is down? Br, Johannes
  18. Hi, no, I am not shutting down. I got it now working by reverting back to an older Letsencrypt installation and running a "certbot renew" in the Docker-CLI. I need to look in detail when I have more time.
  19. Hi, I have reverted back now the letsencrypt version, and I was able to fix all errors and warnings, except the last 4 warnings. But the certs are still not updated. Br, Johannes
  20. Hi, was there recently a change on Letsencrypt? Today my websites were broken, because the certificate was not renewed. Last Renewal was in April. In the Logs I cannot find an relating error, of course there are warnings, but I do not think they are responsible for the issue. ------------------------------------- _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io We gratefully accept donations at: https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 20-config: executing... [cont-init.d] 20-config: exited 0. [cont-init.d] 30-keygen: executing... using keys found in /config/keys [cont-init.d] 30-keygen: exited 0. [cont-init.d] 50-config: executing... Variables set: PUID=99 PGID=100 TZ=Europe/Berlin URL=familie-ebner.at SUBDOMAINS=cloud,tauchen,solar,ha,solar2,nr,nr2,wetter,wetter2,mqtt, EXTRA_DOMAINS=cloud.ff-metnitz.at,slideshow.ff-metnitz.at,backup.ff-metnitz.at, ONLY_SUBDOMAINS=true DHLEVEL=2048 VALIDATION=http DNSPLUGIN= EMAIL=johannes@familie-ebner.at STAGING= 2048 bit DH parameters present SUBDOMAINS entered, processing SUBDOMAINS entered, processing Only subdomains, no URL in cert Sub-domains processed are: -d cloud.familie-ebner.at -d tauchen.familie-ebner.at -d solar.familie-ebner.at -d ha.familie-ebner.at -d solar2.familie-ebner.at -d nr.familie-ebner.at -d nr2.familie-ebner.at -d wetter.familie-ebner.at -d wetter2.familie-ebner.at -d mqtt.familie-ebner.at EXTRA_DOMAINS entered, processing Extra domains processed are: -d cloud.ff-metnitz.at -d slideshow.ff-metnitz.at -d backup.ff-metnitz.at E-mail address entered: johannes@familie-ebner.at http validation is selected Certificate exists; parameters unchanged; starting nginx [cont-init.d] 50-config: exited 0. [cont-init.d] 99-custom-files: executing... [custom-init] no custom files found exiting... [cont-init.d] 99-custom-files: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /config/nginx/site-confs/ha.familie-ebner.at:42 nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /config/nginx/site-confs/mqtt.familie-ebner.at:42 nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /config/nginx/site-confs/nr.familie-ebner.at:42 nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /config/nginx/site-confs/nr2.familie-ebner.at:42 nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /config/nginx/site-confs/wetter.familie-ebner.at:42 nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /config/nginx/site-confs/wetter2.familie-ebner.at:42 nginx: [alert] detected a LuaJIT version which is not OpenResty's; many optimizations will be disabled and performance will be compromised (see https://github.com/openresty/luajit2 for OpenResty's LuaJIT or, even better, consider using the OpenResty releases from https://openresty.org/en/download.html) nginx: [error] lua_load_resty_core failed to load the resty.core module from https://github.com/openresty/lua-resty-core; ensure you are using an OpenResty release from https://openresty.org/en/download.html (rc: 2, reason: module 'resty.core' not found: no field package.preload['resty.core'] no file './resty/core.lua' no file '/usr/share/luajit-2.1.0-beta3/resty/core.lua' no file '/usr/local/share/lua/5.1/resty/core.lua' no file '/usr/local/share/lua/5.1/resty/core/init.lua' no file '/usr/share/lua/5.1/resty/core.lua' no file '/usr/share/lua/5.1/resty/core/init.lua' no file '/usr/share/lua/common/resty/core.lua' no file '/usr/share/lua/common/resty/core/init.lua' no file './resty/core.so' no file '/usr/local/lib/lua/5.1/resty/core.so' no file '/usr/lib/lua/5.1/resty/core.so' no file '/usr/local/lib/lua/5.1/loadall.so' no file './resty.so' no file '/usr/local/lib/lua/5.1/resty.so' no file '/usr/lib/lua/5.1/resty.so' no file '/usr/local/lib/lua/5.1/loadall.so') nginx: [warn] conflicting server name "wetter.familie-ebner.at" on 0.0.0.0:80, ignored nginx: [warn] conflicting server name "wetter2.familie-ebner.at" on 0.0.0.0:80, ignored nginx: [warn] conflicting server name "wetter.familie-ebner.at" on 0.0.0.0:443, ignored nginx: [warn] conflicting server name "wetter2.familie-ebner.at" on 0.0.0.0:443, ignored Server ready
  21. Ok, it seems I got it working. Why I was not able to ping external IPs I am still not sure, but this is now working. What I have changed now is that I have set manually the unrestricted DNS Servers in the OpenVPN Config.
  22. Update: I have made the normal Setup as shown in the video (with "BRIDGE"). I can successfully connect from external. But now the funny thing about my second requirement. It is at least working for iOS. *) iOS: When I am in my WLAN without OpenVPN connected, I have a secured internet connection. No Drugs, Porns,... sites. As soon as I am starting OpenVPN I have full access. It seems it is working, because my UnRaid Server is also unrestricted. It seems the iPhone is using then the IP of the UnRaid server to communicate with externals - so this is OK *) Windows: I can establish a OpenVPN Connection from my Intranet, but as soon as it is active I have still access to my internal IPs, but no access to public IPs anymore. It seems Windows is behaving differently compared to iOS... Any ideas?
  23. Hi, I have two questions: 1) In the video it states "host" for the Docker config (in a screenshot). The default ist "Bridge". If changing to "host" the server is not starting correctly. Should I keept it to "bridge"? 2) I have a special requirement in addition to connecting from outside to my environment. I am using PiHole + OpenDNS to secure the internet for my kids. Onmy firewall I am only allowing the PiHole DNS IPs and the OpenDNS IPs. But sometimes I need to disable this. Therefore I want to connect from internally to OpenVPN, getting a different IP and DNS config and allow then the new IP (or a whole new network) to be unrestricted. Is this possible? Best Regards, Johannes
  24. Hi, is this docker supporting redis? Br, Johannes