The error message says that the MySQL/MariaDB server is not running. Depending which UCS version you are running, start the appropriate service with the service or systemctl command.
Hello, Thx for the fast answer! I have the latest version running with all updates (Kopano Core: 8.6.2.1-2). Can you give me the command in detail which I can put in Putty?
To start mariadb on UCS 4.3, use service mariadb start. You can check the service status with service mariadb status
Thx for the fast answer. It dosent work 
/var/log$ service mariadb status
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Wed 2018-11-21 10:08:20 CET; 49min ago
Process: 967 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 830 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 797 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 787 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 967 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 499ms
Nov 21 10:08:11 mail systemd[1]: Starting MariaDB database server...
Nov 21 10:08:13 mail mysqld[967]: 2018-11-21 10:08:13 139781907026496 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 967 ...
Nov 21 10:08:20 mail systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Nov 21 10:08:20 mail systemd[1]: Failed to start MariaDB database server.
Nov 21 10:08:20 mail systemd[1]: mariadb.service: Unit entered failed state.
Nov 21 10:08:20 mail systemd[1]: mariadb.service: Failed with result 'exit-code'.
/var/log$ service mariadb start
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
The last lines mentions additional logs you can check, with journalctl -xe. You can also have a look at the logfiles in /var/log/mysql/. It may be possible that the MariaDB database was damaged when your disk ran out of space. If that is the case, the MariaDB documentation will hopefully have some information how to proceed - I do not have experience with reconstructing corrupted databases. If you have a backup of the database, you could import the last working version.
Damrose thank you very much. I will do a rool back to the former VM and rekonfigure the space directly that this problem never happend.
there is also a knowledge base entry for this Problem: MySQL Server Does not Start any more
But if you can easily restore to your last snapshot, that is probably the better way.
Hello Fbartels,
very good hint! Thx! I will try to rebuild the DB!
Hello,
question to disk space. I have now the situation that the disk space runs out! I started the VM with 50GB and after the kopano setup I did increase the VM space to 300GB but the system didn’t increase / recognize this, 98% used. Would it be possible to fix this without new installation? It a kind of a partition problem:
Dateisystem Größe Benutzt Verf. Verw% Eingehängt auf
udev 10M 0 10M 0% /dev
tmpfs 787M 16M 772M 3% /run
/dev/mapper/vg_ucs-root 46G 43G 1,1G 98% /
tmpfs 2,0G 56K 2,0G 1% /dev/shm
tmpfs 5,0M 0 5,0M 0% /run/lock
tmpfs 2,0G 0 2,0G 0% /sys/fs/cgroup
/dev/sda1 472M 63M 385M 15% /boot
Hello Christian,
nice manual which fits on my problem. I tried to execute this but have a poblem. As you can see the VM space (Windows Server 2016) has 300 GB space. But I cant enlarge it. The step 2c (command n) & 2d (command t) dont fits to your manual. Also I couldnt enlarge the space to maybe 250GB. I can create only 49,5GB again as shown. You you have an idea?
Command (m for help): p
Disk /dev/sda: 300 GiB, 322122547200 bytes, 629145600 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Sectors Size Id Type
/dev/sda1 * 2048 999423 997376 487M 83 Linux
/dev/sda2 1001470 104855551 103854082 49,5G 5 Extended
/dev/sda5 1001472 104855551 103854080 49,5G 8e Linux LVMCommand (m for help): d
Partition number (1,2,5, default 5): 5
Partition 5 has been deleted.Command (m for help): n
Partition type
p primary (1 primary, 1 extended, 2 free)
l logical (numbered from 5)
Select (default p): lAdding logical partition 5
First sector (1003518-104855551, default 1003520):
Last sector, +sectors or +size{K,M,G,T,P} (1003520-104855551, default 104855551):Created a new partition 5 of type ‘Linux’ and of size 49,5 GiB.
Partition #5 contains a ext4 signature.Do you want to remove the signature? [Y]es/[N]o: n
Command (m for help): t
Partition number (1,2,5, default 5): 5
Partition type (type L to list all types): 8eChanged type of partition ‘Linux’ to ‘Linux LVM’.
Command (m for help): w
The partition table has been altered.
Calling ioctl() to re-read partition table.
Re-reading the partition table failed.: Das Gerät oder die Ressource ist belegtThe kernel still uses the old table. The new table will be used at the next reboot or after you run partprobe(8) or kpartx(8).
root@mail:~# pvresize /dev/sda5
Physical volume “/dev/sda5” changed
1 physical volume(s) resized / 0 physical volume(s) not resized
root@mail:~# lvresize -l +100%FREE /dev/vg_ucs/root
New size (12165 extents) matches existing size (12165 extents).
root@mail:~# resize2fs /dev/vg_ucs/root
resize2fs 1.43.4 (31-Jan-2017)
Das Dateisystem ist bereits 12456960 (4k) Blöcke lang. Nichts zu tun!
Thx a lot!
Hello Again,
Maybe somebody can advice me whats going wrong if I want to increase my stroage size. I stick in step 2e on Christians Workaround (special thx to him!). There isnt the message like shown in that “all space is in use.”
Please see also as shown below what I did. I cant see a mistake.
Additional informtation: the kopano machine run as VM under hyper-v. Maybe here is somethink different.
Step 2e from Christian:
Command (m for help): n
All space for primary partitions is in use.
This is the feedback which I get in step 2e:
Command (m for help): n
Partition type
p primary (1 primary, 1 extended, 2 free)
l logical (numbered from 5)
Select (default p):
If I type l for "logical Partition I get the followed feedback:
Select (default p): l
Adding logical partition 6No free sectors available.
Complete log from my excecution till 2e:
root@mail:~# fdisk /dev/sda
Welcome to fdisk (util-linux 2.29.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.Command (m for help): u
Changing display/entry units to cylinders (DEPRECATED!).
Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Geometry: 255 heads, 63 sectors/track, 28719 cylinders
Units: cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Cylinders Size Id Type
/dev/sda1 * 1 63 63 487M 83 Linux
/dev/sda2 63 6527 6465 49,5G 5 Extended
/dev/sda5 63 6527 6465 49,5G 8e Linux LVMCommand (m for help): d
Partition number (1,2,5, default 5): 5Partition 5 has been deleted.
Command (m for help): d
Partition number (1,2, default 2): 2Partition 2 has been deleted.
Command (m for help): n
Partition type
p primary (1 primary, 0 extended, 3 free)
e extended (container for logical partitions)
Select (default p): e
Partition number (2-4, default 2): 2
First cylinder (63-28719, default 63): 63
Last cylinder, +cylinders or +size{K,M,G,T,P} (63-28719, default 28719): 28719Created a new partition 2 of type ‘Extended’ and of size 219,5 GiB.
Command (m for help): n
Partition type
p primary (1 primary, 1 extended, 2 free)
l logical (numbered from 5)
Select (default p):
PS.: All the best for X-mas days and thx in advanced for support!
Can you post what you see when typing “p” after this step?
/KNEBB
Dear knebb,
thx for your support! Im not realy sure if you can see something?! This is the feedback on p after step 2d. I see there a different start and end cylinder!?!?!?:
Feedback after step 2d on p command:
Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Sectors Size Id Type
/dev/sda1 * 2048 999423 997376 487M 83 Linux
/dev/sda2 1001470 104855551 103854082 49,5G 5 Extended
/dev/sda5 1001472 104855551 103854080 49,5G 8e Linux LVMCommand (m for help):
This is the complete log:
root@mail:~# fdisk /dev/sda
Welcome to fdisk (util-linux 2.29.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.Command (m for help): u
Changing display/entry units to cylinders (DEPRECATED!).Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Geometry: 255 heads, 63 sectors/track, 28719 cylinders
Units: cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Cylinders Size Id Type
/dev/sda1 * 1 63 63 487M 83 Linux
/dev/sda2 63 6527 6465 49,5G 5 Extended
/dev/sda5 63 6527 6465 49,5G 8e Linux LVMCommand (m for help): d
Partition number (1,2,5, default 5): 5Partition 5 has been deleted.
Command (m for help): d
Partition number (1,2, default 2): 2Partition 2 has been deleted.
Command (m for help): n
Partition type
p primary (1 primary, 0 extended, 3 free)
e extended (container for logical partitions)
Select (default p): e
Partition number (2-4, default 2): 2
First cylinder (63-28719, default 63): 63
Last cylinder, +cylinders or +size{K,M,G,T,P} (63-28719, default 28719): 28719Created a new partition 2 of type ‘Extended’ and of size 219,5 GiB.
Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Sectors Size Id Type
/dev/sda1 * 2048 999423 997376 487M 83 Linux
/dev/sda2 1001470 104855551 103854082 49,5G 5 Extended
/dev/sda5 1001472 104855551 103854080 49,5G 8e Linux LVMCommand (m for help):
This is the feedback afterwards if I try to rewrite the partition table:
Command (m for help): w
The partition table has been altered.
Calling ioctl() to re-read partition table.
Re-reading the partition table failed.: Das Gerät oder die Ressource ist belegtThe kernel still uses the old table. The new table will be used at the next reboot or after you run partprobe(8) or kpartx(8).
root@mail:~# fdisk /dev/sda
Welcome to fdisk (util-linux 2.29.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Sectors Size Id Type
/dev/sda1 * 2048 999423 997376 487M 83 Linux
/dev/sda2 1001470 104855551 103854082 49,5G 5 Extended
/dev/sda5 1001472 104855551 103854080 49,5G 8e Linux LVMCommand (m for help):
These is NOT the exact output of what you are doing! Is simply does not macht.
Please follow the steps exactly and type “p” after 2d and before 2e.
You output shows it has created the larger partition 2:
Created a new partition 2 of type ‘Extended’ and of size 219,5 GiB.
But then you post the output of “p” which tells us it is not directly afterwards (as the units does not match).
/CV
Hello Again,
sorry maybe I had a copy past error. I check it again, and of course you are right but I stick on the point 2e further. The system did create a full extented partition but doesnt give me the feedback which you have under 2e. How should I proceed?
After step 2d: Extended stroage created of 219,5GB
Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Geometry: 255 heads, 63 sectors/track, 28719 cylinders
Units: cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Cylinders Size Id Type
/dev/sda1 * 1 63 63 487M 83 Linux
/dev/sda2 63 28719 28657 219,5G 5 Extended
Step 2e dosent give me the same Feedback like you have (all space is use)
Command (m for help): n
Partition type
p primary (1 primary, 1 extended, 2 free)
l logical (numbered from 5)
Select (default p):
Here is the log again with the status after 2e
fdisk: cannot open /etc/sda: Datei oder Verzeichnis nicht gefunden
root@mail:~# u
-bash: u: Kommando nicht gefunden.
root@mail:~# fdisk /dev/sdaWelcome to fdisk (util-linux 2.29.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.Command (m for help): u
Changing display/entry units to cylinders (DEPRECATED!).Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Geometry: 255 heads, 63 sectors/track, 28719 cylinders
Units: cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Cylinders Size Id Type
/dev/sda1 * 1 63 63 487M 83 Linux
/dev/sda2 63 6527 6465 49,5G 5 Extended
/dev/sda5 63 6527 6465 49,5G 8e Linux LVMCommand (m for help): d
Partition number (1,2,5, default 5): 5Partition 5 has been deleted.
Command (m for help): d
Partition number (1,2, default 2): 2Partition 2 has been deleted.
Command (m for help): n
Partition type
p primary (1 primary, 0 extended, 3 free)
e extended (container for logical partitions)
Select (default p): e
Partition number (2-4, default 2): 2
First cylinder (63-28719, default 63): 63
Last cylinder, +cylinders or +size{K,M,G,T,P} (63-28719, default 28719): 28719Created a new partition 2 of type ‘Extended’ and of size 219,5 GiB.
Command (m for help): p
Disk /dev/sda: 220 GiB, 236223201280 bytes, 461373440 sectors
Geometry: 255 heads, 63 sectors/track, 28719 cylinders
Units: cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: dos
Disk identifier: 0xa649a22dDevice Boot Start End Cylinders Size Id Type
/dev/sda1 * 1 63 63 487M 83 Linux
/dev/sda2 63 28719 28657 219,5G 5 ExtendedCommand (m for help): n
Partition type
p primary (1 primary, 1 extended, 2 free)
l logical (numbered from 5)
Select (default p):
Hi,
well from your latest output everything is working fine. The extended partition is created with the space and now you should re-create the logical partition.
According to this it is waiting four you to type “l”…
Sorry, but to be able to help you should REALLY post helpful things. Up to 2d everything is fine. Make sure you type in “l”, and NOT “p”!
/CV
Thx a lot for your great support Christian! I learnd something About my mistake! Its really essential to run fdisk in one session. I jumped out for exsample sometimes by wrong typing and than you loose all changes directly which was done with fdisk before!
Just an update as I had this exact problem today and solved it by deleting /var/lib/mysql/tc.log, this appears to work!!