{"id":1505,"date":"2015-05-06T13:38:45","date_gmt":"2015-05-06T11:38:45","guid":{"rendered":"http:\/\/my.stargazer.at\/?p=1505"},"modified":"2015-05-06T13:38:45","modified_gmt":"2015-05-06T11:38:45","slug":"owncloud-8-0-3-and-some-sql-problem","status":"publish","type":"post","link":"https:\/\/my.stargazer.at\/de\/2015\/05\/06\/owncloud-8-0-3-and-some-sql-problem\/","title":{"rendered":"OwnCloud 8.0.3 und ein SQL Problem"},"content":{"rendered":"<p>Heute war meine OwnCloud dran: ein Update auf 8.0.3; Aber irgendwie schien das Update nicht ganz so zu laufen wie es sollte:<\/p>\n<blockquote><p>Aktualisiere ownCloud auf Version 8.0.3. Dies k\u00f6nnte eine Weile dauern.<br \/>\nAn exception occurred while executing &#8218; DELETE FROM `oc_lucene_status` WHERE `fileid` IN ( SELECT `fileid` FROM ( SELECT `fileid` FROM `oc_lucene_status` GROUP BY `fileid` HAVING count(`fileid`) &gt; 1 ) AS `mysqlerr1093hack` )&#8216;: SQLSTATE[HY000]: General error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.<br \/>\nThe update was unsuccessful. Please report this issue to the ownCloud community.<\/p><\/blockquote>\n<p><!--more-->Der Grund dazu &#8211; die Fehlermeldung interpr\u00e4tierend &#8211; muss wohl im bin\u00e4ren Log des SQL Servers begraben liegen: Dieses ist standardm\u00e4\u00dfig offenbar auf STATEMENT w\u00e4hrend wir f\u00fcr die READ (UN)COMMITTED Anweisungen ein row-logging ben\u00f6tigen. Einfach umzustellen in der my.cnf:<\/p>\n<blockquote><p>binlog_format = ROW<\/p><\/blockquote>\n<p>Nach einem Neustart des\u00a0MySQL Servers sah die Sache schon besser aus:<\/p>\n<blockquote><p>Update successful<\/p><\/blockquote>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Heute war meine OwnCloud dran: ein Update auf 8.0.3; Aber irgendwie schien das Update nicht ganz so zu laufen wie es sollte: Aktualisiere ownCloud auf Version 8.0.3. Dies k\u00f6nnte eine Weile dauern. An exception occurred while executing &#8218; DELETE FROM `oc_lucene_status` WHERE `fileid` IN ( SELECT `fileid` FROM ( SELECT `fileid` FROM `oc_lucene_status` GROUP BY `fileid` HAVING count(`fileid`) [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[299,600],"class_list":["post-1505","post","type-post","status-publish","format-standard","hentry","category-it-related-stuff","tag-mysql","tag-owncloud"],"_links":{"self":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/posts\/1505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/comments?post=1505"}],"version-history":[{"count":0,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/posts\/1505\/revisions"}],"wp:attachment":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/media?parent=1505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/categories?post=1505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/tags?post=1505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}