search

pydio / pydio-sync-java

[DEPRECATED] Synchronization Client of the Pydio project. Based on the Java SDK.
GNU General Public License v3.0
35 stars 15 forks source link

two remaining errors #34

Open dflahaut opened 10 years ago

dflahaut commented 10 years ago

hello,

I'm quite desperate : ajaxplorer-sync doesn't work properly ! But I won't give up !

I've :

I will describe the last clean start :

1/ in ajxp_log.out

----------- after begining --------------- 0 [main] INFO root - Rdiff Processor active? Yes 478 [main] INFO com.j256.ormlite.table.TableUtils - creating table 'a' 479 [main] INFO com.j256.ormlite.table.TableUtils - creating index 'a_parent_idx' for table 'a 985 [main] INFO com.j256.ormlite.table.TableUtils - executed create table statement changed 0 rows: CREATE TABLE a (id INTEGER PRIMARY KEY AUTOINCREMENT , path VARCHAR , label VARCHAR , lastModified TIMESTAMP , resourceType VARCHAR , status INTEGER , leaf BOOLEAN , uuid VARCHAR , parent_id INTEGER ) 988 [main] INFO com.j256.ormlite.table.TableUtils - executed create table statement changed 0 rows: CREATE INDEX a_parent_idx ON a ( parent_id ) 988 [main] INFO com.j256.ormlite.table.TableUtils - creating table 'b' 989 [main] INFO com.j256.ormlite.table.TableUtils - creating index 'b_node_idx' for table 'b 991 [main] INFO com.j256.ormlite.table.TableUtils - executed create table statement changed 0 rows: CREATE TABLE b (id INTEGER PRIMARY KEY AUTOINCREMENT , name VARCHAR , value VARCHAR , node_id INTEGER ) 994 [main] INFO com.j256.ormlite.table.TableUtils - executed create table statement changed 0 rows: CREATE INDEX b_node_idx ON b ( node_id ) 1037 [main] INFO com.j256.ormlite.table.TableUtils - creating table 'syncchange' 1040 [main] INFO com.j256.ormlite.table.TableUtils - executed create table statement changed 0 rows: CREATE TABLE syncchange (id INTEGER PRIMARY KEY AUTOINCREMENT , jobId VARCHAR , key VARCHAR , changeValue VARCHAR ) 1043 [main] INFO com.j256.ormlite.table.TableUtils - creating table 'synclog' 1044 [main] INFO com.j256.ormlite.table.TableUtils - creating index 'synclog_synchroNode_idx' for table 'synclog 1047 [main] INFO com.j256.ormlite.table.TableUtils - executed create table statement changed 0 rows: CREATE TABLE synclog (id INTEGER PRIMARY KEY AUTOINCREMENT , jobDate BIGINT , jobStatus VARCHAR , jobSummary VARCHAR , synchroNode_id INTEGER ) 1049 [main] INFO com.j256.ormlite.table.TableUtils - executed create table statement changed 0 rows: CREATE INDEX synclog_synchroNode_idx ON synclog ( synchroNode_id ) 1354 [main] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 1397 [main] INFO org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 1399 [main] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.1.3 created. 1401 [main] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 1402 [main] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.1.3) 'AjaXplorerScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 1 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

1402 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'AjaXplorerScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 1402 [main] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.1.3

1403 [main] INFO org.quartz.core.QuartzScheduler - Scheduler AjaXplorerScheduler_$_NON_CLUSTERED started.

but when ajaxplorer-sync want to make something :

------------------ error 1 ---------------------- 545374 [AjaXplorerScheduler_Worker-1] ERROR root - Synchro java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "Automator": syntax error) at org.sqlite.DB.newSQLException(DB.java:374) at org.sqlite.DB.newSQLException(DB.java:378) at org.sqlite.DB.throwex(DB.java:365) at org.sqlite.NativeDB.prepare(Native Method) at org.sqlite.DB.prepare(DB.java:123) at org.sqlite.PrepStmt.(PrepStmt.java:44) at org.sqlite.Conn.prepareStatement(Conn.java:403) at org.sqlite.Conn.prepareStatement(Conn.java:398) at com.j256.ormlite.jdbc.JdbcDatabaseConnection.compileStatement(JdbcDatabaseConnection.java:108) at com.j256.ormlite.stmt.mapped.MappedPreparedStmt.compile(MappedPreparedStmt.java:45) at com.j256.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:192) at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:153) at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:245) at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:250) at com.j256.ormlite.dao.BaseDaoImpl.queryForFieldValues(BaseDaoImpl.java:875) at com.j256.ormlite.dao.BaseDaoImpl.queryForFieldValues(BaseDaoImpl.java:257) at info.ajaxplorer.synchro.SyncJob.findNodesInTmpSnapshot(SyncJob.java:486) at info.ajaxplorer.synchro.SyncJob.applyChanges(SyncJob.java:527) at info.ajaxplorer.synchro.SyncJob.run(SyncJob.java:349) at info.ajaxplorer.synchro.SyncJob.execute(SyncJob.java:163) at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

I've more than 300 times that message.

Le log file looks like that :

545984 [AjaXplorerScheduler_Worker-1] INFO root - Uploading 147229 bytes 547848 [AjaXplorerScheduler_Worker-1] INFO root - Uploading 289 bytes 548551 [AjaXplorerScheduler_Worker-1] ERROR root - Synchro java.lang.Exception: Could not upload file to the server at info.ajaxplorer.synchro.SyncJob.applyChanges(SyncJob.java:645) at info.ajaxplorer.synchro.SyncJob.run(SyncJob.java:349) at info.ajaxplorer.synchro.SyncJob.execute(SyncJob.java:163) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) 548947 [AjaXplorerScheduler_Worker-1] INFO root - Uploading 83606 bytes 549727 [AjaXplorerScheduler_Worker-1] ERROR root - Synchro java.lang.Exception: Could not upload file to the server at info.ajaxplorer.synchro.SyncJob.applyChanges(SyncJob.java:645) at info.ajaxplorer.synchro.SyncJob.run(SyncJob.java:349) at info.ajaxplorer.synchro.SyncJob.execute(SyncJob.java:163) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

550043 [AjaXplorerScheduler_Worker-1] INFO root - Uploading 67 bytes

------------------------- error 2 ----------------------- 548551 [AjaXplorerScheduler_Worker-1] ERROR root - Synchro java.lang.Exception: Could not upload file to the server at info.ajaxplorer.synchro.SyncJob.applyChanges(SyncJob.java:645) at info.ajaxplorer.synchro.SyncJob.run(SyncJob.java:349) at info.ajaxplorer.synchro.SyncJob.execute(SyncJob.java:163) at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

2/ ajxp_errors.out

To my mind, we have the same errors ... -------------------- error 1 ------------------------------- 545668 [AjaXplorerScheduler_Worker-1] ERROR root - Synchro java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "Automator": syntax error) at org.sqlite.DB.newSQLException(DB.java:374) at org.sqlite.DB.newSQLException(DB.java:378) at org.sqlite.DB.throwex(DB.java:365) at org.sqlite.NativeDB.prepare(Native Method) at org.sqlite.DB.prepare(DB.java:123) at org.sqlite.PrepStmt.(PrepStmt.java:44) at org.sqlite.Conn.prepareStatement(Conn.java:403) at org.sqlite.Conn.prepareStatement(Conn.java:398) at com.j256.ormlite.jdbc.JdbcDatabaseConnection.compileStatement(JdbcDatabaseConnection.java:108) at com.j256.ormlite.stmt.mapped.MappedPreparedStmt.compile(MappedPreparedStmt.java:45) at com.j256.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:192) at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:153) at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:245) at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:250) at com.j256.ormlite.dao.BaseDaoImpl.queryForFieldValues(BaseDaoImpl.java:875) at com.j256.ormlite.dao.BaseDaoImpl.queryForFieldValues(BaseDaoImpl.java:257) at info.ajaxplorer.synchro.SyncJob.findNodesInTmpSnapshot(SyncJob.java:486) at info.ajaxplorer.synchro.SyncJob.applyChanges(SyncJob.java:527) at info.ajaxplorer.synchro.SyncJob.run(SyncJob.java:349) at info.ajaxplorer.synchro.SyncJob.execute(SyncJob.java:163) at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

---------------------------- error 2 -------------------------------------- 548551 [AjaXplorerScheduler_Worker-1] ERROR root - Synchro java.lang.Exception: Could not upload file to the server at info.ajaxplorer.synchro.SyncJob.applyChanges(SyncJob.java:645) at info.ajaxplorer.synchro.SyncJob.run(SyncJob.java:349) at info.ajaxplorer.synchro.SyncJob.execute(SyncJob.java:163) at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

Any idea ? It's a fine application : I won't give up !

Bye for now Denis

cdujeu commented 10 years ago

wow, that's getting weirder... We don't make any reference to "Automator" in our code... Do you know if this specific error is new to Mavericks? Or did you have the same problem before upgrade?

dflahaut commented 10 years ago

Really, I'm not sure ... I made a lot of changes in the same times because I'd two big folders that were always remaining in error capture decran 2013-10-28 a 18 33 00

How can I help ?

cdujeu commented 10 years ago

OMG!!! This seems to indicate that simply the names are not correctly espaced in the SQL query.... We'll have a look at this, But in between could you simply rename the folder "flux de travail de l'Automator" into "flux de travail de lAutomator" for example? -c

dflahaut commented 10 years ago

I will have a look at that folder ...

It's very interesting because it's a matter of ' !

I'v been obliged to rename all my folders and files that had an ' in their name (pydio server is on ubuntu 12.04 with fr_FR.utf8) ... with two exceptions : "Données Utilisateurs Microsoft/xxx" and another one.

dflahaut commented 10 years ago

hello

I restarted ajaxplorer-sync from scratch ... after folder have been renamed But always the same error in sub-folder : capture decran 2013-10-28 a 19 46 16

Do you want the log and error files ?

May be a matter of charset ... but I don't know what to do :

cdujeu commented 10 years ago

hi we now suspect a problem with path lengths. Can you send me the log files? use team (@) pydio (dot) com -c

wojt-spot commented 10 years ago

Hello @dflahaut Today when I was doing test use cases, I tried to copy repository with Your file strucuture to new folder, and without success, the cuse was, that with new folder name, some of the files couldnt be copied - as they final paths were too long. It might be that is the same in Your case, so please check out if there are any filest with full path longer that 260 chars (including their folder names).

dflahaut commented 10 years ago

hi @wojt-spot sorry for the delay in replying to you, the longtest path : -> client side = 182 -> server side = 211

cdujeu commented 10 years ago

Now look directly into http://dl.ajaxplorer.info/nightly/sync/0.8.4-SNAPSHOT/Installers/