"cannot execute SELECT FOR UPDATE in a read-only transaction" error while logging in portal

Legacy Knowledge Base

Published Jun. 30, 2025

"cannot execute SELECT FOR UPDATE in a read-only transaction" error while logging in portal

Written By

Amit Tiwari

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

Issue

Below error observed in logs and UI(internal serve error) while logging in to the portal:

2022-11-22 10:41:23.108 ERROR[http-nio-8080-exec-16][JDBCExceptionReporter:234]ERROR: cannot execute SELECT FOR UPDATE in a read-only transaction 
                                  and 
https://***.**.**/web/****/login?p_p_id=com_liferay_login_web_portlet_LoginPortlet&p_p_lifecycle=1&p_p_state=maximized&p_p_mode=view&_com_liferay_login_web_portlet_LoginPortlet_javax.portlet.action=/login/login&_com_liferay_login_web_portlet_LoginPortlet_mvcRenderCommandName=/login/login

Environment

Liferay 7.4 DXP Update 1
Postgres DB

Resolution

This error might be caused because the PostgreSQL server is in recovery(read-only) or standby mode and in order to resolve the issue make sure to remove the PostgreSQL server from recovery mode.