The error returned was no such file or directory - Исправление ошибок и поиск оптимальных решений проблем

включил перезапустил sql до момента паделия SQL сервера вот лог

Код

210624  6:15:40	    20 Connect	sql_satell@localhost as anonymous on satell
		    20 Query	SELECT VERSION() AS `version`
		    20 Query	SET NAMES utf8mb4
		    20 Query	SET NAMES 'utf8mb4'
		    20 Query	SELECT @@SESSION.sql_mode
		    20 Query	SET SESSION sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
		    20 Query	SELECT category, COUNT(*) AS count FROM dle_post WHERE approve=1 AND date < '2021-06-24 09:15:40' GROUP BY category
		    20 Query	SELECT * FROM dle_users WHERE user_id='1'
		    20 Query	SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:40' ORDER BY fixed desc, date DESC LIMIT 0,10
		    20 Query	SELECT COUNT(*) as count FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:40'
		    20 Query	SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE p.approve=1 AND p.date >= '2021-06-24 09:15:40' - INTERVAL 1 MONTH AND p.date < '2021-06-24 09:15:40' ORDER BY rating DESC, comm_num DESC, news_read DESC, date DESC LIMIT 0,10
		    20 Quit	
210624  6:15:41	    21 Connect	sql_satell@localhost as anonymous on satell
		    21 Query	SELECT VERSION() AS `version`
		    21 Query	SET NAMES utf8mb4
		    21 Query	SET NAMES 'utf8mb4'
		    21 Query	SELECT @@SESSION.sql_mode
		    21 Query	SET SESSION sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
		    21 Query	SELECT category, COUNT(*) AS count FROM dle_post WHERE approve=1 AND date < '2021-06-24 09:15:41' GROUP BY category
		    21 Query	SELECT * FROM dle_users WHERE user_id='1'
		    21 Query	SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:41' ORDER BY fixed desc, date DESC LIMIT 0,10
		    21 Query	SELECT COUNT(*) as count FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:41'
		    21 Query	SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE p.approve=1 AND p.date >= '2021-06-24 09:15:41' - INTERVAL 1 MONTH AND p.date < '2021-06-24 09:15:41' ORDER BY rating DESC, comm_num DESC, news_read DESC, date DESC LIMIT 0,10
		    21 Quit	
		    22 Connect	sql_satell@localhost as anonymous on satell
		    22 Query	SELECT VERSION() AS `version`
		    22 Query	SET NAMES utf8mb4
		    22 Query	SET NAMES 'utf8mb4'
		    22 Query	SELECT @@SESSION.sql_mode
		    22 Query	SET SESSION sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
		    22 Query	SELECT category, COUNT(*) AS count FROM dle_post WHERE approve=1 AND date < '2021-06-24 09:15:41' GROUP BY category
		    22 Query	SELECT * FROM dle_users WHERE user_id='1'
		    22 Query	SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:41' ORDER BY fixed desc, date DESC LIMIT 0,10
		    22 Query	SELECT COUNT(*) as count FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:41'
		    22 Query	SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE p.approve=1 AND p.date >= '2021-06-24 09:15:41' - INTERVAL 1 MONTH AND p.date < '2021-06-24 09:15:41' ORDER BY rating DESC, comm_num DESC, news_read DESC, date DESC LIMIT 0,10
		    22 Quit	
210624  6:15:42	    23 Connect	sql_satell@localhost as anonymous on satell
		    23 Query	SELECT VERSION() AS `version`
		    23 Query	SET NAMES utf8mb4
		    23 Query	SET NAMES 'utf8mb4'
		    23 Query	SELECT @@SESSION.sql_mode
		    23 Query	SET SESSION sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
		    23 Query	SELECT category, COUNT(*) AS count FROM dle_post WHERE approve=1 AND date < '2021-06-24 09:15:42' GROUP BY category
		    23 Query	SELECT * FROM dle_users WHERE user_id='1'
		    23 Query	SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:42' ORDER BY fixed desc, date DESC LIMIT 0,10
		    23 Query	SELECT COUNT(*) as count FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:42'
		    23 Query	SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE p.approve=1 AND p.date >= '2021-06-24 09:15:42' - INTERVAL 1 MONTH AND p.date < '2021-06-24 09:15:42' ORDER BY rating DESC, comm_num DESC, news_read DESC, date DESC LIMIT 0,10
		    23 Quit	
		    24 Connect	sql_satell@localhost as anonymous on satell
		    24 Query	SELECT VERSION() AS `version`
		    24 Query	SET NAMES utf8mb4
		    24 Query	SET NAMES 'utf8mb4'
		    24 Query	SELECT @@SESSION.sql_mode
		    24 Query	SET SESSION sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
		    24 Query	SELECT category, COUNT(*) AS count FROM dle_post WHERE approve=1 AND date < '2021-06-24 09:15:42' GROUP BY category
		    24 Query	SELECT * FROM dle_users WHERE user_id='1'
		    24 Query	SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:42' ORDER BY fixed desc, date DESC LIMIT 0,10
		    24 Query	SELECT COUNT(*) as count FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('1')) c ON (p.id=c.news_id) WHERE approve=1 AND date < '2021-06-24 09:15:42'
		    24 Query	SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) WHERE p.approve=1 AND p.date >= '2021-06-24 09:15:42' - INTERVAL 1 MONTH AND p.date < '2021-06-24 09:15:42' ORDER BY rating DESC, comm_num DESC, news_read DESC, date DESC LIMIT 0,10
		    24 Quit

Добавлено через 2 часа 31 минуту
нашол скрипт настройки ubunty
вот что выдал

Код

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /var/log/mysql/error.log file
    Add skip-innodb to MySQL configuration to disable InnoDB
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Reduce or eliminate unclosed connections and network issues
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
             See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
             (specially the conclusions at the bottom of the page).
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    Performance schema should be activated for better diagnostics
    Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
    Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB
    Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 1M, or use smaller result sets)
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    performance_schema = ON enable PFS
    innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.

как добавить skip-innodb в конфигурацию MySQL, чтобы отключить InnoDB ?

Источник

Knowledge Base

Home
Knowledge Base
Legacy Products (File-Only Backup)
File-Based Backup Errors
File Error: No such file or directory

You may see this error for two reasons. If the paths to the files look like normal Windows paths with a drive letter, such as “K:eSilo_SQL_Backupbackup.log No such file or directory” the problem is most likely on the client side.

In most cases, this simply indicates that the file or folder specified was a top-level item selected in the backup schedule and it did not exist at the time the backup ran. You can remove the item from the schedule by clicking the “Show Errors” link in the lower left corner of the Edit Backup Schedule pop-up box (Schedule >> Edit), selecting the items to remove and then clicking “Remove.”
In some cases, this error could be shown when the path of the specified file or folders exceeds 258 characters in length. The way to solve this is to reduce the length of the full path to the items specified, either by moving or renaming the file(s) and/or containing folders.

If the paths to the files look like POSIX paths, such as “/5714/Today/C Drive/AP Vendors No such file or directory” the problem is likely on the server side and indicates possible corruption in the database table(s) for this particular backup user. Contact eSilo Support (support@esilo.com) to have our engineers perform a full user check which should detect and resolve the problem.

Was this article helpful?

Page load link

Go to Top

Источник

I’ve downloaded a game (Shank) but the bin file doesn’t run. The error that is shown when I try to launch the executable is:

bash: ./shank-linux-120720110-1-bin: No such file or directory

asked May 7, 2012 at 19:06

FrancescoFrancesco

2,8612 gold badges13 silver badges12 bronze badges

You’re probably trying to run a 32-bit binary on a 64-bit system that doesn’t have 32-bit support installed.

There are three cases where you can get the message “No such file or directory”:

The file doesn’t exist. I presume you’ve checked that the file does exist (perhaps because the shell completes it).
There is a file by that name, but it’s a dangling symbolic link.
The file exists, and you can even read it (for example, the command file shank-linux-120720110-1-bin displays something like “ELF 32-bit LSB executable …”), and yet when you try to execute it you’re told that the file doesn’t exist.

The error message in this last case is admittedly confusing. What it’s telling you is that a key component of the runtime environment necessary to run the program is missing. Unfortunately, the channel through which the error is reported only has room for the error code and not for this extra information that it’s really the runtime environment that’s to blame. If you want the technical version of this explanation, read Getting “Not found” message when running a 32-bit binary on a 64-bit system.

The file command will tell you just what this binary is. With a few exceptions, you can only run a binary for the processor architecture that your release of Ubuntu is for. The main exception is that you can run 32-bit (x86, a.k.a. IA32) binaries on 64-bit (amd64, a.k.a. x86_64) systems.

In Ubuntu up to 11.04, to run a 32-bit binary on a 64-bit installation, you need to install the ia32-libs package . You may need to install additional libraries (you’ll get an explicit error message if you do).

Since 11.10 (oneiric) introduced multiarch support, you can still install ia32-libs, but you can choose a finer-grained approach, it’s enough to get libc6-i386 (plus any other necessary library).

answered May 7, 2012 at 21:47

64 bit Ubuntu Multiarch systems

Follow this answer only if the output of file file-name shows,

file-name: ELF 32-bit LSB  executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.8, not stripped

To run 32bit executable file in a 64 bit multi-arch Ubuntu system, you have to add i386 architecture and also you have to install libc6:i386,libncurses5:i386,libstdc++6:i386 these three library packages.

sudo dpkg --add-architecture i386
sudo apt-get update
sudo apt-get install libc6:i386 libncurses5:i386 libstdc++6:i386
./file-name

answered Apr 24, 2014 at 13:14

Avinash RajAvinash Raj

75.8k55 gold badges212 silver badges252 bronze badges

To expand on @Gilles answer, there are at least three scenarios resulting in this error:

The file doesn’t exist.
The file exists but is a dangling symbolic link.
The file exists (e.g. file command works), making for a puzzling error message. This may mean there’s a problem with the loader.

Categories of loader problems:

An executable’s loader does not exist. You can check this using the file command and see if the loader does exist. E.g.
```
file lmgrd
lmgrd: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked, interpreter /lib64/ld-lsb-x86-64.so.3, for GNU/Linux 2.6.18, stripped
```
Notice interpreter /lib64/ld-lsb-x86-64.so.3; if this file does not exist, you need to install it. For this particular loader on 16.04, the answer turned out to be sudo apt-get install lsb.
Issues with a script’s loader (see this answer).
Missing shared libraries — use ldd <file-name> to check for any «not found» libraries. See this answer for more info.

The loader not existing could be due to a 32/64 bit mismatch or some other reason. There might be other kinds of loader errors I don’t know about.

answered May 11, 2018 at 18:54

jtpereydajtpereyda

1,9753 gold badges18 silver badges21 bronze badges

Here’s a transcript showing a bit more about the nature of the problem, and how to fix it as of Ubuntu 16.04. Notice that even though file reports «dynamically linked», ldd reports «not a dynamic executable».

$ ./myprogram
bash: myprogram: No such file or directory

$ file myprogram
myprogram: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked, interpreter /lib/ld-linux.so.2, for GNU/Linux 2.2.5, not stripped

$ ldd myprogram
    not a dynamic executable

Once you install libc6:i386, things start improving…

$ sudo apt-get install libc6:i386 # the initial fix
...

$ ldd myprogram
    linux-gate.so.1 =>  (0xf77fd000)
    libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf7626000)
    /lib/ld-linux.so.2 (0x56578000)

$ ./myprogram
myprogram: error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory

To complete the job, you may need to identify and install additional libraries one at a time…

$ sudo apt-get install libstdc++6:i386 ## may require various additional libs

$ ./myprogram
... works correctly ...

I don’t know if there is a systematic way of identifying the correct libraries to install. There is a bit of guesswork mapping the error messages to package names (tab completion helps).

answered Jun 8, 2016 at 20:57

Brent BradburnBrent Bradburn

2,6962 gold badges28 silver badges35 bronze badges

By installing the deb for 32 bit I realized I was missing some libraries (in addition to ia32-libs and libc6). I first solved this problem by giving this command:

sudo apt-get install -f

Then I got another error:

Message: SDL_GL_LoadLibrary 
Error: Failed loading libGL.so.1

Obviously, these libraries were properly installed. Without going into details I had to link the libraries by hand. I realized then that could also an easier solution through Synaptic install the following packages:

libgl1-mesa-glx:i386
libgl1-mesa-dri: i386.

After that the next problem was the black screen while playing, which I solved by replacing the executable in /Shank/bin with this:
http://treefort.icculus.org/smb/smb-linux-mesa-hotfix-test.tar.bz2.

I hope it will be useful to someone.
If you need more help or more details please feel free to contact me.

kiri

27k16 gold badges79 silver badges115 bronze badges

answered May 9, 2012 at 19:12

FrancescoFrancesco

2,8612 gold badges13 silver badges12 bronze badges

This error happens when working on Windows (which introduces extra characters because of different line separator than Linux system) and trying to run this script (with extra characters inserted) in Linux. The error message is misleading.

In Windows, the line separator is CRLF (rn) whereas in linux it is LF (n). In my case, this happened due to working on Windows and uploading to Unix server for execution.

answered Jan 24, 2020 at 2:55

PALENPALEN

1,0731 gold badge8 silver badges6 bronze badges

Google navigated me to this page. My issue was distantly related to the title of this thread, so I am posting it here for the future visitors like me:

It is one of the weirdest issues:

$ ls -lh
ls: cannot access .~dataprep.ipynb: No such file or directory
-????????? ? ?      ?           ?            ? .~dataprep.ipynb
-rw------- 1 tgowda mygroup 475K Jun 12 15:59 dataprep.ipynb

I see that the file .~dataprep.ipynb is right there with some weird ?? permissions.
I just wanted to get rid of that messed up file.
rm command could not remove it. mv command couldn’t move it.

And then…

$ python
>>> from pathlib import Path
>>> list(Path('.').glob("*.ipynb"))
[PosixPath('.~dataprep.ipynb'), PosixPath('dataprep.ipynb')]
>>> p = list(Path('.').glob("*.ipynb"))[0]
>>> p
PosixPath('.~dataprep.ipynb')
>>> p.unlink()
>>> list(Path('.').glob("*.ipynb"))
[PosixPath('dataprep.ipynb')]

And that’s how I was able to defeat it.

answered Jun 13, 2020 at 3:36

None of the above answers worked for me because there was a miss-resolving for the interpreter.

I have written a detailed answer here, explaining how to fix this issue.

Thanks to this man who shared his experience with others solution here.
thanks to him i was able to solve this problem.

To summarize, as @steeldriver though, there was an interpreter problem.
the linker is giving to my program [/lib/ld64.so.1] as ELF interpreter but this path doesnt exist at all and i checked it by:
> ls /lib/ld64.so.1
ls: cannot access '/lib/ld64.so.1': No such file or directory
After that, i checked the interpreters path’s on my ubuntu installation by:
> ls /lib64/ld-*
/lib64/ld-linux-x86-64.so.2  /lib64/ld-lsb-x86-64.so.2  /lib64/ld-lsb-x86-64.so.3
so the solution is to create a link of one of this interpreters to the inexistant interpreter path by:
sudo ln -s /lib64/ld-linux-x86-64.so.2 /lib/ld64.so.1
Now we re-check the inexistent interpreter one more time to see if its still inexisting or not:
> ls /lib/ld64.so.1
/lib/ld64.so.1
Now this command has returned /lib/ld64.so.1 instead of «inexistant file». so the problem was solved and i could run ./main successfully

So, in a summary, you have to create a link of one of this interpreters to the inexistant interpreter path by running the following command in a terminal (Ctrl + Alt + T) :

sudo ln -s /lib64/ld-linux-x86-64.so.2 /lib/ld64.so.1

answered Jan 28, 2022 at 21:06

Источник

Knowledge Base

Was this article helpful?

Related Articles

64 bit Ubuntu Multiarch systems