[Support] Linuxserver.io - MariaDB

[DrSiva2022]

On 7/21/2023 at 6:43 PM, jademonkee said:

FWIW, I copied all the .err files to a new directory (just in case), I then deleted all of them except the one listed in the logs at start-up.

I then renamed the active log file to <filename>.err.old

I then logged into the mysql console by opening the mariadb console via the Unraid GUI, then issuing the command:

mysql -uroot -p

As per https://mariadb.com/kb/en/flush/, I then issued the command to close and reopen the .err file (basically recreate it)

flush error logs;

Now the .err file is KB in size, and I have recovered 3GB of space on the cache drive by clearing the errors that have been accumulating for a couple years now.

Fingers crossed I haven't messed anything up!

 

tried and this is the result :

 

root@a5ca99f8f429:/# mysql -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
root@a5ca99f8f429:/# 

 

[jademonkee]

1 hour ago, DrSiva2022 said:

 

tried and this is the result :

 

root@a5ca99f8f429:/# mysql -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
root@a5ca99f8f429:/# 

 

Sorry, I don't know what that error means.

LS.io no longer offer support through this forum, instead offering it through their Discord, so maybe try there.

[DrSiva2022]

ok i moved all .err and ib_xyz files to a folder and restarted mariadb.

 

Now its not logging that much error . but logs like this

 

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    99
User GID:    100
───────────────────────────────────────

[custom-init] No custom files found, skipping...
UMASK corrected from 022 to 0640 ...
230810 15:19:07 mysqld_safe Logging to '/config/databases/1ea560a3a27c.err'.
230810 15:19:07 mysqld_safe Starting mariadbd daemon with databases from /config/databases
[ls.io-init] done.

 

 

when you go into 1ea...... .err file . this is what is inside

 

230810 15:19:07 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2023-08-10 15:19:07 0 [Note] Starting MariaDB 10.6.13-MariaDB-log source revision a24f2bb50ba4a!!!!!!!!d584937f36 as process 363
2023-08-10 15:19:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-08-10 15:19:07 0 [Note] InnoDB: Number of pools: 1
2023-08-10 15:19:07 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-08-10 15:19:07 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2023-08-10 15:19:07 0 [Note] InnoDB: Using Linux native AIO
2023-08-10 15:19:07 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2023-08-10 15:19:07 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-10 15:19:07 0 [Note] InnoDB: 128 rollback segments are active.
2023-08-10 15:19:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-10 15:19:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-10 15:19:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-08-10 15:19:07 0 [Note] InnoDB: 10.6.13 started; log sequence number 33112; transaction id 4
2023-08-10 15:19:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-10 15:19:07 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2023-08-10 15:19:07 0 [Note] InnoDB: Buffer pool(s) load completed at 230810 15:19:07
2023-08-10 15:19:07 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2023-08-10 15:19:07 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-08-10 15:19:07 0 [Note] Server socket created on IP: '::'.
2023-08-10 15:19:07 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).
2023-08-10 15:19:07 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2023-08-10 15:19:07 2 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2023-08-10 15:19:07 0 [Note] /usr/bin/mariadbd: ready for connections.
Version: '10.6.13-MariaDB-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server
2023-08-10 15:19:08 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
2023-08-10 15:19:08 5 [Warning] Access denied for user 'root'@'localhost' (using password: YES)

 

[DrSiva2022]

Pls someone help...

[xjp99]

Noob here. I installed nextcloud using spaceinvaderone's tutorial and it has been running fine for like 2 years. I decided to add some drives and a second parity. That was accomplished without fault. Or so I thought. When I restarted everything all the apps were not there. I had to reinstall them by going to the "previous installed" tab. 

 

Now I get this error from mariadb:

 

cp: not replacing '/config/custom.cnf'
[custom-init] No custom files found, skipping...
230820 08:40:26 mysqld_safe Logging to '/config/databases/b9c1c3db04f5.err'.
230820 08:40:26 mysqld_safe Starting mariadbd daemon with databases from /config/databases

 

I tried searching the interwebs for instructions but couldn't find anything. Not sure where to turn to next. 

 

Thanks.

 

[Archonw]

What is inside '/config/databases/b9c1c3db04f5.err
It should be under your appdata/mariadb folder.


Gesendet von meinem Pixel 6 Pro mit Tapatalk

[xjp99]

39 minutes ago, Archonw said:

What is inside '/config/databases/b9c1c3db04f5.err
It should be under your appdata/mariadb folder.


Gesendet von meinem Pixel 6 Pro mit Tapatalk
 

[Goldmaster]

how can i see the number of user accounts on mariadb? i have tried running SELECT User FROM mysql.user; but comes back as ERROR 1142 (42000): SELECT command denied to user. I will ask if it's possible to change username of an account to something else? Please.

[PantThrower]

Firstly I am very much a beginner with this so this may be a stupid query.

 

I updated the dockers for Swag, MariaDB and Nextcloud. Since then Nextcloud has been stuck in maintenance mode with the below log:

 

In ExceptionConverter.php line 117:

   An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_external_config' doesn't exist in engine

In Exception.php line 28:

    SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_external_config' doesn't exist in engine

In Connection.php line 71:

     SQLSTATE[42S02]: Base table or view not found: 1932 Table 'nextcloud.oc_external_config' doesn't exist in engine

 

I then looked in the MariaDB log and it wanted me to run a manual update via the consol. I ran the update and got the following in the MariaDB log:

MariaDB upgrade log:
Error    : Table 'nextcloud.oc_external_applicable' doesn't exist in engine
status   : Operation failed
nextcloud.oc_external_config
Error    : Table 'nextcloud.oc_external_config' doesn't exist in engine
status   : Operation failed
nextcloud.oc_external_mounts
Error    : Table 'nextcloud.oc_external_mounts' doesn't exist in engine
status   : Operation failed
nextcloud.oc_external_options
Error    : Table 'nextcloud.oc_external_options' doesn't exist in engine
status   : Operation failed
nextcloud.oc_files_metadata
Error    : Table 'nextcloud.oc_files_metadata' doesn't exist in engine
status   : Operation failed
nextcloud.oc_files_metadata_index
Error    : Table 'nextcloud.oc_files_metadata_index' doesn't exist in engine
status   : Operation failed
nextcloud.oc_onlyoffice_filekey
Error    : Table 'nextcloud.oc_onlyoffice_filekey' doesn't exist in engine
status   : Operation failed
nextcloud.oc_text2image_tasks
Error    : Table 'nextcloud.oc_text2image_tasks' doesn't exist in engine
status   : Operation failed
Phase 7/8: uninstalling plugins
Phase 8/8: Running 'FLUSH PRIVILEGES'
 

I have asked in the Nextcloud forum and the opinion there is that it is likely a database issue.

 

I haven't lost any of the date but it appears that several nextcloud tables have gone missing after the update. Can anyone help on how I can resolve this?

 

Thanks in advance

[FooYoungHi]

I'm having a similar issue to the person above, but only with "oc_files_versions".

 

Piece from my post in the Nextcloud topic:

Upon checking the database with adminer, I see that the table exists, but it doesn´t have the 'InnoDB' engine, it's blank. The same with the 'collation' column. The rest of the columns have the value: "?".

If I click on the table, I also get the error that it doesn't exist in this engine. This way I can´t manually try to fix the table.

Due to this I can´t create a backup of the database, since it gives me an error. I've tried to 'occ upgrade' in the nextcloud terminal, but that stops at the same error. Forcing MariaDB to upgrade again just gives the same error.

Rolling back to a previous version of nextcloud doesn't do anyhing either. I'm stuck in maintenance mode (nothing is fixed when I disable it).

Any help would be greatly appreciated.

 

From what I understand the table is not corrupt, but for some reason MariaDB can't find/read them. It lists it, but claims it doens't exist.

I've tried looking for a fix myself, but since my knowledge of databases is too limited, I'm careful.

Is there any hope, or should I see this as a loss? (And my own mistake for not making adequate backups)