# Read timed out when using system.alarm.queryJournal **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [April 26, 2022, 11:12am UTC](https://forum.inductiveautomation.com/t/read-timed-out-when-using-system-alarm-queryjournal/58861 "2022-04-26T11:12:55Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![liam1](https://avatars.discourse-cdn.com/v4/letter/l/e68b1a/32.png) [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Post date:** [April 26, 2022, 11:12am UTC](https://forum.inductiveautomation.com/t/read-timed-out-when-using-system-alarm-queryjournal/58861/1 "2022-04-26T11:12:55Z")
Been having issues lately when trying to query the alarm journal. When running this is the script console , it takes a while and causes my designer to disconnect from the gateway. The code I’m using in the script console ```auto end = system.date.now() start = system.date.addHours(end, -1) source='prov:default:/tag:teleBridgeOPCServer/WASTE/BLAAUWBERG/STATIONS/11TH AVENUE/AlarmTest' ret=system.alarm.queryJournal(journalName="Journal",source=source,startDate=start,endDate=end) print ret ``` Error log ```auto Java Traceback: Traceback (most recent call last): File "", line 4, in at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:351) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:543) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:283) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:278) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:945) at com.inductiveautomation.ignition.client.script.ClientAlarmUtilities.queryJournalImpl(ClientAlarmUtilities.java:47) at com.inductiveautomation.ignition.common.script.builtin.AbstractAlarmUtilities.queryJournal(AbstractAlarmUtilities.java:100) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) com.inductiveautomation.ignition.client.gateway_interface.GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out at org.python.core.Py.JavaError(Py.java:547) at com.inductiveautomation.ignition.common.script.builtin.AbstractAlarmUtilities.queryJournal(AbstractAlarmUtilities.java:102) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.python.core.PyReflectedFunction. __call__ (PyReflectedFunction.java:190) at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction. __call__ (ScriptManager.java:541) at org.python.core.PyObject. __call__ (PyObject.java:400) at org.python.pycode._pyx34.f$0(:5) at org.python.pycode._pyx34.call_function() at org.python.core.PyTableCode.call(PyTableCode.java:173) at org.python.core.PyCode.call(PyCode.java:18) at org.python.core.Py.runCode(Py.java:1687) at org.python.core.Py.exec(Py.java:1731) at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:277) at org.python.util.InteractiveInterpreter.runcode(InteractiveInterpreter.java:130) at com.inductiveautomation.ignition.designer.gui.tools.jythonconsole.JythonConsole$ConsoleWorker.doInBackground(JythonConsole.java:611) at com.inductiveautomation.ignition.designer.gui.tools.jythonconsole.JythonConsole$ConsoleWorker.doInBackground(JythonConsole.java:599) at java.desktop/javax.swing.SwingWorker$1.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.desktop/javax.swing.SwingWorker.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:351) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:543) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:283) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:278) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:945) at com.inductiveautomation.ignition.client.script.ClientAlarmUtilities.queryJournalImpl(ClientAlarmUtilities.java:47) at com.inductiveautomation.ignition.common.script.builtin.AbstractAlarmUtilities.queryJournal(AbstractAlarmUtilities.java:100) ... 23 more Caused by: java.net.SocketTimeoutException: Read timed out at java.base/java.net.SocketInputStream.socketRead0(Native Method) at java.base/java.net.SocketInputStream.socketRead(Unknown Source) at java.base/java.net.SocketInputStream.read(Unknown Source) at java.base/java.net.SocketInputStream.read(Unknown Source) at java.base/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source) at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source) at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source) at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source) at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source) at java.base/java.io.BufferedInputStream.fill(Unknown Source) at java.base/java.io.BufferedInputStream.read1(Unknown Source) at java.base/java.io.BufferedInputStream.read(Unknown Source) at java.base/sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source) at java.base/sun.net.www.http.HttpClient.parseHTTP(Unknown Source) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source) at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:437) ... 28 more Traceback (most recent call last): File "", line 4, in at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:351) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:543) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:283) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:278) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:945) at com.inductiveautomation.ignition.client.script.ClientAlarmUtilities.queryJournalImpl(ClientAlarmUtilities.java:47) at com.inductiveautomation.ignition.common.script.builtin.AbstractAlarmUtilities.queryJournal(AbstractAlarmUtilities.java:100) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) com.inductiveautomation.ignition.client.gateway_interface.GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out ``` ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 26, 2022, 12:45pm UTC](https://forum.inductiveautomation.com/t/read-timed-out-when-using-system-alarm-queryjournal/58861/2 "2022-04-26T12:45:02Z")
> [@liam1](#): > > `Read timed out` The query is just taking too long. Go make sure the journal's tables have appropriate indices. ---
**Author:** ![liam1](https://avatars.discourse-cdn.com/v4/letter/l/e68b1a/32.png) [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Post date:** [May 3, 2022, 8:27am UTC](https://forum.inductiveautomation.com/t/read-timed-out-when-using-system-alarm-queryjournal/58861/3 "2022-05-03T08:27:20Z")
So it seems that the alarm database was 11 GB’s which caused a read timeout.After clearing the DB this resolved the issue ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 3, 2022, 10:02am UTC](https://forum.inductiveautomation.com/t/read-timed-out-when-using-system-alarm-queryjournal/58861/4 "2022-05-03T10:02:35Z")
The size of the DB by itself won’t create timeouts if the DB tables have _ **proper indexing** _. I wouldn’t have thrown away history like that. You never know when you might need it. Talk to your DB admins about indexing. ---
**Author:** ![liam1](https://avatars.discourse-cdn.com/v4/letter/l/e68b1a/32.png) [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Post date:** [May 3, 2022, 10:30am UTC](https://forum.inductiveautomation.com/t/read-timed-out-when-using-system-alarm-queryjournal/58861/5 "2022-05-03T10:30:04Z")
The db is on our test and development gateway so the data is not critical.When you say proper indexing,what do you mean by that? When ignition creates the alarm tables in the database is it not correctly setup already? Is there extra configuration that needs to be done to the db or the tables? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 3, 2022, 10:31am UTC](https://forum.inductiveautomation.com/t/read-timed-out-when-using-system-alarm-queryjournal/58861/6 "2022-05-03T10:31:40Z")
> [@liam1](#): > > is it not correctly setup already? Not that I recall, no. At least index the main journal by `t_stamp`, and the details file by `uuid`.