Comments (9)
we can't be sure about support for your OS, see requirements and why Ubuntu is the only supported distribution.
- Can you name details about your environment, (hardware, VM, container etc...)
- Do you recall any changes made lately (before yesterday)?
- Did you add any apps?
I cannot find any log files related to PHP or MySQL under /var/snap/nextcloud/... could you please let me know the directories? Trying based in Issue 1246, but did not find the log files - I have not done any customization on the snap, so should be in original place.
See managing logs.
Also I was dumb enough to not have a backup, which I will do now (possible automatically with snap??)
This may help for automated snap backups; Backup, restore & migrate see also example rotating backup script
from nextcloud-snap.
not much, 5-10, but they also have to be instructed how to synch the desktop app again and what ever they changed in the meantime...
thanks a lot for the support :)
from nextcloud-snap.
@scubamuc thanks for the support!
Can you name details about your environment, (hardware, VM, container etc...)
Hardware : BCM2835
Model : Raspberry Pi 4 Model B Rev 1.2
OS:
pi@raspberrypi:~ $ cat /etc/os-release
PRETTY_NAME="Debian GNU/Linux 10 (buster)"
I managed to save the logs:
ApacheLog.txt
MySQLLog.txt
NextcloudLog.txt
PHP and PHP-fpm logs are basically empty.
MySQL log is partial, but these messages are on repeat.
InnoDB insertion error as I suspected, there should be a recovery for that, but I only find commands where MySQL or mariaDB is directly installed, I found also docker commands, but not for snap 🈂️
Do you recall any changes made lately (before yesterday)?
Did you add any apps?
I do not recall any changes made lately, We use only two "extra" apps, but those were initially intalled:
- Temporary file locks
- Decks
This may help for automated snap backups; Backup, restore & migrate see also example rotating backup script
Thank you so much for sure will do this after restoring :)
from nextcloud-snap.
so your logs are displaying a mysql issue:
2024-01-04T17:37:32.736449Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: fut0lst.ic:81:addr.page == FIL_NULL || addr.boffset >= FIL_PAGE_DATA thread 5$InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
2024-01-04T17:37:32Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=7a7b99da33acb19c1a647ceeb813a45d4786fb61
Thread pointer: 0x7f48000b20
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Have you done suggested:
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
from nextcloud-snap.
No I have not done it since I am not sure how to navigate in mysql within the Nextcloud snap...is there a possibility to do the repair similar like this: https://stackoverflow.com/questions/28521530/mysql-fatal-error-cant-open-and-lock-privilege-tables-incorrect-file-format
But with commands inside the snap install?
from nextcloud-snap.
But with commands inside the snap install?
nope, this will not be possible since the Database is not starting... I'm all out of ideas.
from nextcloud-snap.
You won't be able to run snap commands to package it up nicely, but you can just slurp off the entire directory if you have another drive (or machine to scp it to). Worst case you lose your database, but you should be able to grab all the raw data assuming your drive hasn't eaten it. I would grab the entire /var/snap/nextcloud directory if I were you-- by default everything you care about is there. Did you change the data directory, though? If so, you'll need to grab that directory as well.
your raw data can be found in /var/snap/nextcloud/common/nextcloud/data
if you haven't changed your data directory, so if you grab that directory and copy the contents to your new install, you'll at least preserve the raw data. I'm guessing that Deck projects
data will be there too.
from nextcloud-snap.
But for sure all users has to be recreated with the corrupted tables right?
from nextcloud-snap.
yeah, I guess...
how many users are you hosting on a Raspi4?
from nextcloud-snap.
Related Issues (20)
- NextCloud Installation Broken - Unable To Update HOT 14
- How to modify the JSON file of translation content? HOT 3
- I can't write korean on nextcloud office. HOT 3
- cannot run https://scan.nextcloud.com/ HOT 7
- Your web server is not properly set up to resolve "/.well-known/webfinger". "/.well-known/nodeinfo". HOT 26
- unable to change data directory HOT 2
- no .js compression HOT 14
- Nextcloud 28 - MySQL server has gone away","Code":2006," - server crashes and won't come back HOT 8
- app upgrade "collectives" PDO SQLite error "fulltextsearch"
- documentation wiki, managing logs
- Font not appear in Office HOT 1
- Your data directory and files are probably accessible from the internet. HOT 2
- Hub 8 Assistant 2.0 App missing HOT 6
- cron not working after upgrade to 29.02.1 HOT 25
- Logs are flooded with: Invalid "upload_max_filesize" setting. Invalid quantity "16G": value is out of range, using overflow result for backwards compatibility at Unknown#0 HOT 4
- Download Progress not being shown while downloading a File HOT 2
- Mounted disks cannot be accessed in external storage HOT 25
- Update Nextcloud to 29.0.3 HOT 12
- Update Nextcloud to 28.0.7 HOT 1
- Update Nextcloud to 27.1.11 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from nextcloud-snap.