firebird-test Mailing List for Firebird

Hi Pavel, seems that your last update broke xml output

see :
http://ci.ibphoenix.com/job/Firebird-3-Mageia64/48/testReport/results/xml/_failed_to_read_/

seems that it generate :
http://ci.ibphoenix.com/job/Firebird-3-Mageia64/lastSuccessfulBuild/artifact/results.xml/*view*/

instead of previous :
http://ci.ibphoenix.com/job/Firebird-3-Mageia64/27/artifact/results.xml/*view*/

can you check ?

thanks

Hi,

Adriano and I added support for CI on the https://travis-ci.org/. It's
free for open source projects.
The link to the testing page is on a github mirror of firebird (click
on build... icon at the top of readme)
https://github.com/asfernandes/firebird
or direct links
https://travis-ci.org/asfernandes/firebird
https://travis-ci.org/asfernandes/firebird/builds

I didn't announce this ci because there is some instability during ci
process, but in the neighbor thread Marius asked about it.

At the moment there is only linux testing (Ubuntu 12.04). OS X can be
added there. And there is no windows builds on travis, but Marius
suggested 'appveyor' so I'll try it.

Here are some notes for dev- and QA-teams:
1. Please, check CI scripts, build and test environment.
https://github.com/asfernandes/firebird/blob/master/.travis.yml
Several tests produce errors, maybe because of misconfigured
environment. For example, there is no 'make install' step.
2. One test is very long, so I disabled it (bugs.core_0870).
3. We need somehow to compare test results with QA team results in
order to have similar results. How many tests are failing? etc...
4. Do you need such tool (ci) at all? Are you interested?
5. Do you need email notifications on failed builds? You can write
privately to me, so I'll add your address.
6. CMake build on travis' ubuntu fails, so at the moment the default
build is user. This will be fixed later. Other OSes will be tested
first with CMake, if possible.

-- 
Egor Pugin

Just remember that Interbase/Firebird may be the ONLY DBMS that strictly
conforms BY DEFAULT to the real SQL transaction model. Everyone else
let's you see the uncommmitted work of others or some other model by
default - a banker's nightmare perhaps.

Thanks for doing this.

Ray


On Thu, 2015-03-12 at 12:25 +0300, Roman Simakov wrote:
> Hello!
> 
> I've ported BenchmarkSQL for Firebird. It's TPC-C test working via
> JDBC and support PostgreSQL, Oracle, DB2 and now Firebird.
> 
> https://github.com/romansimakov/BenchmarkSQL
> 
> I could run it locally and maybe it could be useful to know where we
> are comparing to other DBMSs.
> 
> Please share you investigations.
> 

Hello!

I've ported BenchmarkSQL for Firebird. It's TPC-C test working via
JDBC and support PostgreSQL, Oracle, DB2 and now Firebird.

https://github.com/romansimakov/BenchmarkSQL

I could run it locally and maybe it could be useful to know where we
are comparing to other DBMSs.

Please share you investigations.

-- 
Roman Simakov

Le 23/10/14 11:13, Robbert-Jan a écrit :
> If the test results are okay: - should I add a comment that the test
> results are okay? - should I ask someone (who?) to close the issue,
> or is “resolved” already the desired end status of an issue?
>
"resolved" is enough

> If the test results are not okay: - should I start a new issue
> (referencing to the old issue), or should I add a comment to the
> issue?
>
add a comment and reopen the issue

Hi,
I’ve started testing FB 3.0 beta, starting with retesting those issues I’ve reported myself during alpha-release testing.

I’ve read some guidelines on the Firebird website about how to report issues efficiently, but now I’m wandering, how should I report my retest results in the Jira FB tracker?

If the test results are okay:
- should I add a comment that the test results are okay?
- should I ask someone (who?) to close the issue, or is “resolved” already the desired end status of an issue?

If the test results are not okay:
- should I start a new issue (referencing to the old issue), or should I add a comment to the issue?

Kind regards,
Robert NL

Le 03/04/14 13:13, Roman Simakov a écrit :
> Please consider our patches we made locally.

Thanks
committed

Please consider our patches we made locally.

2014-04-03 10:43 GMT+04:00 Philippe Makowski <pma...@ib...>:
> Le 10/10/13 12:33, Roman Simakov a écrit :
>> I guess save_xunit could be improved and a possibility to parse other
>> keys could be added. I.e. we can expect not only EXCEPTION key.
>>
>> Thought?
>>
> yes, it becomes problematic, I can't publish results in ci.ibphoenix.com
> we have to work on this
> Pavel, any idea ?
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test



-- 
Roman Simakov

Le 10/10/13 12:33, Roman Simakov a écrit :
> I guess save_xunit could be improved and a possibility to parse other
> keys could be added. I.e. we can expect not only EXCEPTION key.
>
> Thought?
>
yes, it becomes problematic, I can't publish results in ci.ibphoenix.com
we have to work on this
Pavel, any idea ?

03.02.2014 19:49, Robbert-Jan wrote:
>
> Seems the START WITH clause needs to be between parenthesses, so:
>     ALTER TABLE Test ADD IdentityTest INTEGER GENERATED BY DEFAULT AS
> IDENTITY (START WITH 1)
> works!
> However, is it possible to make the parser a little bit more intelligent
> so parentheses are not needed?

This is not our personal choice. The SQL specification requires 
parentheses and I don't think we should relax the syntax.


Dmitry

Hi,
Seems the START WITH clause needs to be between parenthesses, so:

   ALTER TABLE Test ADD IdentityTest INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1)

works!

However, is it possible to make the parser a little bit more intelligent so parentheses are not needed?


Kind regards, 
Robert

From: Robbert-Jan 
Sent: Monday, February 03, 2014 1:50 PM
To: fir...@li... 
Subject: [Firebird-test] Alpha2: adding identity column with START WITHclause gives error

Testing WI-T3.0.0.30809 Firebird 3.0 Alpha 2:

ALTER TABLE Test
ADD IdentityTest
INTEGER
GENERATED BY DEFAULT AS IDENTITY
START WITH 1

error:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 5, column 1
START


Note:
This works okay: ALTER TABLE Test ADD IdentityTest INTEGER GENERATED BY DEFAULT AS IDENTITY
This works also okay: ALTER TABLE Test ALTER IdentityTest RESTART WITH 1

Kind regards,
Robert
- NL



--------------------------------------------------------------------------------
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk 


--------------------------------------------------------------------------------
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Testing WI-T3.0.0.30809 Firebird 3.0 Alpha 2:

ALTER TABLE Test
ADD IdentityTest
INTEGER
GENERATED BY DEFAULT AS IDENTITY
START WITH 1

error:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 5, column 1
START


Note:
This works okay: ALTER TABLE Test ADD IdentityTest INTEGER GENERATED BY DEFAULT AS IDENTITY
This works also okay: ALTER TABLE Test ALTER IdentityTest RESTART WITH 1

Kind regards,
Robert
- NL

Done, CORE-4280 has been created for this issue.

On 23-11-2013 15:51, Robert wrote:
> Hi,
> testing FB 3 (Windows, WI-T3.0.0.30566 Firebird 3.0 Alpha 1), I see that
> currently stored functions may have input arguments with the same name,
> like:
> CREATE FUNCTION Test (X INTEGER, X INTEGER) /* argument X appears twice */
> RETURNS INTEGER
> AS
> BEGIN
>    RETURN X + 1;
> END
> I think this should not be allowed, like it is also not allowed for
> parameters of stored procedures.
> I suggest to define a unique key on rdb$function_arguments for
> (rdb$function_name, rdb$argument_name); note rdb$argument_name is NULL
> for the return argument, but afaik this is okay for unique keys.
> Kind regards, Robert

This sounds like a bug to me, I suggest that you report in the tracker.

Mark
-- 
Mark Rotteveel

On 23-11-2013 15:51, Robbert-Jan wrote:
> Hi,
> testing FB 3 (Windows, WI-T3.0.0.30566 Firebird 3.0 Alpha 1), I see that
> currently stored functions may have input arguments with the same name,
> like:
> CREATE FUNCTION Test (X INTEGER, X INTEGER) /* argument X appears twice */
> RETURNS INTEGER
> AS
> BEGIN
>    RETURN X + 1;
> END
> I think this should not be allowed, like it is also not allowed for
> parameters of stored procedures.
> I suggest to define a unique key on rdb$function_arguments for
> (rdb$function_name, rdb$argument_name); note rdb$argument_name is NULL
> for the return argument, but afaik this is okay for unique keys.
> Kind regards, Robert

This sounds like a bug to me, I suggest that you report in the tracker.

Mark
-- 
Mark Rotteveel

Hi, 
testing FB 3 (Windows, WI-T3.0.0.30566 Firebird 3.0 Alpha 1), I see that currently stored functions may have input arguments with the same name, like:

CREATE FUNCTION Test (X INTEGER, X INTEGER) /* argument X appears twice */
RETURNS INTEGER
AS
BEGIN
  RETURN X + 1;
END

I think this should not be allowed, like it is also not allowed for parameters of stored procedures.
I suggest to define a unique key on rdb$function_arguments for (rdb$function_name, rdb$argument_name); note rdb$argument_name is NULL for the return argument, but afaik this is okay for unique keys.

Kind regards, Robert

Hello!

I got an error with following backtrace:
==================================================
roman:fbt-repository$ PYTHONPATH=~/prj/fbtest/fdb /usr/bin/python
~/prj/fbtest/fbtest/fbtest.py -v -x -b
~/prj/rdb/firebird/gen/firebird/bin/
functional.arno.indices.starting_with_02
functional.arno.indices.starting_with_02 ... ERROR
======================================================================
ERROR: functional.arno.indices.starting_with_02
----------------------------------------------------------------------
Init script
Unexpected stderr stream received from ISQL.

----------------------------------------------------------------------
Ran 1 tests in 0.566s

FAILED (errors=1)
Traceback (most recent call last):
  File "/home/roman/prj/fbtest/fbtest/fbtest.py", line 3167, in <module>
    run_tests()
  File "/home/roman/prj/fbtest/fbtest/fbtest.py", line 2849, in run_tests
    script_runner.run_tests(parser.parse_args())
  File "/home/roman/prj/fbtest/fbtest/fbtest.py", line 2270, in run_tests
    results.save_xunit(os.path.join(os.getcwd(),'results.xml'))
  File "/home/roman/prj/fbtest/fbtest/fbtest.py", line 1806, in save_xunit
    e = result[Result.EXCEPTION]
  File "/home/roman/prj/fbtest/fbtest/fbtest.py", line 1638, in __getitem__
    return self.annotations[key]
KeyError: 'exception'
==================================================

It looks like an error in save_xunit function since it uses
Result.EXCEPTION key but never assign it before.
==========fbtest.py:1805============================

                if result.outcome == Result.ERROR:
                    e = result[Result.EXCEPTION]

==================================================

This result was created by these lines which do not assign Result.EXCEPTION key:
==============fbtest.py:716=========================
                    if stderr:
                        if self.connection_character_set:
                            stderr =
stderr.decode(DB_CHAR_SET_NAME_TO_PYTHON_ENCODING_MAP[self.connection_character_set]).encode('utf-8')

fail_and_annotate_streams(Result.ERROR,'ISQL','Init
script',stderr=stderr)
                        cleanup()
                        return

==================================================

I guess save_xunit could be improved and a possibility to parse other
keys could be added. I.e. we can expect not only EXCEPTION key.

Thought?

-- 
Roman Simakov

Roman Simakov  [2013-10-03 20:05] :
> The same
> 
same ?

Hard to believe or your Python stack is completly broken

The same

2013/10/3 Philippe Makowski <pma...@ib...>:
> Le 03/10/13 15:42, Roman Simakov a écrit :
>> Thanks for the quick reply. I did all your instructions but still see
>> an error of run tests. Full log of my actions you can found here
>> https://www.dropbox.com/s/1d4m7udc0906nka/fbtest_terminal.txt
>>
>> An error is:
>> =========================================
>> roman:prj$ pushd fbt-repository/
>> ~/prj/fbt-repository ~/prj
>> roman:fbt-repository$ sudo chmod 666 ./fdb/*.fdb
>> roman:fbt-repository$ fbt_run
>> Traceback (most recent call last):
>>    File "/usr/local/bin/fbt_run", line 9, in <module>
>>      load_entry_point('fbtest==1.0', 'console_scripts', 'fbt_run')()
>>    File "/pkg_resources.py", line
>> 357, in load_entry_point
>>      return get_distribution(dist).load_entry_point(group, name)
>>    File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
>> 2393, in load_entry_point
>>      raise ImportError("Entry point %r not found" % ((group,name),))
>> ImportError: Entry point ('console_scripts', 'fbt_run') not found
>> roman:fbt-repository$
>> =========================================
>>
> ok so copy fbtest.py into /usr/local/lib/python2.7/dist-packages
>
> instead of :
> $ sudo cp -f fbtest.py /usr/lib/python2.7/dist-packages/fbtest.py
>
> do
>
> $ sudo cp -f fbtest.py /usr/local/lib/python2.7/dist-packages/fbtest.py
>
>
> I really don't like Ubuntu :(
>
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test



-- 
Roman Simakov

Le 03/10/13 15:42, Roman Simakov a écrit :
> Thanks for the quick reply. I did all your instructions but still see
> an error of run tests. Full log of my actions you can found here
> https://www.dropbox.com/s/1d4m7udc0906nka/fbtest_terminal.txt
>
> An error is:
> =========================================
> roman:prj$ pushd fbt-repository/
> ~/prj/fbt-repository ~/prj
> roman:fbt-repository$ sudo chmod 666 ./fdb/*.fdb
> roman:fbt-repository$ fbt_run
> Traceback (most recent call last):
>    File "/usr/local/bin/fbt_run", line 9, in <module>
>      load_entry_point('fbtest==1.0', 'console_scripts', 'fbt_run')()
>    File "/pkg_resources.py", line
> 357, in load_entry_point
>      return get_distribution(dist).load_entry_point(group, name)
>    File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
> 2393, in load_entry_point
>      raise ImportError("Entry point %r not found" % ((group,name),))
> ImportError: Entry point ('console_scripts', 'fbt_run') not found
> roman:fbt-repository$
> =========================================
>
ok so copy fbtest.py into /usr/local/lib/python2.7/dist-packages

instead of :
$ sudo cp -f fbtest.py /usr/lib/python2.7/dist-packages/fbtest.py

do

$ sudo cp -f fbtest.py /usr/local/lib/python2.7/dist-packages/fbtest.py


I really don't like Ubuntu :(

Thanks for the quick reply. I did all your instructions but still see
an error of run tests. Full log of my actions you can found here
https://www.dropbox.com/s/1d4m7udc0906nka/fbtest_terminal.txt

An error is:
=========================================
roman:prj$ pushd fbt-repository/
~/prj/fbt-repository ~/prj
roman:fbt-repository$ sudo chmod 666 ./fdb/*.fdb
roman:fbt-repository$ fbt_run
Traceback (most recent call last):
  File "/usr/local/bin/fbt_run", line 9, in <module>
    load_entry_point('fbtest==1.0', 'console_scripts', 'fbt_run')()
  File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
357, in load_entry_point
    return get_distribution(dist).load_entry_point(group, name)
  File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
2393, in load_entry_point
    raise ImportError("Entry point %r not found" % ((group,name),))
ImportError: Entry point ('console_scripts', 'fbt_run') not found
roman:fbt-repository$
=========================================

2013/10/3 Philippe Makowski <pma...@ib...>:
> Le 03/10/13 13:14, Roman Simakov a écrit :
>> Hello!
>>
>> I'm trying to run fbtest on my Ubuntu 13.04 x86_64. I have some
>> problems and I rely on your help.
>>
> be sure you have python-setuptools
> sudo apt-get install python-setuptools
>
> the automated build box (http://ci.ibphoenix.fr) do it mostly like that :
>
>
> # co python driver for firebird
> svn co svn://svn.code.sf.net/p/firebird/code/python/fdb/trunk fdb
> # install
> pushd fdb
> sudo python setup.py install
> popd
>
> # co fbtest
> svn://svn.code.sf.net/p/firebird/code/qa/fbtest/trunk qa
> # install tbtest
> pushd qa
> sudo python setup.py install
> # we need this because setup.py is not correct
> sudo cp -f fbtest.py /usr/lib/python2.7/dist-packages/fbtest.py
> #
> popd
>
> # co fbt-repository
> svn co svn://svn.code.sf.net/p/firebird/code/qa/fbt-repository/trunk
> fbt-repository
>
> pushd fbt-repository
> sudo chmod 666 ./fdb/*.fdb
>
>
> fbt_run ...
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test



-- 
Roman Simakov

Le 03/10/13 13:14, Roman Simakov a écrit :
> Hello!
>
> I'm trying to run fbtest on my Ubuntu 13.04 x86_64. I have some
> problems and I rely on your help.
>
be sure you have python-setuptools
sudo apt-get install python-setuptools

the automated build box (http://ci.ibphoenix.fr) do it mostly like that :


# co python driver for firebird
svn co svn://svn.code.sf.net/p/firebird/code/python/fdb/trunk fdb
# install
pushd fdb
sudo python setup.py install
popd

# co fbtest
svn://svn.code.sf.net/p/firebird/code/qa/fbtest/trunk qa
# install tbtest
pushd qa
sudo python setup.py install
# we need this because setup.py is not correct
sudo cp -f fbtest.py /usr/lib/python2.7/dist-packages/fbtest.py
#
popd

# co fbt-repository
svn co svn://svn.code.sf.net/p/firebird/code/qa/fbt-repository/trunk 
fbt-repository

pushd fbt-repository
sudo chmod 666 ./fdb/*.fdb


fbt_run ...

Hello!

I'm trying to run fbtest on my Ubuntu 13.04 x86_64. I have some
problems and I rely on your help.

1) I cannot install fbtest via pip
===========================================
roman:fbtest_repo$ sudo pip install fbtest
Downloading/unpacking fbtest
  Running setup.py egg_info for package fbtest
    /usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'entry_points'
      warnings.warn(msg)
    /usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'use_2to3'
      warnings.warn(msg)
    /usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'include_package_data'
      warnings.warn(msg)
    /usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'zip_safe'
      warnings.warn(msg)
    /usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'test_suite'
      warnings.warn(msg)
    /usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'install_requires'
      warnings.warn(msg)
    usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
       or: -c --help [cmd1 cmd2 ...]
       or: -c --help-commands
       or: -c cmd --help

    error: invalid command 'egg_info'
    Complete output from command python setup.py egg_info:
    /usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'entry_points'

  warnings.warn(msg)

/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'use_2to3'

  warnings.warn(msg)

/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'include_package_data'

  warnings.warn(msg)

/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'zip_safe'

  warnings.warn(msg)

/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'test_suite'

  warnings.warn(msg)

/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'install_requires'

  warnings.warn(msg)

usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]

   or: -c --help [cmd1 cmd2 ...]

   or: -c --help-commands

   or: -c cmd --help



error: invalid command 'egg_info'

----------------------------------------
Command python setup.py egg_info failed with error code 1 in
/tmp/pip-build-root/fbtest
Storing complete log in /home/roman/.pip/pip.log

===========================================
I checked it out from
svn co http://svn.code.sf.net/p/firebird/code/qa/fbtest/trunk/ fbtest
then install manually like this
===========================================
roman:fbtest$ sudo python setup.py install
/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'entry_points'
  warnings.warn(msg)
/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'use_2to3'
  warnings.warn(msg)
/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'include_package_data'
  warnings.warn(msg)
/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'zip_safe'
  warnings.warn(msg)
/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'test_suite'
  warnings.warn(msg)
/usr/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown
distribution option: 'install_requires'
  warnings.warn(msg)
running install
running build
running install_egg_info
Writing /usr/local/lib/python2.7/dist-packages/fbtest-1.0.egg-info
===========================================

2) Cannot update test repository
=============================================
roman:fbtest_repo$ fbt_update repository
Traceback (most recent call last):
  File "/usr/local/bin/fbt_update", line 9, in <module>
    load_entry_point('fbtest==1.0', 'console_scripts', 'fbt_update')()
  File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
357, in load_entry_point
    return get_distribution(dist).load_entry_point(group, name)
  File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
2393, in load_entry_point
    raise ImportError("Entry point %r not found" % ((group,name),))
ImportError: Entry point ('console_scripts', 'fbt_update') not found
================================================

I did it manually

=================================================
roman:prj$ svn co
http://svn.code.sf.net/p/firebird/code/qa/fbt-repository/trunk/
fbtest_repo
A    fbtest_repo/fbk
A    fbtest_repo/fbk/core1006.fbk
...
A    fbtest_repo/fdb/core870.fdb
A    fbtest_repo/fdb/core1331.fdb
Получена редакция 58685.
===============================================

3) Cannot run tests.
=================================================
roman:prj$ fbt_run
Traceback (most recent call last):
  File "/usr/local/bin/fbt_run", line 9, in <module>
    load_entry_point('fbtest==1.0', 'console_scripts', 'fbt_run')()
  File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
357, in load_entry_point
    return get_distribution(dist).load_entry_point(group, name)
  File "/usr/local/lib/python2.7/dist-packages/pkg_resources.py", line
2393, in load_entry_point
    raise ImportError("Entry point %r not found" % ((group,name),))
ImportError: Entry point ('console_scripts', 'fbt_run') not found
=============================================

I'm not so familar with python so sorry if it can be fixed trivially.

Thanks.

-- 
Roman Simakov

Hi,

Testing WI-T3.0.0.30566 Firebird 3.0 Alpha 1 on Windows XP.

An uncommitted select of the new pseudo table sec$users (CORE-2639) seems to block new database connections.

Test situation:

session 1:

connect to test database
start transaction
select * from sec$users
(do *not* commit)

session 2:

connect to test database => results in sql error –902; engine code 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login.


I have tested this with FlameRobin using all isolation modes for the transaction in session 1 (concurrency, dirty read, read committed and consistency) and the error occurs in all circumstances.

The error can easily be avoided using short running transaction, but if the error occurs it can be confusing (it says ‘user name and password’ not set up, what actually is not the case).

I’m new in testing and tracking. Should I post an issue in Jira?

Kind regard,
Robert
NL

Thank you, Vlad,

this does the trick...

Have a nice weekend, Thomas

> x-prefixed literals have charset OCTETS and it could be a reason for such issues.
> 
> Try to use charset introducer before literal, for example:
> 
>   _win1252 x'20'

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 545 • Fax +49 (04 51) 399 04 - 604
Mail tho...@as... <mailto:tho...@as...>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
in...@as... <mailto:in...@as...> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.

here is the full text of the procedure:

CREATE OR ALTER PROCEDURE SPDUMPCONFIG
AS
DECLARE VARIABLE MASTER VARCHAR(15);
DECLARE VARIABLE SELF VARCHAR(15);
BEGIN
SELECT MASTER, SELF FROM CONFIG INTO :MASTER, :SELF;
EXECUTE STATEMENT '
EXECUTE BLOCK
AS
DECLARE VARIABLE MASTER VARCHAR(15);
DECLARE VARIABLE SELF VARCHAR(15);
DECLARE VARIABLE ID_NPRICE BIGINT;
DECLARE VARIABLE EXCHANGE VARCHAR(127);
DECLARE VARIABLE TEMP VARCHAR(127);
DECLARE VARIABLE DISCOUNT_DATE D_DATETIME;
DECLARE VARIABLE PRICE_DATE D_DATETIME;
DECLARE VARIABLE PINPAD D_BOOLEAN;
DECLARE VARIABLE REPLENISHMENT D_BOOLEAN;
DECLARE VARIABLE FILEVERSION VARCHAR(15);
DECLARE VARIABLE FRPRINTSRV VARCHAR(15);
DECLARE VARIABLE CARDS_DATE D_DATETIME;
DECLARE VARIABLE KKM_NUMBER VARCHAR(10);
DECLARE VARIABLE FONT_INCREASE INTEGER;
BEGIN
FOR
EXECUTE STATEMENT ''
SELECT MASTER,SELF,ID_NPRICE,EXCHANGE,TEMP,DISCOUNT_DATE,PRICE_DATE,PINPAD,REPLENISHMENT,FILEVERSION,FRPRINTSRV,CARDS_DATE,KKM_NUMBER,0 FONT_INCREASE
FROM CONFIG ''
ON EXTERNAL DATA SOURCE '''|| :SELF || '''||''/3050:PMRMK''
WITH COMMON TRANSACTION
AS USER ''SYSDBA'' PASSWORD ''masterkey''
INTO :MASTER,:SELF,:ID_NPRICE,:EXCHANGE,:TEMP,:DISCOUNT_DATE,:PRICE_DATE,:PINPAD,:REPLENISHMENT,:FILEVERSION,:FRPRINTSRV,:CARDS_DATE,:KKM_NUMBER,:FONT_INCREASE
DO
BEGIN
UPDATE OR INSERT INTO CONFIG(MASTER,SELF,ID_NPRICE,EXCHANGE,TEMP,DISCOUNT_DATE,PRICE_DATE,PINPAD,REPLENISHMENT,FILEVERSION,FRPRINTSRV,CARDS_DATE,KKM_NUMBER,FONT_INCREASE)
VALUES(:MASTER,:SELF,:ID_NPRICE,:EXCHANGE,:TEMP,:DISCOUNT_DATE,:PRICE_DATE,:PINPAD,:REPLENISHMENT,:FILEVERSION,:FRPRINTSRV,:CARDS_DATE,:KKM_NUMBER,:FONT_INCREASE)
MATCHING(SELF);
SUSPEND;
END
END '
ON EXTERNAL DATA SOURCE :MASTER||'/3050:ACCEPTANCE'
WITH COMMON TRANSACTION
AS USER 'SYSDBA' PASSWORD 'masterkey';
WHEN ANY DO EXIT;
END
but I can not yet provide a memory dump or call stack trace

Четверг, 23 мая 2013, 9:03 UTC от "Vlad Khorsun (JIRA)" <tr...@fi...>:
>
>    [  http://tracker.firebirdsql.org/browse/CORE-4104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=26758#action_26758 ] 
>
>Vlad Khorsun commented on CORE-4104:
>------------------------------------
>
>Please, provide full reproducible example.
>Also, it would be useful to have memory dump or call stack trace of crashed process.
>
>> crash external firebird server is often to run a script containing a statement "update or insert"
>> -------------------------------------------------------------------------------------------------
>>
>>                 Key: CORE-4104
>>                 URL:  http://tracker.firebirdsql.org/browse/CORE-4104
>>             Project: Firebird Core
>>          Issue Type: Bug
>>          Components: Engine
>>    Affects Versions: 2.5.2
>>         Environment: Linux Ubuntu 10.04, Firebird 2.5.2 (Linux), windows application over WINE(Windows XP mode)
>>            Reporter: Otinov Andrey
>>
>> CREATE OR ALTER PROCEDURE SPDUMPCONFIG
>> AS
>> DECLARE VARIABLE MASTER VARCHAR(15);
>> DECLARE VARIABLE SELF VARCHAR(15);
>> BEGIN
>>   SELECT MASTER, SELF FROM CONFIG INTO :MASTER, :SELF;
>>   EXECUTE STATEMENT '
>> EXECUTE BLOCK
>> AS
>> DECLARE VARIABLE MASTER VARCHAR(15);
>> DECLARE VARIABLE SELF VARCHAR(15);
>> ...
>> BEGIN
>>   FOR
>>     EXECUTE STATEMENT ''
>>     SELECT MASTER,SELF...
>>     FROM CONFIG ''
>>   ON EXTERNAL DATA SOURCE '''|| :SELF || '''||''/3050:PMRMK''
>>   WITH COMMON TRANSACTION
>>   AS USER ''SYSDBA'' PASSWORD ''masterkey''
>>   INTO MASTER,:SELF...  DO
>>   BEGIN
>>     UPDATE OR INSERT INTO CONFIG(MASTER,SELF...)
>>  VALUES(:MASTER,:SELF...)
>>     MATCHING(SELF);
>>     SUSPEND;
>>   END
>> END '
>>   ON EXTERNAL DATA SOURCE :MASTER||'/3050:ACCEPTANCE'
>>   WITH COMMON TRANSACTION
>>   AS USER 'SYSDBA' PASSWORD 'masterkey';
>>   WHEN ANY DO EXIT;
>> END
>
>-- 
>This message is automatically generated by JIRA.
>-
>If you think it was sent incorrectly contact one of the administrators:  http://tracker.firebirdsql.org/secure/Administrators.jspa
>-
>For more information on JIRA, see:  http://www.atlassian.com/software/jira
>
>