search

drotiro / postpic

PostPic is an extension for the open source dbms PostgreSQL that enables image processing inside the database, like PostGIS does for spatial data. It adds the new 'image' type to the SQL, and several functions to process images and to extract their attributes.
http://drotiro.github.com/postpic/
135 stars 23 forks source link

Postpic - Function Square Resetting Postgres 9.2/9.3 #3

Closed bemanuel closed 10 years ago

bemanuel commented 10 years ago

Hi, i was testing postpic with PostgreSQL 9.2 and 9.3, but some functions like 'square' is resetting the service. The message was: (48543) SELECT: magick/transform.c:470: CropImage: Asserção `image != (const Image ) ((void )0)' falhou. LOG: server process (PID 15605) was terminated by signal 6: Aborted DETAIL: Failed process was running: select square(the_img, 96) from images LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-03 18:07:06 BRT LOG: database system was not properly shut down; automatic recovery in progress

I want to contribute to the project. Where can i verify the code to correct this problem? On compiling there was some errors, i had to modify attribute int4 to int8 or int, to compile succesful in PG 9.2 or 9.3

drotiro commented 10 years ago

Hi, I'm stick to version 9.1 Will update and try to reproduce the bug. To contribute you just need fork this repository and submit pull requests. Thanks.

drotiro commented 10 years ago

Update: Tested with PG9.2 on Ubuntu 13.04 32bit and worked fine. There were no compilation errors. I'll try with a 64bit box.

What system are you testing on? What version of Graphics Magick (check with GraphicsMagick-config --version)? Also, did you get some error while loading images?

bemanuel commented 10 years ago

On Wed, Feb 5, 2014 at 6:15 AM, Domenico Rotiroti notifications@github.comwrote:

Update: Tested with PG9.2 on Ubuntu 13.04 32bit and worked fine. There were no compilation errors. I'll try with a 64bit box.

What system are you testing on?

Ubuntu 13.10 - 3.11.0-15-generic #25-Ubuntu SMP - x86_64 Postgres v9.3.2 - CONFIGURE = '--prefix=/media/dados/Postgres/pg93' '--with-openssl' '--with-ossp-uuid' '--with-libxml' '--with-libxslt' '--with-perl' '--with-python'

What version of Graphics Magick (check with GraphicsMagick-config --version

)?

1.3.16 libgraphicsmagick++1-dev

Also, did you get some error while loading images?

Load to database, convert from bytea to image, using image_send, all is working. But when i use square, thumbnail the cluster is reseted.

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

drotiro commented 10 years ago

Hi, can you try the code in branch issue3 and see if it works for you? (I tested with Mint 13 64bit and it worked)

bemanuel commented 10 years ago

Now, on import i have errors:

postpic_import -U postpic -d postpic -hlocalhost -c postpic_import_callback *.JPG

.0.1(46192) BIND: malloc.c:2369: sysmalloc: Assertion `(old_top == (((mbinptr) (((char ) &((av)->bins[((1) - 1) * 2])) - builtin_offsetof (struct malloc_chunk, fd)))) && old_size == 0) || ((unsigned long) (old_size) >= (unsigned long)((((builtin_offsetof (struct malloc_chunk, fd_nextsize))+((2 * (sizeof(size_t))) - 1)) & ~((2 \ (sizeof(size_t))) - 1))) && ((old_top)->size & 0x1) && ((unsigned long)old_end & pagemask) == 0)' failed. LOG: server process (PID 13670) was terminated by signal 6: Aborted DETAIL: Failed process was running: select postpic_import_callback($1::image, 'DSC00006.JPG', '') LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:08:33 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/2BB1E18 LOG: unexpected pageaddr 0/1562000 in log segment 000000010000000000000003, offset 5644288 LOG: redo done at 0/3561A70 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 6:27 PM, Domenico Rotiroti notifications@github.comwrote:

Hi, can you try the code in branch issue3 and see if it works for you? (I tested with Mint 13 64bit and it worked)

— Reply to this email directly or view it on GitHubhttps://github.com/drotiro/postpic/issues/3#issuecomment-34249157 .

bemanuel commented 10 years ago

And using the example system: PostPicSQL> set mode thumbs Mode set to thumbs PostPicSQL> select square(the_img, 96) from images ERROR: Um erro de E/S ocorreu ao enviar para o processo servidor.

LOG: server process (PID 13800) was terminated by signal 11: Segmentation fault DETAIL: Failed process was running: select square(the_img, 96) from images LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:09:06 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/3561B20 LOG: record with zero length at 0/50810C0 LOG: redo done at 0/5081090 LOG: last completed transaction was at log time 2014-02-05 19:12:22.777595-03 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:10 PM, Bruno Silva bemanuel.pe@gmail.com wrote:

Now, on import i have errors:

postpic_import -U postpic -d postpic -hlocalhost -c postpic_import_callback *.JPG

.0.1(46192) BIND: malloc.c:2369: sysmalloc: Assertion `(old_top == (((mbinptr) (((char ) &((av)->bins[((1) - 1) * 2])) - builtin_offsetof (struct malloc_chunk, fd)))) && old_size == 0) || ((unsigned long) (old_size) >= (unsigned long)((((builtin_offsetof (struct malloc_chunk, fd_nextsize))+((2 * (sizeof(size_t))) - 1)) & ~((2 \ (sizeof(size_t))) - 1))) && ((old_top)->size & 0x1) && ((unsigned long)old_end & pagemask) == 0)' failed. LOG: server process (PID 13670) was terminated by signal 6: Aborted DETAIL: Failed process was running: select postpic_import_callback($1::image, 'DSC00006.JPG', '') LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:08:33 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/2BB1E18 LOG: unexpected pageaddr 0/1562000 in log segment 000000010000000000000003, offset 5644288 LOG: redo done at 0/3561A70 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 6:27 PM, Domenico Rotiroti < notifications@github.com> wrote:

Hi, can you try the code in branch issue3 and see if it works for you? (I tested with Mint 13 64bit and it worked)

— Reply to this email directly or view it on GitHubhttps://github.com/drotiro/postpic/issues/3#issuecomment-34249157 .

bemanuel commented 10 years ago

I don't know if helps, but, above the messages of compilation * Checking for required programs GraphicsMagick-config: /usr/bin/GraphicsMagick-config pg_config : /opt/postgres/bin//pg_config make[1]: Entering directory /home/bemanuel/postpic-issue3/server' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fpicGraphicsMagick-config --cppflags --cflags`-I. -I. -I/opt/postgres/include/server -I/opt/postgres/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -c -o postpic.o postpic.c postpic.c: In function ‘pp_timestamp2str’: postpic.c:851:2: warning: passing argument 5 of ‘timestamp2tm’ from incompatible pointer type [enabled by default] timestamp2tm(ts, &tzp, &tm, &fsec , &tzn, NULL); ^ In file included from /opt/postgres/include/server/utils/datetime.h:20:0, from postpic.c:24: /opt/postgres/include/server/utils/timestamp.h:233:12: note: expected ‘const char ’ but argument is of type ‘char *’ extern int timestamp2tm(Timestamp dt, int tzp, struct pg_tm tm, ^ gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fpic -shared -o postpic.so postpic.o -L/opt/postgres/lib -Wl,--as-needed -Wl,-rpath,'/opt/postgres/lib',--enable-new-dtagsGraphicsMagick-config --libs make[1]: Leaving directory/home/bemanuel/postpic-issue3/server' make[1]: Entering directory/home/bemanuel/postpic-issue3/utils' gcc -Ipg_config --includedir-c postpic_import.c -o postpic_import.o gcc -Ipg_config --includedir-c postpic_utils.c -o postpic_utils.o gcc -o postpic_import postpic_import.o postpic_utils.o -Lpg_config --libdir-lpq gcc -Ipg_config --includedir-c postpic_export.c -o postpic_export.o postpic_export.c: In function ‘pp_export’: postpic_export.c:137:3: warning: passing argument 2 of ‘PQunescapeBytea’ from incompatible pointer type [enabled by default] val = PQunescapeBytea( PQgetvalue(res, i, icol), &len); ^ In file included from postpic_utils.h:14:0, from postpic_export.c:22: /opt/postgres/include/libpq-fe.h:506:23: note: expected ‘size_t ’ but argument is of type ‘int ’ extern unsigned char PQunescapeBytea(const unsigned char *strtext, ^ gcc -o postpic_export postpic_export.o postpic_utils.o -Lpg_config --libdir-lpq make[1]: Leaving directory`/home/bemanuel/postpic-issue3/utils'

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:15 PM, Bruno Silva bemanuel.pe@gmail.com wrote:

And using the example system: PostPicSQL> set mode thumbs Mode set to thumbs PostPicSQL> select square(the_img, 96) from images ERROR: Um erro de E/S ocorreu ao enviar para o processo servidor.

LOG: server process (PID 13800) was terminated by signal 11: Segmentation fault DETAIL: Failed process was running: select square(the_img, 96) from images LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:09:06 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/3561B20 LOG: record with zero length at 0/50810C0 LOG: redo done at 0/5081090 LOG: last completed transaction was at log time 2014-02-05 19:12: 22.777595-03 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:10 PM, Bruno Silva bemanuel.pe@gmail.com wrote:

Now, on import i have errors:

postpic_import -U postpic -d postpic -hlocalhost -c postpic_import_callback *.JPG

.0.1(46192) BIND: malloc.c:2369: sysmalloc: Assertion `(old_top == (((mbinptr) (((char ) &((av)->bins[((1) - 1) * 2])) - builtin_offsetof (struct malloc_chunk, fd)))) && old_size == 0) || ((unsigned long) (old_size) >= (unsigned long)((((builtin_offsetof (struct malloc_chunk, fd_nextsize))+((2 * (sizeof(size_t))) - 1)) & ~((2 \ (sizeof(size_t))) - 1))) && ((old_top)->size & 0x1) && ((unsigned long)old_end & pagemask) == 0)' failed. LOG: server process (PID 13670) was terminated by signal 6: Aborted DETAIL: Failed process was running: select postpic_import_callback($1::image, 'DSC00006.JPG', '') LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:08:33 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/2BB1E18 LOG: unexpected pageaddr 0/1562000 in log segment 000000010000000000000003, offset 5644288 LOG: redo done at 0/3561A70 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 6:27 PM, Domenico Rotiroti < notifications@github.com> wrote:

Hi, can you try the code in branch issue3 and see if it works for you? (I tested with Mint 13 64bit and it worked)

— Reply to this email directly or view it on GitHubhttps://github.com/drotiro/postpic/issues/3#issuecomment-34249157 .

bemanuel commented 10 years ago

size of image: du -ch DSC_8966_NEF.jpg 3.8M DSC_8966_NEF.jpg 3.8M total

But if i import one by one the postpic_import don't crash the server Postgres.

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:26 PM, Bruno Silva bemanuel.pe@gmail.com wrote:

I don't know if helps, but, above the messages of compilation * Checking for required programs GraphicsMagick-config: /usr/bin/GraphicsMagick-config pg_config : /opt/postgres/bin//pg_config make[1]: Entering directory /home/bemanuel/postpic-issue3/server' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fpicGraphicsMagick-config --cppflags --cflags`-I. -I. -I/opt/postgres/include/server -I/opt/postgres/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -c -o postpic.o postpic.c postpic.c: In function ‘pp_timestamp2str’: postpic.c:851:2: warning: passing argument 5 of ‘timestamp2tm’ from incompatible pointer type [enabled by default] timestamp2tm(ts, &tzp, &tm, &fsec , &tzn, NULL); ^ In file included from /opt/postgres/include/server/utils/datetime.h:20:0, from postpic.c:24: /opt/postgres/include/server/utils/timestamp.h:233:12: note: expected ‘const char ’ but argument is of type ‘char *’ extern int timestamp2tm(Timestamp dt, int tzp, struct pg_tm tm, ^ gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fpic -shared -o postpic.so postpic.o -L/opt/postgres/lib -Wl,--as-needed -Wl,-rpath,'/opt/postgres/lib',--enable-new-dtagsGraphicsMagick-config --libs make[1]: Leaving directory/home/bemanuel/postpic-issue3/server' make[1]: Entering directory/home/bemanuel/postpic-issue3/utils' gcc -Ipg_config --includedir-c postpic_import.c -o postpic_import.o gcc -Ipg_config --includedir-c postpic_utils.c -o postpic_utils.o gcc -o postpic_import postpic_import.o postpic_utils.o -Lpg_config --libdir-lpq gcc -Ipg_config --includedir-c postpic_export.c -o postpic_export.o postpic_export.c: In function ‘pp_export’: postpic_export.c:137:3: warning: passing argument 2 of ‘PQunescapeBytea’ from incompatible pointer type [enabled by default] val = PQunescapeBytea( PQgetvalue(res, i, icol), &len); ^ In file included from postpic_utils.h:14:0, from postpic_export.c:22: /opt/postgres/include/libpq-fe.h:506:23: note: expected ‘size_t ’ but argument is of type ‘int ’ extern unsigned char PQunescapeBytea(const unsigned char *strtext, ^ gcc -o postpic_export postpic_export.o postpic_utils.o -Lpg_config --libdir-lpq make[1]: Leaving directory`/home/bemanuel/postpic-issue3/utils'

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:15 PM, Bruno Silva bemanuel.pe@gmail.com wrote:

And using the example system: PostPicSQL> set mode thumbs Mode set to thumbs PostPicSQL> select square(the_img, 96) from images ERROR: Um erro de E/S ocorreu ao enviar para o processo servidor.

LOG: server process (PID 13800) was terminated by signal 11: Segmentation fault DETAIL: Failed process was running: select square(the_img, 96) from images LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:09:06 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/3561B20 LOG: record with zero length at 0/50810C0 LOG: redo done at 0/5081090 LOG: last completed transaction was at log time 2014-02-05 19:12: 22.777595-03 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:10 PM, Bruno Silva bemanuel.pe@gmail.comwrote:

Now, on import i have errors:

postpic_import -U postpic -d postpic -hlocalhost -c postpic_import_callback *.JPG

.0.1(46192) BIND: malloc.c:2369: sysmalloc: Assertion `(old_top == (((mbinptr) (((char ) &((av)->bins[((1) - 1) * 2])) - builtin_offsetof (struct malloc_chunk, fd)))) && old_size == 0) || ((unsigned long) (old_size) >= (unsigned long)((((builtin_offsetof (struct malloc_chunk, fd_nextsize))+((2 * (sizeof(size_t))) - 1)) & ~((2 \ (sizeof(size_t))) - 1))) && ((old_top)->size & 0x1) && ((unsigned long)old_end & pagemask) == 0)' failed. LOG: server process (PID 13670) was terminated by signal 6: Aborted DETAIL: Failed process was running: select postpic_import_callback($1::image, 'DSC00006.JPG', '') LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:08:33 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/2BB1E18 LOG: unexpected pageaddr 0/1562000 in log segment 000000010000000000000003, offset 5644288 LOG: redo done at 0/3561A70 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 6:27 PM, Domenico Rotiroti < notifications@github.com> wrote:

Hi, can you try the code in branch issue3 and see if it works for you? (I tested with Mint 13 64bit and it worked)

— Reply to this email directly or view it on GitHubhttps://github.com/drotiro/postpic/issues/3#issuecomment-34249157 .

bemanuel commented 10 years ago

And the functions square, thumbnail and crop works on psql.

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:32 PM, Bruno Silva bemanuel.pe@gmail.com wrote:

size of image: du -ch DSC_8966_NEF.jpg 3.8M DSC_8966_NEF.jpg 3.8M total

But if i import one by one the postpic_import don't crash the server Postgres.

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:26 PM, Bruno Silva bemanuel.pe@gmail.com wrote:

I don't know if helps, but, above the messages of compilation * Checking for required programs GraphicsMagick-config: /usr/bin/GraphicsMagick-config pg_config : /opt/postgres/bin//pg_config make[1]: Entering directory /home/bemanuel/postpic-issue3/server' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fpicGraphicsMagick-config --cppflags --cflags`-I. -I. -I/opt/postgres/include/server -I/opt/postgres/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -c -o postpic.o postpic.c postpic.c: In function ‘pp_timestamp2str’: postpic.c:851:2: warning: passing argument 5 of ‘timestamp2tm’ from incompatible pointer type [enabled by default] timestamp2tm(ts, &tzp, &tm, &fsec , &tzn, NULL); ^ In file included from /opt/postgres/include/server/utils/datetime.h:20:0, from postpic.c:24: /opt/postgres/include/server/utils/timestamp.h:233:12: note: expected ‘const char ’ but argument is of type ‘char *’ extern int timestamp2tm(Timestamp dt, int tzp, struct pg_tm tm, ^ gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fpic -shared -o postpic.so postpic.o -L/opt/postgres/lib -Wl,--as-needed -Wl,-rpath,'/opt/postgres/lib',--enable-new-dtagsGraphicsMagick-config --libs make[1]: Leaving directory/home/bemanuel/postpic-issue3/server' make[1]: Entering directory/home/bemanuel/postpic-issue3/utils' gcc -Ipg_config --includedir-c postpic_import.c -o postpic_import.o gcc -Ipg_config --includedir-c postpic_utils.c -o postpic_utils.o gcc -o postpic_import postpic_import.o postpic_utils.o -Lpg_config --libdir-lpq gcc -Ipg_config --includedir-c postpic_export.c -o postpic_export.o postpic_export.c: In function ‘pp_export’: postpic_export.c:137:3: warning: passing argument 2 of ‘PQunescapeBytea’ from incompatible pointer type [enabled by default] val = PQunescapeBytea( PQgetvalue(res, i, icol), &len); ^ In file included from postpic_utils.h:14:0, from postpic_export.c:22: /opt/postgres/include/libpq-fe.h:506:23: note: expected ‘size_t ’ but argument is of type ‘int ’ extern unsigned char PQunescapeBytea(const unsigned char *strtext, ^ gcc -o postpic_export postpic_export.o postpic_utils.o -Lpg_config --libdir-lpq make[1]: Leaving directory`/home/bemanuel/postpic-issue3/utils'

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:15 PM, Bruno Silva bemanuel.pe@gmail.comwrote:

And using the example system: PostPicSQL> set mode thumbs Mode set to thumbs PostPicSQL> select square(the_img, 96) from images ERROR: Um erro de E/S ocorreu ao enviar para o processo servidor.

LOG: server process (PID 13800) was terminated by signal 11: Segmentation fault DETAIL: Failed process was running: select square(the_img, 96) from images LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:09:06 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/3561B20 LOG: record with zero length at 0/50810C0 LOG: redo done at 0/5081090 LOG: last completed transaction was at log time 2014-02-05 19:12: 22.777595-03 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 7:10 PM, Bruno Silva bemanuel.pe@gmail.comwrote:

Now, on import i have errors:

postpic_import -U postpic -d postpic -hlocalhost -c postpic_import_callback *.JPG

.0.1(46192) BIND: malloc.c:2369: sysmalloc: Assertion `(old_top == (((mbinptr) (((char ) &((av)->bins[((1) - 1) * 2])) - builtin_offsetof (struct malloc_chunk, fd)))) && old_size == 0) || ((unsigned long) (old_size) >= (unsigned long)((((builtin_offsetof (struct malloc_chunk, fd_nextsize))+((2 * (sizeof(size_t))) - 1)) & ~((2 \ (sizeof(size_t))) - 1))) && ((old_top)->size & 0x1) && ((unsigned long)old_end & pagemask) == 0)' failed. LOG: server process (PID 13670) was terminated by signal 6: Aborted DETAIL: Failed process was running: select postpic_import_callback($1::image, 'DSC00006.JPG', '') LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted; last known up at 2014-02-05 19:08:33 BRT LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/2BB1E18 LOG: unexpected pageaddr 0/1562000 in log segment 000000010000000000000003, offset 5644288 LOG: redo done at 0/3561A70 LOG: database system is ready to accept connections LOG: autovacuum launcher started

Bruno E. A. Silva. Analista de Sistemas. Bacharel em Sistemas de Informação MBA Gerência de Projetos Certified Scrum Master LPIC-1 SCJP, SE 6 Novell CLA / DCTS ECR

DBA Postgres

“A caixa dizia: Requer MS Windows ou superior. Então instalei Linux.” - Sábio Desconhecido "Alguns prestam serviço/consultoria de Qualidade, os outros vendem licença!"

On Wed, Feb 5, 2014 at 6:27 PM, Domenico Rotiroti < notifications@github.com> wrote:

Hi, can you try the code in branch issue3 and see if it works for you? (I tested with Mint 13 64bit and it worked)

— Reply to this email directly or view it on GitHubhttps://github.com/drotiro/postpic/issues/3#issuecomment-34249157 .

drotiro commented 10 years ago

Ok. If I understand correctly, now square & co. work, but import of multiple images with postpic_import fails.

I'll take a look at that and at the compiler warnings.

bemanuel commented 10 years ago

I will made some tests

Enviado pelo meu Nexus Em 06/02/2014 06:31, "Domenico Rotiroti" notifications@github.com escreveu:

Ok. If I understand correctly, now square & co. work, but import of multiple images with postpic_import fails.

I'll take a look at that and at the compiler warnings.

— Reply to this email directly or view it on GitHubhttps://github.com/drotiro/postpic/issues/3#issuecomment-34305812 .

drotiro commented 10 years ago

Merged issue3 and removed the warnings. I'm closing this, if you want file another bug for the postpic_import problem.

Regards.

bemanuel commented 10 years ago

Thanks!

Enviado pelo meu Nexus Em 10/02/2014 10:47, "Domenico Rotiroti" notifications@github.com escreveu:

Merged issue3 and removed the warnings. I'm closing this, if you want file another bug for the postpic_import problem.

Regards.

— Reply to this email directly or view it on GitHubhttps://github.com/drotiro/postpic/issues/3#issuecomment-34632703 .