[Bug]: Database error when running migration 1027Date20230504122946 for app dav: LDAP Operations error #38902
Assignees
Labels
Comments
Chifilly
added
0. Needs triage
Chifilly
changed the title
|
cc @ChristophWurst a second one after nextcloud/all-in-one#2761 |
This comment was marked as off-topic.
This comment was marked as off-topic.
8 tasks
This comment was marked as resolved.
This comment was marked as resolved.
|
Same for you @Chifilly. You posted the access logs. Please find the entry for |
This comment was marked as off-topic.
This comment was marked as off-topic.
This comment was marked as off-topic.
This comment was marked as off-topic.
Yeah, for me this should be safe. https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/transactions.html#transaction-nesting For those using MySQL, can you check that the value in the SHOW TABLE STATUS WHERE Name = 'oc_addressbookchanges';and SELECT MAX(id) FROM oc_addressbookchanges;are the same values? Otherwise this means MySQL had a little issue there. It's possible REPAIR TABLE oc_addressbookchanges;fixes it (don't do it if not needed). It would be nice to get such Nextcloud logs from PostgreSQL users as well. @Chifilly |
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12833
Server version: 11.0.2-MariaDB-1:11.0.2+maria~ubu2204 mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [nextcloud]> SHOW TABLE STATUS WHERE Name = 'oc_addressbookchanges';
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| oc_addressbookchanges | InnoDB | 10 | Compressed | 0 | 0 | 8192 | 0 | 8192 | 0 | 61 | 2022-04-21 00:30:13 | NULL | NULL | utf8mb4_bin | NULL | row_format=COMPRESSED | | 0 | N |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
1 row in set (0.009 sec)
MariaDB [nextcloud]> SELECT MAX(id) FROM oc_addressbookchanges;
+---------+
| MAX(id) |
+---------+
| 408 |
+---------+
1 row in set (0.003 sec)
MariaDB [nextcloud]>my values are not the same repair is not supported MariaDB [nextcloud]> REPAIR TABLE oc_addressbookchanges;
+---------------------------------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------+--------+----------+---------------------------------------------------------+
| nextcloud.oc_addressbookchanges | repair | note | The storage engine for the table doesn't support repair |
+---------------------------------+--------+----------+---------------------------------------------------------+
1 row in set (0.001 sec) |
|
This should do it then. The value (here 409) should be equal to the current ALTER TABLE oc_addressbookchanges AUTO_INCREMENT=409; |
MariaDB [nextcloud]> SELECT MAX(id) FROM oc_addressbookchanges;
+---------+
| MAX(id) |
+---------+
| 408 |
+---------+
1 row in set (0.001 sec)
MariaDB [nextcloud]> SHOW TABLE STATUS WHERE Name = 'oc_addressbookchanges';
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| oc_addressbookchanges | InnoDB | 10 | Compressed | 0 | 0 | 8192 | 0 | 8192 | 0 | 61 | 2022-04-21 00:30:13 | NULL | NULL | utf8mb4_bin | NULL | row_format=COMPRESSED | | 0 | N |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
1 row in set (0.009 sec)
MariaDB [nextcloud]> ALTER TABLE oc_addressbookchanges AUTO_INCREMENT=409;
Query OK, 0 rows affected (0.014 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [nextcloud]> SELECT MAX(id) FROM oc_addressbookchanges;
+---------+
| MAX(id) |
+---------+
| 408 |
+---------+
1 row in set (0.002 sec)
MariaDB [nextcloud]> SHOW TABLE STATUS WHERE Name = 'oc_addressbookchanges';
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| oc_addressbookchanges | InnoDB | 10 | Compressed | 0 | 0 | 8192 | 0 | 8192 | 0 | 409 | 2023-06-20 14:57:33 | NULL | NULL | utf8mb4_bin | NULL | row_format=COMPRESSED | | 0 | N |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
1 row in set (0.009 sec)
MariaDB [nextcloud]> SHOW TABLE STATUS WHERE Name = 'oc_addressbookchanges';
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
| oc_addressbookchanges | InnoDB | 10 | Compressed | 408 | 80 | 32768 | 0 | 8192 | 0 | 410 | 2023-06-20 14:57:33 | NULL | NULL | utf8mb4_bin | NULL | row_format=COMPRESSED | | 0 | N |
+-----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------+----------+-----------------------+---------+------------------+-----------+
1 row in set (0.009 sec)done still same issue. afte start upgrade Auto_increment has value 410. nextcloud.log {"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:24+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::maintenanceEnabled: Turned on maintenance mode","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":0,"time":"2023-06-20T13:09:24+00:00","remoteAddr":"192.168.178.3","user":"--","app":"core","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"starting upgrade from 26.0.2.1 to 27.0.0.8","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"core"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:24+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Repair MySQL collation","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:24+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"OC\\Repair\\Events\\RepairInfoEvent: Repair info: All tables already have the correct collation -> nothing to do","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:24+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Repair SQLite autoincrement","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:24+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Copy data from accounts table when migrating from ownCloud","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:26+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Drop account terms table when migrating from ownCloud","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:26+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::dbUpgradeBefore: Updating database schema","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:26+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::dbUpgrade: Updated database","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:26+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::appUpgradeStarted: Updating <dav> ...","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":3,"time":"2023-06-20T13:09:27+00:00","remoteAddr":"192.168.178.3","user":"--","app":"no app in context","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","exception":{"Exception":"Exception","Message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'","Code":0,"Trace":[{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/lib/private/DB/MigrationService.php","Line":421,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException","Message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1814,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1749,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1163,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"INSERT INTO `oc_cards_properties` (`addressbookid`, `cardid`, `name`, `value`, `preferred`) VALUES(?, ?, ?, ?, ?)",["*** sensitive parameters replaced ***",159,"UID","Anna",0],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":295,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_cards_properties` (`addressbookid`, `cardid`, `name`, `value`, `preferred`) VALUES(?, ?, ?, ?, ?)",["*** sensitive parameters replaced ***",159,"UID","Anna",0],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_cards_properties` (`addressbookid`, `cardid`, `name`, `value`, `preferred`) VALUES(:dcValue1, :dcValue2, :name, :value, :preferred)",["*** sensitive parameters replaced ***",159,"UID","Anna",0],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":1335,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":1303,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":740,"function":"updateProperties","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":718,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":241,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":229,"function":"atomic","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":278,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":527,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":277,"function":"callForAllUsers","class":"OC\\User\\Manager","type":"->","args":[["Closure"]]},{"file":"/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php","line":52,"function":"syncInstance","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":537,"function":"postSchemaChange","class":"OCA\\DAV\\Migration\\Version1027Date20230504122946","type":"->","args":[["OC\\Migration\\SimpleOutput"],["Closure"],["oc_"]]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":417,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["1027Date20230504122946",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":64,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'","Code":1062,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":103,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["23000",1062,"Duplicate entry '49' for key 'PRIMARY'"]]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":295,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_cards_properties` (`addressbookid`, `cardid`, `name`, `value`, `preferred`) VALUES(?, ?, ?, ?, ?)",["*** sensitive parameters replaced ***",159,"UID","Anna",0],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_cards_properties` (`addressbookid`, `cardid`, `name`, `value`, `preferred`) VALUES(:dcValue1, :dcValue2, :name, :value, :preferred)",["*** sensitive parameters replaced ***",159,"UID","Anna",0],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":1335,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":1303,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":740,"function":"updateProperties","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":718,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":241,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":229,"function":"atomic","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":278,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":527,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":277,"function":"callForAllUsers","class":"OC\\User\\Manager","type":"->","args":[["Closure"]]},{"file":"/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php","line":52,"function":"syncInstance","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":537,"function":"postSchemaChange","class":"OCA\\DAV\\Migration\\Version1027Date20230504122946","type":"->","args":[["OC\\Migration\\SimpleOutput"],["Closure"],["oc_"]]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":417,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["1027Date20230504122946",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":30,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'","Code":"23000","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":101,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":295,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_cards_properties` (`addressbookid`, `cardid`, `name`, `value`, `preferred`) VALUES(?, ?, ?, ?, ?)",["*** sensitive parameters replaced ***",159,"UID","Anna",0],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_cards_properties` (`addressbookid`, `cardid`, `name`, `value`, `preferred`) VALUES(:dcValue1, :dcValue2, :name, :value, :preferred)",["*** sensitive parameters replaced ***",159,"UID","Anna",0],["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":1335,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":1303,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":740,"function":"updateProperties","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/CardDavBackend.php","line":718,"function":"atomic","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":241,"function":"updateCard","class":"OCA\\DAV\\CardDAV\\CardDavBackend","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":229,"function":"atomic","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":278,"function":"updateUser","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Manager.php","line":527,"function":"OCA\\DAV\\CardDAV\\{closure}","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/CardDAV/SyncService.php","line":277,"function":"callForAllUsers","class":"OC\\User\\Manager","type":"->","args":[["Closure"]]},{"file":"/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php","line":52,"function":"syncInstance","class":"OCA\\DAV\\CardDAV\\SyncService","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":537,"function":"postSchemaChange","class":"OCA\\DAV\\Migration\\Version1027Date20230504122946","type":"->","args":[["OC\\Migration\\SimpleOutput"],["Closure"],["oc_"]]},{"file":"/var/www/html/lib/private/DB/MigrationService.php","line":417,"function":"executeStep","class":"OC\\DB\\MigrationService","type":"->","args":["1027Date20230504122946",false]},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":844,"function":"migrate","class":"OC\\DB\\MigrationService","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":359,"function":"updateApp","class":"OC_App","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Updater.php","line":271,"function":"doAppUpgrade","class":"OC\\Updater","type":"->","args":[]},{"file":"/var/www/html/lib/private/Updater.php","line":139,"function":"doUpgrade","class":"OC\\Updater","type":"->","args":["27.0.0.8","26.0.2.1"]},{"file":"/var/www/html/core/ajax/update.php","line":185,"function":"upgrade","class":"OC\\Updater","type":"->","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":101}}},"message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'","exception":{},"CustomMessage":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'"}}
{"reqId":"KmELhXM4379vCE57hgff","level":3,"time":"2023-06-20T13:09:27+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::failure: Exception: Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '49' for key 'PRIMARY'","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":3,"time":"2023-06-20T13:09:27+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::updateEnd: Update failed","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:27+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::maintenanceActive: Maintenance mode is kept active","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}}
{"reqId":"KmELhXM4379vCE57hgff","level":1,"time":"2023-06-20T13:09:27+00:00","remoteAddr":"192.168.178.3","user":"--","app":"updater","method":"GET","url":"/core/ajax/update.php?requesttoken=W1DZKixXMwC2jK2z2bUoVVNLkSoeQ0GsUxKgvoKzr%2F0%3D%3AF2GTZ2YESUPP5%2BrUkNIYPQsYwm5xATb2HEjU%2B8jgwas%3D","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36","version":"26.0.2.1","data":{"app":"updater"}} |
|
For me, there seems to be 3 relevant lines in my {
"reqId": "ilirH5idSrBdOv9BO4lm",
"level": 3,
"time": "2023-06-20T15:36:55+00:00",
"remoteAddr": "172.16.0.11",
"user": "--",
"app": "PHP",
"method": "GET",
"url": "/core/ajax/update.php?requesttoken=CWkaghVWn1QekcbCp1FROTphbRbBOugS9fqLTfBvJbM%3D%3AWF9txV1h0idsqJGV3mgBfE0ROHSxYo9FuYzRHpQraoY%3D",
"message": "ldap_search(): Search: Operations error at /var/www/html/apps/user_ldap/lib/LDAP.php#306",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/114.0",
"version": "26.0.2.1",
"data": {
"app": "PHP"
}
}{
"reqId": "ilirH5idSrBdOv9BO4lm",
"level": 0,
"time": "2023-06-20T15:36:55+00:00",
"remoteAddr": "172.16.0.11",
"user": "--",
"app": "user_ldap",
"method": "GET",
"url": "/core/ajax/update.php?requesttoken=CWkaghVWn1QekcbCp1FROTphbRbBOugS9fqLTfBvJbM%3D%3AWF9txV1h0idsqJGV3mgBfE0ROHSxYo9FuYzRHpQraoY%3D",
"message": "LDAP error Operations error (1) after calling ldap_search",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/114.0",
"version": "26.0.2.1",
"data": {
"app": "user_ldap"
}
}{
"reqId": "ilirH5idSrBdOv9BO4lm",
"level": 3,
"time": "2023-06-20T15:36:55+00:00",
"remoteAddr": "172.16.0.11",
"user": "--",
"app": "no app in context",
"method": "GET",
"url": "/core/ajax/update.php?requesttoken=CWkaghVWn1QekcbCp1FROTphbRbBOugS9fqLTfBvJbM%3D%3AWF9txV1h0idsqJGV3mgBfE0ROHSxYo9FuYzRHpQraoY%3D",
"message": "Database error when running migration 1027Date20230504122946 for app dav\nLDAP Operations error",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/114.0",
"version": "26.0.2.1",
"exception": {
"Exception": "Exception",
"Message": "Database error when running migration 1027Date20230504122946 for app dav\nLDAP Operations error",
"Code": 0,
"Trace": [
{
"file": "/var/www/html/lib/private/legacy/OC_App.php",
"line": 844,
"function": "migrate",
"class": "OC\\DB\\MigrationService",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/Updater.php",
"line": 359,
"function": "updateApp",
"class": "OC_App",
"type": "::",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/Updater.php",
"line": 271,
"function": "doAppUpgrade",
"class": "OC\\Updater",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/Updater.php",
"line": 139,
"function": "doUpgrade",
"class": "OC\\Updater",
"type": "->",
"args": [
"27.0.0.8",
"26.0.2.1"
]
},
{
"file": "/var/www/html/core/ajax/update.php",
"line": 185,
"function": "upgrade",
"class": "OC\\Updater",
"type": "->",
"args": []
}
],
"File": "/var/www/html/lib/private/DB/MigrationService.php",
"Line": 421,
"Previous": {
"Exception": "Exception",
"Message": "LDAP Operations error",
"Code": 1,
"Trace": [
{
"file": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"line": 411,
"function": "processLDAPError",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
1,
"Operations error"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"line": 308,
"function": "postFunctionCall",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"line": 214,
"function": "invokeLDAPMethod",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"function": "search",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1065,
"function": "call_user_func_array",
"args": [
[
[
"OCA\\User_LDAP\\LDAP"
],
"*** sensitive parameters replaced ***"
],
[
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1068,
"function": "OCA\\User_LDAP\\{closure}",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1126,
"function": "invokeLDAPMethod",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1290,
"function": "executeSearch",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 977,
"function": "search",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 869,
"function": "searchUsers",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/User_LDAP.php",
"line": 284,
"function": "fetchListOfUsers",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/User_Proxy.php",
"line": 205,
"function": "getUsers",
"class": "OCA\\User_LDAP\\User_LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 521,
"function": "getUsers",
"class": "OCA\\User_LDAP\\User_Proxy",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/dav/lib/CardDAV/SyncService.php",
"line": 277,
"function": "callForAllUsers",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
[
"Closure"
]
]
},
{
"file": "/var/www/html/apps/dav/lib/Migration/Version1027Date20230504122946.php",
"line": 52,
"function": "syncInstance",
"class": "OCA\\DAV\\CardDAV\\SyncService",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/DB/MigrationService.php",
"line": 537,
"function": "postSchemaChange",
"class": "OCA\\DAV\\Migration\\Version1027Date20230504122946",
"type": "->",
"args": [
[
"OC\\Migration\\SimpleOutput"
],
[
"Closure"
],
[
"oc_"
]
]
},
{
"file": "/var/www/html/lib/private/DB/MigrationService.php",
"line": 417,
"function": "executeStep",
"class": "OC\\DB\\MigrationService",
"type": "->",
"args": [
"1027Date20230504122946",
false
]
},
{
"file": "/var/www/html/lib/private/legacy/OC_App.php",
"line": 844,
"function": "migrate",
"class": "OC\\DB\\MigrationService",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/Updater.php",
"line": 359,
"function": "updateApp",
"class": "OC_App",
"type": "::",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/Updater.php",
"line": 271,
"function": "doAppUpgrade",
"class": "OC\\Updater",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/Updater.php",
"line": 139,
"function": "doUpgrade",
"class": "OC\\Updater",
"type": "->",
"args": [
"27.0.0.8",
"26.0.2.1"
]
},
{
"file": "/var/www/html/core/ajax/update.php",
"line": 185,
"function": "upgrade",
"class": "OC\\Updater",
"type": "->",
"args": []
}
],
"File": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"Line": 379
},
"message": "Database error when running migration 1027Date20230504122946 for app dav\nLDAP Operations error",
"exception": {},
"CustomMessage": "Database error when running migration 1027Date20230504122946 for app dav\nLDAP Operations error"
}
} |
|
I have the same symptoms but without user_ldap activated. Error message: {
"reqId":"dvK4KAT0GSaAbg2VDrE3",
"level":3,
"time":"2023-06-20T23:34:02+00:00",
"remoteAddr":"",
"user":"--",
"app":"no app in context",
"method":"",
"url":"--",
"message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value",
"userAgent":"--",
"version":"26.0.2.1",
"exception":{
"Exception":"Exception",
"Message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value",
"Code":0,
"Trace":[
{
"file":"/config/www/nextcloud/lib/private/legacy/OC_App.php",
"line":844,
"function":"migrate",
"class":"OC\\DB\\MigrationService",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":359,
"function":"updateApp",
"class":"OC_App",
"type":"::",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":271,
"function":"doAppUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":139,
"function":"doUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/core/Command/Upgrade.php",
"line":225,
"function":"upgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
"line":298,
"function":"execute",
"class":"OC\\Core\\Command\\Upgrade",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":1040,
"function":"run",
"class":"Symfony\\Component\\Console\\Command\\Command",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":301,
"function":"doRunCommand",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":171,
"function":"doRun",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Console/Application.php",
"line":211,
"function":"run",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/console.php",
"line":100,
"function":"run",
"class":"OC\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/occ",
"line":11,
"args":[
"/config/www/nextcloud/console.php"
],
"function":"require_once"
}
],
"File":"/config/www/nextcloud/lib/private/DB/MigrationService.php",
"Line":421,
"Previous":{
"Exception":"Doctrine\\DBAL\\Exception\\NotNullConstraintViolationException",
"Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value",
"Code":1364,
"Trace":[
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line":1814,
"function":"convert",
"class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line":1749,
"function":"handleDriverException",
"class":"Doctrine\\DBAL\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line":1163,
"function":"convertExceptionDuringQuery",
"class":"Doctrine\\DBAL\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/Connection.php",
"line":295,
"function":"executeStatement",
"class":"Doctrine\\DBAL\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line":354,
"function":"executeStatement",
"class":"OC\\DB\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line":280,
"function":"execute",
"class":"Doctrine\\DBAL\\Query\\QueryBuilder",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":433,
"function":"execute",
"class":"OC\\DB\\QueryBuilder\\QueryBuilder",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php",
"line":63,
"function":"OCA\\DAV\\CardDAV\\{closure}",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":422,
"function":"atomic",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":125,
"function":"createAddressBook",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php",
"line":63,
"function":"OCA\\DAV\\CardDAV\\{closure}",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":120,
"function":"atomic",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":267,
"function":"ensureSystemAddressBookExists",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":276,
"function":"getLocalSystemAddressBook",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/Migration/Version1027Date20230504122946.php",
"line":52,
"function":"syncInstance",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/private/DB/MigrationService.php",
"line":537,
"function":"postSchemaChange",
"class":"OCA\\DAV\\Migration\\Version1027Date20230504122946",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/MigrationService.php",
"line":417,
"function":"executeStep",
"class":"OC\\DB\\MigrationService",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/legacy/OC_App.php",
"line":844,
"function":"migrate",
"class":"OC\\DB\\MigrationService",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":359,
"function":"updateApp",
"class":"OC_App",
"type":"::",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":271,
"function":"doAppUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":139,
"function":"doUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/core/Command/Upgrade.php",
"line":225,
"function":"upgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
"line":298,
"function":"execute",
"class":"OC\\Core\\Command\\Upgrade",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":1040,
"function":"run",
"class":"Symfony\\Component\\Console\\Command\\Command",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":301,
"function":"doRunCommand",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":171,
"function":"doRun",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Console/Application.php",
"line":211,
"function":"run",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/console.php",
"line":100,
"function":"run",
"class":"OC\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/occ",
"line":11,
"args":[
"/config/www/nextcloud/console.php"
],
"function":"require_once"
}
],
"File":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
"Line":116,
"Previous":{
"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception",
"Message":"SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value",
"Code":1364,
"Trace":[
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line":103,
"function":"new",
"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type":"::"
},
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line":1155,
"function":"execute",
"class":"Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/Connection.php",
"line":295,
"function":"executeStatement",
"class":"Doctrine\\DBAL\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line":354,
"function":"executeStatement",
"class":"OC\\DB\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line":280,
"function":"execute",
"class":"Doctrine\\DBAL\\Query\\QueryBuilder",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":433,
"function":"execute",
"class":"OC\\DB\\QueryBuilder\\QueryBuilder",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php",
"line":63,
"function":"OCA\\DAV\\CardDAV\\{closure}",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":422,
"function":"atomic",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":125,
"function":"createAddressBook",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php",
"line":63,
"function":"OCA\\DAV\\CardDAV\\{closure}",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":120,
"function":"atomic",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":267,
"function":"ensureSystemAddressBookExists",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":276,
"function":"getLocalSystemAddressBook",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/Migration/Version1027Date20230504122946.php",
"line":52,
"function":"syncInstance",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/private/DB/MigrationService.php",
"line":537,
"function":"postSchemaChange",
"class":"OCA\\DAV\\Migration\\Version1027Date20230504122946",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/MigrationService.php",
"line":417,
"function":"executeStep",
"class":"OC\\DB\\MigrationService",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/legacy/OC_App.php",
"line":844,
"function":"migrate",
"class":"OC\\DB\\MigrationService",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":359,
"function":"updateApp",
"class":"OC_App",
"type":"::",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":271,
"function":"doAppUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":139,
"function":"doUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/core/Command/Upgrade.php",
"line":225,
"function":"upgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
"line":298,
"function":"execute",
"class":"OC\\Core\\Command\\Upgrade",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":1040,
"function":"run",
"class":"Symfony\\Component\\Console\\Command\\Command",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":301,
"function":"doRunCommand",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":171,
"function":"doRun",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Console/Application.php",
"line":211,
"function":"run",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/console.php",
"line":100,
"function":"run",
"class":"OC\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/occ",
"line":11,
"args":[
"/config/www/nextcloud/console.php"
],
"function":"require_once"
}
],
"File":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
"Line":30,
"Previous":{
"Exception":"PDOException",
"Message":"SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value",
"Code":"HY000",
"Trace":[
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line":101,
"function":"execute",
"class":"PDOStatement",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line":1155,
"function":"execute",
"class":"Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/Connection.php",
"line":295,
"function":"executeStatement",
"class":"Doctrine\\DBAL\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line":354,
"function":"executeStatement",
"class":"OC\\DB\\Connection",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line":280,
"function":"execute",
"class":"Doctrine\\DBAL\\Query\\QueryBuilder",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":433,
"function":"execute",
"class":"OC\\DB\\QueryBuilder\\QueryBuilder",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php",
"line":63,
"function":"OCA\\DAV\\CardDAV\\{closure}",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/CardDavBackend.php",
"line":422,
"function":"atomic",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":125,
"function":"createAddressBook",
"class":"OCA\\DAV\\CardDAV\\CardDavBackend",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/public/AppFramework/Db/TTransactional.php",
"line":63,
"function":"OCA\\DAV\\CardDAV\\{closure}",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":120,
"function":"atomic",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":267,
"function":"ensureSystemAddressBookExists",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/CardDAV/SyncService.php",
"line":276,
"function":"getLocalSystemAddressBook",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->"
},
{
"file":"/config/www/nextcloud/apps/dav/lib/Migration/Version1027Date20230504122946.php",
"line":52,
"function":"syncInstance",
"class":"OCA\\DAV\\CardDAV\\SyncService",
"type":"->",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/private/DB/MigrationService.php",
"line":537,
"function":"postSchemaChange",
"class":"OCA\\DAV\\Migration\\Version1027Date20230504122946",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/DB/MigrationService.php",
"line":417,
"function":"executeStep",
"class":"OC\\DB\\MigrationService",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/legacy/OC_App.php",
"line":844,
"function":"migrate",
"class":"OC\\DB\\MigrationService",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":359,
"function":"updateApp",
"class":"OC_App",
"type":"::",
"args":[
"*** sensitive parameters replaced ***"
]
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":271,
"function":"doAppUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Updater.php",
"line":139,
"function":"doUpgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/core/Command/Upgrade.php",
"line":225,
"function":"upgrade",
"class":"OC\\Updater",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Command/Command.php",
"line":298,
"function":"execute",
"class":"OC\\Core\\Command\\Upgrade",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":1040,
"function":"run",
"class":"Symfony\\Component\\Console\\Command\\Command",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":301,
"function":"doRunCommand",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/3rdparty/symfony/console/Application.php",
"line":171,
"function":"doRun",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/lib/private/Console/Application.php",
"line":211,
"function":"run",
"class":"Symfony\\Component\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/console.php",
"line":100,
"function":"run",
"class":"OC\\Console\\Application",
"type":"->"
},
{
"file":"/config/www/nextcloud/occ",
"line":11,
"args":[
"/config/www/nextcloud/console.php"
],
"function":"require_once"
}
],
"File":"/config/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"Line":101
}
}
},
"message":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value",
"exception":{
},
"CustomMessage":"Database error when running migration 1027Date20230504122946 for app dav\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value"
}
}Searching in MariaDB for columns with "id" i got this: |
|
I also tried to docker-compose up -d my installation (with nextcloud image 27.0.0, mariadb 11.0.2). I was struggling with a similar issue and got it working again. Problem seems to be the user_ldap app. I disabled it after the first failed upgrade attempt, then did the (successful) upgrade, and re-enabled it. Hope this bit of information helps a bit. Good luck. |
Thank you! Doing that allowed me to update, however the original issue is still relevant, since having |
I think this only helps with the symptoms because during your upgrade most users would not have been found so the problematic migration of their data didn't happen. |
|
Maybe it would be good to put the sync address book into a command and warn in the admin overview if it was not run instead of running it in a migration? |
|
Then we'll get the but I don't have access to CLI complaint. That's why we run it for all instances. |
|
Yet thanks for the idea. @bpoppinga23 please try running https://github.com/nextcloud/server/blob/master/apps/dav/lib/Command/SyncSystemAddressBook.php for the existing CLI command. |
|
In my case, I got Nextcloud working again. (user_ldap is not installed, so the cause of problem is different) But entering the command: |
|
Thanks for checking.
It happens when the system address book is created.
From your dump at #38902 (comment) I see it's not a PRI nor auto_increment. |
|
@ChristophWurst mine didn't work ubuntu@docker:~$ docker exec -it -u 33 nextcloud php occ dav:sync-system-addressbook
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
There are no commands defined in the "dav" namespace.
ubuntu@docker:~$ docker exec -it -u 33 nextcloud php occ app:disable dav
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
dav can't be disabled.what shall i do to get upgrade ready? |
This comment was marked as resolved.
This comment was marked as resolved.
This comment was marked as resolved.
This comment was marked as resolved.
|
I don't know. Please restore your backup and wait for this issue to be resolved. |
8 tasks
|
@Chifilly @kimberlyeet thanks a lot. I'm surprised tbh. I expected 50k users instances 🙈
That is good (for me) because then we can continue the debugging. Let's run this command with all debug options:
Then inspect your data/nextcloud.log and drop the log messages that were written the time you ran the command. We should see the LDAP commands run in the background and hopefully get more info about the failed search. |
|
Figured I'd chime in on this too, Using Authentik as my backend for LDAP |
|
I'll also add that since the upgrade, not only did LDAP initally break, but being able to view the users tab has also broken now
|
|
Here are the logs from me; {
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:02+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Calling LDAP function ldap_connect with parameters [\"ldap:\\/\\/authentik-outpost--ldap:3389\"]",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:02+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Calling LDAP function ldap_set_option with parameters [{},17,3]",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:02+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Calling LDAP function ldap_set_option with parameters [{},8,0]",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:02+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Calling LDAP function ldap_set_option with parameters [{},20485,\"15\"]",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:02+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Calling LDAP function ldap_bind with parameters [{},\"cn=admin,ou=users,dc=nextcloud,dc=allsopp,dc=local\",\"***REDACTED***\"]",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:03+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "initializing paged search for filter (&(memberOf=CN=Access - Nextcloud,OU=groups,DC=nextcloud,DC=allsopp,DC=local)(displayname=*)(|(displayname=)(displayname=*))), base ou=users,dc=nextcloud,dc=allsopp,dc=local, attr [\"entryuuid\",\"nsuniqueid\",\"objectguid\",\"guid\",\"ipauniqueid\",\"dn\",\"uid\",\"samaccountname\",\"memberof\",\"mail\",\"displayname\",\"jpegphoto\",\"thumbnailphoto\"], pageSize 500, offset 0",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:03+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Ready for a paged search",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:03+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Calling LDAP function ldap_search with parameters [{},\"ou=users,dc=nextcloud,dc=allsopp,dc=local\",\"(&(memberOf=CN=Access - Nextcloud,OU=groups,DC=nextcloud,DC=allsopp,DC=local)(displayname=*)(|(displayname=)(displayname=*)))\",[\"entryuuid\",\"nsuniqueid\",\"objectguid\",\"guid\",\"ipauniqueid\",\"dn\",\"uid\",\"samaccountname\",\"memberof\",\"mail\",\"displayname\",\"jpegphoto\",\"thumbnailphoto\"],0,0,-1,0,[{\"oid\":\"1.2.840.113556.1.4.319\",\"value\":{\"size\":500,\"cookie\":\"\"},\"iscritical\":false}]]",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 3,
"time": "2023-06-27T12:45:03+00:00",
"remoteAddr": "",
"user": "--",
"app": "PHP",
"method": "",
"url": "--",
"message": "ldap_search(): Search: Operations error at /var/www/html/apps/user_ldap/lib/LDAP.php#306",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "PHP"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:03+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "LDAP error Operations error (1) after calling ldap_search",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 3,
"time": "2023-06-27T12:45:03+00:00",
"remoteAddr": "",
"user": "--",
"app": "core",
"method": "",
"url": "--",
"message": "Error while running background job (class: OCA\\User_LDAP\\Jobs\\Sync, arguments: )",
"userAgent": "--",
"version": "27.0.0.8",
"exception": {
"Exception": "Exception",
"Message": "LDAP Operations error",
"Code": 1,
"Trace": [
{
"file": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"line": 411,
"function": "processLDAPError",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
1,
"Operations error"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"line": 308,
"function": "postFunctionCall",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"line": 214,
"function": "invokeLDAPMethod",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"function": "search",
"class": "OCA\\User_LDAP\\LDAP",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1065,
"function": "call_user_func_array",
"args": [
[
[
"OCA\\User_LDAP\\LDAP"
],
"*** sensitive parameters replaced ***"
],
[
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1068,
"function": "OCA\\User_LDAP\\{closure}",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1126,
"function": "invokeLDAPMethod",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 1290,
"function": "executeSearch",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 977,
"function": "search",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Access.php",
"line": 869,
"function": "searchUsers",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Jobs/Sync.php",
"line": 169,
"function": "fetchListOfUsers",
"class": "OCA\\User_LDAP\\Access",
"type": "->",
"args": [
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
true
]
},
{
"file": "/var/www/html/apps/user_ldap/lib/Jobs/Sync.php",
"line": 143,
"function": "runCycle",
"class": "OCA\\User_LDAP\\Jobs\\Sync",
"type": "->",
"args": [
[
"s01",
"*** sensitive parameters replaced ***"
]
]
},
{
"file": "/var/www/html/lib/public/BackgroundJob/Job.php",
"line": 86,
"function": "run",
"class": "OCA\\User_LDAP\\Jobs\\Sync",
"type": "->",
"args": [
null
]
},
{
"file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php",
"line": 103,
"function": "start",
"class": "OCP\\BackgroundJob\\Job",
"type": "->",
"args": [
[
"OC\\BackgroundJob\\JobList"
]
]
},
{
"file": "/var/www/html/lib/public/BackgroundJob/TimedJob.php",
"line": 93,
"function": "start",
"class": "OCP\\BackgroundJob\\TimedJob",
"type": "->",
"args": [
[
"OC\\BackgroundJob\\JobList"
]
]
},
{
"file": "/var/www/html/cron.php",
"line": 152,
"function": "execute",
"class": "OCP\\BackgroundJob\\TimedJob",
"type": "->",
"args": [
[
"OC\\BackgroundJob\\JobList"
],
[
"OC\\Log"
]
]
}
],
"File": "/var/www/html/apps/user_ldap/lib/LDAP.php",
"Line": 379,
"message": "Error while running background job (class: OCA\\User_LDAP\\Jobs\\Sync, arguments: )",
"exception": {},
"CustomMessage": "Error while running background job (class: OCA\\User_LDAP\\Jobs\\Sync, arguments: )"
}
}
{
"reqId": "1IAV3J2CIoke20M2s8OF",
"level": 0,
"time": "2023-06-27T12:45:04+00:00",
"remoteAddr": "",
"user": "--",
"app": "user_ldap",
"method": "",
"url": "--",
"message": "Calling LDAP function ldap_unbind with parameters [{}]",
"userAgent": "--",
"version": "27.0.0.8",
"data": {
"app": "user_ldap"
}
}Also, I think the logs for the |
Could you check if there is a ticket and if not create one? Thanks |
|
@aaronnad what LDAP server do you use? |
|
8 tasks
|
@Chifilly could you share your (redacted) login and user filters? You can access them via |
Strange, because it worked fine prior to v27, and when I go into the LDAP/AD integration settings and click
The only thing I redacted was the plain text password in my logs, but here's my config; |
|
Hi @Chifilly are you using some kind of appliance? How did you install Nextcloud? |
It's installed via Docker on an old computer that I turned into a server that's running Ubuntu 20.04.6 |
|
And which docker inage are you using? |
The docker official image nextcloud |
|
I suspect the bug comes from #32499 diff --git a/apps/user_ldap/lib/Access.php b/apps/user_ldap/lib/Access.php
index 3fbb003ed51..0b115c42764 100644
--- a/apps/user_ldap/lib/Access.php
+++ b/apps/user_ldap/lib/Access.php
@@ -1545,12 +1545,16 @@ class Access extends LDAPUtility {
return '';
}
// wildcards don't work with some attributes
- $filter[] = $fallbackAttribute . '=' . $originalSearch;
+ if ($originalSearch !== '') {
+ $filter[] = $fallbackAttribute . '=' . $originalSearch;
+ }
$filter[] = $fallbackAttribute . '=' . $search;
} else {
foreach ($searchAttributes as $attribute) {
// wildcards don't work with some attributes
- $filter[] = $attribute . '=' . $originalSearch;
+ if ($originalSearch !== '') {
+ $filter[] = $attribute . '=' . $originalSearch;
+ }
$filter[] = $attribute . '=' . $search;
}
} |
ChristophWurst
added
1. to develop
4 tasks
Merged
5 tasks
tcitworld
added a commit
that referenced
this issue
Jul 27, 2023
Using nested transactions without savepoints is actually deprecated by Doctrine: https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/transactions.html#transaction-nesting Without savepoints, a nested transaction can be rollbacked but not handled properly in the "real" transaction, leading to the following error: Transaction commit failed because the transaction has been marked for rollback only. Ref #36528 (comment) (and possibly) #38902 (comment) Signed-off-by: Thomas Citharel <tcit@tcit.fr>
6 tasks
ChristophWurst
added
3. to review
tcitworld
added a commit
that referenced
this issue
Oct 6, 2023
Using nested transactions without savepoints is actually deprecated by Doctrine: https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/transactions.html#transaction-nesting Without savepoints, a nested transaction can be rollbacked but not handled properly in the "real" transaction, leading to the following error: Transaction commit failed because the transaction has been marked for rollback only. Ref #36528 (comment) (and possibly) #38902 (comment) Signed-off-by: Thomas Citharel <tcit@tcit.fr>
8 tasks
tcitworld
added a commit
that referenced
this issue
Feb 1, 2024
Using nested transactions without savepoints is actually deprecated by Doctrine: https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/transactions.html#transaction-nesting Without savepoints, a nested transaction can be rollbacked but not handled properly in the "real" transaction, leading to the following error: Transaction commit failed because the transaction has been marked for rollback only. Ref #36528 (comment) (and possibly) #38902 (comment) Signed-off-by: Thomas Citharel <tcit@tcit.fr>
AndyScherzinger
pushed a commit
that referenced
this issue
Feb 27, 2024
Using nested transactions without savepoints is actually deprecated by Doctrine: https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/transactions.html#transaction-nesting Without savepoints, a nested transaction can be rollbacked but not handled properly in the "real" transaction, leading to the following error: Transaction commit failed because the transaction has been marked for rollback only. Ref #36528 (comment) (and possibly) #38902 (comment) Signed-off-by: Thomas Citharel <tcit@tcit.fr>
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug description
This bug report is similar to #38873 however it's a different outcome. I didn't know whether they're actually related or not, so I opted to create a new bug report.
Updating my Nextcloud instance causes the
Update to 27.0.0prompt to appear, but updating throws the following error and logs:Steps to reproduce
looking at the error, the
user_ldapapp potentially needs to be installed tooExpected behavior
The migration works and I can access Nextcloud again
Installation method
Community Docker image
Nextcloud Server version
27
Operating system
Debian/Ubuntu
PHP engine version
None
Web server
Apache (supported)
Database engine version
PostgreSQL
Is this bug present after an update or on a fresh install?
Upgraded to a MAJOR version (ex. 22 to 23)
Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
What user-backends are you using?
Configuration report
{ "system": { "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\APCu", "apps_paths": [ { "path": "\/var\/www\/html\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/www\/html\/custom_apps", "url": "\/custom_apps", "writable": true } ], "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "password": "***REMOVED SENSITIVE VALUE***", "port": 6379 }, "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "***REDACTED BY ME***" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "26.0.2.1", "overwrite.cli.url": "***REDACTED BY ME***", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory", "overwritehost": "***REDACTED BY ME***", "overwriteprotocol": "https", "loglevel": 2, "maintenance": false, "app_install_overwrite": [ "officeonline" ], "has_rebuilt_cache": true, "theme": "" } }List of activated Apps
Nextcloud Signing status
Can't access this URL since it's still prompting to update to 27.0.0Nextcloud Logs
Additional info
No response
The text was updated successfully, but these errors were encountered: