Postgresql versus Mysql (was Problem with examples and transactions)

[Leandro Rodrigo Saad Cruz <le...@ibnetwork.com.br>]

Hi all.

I set up a little test to show diferences between pgsql and mysql using
a simple test. This test should create some nodes, store content and
then create another revision of the same node.

Here is my test file.(attached TestFileStore.java)
should be run from build/examples and placed at build/examples/version.
a minor modification to build/examples/example.sh should do.

I run this example twice. using pgsql on a clean enviroment and using
mysql on free env too.

then I gor this results

Postgresql v.7.1.3-4:
pgsql log (attached pgsql.log)
process outout (attached test.pgsql.out)
pgsql queries (attached pgsql.client)

Mysql v 3.23.43-4

mysql log (attached mysql.log)
process output (attached test.mysql.out)
mysql queries (attached mysql.client)

If we compare the process output using mysql and pgsql we can find a
little diff found in test.pgsql.out

>org.apache.slide.store.StandardStore - INFO - Delisting service
>slidestore.reference.JDBCDescriptorsStore@2b34943 from active
>transaction with failure
>org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
>Transaction 1 xid main-1008960374578-1- in thread main

I think this is the cause that postgresql is not storing info in
property relation.

could somebody help me. I can increase the log level in Domain.java to
output more info if needed
-- 
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)
http://www.ibnetwork.com.br

Re: Postgresql versus Mysql (was Problem with examples and transactions)

[Dirk Verbeeck <di...@pandora.be>]

Hi Leandro

Can you send you your Postgresql results?
I don't have Postgresql installed but with enough logging we should be
able to solve this...

Dirk


Leandro Rodrigo Saad Cruz wrote:
> 
> Hi all.
> 
> I set up a little test to show diferences between pgsql and mysql using
> a simple test. This test should create some nodes, store content and
> then create another revision of the same node.
> 
> Here is my test file.(attached TestFileStore.java)
> should be run from build/examples and placed at build/examples/version.
> a minor modification to build/examples/example.sh should do.
> 
> I run this example twice. using pgsql on a clean enviroment and using
> mysql on free env too.
> 
> then I gor this results
> 
> Postgresql v.7.1.3-4:
> pgsql log (attached pgsql.log)
> process outout (attached test.pgsql.out)
> pgsql queries (attached pgsql.client)
> 
> Mysql v 3.23.43-4
> 
> mysql log (attached mysql.log)
> process output (attached test.mysql.out)
> mysql queries (attached mysql.client)
> 
> If we compare the process output using mysql and pgsql we can find a
> little diff found in test.pgsql.out
> 
> >org.apache.slide.store.StandardStore - INFO - Delisting service
> >slidestore.reference.JDBCDescriptorsStore@2b34943 from active
> >transaction with failure
> >org.apache.slide.transaction.SlideTransactionManager - INFO - Rollback
> >Transaction 1 xid main-1008960374578-1- in thread main
> 
> I think this is the cause that postgresql is not storing info in
> property relation.
> 
> could somebody help me. I can increase the log level in Domain.java to
> output more info if needed
> --
> Leandro Rodrigo Saad Cruz
> IT - Inter Business Tecnologia e Servicos (IB)
> http://www.ibnetwork.com.br
> 
>   ------------------------------------------------------------------------
>                          Name: TestFileStore.java
>    TestFileStore.java    Type: text/x-java
>                      Encoding: quoted-printable
> 
>                 Name: mysql.log
>    mysql.log    Type: Plain Text (text/plain)
>             Encoding: quoted-printable
> 
>                    Name: mysql.client
>    mysql.client    Type: Plain Text (text/plain)
>                Encoding: quoted-printable
> 
>                      Name: test.mysql.out
>    test.mysql.out    Type: Plain Text (text/plain)
>                  Encoding: quoted-printable
> 
>   ------------------------------------------------------------------------
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>