This topic contains 4 replies, has 3 voices, and was last updated by 
Rodolfo 8 years, 4 months ago.
- Topic
Hi guys!
Yesterday I got some problems when I was trying to export a report to .csv (36.000 rows)In my log files we can see that the query for some reason was incrementing parameters in every ‘LIMIT/OFFSET’. So, the result of this was a mysql-server crashed. So, do you guys have any idea what happened?
[2015-01-12 16:38:44] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\DBALException: “An exception occurred while executing ‘SELECT o0_.increment_id AS increment_id0, o0_.customer_email AS customer_email1, o1_.postal_code AS postal_code2, o0_.remote_ip AS remote_ip3, o2_.name AS name4, o2_.brand AS brand5, o2_.categories AS categories6, o2_.price AS price7, COALESCE(o1_.region_text, o3_.name) AS sclr8, o0_.created_at AS created_at9 FROM orocrm_magento_order_items o2_ LEFT JOIN orocrm_magento_order o0_ ON o2_.order_id = o0_.id AND (o0_.organization_id = 6) LEFT JOIN orocrm_channel o4_ ON o0_.data_channel_id = o4_.id AND (o4_.organization_owner_id IN (6) AND o4_.organization_owner_id = 6) LEFT JOIN orocrm_magento_order_address o1_ ON o0_.id = o1_.owner_id LEFT JOIN oro_dictionary_region o3_ ON o1_.region_code = o3_.combined_code WHERE o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? ORDER BY increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC LIMIT 200 OFFSET 5400’ with params [“my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”, “my-channel-name”]:
SQLSTATE[HY000]: General error: 3 Error writing file ‘/tmp/MY3ILsi4’ (Errcode: 28)” at /var/www/html/acme-orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:”[object] (Doctrine\\DBAL\\DBALException: An exception occurred while executing ‘SELECT o0_.increment_id AS increment_id0, o0_.customer_email AS customer_email1, o1_.postal_code AS postal_code2, o0_.remote_ip AS remote_ip3, o2_.name AS name4, o2_.brand AS brand5, o2_.categories AS categories6, o2_.price AS price7, COALESCE(o1_.region_text, o3_.name) AS sclr8, o0_.created_at AS created_at9 FROM orocrm_magento_order_items o2_ LEFT JOIN orocrm_magento_order o0_ ON o2_.order_id = o0_.id AND (o0_.organization_id = 6) LEFT JOIN orocrm_channel o4_ ON o0_.data_channel_id = o4_.id AND (o4_.organization_owner_id IN (6) AND o4_.organization_owner_id = 6) LEFT JOIN orocrm_magento_order_address o1_ ON o0_.id = o1_.owner_id LEFT JOIN oro_dictionary_region o3_ ON o1_.region_code = o3_.combined_code WHERE o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? AND o4_.name = ? ORDER BY increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC, increment_id0 ASC LIMIT 200 OFFSET 5400’ with params [\”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”, \”my-channel-name\”]:\n\nSQLSTATE[HY000]: General error: 3 Error writing file ‘/tmp/MY3ILsi4’ (Errcode: 28) at /var/www/html/acme-orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException: SQLSTATE[HY000]: General error: 3 Error writing file ‘/tmp/MY3ILsi4’ (Errcode: 28) at /var/www/html/acme-orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694)”} []
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.