search

heterodb / pg-strom

PG-Strom - Master development repository
http://heterodb.github.io/pg-strom/
Other
1.3k stars 160 forks source link

after create extension pg_strom,select * from pg_class raise error,drop extension is OK #564

Closed changtonghf closed 1 year ago

changtonghf commented 2 years ago

I compile and install the mian branch of pg_strom,after edit postgersql.conf add shared_preload_libraries = '$libdir/pg_strom' then start postgresql,select from pg_class;raise error,and other all feature are OK. I drop extension pg_strom;stop the postgresql,edit postgersql.conf remove shared_preload_libraries = '$libdir/pg_strom',then start postgresql,select from pg_class;Now OK

kaigai commented 2 years ago

I cannot suggest anything without error message....

changtonghf commented 2 years ago

I cannot suggest anything without error message....

steve=# create extension pg_strom;
CREATE EXTENSION
steve=# select * from pg_class;
ERROR:  type with OID 0 does not exist
steve=# SELECT cat, count(*), avg(ax) FROM t0 NATURAL JOIN t1 NATURAL JOIN t2 NATURAL JOIN t3 NATURAL JOIN t4 NATURAL JOIN t5 NATURAL JOIN t6 NATURAL JOIN t7 NATURAL JOIN t8 GROUP BY cat;
ERROR:  Bug? unexpected expression: {FUNCEXPR :funcid 273666 :funcresulttype 1022 :funcretset false :funcvariadic false :funcformat 0 :funccollid 0 :inputcollid 0 :args ({FUNCEXPR :funcid 273663 :funcresulttype 20 :funcretset false :funcvariadic false :funcformat 0 :funccollid 0 :inputcollid 0 :args ({NULLTEST :arg {VAR :varno 65001 :varattno 2 :vartype 701 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnosyn 65001 :varattnosyn 2 :location -1} :nulltesttype 1 :argisrow false :location 0}) :location -1} {FUNCEXPR :funcid 273698 :funcresulttype 701 :funcretset false :funcvariadic false :funcformat 0 :funccollid 0 :inputcollid 0 :args ({VAR :varno 65001 :varattno 2 :vartype 701 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnosyn 65001 :varattnosyn 2 :location -1}) :location -1}) :location -1}
steve=# SELECT cat, count(*), avg(ax::float2) FROM t0 NATURAL JOIN t1 NATURAL JOIN t2 NATURAL JOIN t3 NATURAL JOIN t4 NATURAL JOIN t5 NATURAL JOIN t6 NATURAL JOIN t7 NATURAL JOIN t8 GROUP BY cat;
 cat |  count  |        avg         
-----+---------+--------------------
 ddd | 3845641 |  49.98507155301589
 www | 3844613 |  49.96084038998008
 iii | 3846818 | 49.986969212922965
 uuu | 3847014 |  50.00983128940075
 sss | 3844827 | 49.965999091579995
 hhh | 3844219 |   49.9743726697268
 ccc | 3847734 | 49.975254168064865
 vvv | 3848386 |   49.9917743896962
 zzz | 3848331 |  49.96458120333832
 qqq | 3848787 |  50.01847624802413
 ooo | 3844878 | 49.996129277206364
 fff | 3844356 |  49.99016004945101
 xxx | 3848896 |   49.9946648663522
 mmm | 3842068 | 49.964529660665974
 jjj | 3847006 |  49.99343254335918
 ttt | 3846045 | 50.018311714186154
 lll | 3846431 |  49.97074160684917
 yyy | 3845862 |  49.99223057611047
 eee | 3844988 |  49.99190674497572
 ppp | 3846312 | 50.014215806264225
 kkk | 3847200 | 49.993333933523644
 aaa | 3845546 |  49.99775191893527
 nnn | 3843955 |  49.97460744769823
 rrr | 3845170 |  49.99475855214668
 bbb | 3846559 | 49.992573481760964
 ggg | 3848358 | 50.009455973956406
(26 rows)

steve=# select * from pg_available_extensions where name = 'pg_strom';
   name   | default_version | installed_version |                           comment                           
----------+-----------------+-------------------+-------------------------------------------------------------
 pg_strom | 4.0             | 4.0               | PG-Strom - Extension for Big-data processing using GPU/NVME
(1 row)
changtonghf commented 2 years ago

--this is my postgresql.conf shared_preload_libraries = 'citus,orafce,pg_strom,pg_cron,pg_stat_statements,pg_stat_kcache,pg_stat_monitor,plpgsql_check' jit_provider = 'llvmjit' cron.database_name = 'steve' cron.use_background_workers = on max_worker_processes = 100 track_activities = on track_counts = on track_io_timing = on track_functions = all track_activity_query_size = 10240 stats_temp_directory = 'pg_stat_tmp' shared_buffers = 6GB work_mem = 1GB

kaigai commented 1 year ago

We don't care about issues prior to v3.x or before. Needs to confirm whether it is reproducible on the v5.x series or not.