InfluxDB 1.8.7 on Debian/Raspbian not starting (bug + fix)

In case your InfluxDB service stopped working after upgrading to 1.8.7, it is apparently a known problem:

The fix is trivial: set one script to executable, and restart the influxdb service:

chmod +x /usr/lib/influxdb/scripts/influxd-systemd-start.sh
systemctl restart influxdb.service
7 Likes

Thanks for solution, yesterday I was fighting with this and found it on github. I was able to set script to executable, but now got problems with saving data to influx. I see such error and I dont know what is happening. Did you have same behavior? Part from log is below:

2021-08-05 13:26:39.471 [ERROR] [org.influxdb.impl.BatchProcessor    ] - Batch could not be sent. Data will be lost
org.influxdb.InfluxDBException: [shard 189] open /var/lib/influxdb/data/openhab_db/autogen/189/fields.idx.1.tmp: permission denied
	at org.influxdb.InfluxDBException.buildExceptionFromErrorMessage(InfluxDBException.java:161) ~[bundleFile:?]
	at org.influxdb.InfluxDBException.buildExceptionForErrorState(InfluxDBException.java:173) ~[bundleFile:?]
	at org.influxdb.impl.InfluxDBImpl.execute(InfluxDBImpl.java:827) ~[bundleFile:?]
	at org.influxdb.impl.InfluxDBImpl.write(InfluxDBImpl.java:460) ~[bundleFile:?]
	at org.influxdb.impl.OneShotBatchWriter.write(OneShotBatchWriter.java:22) ~[bundleFile:?]
	at org.influxdb.impl.BatchProcessor.write(BatchProcessor.java:340) [bundleFile:?]
	at org.influxdb.impl.BatchProcessor$1.run(BatchProcessor.java:287) [bundleFile:?]
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:?]
	at java.util.concurrent.FutureTask.run(Unknown Source) [?:?]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]
	at java.lang.Thread.run(Unknown Source) [?:?]

Maybe your Influx data folders also have permission problems.

Have a look at the file permissions of /var/lib/influxdb/data/

openHABian will also apply this when you select option 14. Eventually one Influx restart is needed.

1 Like

I solved the problem with:
sudo chmod + x /usr/lib/influxdb/scripts/influxd-systemd-start.sh

and:
sudo systemctl restart influxdb.service

but 4 days after the problem starts again! i have to uninstall influxdb and reinstall it and it works…but how long does it take? Do you have any solutions ?

thanks in advance

please be more specific in the description of what is happening again.
The thread title and the intro of your post let make me think that the x bit is gone.
Question then would be why you need to install the software again.
I assume that you have a different problem may be permssion of a subdirectory in /var/lib/influxdb/data/. But that is just a guess as it is not mentioned explicitly.

The execute bit is gone

This thread if dedicated for 1.8.7 but I had similar kind of problem like yours after upgrade to 1.8.9
I couldn’t trace any root cause of that problem so my only solution was:

sudo apt-get install --reinstall influxdb

After that there were no problems with influx.

I had to do the same as you, see if the problem does not reappear

The problem that occurs is the inability to start influx, with the error “access denied to war”, while I had done nothing on the server, the last update via apt get upgrade dated back to there is 20 days, apart from that this server has been running for 2 years without problem under linux ubuntu, to solve this strange problem I had to reinstall influxdb without doing anything else, and I had to do it 2 times in a row week. This time I’m under 1.8.9 and we’ll see if it works this time.

Thanks for your help

Here one of the first the log:

[ERROR] [org.influxdb.impl.BatchProcessor    ] - Batch could not be sent. Data will be lost
retrofit.RetrofitError: Connexion refusée (Connection refused)
	at retrofit.RetrofitError.networkError(RetrofitError.java:27) ~[retrofit-1.9.0.jar:?]
	at retrofit.RestAdapter$RestHandler.invokeRequest(RestAdapter.java:395) ~[retrofit-1.9.0.jar:?]
	at retrofit.RestAdapter$RestHandler.invoke(RestAdapter.java:240) ~[retrofit-1.9.0.jar:?]
	at org.influxdb.impl.$Proxy260.writePoints(Unknown Source) ~[?:?]
	at org.influxdb.impl.InfluxDBImpl.write(InfluxDBImpl.java:151) ~[influxdb-java-2.2.jar:?]
	at org.influxdb.impl.BatchProcessor.write(BatchProcessor.java:171) [influxdb-java-2.2.jar:?]
	at org.influxdb.impl.BatchProcessor$1.run(BatchProcessor.java:144) [influxdb-java-2.2.jar:?]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_252]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_252]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_252]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_252]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_252]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_252]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252]
Caused by: java.net.ConnectException: Connexion refusée (Connection refused)
	at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_252]
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0_252]
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_252]
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_252]
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_252]
	at java.net.Socket.connect(Socket.java:607) ~[?:1.8.0_252]
	at com.squareup.okhttp.internal.Platform.connectSocket(Platform.java:100) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.internal.http.SocketConnector.connectRawSocket(SocketConnector.java:160) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.internal.http.SocketConnector.connectCleartext(SocketConnector.java:67) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.Connection.connect(Connection.java:152) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.Connection.connectAndSetOwner(Connection.java:185) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.OkHttpClient$1.connectAndSetOwner(OkHttpClient.java:128) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.internal.http.HttpEngine.nextConnection(HttpEngine.java:341) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.internal.http.HttpEngine.connect(HttpEngine.java:330) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.internal.http.HttpEngine.sendRequest(HttpEngine.java:248) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.Call.getResponse(Call.java:273) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.Call$ApplicationInterceptorChain.proceed(Call.java:230) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.Call.getResponseWithInterceptorChain(Call.java:201) ~[okhttp-2.4.0.jar:?]
	at com.squareup.okhttp.Call.execute(Call.java:81) ~[okhttp-2.4.0.jar:?]
	at retrofit.client.OkClient.execute(OkClient.java:53) ~[retrofit-1.9.0.jar:?]
	at retrofit.RestAdapter$RestHandler.invokeRequest(RestAdapter.java:326) ~[retrofit-1.9.0.jar:?]

In same time during this error all http reguest and post fail: when i reinstall influxdb all run fine