On 12/11/2013 06:58 PM, Markus Westerhausen wrote:
A „DELETE FROM oc_lucene_search;“ in the mysql database fixes the problem

Hi,

I had exactly the same problem, see:
https://github.com/owncloud/core/issues/6298

Are you sure it is ok to go ahead and delete these records? I don't want to fix one problem by creating another one.


                                                Yours: Laszlo

*Von:*owncloud-boun...@kde.org [mailto:owncloud-boun...@kde.org] *Im
Auftrag von *Hermann
*Gesendet:* Mittwoch, 11. Dezember 2013 18:49
*An:* owncloud@kde.org
*Betreff:* Re: [Owncloud] ownCloud 6 release

hi guys,

I updated my OC5.0.13 to OC6.0.0.

Deleted all  expect /config and /data.

The browser says me:

Konnte "search_lucene" nicht aktualisieren.

#0 /var/www/clients/client1/web2/web/lib/private/app.php(92):
OC_App::checkUpgrade('search_lucene')

#1 /var/www/clients/client1/web2/web/lib/private/app.php(66): 
OC_App::loadApp('search_lucene')

#2 /var/www/clients/client1/web2/web/lib/base.php(689): OC_App::loadApps()

#3 /var/www/clients/client1/web2/web/index.php(30): OC::handleRequest()

#4 {main}

The owncloud.log says:

{"app":"index","message":"Exception: Konnte \"search_lucene\" nicht
aktualisieren. - Verursacht durch: An exception occurred while executing
'ALTER TABLE `oc_lucene_status` ADD PRIMARY KEY
(`fileid`)':\n\nSQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry '13' for key
'PRIMARY'","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: Konnte \"search_lucene\" nicht
aktualisieren. - Verursacht durch: An exception occurred while executing
'ALTER TABLE `oc_lucene_status` ADD PRIMARY KEY
(`fileid`)':\n\nSQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry '13' for key 'PRIMARY' - Verursacht durch:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'13' for key 'PRIMARY'[23000]
","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"core","message":"Failed to update database structure (exception
'PDOException' with message 'SQLSTATE[23000]: Integrity constraint
violation: 1062 Duplicate entry '13' for key 'PRIMARY'' in
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php:742\nStack
trace:\n#0 [internal function]: PDO->query('ALTER TABLE `oc...')\n#1
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(742):
call_user_func_array(Array, Array)\n#2
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(152):
Doctrine\\DBAL\\Connection->query('ALTER TABLE `oc...')\n#3
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(91):
OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#4
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db.php(373):
OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/client...')\n#5
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(965):
OC_DB::updateDbFromStructure('\/var\/www\/client...')\n#6
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(867):
OC_App::updateApp('search_lucene')\n#7
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(92):
OC_App::checkUpgrade('search_lucene')\n#8
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(66):
OC_App::loadApp('search_lucene')\n#9
\/var\/www\/clients\/client1\/web2\/web\/lib\/base.php(689):
OC_App::loadApps()\n#10
\/var\/www\/clients\/client1\/web2\/web\/index.php(30):
OC::handleRequest()\n#11 {main}\n\nNext exception
'Doctrine\\DBAL\\DBALException' with message 'An exception occurred
while executing 'ALTER TABLE `oc_lucene_status` ADD PRIMARY KEY
(`fileid`)':\n\nSQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry '13' for key 'PRIMARY'' in
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php:47\nStack
trace:\n#0
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(744):
Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(PDOException),
'ALTER TABLE `oc...')\n#1
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(152):
Doctrine\\DBAL\\Connection->query('ALTER TABLE `oc...')\n#2
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(91):
OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#3
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db.php(373):
OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/client...')\n#4
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(965):
OC_DB::updateDbFromStructure('\/var\/www\/client...')\n#5
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(867):
OC_App::updateApp('search_lucene')\n#6
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(92):
OC_App::checkUpgrade('search_lucene')\n#7
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(66):
OC_App::loadApp('search_lucene')\n#8
\/var\/www\/clients\/client1\/web2\/web\/lib\/base.php(689):
OC_App::loadApps()\n#9
\/var\/www\/clients\/client1\/web2\/web\/index.php(30):
OC::handleRequest()\n#10
{main})","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: Konnte \"search_lucene\" nicht
aktualisieren.","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: 0
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(92):
OC_App::checkUpgrade('search_lucene')\n","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: 1
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(66):
OC_App::loadApp('search_lucene')\n","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: 2
\/var\/www\/clients\/client1\/web2\/web\/lib\/base.php(689):
OC_App::loadApps()\n","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: 3
\/var\/www\/clients\/client1\/web2\/web\/index.php(30):
OC::handleRequest()\n","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: 4
{main}","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: Konnte \"search_lucene\" nicht
aktualisieren. - Verursacht durch: An exception occurred while executing
'ALTER TABLE `oc_lucene_status` ADD PRIMARY KEY
(`fileid`)':\n\nSQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry '13' for key
'PRIMARY'","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"index","message":"Exception: Konnte \"search_lucene\" nicht
aktualisieren. - Verursacht durch: An exception occurred while executing
'ALTER TABLE `oc_lucene_status` ADD PRIMARY KEY
(`fileid`)':\n\nSQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry '13' for key 'PRIMARY' - Verursacht durch:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'13' for key 'PRIMARY'[23000]
","level":4,"time":"2013-12-11T17:46:38+00:00"}
{"app":"core","message":"Failed to update database structure (exception
'PDOException' with message 'SQLSTATE[23000]: Integrity constraint
violation: 1062 Duplicate entry '13' for key 'PRIMARY'' in
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php:742\nStack
trace:\n#0 [internal function]: PDO->query('ALTER TABLE `oc...')\n#1
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(742):
call_user_func_array(Array, Array)\n#2
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(152):
Doctrine\\DBAL\\Connection->query('ALTER TABLE `oc...')\n#3
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(91):
OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#4
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db.php(373):
OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/client...')\n#5
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(965):
OC_DB::updateDbFromStructure('\/var\/www\/client...')\n#6
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(867):
OC_App::updateApp('search_lucene')\n#7
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(92):
OC_App::checkUpgrade('search_lucene')\n#8
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(66):
OC_App::loadApp('search_lucene')\n#9
\/var\/www\/clients\/client1\/web2\/web\/lib\/base.php(548):
OC_App::loadApps()\n#10
\/var\/www\/clients\/client1\/web2\/web\/lib\/base.php(955):
OC::init()\n#11 \/var\/www\/clients\/client1\/web2\/web\/cron.php(49):
require_once('\/var\/www\/client...')\n#12 {main}\n\nNext exception
'Doctrine\\DBAL\\DBALException' with message 'An exception occurred
while executing 'ALTER TABLE `oc_lucene_status` ADD PRIMARY KEY
(`fileid`)':\n\nSQLSTATE[23000]: Integrity constraint violation: 1062
Duplicate entry '13' for key 'PRIMARY'' in
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php:47\nStack
trace:\n#0
\/var\/www\/clients\/client1\/web2\/web\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(744):
Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(PDOException),
'ALTER TABLE `oc...')\n#1
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(152):
Doctrine\\DBAL\\Connection->query('ALTER TABLE `oc...')\n#2
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db\/mdb2schemamanager.php(91):
OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#3
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/db.php(373):
OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/client...')\n#4
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(965):
OC_DB::updateDbFromStructure('\/var\/www\/client...')\n#5
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(867):
OC_App::updateApp('search_lucene')\n#6
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(92):
OC_App::checkUpgrade('search_lucene')\n#7
\/var\/www\/clients\/client1\/web2\/web\/lib\/private\/app.php(66):
OC_App::loadApp('search_lucene')\n#8
\/var\/www\/clients\/client1\/web2\/web\/lib\/base.php(548):
OC_App::loadApps()\n#9
\/var\/www\/clients\/client1\/web2\/web\/lib\/base.php(955):
OC::init()\n#10 \/var\/www\/clients\/client1\/web2\/web\/cron.php(49):
require_once('\/var\/www\/client...')\n#11
{main})","level":4,"time":"2013-12-11T17:46:39+00:00"}
{"app":"cron","message":"Konnte \"search_lucene\" nicht
aktualisieren.","level":4,"time":"2013-12-11T17:46:39+00:00"}

Has anybody a idae what to do?

---
hermann

Am 11.12.2013 15:43, schrieb Frank Karlitschek:

    Hi guys,





    ownCloud 6 is here.

    Thanks a lot to everyone who contributes to this great release.



    You find some more information is here.

    http://blog.karlitschek.de/2013/12/owncloud-6-is-here.html

    and

    http://owncloud.org/six/





    http://download.owncloud.org/community/owncloud-6.0.0.tar.bz2

    http://download.owncloud.org/community/owncloud-6.0.0.tar.bz2.asc

    http://download.owncloud.org/community/owncloud-6.0.0.tar.bz2.md5

    http://download.owncloud.org/community/owncloud-6.0.0.tar.bz2.sha256





    Thanks a lot to everyone who contributed with code, testing and QA. :-)





    Cheers

    Frank







    _______________________________________________

    Owncloud mailing list

    Owncloud@kde.org  <mailto:Owncloud@kde.org>

    https://mail.kde.org/mailman/listinfo/owncloud



_______________________________________________
Owncloud mailing list
Owncloud@kde.org
https://mail.kde.org/mailman/listinfo/owncloud


_______________________________________________
Owncloud mailing list
Owncloud@kde.org
https://mail.kde.org/mailman/listinfo/owncloud

Reply via email to