help maintaining consistency of database with code

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

help maintaining consistency of database with code

Anshuman Manur
Hey,

We're three developers working on building an e-commerce store with ofbiz.
For code sharing and versioning, we've setup a SVN server on a local LAN
machine. We're using a MySQL database ver 5.0. What we usually do is when we
make changes that affect the DB, (such as adding new products) we take a
mysql dump of the db and version the file on the SVN server. The developer
checking out code gets the .sql file and updates his DB. But I notice this
strange error in the logs:

Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO SERVER_HIT
(VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID,
PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or
update a child row: a foreign key constraint fails (`xsport/SERVER_HIT`,
CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT`
(`VISIT_ID`)))

Every hit to the server gives this error. I know this is not normal and I
was wondering if this is caused because we abruptly change the db's state
whenever we check-out from the repo, and the db is somehow out of sync with
the servelt engine. Also, any better ways for code sharing and db
consistency? I'd love to hear what everyone thinks.

Thanks,
Anshuman Manur
Reply | Threaded
Open this post in threaded view
|

Re: help maintaining consistency of database with code

Anshuman Manur
I should probably mention that I did not load the demo store data (ant
target: run-install). I used run-install-seed which loads only the seed
data. I don't know if this causes this issue.


On Fri, May 15, 2009 at 11:34 AM, Anshuman Manur <
[hidden email]> wrote:

> Hey,
>
> We're three developers working on building an e-commerce store with ofbiz.
> For code sharing and versioning, we've setup a SVN server on a local LAN
> machine. We're using a MySQL database ver 5.0. What we usually do is when we
> make changes that affect the DB, (such as adding new products) we take a
> mysql dump of the db and version the file on the SVN server. The developer
> checking out code gets the .sql file and updates his DB. But I notice this
> strange error in the logs:
>
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO SERVER_HIT
> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID,
> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or
> update a child row: a foreign key constraint fails (`xsport/SERVER_HIT`,
> CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT`
> (`VISIT_ID`)))
>
> Every hit to the server gives this error. I know this is not normal and I
> was wondering if this is caused because we abruptly change the db's state
> whenever we check-out from the repo, and the db is somehow out of sync with
> the servelt engine. Also, any better ways for code sharing and db
> consistency? I'd love to hear what everyone thinks.
>
> Thanks,
> Anshuman Manur
>
Reply | Threaded
Open this post in threaded view
|

Re: help maintaining consistency of database with code

Jacques Le Roux
Administrator
In reply to this post by Anshuman Manur
You may neglict such errors, it's related to local context not being consistent with the dump, that's all

Jacques

From: "Anshuman Manur" <[hidden email]>

> Hey,
>
> We're three developers working on building an e-commerce store with ofbiz.
> For code sharing and versioning, we've setup a SVN server on a local LAN
> machine. We're using a MySQL database ver 5.0. What we usually do is when we
> make changes that affect the DB, (such as adding new products) we take a
> mysql dump of the db and version the file on the SVN server. The developer
> checking out code gets the .sql file and updates his DB. But I notice this
> strange error in the logs:
>
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO SERVER_HIT
> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, INTERNAL_CONTENT_ID,
> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or
> update a child row: a foreign key constraint fails (`xsport/SERVER_HIT`,
> CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT`
> (`VISIT_ID`)))
>
> Every hit to the server gives this error. I know this is not normal and I
> was wondering if this is caused because we abruptly change the db's state
> whenever we check-out from the repo, and the db is somehow out of sync with
> the servelt engine. Also, any better ways for code sharing and db
> consistency? I'd love to hear what everyone thinks.
>
> Thanks,
> Anshuman Manur
>

Reply | Threaded
Open this post in threaded view
|

Re: help maintaining consistency of database with code

Abdullah Shaikh-3
In reply to this post by Anshuman Manur
You can have a look at this https://issues.apache.org/jira/browse/OFBIZ-2208


On Fri, May 15, 2009 at 11:34 AM, Anshuman Manur <
[hidden email]> wrote:

> Hey,
>
> We're three developers working on building an e-commerce store with ofbiz.
> For code sharing and versioning, we've setup a SVN server on a local LAN
> machine. We're using a MySQL database ver 5.0. What we usually do is when
> we
> make changes that affect the DB, (such as adding new products) we take a
> mysql dump of the db and version the file on the SVN server. The developer
> checking out code gets the .sql file and updates his DB. But I notice this
> strange error in the logs:
>
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO SERVER_HIT
> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP,
> INTERNAL_CONTENT_ID,
> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or
> update a child row: a foreign key constraint fails (`xsport/SERVER_HIT`,
> CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT`
> (`VISIT_ID`)))
>
> Every hit to the server gives this error. I know this is not normal and I
> was wondering if this is caused because we abruptly change the db's state
> whenever we check-out from the repo, and the db is somehow out of sync with
> the servelt engine. Also, any better ways for code sharing and db
> consistency? I'd love to hear what everyone thinks.
>
> Thanks,
> Anshuman Manur
>



--
Regards,

Abdullah Shaikh
Viithiisys
Reply | Threaded
Open this post in threaded view
|

Re: help maintaining consistency of database with code

Jacques Le Roux
Administrator
Right, and ?

Jacques

From: "abdullah shaikh" <[hidden email]>

> You can have a look at this https://issues.apache.org/jira/browse/OFBIZ-2208
>
>
> On Fri, May 15, 2009 at 11:34 AM, Anshuman Manur <
> [hidden email]> wrote:
>
>> Hey,
>>
>> We're three developers working on building an e-commerce store with ofbiz.
>> For code sharing and versioning, we've setup a SVN server on a local LAN
>> machine. We're using a MySQL database ver 5.0. What we usually do is when
>> we
>> make changes that affect the DB, (such as adding new products) we take a
>> mysql dump of the db and version the file on the SVN server. The developer
>> checking out code gets the .sql file and updates his DB. But I notice this
>> strange error in the logs:
>>
>> Exception: org.ofbiz.entity.GenericDataSourceException
>> Message: SQL Exception while executing the following:INSERT INTO SERVER_HIT
>> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
>> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP,
>> INTERNAL_CONTENT_ID,
>> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES (?,
>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or
>> update a child row: a foreign key constraint fails (`xsport/SERVER_HIT`,
>> CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT`
>> (`VISIT_ID`)))
>>
>> Every hit to the server gives this error. I know this is not normal and I
>> was wondering if this is caused because we abruptly change the db's state
>> whenever we check-out from the repo, and the db is somehow out of sync with
>> the servelt engine. Also, any better ways for code sharing and db
>> consistency? I'd love to hear what everyone thinks.
>>
>> Thanks,
>> Anshuman Manur
>>
>
>
>
> --
> Regards,
>
> Abdullah Shaikh
> Viithiisys
>

Reply | Threaded
Open this post in threaded view
|

Re: help maintaining consistency of database with code

Anshuman Manur
So, I will safely ignore these errors then! Thank you for your replies!

On Fri, May 15, 2009 at 1:34 PM, Jacques Le Roux <
[hidden email]> wrote:

> Right, and ?
>
> Jacques
>
> From: "abdullah shaikh" <[hidden email]>
>
>  You can have a look at this
>> https://issues.apache.org/jira/browse/OFBIZ-2208
>>
>>
>> On Fri, May 15, 2009 at 11:34 AM, Anshuman Manur <
>> [hidden email]> wrote:
>>
>>  Hey,
>>>
>>> We're three developers working on building an e-commerce store with
>>> ofbiz.
>>> For code sharing and versioning, we've setup a SVN server on a local LAN
>>> machine. We're using a MySQL database ver 5.0. What we usually do is when
>>> we
>>> make changes that affect the DB, (such as adding new products) we take a
>>> mysql dump of the db and version the file on the SVN server. The
>>> developer
>>> checking out code gets the .sql file and updates his DB. But I notice
>>> this
>>> strange error in the logs:
>>>
>>> Exception: org.ofbiz.entity.GenericDataSourceException
>>> Message: SQL Exception while executing the following:INSERT INTO
>>> SERVER_HIT
>>> (VISIT_ID, CONTENT_ID, HIT_START_DATE_TIME, HIT_TYPE_ID, NUM_OF_BYTES,
>>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, STATUS_ID, REQUEST_URL, REFERRER_URL,
>>> SERVER_IP_ADDRESS, SERVER_HOST_NAME, LAST_UPDATED_STAMP,
>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP,
>>> INTERNAL_CONTENT_ID,
>>> PARTY_ID, ID_BY_IP_CONTACT_MECH_ID, REF_BY_WEB_CONTACT_MECH_ID) VALUES
>>> (?,
>>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or
>>> update a child row: a foreign key constraint fails (`xsport/SERVER_HIT`,
>>> CONSTRAINT `SERVER_HIT_VISIT` FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT`
>>> (`VISIT_ID`)))
>>>
>>> Every hit to the server gives this error. I know this is not normal and I
>>> was wondering if this is caused because we abruptly change the db's state
>>> whenever we check-out from the repo, and the db is somehow out of sync
>>> with
>>> the servelt engine. Also, any better ways for code sharing and db
>>> consistency? I'd love to hear what everyone thinks.
>>>
>>> Thanks,
>>> Anshuman Manur
>>>
>>>
>>
>>
>> --
>> Regards,
>>
>> Abdullah Shaikh
>> Viithiisys
>>
>>
>