Hi Jaeyun, this seems to be a postgres installation issue with the pgroonga plugin. Please make sure the pgroonga plugin is installed correctly. Please follow our setup doc, and make sure your portsgres has the correct version (your version might be too low or too high) and check if pgroonga is installed correctly
The relevant error is: not access file "$libdir/pgroonga": No such file or directory at org.jooq_3.16.23.POSTGRES.debug(Unknown Source) Zuozhi On Mon, Apr 27, 2026 at 8:37 PM Xinyuan Lin <[email protected]> wrote: > Try to reinstall the DB. > > On Mon, Apr 27, 2026 at 2:20 PM Jae Yun Kim <[email protected]> wrote: > > > Good afternoon everyone. > > > > I was trying to run TexeraWebApplication and I keep seeing this error > > message. I am sending this email to ask if anyone has encountered this > > issue before or knows how to solve this issue. > > > > org.jooq.exception.DataAccessException: SQL [select > > "texera_db"."user"."uid", "texera_db"."user"."name", > > "texera_db"."user"."email", "texera_db"."user"."password", > > "texera_db"."user"."google_id", "texera_db"."user"."google_avatar", > > "texera_db"."user"."role", "texera_db"."user"."comment", > > "texera_db"."user"."account_creation_time", > > "texera_db"."user"."affiliation", "texera_db"."user"."joining_reason" > from > > "texera_db"."user" where "texera_db"."user"."name" in (?)]; ERROR: could > > not access file "$libdir/pgroonga": No such file or directory > > at org.jooq_3.16.23.POSTGRES.debug(Unknown Source) > > at org.jooq.impl.Tools.translate(Tools.java:3130) > > at > > > > > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:727) > > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:343) > > at > > org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:295) > > at > > > > > org.jooq.impl.AbstractResultQuery.fetchLazyNonAutoClosing(AbstractResultQuery.java:316) > > at org.jooq.impl.SelectImpl.fetchLazyNonAutoClosing(SelectImpl.java:2867) > > at org.jooq.impl.ResultQueryTrait.collect(ResultQueryTrait.java:357) > > at org.jooq.impl.ResultQueryTrait.fetch(ResultQueryTrait.java:1462) > > at org.jooq.impl.DAOImpl.fetch(DAOImpl.java:364) > > at org.jooq.impl.DAOImpl.fetch(DAOImpl.java:356) > > at > > > > > org.apache.texera.dao.jooq.generated.tables.daos.UserDao.fetchByName(UserDao.java:84) > > at > > > > > org.apache.texera.web.resource.auth.AuthResource$.createAdminUser(AuthResource.scala:74) > > at > > > > > org.apache.texera.web.TexeraWebApplication.run(TexeraWebApplication.scala:164) > > at > > > > > org.apache.texera.web.TexeraWebApplication.run(TexeraWebApplication.scala:83) > > at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) > > at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:87) > > at io.dropwizard.cli.Cli.run(Cli.java:78) > > at io.dropwizard.Application.run(Application.java:93) > > at > > > > > org.apache.texera.web.TexeraWebApplication$.main(TexeraWebApplication.scala:77) > > at > > > org.apache.texera.web.TexeraWebApplication.main(TexeraWebApplication.scala) > > Caused by: org.postgresql.util.PSQLException: ERROR: could not access > file > > "$libdir/pgroonga": No such file or directory > > at > > > > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733) > > at > > > > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420) > > at > > > > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372) > > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517) > > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434) > > at > > > > > org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194) > > at > > > > > org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180) > > at > > > > > org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:219) > > at > > org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4408) > > at > org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:230) > > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:329) > > ... 17 more > > > > Best, > > Jaeyun Kim > > >
