afsilver
Members-
Posts
12 -
Joined
-
Last visited
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
afsilver's Achievements
Noob (1/14)
0
Reputation
-
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!
-
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!
-
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.
-
How does unraid handle it when i exceed 250GB on the cache then? Thank you, this means I do understand it after all (hopefully) 😂
-
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?
-
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?
-
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
-
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.
-
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.
-
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.
-
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.