No more rows available

I use owncloud cli on a linux OS

sb_release -va
LSB Version:	n/a
Distributor ID:	ManjaroLinux
Description:	Manjaro Linux
Release:	21.3.7
Codename:	Ruah
community/owncloud-client 2.10.1.7389-1 [installed]

During the sync compares a message but I have not find documentation about it using Google

Actual behaviour

The following line is only one example, the string “no more rows available” compares more than one time for each sync

08-16 15:38:29:038 [ warning sync.database.sql ]:	SQL exec failed "DELETE FROM flags WHERE path != '' AND path NOT IN (SELECT path from metadata);" "no more rows available"

Steps to reproduce

You can reproduce the error simply by sync using owncloud cli.

owncloudcmd  --trust -h /home/marco/owncloud_path https://marco:PASSWORD@www.server.com:12345/owncloud/remote.php/webdav/

Server configuration

Operating system:

lsb_release -va
No LSB modules are available.
Distributor ID:	Debian
Description:	Debian GNU/Linux 9.13 (stretch)
Release:	9.13
Codename:	stretch

Web server:

apt list --installed |grep apache

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

apache2/oldoldstable,now 2.4.25-3+deb9u13 amd64 [installed,automatic]
apache2-bin/oldoldstable,now 2.4.25-3+deb9u13 amd64 [installed,automatic]
apache2-data/oldoldstable,now 2.4.25-3+deb9u13 all [installed,automatic]
apache2-doc/oldoldstable,now 2.4.25-3+deb9u13 all [installed,automatic]
apache2-utils/oldoldstable,now 2.4.25-3+deb9u13 amd64 [installed,automatic]
libapache-poi-java/oldoldstable,oldoldstable,now 3.10.1-3 all [installed,automatic]
libapache-pom-java/oldoldstable,oldoldstable,now 10-2 all [installed,automatic]
libapache2-mod-php7.0/now 7.0.33-60+0~20220627.68+debian9~1.gbp3d361a amd64 [installed,local]
libapache2-mod-php7.1/now 7.1.33-47+0~20220627.68+debian9~1.gbp1fc917 amd64 [installed,local]
libapache2-mod-php7.2/now 7.2.34-32+0~20220627.74+debian9~1.gbpc7fa3c amd64 [installed,local]
libapache2-mod-php7.4/now 1:7.4.30-3+0~20220627.69+debian9~1.gbpf2b381 amd64 [installed,local]
libapache2-mod-php8.0/now 1:8.0.20-2+0~20220625.38+debian9~1.gbpde2407 amd64 [installed,local]
libapache2-mod-php8.1/now 8.1.7-2+0~20220625.22+debian9~1.gbp4d1949 amd64 [installed,local]
python3-certbot-apache/oldoldstable,oldoldstable,now 0.28.0-1~deb9u1 all [installed]

Database:

apt list --installed |grep gres

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

libreoffice-sdbc-postgresql/oldoldstable,oldoldstable,oldoldstable,now 1:5.2.7-1+deb9u11 amd64 [installed,automatic]
postgresql/oldoldstable,oldoldstable,oldoldstable,now 9.6+181+deb9u3 all [installed]
postgresql-9.6/oldoldstable,now 9.6.24-0+deb9u1 amd64 [installed,automatic]
postgresql-client-9.6/oldoldstable,now 9.6.24-0+deb9u1 amd64 [installed,automatic]
postgresql-client-common/oldoldstable,oldoldstable,oldoldstable,now 181+deb9u3 all [installed,automatic]
postgresql-common/oldoldstable,oldoldstable,oldoldstable,now 181+deb9u3 all [installed,automatic]
postgresql-contrib-9.6/oldoldstable,now 9.6.24-0+deb9u1 amd64 [installed,automatic]

PHP version:

php --version
PHP 7.2.34-32+0~20220627.74+debian9~1.gbpc7fa3c (cli) (built: Jun 27 2022 08:12:01) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.2.34-32+0~20220627.74+debian9~1.gbpc7fa3c, Copyright (c) 1999-2018, by Zend Technologies

ownCloud version:

apt list --installed |grep owncloud

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

owncloud-files/now 10.5.0-1+2.1 all [installed,local]

Storage backend (external storage):

Client configuration

Client version:

community/owncloud-client 2.10.1.7389-1 [installed]

Operating system:
OS language:

lsb_release -va
LSB Version:	n/a
Distributor ID:	ManjaroLinux
Description:	Manjaro Linux
Release:	21.3.7
Codename:	Ruah

Qt version used by client package (Linux only, see also Settings dialog):

Client package (From ownCloud or distro) (Linux only):

Installation path of client:

Logs

Please use Gist (https://gist.github.com/) or a similar code paster for longer
logs.

Template for output < 10 lines

  1. Client logfile: Output of owncloud --logwindow or owncloud --logfile log.txt
    (On Windows using cmd.exe, you might need to first cd into the ownCloud directory)
    (See also Redirect Notice )

  2. Web server error log:

  3. Server logfile: ownCloud log (data/owncloud.log):
    The message “no more rows available” does not compare in the log.

The sync seems to be working well.

Regards

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.