Menu

#446 CPL and postgres problems

ver devel
closed-fixed
modules (357)
5
2008-07-03
2008-04-11
No

Usage of cpl scripts with the db_postgres module don't work. This was reported on users:

http://lists.openser.org/pipermail/users/2008-March/016754.html

For every script a length of zero is reported.

I've added a small test case (29.sh) that shows the same problem.

It needs to investigated if there is a mixup with some datatypes for postgres.

Cheers,

Henning

Discussion

  • Henning Westerholt

    • status: open --> closed-fixed
     
  • Henning Westerholt

    Logged In: YES
    user_id=337916
    Originator: YES

    Fix commited and tested.

     
  • Henning Westerholt

    • status: closed-fixed --> open
     
  • Henning Westerholt

    Logged In: YES
    user_id=337916
    Originator: YES

    Reopen, because cpl-c works, but further tests shows that it segfaults sometimes. Probably a timing issue, as with activated debugging it works flawless. Trace:

    #0 0xffffe410 in __kernel_vsyscall ()
    #1 0xb7d9b875 in raise () from /lib/tls/i686/cmov/libc.so.6
    #2 0xb7d9d201 in abort () from /lib/tls/i686/cmov/libc.so.6
    #3 0xb7dd2e5c in __libc_message () from /lib/tls/i686/cmov/libc.so.6
    #4 0xb7ddad65 in _int_free () from /lib/tls/i686/cmov/libc.so.6
    #5 0xb7dde800 in free () from /lib/tls/i686/cmov/libc.so.6
    #6 0xb78d260d in PQclear () from /usr/lib/libpq.so.5
    #7 0xb7ce6a6a in free_query (_con=0x819fb00) at dbase.c:303
    #8 0xb7ce6dc0 in db_postgres_store_result (_con=0x819fb00, _r=0xbffa8244) at dbase.c:438
    #9 0x08115dd8 in db_do_query (_h=0x819fb00, _k=0xbffa8238, _op=0x0, _v=0xbffa8210, _c=0xbffa8248, _n=1, _nc=1, _o=0x0, _r=0xbffa8244, val2str=0xb7ceb4a0 <db_postgres_val2str>,
    submit_query=0xb7ce7aad <db_postgres_submit_query>, store_result=0xb7ce6b24 <db_postgres_store_result>) at db/db_query.c:105
    #10 0xb7ce69d2 in db_postgres_query (_h=0x819fb00, _k=0xbffa8238, _op=0x0, _v=0xbffa8210, _c=0xbffa8248, _n=1, _nc=1, _o=0x0, _r=0xbffa8244) at dbase.c:346
    #11 0xb7a2207b in get_user_script (username=0xbffa82b0, domain=0x0, script=0xbffa8360, key=0xbffa8358) at cpl_db.c:147
    #12 0xb7a228a3 in mi_cpl_get (cmd_tree=0x819fc88, param=0x0) at cpl_loader.c:340
    #13 0xb7eda1a7 in mi_fifo_server (fifo_stream=0x82c4bc8) at ../../mi/mi.h:84
    #14 0xb7edc203 in fifo_process (rank=0) at mi_fifo.c:212
    #15 0x080b3338 in start_module_procs () at sr_module.c:571
    #16 0x0806f01c in main (argc=5, argv=0xbffa8734) at main.c:824

     
  • Henning Westerholt

    • assigned_to: nobody --> henningw
     
  • Henning Westerholt

    • status: open --> closed-fixed
     
  • Henning Westerholt

    Logged In: YES
    user_id=337916
    Originator: YES

    I've tried to reproduce this again in the current trunk, with no luck.

     

Log in to post a comment.