Hi,
i've an Windows 2008 R2 with NetXMS 1.2.7
Error:
SQL query failed (Query = "SELECT var_value FROM config WHERE var_name=?"): could not send data to server: No buffer space available (0x00002747/10055)
This event occurs about 200 time a second.
After a while, i need to restart this Server, cause i can't reach it anymore.
Thanks for support.
Hi!
I found explanation for this problem: http://postgresql.1045698.n5.nabble.com/BUG-2305-quot-No-bufferspace-available-quot-error-on-large-insert-td2120136.html (http://postgresql.1045698.n5.nabble.com/BUG-2305-quot-No-bufferspace-available-quot-error-on-large-insert-td2120136.html). Looks like the only way to fix it is to add check for this error in POstgreSQL driver on NetXMS side and do sleep and retry to allow DB server to process data it already have. I'll make a patch and post updated driver here.
Best regards,
Victor
Hi Victor,
thanks for your quick help.
It's a bit Stange, because they're talking about Windows 2000 and this is quite a while behind us :-).
My PostgreSQL is x64 and 9.2.
That's strange indeed. I'm not sure if this real source of you problem, but we should try :) Attached is updated pgsql.ddr. It will also log SQL state code in error message, so if error will repeat, please send me new error messages.
Best regards,
Victor
Hi Victor,
i've copied it in the bin Folder and restarted NetXMS Core.
I think the cause of my Problem was, that the Server had Problems with sending Mailnotifications.
I'd disabled this processing and it seems to work now.
I will activate the policy, so the error could hapen again.