Open mogman1 opened 4 years ago
Over the weekend, I tried updating the jdbc postgres driver from 42.2.5
to 42.2.13
(I figured out what I was doing wrong). I still run into error after a while (see beginning of stack trace below), but at least this time it points to a line that makes sense (see https://github.com/pgjdbc/pgjdbc/blob/REL42.2.13/pgjdbc/src/main/java/org/postgresql/jdbc/PgStatement.java#L459)
[ERROR] [2020-06-05 20:23:04 -0600] [Failable] Java::JavaLang::NullPointerException:
[ERROR] [2020-06-05 20:23:04 -0600] [Failable] org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:459)
org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)
org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:1218)
arjdbc.jdbc.RubyJdbcConnection$10.call(RubyJdbcConnection.java:927)
arjdbc.jdbc.RubyJdbcConnection$10.call(RubyJdbcConnection.java:916)
arjdbc.jdbc.RubyJdbcConnection.withConnection(RubyJdbcConnection.java:3514)
arjdbc.jdbc.RubyJdbcConnection.withConnection(RubyJdbcConnection.java:3480)
arjdbc.jdbc.RubyJdbcConnection.execute_insert_pk(RubyJdbcConnection.java:916)
arjdbc.jdbc.RubyJdbcConnection$INVOKER$i$execute_insert_pk.call(RubyJdbcConnection$INVOKER$i$execute_insert_pk.gen)
org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:201)
org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:326)
...
We're running into an issue at the interface between postgresql-jdbc and arjdbc. We're running JRuby (versions 9.2.6.0, 9.2.7.0, 9.2.9.0) and Rails 5.2 with arjdbc 52.6. Frustratingly the error (stack trace below) shows up only rarely and only under load, we're still trying to figure out how to produce it more reliably. What's also odd is I can't get the line numbers being given in the stack dump for postgresql-jdbc to line up (see https://github.com/pgjdbc/pgjdbc/blob/REL42.2.5/pgjdbc/src/main/java/org/postgresql/jdbc/PgStatement.java#L457, which is just a
}
).I made a stab at updating postgres jdbc to 42.2.13, since 42.2.5 is over a year old, but I keep running into: