включил перезапустил 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 ?
0
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?
Related Articles
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
7
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-bindisplays 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
9
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
4
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.
filecommand 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, strippedNotice
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 besudo 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
4
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
1
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
2
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 directoryAfter 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.3so 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.1Now 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.1Now 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
3