[Firebird-devel] [FB-Tracker] Created: (CORE-3927) Restore's hung for big database.
Restore's hung for big database. Key: CORE-3927 URL: http://tracker.firebirdsql.org/browse/CORE-3927 Project: Firebird Core Issue Type: Bug Components: GBAK Affects Versions: 2.5.0 Environment: Firebird CS 2.5.1 x86, Firebird SS 2.5.2.26538 x64, Windows2008 x86, Windows 2008R2 x64 Reporter: Viktor Belzetskiy Attachments: db_hang.7z The DB volume is about 2 bln records, 1800 tables with 5400 indexes. Restore's hung is happening while "gbak.exe -r -user SYSDBA -pass masterkey -p..." executing if the key (-o "restore one table at a time") is not used. We made a number of tries and found out that restore's hung is not depends on: - Firefird's architecture - Database page size - Windows architecture (x64, x86) - Protocol (INET, XNET, service_mgr) For same bug's playback you should act according to following sequence: 1. Decompressing db_hang.7z. 2. Execute script from file db_script.sql (execute time* ~16h, final database size ~600Г, 7575522329 records) 3. Run Backup database "gbak -b..." (execute time* 6h, size fbk ~400Г) 4. Run Restore "gbak -r..." without key -o "restore one table at a time". In our case the hung took place on 330 Gb file for "TEMP_TBL_1087"-table (gbak: 17611 records restored), after about 3 hours* of Restore's executing. * The executing time is specified for my hardware -- 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 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3928) UNICODE_CI_AI: SELECT
UNICODE_CI_AI: SELECT - Key: CORE-3928 URL: http://tracker.firebirdsql.org/browse/CORE-3928 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Affects Versions: 2.5.1, 2.5.2 Environment: Windows 7 64 bit Reporter: Pablo León In a field with UNICODE_CI_AI collation, the following sentence is case insensitive, witch IMHO is wrong behavior: select * from table where ci_ai_field collate UNICODE = 'c' furthermore, the following sentence is case sensitive (as expected): select * from table where ci_ai_field collate UNICODE like 'c' -- 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 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3925) Creating self-referential FK crashes database (bug-check) whether constraint violation had place
Ng, > -Original Message- > From: ng [mailto:nazimon...@gmail.com] > Sent: Tuesday, September 18, 2012 4:24 PM > To: 'For discussion among Firebird Developers' > Subject: Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3925) Creating self- > referential FK crashes database (bug-check) whether constraint violation had > place > > hello > > we are using anonymous database triggers > > with the login / logout 1000 usersfbserver memory is increasing to > aproximately 1476-1536K . > > > CREATE OR ALTER trigger DB_login_LOG > active on connect position 0 > as > declare variable ClAdr varchar(100); > declare variable ClPrg varchar(100); > declare variable SPrsId integer; > declare variable CPrsId integer; > begin > SELECT > MON$REMOTE_ADDRESS,mon$remote_process,mon$server_pid,d.mon$re > mote_pid > FROM MON$ATTACHMENTS D > WHERE mon$ATTACHMENT_ID = current_connection >Into :cladr, :clprg, :cprsid , :cprsid; > > -- insert into xx_xuserlog ... > -- values ( current_connection,current_timestamp, . > when any do exit; What does this have to do with the email subject. Do not hijack message threads. Please post a fresh message for a new subject/thread? Sean -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3929) Error "attempted update of read-only column" when trying select minvalue from list with more than 255 elements
Error "attempted update of read-only column" when trying select minvalue from list with more than 255 elements -- Key: CORE-3929 URL: http://tracker.firebirdsql.org/browse/CORE-3929 Project: Firebird Core Issue Type: Bug Reporter: Pavel Zotov Priority: Minor select minvalue( 1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- 50 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- 100 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- 150 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- 200 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 -- 250 ,1 ,1 ,1 ,1 ,1 -- this is the last element (255th) where result is OK ,1 -- adding this element leads to strange error message about UPDATING ) from rdb$database; Statement failed, SQLSTATE = 42000 attempted update of read-only column After line 0 in file minval.sql -- 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 -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://ad.doubleclick.net/clk;258768047;13503038;j? http://info.appdynamics.com/FreeJavaPerformanceDownload.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel