You are not logged in.

Announcement

Bonjour, avant de poster, merci de vérifier que vous avez respecté les pré-requis de l'installation et consultez notre documentation : http://docs.blue-mind.net !

Hi, before posting on the forum, please check that you followed installation prerequisites and get a look to our documentation space : http://docs.blue-mind.net

#1 2019-02-21 14:54:47

Tergnier
Member
Registered: 2019-01-11
Posts: 6

Erreur démarrage postgresql

Bonjour,

Suite à une erreur lors de l'ajout d'une pièce jointe sur un mail (error server), j'ai décidé de vérifier les logs et de redémarrer les services bm.
Mais problème, le service postgresql refuse de démarrer :

/etc/init.d/postgresql start
[....] Starting postgresql (via systemctl): postgresql.serviceJob for postgresql.service failed because a configured resource limit was exceeded. See "systemctl status postgresql.service" and "journalctl -xe" for details.
 failed!
 systemctl status postgresql.service
● postgresql.service - PostgreSQL Cluster 9.6-main
   Loaded: loaded (/etc/systemd/system/postgresql.service; enabled; vendor preset: enabled)
   Active: failed (Result: resources) since jeu. 2019-02-21 14:47:09 CET; 4min 9s ago
  Process: 16711 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 9.6-main start (code=exited, status=1/FAI

févr. 21 14:46:38 mail systemd[1]: Starting PostgreSQL Cluster 9.6-main...
févr. 21 14:47:09 mail postgresql@9.6-main[16711]: The PostgreSQL server failed to start. Please check the log output
févr. 21 14:47:09 mail systemd[1]: postgresql.service: PID file /var/run/postgresql/9.6-main.pid not readable (yet?)
févr. 21 14:47:09 mail systemd[1]: Failed to start PostgreSQL Cluster 9.6-main.
févr. 21 14:47:09 mail systemd[1]: postgresql.service: Unit entered failed state.
févr. 21 14:47:09 mail systemd[1]: postgresql.service: Failed with result 'resources'.

Avez-vous une idée ou une solution?

je vous en remercie par avance

une partie du log du core.log

2019-02-21 13:16:17,023 [vert.x-worker-thread-0] n.b.s.s.i.SystemConfiguration ERROR - error retrieving system configuration from database
java.lang.NullPointerException: null
	at net.bluemind.core.jdbc.JdbcAbstractStore.getConnection(JdbcAbstractStore.java:431)
	at net.bluemind.core.jdbc.JdbcAbstractStore.select(JdbcAbstractStore.java:71)
	at net.bluemind.core.jdbc.JdbcAbstractStore.unique(JdbcAbstractStore.java:143)
	at net.bluemind.system.persistance.SystemConfStore.get(SystemConfStore.java:49)
	at net.bluemind.system.service.internal.SystemConfiguration.getValues(SystemConfiguration.java:78)
	at net.bluemind.system.service.internal.InstallationService.getVersion(InstallationService.java:255)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.versionMismatch(JobSchedulerVerticle.java:93)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.isDisabled(JobSchedulerVerticle.java:80)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.executeJobs(JobSchedulerVerticle.java:66)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle$1.handle(JobSchedulerVerticle.java:60)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle$1.handle(JobSchedulerVerticle.java:1)
	at org.vertx.java.core.impl.DefaultVertx$InternalTimerHandler.run(DefaultVertx.java:432)
	at org.vertx.java.core.impl.DefaultContext$3.run(DefaultContext.java:175)
	at org.vertx.java.core.impl.DefaultContext$3.run(DefaultContext.java:175)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.lang.Thread.run(Thread.java:748)
2019-02-21 13:16:17,024 [vert.x-worker-thread-0] n.b.s.s.i.SystemConfiguration WARN - Trying loading 3.0 bminfo
2019-02-21 13:16:17,024 [vert.x-worker-thread-0] n.b.s.s.i.InstallationService INFO - error retrieving database version : Fail to fetch system configuration
net.bluemind.core.api.fault.ServerFault: Fail to fetch system configuration
	at net.bluemind.system.service.internal.SystemConfiguration.getValues(SystemConfiguration.java:91)
	at net.bluemind.system.service.internal.InstallationService.getVersion(InstallationService.java:255)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.versionMismatch(JobSchedulerVerticle.java:93)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.isDisabled(JobSchedulerVerticle.java:80)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.executeJobs(JobSchedulerVerticle.java:66)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle$1.handle(JobSchedulerVerticle.java:60)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle$1.handle(JobSchedulerVerticle.java:1)
	at org.vertx.java.core.impl.DefaultVertx$InternalTimerHandler.run(DefaultVertx.java:432)
	at org.vertx.java.core.impl.DefaultContext$3.run(DefaultContext.java:175)
	at org.vertx.java.core.impl.DefaultContext$3.run(DefaultContext.java:175)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException: null
	at net.bluemind.core.jdbc.JdbcAbstractStore.getConnection(JdbcAbstractStore.java:431)
	at net.bluemind.core.jdbc.JdbcAbstractStore.select(JdbcAbstractStore.java:71)
	at net.bluemind.core.jdbc.JdbcAbstractStore.select(JdbcAbstractStore.java:57)
	at net.bluemind.system.persistance.SystemConfStore.get30(SystemConfStore.java:64)
	at net.bluemind.system.service.internal.SystemConfiguration.getValues(SystemConfiguration.java:84)
	... 13 common frames omitted
2019-02-21 13:16:17,026 [vert.x-worker-thread-0] n.b.s.s.i.InstallationService INFO - error retrieving database version : null
java.lang.NullPointerException: null
	at net.bluemind.core.jdbc.JdbcAbstractStore.getConnection(JdbcAbstractStore.java:431)
	at net.bluemind.core.jdbc.JdbcAbstractStore.select(JdbcAbstractStore.java:71)
	at net.bluemind.core.jdbc.JdbcAbstractStore.select(JdbcAbstractStore.java:57)
	at net.bluemind.system.persistance.SchemaVersionStore.getComponentsVersion(SchemaVersionStore.java:81)
	at net.bluemind.system.service.internal.InstallationService.getComponentsVersion(InstallationService.java:274)
	at net.bluemind.system.service.internal.InstallationService.getVersion(InstallationService.java:261)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.versionMismatch(JobSchedulerVerticle.java:93)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.isDisabled(JobSchedulerVerticle.java:80)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle.executeJobs(JobSchedulerVerticle.java:66)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle$1.handle(JobSchedulerVerticle.java:60)
	at net.bluemind.scheduledjob.scheduler.impl.JobSchedulerVerticle$1.handle(JobSchedulerVerticle.java:1)
	at org.vertx.java.core.impl.DefaultVertx$InternalTimerHandler.run(DefaultVertx.java:432)
	at org.vertx.java.core.impl.DefaultContext$3.run(DefaultContext.java:175)
	at org.vertx.java.core.impl.DefaultContext$3.run(DefaultContext.java:175)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.lang.Thread.run(Thread.java:748)
2019-02-21 13:16:17,027 [vert.x-worker-thread-0] n.b.s.s.i.JobSchedulerVerticle INFO - No db version
2019-02-21 13:16:17,027 [vert.x-worker-thread-0] n.b.s.s.i.JobSchedulerVerticle WARN - core jobs are disabled
2019-02-21 13:16:17,454 [core-heartbeat-timer] n.b.s.s.StateContext INFO - Core state heartbeat : core.state.upgrade
2019-02-21 13:16:21,455 [core-heartbeat-timer] n.b.s.s.StateContext INFO - Core state heartbeat : core.state.upgrade
2019-02-21 13:16:23,454 [vert.x-eventloop-thread-5] n.b.c.s.Sessions INFO - Sessions STATS: size: 0, stats: CacheStats{hitCount=0, missCount=0, loadSuccessCount=0, loadExceptionCount=0, totalLoadTime=0, evictionCount=0}

Offline

#2 2019-02-21 17:14:57

Toony
BlueMind Team
From: Toulouse
Registered: 2012-03-29
Posts: 1,823
Website

Re: Erreur démarrage postgresql

Il faut vérifier ce qu'indique PG dans /var/log/postgresql/postgresql-9.6-main.log.
Avez-vous suffisamment d'espace libre dans /var ?

Offline

#3 2019-02-21 21:58:15

Tergnier
Member
Registered: 2019-01-11
Posts: 6

Re: Erreur démarrage postgresql

Bonjour Toony,

Heu effectivement plus de place dans /var.

2019-02-21 00:01:36 GMT [1224]: [1-1] ERROR:  could not access status of transaction 0
2019-02-21 00:01:36 GMT [1224]: [2-1] DETAIL:  Could not write to file "pg_subtrans/0028" at offset 65536: No space left on device.

Y a t-il une possibilité pour déplacer la sauvegarde /var/backups dans un autre emplacement?
Ou bien faut il étendre /var

Merci d'avance

Offline

#4 2019-02-22 09:59:18

Toony
BlueMind Team
From: Toulouse
Registered: 2012-03-29
Posts: 1,823
Website

Re: Erreur démarrage postgresql

Nous vous conseillons d'utiliser à minima une partition/un disque dédié et idéalement un espace déporté (NFS, iscsi...) pour l'espace de sauvegarde BlueMind /var/backups/bluemind.

Offline

#5 2019-02-22 11:26:32

Tergnier
Member
Registered: 2019-01-11
Posts: 6

Re: Erreur démarrage postgresql

Ok c'est noté, quelle est la procédure pour choisir l'emplacement de /var/backups/bluemind, je n'ai rien trouvé au niveau de l'administration

merci d'avance

Offline

#6 2019-02-22 11:48:36

Toony
BlueMind Team
From: Toulouse
Registered: 2012-03-29
Posts: 1,823
Website

Re: Erreur démarrage postgresql

Ce dossier n'est pas paramètrable, libre à vous d'y attacher une partition locale ou distance.
Ceci doit-être fait au niveau du système.

Offline

Board footer

Powered by FluxBB