I have no clue about the reason.Perhaps a memory licking that went away after
reboot . ...Or you get "lucky" again and the error appears once more. rsrs
My first guess would be if task’s using free(); or what else. how does memory
get released?
> On Sep 17, 2019, at 15:57, THORPE MAYES via naviserver-devel
> <naviserver-devel@lists.sourceforge.net> wrote:
>
> Hi,
>
> This happened today:
>
> I was getting thousands of these lines in my server log:
>
> [17/Sep/2019:07:59:07][4924.7f82467f4700][-conn:mealdeliverysoftware:19:25314-]
> Notice: dbipg: prepare dbipg_6242353/0 cols 0: deallocate dbipg_6238059
> [17/Sep/2019:07:59:07][4924.7f82467f4700][-conn:mealdeliverysoftware:19:25314-]
> Notice: dbipg: prepare dbipg_6242354/0 cols 0: deallocate dbipg_6238060
> [17/Sep/2019:07:59:07][4924.7f82467f4700][-conn:mealdeliverysoftware:19:25314-]
> Notice: dbipg: prepare dbipg_6242355/0 cols 0: deallocate dbipg_6238061
>
>
> I restarted the server and the problem went away (maybe).
>
> My guess is that configuration is either wrong or not complete. Here is the
> section in my config file that deals with this:
>
> # database configuration
>
>
> ns_section "ns/server/${servername}/module/xxxxx"
> ns_param default true ;# This is the default pool for mds
>
>
> ns_param handles 2 ;# Max open handles to db.
>
>
> ns_param maxwait 10 ;# Seconds to wait if handle unavailable.
>
>
> ns_param maxidle 0 ;# Handle closed after maxidle seconds if
> unused.
>
> ns_param maxopen 0 ;# Handle closed after maxopen seconds,
> regardles of use.
>
> ns_param maxqueries 0 ;# Handle closed after maxqueries sql
> queries.
>
> ns_param checkinterval 600 ;# Check for idle handles every 10
> minutes.
>
>
> ns_param maxhandles 0
> ns_param timeout 10
> ns_param maxrows 1000
>
> ns_param cachesize [expr 1024*1024]
>
> # The following parameters are configured at server-startup.
>
>
> ns_param user “xxxxxx"
> ns_param password xxxxxxx
> ns_param database “xxxxxx"
> ns_param datasource "user=‘xxxxx' password=‘xxxxx' dbname=‘xxxxxx’"
>
>
> This is also in the config file for my legacy code:
> # database pool configuration
>
>
> ns_section "ns/db/pool/${default_pool}"
> ns_param driver postgres
> ns_param connections 40
> ns_param datasource localhost:5432:${database_name}
> ns_param user xxxxxx
> ns_param password xxxxxx
> ns_param verbose true
> ns_param logsqlerrors true
> ns_param extendedtableinfo true
> ns_param maxidle 1000000000
> ns_param maxopen 1000000000
>
>
> # Database pools accessible by server
>
>
> ns_section "ns/server/${servername}/db"
> ns_param pools "*"
> ns_param defaultpool "${default_pool}"
>
>
>
> I will appreciate any help/direction.
>
> Thank you,
>
> Thorpe
>
> Thorpe Mayes
> 2313 Lockhill-Selma Road, Suite 164
> San Antonio, Texas 78230-3007
> Phone: (512) 394-8766
>
> _______________________________________________
> naviserver-devel mailing list
> naviserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/naviserver-devel
_______________________________________________
naviserver-devel mailing list
naviserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/naviserver-devel
