Hi,
Well, I have discovered that 3.0 Linux installation script doesn't
install FB as server, so without host specification it works as embedded
(that was new for me), so all reported issues were for embedded (Linux
64-bit). Now I have report also for server. Note, that all reported
issues are regressions.
Dne 1.7.2013 15:33, Dmitry Yemanov napsal(a):
> 01.07.2013 17:14, Pavel Cisar wrote:
>>
>> 1. cursor.rowcount (isc_dsql_sql_info with isc_info_sql_records) returns
>> 1 instead expected 6
>>
>> cur.execute('select * from project')
>> self.assertEqual(cur.rowcount,0)
>> cur.fetchone()
>> self.assertEqual(cur.rowcount,6) <--
>
> Correct for embedded connections (no record prefetch), incorrect for
> remote connections (including localhost).
Confirmed, test adapted.
>> 2. MON$ATTACHMENTS. Next columns are NULL: MON$REMOTE_PROTOCOL,
>> mon$remote_address, mon$remote_pid, mon$remote_process.
>
> Correct for embedded connections (no network layer involved), incorrect
> for remote connections (including localhost).
Confirmed, test adapted.
>> 3. Unexpected RDB$VALID_BLR = True on stored procedure in database
>> restored by v3.0
>
> Why is it unexpected?
Sorry, my bad. True is of course correct. I was misguided because FB <
3.0 returns NONE.
>> 4. Can't get list of users via services API. Returns:
>>
>> Unable to perform the requested Service API action:
>> - SQLCODE: -901
>> - unrecognized service parameter block
>> - All services except for getting server log require switches'
>>
>> -901
>> 335544562
>>
>> BTW, Flamerobin fails with the same error on attempt to get list of
>> users from server.
Also fails with localhost. I suppose it's a bug.
>> 5. Call to isc_service_query with isc_info_svc_running raises error:
>>
>> Services/isc_service_query:
>> - SQLCODE: -901
>> - invalid service handle'
>>
>> -901
>> 335544559
>>
>> Service handle is valid. This call fails ONLY before some actions are
>> requested (via isc_service_start),
>> for example isc_action_svc_get_ib_log. Once any service is started,
>> isc_service_query starts to work properly.
>
> Sounds like a bug.
Indeed. Result from localhost could give you a hint, as it fails with
other error:
Services/isc_service_query:
- SQLCODE: -902
- Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
- No auth of running service
6. Working with limbo transactions (real ones, test using DT carefully
crafted, works in FB < 3.0) causes problems, needs further investigations.
Asking for limbo id succeeds for first database, but fails when asking
for second ones.
ids2 = svc.get_limbo_transaction_ids(self.db2) ->
Exception: OperationalError: ('Unable to perform the requested Service
API action:\n- SQLCODE: -902\n- Your user name and password are not
defined. Ask your database administrator to set up a Firebird login.\n-
Client error - database name does not match', -902, 335544472)
7. With localhost (embedded is fine), tests test_restore and
test_nrestore fail with:
Unable to perform the requested Service API action:
- SQLCODE: -902
- Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
- Client error - database name does not match
-902
335544472
best regards
Pavel Cisar
IBPhoenix
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
