Opened 2 years ago
Last modified 2 years ago
#5307 accepted Verbesserung
alte Einträge aus oc_storages entfernen
| Reported by: | Rüdiger Kupper | Owned by: | Rüdiger Kupper |
|---|---|---|---|
| Priority: | bei Gelegenheit | Milestone: | Nextcloud: Optimierungen |
| Component: | Webdienst: Kepler-Cloud | Severity: | beeinträchtigt keinen Unterricht |
| Keywords: | Cc: |
Description
Dort sind noch alle alten Versuche gelistet, die Home- und Tauchordner auf anderem Weg zugänglich zu machen (Samba, ftp, kompletten Order, ...)
Vor dem Entfernen prüfen, ob alle zugehörigen Einträge in oc_filecache entfernt wurden (siehe #5202).
Change History (18)
comment:1 by , 2 years ago
comment:2 by , 2 years ago
Gleiches Spiel mit den alten ftp::-Mounts:
SELECT * FROM oc_storages where id like "ftp::%"; +------------+--------------------------------------------------------------+-----------+--------------+ | numeric_id | id | available | last_checked | +------------+--------------------------------------------------------------+-----------+--------------+ | 313 | ftp::Armbruste3@localhost//home/attic/armbruste3/ | 1 | NULL | | 314 | ftp::Armbruste3@localhost//home/share/ | 1 | NULL | | 353 | ftp::Barecheyo@localhost//home/share/ | 1 | NULL | | 352 | ftp::Barecheyo@localhost//home/students/12c/barecheyo/ | 1 | NULL | | 1618 | ftp::Braidtlis@localhost//home/share/ | 1 | NULL | | 1617 | ftp::Braidtlis@localhost//home/students/10a/braidtlis/ | 1 | NULL | | 322 | ftp::Finkbeine9@localhost//home/share/ | 1 | NULL | | 321 | ftp::Finkbeine9@localhost//home/students/11c/finkbeine9/ | 1 | NULL | | 576 | ftp::FinkbeinerEr@localhost//home/share/ | 1 | 1629440431 | | 575 | ftp::FinkbeinerEr@localhost//home/students/8d/finkbeinerer/ | 1 | 1629440431 | | 2208 | ftp::Gruendler3@localhost//home/share/ | 1 | NULL | | 2207 | ftp::Gruendler3@localhost//home/students/9c/gruendler3/ | 1 | NULL | | 573 | ftp::Jostmarlo@localhost//home/share/ | 1 | 1629413843 | | 572 | ftp::Jostmarlo@localhost//home/students/9e/jostmarlo/ | 1 | 1629413843 | | 677 | ftp::Metzlerne@localhost//home/share/ | 1 | 1629463667 | | 676 | ftp::Metzlerne@localhost//home/students/8c/metzlerne/ | 1 | 1629463667 | | 317 | ftp::Noth@localhost//home/share/ | 1 | NULL | | 316 | ftp::Noth@localhost//home/teachers/noth/ | 1 | NULL | | 329 | ftp::Prutschke@localhost//home/share/ | 1 | 1629364585 | | 328 | ftp::Prutschke@localhost//home/students/13a/prutschke/ | 1 | 1629364585 | | 362 | ftp::Schillera@localhost//home/share/ | 1 | NULL | | 361 | ftp::Schillera@localhost//home/students/8a/schillera/ | 1 | NULL | | 240 | ftp::akup@localhost// | 0 | 1629325907 | | 256 | ftp::akup@localhost//$home/ | 0 | 1629592720 | | 3053 | ftp::akup@localhost//$home/Arbeitsfläche/ | 0 | 1629674208 | | 3050 | ftp::akup@localhost//$home/Bilder/ | 0 | 1629674199 | | 3051 | ftp::akup@localhost//$home/Dokumente/ | 0 | 1629674201 | | 3054 | ftp::akup@localhost//$home/Downloads/ | 0 | 1629674211 | | 3055 | ftp::akup@localhost//$home/Musik/ | 0 | 1629674214 | | 3052 | ftp::akup@localhost//$home/Videos/ | 0 | 1629674205 | | 3056 | ftp::akup@localhost//$home/Vorlagen/ | 0 | 1629674216 | | 257 | ftp::akup@localhost//home/share/ | 0 | 1629592723 | | 3058 | ftp::akup@localhost//home/share/classes/ | 0 | 1629674219 | | 3059 | ftp::akup@localhost//home/share/projects/ | 0 | 1629674222 | | 3060 | ftp::akup@localhost//home/share/school/ | 0 | 1629674225 | | 3057 | ftp::akup@localhost//home/share/teachers/ | 1 | NULL | | 241 | ftp::akup@localhost//~/ | 0 | 1629325892 | | 570 | ftp::angermann@localhost//home/share/ | 1 | 1629407643 | | 569 | ftp::angermann@localhost//home/students/8a/angermann/ | 1 | 1629407643 | | 564 | ftp::armbruste8@localhost//home/share/ | 1 | NULL | | 563 | ftp::armbruste8@localhost//home/students/10a/armbruste8/ | 1 | NULL | | 338 | ftp::baeumlera@localhost//home/share/ | 1 | NULL | | 337 | ftp::baeumlera@localhost//home/students/13b/baeumlera/ | 1 | NULL | | 378 | ftp::bau@localhost//home/share/ | 1 | 1629441344 | | 3101 | ftp::bau@localhost//home/share/classes/ | 1 | NULL | | 3102 | ftp::bau@localhost//home/share/projects/ | 1 | NULL | | 3103 | ftp::bau@localhost//home/share/school/ | 1 | NULL | | 377 | ftp::bau@localhost//home/teachers/bau/ | 1 | 1629441344 | | 3097 | ftp::bau@localhost//home/teachers/bau/Arbeitsfläche/ | 1 | NULL | | 3094 | ftp::bau@localhost//home/teachers/bau/Bilder/ | 1 | NULL | | 3095 | ftp::bau@localhost//home/teachers/bau/Dokumente/ | 1 | NULL | | 3098 | ftp::bau@localhost//home/teachers/bau/Downloads/ | 1 | NULL | | 3099 | ftp::bau@localhost//home/teachers/bau/Musik/ | 1 | NULL | | 3096 | ftp::bau@localhost//home/teachers/bau/Videos/ | 1 | NULL | | 3100 | ftp::bau@localhost//home/teachers/bau/Vorlagen/ | 1 | NULL | | 374 | ftp::baurankem@localhost//home/share/ | 1 | 1629378032 | | 373 | ftp::baurankem@localhost//home/students/12c/baurankem/ | 1 | 1629378032 | | 284 | ftp::blumensto@localhost//home/share/ | 1 | NULL | | 283 | ftp::blumensto@localhost//home/students/10a/blumensto/ | 1 | NULL | | 541 | ftp::blumenstockS@localhost//home/share/ | 1 | NULL | | 540 | ftp::blumenstockS@localhost//home/students/8b/blumenstocks/ | 1 | NULL | | 371 | ftp::bohnertba@localhost//home/share/ | 1 | 1629407528 | | 370 | ftp::bohnertba@localhost//home/students/12d/bohnertba/ | 1 | 1629407528 | | 341 | ftp::bosenbeck@localhost//home/share/ | 1 | NULL | | 340 | ftp::bosenbeck@localhost//home/students/11b/bosenbeck/ | 1 | NULL | | 1748 | ftp::burkhardt3@localhost//home/share/ | 1 | 1629496495 | | 1747 | ftp::burkhardt3@localhost//home/students/12c/burkhardt3/ | 1 | 1629496495 | | 561 | ftp::eiselegre@localhost//home/share/ | 1 | NULL | | 560 | ftp::eiselegre@localhost//home/students/12a/eiselegre/ | 1 | NULL | | 350 | ftp::fetzerjul@localhost//home/share/ | 1 | NULL | | 349 | ftp::fetzerjul@localhost//home/students/8d/fetzerjul/ | 1 | NULL | | 269 | ftp::fetzerlia@localhost//home/share/ | 1 | NULL | | 268 | ftp::fetzerlia@localhost//home/students/9d/fetzerlia/ | 1 | NULL | | 281 | ftp::finkbeine12@localhost//home/share/ | 1 | NULL | | 280 | ftp::finkbeine12@localhost//home/students/9c/finkbeine12/ | 1 | NULL | | 293 | ftp::fitzneram@localhost//home/share/ | 1 | NULL | | 292 | ftp::fitzneram@localhost//home/students/9e/fitzneram/ | 1 | NULL | | 308 | ftp::fraschluc@localhost//home/share/ | 1 | NULL | | 307 | ftp::fraschluc@localhost//home/students/8c/fraschluc/ | 1 | NULL | | 299 | ftp::fraschsel@localhost//home/share/ | 1 | NULL | | 298 | ftp::fraschsel@localhost//home/students/11a/fraschsel/ | 1 | NULL | | 1621 | ftp::freitagma@localhost//home/share/ | 1 | NULL | | 1620 | ftp::freitagma@localhost//home/students/10a/freitagma/ | 1 | NULL | | 332 | ftp::gaiserjul@localhost//home/share/ | 1 | NULL | | 331 | ftp::gaiserjul@localhost//home/students/7d/gaiserjul/ | 1 | NULL | | 359 | ftp::gerweckma@localhost//home/share/ | 1 | NULL | | 358 | ftp::gerweckma@localhost//home/students/7a/gerweckma/ | 1 | NULL | | 272 | ftp::goetterle@localhost//home/share/ | 1 | NULL | | 271 | ftp::goetterle@localhost//home/students/10c/goetterle/ | 1 | NULL | | 550 | ftp::gorgusleo@localhost//home/share/ | 1 | NULL | | 549 | ftp::gorgusleo@localhost//home/students/6a/gorgusleo/ | 1 | NULL | | 344 | ftp::haistlena@localhost//home/share/ | 1 | NULL | | 343 | ftp::haistlena@localhost//home/students/11c/haistlena/ | 1 | NULL | | 305 | ftp::harterlar@localhost//home/share/ | 1 | NULL | | 304 | ftp::harterlar@localhost//home/students/8c/harterlar/ | 1 | NULL | | 368 | ftp::hauerpaul@localhost//home/share/ | 1 | 1629377405 | | 367 | ftp::hauerpaul@localhost//home/students/12c/hauerpaul/ | 1 | 1629377405 | | 585 | ftp::hauserjul@localhost//home/share/ | 1 | 1629448873 | | 584 | ftp::hauserjul@localhost//home/students/6a/hauserjul/ | 1 | 1629448873 | | 289 | ftp::hubervale@localhost//home/attic/hubervale/ | 1 | NULL | | 290 | ftp::hubervale@localhost//home/share/ | 1 | NULL | | 275 | ftp::jehnertni@localhost//home/share/ | 1 | NULL | | 274 | ftp::jehnertni@localhost//home/students/12d/jehnertni/ | 1 | NULL | | 582 | ftp::kaeseremi@localhost//home/share/ | 1 | 1629448869 | | 581 | ftp::kaeseremi@localhost//home/students/7b/kaeseremi/ | 1 | 1629448869 | | 287 | ftp::kalmbachl@localhost//home/share/ | 1 | NULL | | 286 | ftp::kalmbachl@localhost//home/students/8c/kalmbachl/ | 1 | NULL | | 383 | ftp::kau@localhost//home/share/ | 1 | NULL | | 382 | ftp::kau@localhost//home/teachers/kau/ | 1 | NULL | | 579 | ftp::klumppmia@localhost//home/share/ | 1 | 1629444672 | | 578 | ftp::klumppmia@localhost//home/students/7c/klumppmia/ | 1 | 1629444672 | | 254 | ftp::kup@localhost//home/share/ | 1 | 1629587019 | | 3090 | ftp::kup@localhost//home/share/classes/ | 1 | 1629670161 | | 3091 | ftp::kup@localhost//home/share/projects/ | 1 | 1629670161 | | 3092 | ftp::kup@localhost//home/share/school/ | 1 | 1629670161 | | 3093 | ftp::kup@localhost//home/share/teachers/ | 1 | 1629670161 | | 253 | ftp::kup@localhost//home/teachers/kup/ | 1 | 1629587019 | | 3086 | ftp::kup@localhost//home/teachers/kup/Arbeitsfläche/ | 1 | 1629670161 | | 3083 | ftp::kup@localhost//home/teachers/kup/Bilder/ | 1 | 1629670161 | | 3084 | ftp::kup@localhost//home/teachers/kup/Dokumente/ | 1 | 1629670161 | | 3087 | ftp::kup@localhost//home/teachers/kup/Downloads/ | 1 | 1629670161 | | 3088 | ftp::kup@localhost//home/teachers/kup/Musik/ | 1 | 1629670161 | | 3085 | ftp::kup@localhost//home/teachers/kup/Videos/ | 1 | 1629670161 | | 3089 | ftp::kup@localhost//home/teachers/kup/Vorlagen/ | 1 | 1629670161 | | 251 | ftp::lehrer@localhost//home/share/ | 1 | 1629549847 | | 3069 | ftp::lehrer@localhost//home/share/classes/ | 1 | 1629619447 | | 3070 | ftp::lehrer@localhost//home/share/projects/ | 1 | 1629619447 | | 3071 | ftp::lehrer@localhost//home/share/school/ | 1 | 1629619447 | | 3068 | ftp::lehrer@localhost//home/share/teachers/ | 1 | 1629619447 | | 250 | ftp::lehrer@localhost//home/teachers/lehrer/ | 1 | 1629549847 | | 3064 | ftp::lehrer@localhost//home/teachers/lehrer/Arbeitsfläche/ | 1 | 1629619447 | | 3061 | ftp::lehrer@localhost//home/teachers/lehrer/Bilder/ | 1 | 1629619447 | | 3062 | ftp::lehrer@localhost//home/teachers/lehrer/Dokumente/ | 1 | 1629619447 | | 3065 | ftp::lehrer@localhost//home/teachers/lehrer/Downloads/ | 1 | 1629619447 | | 3066 | ftp::lehrer@localhost//home/teachers/lehrer/Musik/ | 1 | 1629619447 | | 3063 | ftp::lehrer@localhost//home/teachers/lehrer/Videos/ | 1 | 1629619447 | | 3067 | ftp::lehrer@localhost//home/teachers/lehrer/Vorlagen/ | 1 | 1629619447 | | 356 | ftp::lugerroma@localhost//home/share/ | 1 | NULL | | 355 | ftp::lugerroma@localhost//home/students/12b/lugerroma/ | 1 | NULL | | 335 | ftp::millerden@localhost//home/share/ | 1 | NULL | | 334 | ftp::millerden@localhost//home/students/10d/millerden/ | 1 | NULL | | 326 | ftp::millermax@localhost//home/share/ | 1 | 1629364689 | | 325 | ftp::millermax@localhost//home/students/11b/millermax/ | 1 | 1629364689 | | 302 | ftp::millerpau@localhost//home/share/ | 1 | NULL | | 301 | ftp::millerpau@localhost//home/students/8d/millerpau/ | 1 | NULL | | 296 | ftp::muellerha@localhost//home/share/ | 1 | NULL | | 295 | ftp::muellerha@localhost//home/students/9e/muellerha/ | 1 | NULL | | 319 | ftp::noth@localhost//home/share/ | 1 | NULL | | 318 | ftp::noth@localhost//home/teachers/noth/ | 1 | NULL | | 311 | ftp::owsianlui@localhost//home/share/ | 1 | NULL | | 310 | ftp::owsianlui@localhost//home/students/8b/owsianlui/ | 1 | NULL | | 547 | ftp::palaginpo@localhost//home/share/ | 1 | NULL | | 546 | ftp::palaginpo@localhost//home/students/8d/palaginpo/ | 1 | NULL | | 1362 | ftp::peterseme@localhost//home/share/ | 1 | 1629482178 | | 1361 | ftp::peterseme@localhost//home/students/8d/peterseme/ | 1 | 1629482178 | | 588 | ftp::pljakicka@localhost//home/share/ | 1 | 1629451934 | | 587 | ftp::pljakicka@localhost//home/students/12d/pljakicka/ | 1 | 1629451934 | | 1117 | ftp::sautermia@localhost//home/share/ | 1 | 1629478307 | | 1116 | ftp::sautermia@localhost//home/students/7c/sautermia/ | 1 | 1629478307 | | 553 | ftp::schaufler@localhost//home/share/ | 1 | NULL | | 552 | ftp::schaufler@localhost//home/students/9c/schaufler/ | 1 | NULL | | 556 | ftp::schindelv@localhost//home/share/ | 1 | 1629389529 | | 555 | ftp::schindelv@localhost//home/students/9d/schindelv/ | 1 | 1629389529 | | 559 | ftp::schloerso@localhost//home/share/ | 1 | NULL | | 558 | ftp::schloerso@localhost//home/students/12b/schloerso/ | 1 | NULL | | 365 | ftp::schmidtma@localhost//home/share/ | 1 | NULL | | 364 | ftp::schmidtma@localhost//home/students/12d/schmidtma/ | 1 | NULL | | 263 | ftp::schremser1@localhost//home/share/ | 1 | NULL | | 262 | ftp::schremser1@localhost//home/students/12c/schremser1/ | 1 | NULL | | 233 | ftp::schuelte@localhost// | 1 | 1629326343 | | 243 | ftp::schuelte@localhost//$HOME/ | 0 | 1629325947 | | 248 | ftp::schuelte@localhost//$home/ | 0 | 1629326459 | | 237 | ftp::schuelte@localhost//./ | 1 | 1629324239 | | 242 | ftp::schuelte@localhost//\~/ | 0 | 1629325937 | | 232 | ftp::schuelte@localhost//home/share/ | 1 | 1629454505 | | 3079 | ftp::schuelte@localhost//home/share/classes/ | 1 | 1629670776 | | 3080 | ftp::schuelte@localhost//home/share/projects/ | 1 | 1629670777 | | 3081 | ftp::schuelte@localhost//home/share/school/ | 1 | 1629670777 | | 239 | ftp::schuelte@localhost//home/students/a/schuelte/ | 1 | 1629454505 | | 3072 | ftp::schuelte@localhost//home/students/a/schuelte/Bilder/ | 1 | 1629670776 | | 3073 | ftp::schuelte@localhost//home/students/a/schuelte/Dokumente/ | 1 | 1629670776 | | 3076 | ftp::schuelte@localhost//home/students/a/schuelte/Downloads/ | 1 | 1629670776 | | 3077 | ftp::schuelte@localhost//home/students/a/schuelte/Musik/ | 1 | 1629670776 | | 3074 | ftp::schuelte@localhost//home/students/a/schuelte/Videos/ | 1 | 1629670776 | | 3078 | ftp::schuelte@localhost//home/students/a/schuelte/Vorlagen/ | 1 | 1629670776 | | 247 | ftp::schuelte@localhost//root/ | 1 | NULL | | 244 | ftp::schuelte@localhost//~$user/ | 1 | NULL | | 238 | ftp::schuelte@localhost//~/ | 0 | 1629326164 | | 245 | ftp::schuelte@localhost//~schuelte/ | 0 | 1629326220 | | 567 | ftp::schwarzni@localhost//home/share/ | 1 | 1629407812 | | 566 | ftp::schwarzni@localhost//home/students/12c/schwarzni/ | 1 | 1629407812 | | 347 | ftp::seegervan@localhost//home/share/ | 1 | 1629437978 | | 346 | ftp::seegervan@localhost//home/students/6d/seegervan/ | 1 | 1629437978 | | 266 | ftp::seidpia@localhost//home/share/ | 1 | 1629353915 | | 265 | ftp::seidpia@localhost//home/students/11c/seidpia/ | 1 | 1629353915 | | 538 | ftp::serifovic@localhost//home/share/ | 1 | NULL | | 537 | ftp::serifovic@localhost//home/students/11b/serifovic/ | 1 | NULL | | 2374 | ftp::sionmaxim@localhost//home/share/ | 1 | NULL | | 2373 | ftp::sionmaxim@localhost//home/students/13e/sionmaxim/ | 1 | NULL | | 544 | ftp::uenluemel@localhost//home/share/ | 1 | NULL | | 543 | ftp::uenluemel@localhost//home/students/11b/uenluemel/ | 1 | NULL | | 260 | ftp::wujennife@localhost//home/share/ | 1 | NULL | | 259 | ftp::wujennife@localhost//home/students/13e/wujennife/ | 1 | NULL | | 278 | ftp::zankerlea@localhost//home/share/ | 1 | NULL | | 277 | ftp::zankerlea@localhost//home/students/12a/zankerlea/ | 1 | NULL | +------------+--------------------------------------------------------------+-----------+--------------+ 205 rows in set (0,001 sec)
Prüfen, ob es noch alte Einträge dazu in oc_filecache gibt (mittels JOIN):
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where oc_storages.id like "ftp::%";
Das Ergebnis liefert 76764 verbleibende Einträge. Die müssen zunächst entfernt werden.
comment:3 by , 2 years ago
Nach überprüfen, dass alles sinnvoll erscheint:
delete oc_filecache from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where oc_storages.id like "ftp::%"; Query OK, 76764 rows affected (26,553 sec)
Test:
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where oc_storages.id like "ftp::%"; Empty set (0,009 sec)
comment:4 by , 2 years ago
Nun:
> delete FROM oc_storages where id like "ftp::%"; Query OK, 205 rows affected (0,253 sec)
Test:
SELECT * FROM oc_storages where id like "ftp::%"; Empty set (0,000 sec)
comment:5 by , 2 years ago
| Status: | new → accepted |
|---|
comment:6 by , 2 years ago
Der Fileserver ist derzeit nur über das Verzichnis ".links-kepler-cloud" im HV der Nutzer eingebunden. D.h. alle storages, die direkt zum Fileserver führen, sind von früher:
SELECT * FROM oc_storages where id like "sftp:%/home/share/%"; +------------+--------------------------------------------------------------+-----------+--------------+ | numeric_id | id | available | last_checked | +------------+--------------------------------------------------------------+-----------+--------------+ | 215 | sftp::akup@localhost//home/share/ | 1 | NULL | | 218 | sftp::kup@localhost//home/share/ | 1 | 1634568298 | | 219 | sftp::Freyilea@localhost//home/share/ | 1 | NULL | | 226 | sftp::schuelte@localhost//home/share/ | 0 | 1629327642 | | 227 | sftp::schuelte@10.16.112.16//home/share/ | 0 | 1629317506 | | 228 | sftp::schuelte@127.0.0.1//home/share/ | 0 | 1629318468 | | 229 | sftp::schuelte@cloud//home/share/ | 0 | 1629318494 | | 230 | sftp::schuelte@cloud.kg-fds.de//home/share/ | 0 | 1629319040 | | 236 | sftp::goetteram@localhost//home/share/ | 1 | NULL | | 3121 | sftp::akup@localhost//home/share/classes/ | 0 | 1631047906 | | 3122 | sftp::akup@localhost//home/share/projects/ | 0 | 1631047909 | | 3123 | sftp::akup@localhost//home/share/school/ | 0 | 1631047909 | | 3128 | sftp::kup@localhost//home/share/classes/ | 1 | 1634755098 | | 3129 | sftp::kup@localhost//home/share/projects/ | 1 | 1634755103 | | 3130 | sftp::kup@localhost//home/share/school/ | 1 | 1634755103 | | 3131 | sftp::kup@localhost//home/share/teachers/ | 1 | 1634755098 | | 3139 | sftp::lehrer@localhost//home/share/classes/ | 1 | 1634755633 | | 3140 | sftp::lehrer@localhost//home/share/projects/ | 1 | 1634755637 | | 3141 | sftp::lehrer@localhost//home/share/school/ | 1 | 1634755638 | | 3142 | sftp::lehrer@localhost//home/share/teachers/ | 1 | 1634755633 | | 3150 | sftp::schuelte@localhost//home/share/classes/ | 1 | 1632925735 | | 3151 | sftp::schuelte@localhost//home/share/projects/ | 1 | 1632925735 | | 3152 | sftp::schuelte@localhost//home/share/school/ | 1 | 1632925736 | | 3160 | sftp::bau@localhost//home/share/classes/ | 1 | 1630010248 | [...]
u.s.w.
comment:7 by , 2 years ago
Auf Einträge in oc_filecache prüfen:
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where oc_storages.id like sftp:%/home/share/%"; [...] 5685636 rows in set (29,974 sec)
comment:8 by , 2 years ago
delete oc_filecache from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where oc_storages.id like "sftp:%/home/s hare/%"; Query OK, 5685636 rows affected (5 hours 59 min 33,699 sec)
Test:
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where oc_storages.id like "sftp:%/home/share/%"; Empty set (0,495 sec)
Nun:
delete FROM oc_storages where id like "sftp:%/home/share/%"; Query OK, 992 rows affected (2,208 sec)
comment:9 by , 2 years ago
Alle Verweise, die nicht über $/.links-kepler-cloud gehen, stammen ebenfalls von früher:
SELECT * FROM oc_storages where (id like "sftp:%/home%" and id not like "sftp:%/home/%.links-kepler-cloud/"); +------------+------------------------------------------------------------------+-----------+--------------+ | numeric_id | id | available | last_checked | +------------+------------------------------------------------------------------+-----------+--------------+ | 214 | sftp::akup@localhost//home/teachers/akup/ | 1 | NULL | | 217 | sftp::kup@localhost//home/teachers/kup_2263/ | 1 | 1629316132 | | 220 | sftp::kup@localhost//home/teachers/kup/ | 1 | 1634667231 | | 3104 | sftp::akup@localhost//home/teachers/kup/ | 0 | 1629653033 | | 3105 | sftp::kup@localhost//home/students/a/schuelte/ | 0 | 1629670670 | | 3108 | sftp::lehrer@localhost//home/students/a/schuelte/ | 1 | 1629670708 | | 3114 | sftp::kup@localhost//home/teachers/kup/Bilder/ | 1 | 1634755103 | | 3115 | sftp::kup@localhost//home/teachers/kup/Dokumente/ | 1 | 1634755098 | | 3116 | sftp::kup@localhost//home/teachers/kup/Videos/ | 1 | 1633978233 | | 3124 | sftp::kup@localhost//home/teachers/kup/Arbeitsfläche/ | 1 | 1634755098 | | 3126 | sftp::kup@localhost//home/teachers/kup/Musik/ | 1 | 1633357835 | | 3127 | sftp::kup@localhost//home/teachers/kup/Vorlagen/ | 1 | 1633357835 | | 3132 | sftp::lehrer@localhost//home/teachers/lehrer/Bilder/ | 1 | 1634755638 | | 3133 | sftp::lehrer@localhost//home/teachers/lehrer/Dokumente/ | 1 | 1634755632 | | 3134 | sftp::lehrer@localhost//home/teachers/lehrer/Videos/ | 1 | 1633713210 | | 3135 | sftp::lehrer@localhost//home/teachers/lehrer/Arbeitsfläche/ | 1 | 1634755633 | | 3136 | sftp::lehrer@localhost//home/teachers/lehrer/Downloads/ | 1 | 1632236442 | | 3137 | sftp::lehrer@localhost//home/teachers/lehrer/Musik/ | 1 | 1632236450 | | 3138 | sftp::lehrer@localhost//home/teachers/lehrer/Vorlagen/ | 1 | 1632236450 | | 3143 | sftp::schuelte@localhost//home/students/a/schuelte/Bilder/ | 1 | 1632925726 | | 3144 | sftp::schuelte@localhost//home/students/a/schuelte/Dokumente/ | 1 | 1632925726 | | 3145 | sftp::schuelte@localhost//home/students/a/schuelte/Videos/ | 1 | 1632925726 | | 3147 | sftp::schuelte@localhost//home/students/a/schuelte/Downloads/ | 1 | 1632925726 | | 3148 | sftp::schuelte@localhost//home/students/a/schuelte/Musik/ | 1 | 1632925726 | | 3149 | sftp::schuelte@localhost//home/students/a/schuelte/Vorlagen/ | 1 | 1632925735 | | 3153 | sftp::bau@localhost//home/teachers/bau/Bilder/ | 1 | 1630010241 | | 3154 | sftp::bau@localhost//home/teachers/bau/Dokumente/ | 1 | 1630010241 | | 3155 | sftp::bau@localhost//home/teachers/bau/Videos/ | 1 | 1630010241 | | 3156 | sftp::bau@localhost//home/teachers/bau/Arbeitsfläche/ | 1 | 1630010245 | [...]
Version 0, edited 2 years ago by (next)
comment:10 by , 2 years ago
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where (oc_storages.id like "sftp:%/home%" and oc_storages.id not like "sftp:%/home/%.links-kepler-cloud/"); +----------+---------+----------------------------------------------------------------------------------------------------------------> | fileid | storage | path > +----------+---------+----------------------------------------------------------------------------------------------------------------> | 1833997 | 3114 | > | 1833999 | 3114 | Download wallpaper blue, red, abstraction, yellow, figure, red, monochrome, yellow, blue, abstraction, section > | 1834006 | 3114 | Download wallpaper abstraction, vector, texture, abstract, blue, background, pattern, gradient, geometric, back> | 1834015 | 3114 | Download wallpaper circles, blue, abstraction, blue, patterns, color, lines, design, blue, circles, pattern, li> | 1834016 | 3114 | Download wallpaper abstract, white, wet, rain, blue, water, bubble, liquid, splash, chocolate, color, sweet, dr> | 1834018 | 3114 | Download wallpaper simple, green, abstract, dark, light, red, colourful, yellow, blue, background, spectrum, pu> | 1834028 | 3114 | Download wallpaper blue, abstraction, tangled, fractal, threads, section abstraction in resolution 1920x1080_fi> | 1834031 | 3114 | Download wallpaper blue, red, abstraction, yellow, figure, red, monochrome, yellow, blue, abstraction, section > | 1834033 | 3114 | Download wallpaper green, abstract, wallpaper, blue, fon, section abstraction in resolution 1920x1080_files > | 1834036 | 3114 | Download wallpaper abstraction, abstract, dark, geometry, figure, blue, background, polygonal, section abstract> | 1834041 | 3114 | Wallpapers > | 1834051 | 3114 | Download wallpaper color, line, abstraction, weave, color abstract, Wave Blue, section abstraction in resolutio> | 1834052 | 3114 | Wallpaper > | 1834068 | 3114 | .AppleDouble > | 1834070 | 3114 | Download wallpaper green, colorful, abstract, blue, blur, bokeh, gradient, multi coloured, contour lines, grada> | 1834071 | 3114 | Stellarium > | 1834072 | 3114 | Download wallpaper abstract, blue, background, modiac, crystallize, section textures in resolution 1920x1080_fi> | 1834073 | 3114 | Download wallpaper abstract, wallpaper, texture, blue, background, orange, graphic, modiac, crystallize, sectio> | 1834077 | 3114 | Download wallpaper circles, blue, abstraction, patterns, paint, colors, blue, circles, patterns, bokeh, bokeh, > | 1834017 | 3114 | .~lock.NwT9-2018-19-T1--EndnotenNwT.ods# > | 1834037 | 3114 | bags.png.xmp > | 1834065 | 3114 | issue.kepler > | 1834074 | 3114 | LOGO_KEPLER_mittel_80x52_Kaupp_geglaettet.odg > | 1834089 | 3114 | Download wallpaper blue, red, abstraction, yellow, figure, red, monochrome, yellow, blue, abstraction, section > | 1834090 | 3114 | Download wallpaper blue, red, abstraction, yellow, figure, red, monochrome, yellow, blue, abstraction, section > | 1834094 | 3114 | Download wallpaper abstraction, vector, texture, abstract, blue, background, pattern, gradient, geometric, back> | 1834095 | 3114 | Download wallpaper abstraction, vector, texture, abstract, blue, background, pattern, gradient, geometric, back> | 1834099 | 3114 | Download wallpaper circles, blue, abstraction, blue, patterns, color, lines, design, blue, circles, pattern, li> | 1834100 | 3114 | Download wallpaper circles, blue, abstraction, blue, patterns, color, lines, design, blue, circles, pattern, li> | 1834104 | 3114 | Download wallpaper abstract, white, wet, rain, blue, water, bubble, liquid, splash, chocolate, color, sweet, dr> [...] 48968 rows in set (0,291 sec)
comment:11 by , 2 years ago
Nun:
delete oc_filecache from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where (oc_storages.id like "sftp:%/home%" and oc_storages.id not like "sftp:%/home/%.links-kepler-cloud/"); Query OK, 48968 rows affected (4 min 16,345 sec)
comment:12 by , 2 years ago
Test:
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where (oc_storages.id like "sftp:%/home%" and oc_storages.id not like "sftp:%/home/%.links-kepler-cloud/"); Empty set (1,107 sec)
Nun:
delete FROM oc_storages where (id like "sftp:%/home%" and id not like "%.links-kepler-cloud%"); Query OK, 1317 rows affected (7,414 sec)
comment:13 by , 2 years ago
Eben durchs raster gefallen:
SELECT * FROM oc_storages where (id like "sftp:%" and id not like "sftp:%/home/%.links-kepler-cloud/"); +------------+-------------------------------------------------+-----------+--------------+ | numeric_id | id | available | last_checked | +------------+-------------------------------------------------+-----------+--------------+ | 221 | sftp::kup@localhost// | 0 | 1629316805 | | 222 | sftp::kupx@localhost// | 0 | 1629313669 | | 223 | sftp::akup@localhost// | 1 | NULL | | 225 | sftp::schuelte@localhost// | 0 | 1629327642 | | 231 | sftp::Freyilea@localhost// | 1 | NULL | | 235 | sftp::goetteram@localhost// | 1 | NULL | | 246 | sftp::schuelte@localhost//~/ | 0 | 1629326030 | | 3106 | sftp::kup@localhost//$home/ | 1 | NULL | | 3107 | sftp::lehrer@localhost//$home/ | 1 | NULL | | 3109 | sftp::schuelte@localhost//$home/ | 1 | NULL | | 3111 | sftp::akup@localhost//$home/Bilder/ | 0 | 1631047903 | | 3112 | sftp::akup@localhost//$home/Dokumente/ | 0 | 1631047903 | | 3113 | sftp::akup@localhost//$home/Videos/ | 0 | 1631047903 | | 3117 | sftp::akup@localhost//$home/Arbeitsfläche/ | 0 | 1631047903 | | 3118 | sftp::akup@localhost//$home/Downloads/ | 0 | 1631047906 | | 3119 | sftp::akup@localhost//$home/Musik/ | 0 | 1631047906 | | 3120 | sftp::akup@localhost//$home/Vorlagen/ | 0 | 1631047906 | | 5668 | sftp::kup@localhost//Downloads/ | 1 | 1633432949 | | 6536 | sftp::richtest@localhost//$home/Bilder/ | 0 | 1633963131 | | 6537 | sftp::richtest@localhost//$home/Dokumente/ | 0 | 1633963131 | | 6538 | sftp::richtest@localhost//$home/Videos/ | 0 | 1633963131 | | 6539 | sftp::richtest@localhost//$home/Arbeitsfläche/ | 0 | 1633963131 | | 6720 | sftp::Pal@localhost// | 1 | NULL | | 6721 | sftp::shul@localhost// | 1 | NULL | | 6747 | sftp::rich@localhost// | 1 | 1652615684 | +------------+-------------------------------------------------+-----------+--------------+
comment:14 by , 2 years ago
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where (id like "sftp:%" and id not like "sftp:%/home/%.links-kepler-cloud/"); [...] 3106021 rows in set (1 min 8,071 sec)
comment:15 by , 2 years ago
delete oc_filecache from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where (id like "sftp:%" and id not like "sftp:%/home/%.links-kepler-cloud/"); Query OK, 3106021 rows affected (5 hours 8 min 11,825 sec)
Test:
select * from oc_filecache inner join oc_storages on oc_storages.numeric_id=oc_filecache.storage where (id like "sftp:%" and id not like "sftp:%/home/%.links-kepler-cloud/"); Empty set (0,001 sec)
comment:16 by , 2 years ago
delete FROM oc_storages where numeric_id in (221,222,223,225,231,235,246,3106,3107,3109,3111,3112,3113,3117,3118,3119,3120,5668,6536,6537,6538,6539,6720,6721,6747); Query OK, 25 rows affected (0,011 sec)
comment:17 by , 2 years ago
Und schließlich Storage id 1 (local::/var/www/nextcloud/data/). Das Data-Verzeichnis ist lange umgezogen ins fast-storage (gemountet unter /mnt/nextcloud-data). In /var/www/nextcloud gibt es gar kein data-Verzeichnis mehr.
select * from oc_filecache where storage=1; [...] 184923 rows in set (0,841 sec)
delete from oc_filecache where storage=1; Query OK, 184923 rows affected (1 min 49,473 sec)
delete FROM oc_storages where numeric_id=1; Query OK, 1 row affected (3,520 sec)
comment:18 by , 2 years ago
In oc_mounts stehen nun nur noch die NC-Verzeichnisse der Nutzer sowie jede Menge Einträge, die nur einen Hex-Code als Dateinamen haben. Da ich keine Ahnung habe, was sich dahinter verbirgt lasse ich die in Ruhe. Vielleicht mal mit oc_filecache joinen und schauen, was darunter indiziert ist.
Note:
See TracTickets
for help on using tickets.
Ich beginne mit den alten smb::-Mounts:
Prüfen, ob dazu noch oc_filecache-Einträge existieren (vgl. #5202):
Alles klar, also:
Test: