*New 12.1 series Release:
2019-11-08: XigmaNAS 12.1.0.4.7091 - released!

*New 11.3 series Release:
2019-10-19: XigmaNAS 11.3.0.4.7014 - released


We really need "Your" help on XigmaNAS https://translations.launchpad.net/xigmanas translations. Please help today!

Producing and hosting XigmaNAS costs money. Please consider donating for our project so that we can continue to offer you the best.
We need your support! eg: PAYPAL

"write failed, file system is full" after adding MariaDB

XigmaNAS Extensions / Add-ons

Moderator: crest

Forum rules
Set-Up GuideFAQsForum Rules
Post Reply
csilvest
NewUser
NewUser
Posts: 1
Joined: 07 Dec 2018 20:40
Status: Offline

"write failed, file system is full" after adding MariaDB

#1

Post by csilvest » 23 Apr 2019 18:54

Hi everybody! And.... HELP!!!

I had a perfectly functioning XigmaNAS running for a few months. But now I've broken it. Tried to install MariaDB from the OBI. Not sure what went wrong. While the NAS still works, I can no longer get the web server started, nor SSHd. Shortly after the networking starts I see a number of messages related to mysqld and/or MariaDB.... for instance:

Code: Select all

2019-04-23 12:26:14 34722398206 [Warning] mysqld: Retry in 60 secs. Message reprinted every 60 seconds.
/: write failed, file system is full
/: write failed, file system is full
... repeats every 60 seconds
So I'm in a bit of a panic; the fact that the NAS is still functioning makes it a little less stressful (and yes, a full backup has been done!).

What I really want to do immediately is remove the apparently munged up MariaDB and/or MySQL installation. I'm fairly weak with this *nix stuff, so I'm seeking guidance here. More details can be provided; here's the basics:

Installed XigmaNAS-x64-LiveCD-11.2.0.4.6536 on a 32GB USB stick, HP Compaq Pro 6300; 4GB RAM, one 3GB HDD installed.

Any help appreciated!

User avatar
crest
Hardware & Software Guru
Hardware & Software Guru
Posts: 873
Joined: 02 Jul 2012 22:25
Location: Vienna, Austria - GMT+1
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#2

Post by crest » 24 Apr 2019 21:52

Hello csilves,

Welcome to the forums!
csilvest wrote:
23 Apr 2019 18:54
Hi everybody! And.... HELP!!!

I had a perfectly functioning XigmaNAS running for a few months. But now I've broken it. Tried to install MariaDB from the OBI. Not sure what went wrong. While the NAS still works, I can no longer get the web server started, nor SSHd. Shortly after the networking starts I see a number of messages related to mysqld and/or MariaDB.... for instance:

Code: Select all

2019-04-23 12:26:14 34722398206 [Warning] mysqld: Retry in 60 secs. Message reprinted every 60 seconds.
/: write failed, file system is full
/: write failed, file system is full
... repeats every 60 seconds
So I'm in a bit of a panic; the fact that the NAS is still functioning makes it a little less stressful (and yes, a full backup has been done!).

What I really want to do immediately is remove the apparently munged up MariaDB and/or MySQL installation. I'm fairly weak with this *nix stuff, so I'm seeking guidance here. More details can be provided; here's the basics:

Installed XigmaNAS-x64-LiveCD-11.2.0.4.6536 on a 32GB USB stick, HP Compaq Pro 6300; 4GB RAM, one 3GB HDD installed.

Any help appreciated!
Since you wrote you tried to install both MySQL from within OBI and MariaDB (from stock) I assume that you
- didn't change the default path in stock MariaDB
- installed the OBI extensions not to a share on one of your data drives
therefore the db fills up your root respectively var file system.

So your problem should be easy to solve, please provide
- to which path did you install OBI and
- where did you place the MariaDB path?

Regards
crest
NAS1: 11.2.0.4 - Omnius (Revision 6766) x64-embedded; MSI 760GM-P23; AMD Athlon(tm) II X2 250 7.58GiB RAM
NAS2: 11.2.0.4 - Omnius (Revision 6766) x64-embedded; MSI MS-7369; AMD Sempron(tm) LE-1250 8022MiB RAM
UPS: APC Back-UPS ES 550G
Extensions: OneButtonInstaller, Extended GUI, NextOwnCloud, BitTorrent Sync, Syncthing, Downloady, Midnight Commander, NCDU, MySQL, Rclone, Themes:

axb
NewUser
NewUser
Posts: 4
Joined: 14 Aug 2019 02:41
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#3

Post by axb » 14 Aug 2019 02:46

Hi everybody!

I have the same problem, please help.

I clicked "Enable" in MariaDB (from stock) and XigmaNAS don't boot…

Shperrung
experienced User
experienced User
Posts: 107
Joined: 04 Apr 2018 16:29
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#4

Post by Shperrung » 14 Aug 2019 08:40

Looks like you both indicated path for installation Maria DB into root directory on embedded system.

Code: Select all

/: write failed, file system is full
11.2.0.4 - Omnius (revision 6177) embedded -> XigmaNAS 12.0.0.4.6928 RootOnZFS
ASRock J3710-ITX, LAN: Winyao 2 ports; 16Gb RAM; WD 1Tbx2, WD 2Tb; UPS Powercom WOW500U.

axb
NewUser
NewUser
Posts: 4
Joined: 14 Aug 2019 02:41
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#5

Post by axb » 14 Aug 2019 11:25

Can it be unscrewed?

User avatar
raulfg3
Site Admin
Site Admin
Posts: 4965
Joined: 22 Jun 2012 22:13
Location: Madrid (ESPAÑA)
Contact:
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#6

Post by raulfg3 » 14 Aug 2019 16:47

You need to define a persistent path for it on your data disk , not default on boot disk.
12.0.0.4 (revision 6766)+OBI on SUPERMICRO X8SIL-F 8GB of ECC RAM, 12x3TB disk in 3 vdev in RaidZ1 = 32TB Raw size only 22TB usable

Wiki
Last changes

axb
NewUser
NewUser
Posts: 4
Joined: 14 Aug 2019 02:41
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#7

Post by axb » 14 Aug 2019 20:28

But how can I do this since XigmaNAS hangs on this write attempt during boot?

User avatar
raulfg3
Site Admin
Site Admin
Posts: 4965
Joined: 22 Jun 2012 22:13
Location: Madrid (ESPAÑA)
Contact:
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#8

Post by raulfg3 » 15 Aug 2019 00:51

Boot live CD/USB And delete some folders to free space on boot disk,

You need to mount your actual non bootable disk
12.0.0.4 (revision 6766)+OBI on SUPERMICRO X8SIL-F 8GB of ECC RAM, 12x3TB disk in 3 vdev in RaidZ1 = 32TB Raw size only 22TB usable

Wiki
Last changes

User avatar
ms49434
Developer
Developer
Posts: 753
Joined: 03 Sep 2015 18:49
Location: Neuenkirchen-Vörden, Germany - GMT+1
Contact:
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#9

Post by ms49434 » 15 Aug 2019 02:19

axb wrote:
14 Aug 2019 20:28
But how can I do this since XigmaNAS hangs on this write attempt during boot?
These instructions have been tested for a FULL installation:
to disable mariadb (stock) you must perform the following steps:
1. boot in single user mode (boot menu option #2)
2. remount the root folder in read/write mode

Code: Select all

# mount -urw /
3. export xterm

Code: Select all

# export TERM=xterm
4. edit config.xml (nano or vi, whichever you prefer)

Code: Select all

# /usr/local/bin/nano /conf/config.xml
5. scroll to section <mariadb>

Code: Select all

	<mariadb>
		<enable type="bool">1</enable>
	</mariadb>
6. delete the line containing <enable type="bool">1</enable> in the <mariadb> section

Code: Select all

	<mariadb>
	</mariadb>
7. write file and exit editor.
8. reboot

Code: Select all

# reboot
1) XigmaNAS 12.0.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U2, 22GB out of 32GB ECC RAM, LSI 9300-8i IT mode in passthrough mode. Pool 1: 2x HGST 10TB, mirrored, SLOG: Samsung 850 Pro, L2ARC: Samsung 850 Pro, Pool 2: 1x Samsung 860 EVO 1TB , services: Samba AD, CIFS/SMB, ftp, ctld, rsync, syncthing, zfs snapshots.
2) XigmaNAS 12.0.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U2, 8GB out of 32GB ECC RAM, IBM M1215 crossflashed, IT mode, passthrough mode, 2x HGST 10TB , services: rsync.

axb
NewUser
NewUser
Posts: 4
Joined: 14 Aug 2019 02:41
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#10

Post by axb » 15 Aug 2019 15:50

Thank you very much!

I tried to use single user mode before, but I got an error

Code: Select all

/etc/fstab:0 no such file or directory
when trying to mount a partition. Fortunately, in the read/write mode I was able to mount it from LiveUSB.

Many thanks to the developers for a great job!

User avatar
ms49434
Developer
Developer
Posts: 753
Joined: 03 Sep 2015 18:49
Location: Neuenkirchen-Vörden, Germany - GMT+1
Contact:
Status: Offline

Re: "write failed, file system is full" after adding MariaDB

#11

Post by ms49434 » 16 Aug 2019 17:05

These instructions have been tested for an EMBEDDED installation:

to disable mariadb (stock) you must perform the following steps:
1. boot in single user mode (boot menu option #2)
2. set some environment variables

Code: Select all

# export HOME=/
# export TERM=xterm
3. collect boot device name

Code: Select all

# /sbin/glabel status
4. search the output for ufs/embboot, in this example the component value is 'ada0p2' => /dev/ada0p2 which will be used to mount the boot device

Code: Select all

# /sbin/mount -rw /dev/ada0p2 /mnt
5. create memory disk, the output is 'md1' which will be used to unpack the mdlocal file

Code: Select all

# /sbin/mdconfig -t malloc -o compress -s 1192M
6. unpack files for /usr/local

Code: Select all

# /usr/bin/xz -dcv /mnt/mdlocal.xz | /bin/dd of=/dev/md1 bs=1m status=none
7. mount /usr/local

Code: Select all

# /sbin/mount -o noatime,acls /dev/md1 /usr/local
8. use nano to edit config.xml

Code: Select all

# /usr/local/bin/nano /mnt/conf/config.xml
9. scroll to section <mariadb>

Code: Select all

	<mariadb>
		<enable type="bool">1</enable>
	</mariadb>
10. delete the line containing <enable type="bool">1</enable> in the <mariadb> section

Code: Select all

	<mariadb>
	</mariadb>
11. write file and exit editor.
12. reboot

Code: Select all

# reboot
1) XigmaNAS 12.0.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U2, 22GB out of 32GB ECC RAM, LSI 9300-8i IT mode in passthrough mode. Pool 1: 2x HGST 10TB, mirrored, SLOG: Samsung 850 Pro, L2ARC: Samsung 850 Pro, Pool 2: 1x Samsung 860 EVO 1TB , services: Samba AD, CIFS/SMB, ftp, ctld, rsync, syncthing, zfs snapshots.
2) XigmaNAS 12.0.0.4 amd64-embedded on a Dell T20 running in a VM on ESXi 6.7U2, 8GB out of 32GB ECC RAM, IBM M1215 crossflashed, IT mode, passthrough mode, 2x HGST 10TB , services: rsync.

Post Reply

Return to “Extensions / Add-ons”