| 2023-05-30 17:13:14 |
Bryce Harrington |
description |
my MySQL workbench doesn't work properly ,there is no root server
ProblemType: Package
DistroRelease: Ubuntu 22.04
Package: mysql-server-8.0 8.0.33-0ubuntu0.22.04.2
ProcVersionSignature: Ubuntu 5.19.0-42.43~22.04.1-generic 5.19.17
Uname: Linux 5.19.0-42-generic x86_64
ApportVersion: 2.20.11-0ubuntu82.4
AptOrdering:
mysql-server-8.0:amd64: Install
mysql-server-core-8.0:amd64: Install
NULL: ConfigurePending
Architecture: amd64
CasperMD5CheckResult: pass
Date: Fri May 26 13:15:03 2023
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2022-10-08 (229 days ago)
InstallationMedia: Ubuntu 22.04.1 LTS "Jammy Jellyfish" - Release amd64 (20220809.1)
Logs.var.log.daemon.log:
MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.etc.mysql.my.cnf: my.cnf links to /etc/mysql/mysql.cnf
MySQLVarLibDirListing: ['#innodb_temp', 'binlog.000005', 'mysql', 'performance_schema', 'auto.cnf', 'ca-key.pem', 'asus-vivobook.pid', 'undo_002', '#ib_16384_1.dblwr', 'ib_buffer_pool', 'undo_001', 'server-cert.pem', 'binlog.000003', 'sys', 'binlog.000004', 'binlog.000008', 'ibdata1', 'ca.pem', 'mysql_upgrade_info', 'public_key.pem', 'client-cert.pem', '#ib_16384_0.dblwr', 'binlog.000006', 'debian-5.7.flag', '#innodb_redo', 'ibtmp1', 'server-key.pem', 'binlog.index', 'binlog.000007', 'private_key.pem', 'mysql.ibd', 'binlog.000011', 'binlog.000009', 'client-key.pem', 'mulearn', 'binlog.000010']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.19.0-42-generic root=UUID=78aa3916-a8e1-4145-9d65-5c8941b81424 ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.10, Python 3.10.6, python3-minimal, 3.10.6-1~22.04
PythonDetails: N/A
RelatedPackageVersions:
dpkg 1.21.1ubuntu2.1
apt 2.4.8
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.33-0ubuntu0.22.04.2 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install) |
my MySQL workbench doesn't work properly ,there is no root server
ProblemType: Package
DistroRelease: Ubuntu 22.04
Package: mysql-server-8.0 8.0.33-0ubuntu0.22.04.2
ProcVersionSignature: Ubuntu 5.19.0-42.43~22.04.1-generic 5.19.17
Uname: Linux 5.19.0-42-generic x86_64
ApportVersion: 2.20.11-0ubuntu82.4
AptOrdering:
mysql-server-8.0:amd64: Install
mysql-server-core-8.0:amd64: Install
NULL: ConfigurePending
Architecture: amd64
CasperMD5CheckResult: pass
Date: Fri May 26 13:15:03 2023
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2022-10-08 (229 days ago)
InstallationMedia: Ubuntu 22.04.1 LTS "Jammy Jellyfish" - Release amd64 (20220809.1)
Logs.var.log.daemon.log:
MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.etc.mysql.my.cnf: my.cnf links to /etc/mysql/mysql.cnf
MySQLVarLibDirListing: ['#innodb_temp', 'binlog.000005', 'mysql', 'performance_schema', 'auto.cnf', 'ca-key.pem', 'asus-vivobook.pid', 'undo_002', '#ib_16384_1.dblwr', 'ib_buffer_pool', 'undo_001', 'server-cert.pem', 'binlog.000003', 'sys', 'binlog.000004', 'binlog.000008', 'ibdata1', 'ca.pem', 'mysql_upgrade_info', 'public_key.pem', 'client-cert.pem', '#ib_16384_0.dblwr', 'binlog.000006', 'debian-5.7.flag', '#innodb_redo', 'ibtmp1', 'server-key.pem', 'binlog.index', 'binlog.000007', 'private_key.pem', 'mysql.ibd', 'binlog.000011', 'binlog.000009', 'client-key.pem', 'mulearn', 'binlog.000010']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.19.0-42-generic root=UUID=78aa3916-a8e1-4145-9d65-5c8941b81424 ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.10, Python 3.10.6, python3-minimal, 3.10.6-1~22.04
PythonDetails: N/A
RelatedPackageVersions:
dpkg 1.21.1ubuntu2.1
apt 2.4.8
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.33-0ubuntu0.22.04.2 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)
[DpkgTerminalLog]
Preparing to unpack .../mysql-server-8.0_8.0.33-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-server-8.0 (8.0.33-0ubuntu0.22.04.2) over (8.0.32-0ubuntu0.22.04.2) ...
Preparing to unpack .../mysql-server-core-8.0_8.0.33-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-server-core-8.0 (8.0.33-0ubuntu0.22.04.2) over (8.0.32-0ubuntu0.22.04.2) ...
Setting up mysql-server-core-8.0 (8.0.33-0ubuntu0.22.04.2) ...
Setting up mysql-server-8.0 (8.0.33-0ubuntu0.22.04.2) ...
mysqld will log errors to /var/log/mysql/error.log
mysqld is running as pid 38112
Failed to restart mysql.service: Transaction for mysql.service/restart is destructive (systemd-tmpfiles-setup.service has 'stop' job queued, but 'start' is included in transaction).
See system logs and 'systemctl status mysql.service' for details.
invoke-rc.d: initscript mysql, action "restart" failed.
○ mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: inactive (dead) since Fri 2023-05-26 13:02:05 IST; 12min ago
Main PID: 1060 (code=exited, status=0/SUCCESS)
Status: "Server shutdown complete"
CPU: 8min 33.535s
May 20 21:58:13 asus-vivobook systemd[1]: Starting MySQL Community Server...
May 20 21:59:03 asus-vivobook systemd[1]: Started MySQL Community Server.
May 26 13:01:45 asus-vivobook systemd[1]: Stopping MySQL Community Server...
May 26 13:02:05 asus-vivobook systemd[1]: mysql.service: Deactivated successfully.
May 26 13:02:05 asus-vivobook systemd[1]: Stopped MySQL Community Server.
May 26 13:02:05 asus-vivobook systemd[1]: mysql.service: Consumed 8min 33.535s CPU time.
dpkg: error processing package mysql-server-8.0 (--configure):
installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 |
|
