Error in database updating from 8.0.3 to 8.1.1 #18248
Comments
|
@gustavoguerra Can I ask you to provide more information about your setup as listed in the issue template https://raw.githubusercontent.com/owncloud/core/master/issue_template.md Thanks |
|
|
@gustavoguerra Attaching anything to the email doesn't work on Github, because they only append the content of the email to the Github conversation. Can you send the info right inside the email? Thanks. |
Steps to reproduceUse de update manager through menu Admin to change OwnCloud from version 8.0.3 to 8.1.1. Expected behaviourKeep the normal behavior. Actual behaviourDuring installation, I received this message (in Portuguese): Atualizando ownCloud para a versão 8.1.1, isso pode demorar um pouco. Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO "oc_jobs"("class", "argument", "last_run") VALUES(?, ?, 0)' with params ["OCA\Files_sharing\Lib\DeleteOrphanedSharesJob", "null"]: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "oc_jobs_pkey" DETAIL: Key (id)=(3) already exists. Then, trying to log in, I got this message (in Portuguese): ownCloud será atualizado para a versão 8.1.1. And the I got the same message above After some tries, the update finished, and now I can log in. An exception occurred while executing 'INSERT INTO "oc_filecache" ("mimepart","mimetype","mtime","size","etag","storage_mtime","permissions","parent","path_hash","path","name","storage") SELECT ?,?,?,?,?,?,?,?,?,?,?,? FROM "oc_filecache" WHERE "storage" = ? AND "path_hash" = ? HAVING COUNT(*) = 0' with params [1, 2, 1439476892, -1, "55ccac9cd7099", 1439476892, 31, 17034, "9099837e99b70dfd8bd8e45f2ab915d8", "files/Documentos/1 Geral/Teste BBBBBB", "Teste BBBBBB", 1, 1, "9099837e99b70dfd8bd8e45f2ab915d8"]: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "oc_filecache_pkey" DETAIL: Key (fileid)=(22997) already exists. The log file jumped to 16MB, there are a lot of messages. The last ones are these two, that are repeated many times: 2015-08-13T14:45:17+00:00 2015-08-13T14:45:17+00:00 Server configurationOperating system: Web server: Database: PHP version: ownCloud version: (see ownCloud admin page) Updated from an older ownCloud or fresh install: List of activated apps:The content of config/config.php: 'ocnmb5dc3udc', 'passwordsalt' => xxx 'secret' => xxx, 'trusted_domains' => array ( 0 => 'baby.celestin.net', 1 => 'baby.criamosjuntos.com', 2 => 'baby.tecitura.com', 3 => 'celestin.net', 4 => 'criamosjuntos.com', 5 => 'tecitura.com', 6 => 'www.celestin.net', 7 => 'www.criamosjuntos.com', 8 => 'www.tecitura.com', 9 => 'nuvem.celestin.net', 10 => 'nuvem.criamosjuntos.com', 11 => 'nuvem.tecitura.com', 12 => 'baby.criamosjuntos.com.br', ), 'datadirectory' => '/home/celestin/Dados-da-nuvem', 'dbtype' => 'pgsql', 'dbhost' => 'pgsql.celestin.net', 'dbname' => 'celestin', 'dbuser' => 'celestin', 'dbpassword' => xxx, 'version' => '8.1.1.3', # Before here was 'version' => '8.0.3.4', 'installed' => true, 'theme' => '', 'maintenance' => false, ); **Are you using external storage, if yes which one:** local/smb/sftp/... No **Are you using encryption:** yes/no No **Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/... No ### Client configuration **Browser:** Firefox 40.0 **Operating system:** Ubuntu 14.04 ### Logs #### Web server error log ? #### ownCloud log (data/owncloud.log) I will send in the next message, because is too big. #### Browser log ? |
|
The end of the log (the last day log is veeery big, like 8 MB): {"reqId":"VcytUH8AAAEAACf6GaQAAABW","remoteAddr":"177.18.156.155","app":"PHP","message":"Cannot modify header information - headers already sent by (output started at /home/celestin/www/baby/lib/private/eventsource.php:99) at /home/celestin/www/baby/lib/private/response.php#103","level":3,"time":"2015-08-13T14:44:34+00:00"} |
|
cat /proc/version |
|
So if I understand well, even a simple action like creating a brand new folder will produce the duplicate key error ? This shouldn't happen unless maybe two people are creating the same folder at the same time. |
|
@gustavoguerra did you have any more luck with 8.1.3 ? Some update issues were fixed meanwhile |
|
This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs. |
While updating OwnCloud from 8.0.3 to 8.1.1 I got this error:
Can anybody help me?
The text was updated successfully, but these errors were encountered: