DrSiva2022

Pls someone help...

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)

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:/#

I stopped all services , restarted mariadb , even went to older version as mentioned , still its outputting this ins log. Caught SIGTERM signal! cat: /var/run/mysqld/mysqld.pid: No such file or directory UMASK must be a 3-digit mode with an additional leading 0 to indicate octal. The first digit will be corrected to 6, the others may be 0, 2, 4, or 6. UMASK corrected from 022 to 0640 ... 230809 22:46:55 mysqld_safe Logging to '/config/databases/f4e153d31abe.err'. 230809 22:46:55 mysqld_safe Starting mariadbd daemon with databases from /config/databases last time it was nextcloud update which screwed and it was down for long time since i didnt time to fix , now mariadb. Why is even simple updates are causing such a huge headache ?

sorry for late reply. I was little disappointed the way it went down. Its also a wake up call for me who thought this would be a robust solution. My mistakes were few .. adding wrong repository address (in one way the "https://" inclusion should have not taken down the entire app) , and second was not taking app data backup regularly. TBH , ididnt know it existed. I have made the nextcloud share as "Export: YES" and have moved the files to another location on unraid itself. In my case there is no CONTAINER AT ALL to STOP , its all gone , no listing of that app. So have to do a fresh reinstall of nextcloud. Let me update how it goes.Will setup everything and upload one or two pics from phone and then try to put back the folder which i moved back to nextcloud and hope the app recognizes and adds it to its database or whatever. Developers , kindly let me know if you want anything (log files etc) before i do a reinstall. Should be a casestudy how one wrong url could totally remove the app from listing and become unrecoverable.

I can able to see the files which it uploaded , luckily they were encrypted i think. Shall i backthem up and do a fresh install ? Also how to prevent this from happening in future ?

Kindly look here , version and config files are empty. How can i proceed as per your link ?

Thanks for the reply. I have nextcloud down for more than a week now Attaching the screenshots and also version.php and config.php files. couldnt upload .php files here , so here is the files https://file.io/okWxkorivszf they are empty.

I cant even find the app in the docker list. Even version.php or config.php , all are empty. What should i do ?

UPDATE TO THIS POST : Under previous app its showing as plugin. someone pls help.

I was running it fine for past few weeks. I went to nextcloud few days back and it showed PHP incompatibilty error , then went inside unraid and read on forum to update to different repository , i typed wrong , and it did something , and now its not showing in apps list and in previous apps page , it has only "remove option" screenshot here :

PLs help , the nextcloud is not even listing in app section

can someone help me wrong repository address and now nextcloud has vanished from app list and even on previous app list there is only option to remove it. Kindly help me recover nextcloud updated

help pls

IT shows like this