Re: [Firebird-devel] Inconsistency between TimeZoneUtil::MAX_LEN and definition of RDB$TIME_ZONES.RDB$TIME_ZONE_NAME
On 13-2-2019 00:26, Adriano dos Santos Fernandes wrote: On 02/02/2019 12:09, Mark Rotteveel wrote: In the Firebird sources, TimeZoneUtil::MAX_LEN is defined as 32, however the column RDB$TIME_ZONES.RDB$TIME_ZONE_NAME is defined as CHAR(63). There currently is one time zone name with length 32 (the rest is shorter), so right now there is no problem, however this inconsistency between definitions seems like an accident waiting to happen if in the future a zone is added with a length longer than 32. Could this be fixed so they both use the same length (I'd suggest 63)? Then ISQL will also use it and will make it difficult to work there with each time zone name taking so much space. You already have that when selecting from the RDB$TIME_ZONES table though. But more importantly, what will happen if a zone with a longer name is introduced in the future? Will things break (or worse, cause overflow)? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] What is the cause for isc_login_changed errror?
Sorry, can you explain better. I wonder what configuration caused an error. Wrong order of authentication methods for client and server, along with WireCrypt parameters. We would detect that earlier if some sneaky weasel would not play with the config behind our back. regards Pavel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] What is the cause for isc_login_changed errror?
On 2/13/19 6:11 PM, Pavel Cisar wrote: Alex, problem solved, it was a configuration issue after all. Sorry for false alarm. Sorry, can you explain better. I wonder what configuration caused an error. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] What is the cause for isc_login_changed errror?
Alex, problem solved, it was a configuration issue after all. Sorry for false alarm. regards Pavel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] What is the cause for isc_login_changed errror?
On 2/13/19 12:10 PM, Pavel Cisar wrote: Hi all, could anyone explain me what may cause the isc_login_changed error in FB 3 for non-sysdba users? (login works ok for sysdba) It's raised in server.cpp: ServerAuth->accept() That can be a sign of attack on server or bug in FB software. What is the client? If it's out standard fbclient please provide configuration info, login name and for what plugins is it present in user's list. If something else - contract client author please. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Latest OLTP results
If someone is interested. Newest results on recent snapshots. 60 minutes test. FB3 SuperServer is the best always. I have repeated test 3 times and near same results. Because of that i use lastest results. Now i know why DB size have so big difference. E.g. FB25 SuperClassic 370561 times vs FB3 SS 840318. Two Times bigger result. But overall records in resulted databases are 34 705 188 vs 129 473 418. This is near 4 times bigger count! FB3 for me is a leader in all tests. FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE SuperServer 3.0.5 P:\DB\OLTP3.FDB ON 2 262144 8192 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 60 minutes: 14005.30 5365 840318 2019-02-11 21:21 2019-02-11 22:21 FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE Classic 2.5.9 P:\DB\OLTP2.FDB ON 2 12288 8192 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 60 minutes: 1164.40 48244 69864 2019-02-12 18:41 2019-02-12 19:41 FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE SuperClassic 2.5.9 P:\DB\OLTP2.FDB ON 2 12288 8192 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 60 minutes: 6176.02 16168 370561 2019-02-12 21:35 2019-02-12 22:35 FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE SuperServer 2.5.9 P:\DB\OLTP2.FDB ON 2 262144 8192 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 60 minutes: 1263.35 46980 75801 2019-02-13 00:07 2019-02-13 01:07 Regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] What is the cause for isc_login_changed errror?
Hi all, could anyone explain me what may cause the isc_login_changed error in FB 3 for non-sysdba users? (login works ok for sysdba) It's raised in server.cpp: ServerAuth->accept() best regards Pavel Cisar Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel