[jira] Closed: (CAY-997) Incorrect generation of primary key values

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Tue Mar 04 2008 - 12:23:16 EST

  • Next message: Michael Gentry: "Board Report?"

         [ https://issues.apache.org/cayenne/browse/CAY-997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Andrus Adamchik closed CAY-997.
    -------------------------------

        Resolution: Won't Fix

    This is not a bug. Please doublecheck that the PK seuqnce is setup correctly to match the default PK cache size of 20. Looks like it increments by 1 instead of 20... There are two ways to fix it:

    1. Change sequence definition to increment by 20
    2. For each DbEntity in the Modeler, select "Custom Sequence" "Pk Generation Strategy" and enter 1 for the "Cached PK Size"

    > Incorrect generation of primary key values
    > ------------------------------------------
    >
    > Key: CAY-997
    > URL: https://issues.apache.org/cayenne/browse/CAY-997
    > Project: Cayenne
    > Issue Type: Bug
    > Components: Cayenne Core Library
    > Affects Versions: 3.0
    > Environment: postgres 8.2
    > Reporter: Rares Ispas
    > Assignee: Andrus Adamchik
    > Priority: Blocker
    >
    > Fast creation of rows results in Cayenne attempting to reuse the same pk:
    > public void testVideoFiles()
    > {
    > for( int i = 0; i < 200; i++ )
    > VideoFilesDb.insert( 7l, "asdasd", new Date(), new Date(), new Date(), VideoFilesDb.RetentionPolicy.SpaceRequired, new Date(), "" );
    > }
    > public static void insert( long videoStreamId, String fileName, Date startTime, Date endTime, Date uploadTime, RetentionPolicy retentionPolicy, Date retentionExpiration, String hash )
    > {
    > DataContext ctx = DataContext.createDataContext();
    > VideoFiles vf = (VideoFiles) ctx.newObject( VideoFiles.class );
    > vf.setVideoStreamId( videoStreamId );
    > vf.setFileName(fileName);
    > vf.setStartTime(startTime);
    > vf.setEndTime(endTime);
    > vf.setUploadTime(uploadTime);
    > vf.setRetentionPolicy( retentionPolicy.toString() );
    > vf.setRetentionExpiration( retentionExpiration );
    > vf.setHash(hash);
    > ctx.commitChanges();
    > }
    > results in exception:
    > org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "VideoFiles_pkey"
    > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1559)
    > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:352)
    > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2596)
    > at org.apache.cayenne.access.jdbc.BatchAction.runAsBatch(BatchAction.java:134)
    > at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:81)
    > at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:58)
    > at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:230)
    > at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:227)
    > at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:145)
    > at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:821)
    > at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:788)
    > at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:847)
    > at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:785)
    > at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1175)
    > at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1088)
    > at ScreenRecorder.db.VideoFilesDb.insert(VideoFilesDb.java:38)
    > at ScreenRecorder.DbTests.testVideoFiles(DbTests.java:17)
    > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    > at java.lang.reflect.Method.invoke(Method.java:597)
    > at junit.framework.TestCase.runTest(TestCase.java:164)
    > at junit.framework.TestCase.runBare(TestCase.java:130)
    > at junit.framework.TestResult$1.protect(TestResult.java:106)
    > at junit.framework.TestResult.runProtected(TestResult.java:124)
    > at junit.framework.TestResult.run(TestResult.java:109)
    > at junit.framework.TestCase.run(TestCase.java:120)
    > at junit.framework.TestSuite.runTest(TestSuite.java:230)
    > at junit.framework.TestSuite.run(TestSuite.java:225)
    > at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:421)
    > at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:912)
    > at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:766)
    > Here is the entity:
    > <db-entity name="video_files" schema="screen_recorder0_5">
    > <db-attribute name="end_time" type="TIMESTAMP" length="29"/>
    > <db-attribute name="file_name" type="VARCHAR" isMandatory="true" length="2147483647"/>
    > <db-attribute name="file_size" type="BIGINT" length="19"/>
    > <db-attribute name="hash" type="VARCHAR" length="2147483647"/>
    > <db-attribute name="id" type="BIGINT" isPrimaryKey="true" isMandatory="true" length="19"/>
    > <db-attribute name="retention_expiration" type="TIMESTAMP" length="29"/>
    > <db-attribute name="retention_policy" type="VARCHAR" isMandatory="true" length="2147483647"/>
    > <db-attribute name="start_time" type="TIMESTAMP" length="29"/>
    > <db-attribute name="upload_time" type="TIMESTAMP" length="29"/>
    > <db-attribute name="video_stream_id" type="BIGINT" isMandatory="true" length="19"/>
    > </db-entity>
    > Here is the trace. Please remark that selecting from sequence only occurs a few times, after that Cayenne attempts to internally increment the id. That's very wrong.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate startedLoading
    > INFO: started configuration loading.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataDomain
    > INFO: loaded domain: ScreenRecorderDomain
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate loadDataMap
    > INFO: loaded <map name='ScreenRecorderMap' location='ScreenRecorderMap.map.xml'>.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
    > INFO: loading <node name='ScreenRecorderDomainNode' datasource='ScreenRecorderDomainNode.driver.xml' factory='org.apache.cayenne.conf.DriverDataSourceFactory'>.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
    > INFO: using factory: org.apache.cayenne.conf.DriverDataSourceFactory
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.DriverDataSourceFactory load
    > INFO: loading driver information from 'ScreenRecorderDomainNode.driver.xml'.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.DriverDataSourceFactory$DriverHandler init
    > INFO: loading driver org.postgresql.Driver
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.DriverDataSourceFactory$LoginHandler init
    > INFO: loading user name and password.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logPoolCreated
    > INFO: Created connection pool: jdbc:postgresql://10.1.0.2:5432/postgres
    > Driver class: org.postgresql.Driver
    > Min. connections in the pool: 1
    > Max. connections in the pool: 1
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
    > INFO: loaded datasource.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate initAdapter
    > INFO: no adapter set, using automatic adapter.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate shouldLinkDataMap
    > INFO: loaded map-ref: ScreenRecorderMap.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.conf.RuntimeLoadDelegate finishedLoading
    > INFO: finished configuration loading in 125 ms.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logConnect
    > INFO: Opening connection: jdbc:postgresql://10.1.0.2:5432/postgres
    > Login: postgres
    > Password: *******
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logConnectSuccess
    > INFO: +++ Connecting: SUCCESS.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger log
    > INFO: Detected and installed adapter: org.apache.cayenne.dba.postgres.PostgresAdapter
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: SELECT nextval('screen_recorder0_5.pk_video_files')
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.608', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:216, 6->retention_expiration:'2008-03-04 18:58:19.608', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.608', 9->upload_time:'2008-03-04 18:58:19.608', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.967', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:217, 6->retention_expiration:'2008-03-04 18:58:19.967', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.967', 9->upload_time:'2008-03-04 18:58:19.967', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.983', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:218, 6->retention_expiration:'2008-03-04 18:58:19.983', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.983', 9->upload_time:'2008-03-04 18:58:19.983', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.983', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:219, 6->retention_expiration:'2008-03-04 18:58:19.983', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.983', 9->upload_time:'2008-03-04 18:58:19.983', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.983', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:220, 6->retention_expiration:'2008-03-04 18:58:19.983', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.983', 9->upload_time:'2008-03-04 18:58:19.983', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.983', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:221, 6->retention_expiration:'2008-03-04 18:58:19.983', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.983', 9->upload_time:'2008-03-04 18:58:19.983', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.999', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:222, 6->retention_expiration:'2008-03-04 18:58:19.999', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.999', 9->upload_time:'2008-03-04 18:58:19.999', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.999', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:223, 6->retention_expiration:'2008-03-04 18:58:19.999', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.999', 9->upload_time:'2008-03-04 18:58:19.999', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.999', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:224, 6->retention_expiration:'2008-03-04 18:58:19.999', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.999', 9->upload_time:'2008-03-04 18:58:19.999', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:19.999', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:225, 6->retention_expiration:'2008-03-04 18:58:19.999', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:19.999', 9->upload_time:'2008-03-04 18:58:19.999', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.014', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:226, 6->retention_expiration:'2008-03-04 18:58:20.014', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.014', 9->upload_time:'2008-03-04 18:58:20.014', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.014', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:227, 6->retention_expiration:'2008-03-04 18:58:20.014', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.014', 9->upload_time:'2008-03-04 18:58:20.014', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.014', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:228, 6->retention_expiration:'2008-03-04 18:58:20.014', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.014', 9->upload_time:'2008-03-04 18:58:20.014', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.014', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:229, 6->retention_expiration:'2008-03-04 18:58:20.014', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.014', 9->upload_time:'2008-03-04 18:58:20.014', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.014', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:230, 6->retention_expiration:'2008-03-04 18:58:20.014', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.014', 9->upload_time:'2008-03-04 18:58:20.014', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.014', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:231, 6->retention_expiration:'2008-03-04 18:58:20.014', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.014', 9->upload_time:'2008-03-04 18:58:20.014', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.03', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:232, 6->retention_expiration:'2008-03-04 18:58:20.03', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.03', 9->upload_time:'2008-03-04 18:58:20.03', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.03', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:233, 6->retention_expiration:'2008-03-04 18:58:20.03', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.03', 9->upload_time:'2008-03-04 18:58:20.03', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.03', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:234, 6->retention_expiration:'2008-03-04 18:58:20.03', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.03', 9->upload_time:'2008-03-04 18:58:20.03', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.03', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:235, 6->retention_expiration:'2008-03-04 18:58:20.03', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.03', 9->upload_time:'2008-03-04 18:58:20.03', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    > INFO: === updated 1 row.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logCommitTransaction
    > INFO: +++ transaction committed.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logBeginTransaction
    > INFO: --- transaction started.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: SELECT nextval('screen_recorder0_5.pk_video_files')
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryStart
    > INFO: --- will run 1 query.
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQuery
    > INFO: INSERT INTO screen_recorder0_5.video_files (end_time, file_name, file_size, hash, id, retention_expiration, retention_policy, start_time, upload_time, video_stream_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryParameters
    > INFO: [batch bind: 1->end_time:'2008-03-04 18:58:20.03', 2->file_name:'asdasd', 3->file_size:NULL, 4->hash:'', 5->id:217, 6->retention_expiration:'2008-03-04 18:58:20.03', 7->retention_policy:'SpaceRequired', 8->start_time:'2008-03-04 18:58:20.03', 9->upload_time:'2008-03-04 18:58:20.03', 10->video_stream_id:7]
    > Mar 4, 2008 6:58:20 PM org.apache.cayenne.access.QueryLogger logQueryError
    > INFO: *** error.
    > org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "VideoFiles_pkey"
    > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1559)
    > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:352)
    > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2596)
    > at org.apache.cayenne.access.jdbc.BatchAction.runAsBatch(BatchAction.java:134)
    > at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:81)
    > at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:58)
    > at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:230)
    > at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:227)
    > at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:145)
    > at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:821)
    > at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:788)
    > at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:847)
    > at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:785)
    > at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1175)
    > at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1088)
    > at ScreenRecorder.db.VideoFilesDb.insert(VideoFilesDb.java:38)
    > at ScreenRecorder.DbTests.testVideoFiles(DbTests.java:17)
    > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    > at java.lang.reflect.Method.invoke(Method.java:597)
    > at junit.framework.TestCase.runTest(TestCase.java:164)
    > at junit.framework.TestCase.runBare(TestCase.java:130)
    > at junit.framework.TestResult$1.protect(TestResult.java:106)
    > at junit.framework.TestResult.runProtected(TestResult.java:124)
    > at junit.framework.TestResult.run(TestResult.java:109)
    > at junit.framework.TestCase.run(TestCase.java:120)
    > at junit.framework.TestSuite.runTest(TestSuite.java:230)
    > at junit.framework.TestSuite.run(TestSuite.java:225)
    > at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:421)
    > at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:912)
    > at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:766)

    -- 
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.
    



    This archive was generated by hypermail 2.0.0 : Tue Mar 04 2008 - 12:24:33 EST