pydio
two remaining errors
hello,
I'm quite desperate : ajaxplorer-sync doesn't work properly ! But I won't give up !
I've :
- pydio 5.0.4 on ubuntu server 12.04 (lamp) - second setup from scratch
- ajaxplorer-sync on macosx maverick (I'd the same problems with former os) ; I've removed the folder .ajaxplorer many times because I wanted to have a clean start.
I will describe the last clean start :
- detecting local changes : ok
- requestiong remote changes : ok
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.
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.
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
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?
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
How can I help ?
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
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.
hello
I restarted ajaxplorer-sync from scratch ... after folder have been renamed
But always the same error in sub-folder :
Do you want the log and error files ?
May be a matter of charset ... but I don't know what to do :
- server side : pydio tests are ok (charset for example)
- client sode : no tuning on mac !
hi we now suspect a problem with path lengths. Can you send me the log files? use team (@) pydio (dot) com -c
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).
hi @wojt-spot sorry for the delay in replying to you, the longtest path : -> client side = 182 -> server side = 211
Now look directly into http://dl.ajaxplorer.info/nightly/sync/0.8.4-SNAPSHOT/Installers/