maria-discuss team mailing list archive

[Jogchum Reitsma <jogchum.reitsma@xxxxxxxxx>]

Op 08-11-2022 om 13:04 schreef Marko Mäkelä:
> Hi Jogchum,
>
> On Tue, Nov 8, 2022 at 1:21 PM Jogchum Reitsma
> <jogchum.reitsma@xxxxxxxxx>  wrote:
> [...]
> > 2022-11-08 12:06:17 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
> > (repeated several times)
> > 2022-11-08 12:06:17 0 [ERROR] /usr/local/mariadb-10.6.10-linux-systemd-x86_64/bin/mariadbd: unknown option '--skip-locking'
> > 2022-11-08 12:06:17 0 [ERROR] Aborting
> Was that the end of the output? No shutdown message from InnoDB, like this?
>
> 2022-11-08 14:03:03 0 [Note] InnoDB: Shutdown completed; log sequence
> number 2150107; transaction id 3085
>
> If there was no output like that, you should remove any line that says
> "skip_locking" or "skip-locking" from the configuration file and
> retry.
>
> Marko

Yes, that was indeed the end of the output.

The skip-locking statement was not in /etc/my.cnf, but inmy.cnf in my 
home dir. Commented it out and now this complaint disappeared.

But now I get

####################################################################

2022-11-08 13:37:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-11-08 13:37:32 0 [Note] InnoDB: Number of pools: 1
2022-11-08 13:37:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-11-08 13:37:32 0 [Note] InnoDB: Using Linux native AIO
2022-11-08 13:37:32 0 [Note] InnoDB: Initializing buffer pool, total 
size = 134217728, chunk size = 134217728
2022-11-08 13:37:32 0 [Note] InnoDB: Completed initialization of buffer 
pool
2022-11-08 13:37:32 0 [Note] InnoDB: 128 rollback segments are active.
2022-11-08 13:37:32 0 [Note] InnoDB: Creating shared tablespace for 
temporary tables
2022-11-08 13:37:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 
MB. Physically writing the file full; Please wait ...
2022-11-08 13:37:32 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-11-08 13:37:32 0 [Note] InnoDB: 10.6.10 started; log sequence 
number 578191791; transaction id 2935782
2022-11-08 13:37:32 0 [Note] InnoDB: Loading buffer pool(s) from 
/home/jogchum/mysql/ib_buffer_pool
2022-11-08 13:37:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-11-08 13:37:32 0 [Warning] 'innodb-file-format' was removed. It 
does nothing now and exists only for compatibility with old my.cnf files.
2022-11-08 13:37:33 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-11-08 13:37:33 0 [ERROR] Can't start server : Bind on unix socket: 
No such file or directory
2022-11-08 13:37:33 0 [ERROR] Do you already have another server running 
on socket: /var/run/mysql/mysql.sock ?
2022-11-08 13:37:33 0 [ERROR] Aborting
Warning: Memory not freed: 280

##########################################################################

(again no further output).

/var/run/mysql/mysql.sock odoes not exeist, and "pgrep mariadbd", "pgrep 
mysql" and "pgrep mysqld" show nothing, so no serer is running anymore.

ss -a | grep 3306 or
ss -a | grep /var/run/mysql

also gives nothing, so it seems there are no processes using that port.

We're getting closer it seems, but not quite there yet...

regards, Jogchum