MySQL not start
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mysqld: File './binlog.001513' not found [#bf66afe3] 202...
またまたportupgrade したら、mysql が起動しなくなった。
ログ /var/db/mysql/[FQDN].err には、
mysqld: File './binlog.001513' not found
とあり、たしかに、/var/db/mysql/binlog.001513 というファ...
このファイルの存在は、/var/db/mysql/binlog.index に記述...
./binlog.001507
./binlog.001509
./binlog.001510
./binlog.001511
./binlog.001512
./binlog.001513 ← 消去
*portupgrade -ar --batch && reboot [#f9ca3f43]
ports をいつもの如くアップグレードしたところ、Nextcloudが...
同時に、というか、おもむろにw
/usr/bin/su -m www -c "php /usr/local/www/nextcloud/occ ...
すると、
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the da...
Stack trace:
#0 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/D...
#1 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/D...
#2 /usr/local/www/nextcloud/lib/private/DB/Connection.ph...
#3 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/D...
#4 /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/...
#5 /usr/local/www/nextcloud/lib/private/AppConfig.php(34...
#6 /usr/local/www/nextcloud/lib/private/AppConfig.php(11...
#7 /usr/local/www/nextcloud/lib/private/AppConfig.php(30...
#8 /usr/local/www/nextcloud/lib/private/legacy/OC_App.ph...
#9 /usr/local/www/nextcloud/lib/private/Server.php(668):...
#10 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#11 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/...
#12 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#13 /usr/local/www/nextcloud/lib/private/ServerContainer...
#14 /usr/local/www/nextcloud/lib/private/Server.php(1677...
#15 /usr/local/www/nextcloud/lib/private/Server.php(1017...
#16 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#17 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/...
#18 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#19 /usr/local/www/nextcloud/lib/private/ServerContainer...
#20 /usr/local/www/nextcloud/lib/private/Server.php(1977...
#21 /usr/local/www/nextcloud/lib/private/Files/View.php(...
#22 /usr/local/www/nextcloud/lib/private/Server.php(395)...
#23 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#24 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/...
#25 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#26 /usr/local/www/nextcloud/lib/private/ServerContainer...
#27 /usr/local/www/nextcloud/lib/private/Server.php(1324...
#28 /usr/local/www/nextcloud/lib/base.php(595): OC\Serve...
#29 /usr/local/www/nextcloud/lib/base.php(1091): OC::ini...
#30 /usr/local/www/nextcloud/console.php(49): require_on...
#31 /usr/local/www/nextcloud/occ(11): require_once('/usr...
#32 {main}mysql not running? (check /var/db/mysql/sun1.s...
と、既視感の有るスタックトレースが・・・
原因は、サーバ再起動時にMySQLが起動に失敗したために、DBに...
MySQLのログを見ると、
/var/db/mysql/[FQDN].err
[ERROR] [MY-010276] [Server] Unix socket lock file is em...
[ERROR] [MY-010268] [Server] Unable to setup unix socket...
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/local/libexec/mysqld:...
とのことなので、
/tmp
mysql.sock.lock
mysqlx.sock.lock
mysqlx.sock
これらを、
mysql.sock.lock_
mysqlx.sock.lock_
mysqlx.sock_
と改名して、
# /usr/local/etc/rc.d/mysql-server start
で、無事起動。
# ps aux | grep mysql
mysql 62251 11.0 6.8 2252388 560460 - S 13:52 ...
mysql 59251 0.0 0.0 13624 3044 - Is 13:52 ...
root 72447 0.0 0.0 12868 2372 3 S+ 13:53 ...
----
Total access &counter(total);:本日 &counter(today);:昨...
#counter([total|today|yesterday]);
終了行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mysqld: File './binlog.001513' not found [#bf66afe3] 202...
またまたportupgrade したら、mysql が起動しなくなった。
ログ /var/db/mysql/[FQDN].err には、
mysqld: File './binlog.001513' not found
とあり、たしかに、/var/db/mysql/binlog.001513 というファ...
このファイルの存在は、/var/db/mysql/binlog.index に記述...
./binlog.001507
./binlog.001509
./binlog.001510
./binlog.001511
./binlog.001512
./binlog.001513 ← 消去
*portupgrade -ar --batch && reboot [#f9ca3f43]
ports をいつもの如くアップグレードしたところ、Nextcloudが...
同時に、というか、おもむろにw
/usr/bin/su -m www -c "php /usr/local/www/nextcloud/occ ...
すると、
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the da...
Stack trace:
#0 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/D...
#1 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/D...
#2 /usr/local/www/nextcloud/lib/private/DB/Connection.ph...
#3 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/D...
#4 /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/...
#5 /usr/local/www/nextcloud/lib/private/AppConfig.php(34...
#6 /usr/local/www/nextcloud/lib/private/AppConfig.php(11...
#7 /usr/local/www/nextcloud/lib/private/AppConfig.php(30...
#8 /usr/local/www/nextcloud/lib/private/legacy/OC_App.ph...
#9 /usr/local/www/nextcloud/lib/private/Server.php(668):...
#10 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#11 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/...
#12 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#13 /usr/local/www/nextcloud/lib/private/ServerContainer...
#14 /usr/local/www/nextcloud/lib/private/Server.php(1677...
#15 /usr/local/www/nextcloud/lib/private/Server.php(1017...
#16 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#17 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/...
#18 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#19 /usr/local/www/nextcloud/lib/private/ServerContainer...
#20 /usr/local/www/nextcloud/lib/private/Server.php(1977...
#21 /usr/local/www/nextcloud/lib/private/Files/View.php(...
#22 /usr/local/www/nextcloud/lib/private/Server.php(395)...
#23 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#24 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/...
#25 /usr/local/www/nextcloud/lib/private/AppFramework/Ut...
#26 /usr/local/www/nextcloud/lib/private/ServerContainer...
#27 /usr/local/www/nextcloud/lib/private/Server.php(1324...
#28 /usr/local/www/nextcloud/lib/base.php(595): OC\Serve...
#29 /usr/local/www/nextcloud/lib/base.php(1091): OC::ini...
#30 /usr/local/www/nextcloud/console.php(49): require_on...
#31 /usr/local/www/nextcloud/occ(11): require_once('/usr...
#32 {main}mysql not running? (check /var/db/mysql/sun1.s...
と、既視感の有るスタックトレースが・・・
原因は、サーバ再起動時にMySQLが起動に失敗したために、DBに...
MySQLのログを見ると、
/var/db/mysql/[FQDN].err
[ERROR] [MY-010276] [Server] Unix socket lock file is em...
[ERROR] [MY-010268] [Server] Unable to setup unix socket...
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/local/libexec/mysqld:...
とのことなので、
/tmp
mysql.sock.lock
mysqlx.sock.lock
mysqlx.sock
これらを、
mysql.sock.lock_
mysqlx.sock.lock_
mysqlx.sock_
と改名して、
# /usr/local/etc/rc.d/mysql-server start
で、無事起動。
# ps aux | grep mysql
mysql 62251 11.0 6.8 2252388 560460 - S 13:52 ...
mysql 59251 0.0 0.0 13624 3044 - Is 13:52 ...
root 72447 0.0 0.0 12868 2372 3 S+ 13:53 ...
----
Total access &counter(total);:本日 &counter(today);:昨...
#counter([total|today|yesterday]);
ページ名: