Large folders won't load
Closed this issue · 12 comments
CeruleanDerpo commented
I am having an issue with the extension, large folders seem to be empty because they won't load.
I have the latest version of the extensions
prrvchr commented
Hi CeruleanDerpo,
what do you call large folders? I would need to be able to reproduce, could you make a test folder with non-sensitive files?
CeruleanDerpo commented
I just tried creating the test folder, but I cannot see it. Maybe large folders aren't the issue, it was just a coincidence. It's likely nothing is syncing
prrvchr commented
It's likely nothing is syncing
You can obtain more information with the replicator log and it is possible to deactivate the synchronization in the options (to be checked).
CeruleanDerpo commented
This is the log output:
Driver.__new__() 2 *******************************
sdbc.DriverBase.DriverBase() 1
logging.UnoLoggerPool.setRoot() 1:
sdbc.DriverBase.DriverBase() 2
sdbcx.Driver() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
jdbcdriver.DriverProviderMain() 1
derby.DerbyDriverProvider() 1
jdbcdriver.DriverProviderMain() 1
h2.H2DriverProvider() 1
jdbcdriver.DriverProviderMain() 1
hsqldb.HsqlDBDriverProvider() 1
hsqldb.HsqlDBDriverProvider.setSystemProperties() 1 Level: -1
sdbc.DriverBase._registerDriver() 1
sdbc.DriverBase._getDriverClass() 1
sdbc.DriverBase._getDriverClass() 2
sdbc.DriverBase._registerDriver() 2 url: 'jar:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu82409exg.tmp_/jdbcDriverOOo.oxt/driver/hsqldb-2.7.2.jar!/' name: 'org.hsqldb.jdbcDriver'
sdbc.DriverBase._registerDriver() 3
sdbc.DriverBase._registerDriver(url, name) 1
sdbc.DriverBase._registerDriver() 5
sdbc.DriverBase.connect() 1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 1 Level: -1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 2 Url: jdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false
logging.UnoLoggerServiceProvider() 1
logging.UnoLoggerFactory() 1
logging.UnoLoggerAdapter() 1
logging.UnoLoggerPool.getNamedLogger() io.github.prrvchr.jdbcDriverOOo.hsqldb.db.HSQLDB8E6AE2A590.ENGINE
logging.UnoLoggerAdapter() 2: io.github.prrvchr.jdbcDriverOOo.hsqldb.db.HSQLDB8E6AE2A590.ENGINE
sdbc.DriverBase.connect() 2 Name: com.sun.star.sdb.Connection
sdbc.DriverBase.connect() 3 Service: com.sun.star.sdb.Connection
ConnectionBase() 1
sdb.Connection() *************************
sdbc.DriverBase.connect() 4
sdbc.DatabaseMetaData.getTableTypes()
sdbc.DatabaseMetaData.getTableTypes(): Type: GLOBAL TEMPORARY
sdbc.DatabaseMetaData.getTableTypes(): Type: SYSTEM TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: VIEW
sdbc.ResultSet() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
Driver.getDataDefinitionByConnection()
sdbcx.Container.addContainerListener() Class: io.github.prrvchr.uno.sdb.TableContainer - Count: 16
sdbcx.Statement() 1
sdbc.BaseCallableStatement() 1: 'SELECT "Value2" "Folder", "Value3" "Link" FROM "Settings" WHERE "Name" = 'ContentType''
sdb.CallableStatement() 1
sdb.ResultSet() 1
PoolListener.modified()
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
jdbcdriver.DriverProviderMain() 1
derby.DerbyDriverProvider() 1
jdbcdriver.DriverProviderMain() 1
h2.H2DriverProvider() 1
jdbcdriver.DriverProviderMain() 1
hsqldb.HsqlDBDriverProvider() 1
sdbc.DriverBase.connect() 1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 1 Level: -1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 2 Url: jdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false
sdbc.DriverBase.connect() 2 Name: com.sun.star.sdb.Connection
sdbc.DriverBase.connect() 3 Service: com.sun.star.sdb.Connection
ConnectionBase() 1
sdb.Connection() *************************
sdbc.DriverBase.connect() 4
sdbc.DatabaseMetaData.getTableTypes()
sdbc.DatabaseMetaData.getTableTypes(): Type: GLOBAL TEMPORARY
sdbc.DatabaseMetaData.getTableTypes(): Type: SYSTEM TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: VIEW
sdbc.ResultSet() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
Driver.getDataDefinitionByConnection()
sdbcx.Container.addContainerListener() Class: io.github.prrvchr.uno.sdb.TableContainer - Count: 16
sdbcx.Statement() 1
sdbc.BaseCallableStatement() 1: 'SELECT "U"."UserId", "U"."RootId", "U"."Token", "I"."Title" "RootName", "U"."TimeStamp", "U"."SyncMode" FROM "Users" AS "U" INNER JOIN "Items" AS "I" ON "U"."RootId" = "I"."ItemId" WHERE "U"."UserName" = ?'
sdb.CallableStatement() 1
sdb.ResultSet() 1
WARNING: Token 'BLOCK_COMMENT' defined, but not used
WARNING: Token 'LINE_COMMENT' defined, but not used
WARNING: Token 'LINE_TERMINATOR' defined, but not used
WARNING: There are 3 unused tokens
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
jdbcdriver.DriverProviderMain() 1
derby.DerbyDriverProvider() 1
jdbcdriver.DriverProviderMain() 1
h2.H2DriverProvider() 1
jdbcdriver.DriverProviderMain() 1
hsqldb.HsqlDBDriverProvider() 1
sdbc.DriverBase.connect() 1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 1 Level: -1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 2 Url: jdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false
DriverProvider.getJavaConnectionProperties() *********************: user
sdbc.DriverBase.connect() 2 Name: com.sun.star.sdb.Connection
sdbc.DriverBase.connect() 3 Service: com.sun.star.sdb.Connection
ConnectionBase() 1
sdb.Connection() *************************
sdbc.DriverBase.connect() 4
sdbc.DatabaseMetaData.getTableTypes()
sdbc.DatabaseMetaData.getTableTypes(): Type: GLOBAL TEMPORARY
sdbc.DatabaseMetaData.getTableTypes(): Type: SYSTEM TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: VIEW
sdbc.ResultSet() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
Driver.getDataDefinitionByConnection()
sdbcx.Container.addContainerListener() Class: io.github.prrvchr.uno.sdb.TableContainer - Count: 12
sdbcx.Statement() 1
sdbc.BaseCallableStatement() 1: 'CALL "GetRoot"(?)'
sdb.CallableStatement() 1
sdb.ResultSet() 1
Content._updateFolderContent() 1 ConnectionMode: 1 - SessionMode: 0
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdbc.BaseCallableStatement() 1: 'SELECT "C"."Uri" "Title", "C"."Size" "Size", "C"."DateModified" "DateModified", "C"."DateCreated" "DateCreated", "C"."IsFolder" "IsFolder", ? || "P"."Path" || "P"."Uri" "TargetURL", FALSE "IsHidden", FALSE "IsVolume", FALSE "IsRemote", FALSE "IsRemoveable", FALSE "IsFloppy", FALSE "IsCompactDisc" FROM "Children" AS "C" INNER JOIN "Path" AS "P" ON "C"."ItemId" = "P"."ItemId" WHERE ( "C"."IsFolder" = TRUE OR "C"."ConnectionMode" >= ? ) AND "C"."ParentId" = ?'
sdb.CallableStatement() 1
sdb.ResultSet() 1
ContentResultSet.__init__() 151```
prrvchr commented
To know the replication status you need the mDriveSync log, it seems to me that the one provided is mDriveLog.
CeruleanDerpo commented
My bad, here is the correct log:
Gtk-Message: 18:16:20.120: Failed to load module "appmenu-gtk-module"
1 34220 2024-03-24 17:16:32.474620089 OptionsManager::__init__(): OptionManger has been correctly initialized.
PoolListener.modified()
2 34220 2024-03-24 17:16:46.964831690 OptionsManager::saveSetting(): OptionManger saved options False and logging True.
3 34220 2024-03-24 17:16:46.969653785 OptionsManager::loadSetting(): OptionManger has been correctly reloaded.
4 34220 2024-03-24 17:16:48.383711362 OptionsManager::saveSetting(): OptionManger saved options False and logging False.
Driver.__new__() 1
Driver.__new__() 2 *******************************
sdbc.DriverBase.DriverBase() 1
logging.UnoLoggerPool.setRoot() 1:
sdbc.DriverBase.DriverBase() 2
sdbcx.Driver() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
jdbcdriver.DriverProviderMain() 1
derby.DerbyDriverProvider() 1
jdbcdriver.DriverProviderMain() 1
h2.H2DriverProvider() 1
jdbcdriver.DriverProviderMain() 1
hsqldb.HsqlDBDriverProvider() 1
hsqldb.HsqlDBDriverProvider.setSystemProperties() 1 Level: -1
sdbc.DriverBase._registerDriver() 1
sdbc.DriverBase._getDriverClass() 1
sdbc.DriverBase._getDriverClass() 2
sdbc.DriverBase._registerDriver() 2 url: 'jar:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu82409exg.tmp_/jdbcDriverOOo.oxt/driver/hsqldb-2.7.2.jar!/' name: 'org.hsqldb.jdbcDriver'
sdbc.DriverBase._registerDriver() 3
sdbc.DriverBase._registerDriver(url, name) 1
sdbc.DriverBase._registerDriver() 5
sdbc.DriverBase.connect() 1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 1 Level: -1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 2 Url: jdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false
logging.UnoLoggerServiceProvider() 1
logging.UnoLoggerFactory() 1
logging.UnoLoggerAdapter() 1
logging.UnoLoggerPool.getNamedLogger() io.github.prrvchr.jdbcDriverOOo.hsqldb.db.HSQLDB8E6AE2A590.ENGINE
logging.UnoLoggerAdapter() 2: io.github.prrvchr.jdbcDriverOOo.hsqldb.db.HSQLDB8E6AE2A590.ENGINE
sdbc.DriverBase.connect() 2 Name: com.sun.star.sdb.Connection
sdbc.DriverBase.connect() 3 Service: com.sun.star.sdb.Connection
ConnectionBase() 1
sdb.Connection() *************************
sdbc.DriverBase.connect() 4
sdbc.DatabaseMetaData.getTableTypes()
sdbc.DatabaseMetaData.getTableTypes(): Type: GLOBAL TEMPORARY
sdbc.DatabaseMetaData.getTableTypes(): Type: SYSTEM TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: VIEW
sdbc.ResultSet() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
Driver.getDataDefinitionByConnection()
sdbcx.Container.addContainerListener() Class: io.github.prrvchr.uno.sdb.TableContainer - Count: 16
sdbcx.Statement() 1
sdbc.BaseCallableStatement() 1: 'SELECT "Value2" "Folder", "Value3" "Link" FROM "Settings" WHERE "Name" = 'ContentType''
sdb.CallableStatement() 1
sdb.ResultSet() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
jdbcdriver.DriverProviderMain() 1
derby.DerbyDriverProvider() 1
jdbcdriver.DriverProviderMain() 1
h2.H2DriverProvider() 1
jdbcdriver.DriverProviderMain() 1
hsqldb.HsqlDBDriverProvider() 1
sdbc.DriverBase.connect() 1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 1 Level: -1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 2 Url: jdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false
sdbc.DriverBase.connect() 2 Name: com.sun.star.sdb.Connection
sdbc.DriverBase.connect() 3 Service: com.sun.star.sdb.Connection
ConnectionBase() 1
sdb.Connection() *************************
sdbc.DriverBase.connect() 4
sdbc.DatabaseMetaData.getTableTypes()
sdbc.DatabaseMetaData.getTableTypes(): Type: GLOBAL TEMPORARY
sdbc.DatabaseMetaData.getTableTypes(): Type: SYSTEM TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: VIEW
sdbc.ResultSet() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
Driver.getDataDefinitionByConnection()
sdbcx.Container.addContainerListener() Class: io.github.prrvchr.uno.sdb.TableContainer - Count: 16
sdbcx.Statement() 1
sdbc.BaseCallableStatement() 1: 'SELECT "U"."UserId", "U"."RootId", "U"."Token", "I"."Title" "RootName", "U"."TimeStamp", "U"."SyncMode" FROM "Users" AS "U" INNER JOIN "Items" AS "I" ON "U"."RootId" = "I"."ItemId" WHERE "U"."UserName" = ?'
sdb.CallableStatement() 1
sdb.ResultSet() 1
WARNING: Token 'BLOCK_COMMENT' defined, but not used
WARNING: Token 'LINE_COMMENT' defined, but not used
WARNING: Token 'LINE_TERMINATOR' defined, but not used
WARNING: There are 3 unused tokens
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
jdbcdriver.DriverProviderMain() 1
derby.DerbyDriverProvider() 1
jdbcdriver.DriverProviderMain() 1
h2.H2DriverProvider() 1
jdbcdriver.DriverProviderMain() 1
hsqldb.HsqlDBDriverProvider() 1
sdbc.DriverBase.connect() 1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 1 Level: -1
hsqldb.HsqlDBDriverProvider.getConnectionUrl() 2 Url: jdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false
DriverProvider.getJavaConnectionProperties() *********************: user
sdbc.DriverBase.connect() 2 Name: com.sun.star.sdb.Connection
sdbc.DriverBase.connect() 3 Service: com.sun.star.sdb.Connection
ConnectionBase() 1
sdb.Connection() *************************
sdbc.DriverBase.connect() 4
sdbc.DatabaseMetaData.getTableTypes()
sdbc.DatabaseMetaData.getTableTypes(): Type: GLOBAL TEMPORARY
sdbc.DatabaseMetaData.getTableTypes(): Type: SYSTEM TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: TABLE
sdbc.DatabaseMetaData.getTableTypes(): Type: VIEW
sdbc.ResultSet() 1
sdbc.DriverBase.acceptsURL() 1
sdbc.DriverBase.acceptsURL() Url: xdbc:hsqldb:file:///home/derpy/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu11683f0bi.tmp_/mDriveOOo.oxt/hsqldb/vnd-microsoft;hsqldb.default_table_type=cached;ifexists=false - Accept: true - Enhanced: true
Driver.getDataDefinitionByConnection()
sdbcx.Container.addContainerListener() Class: io.github.prrvchr.uno.sdb.TableContainer - Count: 12
sdbcx.Statement() 1
sdbc.BaseCallableStatement() 1: 'CALL "GetRoot"(?)'
sdb.CallableStatement() 1
sdb.ResultSet() 1
Content._updateFolderContent() 1 ConnectionMode: 1 - SessionMode: 0
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdbc.BaseCallableStatement() 1: 'SELECT "C"."Uri" "Title", "C"."Size" "Size", "C"."DateModified" "DateModified", "C"."DateCreated" "DateCreated", "C"."IsFolder" "IsFolder", ? || "P"."Path" || "P"."Uri" "TargetURL", FALSE "IsHidden", FALSE "IsVolume", FALSE "IsRemote", FALSE "IsRemoveable", FALSE "IsFloppy", FALSE "IsCompactDisc" FROM "Children" AS "C" INNER JOIN "Path" AS "P" ON "C"."ItemId" = "P"."ItemId" WHERE ( "C"."IsFolder" = TRUE OR "C"."ConnectionMode" >= ? ) AND "C"."ParentId" = ?'
sdb.CallableStatement() 1
sdb.ResultSet() 1
ContentResultSet.__init__() 15
sdbc.BaseCallableStatement() 1: 'CALL "GetItemId"(?,?,?)'
sdb.CallableStatement() 1
sdbc.BaseCallableStatement() 1: 'CALL "GetItem"(?,?)'
sdb.CallableStatement() 1
sdb.ResultSet() 1
Content._updateFolderContent() 1 ConnectionMode: 1 - SessionMode: 0
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdb.Connection.getParent() *************************
sdbc.BaseCallableStatement() 1: 'SELECT "C"."Uri" "Title", "C"."Size" "Size", "C"."DateModified" "DateModified", "C"."DateCreated" "DateCreated", "C"."IsFolder" "IsFolder", ? || "P"."Path" || "P"."Uri" "TargetURL", FALSE "IsHidden", FALSE "IsVolume", FALSE "IsRemote", FALSE "IsRemoveable", FALSE "IsFloppy", FALSE "IsCompactDisc" FROM "Children" AS "C" INNER JOIN "Path" AS "P" ON "C"."ItemId" = "P"."ItemId" WHERE ( "C"."IsFolder" = TRUE OR "C"."ConnectionMode" >= ? ) AND "C"."ParentId" = ?'
sdb.CallableStatement() 1
sdb.ResultSet() 1
ContentResultSet.__init__() 0
prrvchr commented
Normally the replication log looks like this:
event no thread date time (class/method:) message
1 1755585 2024-03-25 12:20:22.368232483 DataBase::__init__(): DataBase: Loading completed
2 1755585 2024-03-25 12:20:22.371210698 Replicator::__init__(): Replicator has been initialized.
3 1755729 2024-03-25 12:20:22.371326888 Replicator::run(): Replicator start thread with id vnd-microsoft.
4 1755729 2024-03-25 12:20:22.374606859 Replicator::run(): Replicator thread has been paused for 10 minutes.
5 1755729 2024-03-25 12:20:27.190779269 Replicator::_synchronize(): Starting data synchronization.
6 1755729 2024-03-25 12:20:27.547541307 Replicator::_pushUsers(): Starting data replication for user: prrvchr@outlook.fr.
7 1755729 2024-03-25 12:20:27.552219316 Replicator::_initUser(): Initialize user name: prrvchr@outlook.fr.
8 1755729 2024-03-25 12:20:29.086211552 Replicator::_initUser(): First data pull for user name prrvchr@outlook.fr, done...
9 1755729 2024-03-25 12:20:29.135293243 Replicator::_pushUsers(): End of replicating data for user: prrvchr@outlook.fr.
10 1755729 2024-03-25 12:20:29.137126771 Replicator::_pullUsers(): Starting data download for user: prrvchr@outlook.fr.
11 1755729 2024-03-25 12:20:29.402883460 Replicator::_pullUser(): User prrvchr@outlook.fr pull #0 changes on #1 pages with token https://graph.microsoft.com/beta/me/drive/root/delta?$select=id%2ccreatedDateTime%2clastModifiedDateTime%2cname%2cfile%2csize%2cparentReference&token=aTE09NjM4NDY5NjUyMjIzMjM7SUQ9QUM0NjYzMTM5MDg3QTI1MyExMDc7TFI9NjM4NDY5NjYwMjkyNzc7RVA9MjA7U0k9NDA7RExFUD0wO1NHPTE7U089MjtQST0z
12 1755729 2024-03-25 12:20:29.404697670 Replicator::_pullUsers(): End of download for user: prrvchr@outlook.fr.
13 1755729 2024-03-25 12:20:29.406428656 Replicator::_synchronize(): End of data synchronization.
14 1755729 2024-03-25 12:20:29.408166164 Replicator::run(): Replicator thread has been paused for 10 minutes.
15 1755729 2024-03-25 12:20:39.065917710 Replicator::_synchronize(): Starting data synchronization.
16 1755729 2024-03-25 12:20:39.439638093 Replicator::_pushUsers(): Starting data replication for user: prrvchr@outlook.fr.
17 1755729 2024-03-25 12:20:41.888717331 Replicator::_pushItem(): Has replicated the update of file: Untitled 2.odt of 2024-03-25T12:20:39.000Z size: 9441
18 1755729 2024-03-25 12:20:41.920662610 Replicator::_pushUsers(): End of replicating data for user: prrvchr@outlook.fr.
19 1755729 2024-03-25 12:20:41.922513352 Replicator::_pullUsers(): Starting data download for user: prrvchr@outlook.fr.
20 1755729 2024-03-25 12:20:42.188982055 Replicator::_pullUser(): User prrvchr@outlook.fr pull #2 changes on #1 pages with token https://graph.microsoft.com/beta/me/drive/root/delta?$select=id%2ccreatedDateTime%2clastModifiedDateTime%2cname%2cfile%2csize%2cparentReference&token=aTE09NjM4NDY5NjYwNDE3MTM7SUQ9QUM0NjYzMTM5MDg3QTI1MyExMDc7TFI9NjM4NDY5NjYwNDIwNjc7RVA9MjA7U0k9NDA7RExFUD0wO1NHPTE7U089MjtQST0z
21 1755729 2024-03-25 12:20:42.190783242 Replicator::_pullUsers(): End of download for user: prrvchr@outlook.fr.
22 1755729 2024-03-25 12:20:42.192487153 Replicator::_synchronize(): End of data synchronization.
23 1755729 2024-03-25 12:20:42.194292422 Replicator::run(): Replicator thread has been paused for 10 minutes.
CeruleanDerpo commented
I was logging through the console thinking it was the same, I changed it to file, but for some reason libreoffice crashes when pasting vnd-microsoft://my@email (I didn't actually write "my@email") into the open dialog and pressing enter (I haven't used libreoffice in some days, but it used to work before I stopped using it), here are the logs:
event no thread date time (class/method:) message
1 30701 2024-03-26 17:10:31.107106839 DataBase::__init__(): DataBase: Loading completed
2 30701 2024-03-26 17:10:31.114002892 Replicator::__init__(): Replicator has been initialized.
3 30795 2024-03-26 17:10:31.114015797 Replicator::run(): Replicator start thread with id vnd-microsoft.
4 30795 2024-03-26 17:10:31.116566025 Replicator::run(): Replicator thread has been paused for 10 minutes.
prrvchr commented
Looking at the log we can say that there is no replication starting...
What is your version of LibreOffice?
bayazidbh commented
I have the same issue, though I couldn't output the log (even when I choose View Log, it doesn't output anything, but it might be a dependency issue?).
Currently, I run the following version of LibreOffice under an Arch distrobox:
Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 12; OS: Linux 6.7; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
24.2.2-2
Calc: threaded
prrvchr commented
Hi bayazidbh,
I confirm that there are problems with LibreOffice 24.2.x while everything works well under 7.x.
I have the same problem with gDriveOOo under 24.2.x.
I haven't found the problem yet, I'm looking...
prrvchr commented
LibreOffice 24.x seems to have the option to create backup files (ie: .bak file) enabled by default. You can access this option in: Tools -> Options... -> Load/Save -> General -> Always create backup copy
If this option is enabled, it prevents files from being saved with mDriveOOo and gDriveOOo as well.
Version 1.1.2 of mDriverOOo is available. I advise you to use this new version which fixes this problem and many others.