Hi Tim, It seems you haven't initialized the system tables like explained here: https://mariadb.com/kb/en/mysql_install_db/
Regards -GL Le ven. 30 déc. 2022, 03:32, Tim McConnell <tmcconnell...@gmail.com> a écrit : > Hello list, > I have installed and re-installed MariaDB trying to get prelude to work > and I'm at a loss. > When I try to run 'sudo systemctl start mariadb.service' I get these > errors: > Job for mariadb.service failed because the control process exited with > error code. > See "systemctl status mariadb.service" and "journalctl -xeu > mariadb.service" for details. > so I read the KB and found I'm supposed to use 'sudo systemctl status > mariadb.socket' > which gives this: > ● mariadb.socket - MariaDB 10.6.11 database server (socket activation) > Loaded: loaded (/lib/systemd/system/mariadb.socket; static) > Active: active (listening) since Thu 2022-12-29 18:39:25 CST; 26s ago > Until: Thu 2022-12-29 18:39:25 CST; 26s ago > Triggers: ● mariadb.service > Docs: man:mariadbd(8) > https://mariadb.com/kb/en/library/systemd/ > Listen: @mariadb (Stream) > /run/mysqld/mysqld.sock (Stream) > [::]:3306 (Stream) > Tasks: 0 (limit: 8190) > Memory: 4.0K > CPU: 2ms > CGroup: /system.slice/mariadb.socket > > and then if I try to run 'sudo mysqlcheck -A' I'll get this error: > mysqlcheck: Got error: 2013: Lost connection to server at 'handshake: > reading initial communication packet', system error: 104 when trying to > connect > > I then check the status of the socket and get this output: > sudo systemctl status mariadb.socket > × mariadb.socket - MariaDB 10.6.11 database server (socket activation) > Loaded: loaded (/lib/systemd/system/mariadb.socket; static) > Active: failed (Result: service-start-limit-hit) since Thu 2022-12-29 18:4> > Duration: 1min 11.173s > Triggers: ● mariadb.service > Docs: man:mariadbd(8) > https://mariadb.com/kb/en/library/systemd/ > Listen: @mariadb (Stream) > /run/mysqld/mysqld.sock (Stream) > [::]:3306 (Stream) > CPU: 2ms > > I then ran 'sudo journalctl -n 20 -u mariadb.service' (as per the kb) and > get: > Dec 29 19:12:45 DebianTim mariadbd[3660996]: 2022-12-29 19:12:45 0 [Note] > /usr/sbin/mariadbd (server 10.6.11-MariaDB-1) starting as process 3660996 > ... > Dec 29 19:12:45 DebianTim systemd[1]: mariadb.service: Main process > exited, code=exited, status=1/FAILURE > Dec 29 19:12:45 DebianTim systemd[1]: mariadb.service: Failed with result > 'exit-code'. > Dec 29 19:12:45 DebianTim systemd[1]: Failed to start MariaDB 10.6.11 > database server. > > I then found this in my logs: > 2022-12-29 19:12:45 0 [Warning] Plugin 'OQGRAPH' is of maturity level > gamma while the server is stable > 2022-12-29 19:12:45 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 > 2022-12-29 19:12:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 > 2022-12-29 19:12:45 0 [Note] InnoDB: Number of pools: 1 > 2022-12-29 19:12:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions > 2022-12-29 19:12:45 0 [Note] InnoDB: Using liburing > 2022-12-29 19:12:45 0 [Note] InnoDB: Initializing buffer pool, total size > = 134217728, chunk size = 134217728 > 2022-12-29 19:12:45 0 [Note] InnoDB: Completed initialization of buffer > pool > 2022-12-29 19:12:45 0 [Note] InnoDB: 128 rollback segments are active. > 2022-12-29 19:12:45 0 [Note] InnoDB: Creating shared tablespace for > temporary tables > 2022-12-29 19:12:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 > MB. Physically writing the file full; Please wait ... > 2022-12-29 19:12:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. > 2022-12-29 19:12:45 0 [Note] InnoDB: 10.6.11 started; log sequence number > 33836; transaction id 4 > 2022-12-29 19:12:45 0 [Note] Plugin 'FEEDBACK' is disabled. > 2022-12-29 19:12:45 0 [Note] InnoDB: Loading buffer pool(s) from > /var/lib/mysql/ib_buffer_pool > 2022-12-29 19:12:45 0 [ERROR] Could not open mysql.plugin table: "Table > 'mysql.plugin' doesn't exist". Some plugins may be not loaded > 2022-12-29 19:12:45 0 [Note] InnoDB: Buffer pool(s) load completed at > 221229 19:12:45 > 2022-12-29 19:12:45 0 [Warning] You need to use --log-bin to make > --expire-logs-days or --binlog-expire-logs-seconds work. > 2022-12-29 19:12:45 0 [ERROR] Can't open and lock privilege tables: Table > 'mysql.servers' doesn't exist > 2022-12-29 19:12:45 0 [Note] Using systemd activated socket host :: port > 3306 > 2022-12-29 19:12:45 0 [Note] Using systemd activated unix socket > /run/mysqld/mysqld.sock > 2022-12-29 19:12:45 0 [Note] Using systemd activated unix socket @mariadb > 2022-12-29 19:12:45 0 [ERROR] Fatal error: Can't open and lock privilege > tables: Table 'mysql.db' doesn't exist > 2022-12-29 19:12:45 0 [ERROR] Aborting > Warning: Memory not freed: 280 > > So, how do I get this to work? > I even tried the apparmor suggestion from the KB and it didn't work, I > even tried stopping apparmor service completely and still couldn't get it > to work. > I'm using Debian testing (Bookworm) with Kernel version 6.0.0-6-amd64 #1 > SMP PREEMPT_DYNAMIC Debian 6.0.12-1 (2022-12-09) x86_64 GNU/Linux > and MariaDB 10.6.11 from the Debian repository. > > Thanks in advance for any help. > > -- > > Tim McConnell <tmcconnell...@gmail.com> > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
