Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO oc_properties (userid,propertypath,propertyname,propertyvalue) VALUES(?,?,?,?)'

[LukasReschke]

On c.nc.c:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_properties` (`userid`,`propertypath`,`propertyname`,`propertyvalue`) VALUES(?,?,?,?)' with params ["XXXXX", "calendars\/XXXXX\/XXXXX_shared_by_XXXXXXX", "{urn:ietf:params:xml:ns:caldav}calendar-timezone", "BEGIN:VCALENDAR\r\nVERSION:2.0\r\nPRODID:-\/\/Apple Inc.\/\/Mac OS X 10.12.4\/\/EN\r\nCALSCALE:GREGORIAN\r\nBEGIN:VTIMEZONE\r\nTZID:America\/Chicago\r\nBEGIN:DAYLIGHT\r\nTZOFFSETFROM:-0600\r\nRRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU\r\nDTSTART:20070311T020000\r\nTZNAME:CDT\r\nTZOFFSETTO:-0500\r\nEND:DAYLIGHT\r\nBEGIN:STANDARD\r\nTZOFFSETFROM:-0500\r\nRRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU\r\nDTSTART:20071104T020000\r\nTZNAME:CST\r\nTZOFFSETTO:-0600\r\nEND:STANDARD\r\nEND:VTIMEZONE\r\nEND:VCALENDAR\r\n"]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'propertyvalue' at row 1
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1015: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO `oc...', Array)
/var/www/html/lib/private/DB/Connection.php - line 213: Doctrine\DBAL\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
/var/www/html/apps/dav/lib/DAV/CustomPropertiesBackend.php - line 269: OC\DB\Connection->executeUpdate('INSERT INTO `oc...', Array)
/var/www/html/apps/dav/lib/DAV/CustomPropertiesBackend.php - line 147: OCA\DAV\DAV\CustomPropertiesBackend->updateProperties('calendars/frank...', Array)
/var/www/html/3rdparty/sabre/dav/lib/DAV/PropPatch.php - line 317: OCA\DAV\DAV\CustomPropertiesBackend->OCA\DAV\DAV\{closure}(Array)
/var/www/html/3rdparty/sabre/dav/lib/DAV/PropPatch.php - line 245: Sabre\DAV\PropPatch->doCallBackMultiProp(Array, Object(Closure))
/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php - line 1265: Sabre\DAV\PropPatch->commit()
/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 385: Sabre\DAV\Server->updateProperties('calendars/xxxxx...', Array)
[internal function] Sabre\DAV\CorePlugin->httpPropPatch(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/3rdparty/sabre/event/lib/EventEmitterTrait.php - line 105: call_user_func_array(Array, Array)
/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php - line 479: Sabre\Event\EventEmitter->emit('method PROPPATC...', Array)
/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php - line 254: Sabre\DAV\Server->invokeMethod(Object(Sabre\HTTP\Request), Object(Sabre\HTTP\Response))
/var/www/html/apps/dav/lib/Server.php - line 244: Sabre\DAV\Server->exec()
/var/www/html/apps/dav/appinfo/v2/remote.php - line 33: OCA\DAV\Server->exec()
/var/www/html/remote.php - line 162: require_once('/var/www/html/a...')
{main}

cc @georgehrke

[georgehrke]

Grmpf :/

@nickvergessen my fav database person
Can we easily convert text to blob?
I assume things will explode?

https://github.com/nextcloud/server/blob/master/db_structure.xml#L740L745

[nickvergessen]

Text to clob is possible: nextcloud/activity#53
Only does not work on oracle, but current 10 and 11 dont work on oracle due to an issue with the 2fa backup code app which is force enabled. So it's fine.

[georgehrke]

let's change it to clob :)

[georgehrke]

fix is in #4770 :)

[matin2510]

@nickvergessen Could you please help me with problem?
Occasionally I got this error for a simple query with very low active mysql
connection, only around 40~50 connections, can you help me fix this error?

Doctrine\DBAL\Exception\DriverException: An exception occurred while
executing 'SELECT t0.id AS id1, t0.ended_at AS ended_at2,
t0.enter_action_id AS enter_action_id3, t0.current_group_name AS
current_group_name4, t0.enter_info AS enter_info5, t0.last_email_time AS
last_email_time6, t0.milestone_start_at AS milestone_start_at7,
t0.created_at AS created_at8, t0.updated_at AS updated_at9, t0.contact_id
AS contact_id10, t0.campaign_id AS campaign_id11 FROM contact_progress t0
WHERE t0.id = ?' with params [713404]:

[matin2510]

MySQL server has gone away
1 File "/var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php"
line 115 in convertException
2 File "/var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php"
line 116 in driverExceptionDuringQuery
3 File "/var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php" line
836 in executeQuery
4 File "/var/www/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php"
line 748 in load
5 File "/var/www/vendor/doctrine/orm/lib/Doctrine/ORM/Proxy/ProxyFactory.php"
line 172 in Doctrine\ORM\Proxy{closure}
6 File "/var/www/app/cache/prod/doctrine/orm/Proxies/__CG__BKCoreBundleEntityContactProgress.php"
line 274 in __invoke

[georgehrke]

@matin2510 Please use the forum if you need help administrating your Nextcloud: https://help.nextcloud.com

If you have actual bugreports, you can report them in our bug tracker: https://github.com/nextcloud/server/issues

[jcklpe]

@matin2510 Did you ever find a solution for this?

[DevanshuJoshi87]

@matin2510 Were you able to fix above issue ?