Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-17622

Using images (image datatype) not working in DFS cluster mode on oracle

    XMLWordPrintable

Details

    Description

      Hi

      Trying to upload a image (save draft) causes these warnings:

      Warning: PHP: E_WARNING 	Nov 10 2010 13:02:39
      oci_execute() [<a href='function.oci-execute'>function.oci-execute</a>]: ORA-00942: tabellen eller utsnittet finnes ikke in /data1/www/apache2php52/ezp440/.run/extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php on line 1257
      
      Error: _rename(var/storage/images-versioned/188/1-eng-GB/image1.gif, var/storage/images/image/188-1-eng-GB/image.gif)::_delete(var/storage/images/image/188-1-eng-GB/image.gif) 	Nov 10 2010 13:02:39
      Failed to execute SQL for function:
      DELETE FROM ezdbfile WHERE name_hash=:hash
      942 : ORA-00942: tabellen eller utsnittet finnes ikke
      
      Error: 	Nov 10 2010 13:02:39
      Deleting file var/storage/images/image/188-1-eng-GB/image.gif failed
      942: ORA-00942: tabellen eller utsnittet finnes ikke
      
      Warning: PHP: E_WARNING 	Nov 10 2010 13:02:39
      rename(/mnt/export/ezdfs/var/storage/images-versioned/188/1-eng-GB/image1.gif,/mnt/export/ezdfs/var/storage/images/image/188-1-eng-GB/image.gif) [<a href='function.rename'>function.rename</a>]: No such file or directory in /data1/www/apache2php52/ezp440/.run/kernel/private/classes/clusterfilehandlers/dfsbackends/dfs.php on line 240
      
      Notice: PHP: E_NOTICE 	Nov 10 2010 13:02:39
      Undefined variable: fname in /data1/www/apache2php52/ezp440/.run/extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php on line 739
      
      Warning: PHP: E_WARNING 	Nov 10 2010 13:02:39
      oci_execute() [<a href='function.oci-execute'>function.oci-execute</a>]: ORA-00942: tabellen eller utsnittet finnes ikke in /data1/www/apache2php52/ezp440/.run/extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php on line 1257
      
      Error: _rename(var/storage/images-versioned/188/1-eng-GB/image1_reference.gif, var/storage/images/image/188-1-eng-GB/image_reference.gif)::_delete(var/storage/images/image/188-1-eng-GB/image_reference.gif) 	Nov 10 2010 13:02:39
      Failed to execute SQL for function:
       DELETE FROM ezdbfile WHERE name_hash=:hash
      942 : ORA-00942: tabellen eller utsnittet finnes ikke
      
      Error: 	Nov 10 2010 13:02:39
      Deleting file var/storage/images/image/188-1-eng-GB/image_reference.gif failed
      942: ORA-00942: tabellen eller utsnittet finnes ikke
      
      Warning: PHP: E_WARNING 	Nov 10 2010 13:02:39
      rename(/mnt/export/ezdfs/var/storage/images-versioned/188/1-eng-GB/image1_reference.gif,/mnt/export/ezdfs/var/storage/images/image/188-1-eng-GB/image_reference.gif) [<a href='function.rename'>function.rename</a>]: No such file or directory in /data1/www/apache2php52/ezp440/.run/kernel/private/classes/clusterfilehandlers/dfsbackends/dfs.php on line 240
      
      Notice: PHP: E_NOTICE 	Nov 10 2010 13:02:39
      Undefined variable: fname in /data1/www/apache2php52/ezp440/.run/extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php on line 739
      
      Warning: PHP: E_WARNING 	Nov 10 2010 13:02:39
      oci_execute() [<a href='function.oci-execute'>function.oci-execute</a>]: ORA-00942: tabellen eller utsnittet finnes ikke in /data1/www/apache2php52/ezp440/.run/extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php on line 1257
      
      Error: _rename(var/storage/images-versioned/188/1-eng-GB/image1_medium.gif, var/storage/images/image/188-1-eng-GB/image_medium.gif)::_delete(var/storage/images/image/188-1-eng-GB/image_medium.gif) 	Nov 10 2010 13:02:39
      Failed to execute SQL for function:
       DELETE FROM ezdbfile WHERE name_hash=:hash
      942 : ORA-00942: tabellen eller utsnittet finnes ikke
      
      Error: 	Nov 10 2010 13:02:39
      Deleting file var/storage/images/image/188-1-eng-GB/image_medium.gif failed
      942: ORA-00942: tabellen eller utsnittet finnes ikke
      
      Warning: PHP: E_WARNING 	Nov 10 2010 13:02:39
      rename(/mnt/export/ezdfs/var/storage/images-versioned/188/1-eng-GB/image1_medium.gif,/mnt/export/ezdfs/var/storage/images/image/188-1-eng-GB/image_medium.gif) [<a href='function.rename'>function.rename</a>]: No such file or directory in /data1/www/apache2php52/ezp440/.run/kernel/private/classes/clusterfilehandlers/dfsbackends/dfs.php on line 240
      
      Notice: PHP: E_NOTICE 	Nov 10 2010 13:02:39
      Undefined variable: fname in /data1/www/apache2php52/ezp440/.run/extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php on line 594
      
      Warning: PHP: E_WARNING 	Nov 10 2010 13:02:39
      copy(/mnt/export/ezdfs/var/storage/images/image/188-1-eng-GB/image.gif) [<a href='function.copy'>function.copy</a>]: failed to open stream: No such file or directory in /data1/www/apache2php52/ezp440/.run/kernel/private/classes/clusterfilehandlers/dfsbackends/dfs.php on line 92
      
      Error: 	Nov 10 2010 13:02:39
      Failed copying DFS://var/storage/images/image/188-1-eng-GB/image.gif to FS://var/storage/images/image/188-1-eng-GB/image31758tmp.gif 
      
      Error: _deleteByDirList(Array, var/cache/content, 59-) 	Nov 10 2010 13:02:39
      
      Failed to execute SQL for function:
       DELETE FROM ezdbfile WHERE name LIKE :alike
      942 : ORA-00942: tabellen eller utsnittet finnes ikke
      
      Error: _deleteByDirList(Array, var/cache/content, 2-) 	Nov 10 2010 13:02:39
      Failed to execute SQL for function:
       DELETE FROM ezdbfile WHERE name LIKE :alike
      942 : ORA-00942: tabellen eller utsnittet finnes ikke
      

      Some of the errors can be explain by the following code in extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php:

      static $deletequery = "DELETE FROM ezdbfile ";
      

      I guess the tablename should be ezdfsfile?

      Then, when trying to view the image, I get these notices (and no image is shown):

      Notice: PHP: E_NOTICE 	Nov 10 2010 13:17:44
      Undefined variable: fname in /data1/www/apache2php52/ezp440/.run/extension/ezoracle/clusterfilehandlers/dfsbackends/oracle.php on line 594
      
      Warning: PHP: E_WARNING 	Nov 10 2010 13:17:44
      copy(/mnt/export/ezdfs/var/storage/images/image/188-1-eng-GB/image_reference.gif) [<a href='function.copy'>function.copy</a>]: failed to open stream: No such file or directory in /data1/www/apache2php52/ezp440/.run/kernel/private/classes/clusterfilehandlers/dfsbackends/dfs.php on line 92
      
      Error: 	Nov 10 2010 13:17:44
      Failed copying DFS://var/storage/images/image/188-1-eng-GB/image_reference.gif to FS://var/storage/images/image/188-1-eng-GB/image_reference31762tmp.gif 
      
      Warning: eZImageShellHandler::convert 	Nov 10 2010 13:17:44
      Failed executing: convert 'var/storage/images/image/188-1-eng-GB/image_reference.gif' '-geometry' '300x300>' 'GIF:var/storage/images/image/188-1-eng-GB/image_large.gif', Error code: 1
      
      Error: eZImageManager::createImageAlias 	Nov 10 2010 13:17:44
      Failed converting var/storage/images/image/188-1-eng-GB/image_reference.gif to alias 'large' in directory 'var/storage/images/image/188-1-eng-GB'
      

      Attachments

        Activity

          People

            chen chen
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: