ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 4 replies, has 3 voices, and was last updated by  Rodolfo 1 year, 9 months ago.

  • Creator
    Topic
  • #7993

    Rodolfo
    Participant

    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)”} []

Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
    Replies
  • #8073

    Alexandr Smaga
    Participant

    Hello @rbandeira !

    Thank you for reporting this. We will plan fix for this ASAP, will keep you posted.

    #8327

    Rodolfo
    Participant

    Thank you for the feedback @asmaga

    I’m still having issues exporting .csv even with EE 1.8. Some huge .csv reports are taking my webserver down:

    “502 Bad Gateway”

    #14879

    I have the same problem, “502 Bad Gateway” when I want to export to csv, @rbandeira could fix it?

    #14883

    Rodolfo
    Participant

    Hi @juan_antonio_baracat

    I upgrade Oro Platform and after that didn’t see the problem again. I would suggest to you trying to get more info from your app/logs/prod.log

    This command will show the logs in realtime:

    tail -f app/logs/prod.log

    You can also monitor your database to see if there is a sql query hanging for a long time.
    show full processlist;

    Are you on the latest version of the platform?

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.