'Re: [owncloud-user] problems with own file backend'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       owncloud
Subject:    Re: [owncloud-user] problems with own file backend
From:       Vincent Petry <pvince81 () owncloud ! com>
Date:       2014-08-12 8:55:38
Message-ID: 53E9D68A.3090804 () owncloud ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

Hi,

Are you testing this with a SQLite database ?

It could be due to your own backend, but I don't really see how it could
trigger that.
Are your storage calls taking a long time ? You could try to buffer them
and/or use a stat cache to prevent making network requests every time.

Also, for development questions it's better to ask on the devel mailing
list: http://mailman.owncloud.org/mailman/listinfo/devel

Cheers,

Vincent

On 08/06/2014 10:56 PM, Hans Maulwurf wrote:
> hey guys,
>
> i develop an own file backend to use within files_external. at the
> beginning everything worked fine, but now i get many of these errors:
>
> {"app":"core","message":"Exception while scanning file
> \"Neu\/DAL-AR_AN_8_O_0001_00-P.pdf\": An exception occurred while executing
> 'INSERT INTO `oc_filecache` (`mimepart`, `mimetype`, `mtime`, `size`,
> `etag`, `storage_mtime`, `path_hash`, `path`, `parent`, `name`, `storage`)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)':\n\nSQLSTATE[HY000]: General
> error: 1205 Lock wait timeout exceeded; try restarting
> transaction","level":0,"time":"2014-08-06T12:54:25+00:00"}
>
> does this mean, there are too many requests to the database because of my
> filebackend? when these errormessages come up, i only get the loading-wheel
> at the screen and i can't access the files of my backend
>
> any suggestions?
>
> thanks for ur help
>
>
>
> _______________________________________________
> User mailing list
> User@owncloud.org
> http://mailman.owncloud.org/mailman/listinfo/user

[Attachment #5 (text/html)]

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Hi,<br>
    <br>
    Are you testing this with a SQLite database ?<br>
    <br>
    It could be due to your own backend, but I don't really see how it
    could trigger that.<br>
    Are your storage calls taking a long time ? You could try to buffer
    them and/or use a stat cache to prevent making network requests
    every time.<br>
    <br>
    Also, for development questions it's better to ask on the devel
    mailing list: <a class="moz-txt-link-freetext" \
href="http://mailman.owncloud.org/mailman/listinfo/devel">http://mailman.owncloud.org/mailman/listinfo/devel</a><br>
  <br>
    Cheers,<br>
    <br>
    Vincent<br>
    <br>
    <div class="moz-cite-prefix">On 08/06/2014 10:56 PM, Hans Maulwurf
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAA+kSAey68ebyEu=7KFKYVqjZ-Mu=BMXkB9Bt2CC9-RXHVkVtw@mail.gmail.com"
      type="cite">
      <pre wrap="">hey guys,

i develop an own file backend to use within files_external. at the
beginning everything worked fine, but now i get many of these errors:

{"app":"core","message":"Exception while scanning file
\"Neu\/DAL-AR_AN_8_O_0001_00-P.pdf\": An exception occurred while executing
'INSERT INTO `oc_filecache` (`mimepart`, `mimetype`, `mtime`, `size`,
`etag`, `storage_mtime`, `path_hash`, `path`, `parent`, `name`, `storage`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)':\n\nSQLSTATE[HY000]: General
error: 1205 Lock wait timeout exceeded; try restarting
transaction","level":0,"time":"2014-08-06T12:54:25+00:00"}

does this mean, there are too many requests to the database because of my
filebackend? when these errormessages come up, i only get the loading-wheel
at the screen and i can't access the files of my backend

any suggestions?

thanks for ur help

</pre>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
User mailing list
<a class="moz-txt-link-abbreviated" \
href="mailto:User@owncloud.org">User@owncloud.org</a> <a \
class="moz-txt-link-freetext" \
href="http://mailman.owncloud.org/mailman/listinfo/user">http://mailman.owncloud.org/mailman/listinfo/user</a>
 </pre>
    </blockquote>
    <br>
  </body>
</html>

_______________________________________________
User mailing list
User@owncloud.org
http://mailman.owncloud.org/mailman/listinfo/user

[prev in list] [next in list] [prev in thread] [next in thread] 