You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have been working with integrating Skunk with CockroachDB. I have discussed about this integration in a blog post here.
Everything is working fine with CockroachDB integration, But I have got one issue with UNLISTEN on Postgres. Seems CockroachDB does not supports these commands yet. Due to this reason when running queries it gives following error at the end(the queries are successful, but end it raised the error for UNLISTEN * command).
Exception in thread "main" skunk.exception.PostgresErrorException:
🔥
🔥 Postgres ERROR 42601 raised in Error (lexer.go:246)
🔥
🔥 Problem: At or near "unlisten": syntax error.
🔥 Detail: source SQL:
🔥 UNLISTEN *
🔥 ^
🔥
🔥 The statement under consideration was defined
🔥 at «skunk internal»:0
🔥
🔥 UNLISTEN *
🔥
🔥 If this is an error you wish to trap and handle in your application, you can do
🔥 so with a SqlState extractor. For example:
🔥
🔥 doSomething.recoverWith { case SqlState.SyntaxError(ex) => ...}
🔥
skunk.exception.PostgresErrorException: At or near "unlisten": syntax error.
at skunk.net.protocol.Query$$anon$1$$anonfun$apply$2.$anonfun$applyOrElse$12(Query.scala:179)
at map @ skunk.net.protocol.Query$$anon$1$$anonfun$apply$2.$anonfun$applyOrElse$12(Query.scala:179)
at modify @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:91)
at flatten$extension @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:95)
at flatMap @ skunk.net.MessageSocket$$anon$1.pump$1(MessageSocket.scala:80)
at modify @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:91)
at flatten$extension @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:95)
at flatMap @ skunk.net.MessageSocket$$anon$1.pump$1(MessageSocket.scala:80)
at modify @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:91)
at flatten$extension @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:95)
at flatMap @ skunk.net.MessageSocket$$anon$1.pump$1(MessageSocket.scala:80)
at modify @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:91)
at flatten$extension @ skunk.util.Pool$.$anonfun$of$2(Pool.scala:95)
Process finished with exit code 1
Do you have any suggestion or workaround for this? As the error suggested, manually handling it with .recoverWith would be a workaround?
Thank you very much.
The text was updated successfully, but these errors were encountered:
I have been working with integrating
Skunk
withCockroachDB
. I have discussed about this integration in a blog post here.Everything is working fine with
CockroachDB
integration, But I have got one issue withUNLISTEN
onPostgres
. SeemsCockroachDB
does not supports these commands yet. Due to this reason when running queries it gives following error at the end(the queries are successful, but end it raised the error forUNLISTEN *
command).Do you have any suggestion or workaround for this? As the error suggested, manually handling it with
.recoverWith
would be a workaround?Thank you very much.
The text was updated successfully, but these errors were encountered: