Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Whether prompt the cause of the following messages (SQL Anywhere 12.0.1.4178):
Error creating new connection: hcommblk.Open (8) / Shared Memory function newConn failed


I. 07/22 07:25:32. 1: -xs ****
...
I. 07/22 07:25:32. 5: -c
I. 07/22 07:25:32. 6: 15%
...
I. 07/22 07:25:32. SQL Anywhere Network Server Version 12.0.1.4178
...
I. 07/22 07:25:32. Running Windows 7 Build 7601 Service Pack 1 on X86 (X86_64)
I. 07/22 07:25:32. Server built for X86 processor architecture
I. 07/22 07:25:32. 302716K of memory used for caching
I. 07/22 07:25:32. Minimum cache size: 302716K, maximum cache size: 1404940K
I. 07/22 07:25:32. Using a maximum page size of 4096 bytes
I. 07/22 07:25:32. Multiprogramming level: minimum:4, current:20, maximum:80
I. 07/22 07:25:32. Automatic tuning of multiprogramming level is enabled
I. 07/22 07:25:32. TCP using Winsock version 2.2
I. 07/22 07:25:32. IPv6 support enabled
I. 07/22 07:25:32. Database server started at Wed Jul 22 2015 07:25
I. 07/22 07:25:32. Database server will stop at Wed Jul 22 2015 23:45
I. 07/22 07:25:32. Trying to start SharedMemory link ...
I. 07/22 07:25:32.     SharedMemory link started successfully
...
I. 07/22 12:52:23. Connection ID 1: disconnecting shared memory client, process id not found
...
I. 07/22 12:53:41. Error creating new connection: hcommblk.Open (8)
I. 07/22 12:53:41. Shared Memory function newConn failed
I. 07/22 12:54:17. Error creating new connection: hcommblk.Open (8)
I. 07/22 12:54:17. Shared Memory function newConn failed
...
I. 07/22 13:00:01. Database server shutdown requested via server console

asked 22 Jul '15, 04:50

Ilia63's gravatar image

Ilia63
1.2k515782
accept rate: 44%


The "hcommblk.Open (8)" message occurs when the server was unable to connect to the client's shared memory block. The "8" is the error code, in this case means ERROR_NOT_ENOUGH_MEMORY. I.e. the server did not have enough memory (address space) to map the shared memory.

You will likely need to either increase the amount of memory on your computer or reduce the max cache size of the server (i.e. use -ch switch to lower the upper bound of the cache).

HTH

permanent link

answered 22 Jul '15, 08:38

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×438

question asked: 22 Jul '15, 04:50

question was seen: 1,844 times

last updated: 22 Jul '15, 08:38