Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

edu.illinois.codingspectator.csvtosql either hangs or throws an exception #290

Open
reprogrammer opened this issue Aug 4, 2011 · 1 comment
Open

edu.illinois.codingspectator.csvtosql either hangs or throws an exception #290

reprogrammer opened this issue Aug 4, 2011 · 1 comment
Labels
Data Analysis
Milestone
March 15th, 2011

Comments

@reprogrammer
Copy link
Collaborator

The edu.illinois.codingspectator.csvtosql application either hangs while shutting down the database or throws the following exception.

2011-08-04T07:52:29.024-0500  WARNING  ScriptWriter synch error:
java.io.SyncFailedException: sync failed
        at java.io.FileDescriptor.sync(Native Method)
        at org.hsqldb.lib.FileUtil$FileSync.sync(Unknown Source)
        at org.hsqldb.scriptio.ScriptWriterBase.forceSync(Unknown Source)
        at org.hsqldb.persist.Log.synchLog(Unknown Source)
        at org.hsqldb.persist.Log.checkpointClose(Unknown Source)
        at org.hsqldb.persist.Log.checkpoint(Unknown Source)
        at org.hsqldb.persist.Log.checkpoint(Unknown Source)
        at org.hsqldb.persist.Logger.checkpoint(Unknown Source)
        at org.hsqldb.StatementCommand.getResult(Unknown Source)
        at org.hsqldb.StatementCommand.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        at org.hsqldb.Database$CheckpointRunner.run(Unknown Source)
        at org.hsqldb.lib.HsqlTimer$TaskRunner.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:619)

This problem sometimes leads to a corrupt database and sometimes does not.

The first time I noticed this problem was after commit 8162990. But, I didn't find any problem in this commit. We should try running the application on the previous commit to see if this commit has introduced the bug.
reprogrammer added a commit that referenced this issue Aug 5, 2011
@reprogrammer
Committed the database changes more frequently.
17c9d8e 
I increased the number of commit operations from one to eight. Several small commits seem to be more reliable that a single huge commit.

Made Git ignore the files that ANT automatically generates for org.hsqldb.

This commit belongs to issue #290.
@reprogrammer
Copy link
Collaborator Author

The edu.illinois.codingspectator.csvtosql application hung even after commit 17c9d8e.

reprogrammer added a commit that referenced this issue Aug 5, 2011
@reprogrammer
Changed the type of the timestamp column and db shutdown mechanism.
4a70e75 
Changed the type of the timestamp column of the database talbe to BIGINT.

Added "shutdown=true" to the connection string to shutdown the database automatically.

This commit belongs to issues #288 and #290.
reprogrammer added a commit that referenced this issue Aug 13, 2011
@reprogrammer
Merged branch 'sql-queries-for-research-questions' into 'master'.
be13197 
This commit belongs to issues #288, #290, #293, #303.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Data Analysis
Projects
None yet
Milestone
March 15th, 2011
Development

No branches or pull requests
1 participant
@reprogrammer