You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@texera.apache.org by Jae Yun Kim <ja...@uci.edu> on 2026/04/27 21:20:37 UTC
Unable to run TexeraWebApplication
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
Re: Unable to run TexeraWebApplication
Posted by Zuozhi Wang <zu...@gmail.com>.
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 <li...@apache.org> wrote:
> Try to reinstall the DB.
>
> On Mon, Apr 27, 2026 at 2:20 PM Jae Yun Kim <ja...@uci.edu> 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
> >
>
Re: Unable to run TexeraWebApplication
Posted by Xinyuan Lin <li...@apache.org>.
Try to reinstall the DB.
On Mon, Apr 27, 2026 at 2:20 PM Jae Yun Kim <ja...@uci.edu> 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
>