Document Type | Troubleshooting
Category | Administration
Applicable Product Version | 7FS02PS
Document Number | TADTS039
Issue
This explains the phenomenon where tbsql cannot be accessed after a normal boot, and errors are continuously logged in slog.
The error code recorded in slog is as follows.
network_recv_fd: Invalid fd info from listener
Cause
During Tibero boot, a procedure is performed to compare the maximum number of file descriptors (fd) that the current process can open with the number of fds that Tibero needs to use.
At this time, since the maximum number of fds that the process can open was less than the number of fds required by Tibero, a warning message was output to slog.
Solutions
Set the nofile value appropriately for the user in the limits.conf file.
1. Check nofile
[tibero@centro1 ~]$ ulimit -aH core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 14770 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 65536 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 65536 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited [tibero@centro1 ~]$ ulimit -aS core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 14770 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 16384 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 16384 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
2. Configure limits.conf (root privileges)
tibero soft nproc 16384 tibero hard nproc 65536 tibero soft nofile 16384 tibero hard nofile 65536
If the hard limit is sufficient, you can increase the soft limit for the user without root privileges.
However, since this applies only to the current session's number of fds, you must increase the limits.conf file as shown above.
ulimit -Sn [desired_value]