knizhnik / imcs

In-Memory Columnar Store extension for PostgreSQL
Apache License 2.0
203 stars 33 forks source link

imcs support swap disk #42

Open goodluckliu123 opened 9 years ago

goodluckliu123 commented 9 years ago

hi,knizhnik: i install imcs exetension in my postgres 9.3.5, i modify install.sh to: PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 USE_DISK=1 CFLAGS="-g3 --save-temps -Wall -Wno-format-security -DIMCS_DISK_SUPPORT " LDFLAGS="-pthread" install. and my postgres.conf is : imcs.shmem_size = 64 imcs.cache_size = 10 shared_preload_libraries='imcs' when i input select quote_load() in psql, the error is : ERROR: File read failed: 14 CONTEXT: PL/pgSQL function quote_load(boolean,text) line 1 at RETURN. what's wrong with me? help me!!

knizhnik commented 9 years ago

Hi

Error 14 is EFAULT. It means that pread is given invalid buffer address. Why? I don't know. I need to debug the application.

First of all please try to rebuild IMCS from scratch. May be you first build it without IMCS_DISK_SUPPORT and then with it. So please do make ... clean all install

If it doesn't help, I really need to debug it Can you attach debugger to postgres, set breakpoint on line 90 of fileio.c and print stack together with values of local variables. Or may be you can provide me SSH login to you system, so that I can debug it myself...

On 03/10/2015 03:05 PM, goodluckliu123 wrote:

hi,knizhnik: i install imcs exetension in my postgres 9.3.5, i modify install.sh to: PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 USE_DISK=1 CFLAGS="-g3 --save-temps -Wall -Wno-format-security -DIMCS_DISK_SUPPORT " LDFLAGS="-pthread" install. and my postgres.conf is : imcs.shmem_size = 64 imcs.cache_size = 10 shared_preload_libraries='imcs' when i input select quote_load() in psql, the error is : ERROR: File read failed: 14 CONTEXT: PL/pgSQL function quote_load(boolean,text) line 1 at RETURN. what's wrong with me? help me!!

— Reply to this email directly or view it on GitHub https://github.com/knizhnik/imcs/issues/42.

Best regards, Konstantin

goodluckliu123 commented 9 years ago

yes,i do as you say.but the result is still the same, i have TeamViewer tool for Remote Control & Desktop Sharing. Do you have skype number? my skype :kingkiller869

knizhnik commented 9 years ago

My Skype id is knizhnik 11.03.2015 10:50 пользователь "goodluckliu123" notifications@github.com написал:

yes,i do as you say.but the result is still the same, i have TeamViewer tool for Remote Control & Desktop Sharing. Do you have skype number? my skype :kingkiller869

— Reply to this email directly or view it on GitHub https://github.com/knizhnik/imcs/issues/42#issuecomment-78218485.