afsilver
-
Posts
12 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Store
Gallery
Bug Reports
Documentation
Landing
Posts posted by afsilver
-
-
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!
-
On 5/5/2020 at 7:53 AM, sampla said:
I'm also suffering from a missing mysql.sock. The problem emerged after a docker update. Before I delete my own mariadb folder from appdata I'd like to know what problems you had with Nextcloud.
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.
-
1 hour ago, Squid said:
Known limitation of btrfs where it reports the wrong size
How does unraid handle it when i exceed 250GB on the cache then?
1 hour ago, trurl said:with 2 disks, 250+500 raid1, you only get a mirror equal to the smaller disk. Nothing else. Mirror requires the copy of any data to be on a separate device. It wouldn't be redundant if it weren't. So, you only have total capacity of 250.
With 3 disks, 250+500+750 raid1, calculator gives mirror with total capacity of 750. The 750 is mirrored by the 250+500. So the copy of any data can exist on a separate device.
Thank you, this means I do understand it after all (hopefully) 😂
-
On 8/24/2015 at 5:50 AM, trurl said:
If you used all 3 of those, 250, 240, 140, you would get 315. The extra space may not be worth using 2 extra ports, but you also get mirroring.
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?
-
10 hours ago, aptalca said:
Check out the preset heimdall subdolder proxy conf. It does exactly that
i never bothered to check as i assumed subfolder was for "example.com/example" only.
thank you very much 😃
-
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?
-
7 minutes ago, Gog said:
So appdata is only present on your cache, that's good and your mariaDB path is OK. And you are right, moving from a share (/mnt/user) directly to a disk is a bad idea. Always copy share to share or disk to disk.
Have you tried installing MariaDB to a new appdata like /mnt/cache/appdata/mariadb2, verify that this works, stop the container, copy the content of the mariadb dir to the mariadb2 dir, pray a bit and start it back up? Without real backup, that's the only thing I can think of.
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.
-
13 hours ago, jonathanm said:
It would appear your VM was infiltrated, if it were me I'd delete that vdisk and start over. Unraid itself is a little more resilient, but since they were in your VM, who knows where else in your network they poked around.
Each device on your network needs to be examined and possibly reset, including your router.
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).
12 hours ago, Hoopster said:This is why you setup WireGuard (currently included in unRAID), OpenVPN-AS docker container or ZeroTier docker container. I have used all three, but WireGuard is the most convenient.
They all work great for remote access without the risks inherent in opening standard ports on your server directly to the Internet.
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.
[Support] Linuxserver.io - MariaDB
in Docker Containers
Posted
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!