Skip to content

Instantly share code, notes, and snippets.

@volkov
Created July 19, 2020 15:28
Show Gist options
  • Save volkov/ab0a33d026f4aa77f2720f1015efaf49 to your computer and use it in GitHub Desktop.
Save volkov/ab0a33d026f4aa77f2720f1015efaf49 to your computer and use it in GitHub Desktop.
3~2020-07-19 15:27:37.445 ERROR 1 --- [nio-8080-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.Uncategoriz
edSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into weather (location_id, timestamp, temperature, rain, updated, forecast) values (?, ?, ?, ?, ?, ?)]; SQL state [25006]; error code [0]; ERROR: cannot execute INSERT in a read-only tran
saction; nested exception is org.postgresql.util.PSQLException: ERROR: cannot execute INSERT in a read-only transaction] with root cause
org.postgresql.util.PSQLException: ERROR: cannot execute INSERT in a read-only transaction
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532) ~[postgresql-42.2.15-SNAPSHOT.jar!/:42.2.15-SNAPSHOT]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267) ~[postgresql-42.2.15-SNAPSHOT.jar!/:42.2.15-SNAPSHOT]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) ~[postgresql-42.2.15-SNAPSHOT.jar!/:42.2.15-SNAPSHOT]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) ~[postgresql-42.2.15-SNAPSHOT.jar!/:42.2.15-SNAPSHOT]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) ~[postgresql-42.2.15-SNAPSHOT.jar!/:42.2.15-SNAPSHOT]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153) ~[postgresql-42.2.15-SNAPSHOT.jar!/:42.2.15-SNAPSHOT]
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119) ~[postgresql-42.2.15-SNAPSHOT.jar!/:42.2.15-SNAPSHOT]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-3.4.5.jar!/:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar!/:na]
at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867) ~[spring-jdbc-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) ~[spring-jdbc-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:862) ~[spring-jdbc-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:883) ~[spring-jdbc-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:321) ~[spring-jdbc-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:326) ~[spring-jdbc-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at com.github.volkov.weather.WeatherRepository.save(WeatherRepository.kt:16) ~[classes!/:na]
at com.github.volkov.weather.WeatherRepository$$FastClassBySpringCGLIB$$31e984b3.invoke(<generated>) ~[classes!/:na]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at com.github.volkov.weather.WeatherRepository$$EnhancerBySpringCGLIB$$e7a0c6c6.save(<generated>) ~[classes!/:na]
at com.github.volkov.weather.WeatherService.save(WeatherService.kt:87) ~[classes!/:na]
at com.github.volkov.weather.WeatherApplication.putWeather(WeatherApplication.kt:39) ~[classes!/:na]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment