afsilver

Members
  • Posts

    12
  • Joined

  • Last visited

Everything posted by afsilver

  1. I gave up, and deleted the whole db and rebuilt it. Added users manually and scanned files in nextcloud folder to add the userfiles. Had a new btrfs fail on the cache drive and lost the db again, this time i had a local and external backup!
  2. i had a severe crash on my unraid server 3 days ago, docker service kept locking up, and i had to delete docker image and start over. now everything is back except mariadb. log from docker: [cont-init.d] 10-adduser: exited 0. [cont-init.d] 30-config: executing... [cont-init.d] 30-config: exited 0. [cont-init.d] 40-initialise-db: executing... [cont-init.d] 40-initialise-db: exited 0. [cont-init.d] 90-custom-folders: executing... [cont-init.d] 90-custom-folders: 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. 220519 18:55:56 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:55:56 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:55:58 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:55:58 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:00 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:00 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:02 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:02 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:05 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:05 mysqld_safe Starting mariadbd daemon with databases from /config/databases 220519 18:56:07 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'. 220519 18:56:07 mysqld_safe Starting mariadbd daemon with databases from /config/databases Caught SIGTERM signal! cat: /var/run/mysqld/mysqld.pid: No such file or directory [cont-finish.d] executing container finish scripts... [cont-finish.d] done. [s6-finish] waiting for services. [s6-finish] sending all processes the TERM signal. [s6-finish] sending all processes the KILL signal and exiting. text from e8ae576d472a.err: 220519 18:43:20 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2022-05-19 18:43:20 0 [Note] /usr/bin/mariadbd (mysqld 10.5.15-MariaDB-log) starting as process 518 ... 2022-05-19 18:43:21 0 [Note] InnoDB: Uses event mutexes 2022-05-19 18:43:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-05-19 18:43:21 0 [Note] InnoDB: Number of pools: 1 2022-05-19 18:43:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-05-19 18:43:21 0 [Note] InnoDB: Using Linux native AIO 2022-05-19 18:43:21 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2022-05-19 18:43:21 0 [Note] InnoDB: Completed initialization of buffer pool 2022-05-19 18:43:22 0 [Note] InnoDB: Transaction 50443189 was in the XA prepared state. 2022-05-19 18:43:22 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2022-05-19 18:43:22 0 [Note] InnoDB: Trx id counter is 50443190 2022-05-19 18:43:22 0 [Note] InnoDB: 128 rollback segments are active. 2022-05-19 18:43:22 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2022-05-19 18:43:22 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2022-05-19 18:43:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-05-19 18:43:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-05-19 18:43:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-05-19 18:43:22 0 [Note] InnoDB: 10.5.15 started; log sequence number 11641422179; transaction id 50443191 2022-05-19 18:43:22 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2022-05-19 18:43:22 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-05-19 18:43:22 0 [Note] InnoDB: Starting recovery for XA transactions... 2022-05-19 18:43:22 0 [Note] InnoDB: Transaction 50443189 in prepared state after recovery 2022-05-19 18:43:22 0 [Note] InnoDB: Transaction contains changes to 1 rows 2022-05-19 18:43:22 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2022-05-19 18:43:22 0 [Note] Found 1 prepared transaction(s) in InnoDB 2022-05-19 18:43:22 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 ma> 2022-05-19 18:43:22 0 [ERROR] Aborting 220519 18:43:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended tried "mysqld --user=root --tc-heuristic-recover" with rollback and commit. in the docker console. root@e8ae576d472a:/# mysqld --user=root --tc-heuristic-recover rollback 2022-05-19 19:01:16 0 [Note] mysqld (mysqld 10.5.15-MariaDB-log) starting as process 1375 ... 2022-05-19 19:01:16 0 [Note] InnoDB: Uses event mutexes 2022-05-19 19:01:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-05-19 19:01:16 0 [Note] InnoDB: Number of pools: 1 2022-05-19 19:01:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-05-19 19:01:16 0 [Note] InnoDB: Using Linux native AIO 2022-05-19 19:01:16 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2022-05-19 19:01:16 0 [Note] InnoDB: Completed initialization of buffer pool 2022-05-19 19:01:17 0 [Note] InnoDB: 128 rollback segments are active. 2022-05-19 19:01:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-05-19 19:01:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-05-19 19:01:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-05-19 19:01:17 0 [Note] InnoDB: 10.5.15 started; log sequence number 35064; transaction id 8 2022-05-19 19:01:17 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-05-19 19:01:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-05-19 19:01:17 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-05-19 19:01:17 0 [Note] Heuristic crash recovery mode 2022-05-19 19:01:17 0 [Note] Please restart mysqld without --tc-heuristic-recover 2022-05-19 19:01:17 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") 2022-05-19 19:01:17 0 [Note] InnoDB: Buffer pool(s) load completed at 220519 19:01:17 2022-05-19 19:01:17 0 [ERROR] Can't init tc log 2022-05-19 19:01:17 0 [ERROR] Aborting But i do not know how to proceed from here. any help is grately appriciated!
  3. Cant really remember, i believe it got a full reset. So i started over, since it did not contain any files, just a few users. But i also believe this is the wrong thread for nextcloud issues.
  4. How does unraid handle it when i exceed 250GB on the cache then? Thank you, this means I do understand it after all (hopefully) 😂
  5. I really do not understand how the space is calculated. I have 2 drives in cache pool 1 250GB 1 500GB Unraid reports total capacity of 375GB. Which i get if i split the diff and add to the smallest drive. I tired the btrfs calculator, under no circumstances do i get 375. But does this mean i get "proper" RAID1 up to 250GB, then the remaining is duplicated on the 500GB drive only? I am also planning to add another 750GB drive to the cache pool, which in my head would give me proper redundancy with 750GB usable space?
  6. i never bothered to check as i assumed subfolder was for "example.com/example" only. thank you very much 😃
  7. I have letsencrypt working flawlessly with several subdomains. However, i want my top domain to reverse proxy into the Heimdall container. If i access my domain now, i get the following: Welcome to our server The website is currently being setup under this address. For help and support, please contact: [email protected]. How can i redirect https://example.com to Heimdall?
  8. i did edit my first post, axplaining that i "fixed" mariadb by deleting the mariadb folder in appdata. you must have missed it 😃 it now works. but onto nextcloud which is also f'd. thanks for the help anyways
  9. i had the appdata share set to cache only. but some files where not moved. so i set cache to prefer and started the mover. then i set the cache back to only. now i cannot find any appdata folders on any disks. but i later read in another thread that i should manually move from mnt/disk'X' -> mnt/cache, not from mnt/user -> mnt/cache. but to answer your question. my mapping for mariadb was /mnt/user/appdata/mariadb, but now it is /mnt/cache/appdata/mariadb.
  10. Hi, yesterday i added a cache drive to my unraid server, which i belive somehow messed up the appdata share for the docker containers. all the containers need to be set up again. currently i am stuck at fixing mariadb, as the "mysqld.sock" is missing and the sql server wont start. it is supposed to be located in "/var/run/mysqld/" trying to login to the sql server gives me this error: "# mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" i have removed and readded the mariadb docker from the community applications plugin. but still the file is missing. edit: turns out i am missing alot of files in appdata folder after my screwup. deleting mariadb folder from appdata and setting up mariadb from scratch solved my issue.
  11. Thanks, i'll get ridd of the vdisk straight away. Regarding the router, I am hesitant to reset it. Took me quite i while to set up, guess i'll have to go digging for my backup config (if i ever made one). Then WireGuard will be my next "project". thanks for the tip.
  12. So recently got my unraid server up and running. During setup i left unraid and VMs visible to wan ie. I forwarded the ports to webgui for unraid and VNC(stupid i know). I did this incase i wanted to work on the server from... well anywhere. Earlier today i started working on gpu passthrough. Started the VM and open VNC. Once i got to the VMs desktop i lost vnc connection and could not reconnect. I noticed unraid reporting vnc port 5900 but when i open a new vnc window it open it with port 5700. Then i looked over to the display for the VM and noticed a "run" window and CMD was being used 😮 So i rushed to unplug all the ethernet cables i could, and the activity stopped. Since i had no control over the VM, I could only see some of the command being written. "...E6netsh advfirewall firewall add rule name02ok2 dir0in" I assume this is some bot/hacker opening the vm firewall and not some expected behavior from unraid? Safe to say. Upnp and the ports has been disabled/closed in the router. I also checked the VMs vnc was setup with a password. Also how did the vnc ports get f...ed up? Firefox did not allow me to edit the url in the vnc window.