PG::UndefinedObject: ERROR: operator class “pgroonga_text_term_search_ops“ does not exist for acces

最新推荐文章于 2023-03-16 13:19:29 发布
最新推荐文章于 2023-03-16 13:19:29 发布
阅读量617 收藏
点赞数
分类专栏： Linux 文章标签： ruby on rails 后端 postgresql ubuntu linux
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/keineahnung2345/article/details/113613355
版权

PG::UndefinedObject: ERROR: operator class "pgroonga_text_term_search_ops" does not exist for access method "pgroonga"

前言

筆者的環境如下：

  • Ubuntu 20.04
  • ruby 2.7.0p0 (2019-12-25 revision 647ee6f091) [x86_64-linux]
  • Rails 5.2.4.2
  • Redmine 4.1.1
  • 為Redmine安裝了full_text_search插件

這是筆者在redmine根目錄裡執行：

RAILS_ENV=production rake db:reset DISABLE_DATABASE_ENVIRONMENT_CHECK=1 --trace

時所出現的錯。

錯誤訊息

錯誤訊息如下(重點已用螢光標註)：

Caused by:
PG::UndefinedObject: ERROR: operator class “pgroonga_text_term_search_ops” does not exist for access method “pgroonga”
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in async_exec' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:inblock (2 levels) in execute’
/usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies/interlock.rb:48:in block in permit_concurrent_loads' /usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/concurrency/share_lock.rb:187:inyield_shares’
/usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_loads' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:inblock in execute’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract_adapter.rb:581:in block (2 levels) in log' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract_adapter.rb:580:insynchronize’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract_adapter.rb:580:in block in log' /usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/notifications/instrumenter.rb:23:ininstrument’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract_adapter.rb:571:in log' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:inexecute’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/postgresql/schema_statements.rb:466:in add_index' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:315:inblock in create_table’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:314:in each' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:314:increate_table’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/migration.rb:871:in block in method_missing' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/migration.rb:840:inblock in say_with_time’
/usr/share/rvm/rubies/ruby-2.7.0/lib/ruby/2.7.0/benchmark.rb:293:in measure' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/migration.rb:840:insay_with_time’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/migration.rb:860:in method_missing' /home/redmine/redmine/db/schema.rb:405:inblock in <top (required)>’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/schema.rb:50:in instance_eval' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/schema.rb:50:indefine’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/schema.rb:46:in define' /home/redmine/redmine/db/schema.rb:13:in<top (required)>’
/usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:285:in load' /usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:285:inblock in load’
/usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:257:in load_dependency' /usr/share/rvm/gems/ruby-2.7.0/gems/activesupport-5.2.4.2/lib/active_support/dependencies.rb:285:inload’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/tasks/database_tasks.rb:245:in load_schema' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/tasks/database_tasks.rb:266:inblock in load_schema_current’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/tasks/database_tasks.rb:316:in block in each_current_configuration' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/tasks/database_tasks.rb:313:ineach’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/tasks/database_tasks.rb:313:in each_current_configuration' /usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/tasks/database_tasks.rb:265:inload_schema_current’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/railties/databases.rake:258:in block (3 levels) in <top (required)>' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:inblock in execute’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in each' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:inexecute’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:219:in block in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:insynchronize’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:188:ininvoke’
/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-5.2.4.2/lib/active_record/railties/databases.rake:262:in block (3 levels) in <top (required)>' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:inblock in execute’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:in each' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:281:inexecute’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:219:in block in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:insynchronize’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:243:inblock in invoke_prerequisites’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:241:in each' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:241:ininvoke_prerequisites’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:218:in block in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:insynchronize’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:243:inblock in invoke_prerequisites’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:241:in each' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:241:ininvoke_prerequisites’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:218:in block in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:insynchronize’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:199:in invoke_with_call_chain' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/task.rb:188:ininvoke’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:160:in invoke_task' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:inblock (2 levels) in top_level’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:in each' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:116:inblock in top_level’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:125:in run_with_threads' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:110:intop_level’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:83:in block in run' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:186:instandard_exception_handling’
/usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/lib/rake/application.rb:80:in run' /usr/share/rvm/gems/ruby-2.7.0/gems/rake-13.0.3/exe/rake:27:in<top (required)>’
/usr/share/rvm/gems/ruby-2.7.0/bin/rake:23:in load' /usr/share/rvm/gems/ruby-2.7.0/bin/rake:23:in<main>’
/usr/share/rvm/gems/ruby-2.7.0/bin/ruby_executable_hooks:24:in eval' /usr/share/rvm/gems/ruby-2.7.0/bin/ruby_executable_hooks:24:in<main>’
Tasks: TOP => db:schema:load

從錯誤訊息的第一行可以看出是跟pgroonga_text_term_search_ops有關。在<redmine_home>裡尋找線索:

grep pgroonga_text_term_search_ops -rn .

./db/schema.rb:410: t.index [“source”, “destination”], name: “fts_query_expansions_index_pgroonga”, opclass: :pgroonga_text_term_search_ops, using: :pgroonga
./plugins/full_text_search/db/migrate/20190807085000_create_fts_query_expansions.rb:24: “source pgroonga_text_term_search_ops_v2”,
./plugins/full_text_search/db/migrate/20190807085000_create_fts_query_expansions.rb:25: “destination pgroonga_text_term_search_ops_v2”,

可以看到，在plugins/full_text_search/db/migrate/20190807085000_create_fts_query_expansions.rb裡，operator class的名字是叫pgroonga_text_term_search_ops_v2，但是在db/schema.rb裡面，卻把它的名字誤植為pgroonga_text_term_search_ops。

解決方式

一個權宜之計是手動編輯db/schema.rb，把裡面的pgroonga_text_term_search_ops加上_v2即可。

改完之後就能成功執行db:reset的指令了!

發生原因

rails的Github上有人提了issue並提出了他的解決方式：

首先要找到redmine所用的rails版本，筆者的是5.2.4.2，這點可以從上面的錯誤訊息中看出來。

然後修改：/usr/share/rvm/gems/ruby-2.7.0/gems/activerecord-<rails_version>/lib/active_record/connection_adapters/postgresql/schema_statements.rb這個檔案:

把：

expressions.scan(/(?<column>\w+)"?\s?(?<opclass>\w+_ops)?\s?(?<desc>DESC)?\s?(?<nulls>NULLS (?:FIRST|LAST))?/).each do |column, opclass, desc, nulls|

改成：

expressions.scan(/(?<column>\w+)"?\s?(?<opclass>\w+_ops(_\w+)?)?\s?(?<desc>DESC)?\s?(?<nulls>NULLS (?:FIRST|LAST))?/).each do |column, opclass, desc, nulls|

這樣rails在生成db/schema.rb時才能找到正確的operator class名稱。看起來這才是治本的方法。

參考連結

Rails 5 how to clear or delete production postgres database

AR PG opclass schema dumper regex extracts wrong opclass when opclass does not end with _ops

keineahnung2345
关注
专栏目录
【异常】PGSQL提示 ERROR: operator does not exist: character varying = integer
本本本添哥
11-29 3516
这是数据库和实体类里面字段类型不一致造成的报错！仔细检查一下字段类型！1、数据库的类型—varchar类型。3、实体中的类型—String类型。2、枚举值的类型—int类型。
【异常】PSQLException: ERROR: operator does not exist: timestamp without time zone ＞= character varying
最新发布
本本本添哥
03-19 2187
今天在项目中碰见了一个关于pgsql的错误“Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: timestamp without time zone >= character varying”，项目是springmvc+mybatis框架，数据库是postgresql，出错的地方在一个时间查询上，前端页面传递了字符串，直接拿来sql中查询就报错了。
postgresql 创建gin索引
03-21 1375
1.创建gin类型的索引 postgresql 创建gin索引遇到的问题：1.ERROR: operator class "gin_trgm_ops" does not exist for access method "gin" 解决方案：先执行 CREATE EXTENSION pg_trgm; https://www.cnblogs.com/goingforward/p/...
2021-04-08
maker_sss的博客
04-08 328
postgresql ：ERROR: operator class “gin_trgm_ops” does not exist for access method “gin” 1.先使用超级管理员账户登录 su - postgres psql 2.切换数据库：即使用超级管理员账户连接DB_NAME \c <DB_NAME> 3.执行： CREATE EXTENSION pg_trgm; ...
gitlab update 升级测试
潇洒devops
02-01 794
直接按照官网的升级路线，13.12.15 -> latest 14.0.Z -> latest 14.1.Z -> latest 14.Y.Z 会遇到如下。如下报错在14.1.+ 版本解决。
PostgreSQL ERROR: operator does not exist: bigint = character varying
丘处机的专栏
03-16 1万+
类型时，PostgreSQL将使用这个cast来执行转换。如果没有定义该cast，PostgreSQL将无法执行该转换并抛出类似于“operator does not exist”这样的错误。是用于创建新的强制类型转换的SQL命令。该命令指定一个源类型和目标类型，并指定将源类型转换为目标类型时要使用的函数。在此情况下，创建了一个将。类型的列进行了比较，而 PostgreSQL 并没有提供这两个类型之间的默认比较操作符。参数表示当需要自动转换时，该cast将被隐式地使用。类型的cast，其中。
postgresql数据库使用遇到的问题及解决方案
Master_Shifu_的博客
08-21 1万+
postgresql数据库使用遇到的问题及解决方案该文章主要内容1.column is of type timestamp without time zone but expression is of type character varying解决2.关于jdbc向mysql和postgresql批量插入大量数据时候的优化！3.PostgreSQL数据库使用函数生成uuid4.postgresql 如何设置主键defaultValue为uuid5.mybatis中取自增列的值6.创建表内容之--java数
error C2338: THE_BRACKET_OPERATOR_IS_ONLY_FOR_VECTORS__USE_THE_PARENTHESIS_OPERATOR_INSTEAD
何似莫相逢
07-18 8505
error C2338: THE_BRACKET_OPERATOR_IS_ONLY_FOR_VECTORS__USE_THE_PARENTHESIS_OPERATOR_INSTEAD
【R语言报错解决】—存在非数值型变量，Error in c_max * c_min : non-numeric argument to binary operator，如何在数据导入后转为数值型变量？
公卫小何&R语言
09-06 3万+
目录一、问题回顾corrplot及pheatmap均无法绘制热图并报错二、分析原因报错显示出现了非数值型变量三、解决方案——将整个矩阵转化为数值型变量注意：不能直接用as.numeric,会把矩阵全部转成一列向量apply命令解决结果展示作者介绍 一、问题回顾 corrplot及pheatmap均无法绘制热图并报错 corrplot(test,is.corr=FALSE) Error in c_...
No such operator image::read_file问题解决
iwill323的博客
09-28 2416
No such operator image::read_file问题解决
pgroonga:PGroonga是PostgreSQL扩展，使用Groonga作为索引。 PGroonga使PostgreSQL快速成为所有语言的全文搜索平台！
04-05
PGroonga PGroonga使PostgreSQL快速成为所有语言的全文搜索平台！ 网站 访问网站了解更多详情： 执照 PGroonga是根据发行的，该类似于BSD许可证和MIT许可证。 有关版权持有人等详细信息，请参见文件。 捆绑的软件在不同的许可下发布。 以下是捆绑的软件和许可证信息： BSD许可证 版权： Copyright (c) 2012-2019, Yann Collet 详细信息： （仅适用于Windows软件包） LGPL 2.1 版权： Copyright(C) 2009-2019 Brazil Copyright(C) 2018-2019 Sutou Kouhei <kou> 详细信息：
函数明明存在应用却报错不存在 function xxx does not exist
热门推荐
leandzgc的专栏
11-12 8万+
错误信息：function xxx does not exist. No function matches the given name and argument types. You might need to add explicit type casts 函数找不到可能的原因 1、当前schema下不存在对应的函数（例如未增加schema名称，或当前连接的schema非public，且函数...
dataX 报 “ERROR: operator does not exist: timestamp without time zone ＞= text“ 错误及解决方法
prelive的博客
09-25 1万+
【问题现象】 使用datax，编写jobjson，从gp（greenplum）库抽到pg（postgreSQL）库的增量语句（gp库及pg库中的updatet_dt字段均为timestamp类型）： "querySql": [ "select 字段名 from 表名 where update_dt >= to_char(to_timestamp(${lastTime}),'yyyy-MM-dd HH24:MI:SS') AND update_dt < to_char(to_times
PostgreSQL DBA(46) - PG Operator classes and families
07-01 498
先前章节已简单提到pg_am,以hash为例介绍了hash index不能支持大于等于,小于等于等相关操作,我们了解到需要信息来确认访问方法接...
parser切词&全文检索
bielidefeng的专栏
05-30 1535
全文检索：http://www.postgresql.org/docs/9.3/interactive/textsearch.htmlpostgres 切词: http://blog.163.com/digoal@126/blog/static/163877040201422410175698/ ts_parse：获取切词后的所有词组 SELECT * FROM ts_parse('zhpars
SQL 错误 [42883]: ERROR: function pg_catalog.substring(timestamp without time zone, integer, integer)
MyySophia的博客
11-15 3912
目录 一、环境 二、问题 三、后续GP升级之后代码中的substring都要改吗？ 一、环境 dataTransfer]$ psql psql (9.4.24) 二、问题 select substring(evt_timestamp,1,13), count( 1 ) from tablename where evt_timestamp >= '2020-05-01 08:00:00' and evt_timestamp <= '2020-05-03 08:00:00'..
PostgreSQL 枚举类型使用及ERROR: operator does not exist错误处理
Fisher3652的博客
09-09 3540
//创建枚举类 CREATE TYPE USER_ROLE AS ENUM ('MALE', 'FEMALE'); //添加转换规则 CREATE CAST (VARCHAR AS USER_ROLE) WITH INOUT AS IMPLICIT; //创建表，添加枚举类型字段 create table sys_user ( row_id bigserial not null constraint sys_user_pkey primary key,
greenplum常用的pg_catalog监控语句
知识的力量
09-18 2402
目录 1、Greenplum 基本查询信息 1.1、Greenplum 常用查询 1.2、Greenplum 触发器,锁,类型等相关信息 1.3、Greenplum 故障检测相关的信息 1.4、Greenplum 分布式事务有关信息 1.5、 Greenplum segment 有关信息 1.6、Greenplum 数据文件状态有关信息 1.7、Greenplum 有关储存的信...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值