Skip to content

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

Description

@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

Activity

  1. added this to the Nextcloud 12.0 milestone on May 8, 2017
  2. georgehrke commented on May 8, 2017

    @georgehrke
    Member

    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

  3. nickvergessen commented on May 9, 2017

    @nickvergessen
    Member

    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.

  4. self-assigned this
    on May 9, 2017
  5. georgehrke commented on May 9, 2017

    @georgehrke
    Member

    let's change it to clob :)

  6. georgehrke commented on May 9, 2017

    @georgehrke
    Member

    fix is in #4770 :)

  7. matin2510 commented on Sep 9, 2018

    @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]:

  8. matin2510 commented on Sep 9, 2018

    @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

  9. georgehrke commented on Sep 9, 2018

    @georgehrke
    Member

    @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

  10. jcklpe commented on Nov 8, 2018

    @jcklpe

    @matin2510 Did you ever find a solution for this?

  11. DevanshuJoshi87 commented on Jan 4, 2019

    @DevanshuJoshi87

    @matin2510 Were you able to fix above issue ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions