Testing Postgresql 9.5 RC1 with Alfresco 5.0.d

From: Boriss Mejias <bmejias(at)dcc(dot)uchile(dot)cl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Testing Postgresql 9.5 RC1 with Alfresco 5.0.d
Date: 2015-12-28 22:56:50
Message-ID: 5681BE32.5050806@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi there,

The following wiki page:
https://wiki.postgresql.org/wiki/HowToBetaTest#How_to_Test
suggests that I should send the following report to this mailing list.

Name: Boriss Mejías (Tchorix)

Release: Postgresql 9.5 RC1

Test Type: Compatibility with Alfresco Community Edition 5.0.d

Test Detail: New Alfresco installation with Postgresql 9.5 RC1. Testing updates
into the database.

Platform: CentOS 6.5

Installation Method: Compiled from tarball. Default parameters.

Platform Detail:
- VMWare virtual machine
- RAM: 1GB
- CPU: Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz
- Alfresco running on a different VM.

Test Procedure:
- Vanilla installation of Alfresco Community Edition 5.0.d
- Using the default jdbc driver shipped with Alfresco
- Test that Alfresco Shares works correctly with the basic functionality
- Script with multiple HTTP REST calls to create/read/delete users. Each
operation/transaction involves several tables.

Failure? No

Test Results:
- Alfresco worked as expected.
- Scripts are run in parallel to expect race conditions. Alfresco uses
optimistic approach.
- Constraint violations on table-keys are observed in the logs, which is
good, because data remains consistent, and Alfresco handles the error messages
correctly.

Comments:
- I just wrote my own scripts to test the consistency of users data. I'm
not part of Alfresco Inc to use their official test bed
- Alfresco uses Ibatis to control de database model. Hence, I wasn't
expecting any failure.
- I don't have control of the table indexes, and I was not able to compare
the test with a previous version of Postgresql to test performance.
- This is the first time I run a test of a previous-release version of
Postgresql, so any comment of ideas are welcome to contribute again next time.

Cheers
Boriss

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2015-12-28 23:03:25 Re: Using quicksort for every external sort run
Previous Message Fabien COELHO 2015-12-28 22:29:02 Re: pgbench stats per script & other stuff