openmediavault-postgresql error

pr_bond · 27. Februar 2015

Hi

I would test openmediavault-postgresql on a fresh install OMV on VM and i take this is error :

Code

Erreur #4000: exception 'OMVException' with message 
'Failed to execute command 'export LANG=C; invoke-rc.d 'postgresql' start 2>&1': Starting PostgreSQL 9.1 database 
server: mainThe PostgreSQL server failed to start. Please check the log output: 2015-02-25 16:55:28 CET 
FATAL: could not create shared memory segment: Invalid argument 2015-02-25 16:55:28 CET 
DETAIL: Failed system call was shmget(key=5432001, size=41205760, 03600). 2015-02-25 16:55:28 CET 
HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. 
You can either reduce the request size or reconfigure the kernel with larger SHMMAX.
To reduce the request size (currently 41205760 bytes), reduce PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or max_connections.
If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.
The PostgreSQL documentation contains more information about shared memory configuration. ... failed! failed!
invoke-rc.d: initscript postgresql, action "start" failed.' in /usr/share/php/openmediavault/initscript.inc:176
Stack trace:
#0 /usr/share/php/openmediavault/initscript.inc(141): OMVSysVInitScript->invoke('start')
#1 /usr/share/php/openmediavault/initscript.inc(61): OMVSysVInitScript->start()
#2 /usr/share/openmediavault/engined/module/postgresql.inc(117): OMVSysVInitScript->exec()
#3 /usr/share/openmediavault/engined/rpc/config.inc(206): OMVModulePostgreSQL->startService()
#4 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array)
#5 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#6 /usr/share/php/openmediavault/rpcservice.inc(158): OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
#7 /usr/share/openmediavault/engined/rpc/config.inc(224): OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
#8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array)
#9 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
#10 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
#11 /usr/sbin/omv-engined(500): OMVRpc::exec('Config', 'applyChangesBg', Array, Array, 1)
#12 {main}

Alles anzeigen

After googling, i found : http://leopard.in.ua/2013/09/0…l-sessting-shared-memory/

Postgresql need to have 2 options in sysctl.conf to work well.

When i add see below into sysctl.conf postgresql star and no have error.

Code

kernel.shmmax = 1055092736
kernel.shmall = 257591

The patch to add into sysctl.conf

Diff

--- openmediavault-postgresql/debian/postinst   2015-02-27 11:46:14.934861308 +0100
+++ postinst    2015-02-27 11:43:36.042865472 +0100
@@ -21,6 +21,16 @@
             omv_config_add_element "${SERVICE_XPATH}" "enable_management_site" "0"
             omv_config_add_element "${SERVICE_XPATH}" "show_tab" "0"
         fi
+        
+        page_size=`getconf PAGE_SIZE`
+        phys_pages=`getconf _PHYS_PAGES`
+        shmall=`expr $phys_pages / 2`
+        shmmax=`expr $shmall \* $page_size`
+        
+        echo kernel.shmmax = $shmmax >> /etc/sysctl.conf
+        echo kernel.shmall = $shmall >> /etc/sysctl.conf
+
+        sysctl -p
 
         # Activate package triggers. These triggers are only set during the
         # package installation.

Alles anzeigen

Anybody can confirm this mistake ?

HK-47 · 27. Februar 2015

I can't confirm the "mistake" but I can give you advise on a better practice. Put the content you put in /etc/sysctl.conf in a file in /etc/sysctl.d, for example /etc/sysctl.d/postgresql.conf.

ryecoaaron · 27. Februar 2015

I've been doing some testing for two weeks without those parameters. You would think that if you needed it, the debian package would install it?? Are you locating the database(s) on zfs?

Good idea HK

pr_bond · 27. Februar 2015

I test to change locating database on zfs and ext4 and delete sysctl.conf's add and i have the same error :

Code

Erreur
 #4000:
exception 'OMVException' with message 'Failed to execute command 'export
 LANG=C; invoke-rc.d 'postgresql' start 2>&1': Starting 
PostgreSQL 9.1 database server: mainThe PostgreSQL server failed to 
start. Please check the log output: 2015-02-27 15:19:19 CET FATAL: could
 not create shared memory segment: Invalid argument 2015-02-27 15:19:19 
CET DETAIL: Failed system call was shmget(key=5432001, size=41205760, 
03600). 2015-02-27 15:19:19 CET HINT: This error usually means that 
PostgreSQL's request for a shared memory segment exceeded your kernel's 
SHMMAX parameter. You can either reduce the request size or reconfigure 
the kernel with larger SHMMAX. To reduce the request size (currently 
41205760 bytes), reduce PostgreSQL's shared memory usage, perhaps by 
reducing shared_buffers or max_connections. If the request size is 
already small, it's possible that it is less than your kernel's SHMMIN 
parameter, in which case raising the request size or reconfiguring 
SHMMIN is called for. The PostgreSQL documentation contains more 
information about shared memory configuration. ... failed!
 failed!
invoke-rc.d: initscript postgresql, action "start" failed.' in 
/usr/share/php/openmediavault/initscript.inc:176
Stack trace:
#0 /usr/share/php/openmediavault/initscript.inc(141): 
OMVSysVInitScript->invoke('start')
#1 /usr/share/php/openmediavault/initscript.inc(61): 
OMVSysVInitScript->start()
#2 /usr/share/openmediavault/engined/module/postgresql.inc(117): 
OMVSysVInitScript->exec()
#3 /usr/share/openmediavault/engined/rpc/config.inc(206): 
OMVModulePostgreSQL->startService()
#4 [internal function]: OMVRpcServiceConfig->applyChanges(Array, 
Array)
#5 /usr/share/php/openmediavault/rpcservice.inc(125): 
call_user_func_array(Array, Array)
#6 /usr/share/php/openmediavault/rpcservice.inc(158): 
OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
#7 /usr/share/openmediavault/engined/rpc/config.inc(224): 
OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
#8 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, 
Array)
#9 /usr/share/php/openmediavault/rpcservice.inc(125): 
call_user_func_array(Array, Array)
#10 /usr/share/php/openmediavault/rpc.inc(79): 
OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
#11 /usr/sbin/omv-engined(500): OMVRpc::exec('Config', 'applyChangesBg',
 Array, Array, 1)
#12 {main}

Alles anzeigen

I see in /etc/sysctl.d/30-postgresql-shm.conf :

Code

# Shared memory settings for PostgreSQL


# Note that if another program uses shared memory as well, you will have to
# coordinate the size settings between the two.


# Maximum size of shared memory segment in bytes
#kernel.shmmax = 33554432


# Maximum total size of shared memory in pages (normally 4096 bytes)
#kernel.shmall = 2097152

Alles anzeigen

I have increase size ram of VM to 2Go (before 512Mo) and i see a wrong couple of kernel.shmmax / kernel.shmall should may crash postgresql.

Now my /etc/sysctl.d/30-postgresql-shm.conf

Code

# Shared memory settings for PostgreSQL


# Note that if another program uses shared memory as well, you will have to
# coordinate the size settings between the two.


# Maximum size of shared memory segment in bytes
kernel.shmmax = 1055297536


# Maximum total size of shared memory in pages (normally 4096 bytes)
kernel.shmall = 257641

Alles anzeigen

Code

sysctl -p /etc/sysctl.d/30-postgresql-shm.conf
kernel.shmmax = 1055297536
kernel.shmall = 257641


 service postgresql start
Starting PostgreSQL 9.1 database server: main.

Postgresql works well now.

I am alone to have this problem ???

ryecoaaron · 27. Februar 2015

I can't duplicate it. I have it running on my dev system and I never ran into the problem during plugin testing on my VMs. Not sure why you are having the issue.

openmediavault-postgresql error

Jetzt mitmachen!

Tags