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 >
