Skip to main content
📓 Tibero Online Manual Click here 📓

Search

Welcome to Tibero GTS!

Error Occurs When Executing cd, ls Commands in virdir After Accessing TAS via tbascmd

Document Type | Troubleshooting 

Category | Utility

Applicable Product Version | 7FS02PS

Error Code | 31004  

Document Number | TUTTS002

 

Issue

When accessing TAS using tbascmd and executing the cd, ls commands in virdir, an error message '31004: ERROR_AS_NOFILE' may occur, which means that no files exist in the specified directory.
Note
The 31004: ERROR_AS_NOFILE message may appear during file queries, but this situation does not affect DB operation.
 

Cause

The directory does not actually exist in TAS, and it shows a virtual directory as if the directory specified by the user when creating a file exists.
 
  • When specified as datafile '+DS0/tac/system01/system01.dtf'
    Directories such as tac and system01 are not created under DS0; only the actual file '+DS0/tac/system01/system01.dtf' exists.
 
The tac and system01 directories exist as virtual directories, and since the files do not actually exist, corresponding error logs are generated.

 

Solutions

When querying files in directories where actual files exist, this error message does not occur. 

Note
Directories created by the user using mkdir are created as DATA TYPE, and directories created by other cases are created as VIRDIR TYPE.
  • Directories created with the mkdir command create files with a '/' appended at the end of the filename.
  • tbascmd recognizes files with a trailing '/' as directories and displays them accordingly.
  • VIRDIR directories are deleted when all files under them are deleted.
-- After creating the DB, connect using tbascmd

$ tbascmd 28629

ASCMD 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.


[13:29]ASCMD +> ls
+DS0
- Number of diskspaces found: 1


-- Query pre-existing +DS0/tac

[13:47]ASCMD +DS0> ls -l
TYPE     REDUNED     STRIPED     NAME
VIRDIR   -           -           tac/
 - Number of files found: 1


-- Create and query +DS0/test01

[13:47]ASCMD +DS0> mkdir test01

[13:49]ASCMD +DS0> ls -l
TYPE     REDUNED     STRIPED     NAME
VIRDIR   -           -           tac/
DATA     3           COARSE      test01/
 - Number of files found: 2
tbascmd
tas log
tac == virdir [14:01]ASCMD +DS0> cd tac
[2025-04-21T14:01:52.575211] [AS-112] [I] tbas: try to open file '+DS0/tac'(R) [2025-04-21T14:01:52.575835] [AS-112] [W] tbas: failed to open file '+DS0/tac'(R,rc=-20) [2025-04-21T14:01:52.575892] [FRM-112] [I] THROW. ec=ERROR_AS_NOFILE(-31004) [ The AS file, 'tac', does not exist. ] (sql_id:(null), sub_sql_id:(null), user:tibero, ap_module:(null), program:TAS_CLNT, host:NO_HOST) [as_msg.c:2848:process_tbas_open] [2025-04-21T14:01:52.578780] [AS-113] [I] tbas: try to open file '+DS0/tac/'(R) [2025-04-21T14:01:52.579183] [AS-113] [W] tbas: failed to open file '+DS0/tac/'(R,rc=-20) [2025-04-21T14:01:52.579208] [FRM-113] [I] THROW. ec=ERROR_AS_NOFILE(-31004) [ The AS file, 'tac/', does not exist. ] (sql_id:(null), sub_sql_id:(null), user:tibero, ap_module:(null), program:TAS_CLNT, host:NO_HOST) [as_msg.c:2848:process_tbas_open]
[14:02]ASCMD +DS0/tac> cd +DS0
 
[14:03]ASCMD +DS0> mkdir test01
[2025-04-21T14:03:39.347375] [AS-113] [I] tbas: try to open file '+DS0/test01/'(R) [2025-04-21T14:03:39.347895] [AS-113] [W] tbas: failed to open file '+DS0/test01/'(R,rc=-20) [2025-04-21T14:03:39.347969] [FRM-113] [I] THROW. ec=ERROR_AS_NOFILE(-31004) [ The AS file, 'test01/', does not exist. ] (sql_id:(null), sub_sql_id:(null), user:tibero, ap_module:(null), program:TAS_CLNT, host:NO_HOST) [as_msg.c:2848:process_tbas_open] [2025-04-21T14:03:39.351150] [AS-112] [I] tbas: try to open file '+DS0/test01'(R) [2025-04-21T14:03:39.351585] [AS-112] [W] tbas: failed to open file '+DS0/test01'(R,rc=-20) [2025-04-21T14:03:39.351627] [FRM-112] [I] THROW. ec=ERROR_AS_NOFILE(-31004) [ The AS file, 'test01', does not exist. ] (sql_id:(null), sub_sql_id:(null), user:tibero, ap_module:(null), program:TAS_CLNT, host:NO_HOST) [as_msg.c:2848:process_tbas_open] [2025-04-21T14:03:39.355786] [AS-112] [I] tbas: try to open file '+DS0/test01/'(C) [2025-04-21T14:03:39.359152] [AS-112] [I] [DS#0] file#285 resized to 0 bytes [2025-04-21T14:03:39.359192] [AS-112] [I] [DS#0] file created: file#285,size 0 [2025-04-21T14:03:39.362126] [AS-112] [I] tbas: open file '+DS0/test01/'(C,rc=0)
[14:03]ASCMD +DS0> cd test01
[2025-04-21T14:04:18.695847] [AS-113] [I] tbas: try to open file '+DS0/test01'(R) [2025-04-21T14:04:18.696457] [AS-113] [W] tbas: failed to open file '+DS0/test01'(R,rc=-20) [2025-04-21T14:04:18.696499] [FRM-113] [I] THROW. ec=ERROR_AS_NOFILE(-31004) [ The AS file, 'test01', does not exist. ] (sql_id:(null), sub_sql_id:(null), user:tibero, ap_module:(null), program:TAS_CLNT, host:NO_HOST) [as_msg.c:2848:process_tbas_open] [2025-04-21T14:04:18.699695] [AS-112] [I] tbas: try to open file '+DS0/test01/'(R) [2025-04-21T14:04:18.703708] [AS-112] [I] tbas: open file '+DS0/test01/'(R,rc=0)

 

 

 

Related to