The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

Recently we have moved in our product the database from SA10 version to SA12(12.0.1.3311 on Linux). Sometimes on high avilability deployment(using heartbeat package) on database start in error messages log(-oe option) appears message "Cannot create resource tree" and nothing(even not first line 'SQL Anywhere Network Server Version 12.0.1.3311') in regular output messages log file(-o option). WHat can be areason for this error message.

Thanks in advance, Hanan Brener

asked 17 Jul '11, 10:52

HBrener's gravatar image

HBrener
426212333
accept rate: 0%


To expand on Glenn's answer a little bit, SQL Anywhere needs to create some temporary files for the database temp file, shared memory communication (these are actually sockets and shared memory, but appear as files in the file system), and a few others. They are placed in a directory structure rooted at $SATMP, $ASTMP, $TMP, or /tmp (whichever is the first one that is set).

In order for SQL Anywhere to start up, it must be able to create this directory tree for its temporary files. This requires execute permission on all directories up to the parent of $SATMP. Additionally, it requires read/write/execute permission on $SATMP itself.

If the $SATMP directory already has the correct permissions, you may look for existing directories that might conflict with the directories that SQL Anywhere is trying to create. You may also want to check the system logs to see if anything stands out.

If all of that fails, I find that strace can be a powerful tool for determining the exact cause of file-system-related issues.

permanent link

answered 18 Jul '11, 08:21

Phil%20Mitchell's gravatar image

Phil Mitchell
1.9k1831
accept rate: 27%

It has to be some kind of record... Google yields only 4 hits on "Cannot create resource tree" and two of them point here :)

(18 Jul '11, 11:59) Breck Carter

The message indicates that the server is unable to write to the SQL Anywhere resource directory on your Linux machine - likely a file permissions problem.

permanent link

answered 17 Jul '11, 21:21

Glenn%20Paulley's gravatar image

Glenn Paulley
10.7k571104
accept rate: 43%

Hy all.. Sorry for opening an old discusion but i need some help.. Please read this first: New thread

So.. I have some problems with TEMP dir I guess but I feel like a first-timer with linux when reading Sybase support papers. Anyhow, how do I check in which one does SqlAnywhere store TEMP files? "strance" says:

access("/tmp/.SQLAnywhere", W_OK)       = 0
umask(0)                                = 022
mkdir("/tmp/.SQLAnywhere", 0777)        = -1 EEXIST (File exists)
umask(022)                              = 0
open("/tmp/.SQLAnywhere/__SQLAnyCli__3881_3a561f00", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
umask(0)                                = 022
mkdir("/tmp/.SQLAnywhere", 0777)        = -1 EEXIST (File exists)
umask(022)                              = 0
umask(0)                                = 022
mkdir("/tmp/.SQLAnywhere/__SQLAnyCli__3881_3a561f00", 0777) = 0
mkdir("/tmp/.SQLAnywhere/__SQLAnyCli__3881_3a561f00/shmem", 0777) = 0
mkdir("/tmp/.SQLAnywhere/__SQLAnyCli__3881_3a561f00/fifos", 0777) = 0
mkdir("/tmp/.SQLAnywhere/__SQLAnyCli__3881_3a561f00/tmp", 0777) = 0

So.. I think default temp folder is /tmp.SQLAnywhere.. "ls -a -l" says:

drwxrwxrwt.  7 root root  4096 Apr 27 20:25 tmp
...
drwxrwxrwx.  7 apache apache   4096 Apr 27 20:25 .SQLAnywhere

So, what is the problem then? Again.. Everything works as it should in console with "php /var/www/html/dbtest.php", but if I run the script in browser I get an error:

Warning: sasql_connect(): SQLAnywhere: [-100] Database server not found in /var/www/html/dbtest.php
permanent link

answered 27 Apr '12, 14:57

TadejZ's gravatar image

TadejZ
1111
accept rate: 0%

1

No, I don't have an answer or a clue - I'd simply suggest to ask that as another new question (or add it to the one you have started if it seems related), such as "How to find out where SQL Anywhere expects its temporary files?" or whatever seems appropriate - I guess this will get more attraction from other readers...

(01 May '12, 07:13) Volker Barth
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:

×39

question asked: 17 Jul '11, 10:52

question was seen: 2,855 times

last updated: 01 May '12, 07:13