# MariaDB errors after installing Vital v4 **URL:** \ **Category:** VitalPBX\ **Created:** [June 16, 2024, 4:43am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179 "2024-06-16T04:43:57Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 16, 2024, 4:43am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/1 "2024-06-16T04:43:57Z")
I just ran the debian 11 install script on on a vps in Vultr like I have been doing other days, but after the script finishes the mariadb service is not working at all ```auto Jun 14 06:01:41 systemd[1]: Starting MariaDB 10.5.23 database server... Jun 14 06:01:41 mariadbd[4292]: 2024-06-14 6:01:41 0 [Note] Starting MariaDB 10.5.23-MariaDB-0+deb11u1 source revision 6cfd2ba397b0ca689d8ff1bdb9fc4a4dc516a5eb as proces> Jun 14 06:01:41 mariadbd[4292]: 2024-06-14 6:01:41 0 [ERROR] InnoDB: innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB Jun 14 06:01:41 mariadbd[4292]: 2024-06-14 6:01:41 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Jun 14 06:01:41 mariadbd[4292]: 2024-06-14 6:01:41 0 [Note] Plugin 'FEEDBACK' is disabled. Jun 14 06:01:41 mariadbd[4292]: 2024-06-14 6:01:41 0 [ERROR] Unknown/unsupported storage engine: InnoDB Jun 14 06:01:41 mariadbd[4292]: 2024-06-14 6:01:41 0 [ERROR] Aborting Jun 14 06:01:41 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Jun 14 06:01:41 systemd[1]: mariadb.service: Failed with result 'exit-code'. Jun 14 06:01:41 systemd[1]: Failed to start MariaDB 10.5.23 database server. ``` Any idea what could be causing this error, I have upgrade multiple PBXs to v4 in Vultr without seeing this before. ---
**Author:** ![mo10](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/58f4c7/32.png) [@mo10](https://forums.vitalpbx.org/u/mo10)\ **Post date:** [June 16, 2024, 8:23am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/2 "2024-06-16T08:23:36Z")
Strange error, indeed. All the vitalpbx commands via ssh do not help either? ---
**Author:** ![sama](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/s/7993a0/32.png) [@sama](https://forums.vitalpbx.org/u/sama)\ **Post date:** [June 16, 2024, 9:20am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/3 "2024-06-16T09:20:55Z")
> [@hlev](#): > > `innodb_page_size=16384 requires innodb_buffer_pool_size >= 5MiB current 2MiB` Please post the content of /etc/mysql/conf.d/vitalpbx.cnf ---
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 17, 2024, 1:38am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/4 "2024-06-17T01:38:17Z")
Here are the contents of /etc/mysql/conf.d/vitalpbx.cnf ```auto innodb_flush_log_at_trx_commit=2 innodb_log_file_size=64M innodb_log_buffer_size=64M bulk_insert_buffer_size=64M innodb_lock_wait_timeout=180 tmp_table_size=128M max_heap_table_size=128M innodb_buffer_pool_size=0G query_cache_size=64M wait_timeout=120 max_allowed_packet=1G ``` Grabbing the files from a different server it did have different values ```auto innodb_flush_log_at_trx_commit=2 innodb_log_file_size=64M innodb_log_buffer_size=64M bulk_insert_buffer_size=64M innodb_lock_wait_timeout=180 tmp_table_size=64M max_heap_table_size=64M innodb_buffer_pool_size=128M query_cache_size=64M wait_timeout=120 max_allowed_packet=100M log_warnings=1 ``` ---
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 17, 2024, 2:29am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/5 "2024-06-17T02:29:48Z")
Modifying the value for the innodb\_buffer\_pool\_size from to proper value other than 0GB allows the Mariadb service to start. I have set the value back to 512M as the vps is small. So I added `sed -i 's/^innodb_buffer_pool_size=0G/innodb_buffer_pool_size=512M/'` to the install script before the mariadb.service restart line and was able to complete the install fully again. ---
**Author:** ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)\ **Post date:** [June 17, 2024, 4:27pm UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/6 "2024-06-17T16:27:19Z")
You must use 1GB RAM servers as minimum for VitalPBX ---
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 17, 2024, 4:44pm UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/7 "2024-06-17T16:44:11Z")
The vm is using 1 core and 2GB and couldn’t get the install to finish. this is the first time it has happened. Until i set the value innodb\_buffer\_pool\_size to something other than the 0G it was set to. ---
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 17, 2024, 5:16pm UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/8 "2024-06-17T17:16:37Z")
The day before this error started happening I deploy a client on a 1core 1Gb ram vps, without a problem. That is why I opened this ticket something was off, as the vps was getting out of memory issues as well which hadn’t happened before. ---
**Author:** ![Tuxheader](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/t/71c47a/32.png) [@Tuxheader](https://forums.vitalpbx.org/u/Tuxheader)\ **Post date:** [June 18, 2024, 4:45am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/9 "2024-06-18T04:45:50Z")
Do not use the script, since Vultr uses many ports that VitalPBX usually uses for itself, and these conflict. Upload the .ISO and proceed to install from there. Best Regards! ---
**Author:** ![Tuxheader](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/t/71c47a/32.png) [@Tuxheader](https://forums.vitalpbx.org/u/Tuxheader)\ **Post date:** [June 18, 2024, 4:47am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/10 "2024-06-18T04:47:21Z")
José, “Do not use the script, since Vultr uses many ports that VitalPBX usually uses for itself, and these conflict” Upload the .ISO and proceed to install from there. Pura Vida José!!! ---
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 18, 2024, 4:49am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/11 "2024-06-18T04:49:44Z")
Script install works, I have used it multiple times. The issue was pointed above the innodb\_buffer\_pool\_size value was set wrongly, but it has been fixed. I have deployed 2 vms today via the script in vultr without problems. ---
**Author:** ![mo10](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/58f4c7/32.png) [@mo10](https://forums.vitalpbx.org/u/mo10)\ **Post date:** [June 18, 2024, 5:17am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/12 "2024-06-18T05:17:53Z")
> [@hlev](#): > > have deployed 2 vms today via the script in vultr without problems. So maybe an vultr issue? ---
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 18, 2024, 5:24am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/13 "2024-06-18T05:24:40Z")
No the issue was the innodb\_buffer\_pool\_size value in the /etc/mysql/conf.d/vitalpbx.cnf file, after manually modifying it yesterday, that I was able to finalize the install. Today the value has been changed back to 128M by the vital devs as that is what I am seeing in the two vms I provisioned. ---
**Author:** ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)\ **Post date:** [June 18, 2024, 4:36pm UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/14 "2024-06-18T16:36:18Z")
We haven’t changed anything! So, what happened to you seems like an isolated case! ---
**Author:** ![hlev](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/hlev/32/42_2.png) [@hlev](https://forums.vitalpbx.org/u/hlev)\ **Post date:** [June 19, 2024, 1:49pm UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/15 "2024-06-19T13:49:45Z")
I forgot to update the post yesterday but I experienced the issue again, with another vm with 1 core and 2GB of ram. On my last update, I deployed 2 vms with 1core 1gb of ram that day, both of those ran the script without trouble and had the `/etc/mysql/conf.d/vitalpbx.cnf` like this ```auto [mysqld] innodb_flush_log_at_trx_commit=2 innodb_log_file_size=64M innodb_log_buffer_size=64M bulk_insert_buffer_size=64M innodb_lock_wait_timeout=180 tmp_table_size=64M max_heap_table_size=64M innodb_buffer_pool_size=128M query_cache_size=64M wait_timeout=120 max_allowed_packet=100M ``` The innodb\_buffer\_pool\_size value by default was to 128M which made me think you guys had made changes, but yesterday with the 2GB of RAM vm which experienced the issue again, the file `/etc/mysql/conf.d/vitalpbx.cnf` was like this again: ```auto [mysqld] innodb_flush_log_at_trx_commit=2 innodb_log_file_size=64M innodb_log_buffer_size=64M bulk_insert_buffer_size=64M innodb_lock_wait_timeout=180 tmp_table_size=128M max_heap_table_size=128M innodb_buffer_pool_size=0G query_cache_size=64M wait_timeout=120 max_allowed_packet=1G log_warnings=1 ``` The setting `innodb_buffer_pool_size` was once again set to 0G and causing the full install to fail on me as mariadb had errors running properly while the script was finishing up. Is there some sort of logic when the `/etc/mysql/conf.d/vitalpbx.cnf` is copied over or why do you think there is a difference @miguel between the files with the RAM sizes of vms. Dont think this is a Vultr error considering the file is a vitalpbx one, the script doens’t log anything different during the process between vms but the file contents are certainly different between the two. ---
**Author:** ![sama](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/s/7993a0/32.png) [@sama](https://forums.vitalpbx.org/u/sama)\ **Post date:** [June 21, 2024, 12:48am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/16 "2024-06-21T00:48:28Z")
I installed VitalPBX v4 on a new server using 2 vCPU and 2GB RAM, and I’m experiencing the same issue: the innodb\_buffer\_pool\_size keeps changing to 0G, and it looks like every time I run `vitalpbx optimize-mariadb` it’s modifying the file. This issue is only on the latest version of VitalPBX. ---
**Author:** ![mo10](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/58f4c7/32.png) [@mo10](https://forums.vitalpbx.org/u/mo10)\ **Post date:** [June 21, 2024, 8:20am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/17 "2024-06-21T08:20:52Z")
Would be nice if this can be taken serious. Often I have the feeling it’s not. Missing replies or updates, for example. Not only here. ---
**Author:** ![GaryC](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/g/b5a626/32.png) [@GaryC](https://forums.vitalpbx.org/u/GaryC)\ **Post date:** [June 25, 2024, 2:56pm UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/18 "2024-06-25T14:56:22Z")
I have the same issue on what was a working system, if I run optimize-mariadb it changes the file and stops working. This system has the Fax license enabled and has 2GB ram. ---
**Author:** ![sama](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/s/7993a0/32.png) [@sama](https://forums.vitalpbx.org/u/sama)\ **Post date:** [June 25, 2024, 6:10pm UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/19 "2024-06-25T18:10:12Z")
Hello, Since 3 users are reporting the same issues, can you please take a look? if it is a VitalPBX issue Thank you ---
**Author:** ![mo10](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/m/58f4c7/32.png) [@mo10](https://forums.vitalpbx.org/u/mo10)\ **Post date:** [June 27, 2024, 12:31am UTC](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179/20 "2024-06-27T00:31:03Z")
Is it too much that we ask just for a little update @maynor @miguel on a hot topic like this? Just something like: “thank you for reporting, we are already looking into this. Will report here.” [Next page](https://forums.vitalpbx.org/t/mariadb-errors-after-installing-vital-v4/4179.md?page=2)