Thread: I have some troubles to run test_shm_mq;

I have some troubles to run test_shm_mq;

From
Andy Fan
Date:
My code is based on commit 

zhifan@zhifandeMacBook-Pro ~/g/polardb_clean> git log
commit d06fe6ce2c79420fd19ac89ace81b66579f08493 
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Tue Nov 6 18:56:26 2018 -0500

what I did includes:
1.   ./configure --enable-debug
2.   make world  // doesn't see the test_shm_mq on the output
3.   make install-world // doesn't see the test_shm_mq.control under the install directory.
4.   CREATE EXTENSION test_shm_mq;  ==> .  could not open extension control file "/.../share/postgresql/extension/test_shm_mq.control": No such file or directory

how can I get it work?  Thanks

Re: I have some troubles to run test_shm_mq;

From
Thomas Munro
Date:
On Mon, Mar 11, 2019 at 8:59 PM Andy Fan <zhihui.fan1213@gmail.com> wrote:
> 4.   CREATE EXTENSION test_shm_mq;  ==> .  could not open extension control file
"/.../share/postgresql/extension/test_shm_mq.control":No such file or directory
 
>
> how can I get it work?  Thanks

Hi Andy,

Try this first:

cd src/test/modules/test_shm_mq
make install

-- 
Thomas Munro
https://enterprisedb.com


Re: I have some troubles to run test_shm_mq;

From
Andy Fan
Date:
Works, thank you Thomas!  I have spent more than 2 hours on this.   do you know which document I miss for this question?

Thanks

On Mon, Mar 11, 2019 at 4:05 PM Thomas Munro <thomas.munro@gmail.com> wrote:
On Mon, Mar 11, 2019 at 8:59 PM Andy Fan <zhihui.fan1213@gmail.com> wrote:
> 4.   CREATE EXTENSION test_shm_mq;  ==> .  could not open extension control file "/.../share/postgresql/extension/test_shm_mq.control": No such file or directory
>
> how can I get it work?  Thanks

Hi Andy,

Try this first:

cd src/test/modules/test_shm_mq
make install

--
Thomas Munro
https://enterprisedb.com

Re: I have some troubles to run test_shm_mq;

From
Andy Fan
Date:
and whenever I run a simple query  "SELECT test_shm_mq(1024, 'a');"

I see the following log

2019-03-11 16:33:17.800 CST [65021] LOG:  background worker "test_shm_mq" (PID 65052) exited with exit code 1


does it indicates something wrong?

On Mon, Mar 11, 2019 at 4:30 PM Andy Fan <zhihui.fan1213@gmail.com> wrote:
Works, thank you Thomas!  I have spent more than 2 hours on this.   do you know which document I miss for this question?

Thanks

On Mon, Mar 11, 2019 at 4:05 PM Thomas Munro <thomas.munro@gmail.com> wrote:
On Mon, Mar 11, 2019 at 8:59 PM Andy Fan <zhihui.fan1213@gmail.com> wrote:
> 4.   CREATE EXTENSION test_shm_mq;  ==> .  could not open extension control file "/.../share/postgresql/extension/test_shm_mq.control": No such file or directory
>
> how can I get it work?  Thanks

Hi Andy,

Try this first:

cd src/test/modules/test_shm_mq
make install

--
Thomas Munro
https://enterprisedb.com

Re: I have some troubles to run test_shm_mq;

From
Thomas Munro
Date:
On Mon, Mar 11, 2019 at 9:35 PM Andy Fan <zhihui.fan1213@gmail.com> wrote:
> and whenever I run a simple query  "SELECT test_shm_mq(1024, 'a');"
>
> I see the following log
>
> 2019-03-11 16:33:17.800 CST [65021] LOG:  background worker "test_shm_mq" (PID 65052) exited with exit code 1

Hmm, I don't know actually know why test_shm_mq_main() ends with
proc_exit(1) instead of 0.  It's possible that it was written when the
meaning of bgworker exit codes was still being figured out, but I'm
not sure...

>> Works, thank you Thomas!  I have spent more than 2 hours on this.   do you know which document I miss for this
question?

There is probably only src/test/modules/README, which explains that
these modules are tests and examples and not part of a server
installation.

-- 
Thomas Munro
https://enterprisedb.com


Re: I have some troubles to run test_shm_mq;

From
Andy Fan
Date:
 Thanks for the clarification!

On Mon, Mar 11, 2019 at 5:02 PM Thomas Munro <thomas.munro@gmail.com> wrote:
On Mon, Mar 11, 2019 at 9:35 PM Andy Fan <zhihui.fan1213@gmail.com> wrote:
> and whenever I run a simple query  "SELECT test_shm_mq(1024, 'a');"
>
> I see the following log
>
> 2019-03-11 16:33:17.800 CST [65021] LOG:  background worker "test_shm_mq" (PID 65052) exited with exit code 1

Hmm, I don't know actually know why test_shm_mq_main() ends with
proc_exit(1) instead of 0.  It's possible that it was written when the
meaning of bgworker exit codes was still being figured out, but I'm
not sure...

>> Works, thank you Thomas!  I have spent more than 2 hours on this.   do you know which document I miss for this question?

There is probably only src/test/modules/README, which explains that
these modules are tests and examples and not part of a server
installation.

--
Thomas Munro
https://enterprisedb.com